Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 4: Applying Excel 2 3 Data B C 6 4 Beginning work in process inventory: 456 Units in process Completion with respect to materials 7 Completion with respect to conversion 400 55% 30% 69 8 Costs in the beginning work in process inventory: Materials cost $ 3,644 10 Conversion cost $ 7,650 11 Units started into production during the period 18,500 $ 299,620 12 Costs added to production during the period: 13 14 Materials cost Conversion cost 15 Ending work in process inventory: Completion with respect to materials 16 Units in process 17 18 Completion with respect to conversion $ 1,171,734 200 10 % 70% If your formulas are correct, you should get the correct answers to the following questions. (a) What is the equivalent units of production for materials? Equivalent units of production for materials (b) What is the equivalent units of production for conversion? Equivalent units of production for conversion (c) What is the cost per equivalent unit for materials? (Round your answer to 2 decimal places.) Cost per equivalent unit for materials (d) What is the cost per equivalent unit for conversion? (Round your answer to 2 decimal places.) Cost per equivalent unit for conversion (e) What is the cost of the units transferred out? (Round your cost per equivalent unit to 2 decimal places. Cost of units transferred out Change the percentage completion with respect to conversion for the beginning inventory from 30% to 45%, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: 1 Chapter 4: Applying Excel 2 3 Data B C 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion 400 55 % 45 % B Costs in the beginning work in process inventory 9 Materials cost $ 3,644 10 Conversion cost $ 7,650 11 Units started into production during the period 18,500 12 13 14 15 16 Costs added to production during the period: Materials cost Conversion cost Ending work in process inventory: Units in process $ 299,620 $1,171,734 17 Completion with respect to materials 200 10 % 18 Completion with respect to conversion 70 % (a) What is the equivalent units of production for materials? Equivalent units of production for materials (b) What is the equivalent units of production for conversion? Equivalent units of production for conversion (c) What is the cost per equivalent unit for materials? (Round your answer to 2 decimal places.) Cost per equivalent unit for materials (d) What is the cost per equivalent unit for conversion? (Round your answer to 2 decimal places.) Cost per equivalent unit for conversion (e) What is the cost of the units transferred out? (Round your cost per equivalent unit to 2 decimal places. Cost of units transferred out