Question

Felinas Inc. produces floor mats for cars and trucks. The owner, Kenneth Felinas, asked you to assist him in estimating his maintenance costs. Together, Mr. Felinas and you determined that the single best cost driver for maintenance costs was machine hours. Below are data from the previous fiscal year for maintenance expense and machine hours:

Month Maintenance Expense Machine Hours
1 $ 3,480 2,380
2 3,670 2,480
3 3,850 2,580
4 3,980 2,610
5 3,980 2,460
6 4,400 2,620
7 3,970 2,600
8 3,780 2,570
9 3,500 2,390
10 3,120 2,260
11 2,960 1,650
12 3,240 2,250
Using the high-low method, total monthly fixed cost is calculated to be:__________
a. $296.
b. $224.
c. $460.
d. $162.
e. $552.

Answer 1

Fixed costs= 510

Step-by-step explanation:

Giving the following information:

Month Maintenance Expense Machine Hours

1 $ 3,480 2,380

2 3,670 2,480

3 3,850 2,580

4 3,980 2,610

5 3,980 2,460

6 4,400 2,620

7 3,970 2,600

8 3,780 2,570

9 3,500 2,390

10 3,120 2,260

11 2,960 1,650

12 3,240 2,250

To calculate the fixed costs, we need to use the following formulas:

Variable cost per unit= (Highest activity cost - Lowest activity cost)/ (Highest activity units - Lowest activity units)

Variable cost per unit= (4,400 - 2,960) / (2,620 - 1,650)

Variable cost per unit= $1.484536

Fixed costs= Highest activity cost - (Variable cost per unit * HAU)

Fixed costs= 4,400 - (1.484536*2,620)

Fixed costs= $510

Fixed costs= LAC - (Variable cost per unit* LAU)

Fixed costs= 2,960 - (1.484536*1,650)

Fixed costs= 510