c D 150 8 1 Chapter 5: Applying Excel 2 Data Beginning work in process inventory Units in process 300 Completion with respect to materials 55% 7 Completion with respect to conversion 55% 3 9 Costs in the beginning work in process inventory 10 Materials cost $3.485 11 Conversion cost $11.517 12 Unts started into production during the period 10,500 3 34 Costs added to production during the period 15 Materials cost $219,040 16 Conversion cost $747.046 17 18 Ending work in process inventory 19 Units in process 300 20 Completion with respect to materials 50% 21 Completion with respect to conversion 20% 22 23 Entor a formula into each of the colls marked with a 7below 24 Weighted Average method: 25 26 Equivalent Units of Production 27 Materials Conversion 28 Units transferred to the next department 10,300 10,300 29 Equivalent units in ending work in process inventory 30 Materials 31 Conversion 60 32 Equivalent units of production 10.450 10.360 33 34 Costs per Equivalent Unit 35 Materials Conversion 36 Cost of beginning work in process inventory 5 3,485 $ 11.617 37 Costs added during the period $219,040 $747,045 38 Total cost $ 222,525 $ 758,662 39 Equivalent units of production 10.450 10,360 40 Cost per equivalent unit $21.29 $73.23 41 42 Costs of Ending Work in Process Inventory and the Units Transferred Out 43 Materials Conversion Total 44 Ending work in process inventory 45 Equivalent units 150 60 46 Cost per equivalent unit 52129 573 23 53, 194 47. Cost of ending work in process inventory $4394 57 588 48 49 Units completed and transferred out 50 Units transferred to the next department 10,300 10,300 51 Cost per equivalent und $2129 573 23 52 Cost of units transferred out $219,331 5754268 5973,599 53 54 Cost Reconciliation 55 Costs to be accounted for 56 Cost of beginning work in process inventory $15, 102 57 Costs added to production during the period 5966,085 58 Total cost to be accounted for 5981, 187 59 Costs accounted for as follows Cast of ending work in process inventory 57 588 Cost of units transferred out $973,599 62 Total cost accounted for 5961, 187 01 c D 150 8 1 Chapter 5: Applying Excel 2 Data Beginning work in process inventory Units in process 300 Completion with respect to materials 55% 7 Completion with respect to conversion 55% 3 9 Costs in the beginning work in process inventory 10 Materials cost $3.485 11 Conversion cost $11.517 12 Unts started into production during the period 10,500 3 34 Costs added to production during the period 15 Materials cost $219,040 16 Conversion cost $747.046 17 18 Ending work in process inventory 19 Units in process 300 20 Completion with respect to materials 50% 21 Completion with respect to conversion 20% 22 23 Entor a formula into each of the colls marked with a 7below 24 Weighted Average method: 25 26 Equivalent Units of Production 27 Materials Conversion 28 Units transferred to the next department 10,300 10,300 29 Equivalent units in ending work in process inventory 30 Materials 31 Conversion 60 32 Equivalent units of production 10.450 10.360 33 34 Costs per Equivalent Unit 35 Materials Conversion 36 Cost of beginning work in process inventory 5 3,485 $ 11.617 37 Costs added during the period $219,040 $747,045 38 Total cost $ 222,525 $ 758,662 39 Equivalent units of production 10.450 10,360 40 Cost per equivalent unit $21.29 $73.23 41 42 Costs of Ending Work in Process Inventory and the Units Transferred Out 43 Materials Conversion Total 44 Ending work in process inventory 45 Equivalent units 150 60 46 Cost per equivalent unit 52129 573 23 53, 194 47. Cost of ending work in process inventory $4394 57 588 48 49 Units completed and transferred out 50 Units transferred to the next department 10,300 10,300 51 Cost per equivalent und $2129 573 23 52 Cost of units transferred out $219,331 5754268 5973,599 53 54 Cost Reconciliation 55 Costs to be accounted for 56 Cost of beginning work in process inventory $15, 102 57 Costs added to production during the period 5966,085 58 Total cost to be accounted for 5981, 187 59 Costs accounted for as follows Cast of ending work in process inventory 57 588 Cost of units transferred out $973,599 62 Total cost accounted for 5961, 187 01