Hols Tablas Stan Formula Fan Alignment abc FELI Arial 10 Clear B Pasto U F57 D 1 A Chapter 4: Applying Excel 40% 7 13 Data Beginning work in process Inventory: 5 Units in process 200 6 Completion with respect to materials 55% Z 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 153 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 18 Completion with respect to conversion 25% 19 20 Enfor a formula into each of the calls marked with a below 22 22 Weighted Average method: 2224 Equivalent Units of Production 25 Materials Conversion 226 Units transferred to the next department 2 2 27 Equivalent units in ending work in process inventory 28 Materials 2 29 Conversion 30 Equivalent units of production 2 31 32 Costs per Equivalent Unit 33 Materials Conversion 34 Cost of beginning work in process inventory 2 7 35 Costs added dunng the period 2 36 Total cost 2 ? 37 Equivalent units of production 2 38 Cost per equivalent unit 2 39 40 Costs of Ending Work In Process Inventory and the Units Transferred Out Materials Conversion 42 Ending work in process inventory 43 Equivalent units Cost per equivalent unit 45 Cost of ending work in process inventory 47 Units completed and transforrod out 48 Units transferred to the next dopartment 49 Cost por equivalent un 50 Cost of units transferred out S Cost Reconciliation 53 Costs to be accounted for 54 Cost of beginning work in process inventory 55 Costs added to production during the ponad 56 Total cost to be accounted for 57 Costa accounted for as folow Cost of ending work in prostory Total Costs per Equivalent Unit Cost of beginning work in process inventory Costs added during the period Total cost Equivalent units of production Cost per equivalent unit Materials Conversion ? ? ? ? 2 7 2 ? 2 Total Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Ending work in process inventory: Equivalent units ? Cost per equivalent unit 2 2 Cost of ending work in process inventory ? Units completed and transferred out: Units transferred to the next department ? 2 Cost per equivalent unit 2 Cost of units transferred out 2 ? ??? 7 ? Cost Reconciliation Costs to be accounted for: Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for ? 2 2 +