2.2 High-Low Method and Cost Estimation

High-Low Method and Cost Estimation

To prepare operating budgets, perform variance analysis, and quote profitable contract prices, management accountants must split semi-variable (mixed) costs into their discrete fixed and variable components. In the AAT Level 3 MATS exam, the primary technique required for cost separation is the High-Low Method.

---

The Linear Cost Equation ($Y = a + bX$)

The high-low method models total cost using a straight-line mathematical equation:

$$Y = a + bX$$

Where:

• $Y$ = Total Cost (the dependent variable being estimated).
• $a$ = Total Fixed Cost (the vertical intercept representing cost incurred at zero activity).
• $b$ = Variable Cost per Unit of Activity (the gradient of the cost line).
• $X$ = Activity Level (the independent variable, such as units, machine hours, or direct labour hours).

---

Step-by-Step High-Low Method Procedure

To isolate $a$ and $b$ from historical operational data, follow these four strict steps:

Step 1: Select High and Low Activity Levels

Examine the historical data and identify the period with the highest activity level ($X_{\text{high}}$) and the period with the lowest activity level ($X_{\text{low}}$), along with their corresponding total costs ($Y_{\text{high}}$ and $Y_{\text{low}}$).

CRITICAL AAT EXAM RULE: Always select the high and low points based on ACTIVITY LEVEL ($X$), NOT total cost ($Y$). Choosing the highest or lowest monetary cost figure instead of activity volume is a common distractor in exam questions.

Step 2: Calculate Variable Cost per Unit ($b$)

Determine the gradient of the line by dividing the change in total cost by the change in activity level:

$$b = \frac{\text{Cost at Highest Activity} - \text{Cost at Lowest Activity}}{\text{Highest Activity Level} - \text{Lowest Activity Level}} = \frac{Y_{\text{high}} - Y_{\text{low}}}{X_{\text{high}} - X_{\text{low}}}$$

Step 3: Calculate Total Fixed Costs ($a$)

Substitute the calculated variable rate ($b$) and the activity/cost values from either the highest or lowest point into the cost equation:

$$a = Y_{\text{high}} - (b \times X_{\text{high}}) \quad \text{or} \quad a = Y_{\text{low}} - (b \times X_{\text{low}})$$

(Check both points; the derived fixed cost $a$ must be identical for both extreme points).

Step 4: Construct Cost Equation and Forecast Costs

Write the total cost function $Y = a + bX$ and substitute any target activity level ($X_{\text{target}}$) to project future total budgeted costs.

---

Advanced Adjustments to the High-Low Method

In real-world business scenarios and advanced AAT Level 3 exam tasks, historical cost data may be distorted by stepped fixed costs or price inflation. The basic high-low method must be adjusted to produce accurate estimates.

1. Adjusting for Stepped Fixed Costs

If a stepped fixed cost increases between the lowest activity level and the highest activity level (for example, renting an additional storage space when volume exceeds a certain threshold), the step increase must be deducted from the high activity period's cost before applying the high-low formula.

$$\text{Adjusted } Y_{\text{high}} = Y_{\text{high}} - \text{Stepped Fixed Cost Increase}$$ $$\text{Variable Cost per Unit } (b) = \frac{\text{Adjusted } Y_{\text{high}} - Y_{\text{low}}}{X_{\text{high}} - X_{\text{low}}}$$

Once $b$ is derived, determine the base fixed cost $a$ using the low activity point ($Y_{\text{low}}$). For activity levels that trigger the step, add the stepped amount back to $a$.

2. Adjusting for Inflation / Price Level Changes

When historical data spans periods of price changes, total costs at different activity levels reflect different price bases. Costs must be indexed or adjusted to a constant price level before calculating the variable cost gradient $b$.

$$\text{Inflation-Adjusted Cost} = \text{Historical Cost} \times \frac{\text{Target Base Index}}{\text{Historical Period Index}}$$

---

Worked Numerical Examples

Worked Example 1: Standard High-Low Analysis

Scenario: Crestview Ltd recorded the following production activity and total maintenance costs over six operating months:

Step-by-Step Calculation:

1. Identify High and Low Activity Points:

   • Highest Activity ($X_{\text{high}}$): May = 8,400 hours (Cost $Y_{\text{high}} = £49,500$)
   • Lowest Activity ($X_{\text{low}}$): June = 3,500 hours (Cost $Y_{\text{low}} = £27,450$)

2. Calculate Variable Cost per Machine Hour ($b$):

   $$b = \frac{£49,500 - £27,450}{8,400 - 3,500} = \frac{£22,050}{4,900\text{ hours}} = £4.50\text{ per machine hour}$$

3. Calculate Total Fixed Cost ($a$):

   • Using High Point (May): $$a = £49,500 - (£4.50 \times 8,400) = £49,500 - £37,800 = £11,700$$
   • Verification using Low Point (June): $$a = £27,450 - (£4.50 \times 3,500) = £27,450 - £15,750 = £11,700$$

4. Formulate Total Cost Equation:

   $$Y = £11,700 + £4.50X$$

5. Forecast Budgeted Cost for 6,200 Hours:

   $$Y = £11,700 + (£4.50 \times 6,200) = £11,700 + £27,900 = £39,600$$

---

Worked Example 2: High-Low Analysis with Stepped Fixed Cost Adjustment

Scenario: Dynamic Logistics Ltd tracks fleet maintenance costs across output volumes:

• Lowest Activity: 4,000 miles; Total Cost = £38,000
• Highest Activity: 10,000 miles; Total Cost = £79,000

Additional Condition: When fleet mileage exceeds 7,000 miles, an additional service garage bay is leased, increasing fixed costs by £5,000 per period. The high activity level (10,000 miles) includes this £5,000 step, whereas the low activity level (4,000 miles) does not.

Step-by-Step Calculation:

1. Adjust High Activity Total Cost for the Step:

   $$\text{Adjusted } Y_{\text{high}} = £79,000 - £5,000 = £74,000$$

2. Calculate True Variable Cost per Mile ($b$):

   $$b = \frac{\text{Adjusted } Y_{\text{high}} - Y_{\text{low}}}{X_{\text{high}} - X_{\text{low}}} = \frac{£74,000 - £38,000}{10,000 - 4,000} = \frac{£36,000}{6,000\text{ miles}} = £6.00\text{ per mile}$$

3. Calculate Base Fixed Cost ($a$):

   • Using Low Point (4,000 miles, below step threshold): $$a = £38,000 - (£6.00 \times 4,000) = £38,000 - £24,000 = £14,000$$

4. Formulate Cost Equations:

   • For volume up to 7,000 miles: $Y = £14,000 + £6.00X$
   • For volume exceeding 7,000 miles: $Y = (£14,000 + £5,000) + £6.00X = £19,000 + £6.00X$

5. Forecast Budgeted Cost for 8,500 Miles (exceeds 7,000 miles step threshold):

   $$Y = £19,000 + (£6.00 \times 8,500) = £19,000 + £51,000 = £70,000$$

---

Common AAT Exam Traps

• Exam Trap 1: Selecting Data Points by Cost ($Y$) instead of Activity ($X$): Always select high and low data points by activity volume ($X$)!
• Exam Trap 2: Forgetting to Remove Stepped Fixed Costs Before Calculating Gradient: If a step occurred between high and low points, subtract the step from $Y_{\text{high}}$ first.
• Exam Trap 3: Extrapolating Beyond the Relevant Range: Cost estimations are only valid within the historical relevant range.