Question: for B please draw a scatter graph. i uploaded this question already amd it wasnt correct Goulburn, Incorporated produces parts for heavy equipment used in

for B please draw a scatter graph. i uploaded this question already amd it wasnt correct
for B please draw a scatter graph. i uploaded this question already
amd it wasnt correct 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

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, bu 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: 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. Answer is complete but not entirely correct. 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 Goulbum plant. Note: Round variable cost per unit to 2 decimal places. . Use the high-low estimation method to estimate the overhead cost behovior (fixed and variable components of cost) for the Goulbum plant. D. 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 machinc-hours will be worked next month. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Use a spreadsheet program to compute regression coefficients to deseribe the overhead cost equation. Note: Round "Cost per Machine Hour" to 2 decimal places. Round "Floed Costs" to the nearest whole dollar amount. 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. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Use the results of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Note: Round "Cost per Machine Hour" to 2 decimal places. Round your final answer to the nearest whole dollar amount. 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, bu 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: 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. Answer is complete but not entirely correct. 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 Goulbum plant. Note: Round variable cost per unit to 2 decimal places. . Use the high-low estimation method to estimate the overhead cost behovior (fixed and variable components of cost) for the Goulbum plant. D. 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 machinc-hours will be worked next month. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Use a spreadsheet program to compute regression coefficients to deseribe the overhead cost equation. Note: Round "Cost per Machine Hour" to 2 decimal places. Round "Floed Costs" to the nearest whole dollar amount. 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. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Use the results of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Note: Round "Cost per Machine Hour" to 2 decimal places. Round your final answer to the nearest whole dollar amount

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!