Goulburn, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part

common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager, who has just

been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions

with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is

machine$-$hours.

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:

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.

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.