In your Excel HW#$3$ file $-$ Click the Solver Tab, familiarize yourself with the initial data model then INVOKE the Excel Solver tool so as to do the step up steps for this optimization problem:

Objective: Maximize Total Estimated Profit from Production $($of the $3$ different models of Skateboards$)$

Changing Cells: Determine the OPTIMAL mix of production for all $3$ skateboard models given the $3$ constraints below $($Hint: Row $5)$

Constraints: ADD these $3$ constraints $($Hint: use RANGES of Cells!$)$

Optimal Product Production Levels can not exceed the maximum production levels for all $3$ products individually

The Minimum Production Levels must be taken into consideration for all $3_{{?}_{?}}$ products individually

The automatically calculated # of BOM $($Bill of Materials$)$ component Parts "Required" for production must not exceed the Beginning Inventory Available quantities on a per$-$part basis

Now SOLVE AND "Keep Solver Solution" by clicking OK to preserve$/$save$/$update the results so as to answer the REST of the questions for this portion of the Homework correctly NOTE: If it does not SOLVE $-$ then you need to work on it$/$fix it $($meaning $1$ or more of the settings$)$ so that it does$/$will solve!

$13.$ After using Solver, The TOTAL Optimal production for all $3$ Skateboard Product is

$14.$ After using Solver, The Optimal production level for the "Standard" Skateboard Product is

$15.$ After invoking Solver to determine the Optimal $($maximum$)$ Total Estimated Net Profit from Production $-$ the solver$-$calculated estimated Net Profit for the STANDARD Skateboard product is

$16.$ After invoking Solver to determine the Optimal $($maximum$)$ Total Estimated Net Profit from Production $-$ the solver$-$calculated estimated Net Profit for the DELUXE Skateboard product is

$17.$ After Solving the data model, the Uifdated Ending Inventory level $($ ColI for component part BEAR$250$ is

Superscript

$18.$ After Solving the data model, the updated Ending Inventory level $($Col I$)$

SKATERWORLD PRODUCTION SCHENULE

$\backslash$table$[[,,,,,,,,,,],[,,$inlinu,,hinss.,,nillind,,intiliter,,$],[,,4,,3,,5,,$a$,,],[,,204,,600,,7150,,,,],[,,15,,,,20,,,,],[,,$rats,,$1000,,$rian,,,,$],[,,15,,1000,,630,,$Fing,,Timili i$.],[,$$$,145100,$$$,99\mathrm{.}99,$s$),65s_{100},,,,],[$Totil Unit Cooth Murit,$5,619,5,40,00,,1320,,,,],[,s,$Byda,$9,59.,59,,4174,,,,],[,$s$.,84\mathrm{.}82,3,11918,3,$NErI$2,1,$tyat,,$]]$

Production BOM: Bill of Materials

$\backslash$table$[[\backslash$table$[[$Pant$],[$Githogary$]],$Cempontant Part Nundes,Priantilumin,Deluaner,,,,,,,Couste,Brupiparier$],[$Deck$,$STDIKC$200,(0),0,1,3,,397,,,7\mathrm{.}95,],[$Derk:$,$STDW$2300,,1,$a$,2,200,2898,$Model Z Pre Drilliad Dear,$$,1235,],[$Deati$,$STIVIEA,$1,$a$.,$a$,1,250,249,$Primiumin Prow$-$Driflled Deste,$3,1990,],[$Fade$,$RPPADT$20,2,2,2,12,,,,$$$,0\mathrm{.}55,],[$Whed Aesamily:,WHEL TONE:,a$,0,2,6,$z$\mathrm{.}519,2394,,$$$,1\mathrm{.}33,],[$Whed insembly,,a$,2,$a$,,4,4\mathrm{.}3$e$,$Wonfer RWIS Wheat Adsumbly,$$,275,],[$Whad Asearibity,WHIEI SOROM,$2,0,$a$,2,2,009,13,998,,3,4\mathrm{.}58,],[$Bidls$,$BSLTEND,$12,12,12,72,12,800,22,42,,$s$,0\mathrm{.}09,],[$Troge$,$TAPEEOO,$1,1,1,,,909,,$$$,$Q$\mathrm{.}25,],[$Bewings$,$BESAR$200,$a$,8,$a$,119,,,,$$$,269,],[$Beagimps$,$BEARZSO,$(3),0,$D$,,34,100,2092,,$$$,8\mathrm{.}45,$PreDS Shathourd Bitaring$],[,,,,5,y,,,,,,],[,,$BC$.$ III,$$,$$ $1826,,,,,,,]]$for component part WHEL$300$M is