answer it in excel

LO 1,2, 4 3-41 Make-or-buy, relevant costs, and opportunity cost Fab Motors has manufactured compressor parts at its plant in Pitcairn, Indiana, for the past 25 years. An outside supplier, Superior Compressor Company, has offered to supply compressor model C38 at a price of $200 per unit. Current unit manufacturing costs for C38 are as follows: Direct materials SSO Direct labor Variable overhead Fixed owerhead Total costs Required (a) Should Superior Compressor's offer be accepted if the Pitcairn plant is presently operating below capacity? (b) What is the maximum acceptable purchase price if the plant facilities are fully utilized at present and if any additional available capacity can be deployed for the production of other compressors? 17 $213