Construct the spreadsheets model for the "Make-or-Buy Decision" example. You must follow very closely the design/format of the example spreadsheets posted.

After that, you should setup the SOLVER, run SOLVER, and find the optimal solution.

You must submit your spreadsheet showing the optimal solution.

If you could upload the answer with excel it would greatly appreciate it. Thank you!

D E F G H. H 1 L M O P Q S K Set Objective: N SGS14 R 1 B C DTV = number of times daytime TV is used ETV = number of times evening TV is used W = number of times website banner ads are used SN = number of times Sunday newspaper is used B R = number of times radio is used To: O Max O Min O Value Of 0 By Changing Variable Cells: $B$12:$F$12 $B$ 1 R Subject to the Constraints: SGS16SGS21 = $1522 SG$23 = SIS24 Add 30.0000 Change Total 2370 20 Delete 0 10 = $1522 SG$23 = SIS24 Add 30.0000 Change Total 2370 20 Delete 0 10