4.1 Linear Functions & The High-Low Method

4.1 Linear Functions & The High-Low Method

In management accounting, planning, budgeting, and control require accurate predictions of future expenditure across varying operational volumes. Many organizational costs are neither purely fixed nor purely variable; instead, they exhibit semi-variable (mixed) cost behaviour, containing both a constant base charge and a usage-dependent component. Before an organization can construct flexible budgets, calculate break-even points, or evaluate variance reports, management accountants must separate mixed costs into their underlying fixed and variable elements.

1. Structure of Linear Functions and Cost Equations

Linear functions provide the foundational mathematical framework for cost modeling in management accounting. Within a defined operational window, mixed costs are represented by the standard straight-line equation:

$y = a + bx$

Where:

• $y$ = Total Cost: The dependent variable plotted on the vertical axis ($y$-axis). Its magnitude depends directly on the level of activity undertaken.
• $a$ = Total Fixed Cost: The vertical intercept on the $y$-axis. It represents the cost that would theoretically be incurred at zero activity level within the relevant range. Fixed costs include facility rent, basic equipment leasing, and executive salaries.
• $b$ = Variable Cost per Unit: The slope (gradient) of the line. It reflects the marginal rate of expenditure per unit of output or activity. Variable costs include direct raw materials, standard direct labor hours, and production electricity consumption.
• $x$ = Activity Level: The independent variable plotted on the horizontal axis ($x$-axis). It serves as the primary cost driver (e.g., units manufactured, machine hours run, direct labor hours worked, or vehicle miles driven).

  Total Cost ($)
        ^
        |                              / Total Cost Line (y = a + bx)
        |                            / 
        |                          /   <-- Slope = b (Variable Cost per Unit)
        |                        /   
        |                      / 
      a |--------------------/ <------- Vertical Intercept = a (Fixed Cost)
        |                    | 
        |   Fixed Cost (a)   | 
        |                    | 
      0 +--------------------+----------------------------> Activity Level (x)
        0                  Relevant Range

The Concept of the Relevant Range

A fundamental assumption underpinning linear cost equations is the relevant range. The relevant range represents the specific band of activity over which budgeted sales and production volumes are expected to operate, and within which established cost behaviours remain valid:

1. Total fixed costs remain constant in absolute terms.
2. Variable cost per unit remains constant regardless of output fluctuations.
3. Operational efficiency, technology, and factor prices remain unchanged.

If activity expands beyond the relevant range, the enterprise may need to acquire additional factory floor space (causing fixed costs to step up) or hire weekend workers at premium wage rates (causing variable cost per unit to rise).

2. Scatter Diagrams and Visual Inspection

A scatter diagram (or scattergraph) is a graphical representation of historical bivariate cost data. Historical observations are plotted as paired coordinates $(x_i, y_i)$, where each point reflects the total cost incurred at a specific recorded activity level.

  Cost ($)
     ^
     |        *             * (Outlier: Equipment Breakdown)
     |                  *  
     |             *   *  
     |        *   *    
     |      *   * <------- Line of Best Fit (Drawn by Eye)
     |    * 
     |  *
   a |------------------------------------
     |                                      
   0 +-----------------------------------> Activity Level (x)

Mechanics and Purpose

• Visual Inspection: Management accountants plot 12 to 24 months of historical cost observations. By inspecting the resulting cluster of points, analysts evaluate whether a genuine linear relationship exists between activity and expenditure.
• Identifying Outliers: Scatter diagrams reveal unrepresentative historical periods—such as a month where costs spiked due to an unprecedented flood or machine breakdown, or dropped due to a prolonged labor strike. Outliers can be flagged and excluded before formal mathematical modeling.
• Line of Best Fit by Eye: An analyst uses a straight edge to draw a line through the center of the plotted points, balancing points above and below the line. The point where this line intersects the vertical axis provides a rough estimate of total fixed costs ($a$), and the slope provides an approximation of the variable rate ($b$).

Limitations of Scatter Diagrams

• Subjectivity: Visual inspection relies heavily on individual judgment. Two management accountants viewing the same scatter diagram will invariably draw slightly different lines, yielding divergent fixed and variable cost parameters.
• Inability to Minimize Errors: Visual inspection does not mathematically minimize estimation errors across all observed data points.

3. High-Low Method Mechanics

The high-low method is an algebraic technique used to separate mixed costs into fixed and variable components by comparing total costs at two distinct historical activity levels.

The Cardinal Rule of Selection

CRITICAL ACCA EXAM RULE: The high and low points must be selected based strictly on the HIGHEST AND LOWEST ACTIVITY LEVELS ($x$), never on the highest and lowest dollar costs ($y$).

