View the step-by-step solution to:

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

Television Radio Newspaper 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? 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?


I NEED EXCEL SPREAD SHEET AND SENSITIVITY REPORT TO SOLVE THIS PROBLEM.

Top Answer

The excel... View the full answer

Linp 1.JPG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question