Month January February March April May June July August September October Number of Scans 40 85 100 150 200 110 260 Utilities Cost $4,250 6,300 7,000 10,400 14,000 8,500 16,000 11,700 15,100 13,500 160 210 180 Part 1 Using the high low method, estimate the fixed costs of utility per month and the variable costs of utilities per number of scans. Part 2 Using the cost equation from Part 1 complete the total cost of 200 scans? ED X fo B D G Month Number of Scans Utilities Cost 40 85 100 150 January February March April May June July August $4,250 6,300 7,000 10,400 14,000 8,500 16,000 + 11,700 200 110 260 160 September 210 15,100 13,500 180 October 12 13 Variable Cost per 14 Unit Total Fixed Cost 15 Cost Equation 16 17 14 Unit Total Fixed Cost 15 Cost Equation 16 17 18 19 Part 2 20 21 Total Cost 22 23 24 25 26 27 28 2 Question #1 Question #2 AutoSave CH Assignment=2 Templatexlsx - Protected View File Home Insert Draw Page Layout Formulas Data Review View Help O PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Ena HZ X f G H K B C D E Gallop Corporation Contribution Margin Income Statement For the Quarter Ended Sales 5 Less COGS (variable) 6 Less: Selling Expenses (variable) 7 Less: Adminstrative Expenses (variable) 8. Contribution Margin 9 10. Less Operating Expense 11 Less COGS (fixed) 12 Selling Expenses (fixed) + 13 Adminstrative Expenses (fixed) 12 | Net Income 15 16 17 18 19 20 21