Question

In: Accounting

Cost Estimation; High-low Method; MAPE: Horton Manufacturing Inc. produces blinds and other window treatments for residential...

Cost Estimation; High-low Method; MAPE: Horton Manufacturing Inc. 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

1

 $2,625 1,499
2 2670 1590
3 2720 1605
4 2822 1655
5 2855

1775
6 3005 1880
7 2865 1785
8 2905 1805
9 2780 1695
10 2570 1410
11 2590 1550
12 2890 1425

Question:

- Use the high-low method to estimate the fixed and variable portions for maintenance costs.

- Graph the data points to check for possible outliers and determine whether the points selected in requirement 1 are representative of the date.

- Calculate the mean absolute percentage average error (MAPE) for the cost equation you developed in requirement 1.

Solutions

Expert Solution

----------------------------------------------------------------------------------------------------------------------

"ANSWER IS SOLVED AS PER GIVEN QUESTION"
ALL THE BEST!!!!

If any doubts, drop your message in the comments box! Thank you!!!
#STAY SAFE

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Horton Manufacturing Inc. produces blinds and other window treatments for residential homes and offices. The owner...
Horton Manufacturing Inc. 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...
Horton Manufacturing Inc. produces blinds and other window treatments for residential homes and offices. The owner...
Horton Manufacturing Inc. 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...
Marigold Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The...
Marigold Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Commercial Residential Revenues $328,000 $514,000 Direct materials costs $45,000 $50,000 Direct labor costs 110,000 290,000 Overhead costs 108,000 263,000 199,000 539,000 Operating income (loss) $65,000 $(25,000) The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window...
Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The...
Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Commercial Residential Revenues $322,500 $537,500 Direct materials costs $35,000 $50,000 Direct labor costs 120,000 280,000 Overhead costs 87,500 242,500 232,500 562,500 Operating income (loss) $80,000 $(25,000) The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window...
Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The...
Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Commercial Residential Revenues $299,000 $475,000 Direct materials costs $30,000 $49,000 Direct labor costs 109,900 296,500 Overhead costs 93,900 233,800 149,000 494,500 Operating income (loss) $65,200 $(19,500) The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window...
Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The...
Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Commercial Residential Revenues $355,050 $425,000 Direct materials costs $30,000 $50,000 Direct labor costs 150,000 250,000 Overhead costs 85,050 265,050 145,000 445,000 Operating income (loss) $90,000 $(20,000) The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window...
Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North...
Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North American automobile manufacturers. Although the company has a capacity of 300,000 units per year, it is currently producing at an annual rate of 180,000 units. SafeRide, Inc. has received an order from a German manufacturer to purchase 60,000 units at $7.00 each. Budgeted costs for 180,000 and 240,000 units are as follows: 180,000 Units 240,000 Units Manufacturing costs Direct materials $450,000 $600,000 Direct labor...
Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North...
Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North American automobile manufacturers. Although the company has a capacity of 300,000 units per year, it is currently producing at an annual rate of 180,000 units. SafeRide, Inc. has received an order from a German manufacturer to purchase 60,000 units at $7.00 each. Budgeted costs for 180,000 and 240,000 units are as follows: 180,000 Units 240,000 Units Manufacturing costs Direct materials $450,000 $600,000 Direct labor...
In applying the high-low method of cost estimation to mixed costs, how is the total fixed...
In applying the high-low method of cost estimation to mixed costs, how is the total fixed cost estimated? If fixed costs increase, what would be the impact on the (a) contribution margin? (b) income from operations? An examination of the accounting records of Clowney Company disclosed a high contribution margin ratio and production at a level below maximum capacity. Based on this information, suggest a likely means of improving income from operations. Explain.
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 104,500 $30,703,250 119,500 33,380,750 136,500 36,415,250 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Determine the variable cost per unit and...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT