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 /adReach /adWebsite Cost /adReach /adYahoo$500012000MSN$50006000Facebook$250010000BIG 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.

To get the best plan at minimum cost, formulate a spreadsheet as shown below:

Answered: BIG company can advertize on three…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

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
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.

Expert Solution