Fill in the yellow boxes in the excel sheet attached. 1234567815161718ABeginning work in process inventoryUnits started this periodCompleted and transferred outEnding work in process inventoryFields Company has two manufacturing departments, forming and painting. The company uses the weightedaverage method and it reports the following unit data for the Forming department. Units completed in theforming department are transferred to the painting department.Beginning work in processDirect materialsConversionCosts added this periodDirect materials910111213 Production cost information for the forming department follows.14293031 Ending work in process32 Equivalent units of production33Completed and transferred out39 Costs of beginning work in process40 Costs added this period41 Total costsB42+ Equivalent units of production (from part a)43 Costs per equivalent unit of productionUnits51 Completed and transferred out52Direct materials53ConversionTotal Completed and transferred out5455 Ending work in process56 Direct materials1920Conversion21 Total costs to account for2223 Required:24 a. Calculate the equivalent units of production for both direct materials and conversion for the forming department.2526 (Use cells A6 to D21 from the given information to complete this question.)272825,000300,000295,000 100%30,000 80%$44,80015,30057 Conversion58 Total cost of ending work in process59 Total costs accounted for1,231,200896,700CMaterialsPercentComplete60%Units$60,1002,127,900$2,188,000EUP34 b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the forming department3536(Use cells A6 to D21 from the given information to complete this question.)3738DConversionPercentComplete40%Direct Materials100%30%Direct MaterialsEUPper EUPPercentPercentComplete EUP Complete EUP45 c. Using the weighted average method, assign costs to the forming department's output-specifically, its units transferred46 to painting and its ending work in process inventory.4748(Use cells A6 to D21 from the given information to complete this question.)4950 Cost Assignment and ReconciliationConversionConversionCost per EUP Total costEUPper EUPEUP Cost per EUP Total cost$0.00$0.00

Name: Fill in the yellow boxes in the excel sheet attached. 1234567815161718
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Fill in the yellow boxes in the excel sheet attached. 1234567815161718ABeginning work in process inventoryUnits started this periodCompleted and transferred outEnding work in process inventoryFields Company has two manufacturing departments, forming

a. Direct Materials Conversion Units Percent Complete EUP Percent Complete EUP…

Business

Accounting

1 2 Fields Company has two manufacturing departments, forming and painting. The company uses the weighted 3 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 6 TOGGENMANNO233858 10 11 12 14 15 Beginning work in process inventory Units started this period Completed and transferred out Ending work in process inventory 21 13 Production cost information for the forming department follows. Beginning work in process Direct materials Conversion Costs added this period Direct materials Conversion Total costs to account for 29 30 Completed and transferred out 31 Ending work in process 32 33 Equivalent units of production 39 Costs of beginning work in process 40 Costs added this period 41 Total costs 42 + Equivalent units of production (from part a) 43 Costs per equivalent unit of production 44 B Units 50 51 Completed and transferred out Direct materials 52 53 Conversion 54 Cost Assignment and Reconciliation 23 Required: 24 a. Calculate the equivalent units of production for both direct materials and conversion for the forming department. 26 (Use cells A6 to D21 from the given information to complete this question.) 27 25,000 300,000 295,000 100% 30,000 80% Total Completed and transferred out $44,800 15,300 55 Ending work in process 56 Direct materials 57 58 59 Total costs accounted for 36 (Use cells A6 to D21 from the given information to complete this question.) 37 38 Conversion Total cost of ending work in process Materials Percent Complete 60% 1,231,200 896,700 2,127,900 $2,188,000 Units $60,100 34 b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the forming departmen 35 48 (Use cells A6 to D21 from the given information to complete this question.) 49 Direct Materials EUP Direct Materials Percent Complete EUP Conversion Percent Complete 40% 100% 30% EUP per EUP EUP 45 c. Using the weighted average method, assign costs to the forming department's output-specifically, its units transferred 46 to painting and its ending work in process inventory. Conversion Percent Complete Cost per EUP Total cost Conversion Cost per EUP Total cost $0.00 $0.00 TI EUP per EUP EUP