Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. A local television station plans to drop four Friday evening programs at the end of the season. Steve Botuchis, the station manager, developed a
5. A local television station plans to drop four Friday evening programs at the end of the season. Steve Botuchis, the station manager, developed a list of six potential replacement programs. Estimates of the advertising revenue ($) that can be expected for each of the new programs in the four vacated time slots are as follows. Mr. Botuchis asked you to assign programs to time slots in a way that maximizes total advertising revenue. 5:00 - 5:30 - 7:00 - 8:00 - 5:30 PM 6:00 PM 7:30 PM 8:30 PM HOME IMPROVEMENT 5000 3000 6000 4000 WORLD NEWS 7500 8000 7000 5500 NASCAR LIVE 8500 5000 6500 8000 WALL STREET TODAY 7000 6000 6500 5000 HOLLYWOOD BRIEFINGS 7000 8000 3000 6000 RAMUNDO & SON 6000 4000 4500 7000 a) Formulate the problem as a linear programming model. Define the decision variables, objective function, and constraints. (10 Points) b) Solve the model using Excel Solver. (10 Points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started