Return To Assignment Note: Hover over the red tab in the upper right corner of a cell to see the formula. If displayed, red text indicates no response w B D 1 2 B 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 4 forming department are transferred to the painting department. 5 5 Materials Conversion 7 Units B Beginning work in process inventory 25,000 60% Percent Percent Complete Complete 40% 9 Units started this period 300,000 0 Completed and transferred out 295,000 100% 100% 1 Ending work in process inventory 30,000 80% 30% 2 3 Production cost information for the forming department follows. 4 5 Beginning work in process 6 Direct materials 7 Conversion 8 Costs added this period 9 Direct materials 0 Conversion 1 Total costs to account for 2 3 Required: $44,800 15,300 $60,100 1,231,200 896,700 2,127,900 $2,188,000 4 a. Calculate the equivalent units of production for both direct materials and conversion for the forming department. 5 6 (Use cells A6 to D21 from the given information to complete this question.) 7 8 9 Units Direct Materials Percent Complete Conversion EUP Percent Complete 0 Completed and transferred out 1 Ending work in process 2 Equivalent units of production 3 F G H EUP 4 b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the forming department. 5 6 (Use cells A6 to D21 from the given information to complete this question.) Return To Assignment Note: Hover over the red tab in the upper right corner of a cell to see the formula. If displayed, red text indicates no re Required: D E a. Calculate the equivalent units of production for both direct materials and conversion for the forming department. 5 5 (Use cells A6 to D21 from the given information to complete this question.) Direct Materials Percent Conversion Percent Units Complete EUP Complete Completed and transferred out Ending work in process Equivalent units of production F G H EUP 5 b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the forming department. (Use cells A6 to D21 from the given information to complete this question.) Costs of beginning work in process Costs added this period Total costs Direct Materials Conversion 2 + Equivalent units of production (from part a) 5 Costs per equivalent unit of production EUP per EUP EUP per EUP c. Using the weighted average method, assign costs to the forming department's output-specifically, its units transferred to painting and its ending work in process inventory. = (Use cells A6 to D21 from the given information to complete this question.) Cost Assignment and Reconciliation Completed and transferred out EUP Cost per EUP Total cost 2 Direct materials B Conversion Total Completed and transferred out 5 Ending work in process EUP Cost per EUP Total cost 5 Direct materials = Conversion B 1 Total cost of ending work in process Total costs accounted for $0.00 $0.00