Flexible Insurance Coverage

Parameters

Premium Data

Hint: Formulas in the costs section begin with $"=$Min"

Check:

$B16=500,E17=500$

$C18=100,G15=1800$

$B16=500$

$E17=500$

C$18=100$

$G15=1800$

Best Plan

#N$/$A

Hint: Cells B$22$:B$25$ begin with $"=$Choose"

Check: Cell C$26=6604$

min

Best Plan $=2$