Concept explainers
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- The 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_forwardUchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?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_forward
- 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_forwardRefer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and 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 purchase 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? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?arrow_forwardThe president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firms leading product over the past eight years: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the average cost increase that the firm has been realizing per year? d. Compute an estimate of the cost/unit for next year.arrow_forward
- The controller of Emery, Inc. has computed quality costs as a percentage of sales for the past 5 years (20X1 was the first year the company implemented a quality improvement program). This information is as follows: Required: 1. Prepare a trend graph for total quality costs. Comment on what the graph has to say about the success of the quality improvement program. 2. Prepare a graph that shows the trend for each quality cost category. What does the graph have to say about the success of the quality improvement program? Does this graph supply more insight than the total cost trend graph does? 3. Prepare a graph that compares the trend in relative control costs versus relative failure costs. Comment on the significance of this trend.arrow_forwardDeMarco 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_forwardRefer to the information for Farnsworth Company (p. 139) for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered 2 more months of data: Note: For the following requirements, round the intercept terms to the nearest dollar, round the variable rates to the nearest cent, and R2 to two decimal places. Required: 1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results. 2. CONCEPTUAL CONNECTION Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Tracy has learned that the factory suffered severe storm damage during Month 11 that required extensive repairs to the receiving areaincluding major repairs on a forklift. These expenses, included in Month 11 receiving costs, are not expected to recur. What step might Tracy, using her judgment, take to amend the results from the method of least squares? 3. CONCEPTUAL CONNECTION Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.arrow_forward
- Bradshaw Company reported sales of 5,000,000 in 20X1. At the end of the fiscal year (June 30, 20X1), the following quality costs were reported: Required: 1. Prepare a quality cost report. 2. Prepare a graph (pie chart or bar graph) that shows the relative distribution of quality costs, and comment on the distribution. 3. Assuming sales of 5,000,000, by how much would profits increase if quality improves so that quality costs are only 3% of sales?arrow_forwardThe Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.arrow_forwardRoss Company implemented a quality improvement program and tracked the following for the five years: By cost category as a percentage of sales for the same period of time: Required: 1. Prepare a bar graph that reveals the trend in quality cost as a percentage of sales (time on the horizontal axis and percentages on the vertical). Comment on the message of the graph. 2. Prepare a bar graph for each cost category as a percentage of sales. What does this graph tell you? 3. What if management would like to have the trend in relative distribution of quality costs? Express this as a bar graph and comment on its significance.arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningExcel 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 LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College