1 Chapter 5: Applying Excel 2 3 Data 5 Units in process 6 4 Beginning work in process inventory: 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 11 Units started into production during the period 13 14 17 Conversion cost 12 Costs added to production during the period: Materials cost Conversion cost 15 Ending work in process inventory: 16 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: $5,575 5,000 $368,600 $350,900 400 40% 25% 23 24 25 Equivalent Units of Production Materials Conversion 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 ? ? ? ? ? ? 31 32 Costs per Equivalent Unit 33 Materials Conversion 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 Costs of Ending Work in Process Inventory and the Units Transferred Out 41 Materials Conversion Total 43 Equivalent units 42 Ending work in process inventory: 44 Cost per equivalent unit ? ? ? ? 45 Cost of ending work in process inventory ? ? 46 48 47 Units completed and transferred out: Units transferred to the next department 49 Cost per equivalent unit Chapter 5 Form Deady ? ? 2 2