Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please write down constrains and solve it by excel solver Universe News is shown on channel X every Friday. During the hour-long broadcast, no more
Please write down constrains and solve it by excel solver
Universe News is shown on channel X every Friday. During the hour-long broadcast, no more than 19 minutes are allowed to be allocated to commercials. The remaining airtime is allocated to single or multiple time segments for local news, national news, sports, and weather, The advertising revenues generated for commercials shown during the different broadcast segments are different. These are $900 per minute for local news segments, $700 per minute for national news, 950$per minute for sports, and $600 per minute for the weather. The production cost for local news is $160 per minute, the cost for national new is $130 per minute, the costs for sports is $300 per minute, and for the weather it's $250 per minute. The station budget is $12000 per show for production costs. The station policy is that each of the time segments allocated to local news, national news, and sports should be at least 6% but no more than 55% of the total time allocated to local news, national news, sports and weather. The time segment allocated to the weather should be at least 4 minutes but no more than 10 minutes long. Commercials are excluded from these calculations.) Broadcast time devoted to commercials should be at least 7% but no more than 40% of the time segment to which the commercials are added. For example, if the time allocated for local news is 10 minutes, then time T of commercials are added to this segment should be at least 36seconds but no more than 230seconds, so, the total length of this slot will be (10*60+T) seconds What is the maximal advertising revenue that the station can gain using an optimal allocation of the time slots. Universe News is shown on channel X every Friday. During the hour-long broadcast, no more than 19 minutes are allowed to be allocated to commercials. The remaining airtime is allocated to single or multiple time segments for local news, national news, sports, and weather, The advertising revenues generated for commercials shown during the different broadcast segments are different. These are $900 per minute for local news segments, $700 per minute for national news, 950$per minute for sports, and $600 per minute for the weather. The production cost for local news is $160 per minute, the cost for national new is $130 per minute, the costs for sports is $300 per minute, and for the weather it's $250 per minute. The station budget is $12000 per show for production costs. The station policy is that each of the time segments allocated to local news, national news, and sports should be at least 6% but no more than 55% of the total time allocated to local news, national news, sports and weather. The time segment allocated to the weather should be at least 4 minutes but no more than 10 minutes long. Commercials are excluded from these calculations.) Broadcast time devoted to commercials should be at least 7% but no more than 40% of the time segment to which the commercials are added. For example, if the time allocated for local news is 10 minutes, then time T of commercials are added to this segment should be at least 36seconds but no more than 230seconds, so, the total length of this slot will be (10*60+T) seconds What is the maximal advertising revenue that the station can gain using an optimal allocation of the time slotsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started