Excel Online Structured Activity: Break$-$Even Analysis part, the firm must invest $\backslash (\backslash$$ $26,000\backslash )$ in equipment, and the firm estimates that it would cost $\backslash (\backslash$$ $5\backslash )$ per unit to make the part.

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.

$\backslash$$

$3.$ What is the total cost for the make option? Round your answer to the nearest dollar.

$\backslash$$

$4.$ What is the total cost for the buy option? Round your answer to the nearest dollar.

$\backslash$$

$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.

$\backslash$$

$6.$ To obtain the lowest production cost, should the firm make or buy the part?

The firm should the part.