An ad campaign for a new snack chip will be conducted in a limited geographical area and
Fantastic news! We've Found the answer you've been seeking!
Question:
An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below.
Medium | Cost Per Ad | # Reached | Exposure Quality |
TV | 500 | 10000 | 30 |
Radio | 200 | 3000 | 40 |
Newspaper | 400 | 5000 | 25 |
If the number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the model that will maximize the number reached and achieve an exposure quality if at least 1000.
Using SOLVER or LINGO, solve the Max Objective Function. Provide copy of the solution spreadsheet.
Related Book For
Business Statistics in Practice
ISBN: 978-0077404741
6th edition
Authors: Bruce Bowerman, Richard O'Connell
Posted Date: