(Solved) : Please Answer Cell Change Put Solver Incorporate Five Changes Noted Solve Problem Done Non Q43908759 . . .
Pleaseanswer which cell I have to change and what to put on solver.
Incorporate the five changes noted below and solve theproblem only after you have done so! None of the changes notedbelow impact the cells in Rows 18, 19, or 20. I have not providedany hints, however, this Case study requires some of the samestrategies we used to solve the Excel Exercise.
1. (16 Points) Tom now wants to run full-page ads in both majornewspapers for at least two weeks leading up to the vote. NOTE:this changes the minimum value in two cells in Column C as we areassuming this applies to both daily and Sunday newspapers.
2. (16 Points) Tom is scaling back his daytime televisionadvertising strategy which will now consist of running at least twobut no more than four spots per week for the four weeks leading upto the vote.
3. (16 Points) Tom wants to derive at least 10% of his totaladvertising impact from evening television advertisements.
4. (16 Points) Tom has decided he is willing to run a maximum of6, 15-second radio spots per day for the 28 days leading up to thevote and a maximum of 7, 30-second spots per day over the sameperiod of time. However, he wants to ensure the totalimpact derived from radio does not exceed 65% of the totalimpact.
5. (16 Points) With his increase in radio spots, Tom plans touse the majority of these new spots in the Orlando, Tampa, andMiami markets thus he feels the billboards in these cities are nolonger required for advertisement. However, because Tom feels thereis 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 Show transcribed image text 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
Expert Answer
Answer to Please answer which cell I have to change and what to put on solver. Incorporate the five changes noted below and solve …
OR