Goulburn, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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: Month 1 2 3 4 5 7 8 9 10 11 12 13 14 15 16 XER48656 17 18 19 20 21 22 23 24 Machine-Hours 40,000 38,000 30,800 43,100 51,300 46,200 43,100 62,800 37,000 54,400 53,400 37,000 60,600 59,600 46,200 40,000 56,500 51,300 61,600 50,300 54,400 29,800 60,600 59,600 Factory Overhead $ 527,800 417,200 366,500 498,900 591,400 504,100 477,600 714,650 426,000 661,700 617,400 491,200 693,700 655,400 580,700 528,600 684,100 614,400 670,200 619,800 672,800 445,700 693,100 719,200 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 Machine-hours Required A Required C > M ces b. Prepare a scattergraph showing the overhead costs plotted against the machine-hours. Instructions: 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. Enter the exact coordinates in the dialog box that appears to the right of the graph. 4. Click save. 5. To change coordinates already saved, click on a point already placed in the graph, and enter revised coordinates in the dialog box that opens. Factory Overhead (in dollars) 900000 800000 700000 600000 500000 400000 300000 200000 100000 025000 Goulburn, Incorporated 29000 33000 37000 41000 45000 49000 53000 Machine-Hours 57000 61000 Tools Month 1 65000 . Month 31 . Month 5 Month 2 . Month 4 . Month 6 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: Month 1 2 3 4 5 7 8 9 10 11 12 13 14 15 16 XER48656 17 18 19 20 21 22 23 24 Machine-Hours 40,000 38,000 30,800 43,100 51,300 46,200 43,100 62,800 37,000 54,400 53,400 37,000 60,600 59,600 46,200 40,000 56,500 51,300 61,600 50,300 54,400 29,800 60,600 59,600 Factory Overhead $ 527,800 417,200 366,500 498,900 591,400 504,100 477,600 714,650 426,000 661,700 617,400 491,200 693,700 655,400 580,700 528,600 684,100 614,400 670,200 619,800 672,800 445,700 693,100 719,200 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 Machine-hours Required A Required C > M ces b. Prepare a scattergraph showing the overhead costs plotted against the machine-hours. Instructions: 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. Enter the exact coordinates in the dialog box that appears to the right of the graph. 4. Click save. 5. To change coordinates already saved, click on a point already placed in the graph, and enter revised coordinates in the dialog box that opens. Factory Overhead (in dollars) 900000 800000 700000 600000 500000 400000 300000 200000 100000 025000 Goulburn, Incorporated 29000 33000 37000 41000 45000 49000 53000 Machine-Hours 57000 61000 Tools Month 1 65000 . Month 31 . Month 5 Month 2 . Month 4 . Month 6
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Goulburn, Inc. 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...
-
The following data were collected from a standard 0.505-in.-diameter test specimen of a copper alloy (l0 = 2.0 in.): After fracture, the total length was 3.014 in., and the diameter was 0.374 in....
-
The following data were collected from a 0.4-in.-deameter test specimen of polyvinyl chloride (l0 = 2.0 in.): After fracture, the total length was 2,09 in., and the diameter was 0.393 in. Plot the...
-
You and Sam have been in touch since the Palm Beach Business Development Luncheon, and he has expressed interest in your working on his business audit. The two of you make plans to meet for lunch,...
-
Marissas Sushi has the following data for the weekly payroll ending January 31: Employees are paid 112 times the regular hourly rate for all hours worked in excess of 40 hours per week. FICA taxes...
-
Your community has been the target of a terrorist attack. What extra steps do you take around the impact area because it was the site of a terrorist attack?
-
The account balances for the year ended December 31,2010, for Williams Industries are listed next: Requirements 1. Calculate the gross profit percentage for Williams Industries for the year. 2. The...
-
Suppose the following orders are received by an exchange for Cisco stock: Limit Order: Buy 200 shares at $25 Limit Order: Sell 200 shares at $26 Limit Order: Sell 100 shares at $25.50 Limit...
-
You are a full-time student at PSU working part-time at the Best Buy Store located at Cascade Station. The manager of your store wants you to identify potential customers on campus and sell Dell...
-
It is October 16, 2020, and you have just taken over the accounting work of China Moon Products, whose annual accounting period ends October 31. The company?s previous accountant journalized its...
-
How can the banking industry affect the environment through the direct impacts of its internal operations and business processes? The accounting systems that grew up alongside the industrial...
-
The transfer function is defined as the Fourier transform of the output of a system divided by the Fourier transform of the input to a system is equal to the sinusoidal transfer function for the...
-
What are the differences between frictional and structural unemployment? Should we be equally concerned with all types of unemployment? Would the same policies help alleviate both frictional and...
-
The autocorrelation function is an even function of \(\tau\) for a stationary process. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the statement...
-
What is the sectoral shifts hypothesis?
-
What is the intertemporal substitution hypothesis? Does this argument provide a convincing account of the cyclical trend in the unemployment rate?
-
During a titration, a known concentration of concentration. analyte; titrant Otitrant; analyte solvent solute solute: solvent Check Answer is added to a(n) of an unknown
-
Prove that if Σ an is absolutely convergent, then a. an
-
Brandon Technology makes two models of a specialized sensor for the aerospace industry. The difference in the two models relates to the required accuracy of the sensor. The Standard model is used for...
-
Fiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety have been fairly constant over the last three years. The managers at Fiske are planning for some...
-
Rogge Corporation makes a specialized sensor that is used in testing equipment. The company is organized in two divisions: Assembly and Shipping. Managers in both divisions are evaluated as profit...
-
Discuss the physical meaning of the small-signal circuit parameter \(r_{o}\).
-
Discuss, using the concept of a load line, how a simple common-source circuit can amplify a time-varying signal.
-
Sketch a simple source-follower amplifier circuit and discuss the general ac circuit characteristics (voltage gain and output resistance).
Study smarter with the SolutionInn App