please complete E25-18 and all requirements in excel. thanks!

Learning Objective 4 E25-18 Making outsourcing decisions Eclipse Systems manufactures an optical switch that it uses in its final product. The switch has the following manufacturing costs per unit: Differential cost $1.50 $ 11.00 4.50 Direct Materials Direct Labor Variable Overhead Fixed Overhead Manufacturing Product Cost 6.00 8.00 $ 29.50 Another company has offered to sell Eclipse Systems the switch for $20.00 per unit. If Eclipse Systems buys the switch from the outside supplier, the idle manufacturing facilities cannot be used for any other purpose, yet none of the fixed costs are avoidable. Prepare an outsourcing analysis to determine whether Eclipse Systems should make or buy the switch