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,665 | 1,699 | |||
2 | 2,711 | 1,802 | ||||
3 | 2,762 | 1,819 | ||||
4 | 2,866 | 1,876 | ||||
5 | 2,900 | 2,012 | ||||
6 | 3,052 | 2,131 | ||||
7 | 2,910 | 2,023 | ||||
8 | 2,951 | 2,046 | ||||
9 | 2,824 | 1,921 | ||||
10 | 2,611 | 1,598 | ||||
11 | 2,631 | 1,757 | ||||
12 | 2,936 | 1,615 | ||||
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.)
Maintenance cost = _____ + ( _____ x ______)
2. Graph the data points to check for possible outliers and determine whether the points selected in requirement 1 are representative of the data. (To earn full credit for this graph you must plot all required points for each curve. While plotting the points a tool icon will pop up. You can use this to enter exact co-ordinates for your points as needed.)
3. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Do not round intermediate calculations, with the exception of MAPE for each month, which should be rounded to three decimal places. Input your final answer as a percentage rounded to 1 decimal place (i.e., .0540 = 5.40%).)
Mean absolute percentage error (MAPE) ___%
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...
Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs $ 2,770 2,930 3,080 3,190 3,270 3,240 3,180 3,020 2,790 2,390 2,400 2,620 Machine Hours 1,860 1,940 2,020 2,040 2,070 2,050 2,030 2,010 1,870 1,270...
Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours 1 $ 2,620 1,710 2 2,780 1,790 3 2,930 1,870 4 3,040 1,890 5 3,120 1,920 6 3,090 1,900 7 3,030 1,880 8...
Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours 1 $ 2,680 1,770 2 2,840 1,850 3 2,990 1,930 4 3,100 1,950 5 3,180 1,980 6 3,150 1,960 7 3,090 1,940 8...
Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours 1 $ 2,680 1,770 2 2,840 1,850 3 2,990 1,930 4 3,100 1,950 5 3,180 1,980 6 3,150 1,960 7 3,090 1,940 8...
Johnny Lee Inc. produces a line of small gasoline-powered engines that can be used in a variety of residential machines, ranging from different types of lawnmowers, to snowblowers, to garden tools (such as tillers and weed-whackers). The basic product line consists of three different models, each meant to fill the needs of a different market. Assume you are the cost accountant for this company and that you have been asked by the owner of the company to construct a flexible...
Account Analysis to Determine Cost Behavior Darnell Poston, owner of Poston Manufacturing, Inc., wants to determine the cost behavior of labor and overhead. Darnell pays his workers a salary; during busy times, everyone works to get the orders out. Temps (temporary workers hired through an agency) may be hired to pack and prepare completed orders for shipment. During slower times, Darnell catches up on bookkeeping and administrative tasks while the salaried workers do preventive maintenance, clean the lines and building,...
Johnny Lee Inc. produces a line of small gasoline-powered engines that can be used in a variety of residential machines, ranging from different types of lawnmowers, to snowblowers, to garden tools (such as tillers and weed-whackers). The basic product line consists of three different models, each meant to fill the needs of a different market. Assume you are the cost accountant for this company and that you have been asked by the owner of the company to construct a flexible...
3: Assignment Seved Help Save & Exit Crosshill Company's total overhead costs at various levels of activity are presented below: 5 Month April May June July Machine- Hours 54,000 44,000 64,000 74,000 Total Overhead Cost $236,980 $209,280 $264,680 $292,380 Assume that the overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 44,000-machine-hour level of activity in May is as follows: Book $ Utilities (variable) Supervisory salaries (fixed) Maintenance (mixed) 70,400 69,000 69,880...
Johnny Lee Inc. produces a line of small gasoline-powered engines that can be used in a variety of residential machines, ranging from different types of lawnmowers, to snowblowers, to garden tools (such as tillers and weed-whackers). The basic product line consists of three different models, each meant to fill the needs of a different market. Assume you are the cost accountant for this company and that you have been asked by the owner of the company to construct a flexible...