11 As the CEO of Hakoopian clothing company you want to decide whether to manufacture a particular product or outsource its production. Your business analysis team develops a spreadsheet model and uses Excel's What-if analysis to analyze "Savings due to Outsourcing" based on different scenarios. The results below are provided to you as the CEO. D Savings due to outsourcing per prod. volume Prod.Vol. $ 14,500.00 1 Parameters 2 Outsourcing Cost per unit 3 4 Fixed Cost 4.50 $ 25,000.00 10000 $21,500 5 Material cost per unit $ 2.15 20000 $18,000 6 Labor cost per unit $ 2.00 30000 $14,500 7 40000 $11,000 Model 50000 $7,500 9 Production Volume 10000 60000 $4,000 10. 70000 5500 11 Total Outsource Cost 12 5 135,000.00 80000 153.000 30000 (56,500) 13 Total Fixed Cost $ 25,000.00 100000 1510,000 14 Total Material Cost $ 64,500.00 15 Total Labor Cost $60,000.00 16 Total Cost $ 149,500.00 17 18 Savings due to outsourcing 14,500.00 19 The outsourcing cost per unit is 54.50 The amounts in parantheses are Regative (loss). Left column represent production volume. Right column represent "Savings due to outsourcing" Savings due to outsourcing per prod. volume and outsource cost per unit $ 14,500.00 $ 4.20 $ 4.35 $ 4.50 $ 4.65 $ 4.30 10000 $24,500 $23,000 $21,500 $20,000 $18,500 30000 $24,000 $21,000 $18,000 $15,000 $12,000 30000 $23,500 $19,000 514,500 $10,000 $5,500 40000 $23,000 $17,000 $11,000 $5,000 50000 $22,500 $15,000 57,500 $4,000 (55,000 60000 $22,000 $13,000 70000 $21,500 $11,000 80000 $21,000 59,000 90000 520,500 $7,000 100000 $20,000 $5,000 ($1,000) 50 (5.500) ($14,000 $500 $10,000) ($20.500 153,000) 1515,000) 527,000 (54,500) 520,000) 11.500 $10,000) (525.000) (540.000 The amounts in parentheses are negative (in) The first (left-most) column represents the production volume The top row amounts represent "Outsourcing Cost per unit" The amount in each cell represent "Savings due to outsourcing Assuming that you outsource the production of 90,000 units and the company to which you outsource charges you $4.80 per unit, based on the results above, how much will be the savings (or loss) due to outsourcing? Note: Do not use the $ sign in your answer. For example, if there is a saving of $99, the answer is 99 Use a negative sign before the amount to show that it is a loss. For example, if there is a loss of $99, the answer is-99. If there is a saving of $99, then the answer is 99