Please answer these! Thank you
Which of the following formulas correctly calculates the number of units transferred out in cell D21? A 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 $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 165 600 24 Cost per equivalent unit of production for direct materials $5.90 5 UUSI UI US 11 EUR HIVERY 28 JUU JUU 5.5 points Multiple Choice Skipped eBook =+B17-B18-B19 Print References =+B17+B18-019 B17+B18-B19 -B17-818+B19 6 Which of the following formulas correctly calculates the cost per equivalent unit of conversion in cel D257 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 55 DO SO A B 1. Wild Company uses the weighted average method of process costing thad 60,000 unts in 2. begiving inventory, which were 80% complete as to materials and 65% complete as to 3 conversion During the month 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 $452,150 10 Costs added during the month 11 Direct materials costs 710,400 12 Conversion costs 580410 13 Total costs added during the month 1 290 810 14 Total production costs $1.752960 15 16 Units Materials % Conversion% 17 Beginning inventory 60,000 BOX 65% 18 Units Started 120.000 19 Ending inventory 48.000 75 70% 20 21 Unts transferred out 132000 6 22 Total equivalent units of production direct materials 23 Total equivalent units of production conversion 24 Cost per equivalent unit of production for direct materials 25 Cost per equivalent unit of production for conversion 26 Cost of units transferred out 27 Cost of units in ending inventory 28 168,000 165,600 $5.90 $4 60 $1386 000 366,960 5.5 points Spoed eBook Multiple Choice Pint References +C8-C12D23 +C8-C127023 +C8-C127023 +C8C12/023 7 Which of the following formules correctly calculates the return on total assets for 2023? Hint: Remember that Excel uses the order of operations PARENTHESES then EXPONENTS then MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION Use parentheses wound any calculations in either the numerator or denominator 55 Comparative Income Statements For Years Ended December 31, 2023-2020 2023 2022 2021 $318,000 $284.000 $247.000 143.000 254,000 161 000 175,000 30.000 B6,000 114.000 14.000 39.000 $61,000 $16.000 $47.000 2020 $174.000 149.000 25.000 11,000 $14.000 1 2 3 4 Net sales 5 Cost of goods sold 6 Gross margin 7. Operating expenses 8 Net Income 9 10 11 12 1) Cash 14 Accounts receivable, net 15 Merchandise inventory 16 Plant assets, net 12 Total assets 18 19 Current liabilities Comparative Balance Sheets For Years Ended December 31, 2023-2020 2023 2022 2021 $56,000 $4.000 $30,000 89.000 80,000 69,000 36,000 89,000 40,000 130 000 120,000 100.000 $311,000 $293,000 $239,000 2020 $18,000 49,000 52,000 90,000 $209,000 $43,000 $76,000 $48.000 $45,000 AR 7 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total liabilities and equity 24 100,000 30.000 138.000 $311.000 110,000 30,000 77,000 $293.000 100,000 30,000 61,000 $239.000 120,000 30,000 14,000 $209,000 5.5 points spoed ook Multiple Choice Materences -BB/AVERAGE(017.017) AVERAGE(017 C17+88 **BB/SUM817C172 BB/SUM81701723 00 Applying Excel 10: Future Value 4 5.5 points Skipped A B D 1 Which formula properly calculates the future value of monthly deposits of $400 left on 2 deposit for 20 years at an annual return of 8%? Assume an initial deposit of $50,000 Your formula must return a positive value 3 4 Initial deposit $50,000 5 Monthly deposit $400 6 Annual return 8% 7 Number of years 20 8 Payments per year 12 eBook Print References 9 00 Payments per year 5.5 points Multiple Choice Skipped eBook -FV(B6/88,87*88,84) Print References FV[+86/88,87*88,+85) --FV(B6/B8,87*88,85,84) -FV(B6/B8,87*88,85,84) 9 Applying Excel 7: Round function #1 5.5 points Assuming the value in cell A9 is 15,842.0304, which of the following formulas would return a value of 15,842.03? eBook Multiple Choice Print References =ROUND(A9,-2) ROUND-A9,2) =ROUND(249) =ROUND(A9,2) 10 55 points Applying Excel 12: Sales dollars to achieve target pretax income Which of the following formulas in cell D13 correctly calculates the dollar amount of sales required to achieve the targeted pretax income? Hint: Remember that Excel uses the order of operations. PARENTHESES then EXPONENTS then MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION. Use parentheses around any calculations in either the numerator or denominator. A Reference D $700,000 B 1 Target pretax income 2 3 Units $ per unit 4 Sales 2,000 $500 5 Variable costs 2,000 $300 6 Contribution margin 7 Fixed costs 8 Pretax income 9 10 1) Compute the number of break-even units 11 2) Compute the break-even point in sales dollars 123) Sales (units) to achieve targeted pretax income of $700,000 134) Sales (dollars) to achieve targeted pretax income of $700,000 14 Total $1,000,000 600,000 400,000 210,000 $190,000 1,050 $210,000 4,550 $2,275.000 10 14 5.5 points Multiple Choice eBook Print *(+7D1104-C5/C4) References (*07+01/04-C5/C4 +07+DVC4 C5/C4) +(+D74DMC4-C5)/C4) 11 Applying Excel 13: Operating Income 5.5 points Which of the following formulas in cell C20 yields the correct result when copied to cell E20? E eBook Print 1 2 3 4 References 5 B D Productive Capacity 50,000 units Fixed Budget For the year ended December 31, 2020 Per Unit Total Sales $250 $9,375,000 Variable costs 180 6,750,000 Contribution margin $70 2,625,000 Fixed Expenses 2,500,000 Operating Income $125,000 6 7 8 9 10 11 12 Flexible Budget For the year ended December 31, 2020 % of productive capacity 70% Units produced and sold 35,000 13 14 75% 37500 80% 40,000 15 16 17 18 Sales Variable costs Contribution margin Fixed expenses Operating income $8 750 000 6300,000 2,450,000 2,500,000 ($50,000) $9375,000 6.750,000 2625000 2500,000 $125.000 $10,000,000 7200.000 2.800.000 2,500,000 $300,000 19 20 11 20 01 Operating income 1550.0001 $125.000 S800.000 5.5 points Multiple Choice eBook Print +C$18-C$19 References ***C18-$C$19 +$C$18-$C$19 ++$C$18-C19 12 Which of the following formulas correctly calculates the acid test ratio for 2022? Hint Remember that Excel uses the order of operations PARENTHESES then EXPONENTS then MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION Use parentheses around any calculations in either the numerator or denominator 5.5 DO E - D Comparative Income Statements For Years Ended December 31, 2023-2020 2023 2022 2021 $318,000 $284,000 $247.000 143.000 254.000 161.000 175,000 30,000 86,000 114,000 14,000 39.000 $61,000 $16.000 $47.000 2020 $174,000 149,000 25.000 11.000 $14.000 1 2 3 4 Net sales 5 Cost of goods sold 6 Gross margin 7 Operating expenses 8 Net income 9 10 11 12 13 Cash 14 Accounts receivable, net 15 Merchandise inventory 16 Plant assets, net 17 Total assets 18 19 Current liabilities Comparative Balance Sheets For Years Ended December 31, 2023-2020 2023 2022 2021 $56,000 $4,000 $30.000 89,000 80,000 69,000 36,000 89,000 40,000 130,000 120.000 100,000 $311,000 $293,000 $239,000 2020 $18,000 49,000 52.000 90.000 $209,000 $43,000 $76,000 $48,000 $45.000 12 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total liabilities and equity 24 100,000 30.000 138,000 $311,000 110,000 30.000 77,000 $293.000 100,000 30,000 61,000 $239.000 120,000 30,000 14,000 $209,000 5.5 points Doo Print Multiple Choice Duferences 0131841/C19 C13C14/C19 +C131C14+C157C19 OC134C1AVC19
