BUSI508 Week 2 Assignment Chapter 3, Pages 138, Case 3.4 SCORE 100 PERCENT

Incorporate the five changes noted below and solve the problem only after you have done so!  None of the changes noted below impact the cells in Rows 18, 19, or 20.  I have not provided any hints, however, this Case study requires some of the same strategies we used to solve the Excel Exercise.  Good luck and if you have any questions, please post them on the discussion board so that everyone has access to the same information!!  Thanks.

1.  (16 Points) Tom now wants to run full-page ads in both major newspapers for at least two weeks leading up to the vote.  NOTE:  this changes the minimum value in two cells in Column C as we are assuming this applies to both daily and Sunday newspapers.


2.  (16 Points) Tom is scaling back his daytime television advertising strategy which will now consist of running at least two but no more than four spots per week for the four weeks leading up to the vote.


3.  (16 Points) Tom wants to derive at least 10% of his total advertising impact from evening television advertisements.


4.  (16 Points) Tom has decided he is willing to run a maximum of 6, 15-second radio spots per day for the 28 days leading up to the vote and a maximum of 7, 30-second spots per day over the same period of time.   However, he wants to ensure the total impact derived from radio does not exceed 65% of the total impact.  

5.  (16 Points) With his increase in radio spots, Tom plans to use the majority of these new spots in the Orlando, Tampa, and Miami markets thus he feels the billboards in these cities are no longer required for advertisement.  However, because Tom feels there is value in billboard advertising, he wants to derive at least 1% of his total impact from billboards.