Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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,

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 newspaper. Audience estimates, costs, and maximum media usage limitations are as shown:

 Constraint                                          Television        Radio         Newspaper
Audience per advertisement             110,000       17,000          30,000
Cost per advertisement                        $2,500          $300              $500
Maximum media usage                          10                   23                  10

To ensure a balanced use of advertising media, radio advertisements must not exceed 40% 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 $20,500, how many commercial messages should be run on each medium to maximize total audience contact?

Advertisement Alternatives
No of commercial
messages
Television_______
Radio_________
Newspaper__________
What is the allocation of the budget among the three media?
Advertisement AlternativesBudget ($)
Television$ ________
Radio$ ________
Newspaper$ _______
What is the total audience reached?__________
(b)By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
Increase in audience coverage of approximately _____________

Step by Step Solution

3.42 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

We formulate the given problem in Excel and solve using Excel Solver as shown below ... 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_2

Step: 3

blur-text-image_3

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

An Introduction To Statistical Methods And Data Analysis

Authors: R. Lyman Ott, Micheal T. Longnecker

7th Edition

1305269470, 978-1305465527, 1305465520, 978-1305269477

More Books

Students explore these related Economics questions