Question: Please show how to find this answer in excel. The Westchester Chamber of Commerce periodicaliy sponsors public service seminars and programs. Currently, promotional plans are

Please show how to find this answer in excel. The
Please show how to find this answer in excel.
The Westchester Chamber of Commerce periodicaliy sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising altematives include television, redio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. To ensure a balanced use of advertising media, fadio advertisements must not exceed sow of the total number of adveltisements 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 515,900 , how many commercial messages should be run on each medium to maximize total audience contact? Television Asdie Online What is the allocation of the budget among the three meda, and what is the total audience reached? Television Budget (in doliars) Radia Budget (in doliars) Onine Bodget (in doilars) Total Audience (0) by how much would audience contact incresse if an extra $100 were allocated to the promotional budget? (Round your answer to the nearest whaie number)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!