High-Low Method Calculator

In cost accounting and business forecasting, understanding exactly how your costs behave is critical. Some costs are strictly fixed (like rent), and some are strictly variable (like direct materials). However, many business expenses are “mixed costs”—they have both a base fixed fee and an additional variable rate based on usage (like a factory’s electricity bill).

Our free High-Low Method Calculator helps accountants and business managers easily separate these mixed costs. By isolating your fixed costs and your variable cost per unit, you can build accurate budgets and forecast future expenses based on projected activity levels.

How to Calculate the High-Low Method

The High-Low Method uses historical data to estimate cost behavior. As the name suggests, it ignores all data points except for the periods with the highest activity level and the lowest activity level.

The calculation requires two distinct formulas:

Step 1: Find the Variable Cost per Unit

Variable Cost = (Highest Cost - Lowest Cost) / (Highest Activity - Lowest Activity)

Step 2: Find the Total Fixed Cost

Once you have the variable rate, plug it back into the total cost formula using either the High or Low data point (the result will be the same).

Fixed Cost = Total Cost - (Variable Cost × Activity Level)

Step-by-Step Example Calculation

Imagine a manufacturing plant wants to forecast its monthly machinery maintenance costs. Maintenance is a mixed cost: there is a fixed monthly retainer for the mechanics, plus a variable cost for replacement parts based on how many machine hours were logged.

Looking at the last 6 months of data, they identify the extremes:

• Highest Activity Month (August): 8,000 machine hours (Activity) at a total cost of $14,000.
• Lowest Activity Month (February): 4,000 machine hours (Activity) at a total cost of $9,000.

The Final Cost Equation: We now know that the plant’s monthly maintenance cost is a strict $4,000 fixed fee, plus $1.25 for every machine hour logged. If they project 5,000 machine hours next month, they can accurately budget $10,250 for maintenance.

Limitations of the High-Low Method

While the High-Low method is incredibly simple and quick to calculate, it has a significant drawback that accountants must be aware of: it ignores outliers.

Because the formula exclusively relies on only two data points (the absolute highest and lowest), it ignores the behavior of every other month in the dataset. If the “Highest” month was artificially inflated due to an emergency repair or a freak accident, the entire cost formula will be skewed and inaccurate. For highly complex datasets, accountants often prefer to use regression analysis (the least-squares method), which incorporates all data points into the cost estimation.

Frequently Asked Questions (FAQ)

What is a mixed cost in accounting?

A mixed cost (or semi-variable cost) contains both a fixed component that occurs regardless of volume, and a variable component that fluctuates based on production or usage. For example, a salesperson’s compensation (a fixed base salary plus a variable commission per sale) is a mixed cost.

Do I pick the highest cost or the highest activity level?

You must always select the periods with the highest and lowest Activity Level (volume), even if those periods do not have the highest or lowest total costs. Activity drives the cost behavior, so the activity level dictates the data points used in the formula.

Can the calculated fixed cost ever be negative?

Mathematically, yes, if the data is highly irregular. However, logically, a negative fixed cost is impossible in real-world business scenarios. If your High-Low calculation yields a negative fixed cost, it means the dataset has extreme outliers or the cost is not actually a mixed cost, and you should use a scatter graph or regression analysis instead.