BIG company can advertize on three different websites-Yahoo, MSN, and Facebook. Cost and exposure of each advertisement on these sites are given below: Website Cost /ad Reach /ad Website Cost /ad Reach /ad Yahoo $5000 12000 MSN $5000 6000 Facebook $2500 10000 BIG needs to make sure they are reaching at least 500,000 viewers through these ads while keeping their cost to the minimum. There are few other things BIG marketing executives need to keep in mind while planning such as BIG needs to have at least two ads on each one of the websites. Moreover, BIG needs to reach at least 100, 000 people through Yahoo and MSN On the other hand, BIG does not want to have more than 200 ads on Facebook and the number of ads on Facebook needs to be at least 5% of the total ads. Solve using MS Excel Solver.
BIG company can advertize on three different websites-Yahoo, MSN, and Facebook. Cost and exposure of each advertisement on these sites are given below: Website Cost /ad Reach /ad Website Cost /ad Reach /ad Yahoo $5000 12000 MSN $5000 6000 Facebook $2500 10000 BIG needs to make sure they are reaching at least 500,000 viewers through these ads while keeping their cost to the minimum. There are few other things BIG marketing executives need to keep in mind while planning such as BIG needs to have at least two ads on each one of the websites. Moreover, BIG needs to reach at least 100, 000 people through Yahoo and MSN On the other hand, BIG does not want to have more than 200 ads on Facebook and the number of ads on Facebook needs to be at least 5% of the total ads. Solve using MS Excel Solver.
Chapter16: Integrated Marketing Communications
Section: Chapter Questions
Problem 8DRQ
Related questions
Question
- BIG company can advertize on three different websites-Yahoo, MSN, and Facebook.
- Cost and exposure of each advertisement on these sites are given below:
Website |
Cost /ad |
Reach /ad |
Website |
Cost /ad |
Reach /ad |
Yahoo |
$5000 |
12000 |
MSN |
$5000 |
6000 |
|
$2500 |
10000 |
- BIG needs to make sure they are reaching at least 500,000 viewers through these ads while keeping their cost to the minimum. There are few other things BIG marketing executives need to keep in mind while planning such as BIG needs to have at least two ads on each one of the websites. Moreover, BIG needs to reach at least
100, 000 people through Yahoo and MSN On the other hand, BIG does not want to have more than 200 ads on Facebook and the number of ads on Facebook needs to be at least 5% of the total ads.
Solve using MS Excel Solver.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)