Question: ( Media selection problem ) The advertising direc - tor for Diversey Paint and Supply, a chain of four retail stores on Chicago s North

(Media selection problem) The advertising direc-tor for Diversey Paint and Supply, a chain of four retail stores on Chicagos North Side, is consider-ing two media possibilities. One plan is for a series of half-page ads in the Sunday Chicago Tribune newspaper, and the other is for advertising time on Chicago TV. The stores are expanding their lines of do-it-yourself tools, and the advertising director is interested in an exposure level of at least 40% within the citys neighborhoods and 60% in north-west suburban areas. The TV viewing time under consideration has an exposure rating per spot of 5% in city homes and 3% in the northwest suburbs. The Sunday newspaper has corresponding exposure rates of 4% and 3% per ad. The cost of a half-page Tribune advertisement is $925; a television spot costs $2,000. Diversey Paint would like to select the least costly advertising strategy that would meet desired exposure levels. QX (a) Formulate using LP.(b) Solve the problem. Please provide each step of excel solver and how to set up the solver

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!