In: Accounting
The controller of Hall Industries has collected the following
monthly expense data for use in analyzing the cost behavior of
maintenance costs.
| 
 Month  | 
 Total  | 
 Total  | 
|||
|---|---|---|---|---|---|
| 
 January  | 
$2,640 | 3,500 | |||
| 
 February  | 
3,000 | 4,000 | |||
| 
 March  | 
3,600 | 6,000 | |||
| 
 April  | 
4,500 | 7,900 | |||
| 
 May  | 
3,200 | 5,000 | |||
| 
 June  | 
4,620 | 8,000 | |||
Determine the variable-cost components using the high-low
method. (Round answer to 2 decimal places e.g.
2.25.)
| Variable cost per machine hour | 
 $enter the variable cost per machine hour in dollars rounded to 2 decimal places  | 
Determine the fixed cost components using the high-low
method.
| Fixed costs | 
 $  | 
| Ans. 1 | Variable cost per machine hour = (Highest cost - Lowest cost) / (Highest machine hours - Lowest machine hours) | ||||
| ($4,620 - $2,640) / (8,000 - 3,500) | |||||
| $1,980 / 4,500 | |||||
| $0.44 per unit | |||||
| Ans. 2 | We can calculate the fixed maintenance cost by using either highest activity or lowest activity. | ||||
| *Calculation of fixed overhead cost using Highest machine hours : | |||||
| Fixed maintenance cost = Highest cost - (Highest machine hours * Variable cost per machine hour) | |||||
| $4,620 - (8,000 * $0.44) | |||||
| $4,620 - $3,520 | |||||
| $1,100 | |||||
| *Calculation of fixed overhead cost using Lowest machine hours : | |||||
| Fixed maintenance cost = Lowest cost - (Lowest machine hours * Variable cost per machine hour) | |||||
| $2,640 - (3,500 * $0.44) | |||||
| $2,640 - $1,540 | |||||
| $1,100 | |||||
| So, the fixed cost is $1,100. | |||||