Make or Buy Decision:

Zee-Drive Ltd. is a computer manufacturer. One of the items they make is monitors. Zee-Drive has the opportunity to purchase 18,500 monitors from an outside supplier for $211 per unit. One of the company's cost-accounting interns prepared the following schedule of Zee-Drive's cost to produce 18,500 monitors:

	Total cost of producing 18,500 monitors		Unit cost
Direct materials	$	2,090,500	$	113
Direct labor		1,369,000		74
Variable factory overhead		703,000		38
Fixed manufacturing overhead		481,000		26
Fixed non-manufacturing overhead		832,500		45
	$	5,476,000	$	296

You are asked to look over the intern's estimate before the information is shared with members of management who will decide to continue to make the monitors or buy them. The company's controller believes that the estimate may be incorrect because it includes costs that are not relevant. If Zee-Drive buys the monitors, the direct labor force currently employed in producing the monitors will be terminated and there would be no termination costs incurred. There are no materials on hand and no commitments to suppliers to purchase materials, so all materials would need to be purchased to make the monitors. Variable overheads are avoidable if monitors are bought. Fixed manufacturing overhead costs would be reduced by $59,400, but non-manufacturing costs would remain the same if monitors are bought.

Create a differential analysis in Excel.