Lesson 3.1 35 min
Fixed and variable costs
Cost behaviour and the relevant range, then mixed costs and how to split one with the high-low method.
Every decision about price or volume depends on knowing which costs go up when the business does more of something. A cost that rises in proportion to activity is variable. A cost that stays the same across a range of activity is fixed. Most decisions in this module come down to sorting costs into those two groups correctly.
Behaviour depends on the activity you measure
A cost is fixed or variable only in relation to a stated measure of activity, called the cost driver. For a cafe the driver is usually cups or items sold. For a plumbing company it is usually billable hours. Milk is variable with lattes sold. Rent is fixed with lattes sold. A plumber's salary is fixed with billable hours, because the plumber is paid for 2,000 hours whether 1,200 or 1,900 of them are billed.
This last point is easy to miss in a service business. Wages feel variable because they are tied to people working, but if staff are salaried or guaranteed hours, wages don't change when one more job comes in. They change when the business hires or lets someone go.
The relevant range
Fixed costs are fixed only within a range of activity. Hartley's three plumbers can bill at most around 6,000 hours a year between them, and realistically fewer. Beyond that the company needs a fourth plumber and a fourth van, and fixed costs jump. The range over which the cost assumptions hold is the relevant range. Every cost model should state its range, and any decision that moves outside it needs a new model.
Mixed costs
Many costs have a fixed part and a variable part. A van has a lease payment that is the same every month and fuel that rises with kilometres driven. A phone plan has a base fee plus usage. To plan with a mixed cost, split it into its two parts.
Total cost = Fixed cost + (Variable cost per unit × Units)
The high-low method
The high-low method splits a mixed cost using two observations: the period with the highest activity and the period with the lowest.
Variable cost per unit = (Cost at high − Cost at low) ÷ (Activity at high − Activity at low)
Fixed cost = Cost at high − (Variable cost per unit × Activity at high)
It is quick and needs only two numbers, which is also its weakness. If either month was unusual, the estimate is off. Choose the high and low points by activity, not by cost, and look at the other months to see whether they sit close to the resulting line. Regression analysis uses every observation and gives a better estimate when you have more than a handful of periods; spreadsheet software can do it with a single function such as SLOPE and INTERCEPT. OpenStax's Principles of Managerial Accounting covers both methods.
Step costs
Some costs are fixed over a narrow band and then jump. A second espresso machine, a part-time supervisor, a larger storage unit. Treat each step as a fixed cost within its band, and note where the next step begins. Many growth plans fail because they assumed a cost would stay flat past a step.
Worked case
Hartley's cost structure
Hartley Plumbing has 3 salaried plumbers, each paid for 2,000 hours a year at $38 an hour. It bills labour at $125 an hour. Materials cost it $40 per billable hour on average and are billed to customers at cost plus 30%. Running the vans costs $7 per billable hour in fuel and wear, on top of their fixed leases. The plan for the year is 3,600 billable hours.
Sorting Hartley's costs by behaviour against billable hours gives this fixed base:
| $ | |
|---|---|
| Plumber wages, 3 × 2,000 hours × $38 | 228,000 |
| Office administrator | 48,000 |
| Shop and yard rent | 24,000 |
| Van leases, 3 vans | 18,000 |
| Liability insurance | 4,800 |
| Dispatch and accounting software | 4,800 |
| Total fixed costs | 327,600 |
Plumber wages are in the fixed list. They total $228,000 for 6,000 paid hours, and that figure doesn't move with billable hours inside the current team size. The variable costs per billable hour are materials and van running costs:
| $ | |
|---|---|
| Labour billed | 125 |
| Materials billed (cost $40 plus 30%) | 52 |
| Revenue per billable hour | 177 |
| Materials at cost | (40) |
| Fuel and van wear | (7) |
| Contribution per billable hour | 130 |
The van cost was itself split from six months of records using the high-low method. The highest-activity month was Mar (345 hours, $3,915); the lowest was May (260 hours, $3,320).
| Month | Billable hours | Van cost $ |
|---|---|---|
| Jan | 280 | 3,475 |
| Feb | 310 | 3,650 |
| Mar | 345 | 3,915 |
| Apr | 300 | 3,610 |
| May | 260 | 3,320 |
| Jun | 330 | 3,800 |
Variable cost per hour is $595 ÷ 85 hours = $7. Fixed cost per month is $3,915 − ($7 × 345) = $1,500, or $18,000 a year, which agrees with the van leases in the fixed cost list.
Template
Cost behaviour and high-low workbook
A cost classification sheet (fixed, variable or mixed, with driver) and a high-low sheet that picks the high and low activity months, computes the split, and compares it with a SLOPE and INTERCEPT fit. Hartley's figures are loaded.
The full working file, 3-1-cost-behaviour.xlsx, is in the Accounting and Finance Toolkit, Part 1. The lesson above teaches the method and shows the worked numbers, so you can build it yourself in any spreadsheet.
Exercises
Work these, then open the answers
Classify for Northside, against cups sold: rent, coffee beans, card processing fees, the manager's salary, paper cups, the POS software subscription.
Answer
Variable: coffee beans, card processing fees, paper cups. Fixed: rent, the manager's salary, the POS subscription.
Using Hartley's split, what van cost would you expect in a month with 320 billable hours?
Answer
$1,500 + ($7 × 320) = $3,740.
Hartley hires a fourth plumber at the same salary. Which costs change, and what kind of cost is the plumber's salary?
Answer
Fixed costs rise by the new salary ($38 × 2,000 = $76,000) and, if a fourth van is needed, by its lease. The salary is a step cost: fixed within a team size, jumping when the team grows.
Check
4 questions
Sources
Sources
- Principles of Accounting, Volume 2: Managerial Accounting, OpenStax, Rice University