Yellow cells are what we trying to answer

D Outsourcing Decision Model Data Manufactured in-house c Manufacture Outsource Manufacture anufacture Demand 1000 1200 150000 140000 175000 175000 200000 210000 1400 225000 245000 o Conservative p Avg Payoff Fixed cost Unit variable cost Purchased from supplier Unit cost Demand/Production volume Model Total manufacturing cost Total urchased cost Cost difference (Manufacture - Purchase) Best Decision $50,000 $125 $175 1500 $237,500 $262,500 -$25,000 Manufacture Demand 1 ooo 800 150,000.00 140,000.00 1200 1400 Aggressive $ 225,000.00 $ 245,000.00 Std Dev Manufacture Outsource Opportunity loss 175,000.00 $ 200,000.00 175,000.00 $ 210,000.00 Demand utsource Manufacture Outsource 1000 Demand =B16 =B17 Demand $237,500 _$262,500' Table Row input cell: Column input cell: Cancel D Outsourcing Decision Model Data Manufactured in-house c Manufacture Outsource Manufacture anufacture Demand 1000 1200 150000 140000 175000 175000 200000 210000 1400 225000 245000 o Conservative p Avg Payoff Fixed cost Unit variable cost Purchased from supplier Unit cost Demand/Production volume Model Total manufacturing cost Total urchased cost Cost difference (Manufacture - Purchase) Best Decision $50,000 $125 $175 1500 $237,500 $262,500 -$25,000 Manufacture Demand 1 ooo 800 150,000.00 140,000.00 1200 1400 Aggressive $ 225,000.00 $ 245,000.00 Std Dev Manufacture Outsource Opportunity loss 175,000.00 $ 200,000.00 175,000.00 $ 210,000.00 Demand utsource Manufacture Outsource 1000 Demand =B16 =B17 Demand $237,500 _$262,500' Table Row input cell: Column input cell: Cancel