Question: If this could be done using excel LP Solver that would be fantastic! I'm just not sure how to set it up! TV Advertising Nielsen

If this could be done using excel LP Solver that would be fantastic! I'm just not sure how to set it up!If this could be done using excel LP Solver that

TV Advertising Nielsen TV ratings indicated that during the week of June 15-21, 2009, the news program Dateline NBC had an audience of 5.6 million viewers, while the news program 60 Minutes on CBS had an audience of 8.3 million viewers. An advertiser has a budget of up to $1,000,000 to purchase 30 -second commercial timeslots on these two news programs during the next three months. Suppose that each 30 second commercial timeslot on Dateline NBC costs $30,000 and each 30 -second commercial timeslot on 60 Minutes costs $40,000. The advertiser wants to purchase at least eight 30-second timeslots on each of the programs, Dateline NBC and 60 Minutes, but has stipulated that at least two-thirds of the 30 -second timeslots that are purchased should be on Dateline NBC. How many 30 -second timeslots should be purchased on each of these news programs to maximize the total number of viewers? Assume that audience size will remain the same during the subsequent three months as it was during the week of June 15-21, 2009. How many viewers were there? Round your answers to the nearest integers. Slots on Dateline Slots on 60 Minutes = Number of viewers million

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!