What is the allocation of the budget among the three media

Assignment Help Operation Management

Reference no: EM131873319

I need help solving this in excel - step by step in excel. Can someone please help.

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	100,000	18,000	40,000
Cost per advertisement	$2,000	$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?

What is the allocation of the budget among the three media?

(b) By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
Increase in audience coverage of approximately

Reference no: EM131873319

Questions Cloud

Difference between efficiency and effectiveness : It's hard for me to determine the difference between efficiency and effectiveness. Any advice?

Compare and contrast research studies and quality management : Compare and contrast research studies and quality management projects as it relates to healthcare.

Filling the form of turbotax as per the requirement : See the atteched file of Turbotax accounting. Filling the form of turbotax as per the requirement. The response must be typed, single spaced, must be in times.

Economic strike or an unfair labor practice strike : Does work stoppage by the truck drivers in the case represent an economic strike or an unfair labor practice strike?

What is the allocation of the budget among the three media : If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact?

Role of emerging market in international equity markets : Decribe the role of Emerging market in international equity markets.

Procedures to accommodate cultural variables : Altering care or treatment procedures to accommodate cultural variables is unnecessary because any intelligent person

Social responsibility and corporate performance : Discuss the relationship between social responsibility and corporate performance.

Explain and discuss the balanced scorecard : 1. Evaluating strategies on a continuous rather than a periodic basis is desired. Discuss the pros and cons of this statement.

User Account

All Pages