Please include the formulas. Thank you in advance!!

The first pictures help out with the last two pictures (yellow squares). All I need answers for are the bottom two pictures. Please include formulas.

TASK #2.1 INCOME STATEMENT High-End Lifts, Inc. Income Statement For the six-months ended, 4th year % December, November October, 100.0% 1,204,632 1,078,020 1,445,400 -49.0% (612,084) (555,109) (720,430) 100.0% 468,468 419,230 562,100 -48.1% (232,311) (210,154) (274,445) 51.3% 828,705 731,988 1,012,625 2 2 Total 6-months 10,585,620 (5,183,529) 4,116,630 (1,981,484) Sales Revenue - Elevators COGS - Elevators Sales Revenue - Stair Lifts COGS - Stair Lifts September 1,901,268 (925,571) 739,382 (354,222) August ,194,380 (1,057,471) 853,370 (405,517) July, 2,761,920 (1,312,864) 1,074,080 (504,836) | 7,537,238 1,360,858 1,584,763 2,018,300 Gross Margin G&A Expenses Advertising Expense Sales Commissions Salaries & Wages Expense Depreciation Expense nsurance Expense Rent Expense Utilities Expense Total SG&A Expenses Operating Income (EBIT) Other Income & Expenses nterest Expense Earnings Before Taxes (EBT) ncome Tax Expense, 25% Net Income CHECK C26 =3,024,107 1,530,225 735,113 929,378 49,440 144,000 72,000 26,702 3,486,858 4,050,380 10.4% 5.0% 6.3% 0.3% 1.0% 0.5% 0.2% 23.7% 27.5% 177,310 83,655 150,579 8,240 16,000 12,000 3,673 451,457 377,248 159,725 74,863 134,753 8,240 16,000 12,000 3,497 409,077 322,910 210,750 100,375 160,600 8,240 24,000 12,000 4,008 519,973 492,653 274,065 132,033 158,439 8,240 24,000 12,000 4,641 613,417 747,440 314,775 152,388 152,388 8,240 32,000 12,000 5,048 676,838 907,925 393,600 191,800 172,620 8,240 32,000 12,000 5,836 816,096 1,202,204 18,237 4,032, 143 1,008,036 3,024,107 0.1% 27.4% 6.9% 20.6% 3,000 374,248 93,562 280,686 3,015 319,895 79,974 239,921 3,032 489,621 122,405 367,215 3,048 744,392 186,098 558,294 3,062 904,863 226,216 678,647 3,080 1,199,124 299,781 899,343 Sales and COGS Graphs 4,500,000 2,000,000 4,000,000 R2 = 1 R2 = 1 3,500,000 3,000,000 COGS - All Units Weighted Units 22.73 20.34 27.27 35.87 41.40 52.10 Sales Revenue -Weighted Average All Units Month Weighted Units Sales Revenue December 22.73 1,673,100 November 20.34 1,497,250 October 27.27 2,007,500 September 35.87 2,640,650 August 41.40 3,047,750 52.10 3,836,000 High-Low Method Run Rise Low point 20.34 1,497,250 High point 52.10 3,836,000 Slope (WA Price) $ 73,623.26 Month December November October September August July COGS 844,395 765,263 994,875 1,279,793 1,462,988 1,817,700 2,500,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 2,000,000 1,500,000 uly 1,000,000 500,000 High-Low Metho Run Rise Low point 20.34 765,263 High point 52.10 1,817,700 Slope (VC per Unit) $ 33,130.47 Fixed $ 91,500.00 TC = FC + VC; TC = $91,500 + $33,130x 10.00 20.00 30.00 40.00 50.00 60.00 10.00 20.00 30.00 40.00 50.00 60.00 Advertising Exp. 450,000 250,000 Advertising Expense Weighted-Units Advertising 22.7 177,310 20.3 159,725 27.3 210,750 35.9 274,065 41.4 314,775 52.1 393,600 Month December November October September August July R2 = 1 400,000 350,000 Sales Commissions Expense Month Weighted-Units Sales Comm December 22.7 83,655 November 20.3 74,863 October 27.3 100,375 September 35.9 132,033 August 41.4 152,388 July 52.1 191,800 200,000 R2 = 1 150,000 100,000 300,000 250,000 200,000 150,000 100,000 50,000 50,000 Run 20.34 52.10 High-Low Method Low point High point Slope Fixed TC = FC + VC; TC = $10,000 + $7,362x Rise 159,725 393,600 7,362.33 10,000.00 High-Low Metho Run Low point 20.3 High point 52.1 Slope Fixed TC = FC + VC; TC = $0 + $3,681x Rise 74,863 191,800 3,681.16 $ - 10.0 20.0 30.0 40.0 50.0 60.0 $ $ . 10.0 20.0 30.0 40.0 50.0 60.0 Salaries & WagesExp Depreciation Exp 8,240 Salaries & Wages Expense Weighted-Units Sal & Wages 22.7 150,579 20.3 134,753 27.3 160,600 35.9 158,439 41.4 152,388 52.1 172,620 Month December November October September August July R2 = 0.6029 Month December November October September August July 200,000 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 Depreciation Expense Weighted-Units 22.7 20.3 27.3 35.9 41.4 52.1 Dep. Exp 8,240 8,240 8,240 8,240 8,240 8,240 8,240 8,240 8,240 8,240 High-Low Method Low point High point Slope Fixed Run 20.3 52.1 8,240 Rise 134,753 172,620 $ 1,192.06 $ 110,510.01 High-Low Metha Low point High point Slope Fixed Run 20.3 52.1 Rise 8,240 8,240 8,240 R2 = #N/A 50.0 10.0 20.0 30.0 40.0 50.0 60.0 $ 10.0 20.0 30.0 40.0 60.0 $ 8,240.00 12,000 Insurance Exp 40,000 Insurance Expense Weighted Units 22.7 20.3 27.3 35.9 41.4 52.1 Month December November October September August July R= 0.8572 Ins. Exp 16,000 16,000 24,000 24,000 32,000 32,000 35,000 30,000 Month December November October September August July Rent Expense Weighted Units 22.7 20.3 27.3 35.9 41.4 52.1 Rent Exp 12,000 12,000 12,000 12,000 12,000 12,000 25,000 20,000 15,000 Run 20.3 52.1 10,000 5,000 Rise 16,000 32,000 503.68 5,756.92 Rise 12,000 12,000 High-Low Method Low point High point Slope Fixed TC = FC + VC; TC = $5,757+ $504x R2 = #N/A High-Low Metho Run Low point 20.3 High point 52.1 Slope Fixed TC = FC + VC; TC = $12,000 12,000 $ 10.0 20.0 30.0 40.0 50.0 60.0 10.0 20.0 30.0 40.0 50.0 60.0 $ $ 12,000.00 Utilities Exp 7,000 Utilities Expense Weighted-Units 22.7 20.3 27.3 35.9 41.4 52.1 6,000 Month December November October September August July R2 = 1 Util. Exp 3,673 3,497 4,008 4,641 5,048 5,836 5,000 4,000 3,000 2,000 Run 20.3 52.1 1,000 High-Low Method Low point High point Slope Fixed TC = FC + VC; TC = $2,000+ $74x Rise 3,497 5,836 73.62 2,000.00 10.0 20.0 30.0 40.0 50.0 60.0 $ TASK #2.2: COST BEHAVIOR Accounts Classification ales Revenue - WA All Units Revenue High-Low (HL) Method Variable Fixed 73,623.26 $ Linear Regression (LR) Method Variable Fixed 73,623.26 0 Is there a difference between HL Method and LR Method? (Yes or No); Briefly explain No: graph is linear $ - $ $ $ $ $ Hint: Is the graph linear? 91,500 10,000 33,130 7,362 3,681 1,192 33,130 7,362 3.681 91,500 10,000 - Hint: Is the graph curvilinear? COGS - All Units dvertising Expense ales Commissions alaries & Wages Expense Depreciation Expense nsurance Expense ent Expense Utilities Expense Mixed Mixed Variable Mixed Fixed Step-Fixed Fixed Mixed No: graph is linear No: graph is linear No: graph is linear Yes: Curvilinear No: graph is linear Yes: Step-fixed No: graph is linear No: graph is linear - 8,240 110,510 8,240 5,757 12,000 2,000 504 Hint: Is the graph step-fixed? - 74 COTALS $ $ Which Method Should You Use? Linear Hint: Which one includes all of the data? 45,943 PER WA UNIT 240,007 PER MONTH $ 44,173 PER WA UNIT 109,740 PER MONTH Use the linear regression results to derive a total cost equation for High-End Lifts, Inc. Follow this format: COST EQUATION = TC = FC + (VC per unit x Weighted-Average # of Units). Leave WA# of units as an unknown varaiable. Directions: Complete this table by forwarding the amounts that are given on Task #2.1 IS for each line item, starting with advertising expense. The COGS line has been done for you as an example.. FC per month + (VC per Units x | TC = TC = WA# of units) leave blank Check D17 = $45,943 Check G17 = $257,872 If the budgeted weighted average # of units sold in January of year 5 = 23 units, derived budgeted total costs using the cost equation derived above. TC = FC per month + (VC per Units X WA# of units) Check C30 = $1,306,504.60 TASK #3: CONTRIBUTION MARGIN INCOME STATEMENT High-End Lifts, Inc. Contribution Margin Income Statement For the six-months ended, 4th year Per Unit Total % Cell D7 = Task #1 tab cell G61 Weighted Average Volume, All Units - 6 months 199.70 $ 73,623.26 Predicted Sales Revenue Predicted Variable Cost Predicted Contribution Margin #DIV/0! #DIV/0! #DIV/0! Cell C9 = Task #2.2, F6 Cell C10 = Task #2.2, F17 Check: Cell C11 = $5,597,613 6 months D13 (hint: make sure you calculate 6 months of fixed costs) Fixed Costs Predicted Operating Income (EBIT) #DIV/0! #DIV/0! Check D14 = $4,050,381 Operating Income (EBIT) on Task #3.1 IS - Cell C21 27.5% Check D19 = 0.00003% error Difference % Error % Error is insignificant; highly predictive equatic TASK #2.1 INCOME STATEMENT High-End Lifts, Inc. Income Statement For the six-months ended, 4th year % December, November October, 100.0% 1,204,632 1,078,020 1,445,400 -49.0% (612,084) (555,109) (720,430) 100.0% 468,468 419,230 562,100 -48.1% (232,311) (210,154) (274,445) 51.3% 828,705 731,988 1,012,625 2 2 Total 6-months 10,585,620 (5,183,529) 4,116,630 (1,981,484) Sales Revenue - Elevators COGS - Elevators Sales Revenue - Stair Lifts COGS - Stair Lifts September 1,901,268 (925,571) 739,382 (354,222) August ,194,380 (1,057,471) 853,370 (405,517) July, 2,761,920 (1,312,864) 1,074,080 (504,836) | 7,537,238 1,360,858 1,584,763 2,018,300 Gross Margin G&A Expenses Advertising Expense Sales Commissions Salaries & Wages Expense Depreciation Expense nsurance Expense Rent Expense Utilities Expense Total SG&A Expenses Operating Income (EBIT) Other Income & Expenses nterest Expense Earnings Before Taxes (EBT) ncome Tax Expense, 25% Net Income CHECK C26 =3,024,107 1,530,225 735,113 929,378 49,440 144,000 72,000 26,702 3,486,858 4,050,380 10.4% 5.0% 6.3% 0.3% 1.0% 0.5% 0.2% 23.7% 27.5% 177,310 83,655 150,579 8,240 16,000 12,000 3,673 451,457 377,248 159,725 74,863 134,753 8,240 16,000 12,000 3,497 409,077 322,910 210,750 100,375 160,600 8,240 24,000 12,000 4,008 519,973 492,653 274,065 132,033 158,439 8,240 24,000 12,000 4,641 613,417 747,440 314,775 152,388 152,388 8,240 32,000 12,000 5,048 676,838 907,925 393,600 191,800 172,620 8,240 32,000 12,000 5,836 816,096 1,202,204 18,237 4,032, 143 1,008,036 3,024,107 0.1% 27.4% 6.9% 20.6% 3,000 374,248 93,562 280,686 3,015 319,895 79,974 239,921 3,032 489,621 122,405 367,215 3,048 744,392 186,098 558,294 3,062 904,863 226,216 678,647 3,080 1,199,124 299,781 899,343 Sales and COGS Graphs 4,500,000 2,000,000 4,000,000 R2 = 1 R2 = 1 3,500,000 3,000,000 COGS - All Units Weighted Units 22.73 20.34 27.27 35.87 41.40 52.10 Sales Revenue -Weighted Average All Units Month Weighted Units Sales Revenue December 22.73 1,673,100 November 20.34 1,497,250 October 27.27 2,007,500 September 35.87 2,640,650 August 41.40 3,047,750 52.10 3,836,000 High-Low Method Run Rise Low point 20.34 1,497,250 High point 52.10 3,836,000 Slope (WA Price) $ 73,623.26 Month December November October September August July COGS 844,395 765,263 994,875 1,279,793 1,462,988 1,817,700 2,500,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 2,000,000 1,500,000 uly 1,000,000 500,000 High-Low Metho Run Rise Low point 20.34 765,263 High point 52.10 1,817,700 Slope (VC per Unit) $ 33,130.47 Fixed $ 91,500.00 TC = FC + VC; TC = $91,500 + $33,130x 10.00 20.00 30.00 40.00 50.00 60.00 10.00 20.00 30.00 40.00 50.00 60.00 Advertising Exp. 450,000 250,000 Advertising Expense Weighted-Units Advertising 22.7 177,310 20.3 159,725 27.3 210,750 35.9 274,065 41.4 314,775 52.1 393,600 Month December November October September August July R2 = 1 400,000 350,000 Sales Commissions Expense Month Weighted-Units Sales Comm December 22.7 83,655 November 20.3 74,863 October 27.3 100,375 September 35.9 132,033 August 41.4 152,388 July 52.1 191,800 200,000 R2 = 1 150,000 100,000 300,000 250,000 200,000 150,000 100,000 50,000 50,000 Run 20.34 52.10 High-Low Method Low point High point Slope Fixed TC = FC + VC; TC = $10,000 + $7,362x Rise 159,725 393,600 7,362.33 10,000.00 High-Low Metho Run Low point 20.3 High point 52.1 Slope Fixed TC = FC + VC; TC = $0 + $3,681x Rise 74,863 191,800 3,681.16 $ - 10.0 20.0 30.0 40.0 50.0 60.0 $ $ . 10.0 20.0 30.0 40.0 50.0 60.0 Salaries & WagesExp Depreciation Exp 8,240 Salaries & Wages Expense Weighted-Units Sal & Wages 22.7 150,579 20.3 134,753 27.3 160,600 35.9 158,439 41.4 152,388 52.1 172,620 Month December November October September August July R2 = 0.6029 Month December November October September August July 200,000 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 Depreciation Expense Weighted-Units 22.7 20.3 27.3 35.9 41.4 52.1 Dep. Exp 8,240 8,240 8,240 8,240 8,240 8,240 8,240 8,240 8,240 8,240 High-Low Method Low point High point Slope Fixed Run 20.3 52.1 8,240 Rise 134,753 172,620 $ 1,192.06 $ 110,510.01 High-Low Metha Low point High point Slope Fixed Run 20.3 52.1 Rise 8,240 8,240 8,240 R2 = #N/A 50.0 10.0 20.0 30.0 40.0 50.0 60.0 $ 10.0 20.0 30.0 40.0 60.0 $ 8,240.00 12,000 Insurance Exp 40,000 Insurance Expense Weighted Units 22.7 20.3 27.3 35.9 41.4 52.1 Month December November October September August July R= 0.8572 Ins. Exp 16,000 16,000 24,000 24,000 32,000 32,000 35,000 30,000 Month December November October September August July Rent Expense Weighted Units 22.7 20.3 27.3 35.9 41.4 52.1 Rent Exp 12,000 12,000 12,000 12,000 12,000 12,000 25,000 20,000 15,000 Run 20.3 52.1 10,000 5,000 Rise 16,000 32,000 503.68 5,756.92 Rise 12,000 12,000 High-Low Method Low point High point Slope Fixed TC = FC + VC; TC = $5,757+ $504x R2 = #N/A High-Low Metho Run Low point 20.3 High point 52.1 Slope Fixed TC = FC + VC; TC = $12,000 12,000 $ 10.0 20.0 30.0 40.0 50.0 60.0 10.0 20.0 30.0 40.0 50.0 60.0 $ $ 12,000.00 Utilities Exp 7,000 Utilities Expense Weighted-Units 22.7 20.3 27.3 35.9 41.4 52.1 6,000 Month December November October September August July R2 = 1 Util. Exp 3,673 3,497 4,008 4,641 5,048 5,836 5,000 4,000 3,000 2,000 Run 20.3 52.1 1,000 High-Low Method Low point High point Slope Fixed TC = FC + VC; TC = $2,000+ $74x Rise 3,497 5,836 73.62 2,000.00 10.0 20.0 30.0 40.0 50.0 60.0 $ TASK #2.2: COST BEHAVIOR Accounts Classification ales Revenue - WA All Units Revenue High-Low (HL) Method Variable Fixed 73,623.26 $ Linear Regression (LR) Method Variable Fixed 73,623.26 0 Is there a difference between HL Method and LR Method? (Yes or No); Briefly explain No: graph is linear $ - $ $ $ $ $ Hint: Is the graph linear? 91,500 10,000 33,130 7,362 3,681 1,192 33,130 7,362 3.681 91,500 10,000 - Hint: Is the graph curvilinear? COGS - All Units dvertising Expense ales Commissions alaries & Wages Expense Depreciation Expense nsurance Expense ent Expense Utilities Expense Mixed Mixed Variable Mixed Fixed Step-Fixed Fixed Mixed No: graph is linear No: graph is linear No: graph is linear Yes: Curvilinear No: graph is linear Yes: Step-fixed No: graph is linear No: graph is linear - 8,240 110,510 8,240 5,757 12,000 2,000 504 Hint: Is the graph step-fixed? - 74 COTALS $ $ Which Method Should You Use? Linear Hint: Which one includes all of the data? 45,943 PER WA UNIT 240,007 PER MONTH $ 44,173 PER WA UNIT 109,740 PER MONTH Use the linear regression results to derive a total cost equation for High-End Lifts, Inc. Follow this format: COST EQUATION = TC = FC + (VC per unit x Weighted-Average # of Units). Leave WA# of units as an unknown varaiable. Directions: Complete this table by forwarding the amounts that are given on Task #2.1 IS for each line item, starting with advertising expense. The COGS line has been done for you as an example.. FC per month + (VC per Units x | TC = TC = WA# of units) leave blank Check D17 = $45,943 Check G17 = $257,872 If the budgeted weighted average # of units sold in January of year 5 = 23 units, derived budgeted total costs using the cost equation derived above. TC = FC per month + (VC per Units X WA# of units) Check C30 = $1,306,504.60 TASK #3: CONTRIBUTION MARGIN INCOME STATEMENT High-End Lifts, Inc. Contribution Margin Income Statement For the six-months ended, 4th year Per Unit Total % Cell D7 = Task #1 tab cell G61 Weighted Average Volume, All Units - 6 months 199.70 $ 73,623.26 Predicted Sales Revenue Predicted Variable Cost Predicted Contribution Margin #DIV/0! #DIV/0! #DIV/0! Cell C9 = Task #2.2, F6 Cell C10 = Task #2.2, F17 Check: Cell C11 = $5,597,613 6 months D13 (hint: make sure you calculate 6 months of fixed costs) Fixed Costs Predicted Operating Income (EBIT) #DIV/0! #DIV/0! Check D14 = $4,050,381 Operating Income (EBIT) on Task #3.1 IS - Cell C21 27.5% Check D19 = 0.00003% error Difference % Error % Error is insignificant; highly predictive equatic