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
Get step-by-step solutions from verified subject matter experts
