Applying Excel 9: Cost of units in ending inventory Which of the following formulas correctly calculates the cost of the 48,000 units in ending Inventory in cell D27? 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 D E 1 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: 4 5 6 Beginning work in process inventory 7 Direct materials costs $280,800 8 Conversion costs 181 350 9 Total beginning inventory cost $482,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 80 000 80% 65% 18 Units Started 120.000 19 Ending Inventory 48.000 75% 20 21 Units transferred out 132.000 22 Total equivalent units of production - direct materials 168000 23 Total equivalent units of production - conversion 165,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 $1386,000 27 Cost of units in ending inventory 386,960 28 70% Multiple Choice o =+(B19*D19*D24)+(B19-C19*D25) O =+B19-C19*(D24+B19)*D19*D25 O =+819*C19*D25+B19'D19*D25 O =+(B19-C19*D24)+(819*D19*D25)