Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 slots

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting An Introduction To Cost Management Systems

Authors: Philip Jagolinzer

1st Edition

0324015828, 978-0324015829

More Books

Students also viewed these Accounting questions

Question

How can organizations increase diversity? LO.1

Answered: 1 week ago

Question

Describe the components of identity.

Answered: 1 week ago