Question: can you use solver on excel to help me solve this question? Decision 3. Suppose that Penny Chairs has three media options: radio, TV, and
Decision 3. 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 (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 A. How many of each type of ad should be placed 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 hak 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
Get step-by-step solutions from verified subject matter experts
