Question

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 3000 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? This should be done in excel.

Answer 1

Maximize

Z = 3000 x + 7000y

200x + 500y <= 40000

x >= 10

y>= 10

x-y >= 0

x1	x2
175	10
200	500	40000	40000
1	0	175	10
0	1	10	10
1	-1	165	0
3000	7000	595000

Formulas

x1	x2
175	10
200	500	=SUMPRODUCT($B$2:$C$2,B3:C3)	40000
1	0	=SUMPRODUCT($B$2:$C$2,B4:C4)	10
0	1	=SUMPRODUCT($B$2:$C$2,B5:C5)	10
1	-1	=SUMPRODUCT($B$2:$C$2,B6:C6)	0
3000	7000	=SUMPRODUCT($B$2:$C$2,B7:C7)

D7 - X Fox x1 C D E F I J K L M N O P G H Solver Parameters x1 B x2 175 200 1 0 1 3000 10 500 40000 10 Set Objective: SD57 40000 175 10 165 595000 10 To: O Max 1 -1 7000 O Min O value of: 0 By Changing Variable Cells: $B$2:$C$2 Subject to the Constraints: $D$3 <= $E$3 $D$4 >= $E$4 $D$5 >= $E$5 $D$6 >= $E$5 Add Change Delete Reset All Load/Save Make Unconstrained variables Non-Negative Select a Solving Method: GRG Nonlinear Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help [ Solve Close

x = 175

y = 10

Z = 59500

Please rate