Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 68P
(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
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?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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;
thus, they 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 eight quarters have been
collected:
2 25000
38000
3 30000 42500
4 22000 35000
5 21000 34000
6 18000 31400
7 24000 36000
8 28000 42000
Prompt
Work with your group members to answer the following prompts:
Prepare a scattergraph by plotting power costs against machine hours. Does the scattergraph show a linear relationship between machine hours and power cost? Use scattergraph method to draw a cost line that best fits the data and estimate the cost function.
Using high and low…
The Barnett Company has assembled the following data pertaining to certain costs that cannot be easily identified as either fixed or variable. Barnett Company has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation.
Cost Hours
$24,900 5,250
24,000 5,500
36,400 7,500
44,160 9,750
45,000 9,500
What is the estimated total cost at an operating level of 8,000 hours?
You have been asked by management to classify the costs associated with the start-up of this new product line. Using the cost information provided below, classify each cost under the appropriate heading according to the chart provided below. Note that some costs may be classified under more than one heading. For example, a cost may be a fixed cost and a period cost.
Name of cost
Variable Cost
Fixed Cost
Direct Materials
Direct Labor
Factory Overhead
Period Cost
Prime Cost
Conversion Cost
Carlson “New Product” Cost Information
Cost
Amount
Cost Type
Depreciation on Building (annual)
$ 10,000
Direct Labor Cost (per unit)
$ 75
Direct Materials Cost (per unit)
$ 60
Factory Utilities (per unit)
$ 8
Indirect Materials (per unit)
$ 4
Interest on Investments (annual)
$3,000
Machinery Rental (monthly)
$ 6,000
Marketing (annual)
$ 35,000
Rent from Tenant (annual)
$40,000…
Chapter 3 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
Ch. 3 - Prob. 1DQCh. 3 - What is a driver? Give an example of a cost and...Ch. 3 - Suppose a company finds that shipping cost is...Ch. 3 - Some firms assign mixed costs to either the fixed...Ch. 3 - Explain the difference between committed and...Ch. 3 - Explain why the concept of relevant range is...Ch. 3 - Why do mixed costs pose a problem when it comes to...Ch. 3 - Describe the cost formula for a strictly fixed...Ch. 3 - Describe the cost formula for a strictly variable...Ch. 3 - What is the scattergraph method, and why is it...
Ch. 3 - Describe how the scattergraph method breaks out...Ch. 3 - What are the advantages of the scattergraph method...Ch. 3 - Prob. 13DQCh. 3 - What is meant by the best-fitting line?Ch. 3 - What is the difference between the unit cost of a...Ch. 3 - Prob. 16DQCh. 3 - (Appendix 3A) Explain the meaning of the...Ch. 3 - A factor that causes or leads to a change in a...Ch. 3 - Which of the following would probably be a...Ch. 3 - Prob. 3MCQCh. 3 - In the cost formula, the term 128,000,000 a. is...Ch. 3 - In the cost formula, the term 12,000 a. is the...Ch. 3 - Prob. 6MCQCh. 3 - Prob. 7MCQCh. 3 - The following cost formula for total purchasing...Ch. 3 - An advantage of the high-low method is that it a....Ch. 3 - Prob. 10MCQCh. 3 - Prob. 11MCQCh. 3 - Prob. 12MCQCh. 3 - The total cost for monthly supervisory cost in a...Ch. 3 - Yates Company shows the following unit costs for...Ch. 3 - (Appendix 3A) In the method of least squares, the...Ch. 3 - Creating and Using a Cost Formula Big Thumbs...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Absorption-Costing Income Statement Refer to the...Ch. 3 - Variable-Costing Income Statement Refer to the...Ch. 3 - Creating and Using a Cost Formula Kleenaire Motors...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Brief Exercise 3-28 Using High-Low to Calculate...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Brief Exercise 3-32 Absorption-Costing Income...Ch. 3 - Brief Exercise 3-33 Variable-Costing Income...Ch. 3 - Variable and Fixed Costs What follows are a number...Ch. 3 - Cost Behavior, Classification Smith Concrete...Ch. 3 - Prob. 36ECh. 3 - Prob. 37ECh. 3 - Prob. 38ECh. 3 - Step Costs, Relevant Range Bellati Inc. produces...Ch. 3 - Matching Cost Behavior Descriptions to Cost...Ch. 3 - Examine the graphs in Exercise 3-40. Required: As...Ch. 3 - Prob. 42ECh. 3 - Prob. 43ECh. 3 - High-Low Method Refer to the information for Luisa...Ch. 3 - Scattergraph Method Refer to the information for...Ch. 3 - Method of Least Squares Refer to the information...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Method of Least Squares, Developing and Using the...Ch. 3 - The method of least squares was used to develop a...Ch. 3 - Identifying the Parts of the Cost Formula;...Ch. 3 - Inventory Valuation under Absorption Costing...Ch. 3 - Inventory Valuation under Variable Costing Lane...Ch. 3 - Income Statements under Absorption and Variable...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - Identifying Fixed, Variable, Mixed, and Step Costs...Ch. 3 - Identifying Use of the High-Low, Scattergraph, and...Ch. 3 - Identifying Variable Costs, Committed Fixed Costs,...Ch. 3 - Scattergraph, High-Low Method, and Predicting Cost...Ch. 3 - Method of Least Squares, Predicting Cost for...Ch. 3 - Cost Behavior, High-Low Method, Pricing Decision...Ch. 3 - Prob. 63PCh. 3 - Variable and Fixed Costs, Cost Formula, High-Low...Ch. 3 - Cost Separation About 8 years ago, Kicker faced...Ch. 3 - Variable-Costing and Absorption-Costing Income...Ch. 3 - Refer to the information for Farnsworth Company...Ch. 3 - (Appendix 3A) Scattergraph, High-Low Method,...Ch. 3 - (Appendix 3A) Separating Fixed and Variable Costs,...Ch. 3 - (Appendix 3A) Cost Formulas, Single and Multiple...Ch. 3 - Suspicious Acquisition of Data, Ethical Issues...
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
- The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: a. Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. b. In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? How much would you be willing to pay per hour of overtime in each department? c. Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is 18 in department A, 22.50 in department B, and 12 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. What are the optimal production quantities, and what is the revised total contribution to profit? How much overtime do you recommend using in each department? What is the increase in the total contribution to profit if overtime is used?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_forwardExplain 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_forward
- The MTN Company has assembled the following data pertaining to certain costs which cannot be easily identified as either fixed or variable. MTN has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation. Cost Hours $100,000 3,500 61,000 2,000 85,000 2,600 78,200 2,450 91,000 3,000 110,400 3,900 106,000 3,740 93,000 3,380 a) Calculate the variable cost per hour b) Calculate the total fixed costs c) Write the equation which measures the cost behavior of the costs d) Calculate the operating costs for 3,750 hours.arrow_forwardWhich of the following would be true for a service company? a. ABC helps the company make more informed decisions about services. b. Service companies use only a few activities, so a plantwide overhead allocation is always appropriate. c. Most of the company’s costs are for direct materials and direct labor. Indirect costs are a small proportion of total costs. d. All of the above are true.arrow_forwardScattergraph, High–Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows: Month Receiving Orders Receiving Cost ($) 1 1,000 27,000 2 700 22,500 3 1,500 42,000 4 1,200 25,500 5 1,300 37,500 6 1,100 31,500 7 1,600 43,500 8 1,400 36,000 9 1,700 40,500 10 900 24,000 Required: 1. On your own paper, prepare a scattergraph based on the 10…arrow_forward
- Pinnacle Inc. has decided to switch from a traditional overhead allocation system to an ABC system. So far, the firm’s managers have decided that Pinnacle needs six different activity cost pools, including one for assembling products. When selecting a driver for this cost pool, Pinnacle’s managers should be sure to select _______ A. the activity that appears to play the greatest role in determining the firm’s product assembly costs. B. the activity that appears to play the greatest role in determining how many units the firm assembles in a given period. C. the product that appears to account for the majority of the costs in the product assembly pool. D. the product that has the highest per-unit assembly cost.arrow_forwardThe following data have been extracted from the records of Puzzle Incorporated: Production level, in units Variable costs Fixed costs Mixed costs Total costs Required A Required B Required: a. Calculate the missing costs. b. Calculate the cost formula for mixed cost using the high-low method. c. Calculate the total cost that would be incurred for the production of 12,880 units. d. Identify the two key cost behavior assumptions made in the calculation of your answer to part c. Required C Production level, in units Variable costs Fixed costs Mixed costs Total costs Complete this question by entering your answers in the tabs below. Calculate the missing costs. Note: Do not round intermediate calculations. February 9,200 $ 19,320 ? 16,312 $ 71,532 February 9,200 $ 19,320 $ 2 X 16,312 $ 71,532 Required D August August 20, 240 $? 35,900 ? $ 106,970 Answer is not complete. 20,240 34,255 35,900 52,475 $ 106,970arrow_forwardThe MTN Company has assembled the following data pertaining to certain costs which cannot be easily identified as either fixed or variable. MTN has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation Cost Hours $100,000 3,500 61,o00 2,000 85,000 2,600 78,200 2,450 91,000 3,000 110,400 3,900 106,000 3,740 93,000 3,380 Calculate the variable cost per hour Calculate the total fixed costs Write the equation which measures the cost behavior of the costs Calculate the operating costs for 3,750arrow_forward
- Need some help making a cheet sheet for an up coming test. please provide examples. The exam covers chapters 1 through 13. Here are some suggested study topics: Cost Classifications - variable, fixed and mixed, period and product, direct and indirect, opportunity, sunk, relevant, traceable, common, etc. Calculate the results of changes to cost assumptions (CVP) Calculate net income based on contribution margin values either dollars or % Application of Manufacturing Overhead - calculate predetermined overhead rate or activity rates applied to a product or job - job order using a predetermined overhead rate or rates and activity-based costing calculate over and underapplied overhead calculate adjusted cost of goods sold Job Costing What is the total cost of the job and average cost per unit. Cost of Goods Manufactured and cost of goods sold Calculate break even and target profit Create a contribution format income statement Gross margin calculations - absorption or variable costing…arrow_forwardHello, Have a question. Which of the following are the advantages of the ABC approach relative to using a single predetermined overhead application rate based on direct labor hours? Select all that apply. A. ABC does not help in decision making. B. ABC systems produce more accurate financial information. C. ABC approach is likely to provide better information to manufacturing managers. D. ABC helps in decision making. E. ABC systems produce more accurate product costing information. Thanks...arrow_forwardThe Gangwere Company has assembled the following data pertaining to certain costs that cannot be easily identified as either fixed or variable. Gangwere Company has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation. Month Cost Hours January $44,900 3,500 February 24,400 2,000 March 31,280 2,450 April 36,400 3,000 May 44,160 3,900 June 42,400 3,740How is the cost function stated? Question 12 options: a) y = $3,600 + $10.40X b) y = $10,112 + $8.64X c) y = $26,672 + $1.84X d) y = $21,360 + $10.40arrow_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
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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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