8-6 Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kelly’s 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. Use Solver to solve the problem. You need to have one Excel sheet with the problem setup and another sheet with Solver solution
-
8-6 Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kelly’s 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. Use Solver to solve the problem. You need to have one Excel sheet with the problem setup and another sheet with Solver solution
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
