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 $5 per unit. The fitm estimates that it conts $400 to prepare the contract with the suppliet, To make the part, the firm must invest $22,000 in equipenent, and the firm estinates thst it costs $4 per unt to make the part. The data has been collected in the Microsoft Extel Orline flle below. Open the spreadsheet and perform the required analysis to answer the questions beiow. Queitions 1. What is the break-even point? Round your arwaer to the nearest whole numbet. 2. What is the total cost at the breatheven point? Round your answer to the nearest dollac 3. Whot is the total coit for the make option? Heund your anwer to the neacest dollat. 1 4. What is the total cont for the buy eption? hound your answer to the nearest dollar 5. What is the cost difference (make - buy)? Round your aniner to the nearest dollat Use the minus won to erser a fegative diference, t ons. 3 6. To obtion the lomest productist cost, sheuld the ferm make or buy the part? The fim shovits the part