Attached is an Excel sheet template and the information and questions that need to be answered in the Word document.

Please fill in the Excel sheet according to the instructions in the accompanying Word document.

Thank you!

Cincinnati 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: Cheg http://www.chegg.com/homework-help/questions-and-answers/complete-p14-48-pages-624-625-managerialaccounting-creating-value-dynamic-business-enviro-q13076029