1. Ingram Factories, Inc. - multiple departments with no beginning inventory The department managers of Ingram Factories, Inc. have prepared their monthly production reports for September, 2012. The production reports are summarized below. Trimming Assembly Finishing Department Department Department Quantity Started in Production - September 3,000 Trans. In from Prior Dept. 2,700 2,500 Trans. Out to Next Dept. 2,700 2,500 Trans. Out to Finished Goods 2,400 Work in Process - Ending 300 200 100 Stage of Completion Materials 100% 95% 80% Labor 60% 75% 90% Overhead 60% 85% 80% Costs Incurred by each department are as follows: Trimming Assembly Finishing Department Department Department Direct Materials $16,800 $8,393 $3,200 Direct Labor 9,250 7,420 5,160 Manufacturing Overhead 4,608 3,560 2,480 Total Required Using Excel, Prepare a Cost of Production Report for each department using the Weighted Average Method. . Round all unit costs to 4 decimal places . Round all total dollar amounts to the nearest cent. Use the "Precision as Displayed" option for roundingAutoSave UHE 3 Cost of Production Report - Template Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) v 11 A A de Wrap Text v General 200 Paste BIUV DVAv = Merge & Center v $ ~ % " Conditional Format Cell Insert De Formatting as Table Styles N23 X B C D E F G H K 1. Summary of Physical Units and UN Equivalent Unit Calculations Quantity to be Accounted f Physical Units 4 Equivalent Units Percent Completed Quantity Accounted for: Physical Units Direct Materials Direct Labor Overhead Materials Labor Overhead 10 11 12 13 14 15 16 2. Summary of Costs to be accounted for. 17 18 Costs in Prior Department |Total 19 20 21 22 Costs in Current Department Direct Materials Direct Labor Overhead Total 23 24 25 26 27 3. Calculation of Cost per Equivalent Unit Prior Dept. Direct Materials Direct Labor Overhead Total 28 29 30 31 32 4. Assign Costs to Units Transferred out and Ending Prior Dept. Direct Materials Direct Labor Overhead Total 33 Work in Proces 34 35 36 37 Total Costs Accounted for 38 39 Rounding Error 40 Trimming Department Assembly Department Finishing Department +