Problem $2$:

Instructions: Develop an Excel spreadsheet model on this worksheet for the given LP model below,

and run Excel Solver to obtain optimal solutions. Your model should be well organized with blue

boxes $($data$),$ red boxes $($decision variables$),$ and black boxes $($objective function values$).$

Let $T=$ number of commercials on $TV$

$M=$ number of advertisements in magazines

$R=$ number of commercials on radio

$S=$ number of advertisements in Sunday supplements

Maximize $1300T+600M+900R+500S$

subject $to300T+150M+200R+10054,000$

$,90T+30M+50R+40S1,000$

$,T5$

$,R10$

$,T,M,R,S+$