osoft Excel Activity #2: Break-Even Analysis X Jon 1 Video Excel Online Structured Activity: Break-Even Analysis A-Z 6 Suppose that a firm has the option to make or buy a part. Its annual requirement is 19,000 units. A supplier is able to supply the part at $9 per unit. The firm estimates that it costs $500 to prepare the contract with the supplier. To make the part, the firm must invest $22,000 in equipment, and the firm estimates that costs $5 per unit to make the part. COSTS MAKE OPTION BUY OPTION Fixed Cost $22,000 $500 Variable Cost $5 $9 Annual Requirement - 19,000 units The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. . Quen spreadsheet Questions 1. What is the break even point? Round your answer to the nearest whole number 2. What is the total cost at the break even point Round your answer to the nearest dollar Back Next ULEI LUHTCLUE HUIC ILIVOVIL LAGI VIRI CIUM. VICIEUSTICE OF PCI TURILE ICYMICU GYD LU CHINCI LIC YUSUF below. Open spreadsheet Questions 1. What is the break-even point? Round your answer to the nearest whole number. 2. What is the total cost at the break-even point? Round your answer to the nearest dollar. $ 3. What is the total cost of the make option? Round your answer to the nearest dollar 4. What is the total cost for the buy option? Round your answer to the nearest dollar. $ 5. What is the cost difference (make-buy)? Round your answer to the nearest dollar. Use the minus sign to enter a negative difference, if any. $ 6. To obtain the lowest production cost, should the firm make or buy the part? The firm should the part. Check My Work Reset Problem Back B D Break-even Point E F H Demand (units) 19,000 Costs Fixed Variable (per unit) Make Option $22,000 $5.00 Buy Option $500 $9.00 Formulas Difference (Fixed Costs) b6 Difference (Variable Costs) #N/A #N/A Break-even Units Break-even Cost #N/A #N/A Total Cost (Make) Total Cost (Buy) #N/A #N/A 3 Cost Difference (Make - Buy) Optimal Decision #N/A #N/A 0 1 2 3 24 25 26 27 28 29