Accounting Cost Behavior

7. Relevant range

We mentioned a relevant range before when we talked about step-variable costs:

Relevant range is the volume of activity, over which cost behavior stays valid.

Friends Company can produce from 10,000 to 50,000 valves per year. So, the relevant range for Friends Company is the range of normal activity from 10,000 to 50,000 units. Within this relevant range all fixed costs, such as rent, equipment depreciation, and administrative salaries remain constant. If Friends Company decides to produce more valves, they have to hire additional staff and rent more equipment, which will result in an increase of fixed costs. On the contrary, if the production level is reduced, Friends Company has to reduce staff and rental expenses, so fixed costs will decrease.

8. Methods for separating mixed costs

Management usually needs to know what fixed and variable costs are included in mixed costs. This is required for budgeting and planning purposes, among others. Using the total costs and the associated activity level, it is possible to break out the fixed and variable components. There are three methods for separating a mixed cost into its fixed and variable components:

  • High-low method
  • Scatter-graph method
  • Method of least squares

8.1. High-low method

When using the high-low method, the highest point and the lowest point are used to create the cost formula. The high point is defined as the point with the highest activity and the low point is defined as the point with the lowest activity. Using the lowest and highest activity levels, it is possible to estimate the variable cost per unit and the fixed cost component of mixed costs.

Let us assume that Friends Company incurred the following costs during the past six months:

Illustration 14: Total costs of Friends Company over the past six months

Month

Vales Production

Total Cost

July

10,000

$44,000

August

15,000

$60,000

September

23,000

$85,000

October

21,000

$75,000

November

19,000

$70,000

December

28,000

$98,000

The lowest level of production was in July and the highest level of production was in December. The difference between the number of units produced and the difference between the total cost at the highest and lowest levels of production are shown below:

 

Production

Total Cost

Highest Level

28,000 units

$98,000

Lowest Level

10,000 units

$44,000

Difference

18,000 units

$54,000

As the total fixed cost does not change with changes in the production volume, the difference in the total costs represents the change in the total variable costs. So, if we divide the difference in the total costs by the difference in the production levels, we will have an estimate of the variable cost per unit:

Variable Cost per Unit = $54,000 ÷ 18,000 units = $3

The variable cost per unit is $3. The fixed cost will be the same at both the highest and lowest levels of production because fixed costs don't change. In order to estimate the fixed costs, we have to subtract the estimated total variable cost from the total cost:

Total Cost = Variable Cost per Unit x Units of Production + Fixed Cost

Highest level:

$98,000 = $3 x 28,000 + Fixed Cost

Fixed Cost = $14,000

Lowest level:

$44,000 = $3 x 10,000 + Fixed Cost

Fixed Cost = $14,000

The fixed costs equal $14,000. Knowing the fixed costs and the variable cost per unit we can estimate the total costs for the planned production level by using the formula below:

T = F + V x N,

where T is the total cost, F is the fixed cost, V is the variable cost per unit, and N is the number of units to be produced.

Using the formula presented above and the fixed cost and variable cost per unit, we obtain the following formula for our example:

T = $14,000 + $3 x N

The methodology presented above is the high-low method of separating mixed costs. The advantage of this method is its simplicity. However, this method ignores all data points other than the highest and the lowest activity levels. The highest and the lowest activity points often do not represent the rest of the points, which leads to a possible inaccuracy of the final results. This is the main disadvantage of this method.

In order to get more precise results, it is better to use the scatter-graph method or the method of least squares.

Not a member?
See why people join our
online accounting course: