Create a spreadsheet model based on the questions above. Then fill in the spreadsheet using specific value $($integer$,$ no decimal$)$ for decision variables and formulas for constraints.

A B C

$1$ Nowlin Plastics

$2$

$3$ Parameters

$4$ Manufactoring Fixed Cost

$234000$

$5$ Manufactoring Outsourcing

$6$ Cost per Unit

$2$

$3$

$7$ Selling Price

$15$

$12$

$8$

$9$ Model Manufactoring Outsourcing

$10$ Quantity $11$

$11$

$12$ total profit $=$SUMPRODUCT$($B$7$:C$7,$B$10$:C$10)-$SUMPRODUCT$($B$6$:C$6,$B$10$:C$10)-$B$4$

$13$

$14$ constraints used available

$15$ Manufactoring quantity

$200000$

$16$ outsourcing budget

$300000$

$17$ total quantity

$250000$