Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,665 2,710 2,760 1 2 3 4 6 7 8 9 10 11 12 2,860 2,895 Maintenance cost 3,045 2,905 2,945 2,820 2,610 2,630 2,930 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the "slope (unit variable cost)" rounded to 4 decimal places and all other calculations, to nearest whole dollar.) ✓ Answer is complete and correct. S 0.9886 1,177 + X M = Machine Hours 3. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Input your final answer as a percentage rounded to 1 decimal place (i.e., .054 = 5.4%).) Answer is complete but not entirely correct. 7.3 X % Mean absolute percentage error (MAPE)
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,665 2,710 2,760 1 2 3 4 6 7 8 9 10 11 12 2,860 2,895 Maintenance cost 3,045 2,905 2,945 2,820 2,610 2,630 2,930 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the "slope (unit variable cost)" rounded to 4 decimal places and all other calculations, to nearest whole dollar.) ✓ Answer is complete and correct. S 0.9886 1,177 + X M = Machine Hours 3. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Input your final answer as a percentage rounded to 1 decimal place (i.e., .054 = 5.4%).) Answer is complete but not entirely correct. 7.3 X % Mean absolute percentage error (MAPE)
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter18: Pricing And Profitability Analysis
Section: Chapter Questions
Problem 1CE: Ventana Window and Wall Treatments Company provides draperies, shades, and various window...
Related questions
Question
Transcribed Image Text:Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is
concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were
higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's
profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the
previous fiscal year for maintenance costs and machine hours follow:
Month Maintenance Costs Machine Hours
$ 2,665
2,710
2,760
1
2
3
4
6
7
8
9
10
11
12
2,860
2,895
Maintenance cost
3,045
2,905
2,945
2,820
2,610
2,630
2,930
1,566
1,670
1,685
1,735
1,855
1,890
1,865
1,885
1,775
1,450
1,630
1,465
Required:
1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit
variable cost)" to 4 decimal places. Enter the "slope (unit variable cost)" rounded to 4 decimal places and all other calculations, to
nearest whole dollar.)
✓ Answer is complete and correct.
S
0.9886
1,177 +
X
M = Machine Hours
3. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Input your final
answer as a percentage rounded to 1 decimal place (i.e., .054 = 5.4%).)
Answer is complete but not entirely correct.
7.3 X %
Mean absolute percentage error (MAPE)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 1 steps
Recommended textbooks for you
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
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
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
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
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
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub