EBK HORNGREN'S COST ACCOUNTING
16th Edition
ISBN: 9780134475950
Author: Datar
Publisher: PEARSON CO
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 10.32E
High-low, regression. May Blackwell is the new manager of the materials storeroom for Clayton Manufacturing. May has been asked to estimate future monthly purchase costs for part #696, used in two of Clayton’s products. May has purchase cost and quantity data for the past 9 months as follows:
Manufacturing. May has been asked to estimate future monthly purchase costs for part #696, used in two of Clayton’s products. May has purchase cost and quantity data for the past 9 months as follows:
| Month | Cost of Purchase | Quantity Purchased |
| January | $12,675 | 2,710 parts |
| February | 13,000 | 2,810 |
| March | 17,653 | 4,153 |
| April | 15,825 | 3,756 |
| May | 13,125 | 2,912 |
| June | 13,814 | 3,387 |
| July | 15,300 | 3,622 |
| August | 10,233 | 2,298 |
| September | 14,950 | 3,562 |
Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as follows:
| Month | Purchase Quantity Expected |
| October | 3,340 parts |
| November | 3,710 |
| December | 3,040 |
- 1. The computer in May’s office is down, and May has been asked to immediately provide an equation to estimate the future purchase cost for part #696. May grabs a calculator and uses the high-low method to estimate a cost equation. What equation does she get?
Required
- 2. Using the equation from requirement 1, calculate the future expected purchase costs for each of the last 3 months of the year.
- 3. After a few hours May’s computer is fixed. May uses the first 9 months of data and regression analysis to estimate the relationship between the quantity purchased and purchase costs of part #696. The regression line May obtains is as follows:
Evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Compare the regression equation to the equation based on the high-low method. Which is a better fit? Why?
- 4. Use the regression results to calculate the expected purchase costs for October, November, and December. Compare the expected purchase costs to the expected purchase costs calculated using the high-low method in requirement 2. Comment on your results.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:
Month
Machine Hours
Electricity Costs
January
2,500
$
18,400
February
2,900
21,000
March
1,900
13,500
April
3,100
23,000
May
3,800
28,250
June
3,300
22,000
July
4,100
24,750
August
3,500
22,750
September
2,000
15,500
October
3,700
26,000
November
4,700
31,000
December
4,200
27,750
Summary Output
Regression Statistics
Multiple R
0.965
R Square
0.932
Adjusted R2
0.925
Standard Error
1,425.18
Observations
12.00
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
3,726.88
1,682.82
2.21
0.05
(22.69)
7,476.45
Machine Hours
5.77
0.49
11.7
0.00
4.67
6.87
The percent of the total variance that can be explained by the regression is:…
The manager of the main laboratory facility at UrbanFit Center is interested in being able to predict the overhead costs each month for the lab. The manager believes that total overhead varies with the number of lab tests performed I
that some costs remain the same each month regardless of the number of lab tests performed. The lab manager collected the following data for the first seven months of the year.
(Click the icon to view the data.)
Use the high-low method to determine the laboratory's cost equation for total laboratory overhead. Use your results to predict total laboratory overhead if 3,500 lab tests are performed next month.
Let's begin by determining the formula that is used to calculate the variable cost (slope).
Data table
Variable cost (slope)
Number of Lab
Month
Tests Performed
Total Laboratory
Overhead Costs
January
2,800
$21,500
February
2,600
$22,700
March
3,100
$27,900
April....
3,550
$31,400
May
3,700
$28,500
June..
1,200
$19,500
July
1,400
$14,500
Print
Done
X
The manager of Trusty Car Inspection reviewed the monthly operating costs for the past year. The costs ranged from $4,300 for 1,300 inspections to $3,900 for 900 inspections.
Requirements 1. Use the high-low method to calculate the variable cost per inspection. 2. Calculate the total fixed costs. 3. Write the equation and calculate the operating costs for 1,000 inspections. 4. Draw a graph illustrating the total cost under this plan. Label the axes, and show the costs at 900, 1,000, and 1,300 inspections.
Chapter 10 Solutions
EBK HORNGREN'S 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
- Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow:arrow_forwardH1.arrow_forwardAt the end of the first month of opening your business, you calculate the actual operating costs of the business and the income you earned. You also notice and document the difference in what you budgeted for certain materials and labor against the actual amounts you spent on the same. For your statement of cost of goods sold, use the following data regarding the actual costs incurred by the business over the past month: Materials purchased: $20,000 Consumed 80% of the purchased materials Direct labor: $8,493.33 Overhead costs: $3,765 Note: Assume that the beginning materials and ending work in process are zero for the month. Use the following revenue and cost information for the income statement. Note that the revenue you use will depend on the pricing level options you chose in Milestone Two. Also, assume that after accounting for weekends and other holidays, there were 20 business days in the first month of operation. For example, if you chose a sales price of $20 per collar,…arrow_forward
- At the end of the first month of opening your business, you calculate the actual operating costs of the business and the income you earned. You also notice and document the difference in what you budgeted for certain materials and labor against the actual amounts you spent on the same. For your statement of cost of goods sold, use the following data regarding the actual costs incurred by the business over the past month: · Materials purchased: $20,000 o Consumed 80% of the purchased materials · Direct labor: $8,493 · Overhead costs: $3,765 Note: Assume that the beginning materials and ending work in process are zero for the month. Use the following revenue and cost information for the income statement. Note that the revenue you use will depend on the pricing level options you chose in Milestone Two. Also, assume that after accounting for weekends and other holidays, there were 20 business days in the first month of operation. For example, if you chose a sales price of $20 per…arrow_forwardGive me correct answer and explanation.sarrow_forwardThe managerial accountant at Organic Beverage Factory used spreadsheet software to run a regression analysis scenario and compile the following monthly cost data: Organic Beverage Factory Intercept coefficient X Variable 1 Coefficient $4,286,652 $28.21 R-square 0.6521 Which of the following is the correct cost equation showing the correlation of monthly costs, based on the results of the regression analysis compiled by the managerial accountant? O A. y $4,286,652 $28.21 O B. y $0.6521 $28.21x O C. y $28.21x + $4,286,652 O D. y 0.6521x + $4,286,652arrow_forward
- Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information (also included at this link) on production volume and manufacturing costs since the company started operations.use both images to fill in answers.arrow_forwardUsing the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardVentana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)arrow_forward
- DeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fragility of the items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Required: 1. Using the method of least squares, run a regression using the number of orders as the independent variable. 2. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? 3. Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items.arrow_forwardScattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 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? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers 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:arrow_forwardBig Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY