Question: Please Provide excel formulas for the linear programming problem listed below. Thank you! The Westchester Chamber of Commerce periodically sponsors public service seminars and programs.

Please Provide excel formulas for the linear programming problem listed below. Thank you!

Please Provide excel formulas for the linear

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 online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online 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? If your answer is zero enter "O". No of commercial Advertisement Alternatives messages Television Radio Online What is the allocation of the budget among the three media? Advertisement Alternatives Budget ($) Television Radio Online What is the total audience reached

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!