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
![TYPE OF AD
TV
Social media
Billboards
Newspapers
COST
PER AD
$800
$400
$500
$100
AUDIENCE
REACHED/AD
30,000
22,000
24,000
8,000
MAXIMUM
NUMBER
10
10
10
10](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fed18415a-af27-44e8-aa80-ad5d454cc154%2F9cc9030a-ca80-43b6-ac0c-cda35213f574%2F4vj173l_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Principles Of Marketing](https://www.bartleby.com/isbn_cover_images/9780134492513/9780134492513_smallCoverImage.gif)
![Marketing](https://www.bartleby.com/isbn_cover_images/9781259924040/9781259924040_smallCoverImage.gif)
![Foundations of Business (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337386920/9781337386920_smallCoverImage.gif)
![Principles Of Marketing](https://www.bartleby.com/isbn_cover_images/9780134492513/9780134492513_smallCoverImage.gif)
![Marketing](https://www.bartleby.com/isbn_cover_images/9781259924040/9781259924040_smallCoverImage.gif)
![Foundations of Business (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337386920/9781337386920_smallCoverImage.gif)
![Marketing: An Introduction (13th Edition)](https://www.bartleby.com/isbn_cover_images/9780134149530/9780134149530_smallCoverImage.gif)
![MKTG 12:STUDENT ED.-TEXT](https://www.bartleby.com/isbn_cover_images/9781337407595/9781337407595_smallCoverImage.gif)
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)