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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!