High-Low Method Cost Accounting & Forecasting Calculator

Managerial Cost Accounting: Separating Mixed Costs with the High-Low Method

In corporate budgeting, mixed costs (semi-variable costs) contain both a fixed overhead component (e.g., factory rent, base salaries) and a variable component (e.g., electricity, raw materials, hourly overtime).

Why Activity Level (X) Must Drive the High/Low Selection

• Crucial Rule: The high and low data points must be selected based on the highest and lowest levels of activity, NOT the highest and lowest dollar costs.

• Limitations: The high-low method uses only two extreme data points, making it susceptible to distortion from single-month outliers. For larger statistical datasets, linear regression least-squares estimation is preferred.

How to Use This Calculator

Enter your Highest Activity Level (Units / Hours, X_high) (e.g. 10000), Total Cost at Highest Activity ( , C_high) (e.g. 65000), Lowest Activity Level (Units / Hours, X_low) (e.g. 4000), Total Cost at Lowest Activity ( , C_low) (e.g. 38000), and Target Future Activity Level to Forecast (Units) (e.g. 7500). Results update instantly as you type — adjust any value to compare scenarios.

The Formula

Managerial cost accounting High-Low Method formulas: Cost per Unit (b) = (Cost at Highest Activity - Cost at Lowest Activity) / (Highest Activity Level - Lowest Activity Level) = C_high - C_lowX_high - X_low Fixed Cost (a) = C_high - (b × X_high) = C_low - (b × X_low) Cost Function: Y = a + bX Total Cost: Y_forecast = a + (b × X_target) Cost per Unit = Y_forecastX_target = (a) / (X_target) + b

Worked Example

For example, a manufacturing plant has a low activity of 4,000 machine hours costing 38,000 and a peak high activity of 10,000 machine hours costing 65,000: Variable Cost (b) = (65,000 - 38,000) / (10,000 - 4,000) = (27,000) / (6,000) = \4.50/hour. Total Fixed Cost is 65,000 - (4.50 × 10,000) = \20,000.

• At an expected volume of 7,500 hours, Projected Total Cost is \ = \53,750.

00.

Understanding Your Result

Evaluate your result in the context of your specific use case and relevant industry standards or reference values. A single calculated result is a starting point — test two to three scenarios to understand how sensitive the outcome is to your key input assumptions. For high-stakes decisions, verify your result against a secondary source or subject-matter expert before acting.