Problem:

Create a spreadsheet model based on the information below, then fill in the spreadsheet pictured below using specific value $($integer$,$ no decimal$)$ for decision variables and formulas for constraints.

Manufacturing Fixed Cost $=$ $$234000$

Manufacturing Cost per unit $=$ $$2$

Manufacturing Selling Price $=$ $$15$

Outsourcing Cost per unit $=$ $$3$

Outsourcing Selling Price $=$ $$12$

Constraints:

The quantity of manufacturing should be less and equal to $200,000.$

$($Qm

The budget for outsourcing is less and equal to $$300,000.$

$($Co x Qo

They plan to sell $250,000$ products for the coming year.

$($Qm $+$ Qo $=250,000)$