Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: B U 2 4 es 300 35 % 50 % 1 Chapter 5: Applying Excel 2 Data 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion 8 Costs in the beginning work in process inventory: 9 Materials cost 10 Conversion cost 11 Units started into production during the period 12 Costs added to production during the period: 13 Materials cost 14 Conversion cost 15 Ending work in process inventory: 16 Units in process 17 Completion with respect to materials 18 Completion with respect to conversion $ $ 3,105 11,741 15,300 $ 448,818 $ 1,194,534 700 90 % 50 % 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 3 (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