Managerial Accounting for Managers
4th Edition
ISBN: 9781259578540
Author: Eric Noreen, Peter C. Brewer Professor, Ray H Garrison
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2A, Problem 2A.3P
Least-Squares Regression; Scattergraph; Comparison of Activity Bases [LO 2-4, LO 2-8]
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 with which the cost might be closely correlated. 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:
![Chapter 2A, Problem 2A.3P, Least-Squares Regression; Scattergraph; Comparison of Activity Bases [LO 2-4, LO 2-8] The Hard Rock](http://dev-ingestion-image-output.s3-website-us-east-1.amazonaws.com/9781259578540/Chapter-2A/images/html_q_78540-2a-2a.3p_1.png)
Required:
- Using tons mined as the independent variable: prepare a scattergraph that plots tons mined on the horizontal axis and utilities cost on the vertical axis. Determine a cost formula for utilities cost using least-squares regression- Express this cost formula in the form
- 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- Determine a cost formula for utilities cost using least-squares regression. Express this cost formula in the form
- Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilities cost?
1.
Expert Solution
To determine
Concept Introduction:
Scatter-graph:Scatter-graph implies the visual presentation of data on the graph in which costs are shown on the y-axis and activity level is presented in the x-axis.
Least-square regression: Least square regression method use all the available data to derive the best fitting line which would minimize the sum of squared errors between the data points and the regression line.
To prepare:The scatter diagram using tons mixed and utilities cost and determine cost formula
Explanation of Solution
The cost formula is Y=28352+2.58X where, Y is the utilities cost and X is the tons mixed.
Thus, the scatter diagram has been prepared, and least square regression has been performed and cost equation has been determined.
2.
Expert Solution
To determine
Concept Introduction:
Scatter-graph:Scatter-graph implies the visual presentation of data on the graph in which costs are shown on the y-axis and activity level is presented in the x-axis.
Least-square regression: Least square regression method use all the available data to derive the best fitting line which would minimize the sum of squared errors between the data points and the regression line
To prepare:The scatter diagram using tons mixed and utilities cost and determine cost formula
Explanation of Solution
The cost formula is Y=17000+9X where, Y is the utilities cost and X is the direct labor hours Thus, the scatter diagram has been prepared, and least square regression has been performed and cost equation has been determined.
3.
Expert Solution
To determine
Concept Introduction:
Scatter-graph:Scatter-graph implies the visual presentation of data on the graph in which costs are shown on the y-axis and activity level is presented in the x-axis.
Least-square regression: Least square regression method use all the available data to derive the best fitting line which would minimize the sum of squared errors between the data points and the regression line
The activities to be selected as as a base for planning utilities cost
Answer to Problem 2A.3P
Direct labor hours should be taken as a base for planning utilities costs.
Explanation of Solution
The regression coefficient is 0.9346 when direct labor is taken as base whereas it is 0.4668 when tons mined is taken as base. Regression coefficient determines the accuracy with which the costs can be determined. Thus taking direct labor as base, the costs can be determined with 93.46% accuracy whereas the accuracy percentage is only 46.68% when tons mined are taken as base. Thus, the activity to be taken as a base for planning utilities cost has been determined.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Can you provide samples/examples of tasks for developing the costing and profitability model for a new product? Should include the following:
o A table showing the list of the parameters used in your model
o A breakdown of the expected production costs and profitability
o Calculation of the NPV of expected sales/ profitability
o A sensitivity analysis that accounts for changes in any three (3) parameters of your model.
o At least two trade-off rules you developed for your product development
Steele Industries manufactures a number of products at its highly automated
factory. The products are very popular, with demand far exceeding the factory's
capacity. To maximize profit, management should rank products based on their:
gross margin
O contribution margin
O selling price
O contribution margin per unit of the constrained resource
The managerial accountant at Fast and Mean Manufacturing reported that the organization contains an automated production line to manufacture and produce its products for consumers to enjoy in the marketplace. The managerial accountant reported that the company uses the high-low method to estimate the costs in the new budget. The managerial accountant reported the following information:
Compute the slope of the mixed cost, or the variable cost per unit of activity.
Compute the vertical intercept, or the fixed cost component of the mixed cost.
What is the mixed cost equation?
Month
Total machine hours
total cost
January
250,000
$5,500,000
February
248,000
$5,260,000
March
249,000
$5,400,000
April
248,000
$5,220,000
May
238,000
$5,180,000
June
230,000
$5,130,000
Chapter 2A Solutions
Managerial Accounting for Managers
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_forwardThe production manager wants to achieve real and permanently decrease in the unit cost of the product. As you are the cost accountant of the company, which of the following concepts explains about real and permeant decrease in the unit cost of the product? a. Cost estimation b. Cost analysis c. Cost control d. Cost reductioarrow_forwardLancelot Group of Companies would like to estimate its cost function for proper cost management across its business lines. The accountant will.most likely segregate the costs on the basis of • A Degree of averaging into total, average, and unit cost O B. Behavior of cost to changes in activity level to unit and fixed cost • C. Degree of averaging into variable and fixed components O D. Cost-volume relationship into variable and fixed components Reser Selectionarrow_forward
- RelyaTech Corporation manufactures a number of products at its highly automated factory. The products are very popular, with demand far exceeding the factory's capacity. To maximize profit, management should rank products based on their selling price gross margin contribution margin per unit of the constrained resource contribution marginarrow_forwardThe 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_forwardABC systems get more accurate as more activities are identified and analyzed. Critique the following statement: “A company should look to break its production process into as many activities as possible in order to determine the most accurate unit costs possible”. Why do you agree or disagree with that statement? Give several reasons.arrow_forward
- 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…arrow_forwardThe 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?arrow_forwardThe controller of Tri Con Global Systems Inc. has developed a new costing system that traces the cost of activities to products. The new system is able to measure post-manufacturing activities, such as selling, promotional, and distribution activities, and allocate these activities to products in a manner that provides a more complete view of the company's product costs. This system produces better strategic information about the relative profitability of product lines. In the course of implementing the new costing system, the controller realized that the company's current period GAAP net income would increase significantly if the new product cost information were used for inventory valuation on the financial statements. The controller has been under intense pressure to improve the company's net income, and this would be an easy and effective way for her to help meet the company's short-term net income goals. As a result, she has decided to use the new costing system to determine GAAP…arrow_forward
- The controller of Tri Con Global Systems Inc. has developed a new costing system that traces the cost of activities to products. The new system is able to measure post-manufacturing activities, such as selling, promotional, and distribution activities, and allocate these activities to products in a manner that provides a more complete view of the company's product costs. This system produces better strategic information about the relative profitability of product lines. In the course of implementing the new costing system, the controller realized that the company's current period GAAP net income would increase significantly if the new product cost information were used for inventory valuation on the financial statements. The controller has been under intense pressure to improve the company's net income, and this would be an easy and effective way for her to help meet the company's short-term net income goals. As a result, she has decided to use the new costing system to determine GAAP…arrow_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,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_forwardQ.a.Do you agree from the following statements- Explain in details with examples(i) Variable costs are controllable but fixed costs are not. (ii) Sunk costs are irrelevant cost while making any decision. Q. b. Cost Control and Cost Reduction are the two important factors by which Manufacturing companies may increase their Profits. One of the most important tool is the installation of Standard Costing system. But companies have to be very careful while deciding the Proper interpretation of variances from standard is very important for the success of standard costing system as a tool for Cost Control. Mention some important factors that must be born in your mind while interpreting variances.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license