Video

Excel Online Tutorial $$

Excel Online Activity: Break$-$Even Analysis

Suppose that a manufacturer needs to produce a custom aluminum housing for a special customer order. Because it currently does not have the equipment necessary to make the housing, it would have to acquire machines and tooling at a fixed cost $($net of salvage value after the project is completed$)$ $$80,000.$ The variable cost of production is estimated to be $$10$ per unit. The company can outsource the housing to a metal fabricator at a cost of $$23$ per unit. The customer order is for $11,000$ units. What should it do$?$ 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

What is the total in$-$house production cost? Round your answer to the nearest dollar.

$

What is the total outsourced cost? Round your answer to the nearest dollar.

$

What is the cost difference $($in$-$house $-$ outsourced$)?$ Round your answer to the nearest dollar. Use the minus sign to enter a negative difference, if any.

$

To obtain the lowest production cost, should the company manufacture the part in$-$house or outsource the part?