Question

Solve in EXCEL FORMAT, step by step.

A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. How many ads of each type should be used? How many people will this reach?

thank you!

Answer 1

Decision variables:

Let

x = number of radio ads to be done

y = number of TV ads to be done

Objective function is to maximize reach

max Z = 3000 x + 7000 y

Constraints:

200x + 500y <= 40000

x > = 10

y>=10

x>= y or x-y>= 0

x,y>=0

x = number of radio ads to be done = 175

y = number of TV ads to be done = 10

Z = 595000