1 Chapter 4: Applying Excel 2 3 Data 5 6 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 Materials cost Conversion cost 15 Ending work in process inventory: Units in process $368,600 $350,900 16 17 Completion with respect to materials 18 Completion with respect to conversion 19 400 40% 25% 20 Enter a formula into each of the cells marked with a ? below 21 22 Weighted Average method: 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 29 Materials Conversion 30 Equivalent units of production 31 32 Costs per Equivalent Unit ? ? ?