1. Introduction and Objectives
Because real-world operational costs are frequently mixed (semi-variable), management accountants must apply mathematical techniques to separate them into their distinct fixed and variable components. This is essential for accurate budgeting and CVP forecasting.
2. High-Low Method
An operational shortcut that uses the data points from the highest and lowest activity levels within a dataset to calculate the variable rate and fixed baseline.

  • Step 1: Calculate Variable Cost per Unit (b):
    b = (Cost at Highest Activity Level − Cost at Lowest Activity Level) / (Highest Activity Level − Lowest Activity Level)

    Step 2: Calculate Total Fixed Cost (a):
    Fixed Cost = Total Cost at Highest Level − (b × Highest Activity Level)

3. Computational Exercise
An analysis of a manufacturing firm’s maintenance records reveals the following history:
  • Highest Month (January): 4,000 machine hours, costing $22,000.
  • Lowest Month (August): 1,500 machine hours, costing $12,000.

# High-Low Method Calculations
high_hours = 4000
high_cost = 22000
low_hours = 1500
low_cost = 12000

# Step 1: Variable cost per unit (b)
b = (high_cost - low_cost) / (high_hours - low_hours)

# Step 2: Fixed cost calculation (a)
a = high_cost - (b * high_hours)

print(f"Variable rate: ${b:.2f} per machine hour")
print(f"Total Fixed Cost: ${a:.2f}")

 

Evaluating the formulas confirms:

  • Variable Rate (b) = ($22,000 − $12,000) / (4,000 − 1,500) = $10,000 / 2,500 = $4.00 per machine hour

    Total Fixed Cost (a) = $22,000 − ($4.00 × 4,000) = $22,000 − $16,000 = $6,000

    Resulting Cost Formula: Y = $6,000 + $4.00X

4. Ordinary Least Squares (OLS) Linear Regression
The High-Low method has a major limitation: it relies exclusively on two extreme data points, making it vulnerable to distortion from outliers. Global standards prefer OLS Linear Regression, a statistical technique that analyzes all available data points to minimize the sum of squared differences between the actual data and the calculated cost line. This provides a significantly more accurate breakdown of fixed and variable costs.
 
PreviousNext