Question: The Slick-Willie ad agency needs to help a client set next year's advertising budgets for three media formats: Radio, Magazine, and TV. For each dollar

The Slick-Willie ad agency needs to help a client set next year's advertising budgets for three media formats: Radio, Magazine, and TV. For each dollar spent on an ad it generates 10M (million) units of incremental sales for a Radio Ad, 20M for a Magazine Ad, and 30M for a TV Ad. However, Radio listener consumers only average \$10/unit, while Magazine readers average \$30/unit, and TV watchers $15/ unit. The client has only up to $50M of total budget and wants to spend on Radio at least 10% of the total budget. The following LP spreadsheet was developed to determine the optimal mix of ads that will maximize incremental revenues. a. What command should be typed in B7 in order to do a Fill Right to cell D7? B7:= b. What should be typed into cells F10, F11, and G11 (the limit on radio advertising)? F10: F11: G11: = c. What Excel formula should he have put into cell E7? E7: = d. What Excel formula should he have put into cell E10 to do a Fill Down to E11? E10: = e. How should the Solver Windows be filled out? e.1 "Solver Parameters" window: Set Target Cell: To: By Changing Variable Cells: e. 2 "Subject to the Constraints" window: (write Excel command(s) below)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