Selecting periods based on extreme costs rather than extreme activity introduces severe distortion whenever uncharacteristic operational events or non-volume spending occur during a mid-volume period.

Four-Step Mathematical Procedure

1. Step 1: Identify High and Low Activity Levels: Scan the historical dataset to locate the observation with the maximum activity volume $(x_{\text{high}}, y_{\text{high}})$ and the observation with the minimum activity volume $(x_{\text{low}}, y_{\text{low}})$.
2. Step 2: Calculate Variable Cost per Unit ($b$): Compute the difference in total cost between the two points and divide by the difference in activity volume: $b = \frac{\Delta \text{Cost}}{\Delta \text{Activity}} = \frac{\text{Cost at High Activity} - \text{Cost at Low Activity}}{\text{High Activity Level} - \text{Low Activity Level}} = \frac{y_{\text{high}} - y_{\text{low}}}{x_{\text{high}} - x_{\text{low}}}$
3. Step 3: Calculate Total Fixed Cost ($a$): Substitute the calculated unit variable rate ($b$) into either the high activity equation or the low activity equation and solve for $a$: $a = y_{\text{high}} - (b \times x_{\text{high}}) \quad \text{or} \quad a = y_{\text{low}} - (b \times x_{\text{low}})$ (Both substitutions yield the exact same fixed cost figure, providing an immediate arithmetic check).
4. Step 4: Formulate the Forecasting Equation: Construct the finalized cost model $y = a + bx$ and predict total expenditure for the budgeted activity volume ($x_{\text{target}}$): $y_{\text{target}} = a + (b \times x_{\text{target}})$

4. Fully Worked Example: Standard High-Low Application

Operational Data

Vanguard Precision Engineering Ltd records total maintenance overhead expenditure across six consecutive operating months:

Management wishes to forecast total maintenance overheads for July, when budgeted production requires 6,000 machine hours.

Step-by-Step Calculation

Step 1: Identify extreme activity points:

• Highest Activity (May): $x_{\text{high}} = 7,000$ machine hours, $y_{\text{high}} = $62,000$
• Lowest Activity (March): $x_{\text{low}} = 3,200$ machine hours, $y_{\text{low}} = $39,200$

Step 2: Calculate variable cost per machine hour ($b$): $\Delta \text{Activity} = 7,000 - 3,200 = 3,800 \text{ machine hours}$ $\Delta \text{Cost} = \$62,000 - \$39,200 = \$22,800$ $b = \frac{\$22,800}{3,800 \text{ hours}} = \$6.00 \text{ per machine hour}$

Step 3: Solve for total fixed costs ($a$):

• Using May (High Point): $a = \$62,000 - (7,000 \times \$6.00) = \$62,000 - \$42,000 = \$20,000$
• Verification using March (Low Point): $a = \$39,200 - (3,200 \times \$6.00) = \$39,200 - \$19,200 = \$20,000$

The maintenance cost equation is: $y = \$20,000 + \$6.00x$

Step 4: Forecast maintenance costs for July ($x = 6,000$ machine hours): $y_{\text{July}} = \$20,000 + (6,000 \times \$6.00) = \$20,000 + \$36,000 = \$56,000$

5. Handling Stepped Fixed Costs in the High-Low Method

In many production environments, fixed overheads do not remain strictly flat across all activity tiers. Instead, they behave as stepped fixed costs, jumping by a lump sum when operational thresholds are breached (e.g., leasing a secondary warehouse or appointing an additional quality supervisor).

  Total Fixed Cost ($)
        ^
        |                              +------------------ Higher Fixed Cost ($43,000)
        |                              |
        |                              | <-- Step Increase = $15,000
        |                              |
 $28,000|------------------------------+
        |    Base Fixed Cost ($28,000)
        |                              | 
      0 +------------------------------+-------------------> Activity Level (Units)
        0                            6,000 Units

Analytical Adjustment Rule

To calculate the variable cost per unit ($b$) accurately, both data points must be adjusted to the same fixed cost baseline. If fixed costs step up at an intermediate activity level between the low and high observations:

1. Subtract the step increase from the high activity total cost (bringing it down to the low-volume fixed cost tier); OR
2. Add the step increase to the low activity total cost (bringing it up to the high-volume fixed cost tier).

Worked Example: Stepped Fixed Costs

• Low Activity: 4,000 units, Total Cost = $52,000
• High Activity: 9,000 units, Total Cost = $97,000
• Operating Condition: Total fixed costs increase by $15,000 for production volumes exceeding 6,000 units.
• Objective: Forecast total costs for an output volume of 8,500 units.

