2. A local television station plans to drop four Friday evening programs at the end of the season. Steve Green, the station manager, developed a list of six potential replacement programs. Estimates of the advertising revenue (in $100s) that can be expected for each of the new programs in the four vacated time slots are as follows. Mr. Green asked you to find the assignment of programs to time slots that will maximize total advertising revenue. Solve using Excel Solver and summarize your results. 2. A local television station plans to drop four Friday evening programs at the end of the season. Steve Green, the station manager, developed a list of six potential replacement programs. Estimates of the advertising revenue (in $100s) that can be expected for each of the new programs in the four vacated time slots are as follows. Mr. Green asked you to find the assignment of programs to time slots that will maximize total advertising revenue. Solve using Excel Solver and summarize your results