scenario is presented as follows. The program manager for Channel 10 would like to determine the best way to allocate the time for the 11:00-11:30 evening news broadeast. Specifically, she would like to determine the number of minutes of broadcast time to devote to local news, national news, weather, and sports. Over the 30 -minute broadcast, 10 minutes are set aside for advertising. The local news coverage; the time devoted to local news of national news must be at least 50% of the total broadcast time; the time devoted to the weather segment must be less than or equal to the time devoted to the sports segment; the time devoted to the sports segment. should be no longer than the total time spent on the local and national news; and at least 20% of the time should be devoted to the weather segment. The production costs per minute are $300 for local news, $200 for national news, $100 for weather, and $100 for sports. (a) Formulate this problem as a linear programming model to minimize the total production cost. You should formulate the problem algebraically. Clearly define the decision variables and their units. Express the objective function and the constraints as linear functions of the decision variables that you define. You should also identify each constraint by attaching a short descriptive label to it (e.g., Local News, or Local and National News, etc.). (b) Implement the above formulation in an Excel spreadsheet and solve it using Excel Solver. Submit the Excel file with an answer report generated and reported