Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managing Hospitality Human Resources

Authors: Robert H Woods, Educational Institute Staff American Hotel & Lodging Association

4th Edition

0866122877, 9780866122870

More Books

Students also viewed these General Management questions