57 X fx 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 12 Costs added to production during the period: 13 14 16 17 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 40 Costs of Ending Work in Process Inventory and the Units Transferred Out 41 Materials Conversion Total 42 Ending work in process inventory: 43 44 45 46 Equivalent units Cost per equivalent unit Cost of ending work in process inventory 47 Units completed and transferred out: 48 Units transferred to the next department ? ? ? ? ? ? ? 49 Cost per equivalent unit 50 Cost of units transferred out 722 ? ? ? 722 ? ? ? ? 51 52 Cost Reconciliation 53 Costs to be accounted for: 55 54 Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for sss 56 57 Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out 58 59 60 Total cost accounted for 61 ? ? 22 ? 222