Part $3$ Creating the Indifference Table

Working in cells G$20$:O$42,$ you will create an indifference table that will help you to determine which of your five plans is

most optimal at a given probability.

$$ In the merged cell of G$20$:$21,$ type $$Indifference Point$.$

o Starting in cell G$23,$ list your indifference points in the Yellow Cells in ascending order. You calculated

the indifference points in Part $2.$ Your last indifference point will be placed in cell G$41.$

$$ In the merged cell of H$20$:$21,$ type $$Test Point$.$

o Starting in cell H$22,$ list your test points in the white cells. Your last test point will be placed in cell H$42.$

$$ In the merged cell of I$20$:M$20,$ type $$Plan Name$$

o In cell I$21,$ type $$Quad$.$

o In cell J$21,$ type $$Double$.$

o In cell K$21,$ type $$Super Single$.$

o In cell L$21,$ type $$Single$.$

o In cell M$21,$ type $$Scholar$.$

$$ In the merged cell of N$20$:$21,$ type $$Maximum$$

$$ In the merged cell of O$20$:$21,$ type $$Optimal Plan$$

Now that the indifference table has the correct heading and test points have been selected, you now must fill in the

chart.

$$ In cell I$22,$ type the formula, $=$$C$$3+$$E$$3*$H$22.$

$$ In cell J$22,$ type the formula, $=$$C$$4+$$E$$4*$H$22.$

$$ In cell K$22,$ type the formula, $=$$C$$5+$$E$$5*$H$22.$

$$ In cell L$22,$ type the formula, $=$$C$$6+$$E$$6*$H$22.$

$$ In cell M$22,$ type the formula, $=$$C$$7+$$E$$7*$H$22.$

$$ In cell N$22,$ type the formula $=$MAX$($I$22$:M$22).$

$$ In cell O$22,$ type the formula

$=$IF$($I$22=$N$22,$I$$21,$IF$($J$22=$N$22,$J$$21,$IF$($K$22=$N$22,$K$$21,$IF$($L$22=$N$22,$L$$21,$IF$($M$22=$N$22,$M$$21,"$Uh$-$Oh$"))))).$

$$ Format cells I$22$ thru N$22$ as $$Currency$$ with no decimal place

$$ Copy cells I$22$ to O$22$ to each of the white rows $($rows $24,26,28,...,42)$ in the indifference table while preserving

the formatting of the table.

o You can adjust the column widths to better display the numbers in the table if you desire.