Reverse engineer prices in an Insurance Plan

[DRSteele]

Can some math genius please help me?

I wish to reckon the base prices for extended healthcare plan. There are three classes in the plans: Health, Dental and Prescriptions.

Each of those three classes has three available variables: A, B and C. ​

By clicking through the co's website, I was able to come up with the various prices for all possible permutations of the various plans. [It only takes seven prices to compute the changes between the plans, so I didn't click through all 3^3=27 of them.]

So we know the total prices for each of the 3^3=27 permutations. I wish to know the prices for each of the base plans (i.e., H-A, D-A, P-A)

​

Once those are known the rest falls into place. Right? or am I missing something? I tried matrix algebra and I became sorely vexed.


Here is the data. I hope to be able to fill out all the purple stuff.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Book1
	A	B	C	D	E	F	G	H
5	Plan	Health	Dental	Prescriptions	Comment	Parameters
6	A
7	B
8	C
9
10	Selected	Health	Dental	Prescriptions	Health	Dental	Prescriptions	Price
11		A	A	A				69.50
12		A	A	B				71.90
13		A	B	A				80.90
14		A	B	B				83.30
15		B	B	B				102.40
16		B	A	B				91.00
17		B	B	A				100.00
18		B	A	A				88.60
19		B	B	C				118.90
20		B	C	B				132.80
21		B	C	C				149.30
22		C	B	B				114.90
23		C	B	C				131.40
24		C	C	B				145.30
25		C	C	C				161.80
26		A	A	C				88.40
27		A	B	C				99.80
28		A	C	B				113.70
29		A	C	C				130.20
30		B	A	C				107.50
31		B	C	A				130.40
32		B	C	C				149.30
33		C	A	B				103.50
34		C	B	A				112.50
35		C	A	A				101.10
36		C	B	B				114.90
37		C	C	A				142.90
Sheet2

[/FONT]

 

[DRSteele]

I see in the InsurCo's website that certain plans partially funds psychiatric help, which I'm sure to need the more I try to suss out their price schedule.

 

[Worf]

Worf's LP model does not make sense.

If you care to explain.

 

[shg]

I'm recovering from major surgery, and my attention span has been limited.

Your solutions (to a very different problem) are "sexy", to say the least. I'm sure they appeal to people who like complicated one-solution-fits-all implementations.

I hope the recovery is going well. I learned after hip surgery a few years ago that opiates can have some unpleasant side effects. Sounds like you need to ease off the pain meds and double up on the macrogol.

 

[joeu2004]

Sounds like you need to ease off the pain meds and double up on the macrogol.

ROTFLOL!! One of the best sophomoric responses I've seen! Maybe you should run for US President. That seems to be the only ability that's required these days.