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)
- On December 31, 2022, Akron, Incorporated, purchased 5 percent of Zip Company's common shares on the open market in exchange for $15,650. On December 31, 2023, Akron, Incorporated, acquires an additional 25 percent of Zip Company's outstanding common stock for $93,500. During the next two years, the following information is available for Zip Company: Year Income Dividends Declared Common Stock Fair Value (12/31) 2022 $ 313,000 2023 $ 70,000 $ 7,800 374,000 2024 90,000 15,100 476,000 At December 31, 2023, Zip reports a net book value of $294,000. Akron attributed any excess of its 30 percent share of Zip's fair over book value to its share of Zip's franchise agreements. The franchise agreements had a remaining life of 10 years at December 31, 2023. Required: Assume Akron applies the equity method to its Investment in Zip account: What amount of equity income should Akron report for 2024? On Akron's December 31, 2024, balance sheet, what amount is reported for the…arrow_forwardCalculate JCI's projected free cash flow; the tax rate is 25%. Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places. $ ? What is JCI's current intrinsic stock price (the price on 6/30/2021)? What is the projected intrinsic stock price for 6/30/2022? FCF is expected to grow at a constant rate of 5%, and JCI's WACC is 9%. The firm has 800 million shares outstanding. Round your answers to the nearest cent. Intrinsic stock price on 6/30/2021: $ ? Intrinsic stock price on 6/30/2022: $ ? What is the projected intrinsic stock price on 7/1/2022 if JCI distributes the cash as dividends? Round your answer to the nearest cent. $ ? What is the projected intrinsic stock price on 7/1/2022 if JCI distributes the cash through stock repurchases? Round your answer to the nearest cent. $ ? How many shares will remain outstanding after the repurchase? Enter your answer in millions. For example, an…arrow_forwardkindly help me with accounting questionarrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning