60.1K

Verified Solution

Link Copied!

can someone help me on how to get these

numbers. what are the formuals? they ones i need are

hifhlighted in yellow

everything in yellow i need the formulas

4.975,000 Actual Per Unit 0.0623120 171 3,750,000 Direct labor Make sure all of your numbers Ine up in the columns Use Manufacturing overhead - variable 337,500 0.0675 the command currency icon 125,000 0.0250 Selling expenses - variable to achieve this item. If your Administrative expenses - variable numbers do not line 50,000 0.0100 3 Manufacturing overhead - fixed column, 10% will be deducted 310,000 0.0620 from your grade. This goes 4 Selling expenses - fixed for all semester 175,000 15 Administrative expenses - fixed 46,500 116 Beverage selling price per 16 oz. 0.75 Cells A21 and A41 should be this formula: -CONCATENATE("For Year Ended", TEXTIA3, "mmmm dd, WW') 18. Impact Area: 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22 Net sales $ Use the round formula everywhere 23 Variable expenses a number is multiplied by a percent 24 Direct materials or divided $ 447,750 25 Direct labor 833,313 26 Manufacturing overhead - variable 335,813 27 Cost of goods sold $ 1,616,876 28 Selling expenses Warning!!! The estimated per units has 124.375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent 31 Contribution margin 32 Fixed expenses 33 Cost of goods sold 310.000 34 Selling expenses 175,000 35 Administrative expenses 46,500 36 Total fixed expenses 1.791,001 1,958,999 531,500 logo X DownloadAttachment how to do income statement an X ades - 20FA ACC_165 WA PAX el/le/dropbox/24698/25071/DownloadAttachment?fid=207851 Nikki Haley Company For all Semester, use round 2 Income Statement Analysis formula everytime two cells are 3 December 31, 2020 multiplied or divided 4 5 Input Area All cells with highlights are Estimated 6 formulas. Do not highlight Per Unit Units Sold 7 Net Sales any cells $ 3.750,000 0.7500 5,000,000 8 Direct materials 450.000 0.0900 19 Direct labor 837500 0.1675 Units Produced 10 Manufacturing overhead . Variable 337,500 0.0675 4,975.000 11 Seling expenses variable 125.000 0.0250 12 Administrative expenses - variable 50.000 0.0100 Actual Per Unit 13 Manufacturing overhead. foed 310.000 0.0820 0.0623120 14 Selling expenses - fixed 175,000 15 Administrative expenses - fored 46,500 16. Beverage selling price per 16 oz. 0.75 17 Cells A21 and MI should be this formula -CONCATENATE("Por Year Ended", TEXTA, dd, WW 18 Impact Area 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22. Net sales Use the round formula everywhere $ 3.750,000 2 Variable expenses a number is multiplied by a percent 24 Direct materials or divided $ 447,750 25 Direct labor 833,313 26 Manufacturing overhead .variable 335,813 27 Cost of goods sold $ 1,616,878 2 Selling expenses Warningill The estimated per units has 124,375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent 1.791,001 31 Contribution margin 1,950,000 32 Foed expenses 39 Cost of goods sold 310.000 30 Selling experves 35 Administrative expenses 175,000 46,500 36 Total faced expenses 531,500 9 d21/le/dropbox/24698/25071/DownloadAttachment?fid=207851 B D 1 Nikki Haley Company 2 Income Statement Analysis For all Semester, use round formula everytime two cells are 3 December 31, 2020 multiplied or divided 4 5 Input Area: All cells with highlights are Estimated G formulas. Do not highlight Per Unit Units Sold 7 Net Sales any cells $ 3.750,000 $ 0.7500 5,000,000 8 Direct materials 450.000 0.0900 9 Direct labor 837 500 0.1675 Units Produced 10 Manufacturing overhead - variable 337,500 0.0675 4.975,000 11 Selling expenses - variable 125,000 0 0250 12 Administrative expenses variable 50.000 0.0100 Actual Per Unit 13 Manufacturing overhead - fixed column, 10 il duced 310.000 0.0620 0.0623120 de This 14 Selling expenses fixed 175,000 15 Administrative expenses. fixed 46,500 16 Beverage selling price per 1602 0.75 Cells And Mhould be this formule CONCATENATI"Yo Year Ended", TEXTAB, www 18 Impact Area: 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22 Net sales $ Use the round formula everywhere 23 Variable expenses 3.750,000 a number is multiplied by a percent 24 Direct materials or divided $ 447.750 25 Direct labor 833,313 20 Manufacturing overhead - variable 335,813 27 Cost of goods sold $ 1,616,870 28 Selling expenses WarningThe estimated per units has 124,375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent 1,791,001 31 Contribution margin 1.958.999 32 Foed expenses 39 Cost of goods sold 310,000 30 Selling expenses 175.000 35 Administrative expenses 46.500 36 Totalfixed expenses 531 500 37 Net Income NRI Haley Company 40 Traditional (Absorption Accounting) Income Statement For Year Ended December 31, 2020 42 Net sales 3,750,000 43 Cost of Goods Sold 4 Direct materials $ 447.750 45 Direct labor 833,313 46 Manufacturing overhead - variable 335.813 47 Manufacturing overhead food 311.560 16 Beverage selling price per 16 oz. 0.75 17 Cells A21 and A41 should be this formula: -CONCATENATE("For Year Ended", TEXT[A3,"mmmm dd, Ww) 18 Impact Area: 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22 Net sales 3,750,000 23 Variable expenses Use the round formula everywhere a number is multiplied by a percent 24 Direct materials or divided 447.750 25 Direct labor 833,313 26 Manufacturing overhead - variable 335,813 27 Cost of goods sold $ 1,616,876 28 Selling expenses Warning!!! The estimated per units has 124,375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent. 1.791,001 31 Contribution margin 1,958,999 32 Fixed expenses 33 Cost of goods sold 310,000 34 Selling expenses 175,000 35 Administrative expenses 46.500 36 Total fixed expenses 531,500 37 Net Income $ 1,427 499 39 Nikki Haley Company 40 Traditional (Absorption Accounting) Income Statement For Year Ended December 31, 2020 42 Net sales 3,750,000 43 Cost of Goods Sold 44 Direct materials $ 447,750 45 Direct labor 833,313 46 Manufacturing overhead - variable 335,813 47 Manufacturing overhead - fixed 311,500 48 Total Cost of Goods Sold 1.928,436 49 Gross Margin (Gross Profit 1,821,564 50. Selling and Administrative expenses 51 Selling expenses - variable 124,375 52 Selling expenses - fixed 175,000 53 Administrative expenses - variable 49.750 SA Administrative expenses - fixed 46,500 55 Total Selling and Administrative expenses 395,625 56 Net income 1,425,939 4.975,000 Actual Per Unit 0.0623120 171 3,750,000 Direct labor Make sure all of your numbers Ine up in the columns Use Manufacturing overhead - variable 337,500 0.0675 the command currency icon 125,000 0.0250 Selling expenses - variable to achieve this item. If your Administrative expenses - variable numbers do not line 50,000 0.0100 3 Manufacturing overhead - fixed column, 10% will be deducted 310,000 0.0620 from your grade. This goes 4 Selling expenses - fixed for all semester 175,000 15 Administrative expenses - fixed 46,500 116 Beverage selling price per 16 oz. 0.75 Cells A21 and A41 should be this formula: -CONCATENATE("For Year Ended", TEXTIA3, "mmmm dd, WW') 18. Impact Area: 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22 Net sales $ Use the round formula everywhere 23 Variable expenses a number is multiplied by a percent 24 Direct materials or divided $ 447,750 25 Direct labor 833,313 26 Manufacturing overhead - variable 335,813 27 Cost of goods sold $ 1,616,876 28 Selling expenses Warning!!! The estimated per units has 124.375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent 31 Contribution margin 32 Fixed expenses 33 Cost of goods sold 310.000 34 Selling expenses 175,000 35 Administrative expenses 46,500 36 Total fixed expenses 1.791,001 1,958,999 531,500 logo X DownloadAttachment how to do income statement an X ades - 20FA ACC_165 WA PAX el/le/dropbox/24698/25071/DownloadAttachment?fid=207851 Nikki Haley Company For all Semester, use round 2 Income Statement Analysis formula everytime two cells are 3 December 31, 2020 multiplied or divided 4 5 Input Area All cells with highlights are Estimated 6 formulas. Do not highlight Per Unit Units Sold 7 Net Sales any cells $ 3.750,000 0.7500 5,000,000 8 Direct materials 450.000 0.0900 19 Direct labor 837500 0.1675 Units Produced 10 Manufacturing overhead . Variable 337,500 0.0675 4,975.000 11 Seling expenses variable 125.000 0.0250 12 Administrative expenses - variable 50.000 0.0100 Actual Per Unit 13 Manufacturing overhead. foed 310.000 0.0820 0.0623120 14 Selling expenses - fixed 175,000 15 Administrative expenses - fored 46,500 16. Beverage selling price per 16 oz. 0.75 17 Cells A21 and MI should be this formula -CONCATENATE("Por Year Ended", TEXTA, dd, WW 18 Impact Area 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22. Net sales Use the round formula everywhere $ 3.750,000 2 Variable expenses a number is multiplied by a percent 24 Direct materials or divided $ 447,750 25 Direct labor 833,313 26 Manufacturing overhead .variable 335,813 27 Cost of goods sold $ 1,616,878 2 Selling expenses Warningill The estimated per units has 124,375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent 1.791,001 31 Contribution margin 1,950,000 32 Foed expenses 39 Cost of goods sold 310.000 30 Selling experves 35 Administrative expenses 175,000 46,500 36 Total faced expenses 531,500 9 d21/le/dropbox/24698/25071/DownloadAttachment?fid=207851 B D 1 Nikki Haley Company 2 Income Statement Analysis For all Semester, use round formula everytime two cells are 3 December 31, 2020 multiplied or divided 4 5 Input Area: All cells with highlights are Estimated G formulas. Do not highlight Per Unit Units Sold 7 Net Sales any cells $ 3.750,000 $ 0.7500 5,000,000 8 Direct materials 450.000 0.0900 9 Direct labor 837 500 0.1675 Units Produced 10 Manufacturing overhead - variable 337,500 0.0675 4.975,000 11 Selling expenses - variable 125,000 0 0250 12 Administrative expenses variable 50.000 0.0100 Actual Per Unit 13 Manufacturing overhead - fixed column, 10 il duced 310.000 0.0620 0.0623120 de This 14 Selling expenses fixed 175,000 15 Administrative expenses. fixed 46,500 16 Beverage selling price per 1602 0.75 Cells And Mhould be this formule CONCATENATI"Yo Year Ended", TEXTAB, www 18 Impact Area: 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22 Net sales $ Use the round formula everywhere 23 Variable expenses 3.750,000 a number is multiplied by a percent 24 Direct materials or divided $ 447.750 25 Direct labor 833,313 20 Manufacturing overhead - variable 335,813 27 Cost of goods sold $ 1,616,870 28 Selling expenses WarningThe estimated per units has 124,375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent 1,791,001 31 Contribution margin 1.958.999 32 Foed expenses 39 Cost of goods sold 310,000 30 Selling expenses 175.000 35 Administrative expenses 46.500 36 Totalfixed expenses 531 500 37 Net Income NRI Haley Company 40 Traditional (Absorption Accounting) Income Statement For Year Ended December 31, 2020 42 Net sales 3,750,000 43 Cost of Goods Sold 4 Direct materials $ 447.750 45 Direct labor 833,313 46 Manufacturing overhead - variable 335.813 47 Manufacturing overhead food 311.560 16 Beverage selling price per 16 oz. 0.75 17 Cells A21 and A41 should be this formula: -CONCATENATE("For Year Ended", TEXT[A3,"mmmm dd, Ww) 18 Impact Area: 19 Nikki Haley Company 20 Contribution Margin Income Statement 21 For Year Ended December 31, 2020 22 Net sales 3,750,000 23 Variable expenses Use the round formula everywhere a number is multiplied by a percent 24 Direct materials or divided 447.750 25 Direct labor 833,313 26 Manufacturing overhead - variable 335,813 27 Cost of goods sold $ 1,616,876 28 Selling expenses Warning!!! The estimated per units has 124,375 29 Administrative expenses decimals, this is the same as being a 49.750 30 Total variable expenses percent. 1.791,001 31 Contribution margin 1,958,999 32 Fixed expenses 33 Cost of goods sold 310,000 34 Selling expenses 175,000 35 Administrative expenses 46.500 36 Total fixed expenses 531,500 37 Net Income $ 1,427 499 39 Nikki Haley Company 40 Traditional (Absorption Accounting) Income Statement For Year Ended December 31, 2020 42 Net sales 3,750,000 43 Cost of Goods Sold 44 Direct materials $ 447,750 45 Direct labor 833,313 46 Manufacturing overhead - variable 335,813 47 Manufacturing overhead - fixed 311,500 48 Total Cost of Goods Sold 1.928,436 49 Gross Margin (Gross Profit 1,821,564 50. Selling and Administrative expenses 51 Selling expenses - variable 124,375 52 Selling expenses - fixed 175,000 53 Administrative expenses - variable 49.750 SA Administrative expenses - fixed 46,500 55 Total Selling and Administrative expenses 395,625 56 Net income 1,425,939

Answer & Explanation Solved by verified expert

See Answer