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 1 Parameters 2 Outsourcing Coat per unit Cost 5 Mercoperit Laborcon $ 25,000.00 $ 2.15 $ Savings due to outsourcing per pred volume Prod. Vol 514.500.00 $21.500 2000 $18,000 $14500 DOO $11,000 000 57.500 54, DCO 20000 $500 2000 151 DOO soil 10000 DOO The outsourcing cost per i 5450 The the eft column represent production wome ght comment Saving to Production Volume 30 11 Total Our Cost 12 3 Tote Cont 34 Total Melow 15 Tabor Cout 15 Total Cost 13 18 Savings dorto turing 19 Savings due to outsourcing per prod. volume and outsource center 14.500.00 5 4.20 4.355 4505 4.65 4.30 10000 524.500 $23,000 21.00 520.000 SIRS 20000 $24.000 $21,000 S18.000 $15.000 $12.000 000 $23.500 $19.000 $14.00 $10.000 S. 40000 $23,000 $17.000 $11.000 55,000 50.000 000 $22,500 $15,000 $7.500 $0 152 000 $22.000 $13,000 54.000 (55.000 $14.000 70000 $21.500 $11.000 5500 $10,000 1520, 500 OG 522,000 59,000 (53.000 ($15.000 27.000) 0000 $20.500 57.000 10 10.500 100000 520000 55.000 510000525.540.000 the mothers are not The first det meste represents the production Volume The top now amounts represent "Outsourcing Coster unit The amount in each cairant "Saving to outro $ 2.000.00 525,000.00 564 500 00 SGO00000 $ 149,500.00 $14.500.00 Assuming that the company to which you outsource charges you $4.80 per unit, based on the results above, which range for production volume contains the break-even point? 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