COST ACCOUNTING
16th Edition
ISBN: 9781323169261
Author: Horngren
Publisher: PEARSON C
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
!
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…
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
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
28
H3.
Show proper step by step calculation
Chapter 10 Solutions
COST ACCOUNTING
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
- ! 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 Activity 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. 14. What activity variance would Adger report in May with respect to its revenue? (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…arrow_forwardes 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 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 $ 50,000 $ 36,000 Variable Element per Customer Served $ 5,000 $ 1,100 Actual Total for May $ 160,000 $ 88,000 $ 600 $ 19,000 $ 34,500 When preparing its planning budget, the company estimated it would serve 30 customers per month; however, during May the company actually served 35 customers. Required: 1. What amount of revenue would be included in Adger's flexible budget for May?arrow_forwardPlease help mearrow_forward
- (J)arrow_forwardbh.2arrow_forwardUse the information given below to calculate each of the following independently 3.1 Expected total Marginal Income and Net Profit/Loss Slumber Limited manufactures beds. The following information was extracted from the budget for 2024:Expected production and sales (units) 1 200Selling price per bed R6 000Direct materials cost per bed R1 700Direct labour cost per bed R860Variable manufacturing overheads cost per bed R320Fixed manufacturing overheads cost R1 084 800Sales commission (as a percentage of the selling price) 20%Fixed administrative and selling costs R720 000 PLEASE PUT THE ANSWER IN RANDSarrow_forward
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:arrow_forwardUsing High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. 2. Calculate total fixed labor cost for the year. 3. Calculate total labor cost for the coming year. Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:arrow_forwardSales Revenue Approach, Variable Cost Ratio, Contribution Margin Ratio Arberg Companys controller prepared the following budgeted income statement for the coming year: Required: 1. What is Arbergs variable cost ratio? What is its contribution margin ratio? 2. Suppose Arbergs actual revenues are 30,000 more than budgeted. By how much will operating income increase? Give the answer without preparing a new income statement 3. How much sales revenue must Arberg earn to break even? Prepare a contribution margin income statement to verify the accuracy of your answer. 4. What is Arbergs expected margin of safety? 5. What is Arbergs margin of safety if sales revenue is 380,000?arrow_forward
- Variable Cost Ratio, Contribution Margin Ratio Chillmax Company plans to sell 3,500 pairs of shoes at 60 each in the coming year. Unit variable cost is 21 (includes direct materials, direct labor, variable factory overhead, and variable selling expense). Fixed factory overhead is 30,000 and fixed selling and administrative expense is 48,000. Required: 1. Calculate the variable cost ratio. 2. Calculate the contribution margin ratio. 3. Prepare a contribution margin income statement based on the budgeted figures for next year. In a column next to the income statement, show the percentages based on sales for sales, total variable cost, and total contribution margin.arrow_forwardUsing High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Speedy Petes above. Assume that this information was used to construct the following formula for monthly delivery cost. TotalDeliveryCost=41,850+(12.00NumberofDeliveries) Required: Assume that 3,000 deliveries are budgeted for the following month of January. Use the total delivery cost formula for the following calculations: 1. Calculate total variable delivery cost for January. 2. Calculate total delivery cost for January.arrow_forwardSuppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What is the cost formula for monthly shipping cost? Identify the independent variable, the dependent variable, the fixed cost per month, and the variable rate.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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