13 14 Cost per ad 160 100 80 9 13 15 8 85 model appropriately and reoptimize (with integer constraints on the 15 Cost per million exposures 6,400 5,882 6,154 6,000 6,842 6,000 6,667 5,667 number of ads). Finally, run solvertable to see how sensitive the 16 17 Advertising plan optimal solution is to the maximum number of ads per show allowed.
32 1 $100 000 33 2 34 3 35 4 36 5 37 38 Final cash Objective to maximize: final cash at beginning of year 5 39 40 Max ever in cash Output cell for SolverTable 41 42 43 44 For any reasonable money market rate -- from 1% to 8% -- the 45 SolverTable output shows that the maximum ever put into the 46 money market remains the same, at $87,500. 47
annaabi.ee 
