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.)