Question: A candidate for mayor in a small town is figuring out how to arrange her last-minute advertising in the days preceding the election. Two types
A candidate for mayor in a small town is figuring out how to arrange her last-minute advertising in the days preceding the election. Two types of ads will be used: radio and online. Each radio ad costs $500 and reaches an estimated 1,000 senior people and 500 non-senior people (e.g., young people). Each online ad costs $1200 and reaches an estimated 1000 seniors and 3,000 non-seniors. The campaign manager needs to decide the number of radio ads and the number of online ads so that the total cost of ads is minimized while at the same time at least 100,000 seniors and at least 150,000 non-seniors are reached. Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file here.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
