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 director for Diversey Paint and Supply, a chain of four retail stores on Chicagos North Side, is considering two media possibilities. One plan is for a series of halfpage ads in the Sunday Chicago Tribune newspaper, and the other is for advertising time on Chicago TV The stores are expanding their lines of doityourself tools, and the advertising director is interested in an exposure level of at least within the citys neighborhoods and in northwest suburban areas. The TV viewing time under consideration hasan exposure rating per spot of in city homes and in the northwest suburbs. The Sunday newspaper has corresponding exposure rates of and per ad The cost of a halfpage Tribune advertisement is $; a television spot costs $ Diversey Paint would like to select the leastcostly advertising strategy that would meet desired exposure levels. QXa Formulate using LPb 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
