Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 10.35E
High-low method. Wayne Mueller financial analyst at CELL Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters:
| Quarter | Machine-Hours | Utility Costs |
| 1 | 120,000 | $215,000 |
| 2 | 75,000 | 150,000 |
| 3 | 110,000 | 200,000 |
| 4 | 150,000 | 270,000 |
| 5 | 90,000 | 170,000 |
| 6 | 140,000 | 250,000 |
| 7 | 130,000 | 225,000 |
| 8 | 100,000 | 195,000 |
- 1. Estimate the cost function for the quarterly data using the high-low method.
- 2. Plot and comment on the estimated cost function.
- 3. Mueller anticipates that CELL will operate machines for 125,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Dallus wants to examine the behaviour of maintenance costs for budgeting purpose. The
following data on machine hours worked and maintenance costs for the past year are collected:
Month Machine Hours Maintenance Cost
January
18,000
February 15,000
March
12,750
21,000
April
May
June
11,880
14,500
July
19,000
August
14,880
September 10,000
October
13,360
November 16,600
December 18,800
$20,600
18,900
15,100
22,010
13,200
19,500
25,000
19,874
12,000
15,500
19,800
13,500
Required:
a. Use the high-low method to estimate the variable cost per machine hour and the fixed cost
per month.
b. Plot and comment on the estimated cost function.
C. Develop a formula to express the cost behaviour of ABC's maintenance costs.
d. According to the budget, the machine is expected to work 200,000 hours next year. How
much is the budgeted maintenance costs?
Crystal Mining has completed the following data to analyze utility cost:MonthMachine Hours Utility CostJanuary200P 300February325440March400480April410490May525620June680790July820840August900900Required:1.Use the least squaresmethod to develop a formula for budgeting utility cost. (Round off value of b to two decimal places and the value of a to nearest peso.2.Prepare flexible budget with separate variable and fixed categories for utility costs at 350, 500, and 600 machine hours.
High-low method. Wayne Mueller, financial analyst at CELL Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters:
Chapter 10 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ch. 10 - What two assumptions are frequently made when...Ch. 10 - Describe three alternative linear cost functions.Ch. 10 - What is the difference between a linear and a...Ch. 10 - High correlation between two variables means that...Ch. 10 - Name four approaches to estimating a cost...Ch. 10 - Describe the conference method for estimating a...Ch. 10 - Describe the account analysis method for...Ch. 10 - List the six steps in estimating a cost function...Ch. 10 - When using the high-low method, should you base...Ch. 10 - Describe three criteria for evaluating cost...
Ch. 10 - Define learning curve. Outline two models that can...Ch. 10 - Discuss four frequently encountered problems when...Ch. 10 - Prob. 10.13QCh. 10 - All the independent variables in a cost function...Ch. 10 - Multicollinearity exists when the dependent...Ch. 10 - HL Co. uses the high-low method to derive a total...Ch. 10 - A firm uses simple linear regression to forecast...Ch. 10 - In regression analysis, the coefficient of...Ch. 10 - A regression equation is set up, where the...Ch. 10 - What would be the approximate value of the...Ch. 10 - Estimating a cost function. The controller of the...Ch. 10 - Identifying variable-, fixed-, and mixed-cost...Ch. 10 - Various cost-behavior patterns. (CPA, adapted)....Ch. 10 - Matching graphs with descriptions of cost and...Ch. 10 - Account analysis, high-low. Stein Corporation...Ch. 10 - Account analysis method. Gower, Inc., a...Ch. 10 - Prob. 10.27ECh. 10 - Estimating a cost function, high-low method. Lacy...Ch. 10 - Linear cost approximation. Dr. Young, of Young and...Ch. 10 - Cost-volume-profit and regression analysis....Ch. 10 - Regression analysis, service company. (CMA,...Ch. 10 - High-low, regression. May Blackwell is the new...Ch. 10 - Learning curve, cumulative average-time learning...Ch. 10 - Learning curve, incremental unit-time learning...Ch. 10 - High-low method. Wayne Mueller financial analyst...Ch. 10 - High-low method and regression analysis. Market...Ch. 10 - High-low method; regression analysis. (CIMA,...Ch. 10 - Regression, activity-based costing, choosing cost...Ch. 10 - Interpreting regression results. Spirit...Ch. 10 - Cost estimation, cumulative average-time learning...Ch. 10 - Cost estimation, incremental unit-time learning...Ch. 10 - Regression; choosing among models. Apollo Hospital...Ch. 10 - Multiple regression (continuation of 10-42). After...Ch. 10 - Cost estimation. Hankuk Electronics started...Ch. 10 - Prob. 10.45PCh. 10 - Interpreting regression results, matching time...Ch. 10 - Purchasing department cost drivers, activity-based...Ch. 10 - Purchasing department cost drivers, multiple...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Wayne Mueller, financial analyst at CELL Corporation, is examining the behav- ior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters: Utility Costs $215,000 Quarter Machine-Hours 120,000 150,000 200,000 270,000 170,000 250,000 225,000 195,000 2 75,000 110,000 150,000 90,000 140,000 130,000 3 4 5 100,000 1. Estimate the cost function for the quarterly data using the high-low method. 2. Plot and comment on the estimated cost function. 3. Mueller anticipates that CELL will operate machines for 125,000 hours in quarter 9. Calculate the pre- dicted utility costs in quarter 9 using the cost function estimated in requirement 1.arrow_forward! Required information [The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month $ 57,000 $ 36,000 Employee salaries and wages Travel expenses Other expenses Variable Element per Customer Served $ 5,800 $ 1,800 $ 950 When preparing its planning budget the company estimated that it would serve 35 customers per month; however, during May the company actually served 40 customers. Actual Total for May $ 217,000 $ 128,100 $ 35,300 $ 34,400 15. What activity variances would Adger report with respect to each of its expenses for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no…arrow_forwardKen Howard, financial analyst at KMW Corporation, is examining the behavior of quarterly maintenance costs for budgeting purposes. Howard collects the following data on machine hours worked and maintenance costs for the past 12 quarters: Quarter Machine-Hours 20,000 24,000 22,000 26,000 18,000 ITT Maintenance Costs $ 41,000 48,000 44,000 52,000 38,000 47,000 43,000 51,000 21,000 42,000 25,000 49,000 11 28,000 56,000 12 27,000 57,000 1234567890=2 23,000 21,000 25,000 Required: 1. Estimate the cost function for the quarterly data using the high-low method. 2. Apply Excel to estimated cost function based on the regression method. Plot the results and explain the main contents of the regression table. 3. Howard anticipates that KMW will operate machines for 30,000 hours in quarter 13. Calculate the predicted maintenance costs in quarter 13 using the cost function estimated in requirement 1 and requirement 2. Comment on the accuracy of both methods and which one you will select for future…arrow_forward
- i Required information [The following information applies to the questions displayed below] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month Variable Element per Customer Served Actual Total for May $ 6,600 $ 213,500 $ 62,000 $ 2,300 $ 141,100 $ 540 $ 15,700 $ 41,000 $ 38,900 When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 5. What activity variances would Adger report with respect to each of its expenses for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive…arrow_forwardUsing account analysis, Pymble Co. wishes to estimate employees' automobile expenses as a function of miles driven. Costs for the past quarter, during which 58,000 miles were driven, are classified as follows: Item Classification Cost $3,200 11,200 3,900 1,800 2,100 Fuel Variable Fixed Fixed Variable Fixed Depreciation Insurance Maintenance Parking Predict the total cost for the coming quarter for which the employees' auto travel budget would be 65,000 miles: $arrow_forwardRequired information [The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month Variable Element per Customer $ 70,000 Served $ 6,300 $ 1,700 Actual Total for May $ 49,000 $ 199,000 $ 127,300 $ 620 $ 18,000 $ 46,100 When preparing its planning budget, the company estimated it would serve 30 customers per month; however, during May the company actually served 35 customers. 5. What net operating income would appear in Adger's flexible budget for May? Net operating incomearrow_forward
- Botana Company constructed the following formula for its monthly utility cost. Total utility cost = $1,200 + ($8.10 × Labor hours) Assume that 775 labor hours are budgeted for the month of April. If Botana Company incurs 9,600 labor hours for the year, what would be the estimate of total utility cost?arrow_forward! Required information [The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month $ 57,000 $ 36,000 Variable Element per Customer Served $ 5,800 $ 1,800 $ 950 Spending variance Actual Total for May $ 217,000 $ 128, 100 $ 35,300 $ 34,400 When preparing its planning budget the company estimated that it would serve 35 customers per month; however, during May the company actually served 40 customers. 8. What is Adger's travel expenses spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)arrow_forward! Required information [The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month $ 57,000 $ 36,000 Variable Element per Customer Served $ 5,800 $ 1,800 $ 950 Revenue variance Actual Total for May $ 217,000 $ 128,100 $ 35,300 $ 34,400 When preparing its planning budget the company estimated that it would serve 35 customers per month; however, during May the company actually served 40 customers. 6. What is Adger's revenue variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)arrow_forward
- [The following information applles to the questions displayed below.] ABC Corporation Is a service company that measures Its output based on the number of customers served. The company provided the following fixed and varlable cost estimates that It uses for budgeting purposes and the actual results for May as shown below: Actual Total for May $ 223,500 $ 126,000 20,400 S.44,300 Fixed Element Variable Element per Month per Customer Served $6,100 $ 1,500 Revenue Employee salaries and wages Travel expenses other expenses $ 68,000 $ 47,000 When preparing Its plannlng budget the company estimated that It would serve 35 customers per month; however, during May the company actually served 40 customers. 14. What activity varlance would Adger report In May with respect to Its revenue? (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (I.e., zero varlance). Input all amounts as positive values.) Activity variancearrow_forwardRequired Information [The following information applies to the questions displayed below] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below. Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month Amount of other expenses $50,000 $36.000 $ 35,000 Variable Element per Customer Served $5,000 $1,100 $ 600 Actual Total for May $ 160,000 $ 88,000 When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 4. What amount of other expenses would be included in Aager's flexible budget for May? $ 19,000 $ 34,500 28arrow_forward! Required information [The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month $ 57,000 $ 36,000 Variable Element per Customer Served $ 5,800 $ 1,800 $ 950 Amount of travel expenses included in the flexible budget Actual Total for May $ 217,000 $ 128,100 When preparing its planning budget the company estimated that it would serve 35 customers per month; however, during May the company actually served 40 customers. 3. What amount of travel expenses would be included in Adger's flexible budget for May? $ 35,300 $ 34,400arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY