Question: PLEASE DO IN EXCEL WITH FORMULAS 19. A local television station plans to drop four Friday evening programs at the end of the season. Steve

PLEASE DO IN EXCEL WITH FORMULAS

19. 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 find the assignment of programs to time slots that will maximize total advertising revenue.

5:005:30 p.m.

5:306:00 p.m.

7:007:30 p.m.

8:008:30 p.m.

Comedy Live

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

This Week in Hockey

6000

4000

4500

7000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!