PLEASE DO IT IN EXCEL AND SHOW FORMULA TEXT

Q&H Company advertises during soap operas and

football games. Each soap opera ad costs $75,000,

and each football game ad costs $130,000. If S soap

opera ads are purchased, they will be seen by 4S1y2

million men and 22S1y2 million women. If F football

ads are purchased, they will be seen by 28F1y2 million

men and 10F1y2 million

women. The company wants

at least 60 million men and at least 50 million women

to see its ads.

a. Determine how to minimize Q&Hs cost of

reaching

the required number of viewers.

b. How does this model violate the proportionality

and additivity assumptions of LP?

c. Suppose that the number of women (in millions)

reached by F football ads and S soap opera ads is

8F1y2 1 22S1y2 2 0.3(FS)1y2. Why might this be

a more realistic representation of the number of

women viewers seeing Q&Hs ads?

PLEASE DO IT IN EXCEL AND SHOW FORMULA TEXT

Purchasing advertising Cost per ad ($1000s) Soap Football Ifs soap opera ads are used, they'll be watched by a*sqrt(s) million men, b*sqrt(s) women, where b IfFfootball ads are used, they'll be watched by c*sqrt(F) million men, d*sqrt(F) women, where c #d Soap Football Ads to purchase Viewer requirement in millions of viewers) Men Women Actual viewers Required viewers Total cost ($1000s) - . . . Parts a, b Part c + + B D E F G I 1 Purchasing advertising B 3 Cost per ad ($1000s) 4 Soap Football 5 6 7 If soap opera ads are used, they'll be watched by a*sqrt(s) million men, b*sqrt(s) women, where 8 a 9 b 10 11 If Ffootball ads are used, they'll be watched by c*sqrt(F) million men, d*sqrt(F) women, where 12 C 13 d 14 15 Soap Football 16 Ads to purchase 17 18 Viewer requirement (in millions of viewers) 19 Men Women 20 Actual viewers 21 22 Required viewers 23 24 Total cost ($1000s) 25 26 27 28 29 30 21