People cost
Headcount Cost Bridge
Separate a movement in employee cost into what you pay per head, how many heads you had, and where those heads sat — with contractors and closed teams held apart rather than distorting the rate.
Input data
One row per group. FTE means average FTE for the period, not closing headcount.
| Group | Prior year FTEaverage | Prior year cost | Current year FTEaverage | Current year cost | |
|---|---|---|---|---|---|
Tip: paste a rectangular range from Excel or Sheets.
Employee cost movement
+$1,132,000
Employee cost rose $1,132,000 between the two periods. Average FTE across the groups present in both periods is unchanged at 100, so headcount explains none of the $532,000 those groups moved. The movement on those groups is rate $332,000 and mix $200,000. Outside them, groups new in this period $600,000, each held apart because it has no cost per FTE in both periods to compare.
- Average FTE, common groups
- 100 → 100
- Cost on those groups
- +$532,000
- Cost per FTE, common groups
- $70,000 → $75,320
Cost figures include salary, on-costs and bonus.
Cost bridge
Cost rising is red, falling is green: employee cost is an expense.
Prior year
$7,000,000
Rate
+$332,000
FTE
$0
no effect
Mix
+$200,000
New
+$600,000
Closed
$0
no effect
Cost, no FTE
$0
no effect
Current year
$8,132,000
By group
Cost per FTE is derived, never entered. FTE is a set-level effect and belongs to no single group.
| Group | Set | Cost per FTE Prior year | Cost per FTE Current year | Rate | Mix | Held apart |
|---|---|---|---|---|---|---|
| Engineering | Both periods | $100,000 | $105,000 | +$220,000 | +$1,320,000 | — |
| Support | Both periods | $50,000 | $52,000 | +$112,000 | -$1,120,000 | — |
| Data platform | New | — | $120,000 | — | — | +$600,000 |
Reuse the analysis
Copy the summary, or export the groups and the chart.
Transparent by design
How this calculation works
FTE means average FTE for the period, not closing headcount. A full period of cost divided by a closing headcount is not a cost per head, and every figure here runs through that division.
Cost per FTE
Cost divided by average FTE, per group and per period. Always derived, never entered, so the cost always ties.
Rate effect
Current FTE multiplied by the change in that group’s cost per FTE. Measured at current FTE, so it carries the interaction between a pay change and a headcount change.
FTE effect
The change in total average FTE multiplied by the prior average cost per FTE across the groups present in both periods. A set-level term, never pushed down to a group.
Mix effect
Current FTE multiplied by the gap between that group’s prior cost per FTE and the prior average. It captures the same headcount sitting in more or less expensive teams.
New and closed groups
Held in their own bars at their cost movement, not their cost level. Defining them as movements is what makes the bridge hold for a group recruiting before anyone joined, or paying severance after everyone left.
Cost carrying no FTE
Contractors, agency staff and outsourced teams appear in a payroll report with cost and no headcount. They have no cost per FTE in either period, so they join none of the three effects and get their own bar. Without it the bridge would not reconcile.
Colour
Employee cost is an expense, so a rise is red and a fall is green however positive the number reads. FTE counts and cost levels carry no colour at all, because a level is not a movement.
Reconciliation
Prior cost plus rate, FTE, mix and the three held-apart bars equals current cost. Any residual is shown rather than folded into the rate.