Question: Can somebody put this question into excel sheets? Suppose that Penny Chairs has three media options: radio, TV , and ads in Furniture World (

Can somebody put this question into excel sheets?
Suppose that Penny Chairs has three media options: radio, TV, and ads in Furniture World (an industry publication). The table below provides information related to the costs, exposure values (i.e. how many people see the ad and is typically derived from market research studies), and limitations on the allowable number of ads in each medium desired by the firm. The company would like to achieve a total
exposure value of at least 60,000.
Cost/Ad Exposure:
Radio: $500
TV: $2000
Furniture World: $200
Exposure Value/Ad:
Radio: $2000
TV: $4000
Furniture World: $2700
Minimum Units:
Radio: 0
TV: 10
Furniture World: 6
Maximum Units:
Radio: 15
TV: No Limit
Furniture World: 12
a) What advertising mix should be implemented in order to minimize the cost of achieving the minimum required total exposure. Which constraints are binding? Why?
b) Furniture World has instituted a policy where advertisers must run a minimum of 8 ads and has raised the cost per ad to $215. How will this change the mix of ads that Penny Chairs runs?

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 General Management Questions!