Q&H Company advertises on soap operas and footballgames. Each soap opera ad costs $50000, and eachfootball game ad costs $100000. Giving all figures inmillions of viewers, if S soap opera ads are bought,they will be seen by 5S^1/2millionmen and 20S^1/2million women. If F football ads are purchased, they willbe seen by 17F^1/2millionmen and 7F^1/2millionwomen. Q&H wants at least 40 million men and atleast 60 million women to see its ads.

Determine how to minimize Q&H's cost of reaching the required umber of viewrs.

Here's the requirement of this Assignment:

Please formulate an algebraic model for this problem.

Convert your algebraic model to a spreadsheet model in Excel and solve for optimal solution with Solver.

I have already done with the algebraic model, please help me to check if i'm correct.

Decision Variables:

let S= # of soap opera ads

F=# of football games ads

Minimize Z=50,000S+100,000F

S.T.

5*S^1/2+17*F^1/2>=40

20*S^1/2+7*F^1/2>=60

S,F>=0

Then I need help about second one how to do Convert your algebraic model to a spreadsheet model in Excel and solve for optimal solution with Solver.

Thanks a lot!