help please
Which of the following formulas correctly calculates the total equivalent units of production for conversion in cell D23? Hint: Remember that Excel uses the order of operations. PARENTHESES then EXPONENTS then MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION. Make sure to add parentheses where necessary. B C D E Wild Company uses the weighted average method of process costing. It had 60,000 units in 2 beginning inventory, which were 80% complete as to materials and 65% complete as to 3 conversion. During the month, it started 120,000 units. At the end of the month, 48,000 units were in inventory, which were 75% complete as to materials and 70% complete as to conversion. Cost information is as follows Beginning work in process inventory: aterials costs $280,800 8 Conversion costs 181,350 9 Total beginning inventory cost $462, 150 10 Costs added during the month: 11 Direct materials costs 710,400 12 Conversion costs 580,410 13 Total costs added during the month 1,290,810 14 Total production costs $1,752,960 15 16 Units Materials % Conversion % 17 Beginning Inventory 60,000 80% 65% 18 Units Started 120,000 19 Ending Inventory 48,000 75% 70% 20 21 Units transferred out 132,000 22 Total equivalent units of production - direct materials 168,000 23 Total equivalent units of production - conversion 65,600 24 Cost per equivalent unit of production for direct materials $5.90 25 Cost per equivalent unit of production for conversion $4.60 26 Cost of units transferred out $1,386,000 27 Cost of units in ending inventory 366,960 28 Multiple Choice O =+D21+(B19*D19) O =+D21*(B19+D19) O =+D21*B19*D19 O =+D21*B19+D19Which of the following formulas correctly calculates the cost per equivalent unit of conversion in cell D25? Hint: Remember that Excel uses the order of operations. PARENTHESES then EXPONENTS then MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION. Make sure to add parentheses where necessary. B C D E Wild Company uses the weighted average method of process costing. It had 60,000 units in beginning inventory, which were 80% complete as to materials and 65% complete as to conversion. During the month, it started 120,000 units. At the end of the month, 48,000 units were in inventory, which were 75% complete as to materials and 70% complete as to conversion. Cost information is as follows Beginning work in process inventory: Direct materials costs $280,800 8 Conversion costs 181,350 Total beginning inventory cost $462, 150 sts added 11 Direct materials costs 710,400 12 Conversion costs 580,410 13 Total costs added during the month 1,290,810 14 Total production costs $1,752,960 15 16 Units Materials % Conversion % 17 Beginning Inventory 60,000 80% 65% 18 Units Started 120,000 19 Ending Inventory 48,000 75% 70% 20 21 Units transferred out 132,000 22 Total equivalent units of production - direct materials 168,000 23 Total equivalent units of production - conversion 65,600 24 Cost per equivalent unit of production for direct materials $5.90 25 Cost per equivalent unit of production for conversion $4.60 26 Cost of units transferred out $1,386,000 366,960 28 27 Cost of units in ending inventory Multiple Choice O =+C8+C12*D23 O =+(C8+C12)/D23 O =+(C8-C12)/D23 O =+C8+C12/D23
