8-6 Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kellys campaign manager during this election, is planning the marketing campaign, and there is some stiff competition. Martinez has selected four ways to advertise: television ads, radio ads, billboards, and newspaper ads. The costs of these, the audience reached by each type of ad, and the maximum number available are shown in the following table:

In addition, Martinez has decided that there should be at least six ads on TV or social media or some combination of those two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. While fund-raising is still continuing, the monthly budget for advertising has been set at $15,000. How many ads of each type should be placed to maximize the total number of people reached?

8-6 (pg 312) - Use Solver to solve the problem. You need to have one Excel sheet with the problem setup (basically what you already did in Assignment #7 and another sheet with Solver solution. Refer to the attached Excel file for Solver examples. Do NOT answer the questions from the textbook.