Many costs have a fixed part and a variable part. The high-low method calculator uses the highest and the lowest activity levels to estimate the variable cost per unit and the fixed cost, and then predicts the total cost for a new level of activity.
How the calculation works
- Find, in your records, the period with the highest activity level and the period with the lowest activity level, and enter the total cost of each (not the highest and lowest costs).
- Enter the activity level you expect for the next period.
- The calculator finds the variable cost per unit = (high cost − low cost) / (high activity − low activity).
- It then finds the fixed cost = high cost − variable cost × high activity, and the predicted cost = fixed cost + variable cost × expected activity.
Example
A plant spent $84,000 at its highest activity of 12,000 units, and $59,000 at its lowest activity of 7,000 units. The variable cost is (84,000 − 59,000) / (12,000 − 7,000) = $5.00 per unit. The fixed cost is 84,000 − 5 × 12,000 = $24,000. For an expected activity of 10,000 units, the predicted cost is 24,000 + 5 × 10,000 = $74,000, or $7.40 per unit, of which 32.4 % is fixed.
Why it matters
The calculator helps accounting students, managers and small business owners to build a cost equation from just two observations, to prepare a budget and to feed a break-even or flexible budget analysis. It also shows how much of the predicted cost is fixed, which tells how much the cost will change if the activity changes.
Good to know
The high-low method uses only two data points and assumes a linear cost behavior inside the relevant range. It can be misleading if one of the points is unusual. For decisions of size, use a regression on many observations. The costs and activities must be taken from the same periods and with the same unit of measure.
Related tools
The break-even calculator uses the cost equation to find the sales needed, the overhead rate calculator finds the rate used to apply overhead, the flexible budget variance calculator separates volume from spending, and the operating leverage calculator shows the effect of fixed costs on profit.