The program manager for Channel 10 would like to determine the best way to allocate the time for the 11:0011: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. a. What is the minimum production cost that satisfies all constraints? b. According to the optimal solution, how any minutes are allocated to national news? c. How many minutes of local news could the program manager schedule and still have the same optimal solution? d. Interpret the shadow price for the constraint corresponding to the requirement that at least 15% of the available time should be devoted to local coverage. e. Interpret the shadow price for the constraint corresponding to the requirement that the time devoted to the local and the national news must be at least 50% of the total broadcast time. How would you set up the excel worksheet and sensitivity analysis?