60.1K

Verified Solution

Link Copied!

Problem 1 (Resources/Time Allocation): The business 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 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 broadeast 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) (Done in HW1 - This sub question will not be evaluated again in this homework. Please refer to the solution keys if you have received any comments that corrected your submitted work for HW1.) 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

Answer & Explanation Solved by verified expert

See Answer