A marketing organization has up to $120,000 to spend on a radio, newspaper and TV advertising campaign for an expensive sports car. To be effective the campaign should reach at least 2,500,000 people, half of whom should be in the middle to upper income brackets and at least 500,000 should be adult males.

In addition, it is decided to use at least 150, 100 and 10 advertising units on radio, newspapers and TV, respectively. Determine the optimal advertising strategy.

Transcribed Image Text:

The relevant data is Radio Newspapers Television $100 2, 000 $120 Cost per advertising unit People reached per unit Persons reached in middle/upper incomes per unit $2,000 3, 000 60, 000 25, 000 8, 000 1,000 1,500 Adult males reached per unit 300 1,000 The relevant data is Radio Newspapers Television $100 2, 000 $120 Cost per advertising unit People reached per unit Persons reached in middle/upper incomes per unit $2,000 3, 000 60, 000 25, 000 8, 000 1,000 1,500 Adult males reached per unit 300 1,000

Answer rating: 100% (QA)

We will solve this linear programming problem using Excel Solver Below excel screensho... View the full answer