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
REVEL for Horngren's Cost Accounting: A Managerial Emphasis -- Access Card (16th Edition) (What's New in Accounting)
- Financial Accounting Question please solvearrow_forwardY Company purchased an asset for $73,000 on January 1, Year 1. The asset was expected to have a four-year life and an $8,000 salvage value. What would be the amount of depreciation expense for Year 1 using double-declining balance? Answerarrow_forwardAnsarrow_forward
- Please give me true answer this financial accounting questionarrow_forwardCan you please answer this financial accounting question?arrow_forwardY Company purchased an asset for $73,000 on January 1, Year 1. The asset was expected to have a four-year life and an $8,000 salvage value. What would be the amount of depreciation expense for Year 1 using double-declining balance? Ansarrow_forward
- Financial Accountingarrow_forwardSnowbird Company is constructing a building that qualifies for interest capitalization. It is built between January 1 and December 31, Year 1. Snowbird made the following expenditures related to this building: April 1 $396,000July 1 400,000September 1 510,000December 1 120,000The company borrowed $500,000 at 12% to help finance the project. In addition, Snowbird had outstanding borrowings of $2 million at 8% and $1 million at 9%. Required: Compute the amount of interest capitalized related to the construction of the building. Next Level What effect does the interest capitalization have on the company’s financial statements after it completes the building?arrow_forwardFGH Floral Company has a delivery truck that is being sold after 5 years of use. The current book value of the delivery truck is $6,000. If FGH Floral Company sells the delivery truck for $9,000, what is the impact of this transaction? Provide Answerarrow_forward
- On August 1, 20Y7, Rafael Masey established Planet Realty, which completed the following transactions during the month: Rafael Masey transferred cash from a personal bank account to an account to be used for the business in exchange for Common Stock, $22,000. Purchased supplies on account, $1,190. Earned sales commissions, receiving cash, $18,260. Paid rent on office and equipment for the month, $4,020. Paid creditor on account, $440. Paid dividends, $1,080. Paid automobile expenses (including rental charge) for month, $1,110, and miscellaneous expenses, $750. Paid office salaries, $2,340. Determined that the cost of supplies used was $660.arrow_forwardWhat is the corporation's tax liability on these financial accounting question?arrow_forwardEvergreen Logistics incurred the following costs for a new delivery truck: please answer the financial 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