Answer Happy

LP Model: Variables: Objective: 7-16: Marketing Mix 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. A) Create the LP model for this problem in the textbox to the right. B) Create the spreadsheet for this problem below. C) Use Solver to find the optimal solution. Hea D) How many ads of each type should be used? E) How many people will this reach?" Constraints: Radio Television Cost Reach Blue cells are for data Green cells are constraints that need formulas Orange cell is for objective that needs formula Yellow cells are for decision variables which are blank Answers to Questions D and E # of ads 10 10 Hint: there are more than one constraint that will need to be placed in Solver > > 10 10 Total Reach