1. The Management Challenge of Mixed Costs
Mixed costs (such as factory maintenance or IT support) contain a fixed baseline cost plus a variable usage charge. To budget effectively, managers must separate these two components.
 
2. Advanced High-Low Method
The High-Low method isolates cost components by analyzing the periods with the highest and lowest activity levels (volume). It assumes that any change in total cost between these two points is driven entirely by variable costs.
Linear Equation Blueprint
\(Y=a+bX\)
Where:
  • Y = Total Mixed Cost
  • a = Total Fixed Cost
  • b = Variable Cost per Unit of Activity
  • X = The Independent Activity Level Volume

Step-by-Step Mathematical Protocol
  1. Review historical data and identify the periods with the absolute highest and lowest activity levels (X). Warning: Never choose data points based on the highest or lowest cost values; always select points based on activity volume.

  2. Variable cost per unit (b):

    b = (“Cost at Highest Activity” − “Cost at Lowest Activity”)/(“Highest Activity Level” − “Lowest Activity Level”)

     

    2) Total fixed cost (a): (use either the highest or lowest activity point)

    a = “Total Cost” − (b × “Activity Level”)

     

    3.Vulnerabilities and Flaws

The High-Low method is simple to calculate but highly vulnerable to distortions. Because it only evaluates two data points, any unrepresentative spike or drop (an outlier) in the highest or lowest periods will skew the entire formula.
3. The Scattergraph (Visual Fit) Technique
The scattergraph method plots every historical data point from the period onto a chart, with activity on the X-axis and total cost on the Y-axis.
  • The Line of Best Fit: An accountant visually draws a straight line through the center of the data points, balancing the points above and below the line.
  • Fixed Cost Isolation: The point where the drawn line crosses the vertical Y-axis represents the total fixed cost (a).
  • Advantage over High-Low: This method reviews all available historical data visually, allowing the accountant to easily spot and ignore unusual outliers.

 
PreviousNext