ABC produces one product. The following data shows the number of units of product made in the first few months of last year and the total costs incurred during the month: Month Units Total Costs January 750 $ 60,000 February 580 $ 49,000 March 4500 $ 45,000 April 710 $ 64,000 Which of the three quantitative methods mentioned in Chapter 6 (a scattergraph; high-low method; linear regression) is likely to yield the most accurate estimate of the breakdown between variable and fixed costs for this data set? (Briefly explain why.)

ABC produces one product. The following data shows the number of units of product made in the first few months of last year and the total costs incurred during the month: Month Units Total Costs January 750 $ 60,000 February 580 $ 49,000 March 4500 $ 45,000 April 710 $ 64,000 Which of the three quantitative methods mentioned in Chapter 6 (a scattergraph; high-low method; linear regression) is likely to yield the most accurate estimate of the breakdown between variable and fixed costs for this data set? (Briefly explain why.)

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter2: Basic Cost Management Concepts

Section: Chapter Questions

Problem 21E: Ellerson Company provided the following information for the last calendar year: During the year,...

See similar textbooks

Similar questions

Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,200 Jan. 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $43, 200 4,800 $ 3,600 $ $ $ 684.65 Average 400 Average cost per hour a (intercept) b (coefficient) 9.00 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105 At 400 hours of activity, Armer management can be approximately two-thirds confident that the maintenance costs will be in the range of
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$150,000 + $10XDLH; R-square = 0.95]; [Y= $190,000 + $5xMhr; R-square = 0.11]; [Y=200,000+2Q; R-square=0.52]. Based on this information, which cost driver do you recommend? Select one: O a. Machine hours (Mhr) O b. Direct labor hours (DLH) O c. None of them O d. Quantity produced (Q) O e. All cost drivers are the same
Using the highest and lowest levels of activity for the past year, the cost function representing maintenance costs (y) as a function of machine hours (x) was developed: y=439,000 + 14x. The lowest level of machine hours last year was 4000. The maintenance cost incurred at the highest and lowest level of machine hours were P551,000 and P495,000, respectively. If 5975 machine hours were used the following month, what amount maintenance cost can the company expect? a. 439,000b. 495,000c. 551,000d. 522,650
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$95,000 + $9×DLH; R-square = 0.90]; [Y= $120,000 + $5xMhr; R-square = 0.10]; [Y=190,000+2Q; R-square=0.55]. How much of the variations on the overhead costs is explained by %3D the machine hours (Mhr)? Select one: a. 55% b. None of the answers given c. 90% d. 45%
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr). and the third is based on quantity produced (Q). The results were: [Y-$150,000 + $10×DLH; R-square 0.95]: [Y= $190,000 $5xMhr. R-square = 0.11] [Y=200,000+20 R-square=0.52] Based on this information, %3D which cost driver do you recommend? Select one: O a. All cost drivers are the same Ob. None of them Oc Machine hours (Mhr) O d. Direct labor hours (DLH) Oe. Quantity produced (Q)
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$95,000 + $9×DLH; R-square = 0.85); [Y= $120,000 + $5xMhr; R-square = 0.15]; [Y=190,000+2Q; R-square=0.45]. How much of the variations on the overhead costs is explained by the direct labor hours (DLH)? Select one: O a. 55% O b. None of the answers given O c. 15% O d. 85% O e. 45%
Identify Cost Graphs The following cost graphs illustrate various types of cost behavior: Cost Graph One Cost Graph Two 0 Total Units Produced 0 Total Units Produced Cost Graph Three Cost Graph Four 0 Total Units Produced Total Units Produced
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$95,000+ $9×DLH; R-square Y=190,000+2Q; R-square-D0.55]. How much of the variations on the overhead costs is explained 0.90]; [Y= $120,000 $5xMhr; R-square = 0.10]; by the machine hours (Mhr)? Select one: O a. 90% Ob. None of the answers given Oc.45% O6.55% Oe. 10% Next page page
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr). and the third is based on quantity produced (Q). The results were: [Y=$95,000 + $9×DLH; R-square 0.90]; [Y= $120,000 + $5xMhr; R-square 0.10]: [Y=D190,000+2Q; R-square%3D0.55]. How much of the variations on the overhead costs is explained by the direct labor hours (DLH)? Select one: Oa 45% Ob. None of the answers given O c 10% O a. 5596 Ce. 90%,
Patterson Company produces wafers for integrated circuits. Data for the most recent year are provided: Expected Consumption Ratios Activity Driver Wafer B Wafer A Inserting and sorting process activities: Developing test programs 47,000 0.25 1. 2$ Engineering hours 0.75 Making probe cards Development hours 2. 68,000 0.10 0.90 Test hours 0.60 3. Testing products 700,000 0.40 Number of batches Setting up batches 0.55 4. 145,000 0.45 Engineering design Number of change orders 0.20 0.80 5. 93,000 Handling wafer lots Number of moves 500,000 6. 0.40 0.60 7. 0.30 Inserting dies 1,100,000 Number of dies 0.70 Procurement process activities: Purchasing materials Number of purchase orders 600,000 0.20 0.80 8. Unloading materials Number of receiving orders 0.35 0.65 9. 61,000 10. Inspecting materials 79,000 Inspection hours 0.60 0.40 Distance moved 0.50 0.50 11. Moving materials 400,000 12. Number of invoices 0.35 0.65 Paying suppliers 35,000 $ 3,828,000 Total activity cost Unit-level (plantwide)…
Company produces and sells rattan baskets. The number of drifts produced are the corresponding total production costs for six months, which are representatives for the year, are as follows: Using the least squares method, the variable production cost per unit is approximately a. P 5. b. P10. c. P0.27. d. P3.74.
Using the highest and lowest levels of activity for the past year, the cost function representing maintenance costs (y) as a function of machine hours (x) was developed: y=439,000 + 14x. The lowest level of machine hours last year was 4000. The maintenance cost incurred at the highest and lowest level of machine hours were P551,000 and P495,000, respectively. What was the highest level of activity last year that was used to develop the cost function? *