Jx A B 5 6 1 Chapter 4: Applying Excel 2 3 Data 4 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 16 17 12 Costs added to production during the period: 13 14 Materials cost Conversion cost 15 Ending work in process inventory: 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 $368,600 $350,900 400 40% 25% 21 22 Weighted Average method: 23 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 ? ? ? ? ? ? 31 33 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 ? 223 ? ? ? ? ? 22 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 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 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: 58 59 60 61 62 Cost of ending work in process inventory Cost of units transferred out Total cost accounted for 63 ? ? ? 222 ? ? ? ? ? 227 ? ? 227