N21 X fx A B C D E F G H Fields Company has two manufacturing departments, forming and painting. The company uses the weighted average method and it reports the following unit data for the Forming department. Units completed in the forming department are transferred to the painting department. Materials Conversion Percent Percent Units Complete Complete Beginning work in process inventory 25,000 60% 40% Units started this period 300,000 10 Completed and transferred out 295,000 100% 100% 11 Ending work in process inventory 30,000 80% 30% 12 13 Production cost information for the forming department follows. 14 15 Beginning work in process 16 Direct materials $44,800 17 Conversion 15,300 $60,100 18 Costs added this period 19 Direct materials 1,231,200 20 Conversion 896,700 2,127,900 21 Total costs to account for $2,188,000 23 Required: 24 a. Calculate the equivalent units of production for both direct materials and conversion for the forming department. 25 26 (Use cells A6 to D21 from the given information to complete this question.) 27 Direct Materials Conversion Percent Percent 29 Units Complete EUP Complete EUP 30 Completed and transferred out Ending work in process 32 Equivalent units of production 33 34 b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the forming department 35 36 (Use cells A6 to DZ1 from the given information to complete this question.) 38 Direct Materials Conversion 39 Costs of beginning work in process 40 Costs added this period Total costs + Equivalent units of production (from part a) EUP EUP Costs per equivalent unit of production per EUP per EUP 45 c. Using the weighted average method, assign costs to the forming department's output-specifically, its units 46 transferred to painting and its ending work in process inventory. 47 48 (Use cells A6 to D21 from the given information to complete this question.) 49 Cost Assignment and Reconciliation Completed and transferred out EUP Cost per EUP Total cost Direct materials Conversion Total Completed and transferred out Ending work in process EUP Cost per EUP Total cost Direct materials $0.00 Conversion