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

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!