(4 Questions, 10 Marks) Winslow Inc. operates a chain of shops. The company's chief executive officer is interested in accumulating some information on the utility costs incurred by the company. You have been asked to analyze the following twelve months' data. Month January February March April May June July August September October November December Utility Cost Number of Units $ 3,825 6,375 $ 3,975 6,630 S 4,238 6,800 $ 4,725 7,820 $ 4.800 8,330 $ 5,025 9,180 s 5,276 10,030 $ 5.250 9,520 $ 4,650 8,075 $ 4,575 7,650 $ 4,200 7,225 s 4,425 7,650 Question 8 (3 points) Using the high-low method calculate the variable rate for total utility costs. A Question 9 (2 points) Using the high-low method and variable rate entered above calculate the fixed MacBook esc 000 80 FI F2 F3 000 FA A # 3 $ 4 % 5 i N wy October November December $ $ $ 4,575 4,200 4,425 7,650 7,225 7,650 Question 8 (3 points) Using the high-low method calculate the variable rate for total utility costs. A Question 9 (2 points) Using the high-low method and variable rate entered above calculate the fixed cost for total utility costs. Question 10 (3 points) Using the method of least squares, your regression analysis produced an intercept of $1,300 and independent variable of 0.45. Using the results of the regression analysis calculate the total utility costs for 7,500 units. A Question 11 (2 points) The CEO would like to understand what the advantages and disadvantages of the method of least squares and the high-low method. Select all of the advantages of the high-low method from the list below. MacBook Air esc 0 200 DOO F1 F2 F3 F4 # $ % Time Limit: 3:00:00 Time Left:2:48:49 Sheikh Mahima: Attempt 1 Using the results of the regression analysis calculate the total utility costs for 7,500 units. Question 11 (2 points) The CEO would like to understand what the advantages and disadvantages of the method of least squares and the high-low method. Select all of the advantages of the high-low method from the list below. Uses all of the data points This method is objective Excludes outliers automatically Simple to calculate Uses only two data points Next Page Page 2 of 9 Submit Qulz 7 of 49 questions saved MacBook Air esc 20 000 31 FI F2 F3 F4 SF $ %