Question: Solve this using Linear programming and solver (excel), and please show the solver steps The Chamber of Commerce regularly sponsors seminars and public service programs.
Solve this using Linear programming and solver (excel), and please show the solver steps
The Chamber of Commerce regularly sponsors seminars and public service programs. Currently, promotional plans for this year's show are underway. Advertising alternatives include television, radio, and newspaper. Viewership estimates, costs, and maximum media usage limitations are shown below:
| Restriction | TV | Radio | News Paper |
| Audience per ad | 100,000 | 18,000 | 40,000 |
| Cost per ad | U$2000 | U$ 300 | U$ 600 |
| Maximum use of the medium | 10 | 20 | 10 |
To guarantee a balanced plan, radio ads must not exceed 50% of the total number of ads allowed. In addition, television must constitute at least 10% of the total number of authorized advertisements.
a. If the promotional budget is limited to $18,200, how many commercial messages must be handled in each medium to maximize total audience contact? What is the budget allocation between the three media, and what is the total audience reached?
b. How much would audience contact increase if an additional $100 were allocated to the promotional budget?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
