Managerial Accounting
null Edition
ISBN: 9781260195408
Author: Whitecotton
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 21E
Estimating Cost Behavior Using Least-Squares Regression and High-Low Method
Tempt Office Services and Supplies (TOSS) provides various products and services in the Tempt Research Park, home to numerous high-tech and bio-tech companies. Making color copies is one of its most popular and profitable services. The controller performed a regression analysis of data from the Color Copy Department with the following results:
The regression output was based on the following data:
1. What is the variable cost per color copy for TOSS?
2. What is the used cost for the Color Copy Department?
3. Based on the regression output obtained by the controller, what cost formula should be used to estimate future total costs for the Color Copy Department?
4. How accurate will the cost formula developed in requirement 3 be at predicting the total cost for the Color Copy Department?
5. Use the high-low method to estimate the variable and fixed costs for the Color Copy Department. What cost formula should be used based on your analysis?
6. If 22,100 copies are made during January, what is the total cost predicted by each method?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Method of Least Squares, Developing and Using the Cost Formula
The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received:
Intercept
147,400
Slope
210
The cost driver used was number of parts inspected.
Required:
1. What is the cost formula?
Total cost of receiving = $ + ( $ × )
2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month.
Independent variable
Dependent variable
Variable rate per professional hour
per part inspected
Fixed cost per month
3. Using the cost formula, predict the cost of receiving for a month in which 6,800 parts are inspected.
Total cost of receiving = $
Identifying the Parts of the Cost Formula;…
Method of Least Squares, Developing and Using the Cost Formula
The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received:
Intercept
175,600
Slope
455
The cost driver used was number of parts inspected.
Required:
1. What is the cost formula?
Total cost of receiving = $ + ( $ × )
2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month.
Independent variable
Dependent variable
Variable rate per professional hour
per part inspected
Fixed cost per month
3. Using the cost formula, predict the cost of receiving for a month in which 7,200 parts are inspected.
Total cost of receiving = $
Almed Products has determined that the number of machine hours worked (MH) drives the amount of manufacturing overhead incurred (MOH). On the basis of this relationship, a staff analyst has constructed the following regression equation:
MOH = 240,000 + 8MH
Which of the choices correctly depicts the nature of Almed’s variables?
Dependent Independent
A. MOH MOH
B. MOH MH
C. MH MOH
D. MH MH
E. 8 240,000
Multiple Choice
Choice A
Choice B
Choice C
Choice D
Choice E
Chapter 5 Solutions
Managerial Accounting
Ch. 5 - Define each of the following terms variable cost,...Ch. 5 - Prob. 2QCh. 5 - Prob. 3QCh. 5 - Prob. 4QCh. 5 - Prob. 5QCh. 5 - Describe the three methods used to estimate cost...Ch. 5 - Prob. 7QCh. 5 - Prob. 8QCh. 5 - Prob. 9QCh. 5 - Prob. 10Q
Ch. 5 - Prob. 11QCh. 5 - Prob. 12QCh. 5 - Prob. 13QCh. 5 - Prob. 14QCh. 5 - Which of the following increases when activity...Ch. 5 - Prob. 2MCCh. 5 - Prob. 3MCCh. 5 - Consider the following information for a local...Ch. 5 - Prob. 5MCCh. 5 - Prob. 6MCCh. 5 - Prob. 7MCCh. 5 - Prob. 8MCCh. 5 - Prob. 9MCCh. 5 - Hathaway Corp, manufactures garden hoses. Last...Ch. 5 - Identifying Cost Behavior Heather Oak is trying to...Ch. 5 - Prob. 2MECh. 5 - Defining Cost Behavior Match each of the following...Ch. 5 - Prob. 4MECh. 5 - Defining Terms for the High-Low Method Indicate...Ch. 5 - Prob. 6MECh. 5 - Prob. 7MECh. 5 - Prob. 8MECh. 5 - Prob. 9MECh. 5 - Prob. 10MECh. 5 - Prob. 11MECh. 5 - Prob. 12MECh. 5 - Prob. 13MECh. 5 - Prob. 14MECh. 5 - Prob. 15MECh. 5 - Prob. 16MECh. 5 - Compare full absorption costing to variable...Ch. 5 - Identifying Cost Behavior Patterns Steve...Ch. 5 - Prob. 2ECh. 5 - Prob. 3ECh. 5 - Prob. 4ECh. 5 - Estimating Cost Behavior Using High-Low Method...Ch. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - Estimating Cost Behavior Using Scattergraph and...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Comparing High-Low Method and Least-Squares...Ch. 5 - Preparing Contribution Margin Income Statement...Ch. 5 - Determining Cost Behavior, Preparing Contribution...Ch. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Comparing Full Absorption Costing and Variable...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Prob. 1.1GAPCh. 5 - Prob. 1.2GAPCh. 5 - Prob. 1.3GAPCh. 5 - Prob. 1.4GAPCh. 5 - Prob. 1.5GAPCh. 5 - Prob. 1.6GAPCh. 5 - Prob. 2.1GAPCh. 5 - Prob. 2.2GAPCh. 5 - Prob. 2.3GAPCh. 5 - Prob. 2.4GAPCh. 5 - Prob. 2.5GAPCh. 5 - Prob. 2.6GAPCh. 5 - Prob. 2.7GAPCh. 5 - Prob. 3.1GAPCh. 5 - Prob. 3.2GAPCh. 5 - Prob. 3.3GAPCh. 5 - Prob. 3.4GAPCh. 5 - Prob. 3.5GAPCh. 5 - Prob. 4.1GAPCh. 5 - Prob. 4.2GAPCh. 5 - Prob. 4.3GAPCh. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Prob. 5.3GAPCh. 5 - Prob. 6.1GAPCh. 5 - Prob. 6.2GAPCh. 5 - Prob. 6.3GAPCh. 5 - Prob. 6.4GAPCh. 5 - Prob. 6.5GAPCh. 5 - Prob. 6.6GAPCh. 5 - Prob. 1.1GBPCh. 5 - Prob. 1.2GBPCh. 5 - Prob. 1.3GBPCh. 5 - Prob. 1.4GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 1.6GBPCh. 5 - Prob. 2.1GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 2.3GBPCh. 5 - Prob. 2.4GBPCh. 5 - Prob. 2.5GBPCh. 5 - Prob. 2.6GBPCh. 5 - Prob. 2.7GBPCh. 5 - Prob. 3.1GBPCh. 5 - Prob. 3.2GBPCh. 5 - Prob. 3.3GBPCh. 5 - Prob. 3.4GBPCh. 5 - Prob. 3.5GBPCh. 5 - Prob. 4.1GBPCh. 5 - Prob. 4.2GBPCh. 5 - Prob. 4.3GBPCh. 5 - Prob. 5.1GBPCh. 5 - Prob. 5.2GBPCh. 5 - Prob. 5.3GBPCh. 5 - Prob. 6.1GBPCh. 5 - Prob. 6.2GBPCh. 5 - Prob. 6.3GBPCh. 5 - Prob. 6.4GBPCh. 5 - Prob. 6.5GBPCh. 5 - Prob. 6.6GBP
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
- Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?arrow_forwardUsing the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?arrow_forwardThe controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Multiple regression was run on the above data; the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 total purchase orders and 45 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders and 580 nonstandard orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 2? (Round your answers to the nearest dollar.)arrow_forward
- Continuous improvement is the governing principle of a lean accounting system. Following are several performance measures. Some of these measures would be associated with a traditional standard-costing accounting system, and some would be associated with a lean accounting system. a. Materials price variances b. Cycle time c. Comparison of actual product costs with target costs d. Materials quantity or efficiency variances e. Comparison of actual product costs over time (trend reports) f. Comparison of actual overhead costs, item by item, with the corresponding budgeted costs g. Comparison of product costs with competitors product costs h. Percentage of on-time deliveries i. First-time through j. Reports of value- and non-value-added costs k. Labor efficiency variances l. Days of inventory m. Downtime n. Manufacturing cycle efficiency (MCE) o. Unused (available) capacity variance p. Labor rate variance q. Using a sister plants best practices as a performance standard Required: 1. Classify each measure as lean or traditional (standard costing). If traditional, discuss the measures limitations for a lean environment. If it is a lean measure, describe how the measure supports the objectives of lean manufacturing. 2. Classify the measures into operational (nonfinancial) and financial categories. Explain why operational measures are better for control at the shop level (production floor) than financial measures. Should any financial measures be used at the operational level? 3. Suggest some additional measures that you would like to see added to the list that would be supportive of lean objectives.arrow_forwardGadell Farms produces venison sausage that is distributed to grocery stores throughout the Southeast. They have collected this shipping cost data: Prepare a scatter graph of the shipping data. Plot cost on the vertical axis and tons produced on the horizontal axis. Is the relationship between packaging costs and tons produced approximately linear? Draw a straight line through the scatter graph. Using the high-low method, estimate the cost formula for Gadell Farms packaging costs. The least-squares regression method was used and the analysis resulted in this cost equation: Y= 1650 + 78.57x. Comment on the accuracy of your high-low method estimation. What would you estimate packaging costs to be if Gadell Farms shipped 10 tons in a single month? Use the cost formula you obtained in part B. Comment on how accurately this is reflected by the scatter graph you constructed. What factors other than number of tons produced do you think could affect Gadell Farms packaging expense? Explain.arrow_forwardEvaluating selling and administrative cost allocations Gordon Gecco Furniture Company has two major product lines with the following characteristics: Commercial office furniture: Few large orders, little advertising support, shipments in full truckloads, and low handling complexity Home office furniture: Many small orders, large advertising support, shipments in partial truckloads, and high handling complexity The company produced the following profitability report for management: The selling and administrative expenses are allocated to the products on the basis of relative sales dollars. Evaluate the accuracy of this report and recommend an alternative approach.arrow_forward
- a) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? c) Prepare the scatter diagram, clearly showing any outliers. d) Using the line of best-fit, determine the company’s fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.) e) In view of the department’s cost behavior pattern, which of the two methods appear more appropriate? Explain your answerarrow_forwardAnalysis of Regression Results Wang Manufacturing uses regression analysis to predict manufacturing overhead costs based on direct labor hours and/or machine hours and has developed thethree following regression equations:Regression 1 Regression 2 Regression 3SE 33,844 45,383 31,044R-squared 0.55 0.35 0.58t-values:Direct labor hours 2.3 1.9Machine hours 1.1 0.8Required Which regression would you choose and why?arrow_forwardTom uses his computer to calculate the following regression formula:Weekly total costs = $18,791 + ($19.97 * Number of orders per week) Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Is the cost function estimated using the high-low method a close approximation of the cost function estimated using the regression method? Explain briefly.arrow_forward
- The Connors Company has assembled the following data pertaining to certain costs that cannot beeasily identified as either fixed or variable. Connors Company has heard about a method of measuringcost functions called the high-low method and has decided to use it in this situation.A company has heard about a method of measuring cost functions called the regression analysis and hasdecided to use it in this situation.Cost Hours$23,000 5,000$26,000 6,450$34,600 7,650$42,000 10,000$38,000 9,350What is the estimated total cost at an operating level of 9,000 hours?A) $34,200B) $38,200C) $41,400D) $37,800 Work question #7 using regression analysisarrow_forward1) Determine the variable cost per unit and the fixed cost using the high-low method. 2) What is the equation of the total mixed cost function? 3) Based on the High-Low method, what is the total production costs if 6,500 units are produced?4) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2 cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the yaxis.5) Using the line of best-fit, determine the company’s fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.) Answer all please and thanks.arrow_forwardCourse Objectives: Compute sales units given operating income, selling price and variable cost per unit. Prepare a contribution margin income statement, clearly showing contribution Use CVP analysis to compute breakeven point and margin of safety Analyze the impact which changes in sales volume and total fixed costs will have on the breakeven point, margin of safety and operating income Explain the impact of errors such as the omission of fixed on the decision making process. Darius Manufacturing Company manufactures and sells parts for various musical gadgets. The business earned Operating Income of $420,000 in 2018, when selling price per unit was $200 and the president of Darius is under pressure to increase operating income in 2019 and is therefore considering the implementation of strategies geared at increasing revenues. Data for variable cost per unit and total fixed costs were as follows: Variable expenses per unit: Direct Material $20…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License