Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help with the steps on Excel, I am stuck in this question. The Westchester Chamber of Commerce periodically sponsors public service seminars and

image text in transcribed

Can someone help with the steps on Excel, I am stuck in this question.

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 Audience per advertisement Cost per advertisement Maximum media usage Television 100,000 $2,000 10 Radio 18,000 $300 Newspaper 40,000 $600 10 20 To ensure a balanced use of advertising media, radio advertisements must not exceed 50 percent of the total number of advertisements authorized. In addition, television should account for at least 10 percent 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, and what is the total audience reached? b. By how much would audience contact increase if an extra $100 were allocated to the promotional budget

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_step_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Accounting questions

Question

Appreciate the rationale for having a human resources department.

Answered: 1 week ago

Question

What are some global employee and labor relations problems?

Answered: 1 week ago