Question: please use excel solver to solve and show steps Homework 2 The Denver advertising agency promoting the new Breem dishwashing detergent wants to get the
Homework 2 The Denver advertising agency promoting the new Breem dishwashing detergent wants to get the best exposure possible for the product within the $100,000 advertising budget ceiling placed on it. To do so, the agency needs to decide how much of the budget to spend on each of its two most effective media: (1) television spots during the afternoon hours and (2) large ads in the city's Sunday newspaper. Each television spots costs $3000; each Sunday newspaper ad costs $1250. Th expected exposure, based on industry rating, is 35,000 viewers for each TV commercial and 20,000 readers for each newspaper advertisement. The agency director, Deborah Kellogg, knows from experience that it is important to use both media in order to reach the broadest spectrum of potential Breem customers. She decides that at least 5 but no more than 25 television spots should be ordered, and that at least 10 newspaper ads should be contracted. How many times should each of the two media be used to obtain maximum exposures while staying within the budget
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
