Question

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 maintenance costs and machine hours follow:

Month Maintenance Costs Machine Hours
1 $ 2,625 1,499
2 2,670 1,590
3 2,720 1,605
4 2,820 1,655
5 2,855 1,775
6 3,005 1,880
7 2,865 1,785
8 2,905 1,805
9 2,780 1,695
10 2,570 1,410
11 2,590 1,550
12 2,890 1,425

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 and all other calculations, to nearest whole dollar.)

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. 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., .054 = 5.4%).)

Homework Answers

Answer #1
1) Maintenance Costs
At highest activity : X2 = 1880 Y2 = $3,005
At lowest activity : X1= 1410 Y1= $2,570
.
Variable Maintenance Costs per Machine hour =(3005-2570) /(1880-1410) $0.9255
Total Maintenance Fixed Costs = 3005-(1880*0.9255) = $1,265
3) Month Machine Hours Actual Maintenance Costs Forecasted Maintenance Absolute Percent Error
1 1,499 $ 2,625 $ 2,652 1.041%
2 1,590 2,670 2,737 2.492%
3 1,605 2,720 2,750 1.119%
4 1,655 2,820 2,797 -0.826%
5 1,775 2,855 2,908 1.848%
6 1,880 3,005 3,005 -0.002%
7 1,785 2,865 2,917 1.816%
8 1,805 2,905 2,936 1.051%
9 1,695 2,780 2,834 1.932%
10 1,410 2,570 2,570 -0.002%
11 1,550 2,590 2,700 4.229%
12 1,425 2,890 2,584 -10.594%
MAPE 0%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Can you explain to me how to do MAPE in Excel with this data? . ....
Can you explain to me how to do MAPE in Excel with this data? . . . Cost Estimation; High-Low Method; MAPE?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 expense and machine hours: Month Maintenance Expense Machine Hours ?1 $2,600...
Crosshill Company’s total overhead costs at various levels of activity are presented below: Month Machine-Hours Total...
Crosshill Company’s total overhead costs at various levels of activity are presented below: Month Machine-Hours Total Overhead Cost      April 49,000    $173,870        May 39,000    $151,570        June 59,000    $196,170        July 69,000    $218,470   Assume that the overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 39,000-machine-hour level of activity in May is as follows:   Utilities (variable) $ 42,900     Supervisory salaries (fixed) 46,000   Maintenance (mixed) 62,670   Total overhead cost $ 151,570 The...
Prince Company’s total overhead costs at various levels of activity are presented below:   Month Machine Hours...
Prince Company’s total overhead costs at various levels of activity are presented below:   Month Machine Hours Total Overhead Cost   September 112,800 $ 781,512   October 89,200 $ 662,568   November 157,200 $ 1,005,288   December 165,000 $ 1,044,600 Assume that the overhead cost above consists of utilities, supervisory salaries, depreciation, and maintenance. The breakdown of these costs at the 89,200-machine-hour level of activity in October is as follows:   Utilities (variable) $ 233,704   Supervisory salaries       and depreciation (fixed) 172,000   Maintenance (mixed)      256,864   Total overhead...
Sawaya Co., Ltd., of Japan is a manufacturing company whose total factory overhead costs fluctuate considerably...
Sawaya Co., Ltd., of Japan is a manufacturing company whose total factory overhead costs fluctuate considerably from year to year according to increases and decreases in the number of direct labor-hours worked in the factory. Total factory overhead costs at high and low levels of activity for recent years are given below: Level of Activity Low High Direct labor-hours 52,800 70,400 Total factory overhead costs $ 286,620 $ 328,860 The factory overhead costs above consist of indirect materials, rent, and...
Johnny Lee Inc. produces a line of small gasoline-powered engines that can be used in a...
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...
Reducir, Inc., produces two different types of hydraulic cylinders. Reducir produces a major subassembly for the...
Reducir, Inc., produces two different types of hydraulic cylinders. Reducir produces a major subassembly for the cylinders in the Cutting and Welding Department. Other parts and the subassembly are then assembled in the Assembly Department. The activities, expected costs, and drivers associated with these two manufacturing processes are given below. Process Activity Cost Activity Driver Expected Quantity Cutting and Welding Welding $ 776,000    Welding hours 4,000 Machining 450,000    Machine hours 10,000 Inspecting 448,250    No. of inspections 1,000 Materials handling 300,000...
Comparison of Methods of Allocation Duweynie Pottery, Inc., is divided into two operating divisions: Pottery and...
Comparison of Methods of Allocation Duweynie Pottery, Inc., is divided into two operating divisions: Pottery and Retail. The company allocates Power and General Factory department costs to each operating division. Power costs are allocated on the basis of the number of machine hours and general factory costs on the basis of square footage. No effort is made to separate fixed and variable costs; however, only budgeted costs are allocated. Allocations for the coming year are based on the following data:...
Bubble Company produces a variety of bottles from recycled plastic. The company has one particular machine...
Bubble Company produces a variety of bottles from recycled plastic. The company has one particular machine on which it can produce either of two types of water bottles, 1-liter bottles or 1/2-liter bottles. Sales demand for both products is such that the machine could operate at full capacity on either of the products, and Bubble can sell all output at current prices. One unit of the 1/2-liter product requires one hour of machine time per unit of output, and one...
Bubble Company produces a variety of bottles from recycled plastic. The company has one particular machine...
Bubble Company produces a variety of bottles from recycled plastic. The company has one particular machine on which it can produce either of two types of water bottles, 1-liter bottles or 1/2-liter bottles. Sales demand for both products is such that the machine could operate at full capacity on either of the products, and Bubble can sell all output at current prices. One unit of the 1/2-liter product requires one hour of machine time per unit of output, and one...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical industry. One of the company’s products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2,200 hours of welding time is available annually on the machine. Because each drum requires 0.8 hours of welding...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT