Voyageurs recently hired an NYU graduate, from the BS/MS in accounting program, to improve its cost system and decisionmaking process. The talented graduate suggested to use the leastsquare regression method instead of the highlow method.

Using Excel or a similar application, run the leastsquare regression on the above data. You may copy and paste the data into Excel or download the provided Excel file from Tests&Quizzes. Answer the following question using your leastsquare regression.

6. f) What is the slope coefficient?

7. g) What is the constant (intercept) ?

8. h) What is the estimated cost function?

9. i) What is the estimated total cost at an operating level of 2,000 units?

10. j) What is the estimated total cost at an operating level of 77,000 units?

11. k) How well does the regression explain the cost variation (explain you answer)?

12. l) Explain the advantage and disadvantage of the highlow method?

13. m) Explain the advantage and disadvantage of the leastsquare regression method?

14. n) Which method do you prefer? Why?

this is the regression data

2. (30 points) Voyageurs Company collected the following data to assess certain costs that cannot be easily identified as either fixed or variable. Month January February March April May June July August September October November December Cost 67,120 67,130 68,930 53,090 56,880 64,400 59,930 58,300 71,310 67,450 56,890 57,800 Units 1,860 2,140 2,040 1,520 1,640 1,700 1,540 1,400 2,180 2,100 1,420 1,400 Voyageurs decided to use high-low method to estimate its cost function. Answer the following question using the high-law method. show your calculation. Units Month Cost January 67,120 February 67,130 March 68,930 April 53,090 | May 56,880 June 64,400 July 59,930 August 58,300 Septembe 71,310 October 67,450 November 56,890 December 57,800 1,860 2,140 2,040 1,520 1,640 1,700 1,540 1,400 2,180 2,100 1,420 1,400 2. (30 points) Voyageurs Company collected the following data to assess certain costs that cannot be easily identified as either fixed or variable. Month January February March April May June July August September October November December Cost 67,120 67,130 68,930 53,090 56,880 64,400 59,930 58,300 71,310 67,450 56,890 57,800 Units 1,860 2,140 2,040 1,520 1,640 1,700 1,540 1,400 2,180 2,100 1,420 1,400 Voyageurs decided to use high-low method to estimate its cost function. Answer the following question using the high-law method. show your calculation. Units Month Cost January 67,120 February 67,130 March 68,930 April 53,090 | May 56,880 June 64,400 July 59,930 August 58,300 Septembe 71,310 October 67,450 November 56,890 December 57,800 1,860 2,140 2,040 1,520 1,640 1,700 1,540 1,400 2,180 2,100 1,420 1,400