Complete "P14-48" on pages 624-625 of Managerial Accounting: Creating Value in a Dynamic Business Environment and present your responses in an Excel spreadsheet.

\fCincinnati Flow Technology Outsource (Buy) $ $ 0 (pumps) - ($ per unit) - ($ annually) Insource (Make) $ $ 0 (pumps) - ($ per unit) - ($ annually) Cost in making 10,000 pumps Components (outside purchase)......................................................................... $ Assembly labor............................................................................................................ $ Manufacturing overhead.......................................................................................... $ General / Adminstrative overhead........................................................................... $ Fixed overhead.................................................... Variable overhead.............................................. Manufacturing overhead................................ 50% $ 100% $ 150% $ - - Total costs to be avoided by purchasing..........................................................................= $ - Total costs of purchasing (10,000 pumps x $102 per unit)............................................= $ - Total annual net saving.........................................................................................................= $ - Type your response to the question here: References