2 3 4 5 6 1 Chapter 4: Applying Excel Data Beginning work in process inventory: Units in process Completion with respect to materials 200 55% 7 Completion with respect to conversion 30% 8 Costs in the beginning work in process inventory: 9 Materials cost $9,600 10 Conversion cost $5,575 11 Units started into production during the period 5,000 $368,600 $350,900 12 Costs added to production during the period: 13 14 Materials cost Conversion cost 15 Ending work in process inventory: 16 17 Units in process Completion with respect to materials 18 Completion with respect to conversion 19 20 Enter a formula into each of the cells marked with a ? below 21 22 Weighted Average method: 23 400 40% 25% 24 25 26 Units transferred to the next department 27 Equivalent units in ending work in process inventory: 28 Materials 29 Conversion 30 Equivalent units of production Equivalent Units of Production Materials Conversion 4,800 4,800 160 100 4,960 4,900 31 32 Costs per Equivalent Unit 33 Materials 34 Cost of beginning work in process inventory 35 Costs added during the period 36 Total cost 37 Equivalent units of production 38 Cost per equivalent unit 39 Conversion ? ? ? ? ? ? ? ? ? + TOU 20 Midieniais 29 Conversion 30 Equivalent units of production 100 4,960 4,900 31 32 Costs per Equivalent Unit Materials Conversion 33 34 Cost of beginning work in process inventory 35 Costs added during the period 36 Total cost 37 Equivalent units of production 38 Cost per equivalent unit 39 ? ? ? ? ? ? ? ? ? 40 41 Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Total 42 Ending work in process inventory: 43 Equivalent units 44 Cost per equivalent unit 45 Cost of ending work in process inventory 46 47 Units completed and transferred out: 48 49 Units transferred to the next department Cost per equivalent unit 50 Cost of units transferred out 51 52 Cost Reconciliation ? 100 ? ? ? ? ? ??? 777 ? 53 Costs to be accounted for. 54 55 56 Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for 57 Costs accounted for as follows: Cost of ending work in process inventory 58 59 Cost of units transferred out 60 Total cost accounted for 61 ? ? ? ? ? ? +