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) $100,000. The variable cost of production is estimated to be $20 per unit. The company can outsource the housing to a metal fabricator at a cost of $29 per unit. The customer order is for 12,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 1. What is the total in-house production cost? Round your answer to the nearest dollar. $ 2. What is the total outsourced cost? Round your answer to the nearest dollar. $ 3. 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. 4. To obtain the lowest production cost, should the company manufacture the part in-house or outsource the part? Production volume 12,000 Produced In-House Fixed cost $100,000.00 Unit variable cost $20.00 Outsourced Unit cost $29.00 Total In-House Production Cost Total Outsourced Cost Cost difference (In-House - Outsourced) Optimal Decision