Paste F57 BIUV AA Me Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Up X fx A B 5 6 7 1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion 200 55% 30% 8 Costs in the beginning work in process inventory: 90 Materials cost $9,600 Conversion cost 13 10 11 Units started into production during the period 12 Costs added to production during the period: 14 Materials cost Conversion cost 15 Ending work in process inventory: 16 Units in process 17 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 ? ? ? ? ? 2 D 31 32 33 Costs per Equivalent Unit 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 41 ? ? ? ? 7 7 ? P Costs of Ending Work In Process Inventory and the Units Transferred Out 42 Ending work in process inventory Materials Conversion Total Chapter 4 Form