Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 6.A, Problem 6P
Least-Square. Regression; Scattergraph; Comparison of Activity Bases
The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company’s cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formula .The production superintendent disagrees, she thinks that direct labor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information:
Required:
1. Using torn mined as the independent variable, prepare a scattergraph that plots tons mined on the horizontal axis and utilities cost on the vertical axis Using the least-squares regression method, estimate the variable utilities cost per ton mined and the total fixed utilities cost per quarter. Express these estimates in the form Y = a + bX.
2. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor-hours on the horizontal axis and utilities cost on the vertical axis. Using the least-squares regression method, estimate the variable utilities cost per direct labor-hour and the total fixed utilities cost per quarter. Express these estimates in the form Y = a+ bX.
3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilities cost?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Least-Squares Regression; Scattergraph; Comparison of Activity Bases
The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company’s cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formula. The production superintendent disagrees; she thinks that direct labor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information:
Required:
1. Using tons mined as the independent variable, prepare a scattergraph that plots tons mined on the horizontal axis and utilities cast on the vertical axis. Using the least-squares regression method, estimate the variable utilities cost per ton mined and the total fixed utilities cost per quarter. Express these estimates in the form Y = a + bX.
2. Using direct…
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 analysis
Describe how total variable costs and unit variable costs behave with changes in the level of activity.
Describe the behavior of (a) total fixed costs and (b) unit fixed costs as the level of activity increases.
In applying the high-low method of cost estimation, how is the total fixed cost estimated?
An examination of the accounting records of Larredo Company disclosed a high contribution margin ratio and production at a level below maximum capacity. Based on this information, suggest a likely means of improving operating income.
If the unit cost of direct materials is decreased, what effect will this change have on the break-even point?
What does operating leverage measure, and how is it computed?
Chapter 6 Solutions
Introduction To Managerial Accounting
Ch. 6.A - The Cheyenne Hotel in Big Sky, Montana, has...Ch. 6.A - Least-Squares Regression LOS11 Bargain Rental Car...Ch. 6.A - Prob. 3ECh. 6.A - Archer Company is a wholesaler of custom-built...Ch. 6.A - George Caloz&Freres, located in Grenchen,...Ch. 6.A - Least-Square. Regression; Scattergraph; Comparison...Ch. 6.A - Cost Behaviour; High4æw Method; Contribution...Ch. 6.A - Nova Company’s total overhead cost at various...Ch. 6.A - High-Low Method; Contribution Format Income...Ch. 6.A - Least-Squares Regression Method; Scattergraph;...
Ch. 6.A - Mixed Cost Analysis and the Relevant Range LOS-10...Ch. 6.A - Prob. 12PCh. 6 - What is the meaning of contribution margin ratio?...Ch. 6 - Prob. 2QCh. 6 - In all respects, Company A and Company B are...Ch. 6 - What is the meaning of operating leverage?Ch. 6 - What is the meaning of break-even point?Ch. 6 - In response to a request from your immediate...Ch. 6 - What is the meaning of margin of safety?Ch. 6 - Prob. 8QCh. 6 - Explain how a shift in the sales mix could result...Ch. 6 - The Excel worksheet form that appears be1o is to...Ch. 6 - The Excel work sheet from that appears below is to...Ch. 6 - Prob. 3AECh. 6 - The Excel worksheet form that appears be1o is to...Ch. 6 - Prob. 5AECh. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Prob. 11F15Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - The Effect of Cha noes ¡n Activity on Net...Ch. 6 - Prob. 2ECh. 6 - Prepare a Profit Graph L062 Jaffre Enterprises...Ch. 6 - Computing and Using the CM Ratio L063 Last month...Ch. 6 - Changes in Venable Costs, Fixed Costs, Selling...Ch. 6 - Prob. 6ECh. 6 - Lin Corporation has a single product 1ose selling...Ch. 6 - Compute the Margin of Safety LO6-7 Molander...Ch. 6 - Compute and Use the Degree 01 Operating Leverage...Ch. 6 - Prob. 10ECh. 6 - Missing Data; Basic CVP Concepts L061, L069 Fill...Ch. 6 - Prob. 12ECh. 6 - Change in selling price, Sales Volume, Variable...Ch. 6 - Prob. 14ECh. 6 - Operating Leverage 1061. 1068 Magic Realm, Inc.,...Ch. 6 - Prob. 16ECh. 6 - Break-Even and Target Profit Analysis 1064, 1066,...Ch. 6 - Break-Even and Target Profit Analysis; Margin of...Ch. 6 - Prob. 19PCh. 6 - Prob. 20PCh. 6 - Prob. 21PCh. 6 - Prob. 22PCh. 6 - CVP Applications; Contribution Margin Ratio:...Ch. 6 - Break-Even and Target Profit Analysis LO6-6, L066...Ch. 6 - Prob. 25PCh. 6 - Prob. 26PCh. 6 - Prob. 27PCh. 6 - Sales Mix; Commission Structure; Multiproduct...Ch. 6 - Changes in Cost Structure; Break-Even Analysis;...Ch. 6 - Graphing; Incremental Analysis; Operating Leverage...Ch. 6 - Interpretive Questions on the CVP Graph L062, L065...
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
- Explain how a plantwide overhead rate, using a unit-based driver, can produce distorted product costs. In your answer, identify two major factors that impair the ability of plantwide rates to assign cost accurately.arrow_forwardLarsen, Inc., produces two types of electronic parts and has provided the following data: There are four activities: machining, setting up, testing, and purchasing. Required: 1. Calculate the activity consumption ratios for each product. 2. Calculate the consumption ratios for the plantwide rate (direct labor hours). When compared with the activity ratios, what can you say about the relative accuracy of a plantwide rate? Which product is undercosted? 3. What if the machine hours were used for the plantwide rate? Would this remove the cost distortion of a plantwide rate?arrow_forwardBecause of high production-changeover time and costs, a director of manufacturing must convince management that a proposed manufacturing method reduces costs before the new method can be implemented. The current production method operates with a mean cost of $220 per hour. A research study will measure the cost of the new method over a sample production period. Develop the null and alternative hypotheses most appropriate for this study. Comment on the conclusion when H0 cannot be rejected. Comment on the conclusion when H0 can be rejected.arrow_forward
- (Appendix 3A) Scattergraph, High-Low Method, Method of Least Squares, Use of Judgment The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed. The costs must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past 8 quarters have been collected: Note: For the following requirements, round the fixed cost to the nearest dollar, round the variable rates to three decimal places, and the R2 to two decimal places. Required: 1. Prepare a scattergraph by plotting power costs against machine hours. Does the scatter-graph show a linear relationship between machine hours and power cost? 2. Using the high and low points (i.e., the high-low method), compute a power cost formula. (Note: Round answers to three decimal places.) 3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination. 4. CONCEPTUAL CONNECTION Rerun the regression, and drop the point (20,000, 26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?arrow_forwardContinuous 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_forwardVariable and Fixed Costs, Cost Formula, High-Low Method Li Ming Yuan and Tiffany Shaden are the department heads for the accounting department and human resources department, respectively, at a large textile firm in the southern United States. They have just returned from an executive meeting at which the necessity of cutting costs and gaining efficiency has been stressed. After talking with Tiffany and some of her staff members, as well as his own staff members, Li Ming discovered that there were a number of costs associated with the claims processing activity. These costs included the salaries of the two paralegals who worked full time on claims processing, the salary of the accountant who cut the checks, the cost of claims forms, checks, envelopes, and postage, and depreciation on the office equipment dedicated to the processing. Some of the paralegals time appears to vary with the routine processing of uncontested claims, but considerable time also appears to be spent on the claims that have incomplete documentation or are contested. The accountants time appears to vary with the number of claims processed. Li Ming was able to separate the costs of processing claims from the costs of running the departments of accounting and human resources. He gathered the data on claims processing cost and the number of claims processed per month for the past 6 months. These data are as follows: Required: 1. Classify the claims processing costs that Li Ming identified as variable and fixed. 2. What is the independent variable? The dependent variable? 3. Use the high-low method to find the fixed cost per month and the variable rate. What is the cost formula? 4. CONCEPTUAL CONNECTION Suppose that an outside company bids on the claims processing business. The bid price is 4.60 per claim. If Tiffany expects 75,600 claims next year, should she outsource the claims processing or continue to do it in-house?arrow_forward
- Lean manufacturing uses value streams to produce a family of products that require the same manufacturing sequence. Value-stream costing is an approach often used to determine the unit product costs in a lean manufacturing environment. Which of the following best describes how unit costs are calculated using value-stream costing? a. Value stream costs divided by units shipped b. Value stream costs divided by units produced c. (Total prime costs + overhead costs assigned to the value stream using a plantwide rate) divided by units produced d. Activity-based costing assignments within the value streamarrow_forwardThe controller of the South Charleston plant of Ravinia, Inc., monitored activities associated with materials handling costs. The high and low levels of resource usage occurred in September and March for three different resources associated with materials handling. The number of moves is the driver. The total costs of the three resources and the activity output, as measured by moves for the two different levels, are presented as follows: Required: 1. Determine the cost behavior formula of each resource. Use the high-low method to assess the fixed and variable components. 2. Using your knowledge of cost behavior, predict the cost of each item for an activity output level of 9,000 moves. 3. Construct a cost formula that can be used to predict the total cost of the three resources combined. Using this formula, predict the total materials handling cost if activity output is 9,000 moves. In general, when can cost formulas be combined to form a single cost formula?arrow_forwardWhich of the following is a reason a company would implement activity-based costing? A. The cost of record keeping is high. B. The additional data obtained through traditional allocation are not worth the cost. C. They want to improve the data on which decisions are made. D. A company only has one cost driver.arrow_forward
- Abernathy, Inc., produces two different generators and is concerned about their quality. The company has identified the following quality activities and costs associated with the two products: Required: 1. Calculate the quality cost per unit for each product, and break this unit cost into quality cost categories. Which of the two seems to have the lowest quality? 2. How might a manager use the unit quality cost information?arrow_forwardThe cost behavior patterns below are lettered A through H. The vertical axes of the graphs represent total dollars of expense, and the horizontal axes represent production in units, machine hours, or direct labor hours. In each case, the zero point is at the intersection of the two axes. Each graph may be used no more than once. Required: Select the graph that matches the lettered cost described here. a. Depreciation of equipmentthe amount of depreciation charged is computed based on the number of machine hours that the equipment was operated. b. Electricity billflat fixed charge, plus a variable cost after a certain number of kilowatt hours are used. c. City water billcomputed as follows: d. Depreciation of equipmentthe amount is computed by the straight-line method. e. Rent on a factory building donated by the citythe agreement calls for a fixed fee payment, unless 200,000 labor hours are worked, in which case no rent need be paid. f. Salaries of repair workersone repair worker is needed for every 1,000 machine hours or less (i.e., 0 to 1,000 hours requires one repair worker, 1,001 to 2,000 hours requires two repair workers, etc.).arrow_forwardAssume you are the department B manager for Marleys Manufacturing. Marleys operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only o department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. (Hint: It may be helpful to perform a vertical analysis.)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
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY