9 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 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 21 22 Weighted Average method: $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 31 22 22 ? ? Canto nor Caunalant Unit Chapter 4 Form Ready Accessibility: Good to go