Step 1: Normalize costs to a single baseline: Deduct the $15,000 step from the high activity cost to align both points with the baseline fixed cost tier: $\text{Adjusted High Cost} = \$97,000 - \$15,000 = \$82,000$

Step 2: Calculate variable cost per unit ($b$): $\Delta \text{Activity} = 9,000 - 4,000 = 5,000 \text{ units}$ $\Delta \text{Cost} = \$82,000 - \$52,000 = \$30,000$ $b = \frac{\$30,000}{5,000 \text{ units}} = \$6.00 \text{ per unit}$

Step 3: Determine base and stepped fixed costs:

• Baseline fixed cost (for activity $\le 6,000$ units): $a_{\text{base}} = \$52,000 - (4,000 \times \$6.00) = \$52,000 - \$24,000 = \$28,000$
• Stepped fixed cost (for activity $> 6,000$ units): $a_{\text{stepped}} = \$28,000 + \$15,000 = \$43,000$
• Reconciliation at High Point: $$43,000 + (9,000 \times $6.00) = $43,000 + $54,000 = $97,000$ (Confirmed).

Step 4: Forecast total cost for 8,500 units: Because 8,500 units exceeds the 6,000-unit threshold, the higher fixed cost applies: $y = a_{\text{stepped}} + bx = \$43,000 + (8,500 \times \$6.00) = \$43,000 + \$51,000 = \$94,000$

6. Handling Changes in Variable Cost per Unit

Variable costs per unit can shift across operational volumes due to structural supply factors, such as bulk quantity discounts on raw materials (which lower $b$) or overtime premiums on direct labor (which increase $b$).

Worked Example: Quantity Discount Threshold

• Low Activity: 3,000 units, Total Cost = $46,000
• High Activity: 8,000 units, Total Cost = $80,000
• Operating Condition: Direct material quantity discounts reduce the variable cost per unit by 25% for all units produced in excess of 5,000 units. Total fixed costs remain completely unchanged.
• Objective: Calculate the base variable cost per unit, total fixed costs, and forecast expenditure for 7,000 units.

Step 1: Set up the algebraic cost equations: Let $b$ represent the standard variable cost per unit for output up to 5,000 units. For output above 5,000 units, variable cost per unit is: $b_{\text{discounted}} = (1.00 - 0.25)b = 0.75b$

• At Low Activity (3,000 units $\le 5,000$): $\text{Total Cost} = a + 3,000b = \$46,000 \quad \text{--- (Equation 1)}$

• At High Activity (8,000 units): Output consists of 5,000 units at standard rate $b$, plus 3,000 incremental units at discounted rate $0.75b$: $\text{Total Variable Cost} = 5,000b + 3,000(0.75b) = 5,000b + 2,250b = 7,250b$ $\text{Total Cost} = a + 7,250b = \$80,000 \quad \text{--- (Equation 2)}$

Step 2: Solve simultaneously for $b$ and $a$: Subtract Equation 1 from Equation 2: $(a + 7,250b) - (a + 3,000b) = \$80,000 - \$46,000$ $4,250b = \$34,000$ $b = \frac{\$34,000}{4,250} = \$8.00 \text{ per unit}$

• Discounted variable rate (units above 5,000): $0.75 \times \$8.00 = \$6.00 \text{ per unit}$
• Total fixed cost ($a$): $a = \$46,000 - (3,000 \times \$8.00) = \$46,000 - \$24,000 = \$22,000$

Step 3: Forecast total cost for 7,000 units: Production of 7,000 units incorporates 5,000 units at $8.00 and 2,000 units at $6.00: $y = \$22,000 + (5,000 \times \$8.00) + (2,000 \times \$6.00) = \$22,000 + \$40,000 + \$12,000 = \$74,000$

7. Advantages and Limitations of the High-Low Method

8. ACCA Exam Traps & Pitfalls

• Exam Trap 1: Selecting by Cost Rather Than Activity. ACCA exam questions frequently feature a month with moderate activity but inflated costs (e.g., due to emergency repair work). Candidates who pick the highest dollar cost rather than the highest volume score zero on the calculation.
• Exam Trap 2: Omitting Stepped Overheads in Future Projections. When calculating forecasts above a step threshold, candidates often determine the base fixed cost correctly from the low point, but forget to add the step increment back when generating the final budgeted figure.
• Exam Trap 3: Extrapolating Beyond the Relevant Range. Applying high-low parameters to production volumes far above the observed high point assumes an infinite relevant range. In reality, capacity limits will trigger stepped costs or overtime penalties.