Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Factory Overhead Month Machine-Hours 1 39,300 $ 527,100 2 37,300 416,500 3 30,100 365,800 4 42,400 498,200 5 50,600 590,700 6 45,500 503,400 7 42,400 476,900 8 62,100 702,400 9 36,300 425,300 10 53,700 661,000 11 52,700 616,700 12 36,300 490,500 13 59,900 693,000 14 58,900 654,700 15 45,500 580,000 16 39,300 527,900 17 55,800 683,400 18 50,600 613,700 19 60,900 669,500 20 49,600 619,100 21 53,700 672,100 22 29,100 445,000 23 59,900 692,400 24 58,900 718,500 Required: a. Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable components of cost) for the Goulburn plant. b. Prepare a scattergraph showing the overhead costs plotted against the machine-hours. c. Use a spreadsheet program to compute regression coefficients to describe the overhead cost equation. d. Use the results of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Complete this question by entering your answers in the tabs below. Required A Required C Required D Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable components of cost) for the Goulburn plant. Note: Round variable cost per unit to 2 decimal places. Overhead costs = per Machine hour x Machine-hours