1. 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.).
2. 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.

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 broadcast. 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 station's broadcast policy states that at least 15% of the time available should be devoted to local news coverage; the time devoted to local news or 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. - Submission instructions: All files including Word or Excel or PDF files you used to product your homework. Please use the provided Excel file (if any) to begin solving the questions that make use of Excel. In many cases, the data will already be laid out in a useful way to start you off. Sometimes, the problem will already be partially solved, to lead you in the right direction! In your Excel spreadsheets, always use the color codes expressed in Lecture 2. That is to highlight data parameters in GREEN, decision variables in BLUE, and the objective cell and Left Hand Side (LHS) of a constraint (or any formulae or functions of the decision variables) in GREY. Problem 1 (Resources/Time Allocation): The business scenario is presented as follows. (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