Excel Onime Structured Activity: Break-Even Analysis Suppose that a firm has the option to make or buy a part. Its annual requirement is 20,000 units. A supplier is able to supply the part at $12 per unit. The firm estimates that it costs $700 to prepare the contract with the supplier. To make the part, the firm must invest $26,000 in equipment, and the firm estimates that it costs $8 per unit to make the part. COSTS Fixed Cost Variable Cost MAKE OPTION BUY OPTION $26,000 $8 $700 $12 Annual Requirement - 20,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. 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 for the make option? Round your answer to the nearest dollar.