1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process inventory: 5 Units in process 200 6 Completion with respect to materials 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 12 Costs added to production during the period: 13 Materials cost $368,600 14 Conversion cost $350,900 15 Ending work in process inventory: 16 Units in process 400 17 Completion with respect to materials 40% 18 Completion with respect to conversion 25% 19 20 Enter a formula into each of the cells marked with a ? below 21 22 Weighted Average method: 23 Equivalent Units of Production 25 Materials 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 ? 24 Conversion ? ? ? 31 32 Costs per Equivalent Unit 33 34 Cost of beginning work in process inventory 35 Costs added during the period Materials ? ? ? Conversion ? ? ? 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 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 Units transferred to the next department 49 Cost per equivalent unit 50 Cost of units transferred out ? ? ? .. ? 51 52 Cost Reconciliation 53 Costs to be accounted for: 54 Cost of beginning work in process inventory 55 Costs added to production during the period 56 Total cost to be accounted for ? ? ? 57 Costs accounted for as follows: 58 Cost of ending work in process inventory 59 Cost of units transferred out 60 Total cost accounted for ? ? ? 61 62 1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process inventory: 5 Units in process 200 6 Completion with respect to materials 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 12 Costs added to production during the period: 13 Materials cost $368,600 14 Conversion cost $350,900 15 Ending work in process inventory: 16 Units in process 400 17 Completion with respect to materials 40% 18 Completion with respect to conversion 25% 19 20 Enter a formula into each of the cells marked with a ? below 21 22 Weighted Average method: 23 Equivalent Units of Production 25 Materials 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 ? 24 Conversion ? ? ? 31 32 Costs per Equivalent Unit 33 34 Cost of beginning work in process inventory 35 Costs added during the period Materials ? ? ? Conversion ? ? ? 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 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 Units transferred to the next department 49 Cost per equivalent unit 50 Cost of units transferred out ? ? ? .. ? 51 52 Cost Reconciliation 53 Costs to be accounted for: 54 Cost of beginning work in process inventory 55 Costs added to production during the period 56 Total cost to be accounted for ? ? ? 57 Costs accounted for as follows: 58 Cost of ending work in process inventory 59 Cost of units transferred out 60 Total cost accounted for ? ? ? 61 62