Question

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown:

Constraint Television Radio Online
Audience per advertisement 100,000   18,000   40,000  
Cost per advertisement $2000   $300   $600  
Maximum media usage 10   20   10  

To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized.

(a) If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? If your answer is zero enter “0”.

Advertisement Alternatives
No of commercial
messages
Television
Radio
Online
What is the allocation of the budget among the three media?
Advertisement Alternatives Budget ($)
Television $
Radio $
Online $
What is the total audience reached?
(b) By how much would audience contact increase if an extra $100 were allocated to the promotional budget? Round your answer to the nearest whole number.
Increase in audience coverage of approximately

Please show how to solve using excel if possible, thanks.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 100,000   18,000   40,000   Cost per advertisement $2000   $300   $600   Maximum media usage 10   20   10   To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 100000 18000 40000 Cost per advertisement $1400 $190 $600 Maximum media usage 10 10 20 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 100000 18000 20000 Cost per advertisement $2000 $300 $600 Maximum media usage 10 25 15 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under...
The Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 150,000   17,000   35,000   Cost per advertisement $1,500   $250   $500   Maximum media usage 12   18   11   To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of the total number of...
Problem 9-01 (Algorithmic) The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently,...
Problem 9-01 (Algorithmic) The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Newspaper Audience per advertisement 120000 20000 37000 Cost per advertisement $1500 $210 $430 Maximum media usage 12 25 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of...
Question 4 options: The Rapid City Chamber of Commerce periodically sponsors public service seminars and programs...
Question 4 options: The Rapid City Chamber of Commerce periodically sponsors public service seminars and programs which are open to the public. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are shown below: Television Radio Newspaper Audience per advertisement 80,000 15,000 30,000 Cost per advertisement $1,900 $290 $510 Maximum media usage limitation 15 25 10 Suppose that the production budget is limited to...
A committee in charge of promoting a Ladies Professional Golf Association tournament is trying to determine...
A committee in charge of promoting a Ladies Professional Golf Association tournament is trying to determine how best to advertise the event during the two weeks prior to the tournament. The committee obtained the following information about the three advertising media they are considering using. Category Audience Reached per Advertisement Cost per Advertisement Maximum Numer of Advertisement TV 200,000 $2,500 10 Radio 50,000 $400 15 Internet 100,000 $500 18 The last column in this table shows the maximum number of...
Pandora is the Internet’s most successful subscription radio service. As of June 2013, it had over...
Pandora is the Internet’s most successful subscription radio service. As of June 2013, it had over 200 million registered users (140 million of which access the service via a mobile device) and over 70 million active listeners. Pandora now accounts for more than 70% of all Internet radio listening hours and a 7% share of total U.S. radio listening (both traditional and Internet). At Pandora, users select a genre of music based on a favorite musician, and a computer algorithm...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT