PROBLEM 7 Eyewitness News is shown on channel 5 Monday through Friday evenings from 5:00 P.M. to 6:00 P.M. During the hour-long broadcast, 18 minutes are allocated to commercials. The remaining 42 minutes of airtime are allocated to single or multiple time segments for local news and features, national news, sports, and weather. The station has learned through several viewer surveys that viewers do not consistently watch the entire news program; they focus on some segments more closely than others. For example, they tend to pay more attention to the local weather than the national news (because they know they will watch the network news following the local broadcast). As such, the advertising revenues generated for commercials shown during the different broadcast segments are $850 per minute for local news and feature segments, $600 per minute for national news, $750 per minute for sports, and $1,000 per minute for the weather. The production cost for local news is $400 per minute, the cost for national news is $100 per minute, the cost for sports is $175 per minute, and for weather it's $90 per minute. The station budgets $9,000 per show for production costs. The station's policy is that the broadcast time devoted to local news and features must be at least 10 minutes but not more than 25 minutes, whereas national news, sports, and weather must have segments of at least 5 minutes each but not more than 10 minutes. Commercial time must be limited to no more than 6 minutes for each of the four broadcast segment types. The station manager wants to know how many minutes of commercial time and broadcast time to allocate to local news, national news, sports, and weather to maximize advertising revenues. Required: Solve this model by using the computer.

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter14: Game Theory

Section14.5: Introduction To N-person Game Theory

Problem 10P

See similar textbooks

Related questions

Concept explainers

Question

100%

PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.

I REPEAT, ONLY EXCEL

PROBLEM 7
Eyewitness News is shown on channel 5 Monday through Friday evenings from 5:00 P.M. to 6:00 P.M.
During the hour-long broadcast, 18 minutes are allocated to commercials. The remaining 42 minutes
of airtime are allocated to single or multiple time segments for local news and features, national news,
sports, and weather. The station has learned through several viewer surveys that viewers do not
consistently watch the entire news program; they focus on some segments more closely than others.
For example, they tend to pay more attention to the local weather than the national news (because
they know they will watch the network news following the local broadcast). As such, the advertising
revenues generated for commercials shown during the different broadcast segments are $850 per
minute for local news and feature segments, $600 per minute for national news, $750 per minute for
sports, and $1,000 per minute for the weather. The production cost for local news is $400 per minute,
the cost for national news is $100 per minute, the cost for sports is $175 per minute, and for weather
it's $90 per minute. The station budgets $9,000 per show for production costs. The station's policy is
that the broadcast time devoted to local news and features must be at least 10 minutes but not more
than 25 minutes, whereas national news, sports, and weather must have segments of at least 5
minutes each but not more than 10 minutes. Commercial time must be limited to no more than 6
minutes for each of the four broadcast segment types.
The station manager wants to know how many minutes of commercial time and broadcast time to
allocate to local news, national news, sports, and weather to maximize advertising revenues.
Required:
Solve this model by using the computer.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.