On the tab labeled "Original Problem", have provided the modeling of Case 3.4 on Pages136-138. Carefully read the case in the textbook and then review the model and solver set up to familiarize yourself with the integration of the LP into Excel. On the tab labeled "Case Update", you will see there are 5 changes that must be made in the model. Using the model I have provided on the "Case Update" tab, make the required changes and re-load the solver (on the "Case Update" tab) to determine the new advertising strategy. The model should be solved only one time: after you have incorporated all 5 changes noted on the "Case Update" tab. In addition to updating the model and solver, you should provide a sentence or two to state how you addressed each change within the model. Each question is worth 16 points: 8 points for a clear, concise, grammatically correct description of the mechanical changes made to the model and 8 points for the correct solution resulting from the changes made. Questions should be answered on the "Case Update" tab and typed in unbolded black font right after the statement of the question. Please remember that case studies are individual effort, however, if you have questions you are urged to post a note on the course site within the discussion forum.;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.;2. (16 Points) Tom is scaling back his daytime television advertising strategy which will now consist of running at least one but no more than three spots per week for the four weeks leading up to the vote.;3. (16 Points) Tom wants to derive at least 20% of his total advertising impact from evening television advertisements.;4. (16 Points) Tom has decided he is willing to run a maximum of 7, 15-second radio spots per day for the 28 days leading up to the vote and a maximum of 6, 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.
Paper#31093 | Written in 18-Jul-2015Price : $27