Please show work (ex. formulas in excel)so that I can understand work process. Thank you.

Outsourcing (Make-or-Buy) Decision

Mountain Air Limited manufactures a line of room air purifiers. Management is currently evaluating the possible production of an air purifier for automobiles. Based on an annual volume of 10,000 units, the predicted cost per unit of an auto air purifier follows.

Direct materials$ 9.00

Direct labor1.40

Factory overhead10.00

Total$ 20.40

These cost predictions include $80,000 infixed factory overhead averaged over 10,000 units.

The completed air purifier units include a battery-operated electric motor, whichMountain Air assembles with parts purchased from an outside vendor for $2.00 per motor.Mini Motor Company has offered to supply an assembled battery-operated motor at a cost of $5.50 per unit, with a minimum annual order of 5,000 units. If Mountain Air accepts this offer, it will be able to reduce the variable labor and variable overhead costs of the auto air purifier by 50 percent.

• Calculate the net advantage (disadvantage)ofoutsourcing the electric motors from Mini Motor Company.