Please answer which cell I have to change and what to put on solver.

Incorporate the five changes noted below and solve the problem only after you have done so! None of the changes noted below impact the cells in Rows 18, 19, or 20. I have not provided any hints, however, this Case study requires some of the same strategies we used to solve the Excel Exercise.

1. (16 Points) Tom now wants to run full-page ads in both major newspapers for at least two weeks leading up to the vote. NOTE: this changes the minimum value in two cells in Column C as we are assuming this applies to both daily and Sunday newspapers.

2. (16 Points) Tom is scaling back his daytime television advertising strategy which will now consist of running at least two but no more than four spots per week for the four weeks leading up to the vote.

3. (16 Points) Tom wants to derive at least 10% of his total advertising impact from evening television advertisements.

4. (16 Points) Tom has decided he is willing to run a maximum of 6, 15-second radio spots per day for the 28 days leading up to the vote and a maximum of 7, 30-second spots per day over the same period of time. However, he wants to ensure the total impact derived from radio does not exceed 65% of the total impact.

5. (16 Points) With his increase in radio spots, Tom plans to use the majority of these new spots in the Orlando, Tampa, and Miami markets thus he feels the billboards in these cities are no longer required for advertisement. However, because Tom feels there is value in billboard advertising, he wants to derive at least 1% of his total impact from billboards.

AutoSave Of H br gl B - case1 - Excel File Home Insert Draw Page Layout Formulas Data Review View Help X Cut Arial 10 AA === Wrap Text Ge LG Copy Paste BIU - Eva A Format Painter El Merge & Center v $ Clipboard Font Alignment G30 : * fx A B C D E | F | G H | Friends of the Manatees N 75 15 NON 80 85 Impact Cost 5 Advertising Medium | Units Min Max Per Unit Total Per Unit Total 6 Half-page, Daily paper 48 55 2,530 $800 $36,800 7 Full-page, Daily paper 2 48 150 $1,400 $2,800 8 Half-page, Sunday paper 65 390 $1,200 $7,200 9 Full-page, Sunday paper 160 $1,800 $3,600 10 Daytime TV spot 2,513 $2,500 $73,900 11 Evening TV spot 28 28 56 100 2,800 $3,500 $98,000 12 Highway Billboards 103 1035 350 $750 $7,500 13 15 second Radio spot 14056 140 45 6,300 $150 $21,000 14 30 second Radio spot 140 56 140 55 7,700 $300 $42,000 15 Half-page, magazine 90 12 50 450 $500 $4,500 16 Full-page, magazine 3 3 12 60 180 $900 $2,700 17 Key Totals: 0 Min Max Total: 23,523 Total: $300,000 18 Daily paper ads 48 24 48 Budget: $300,000 19 Sunday paper ads 8 28 20 Magazine ads 123 12 21 AutoSave Of H br gl B - case1 - Excel File Home Insert Draw Page Layout Formulas Data Review View Help X Cut Arial 10 AA === Wrap Text Ge LG Copy Paste BIU - Eva A Format Painter El Merge & Center v $ Clipboard Font Alignment G30 : * fx A B C D E | F | G H | Friends of the Manatees N 75 15 NON 80 85 Impact Cost 5 Advertising Medium | Units Min Max Per Unit Total Per Unit Total 6 Half-page, Daily paper 48 55 2,530 $800 $36,800 7 Full-page, Daily paper 2 48 150 $1,400 $2,800 8 Half-page, Sunday paper 65 390 $1,200 $7,200 9 Full-page, Sunday paper 160 $1,800 $3,600 10 Daytime TV spot 2,513 $2,500 $73,900 11 Evening TV spot 28 28 56 100 2,800 $3,500 $98,000 12 Highway Billboards 103 1035 350 $750 $7,500 13 15 second Radio spot 14056 140 45 6,300 $150 $21,000 14 30 second Radio spot 140 56 140 55 7,700 $300 $42,000 15 Half-page, magazine 90 12 50 450 $500 $4,500 16 Full-page, magazine 3 3 12 60 180 $900 $2,700 17 Key Totals: 0 Min Max Total: 23,523 Total: $300,000 18 Daily paper ads 48 24 48 Budget: $300,000 19 Sunday paper ads 8 28 20 Magazine ads 123 12 21