Example

Headcount Plan Example

A 100-person technology company in Cambridge with £7M revenue. The People team and Finance team collaborate on the annual headcount plan, which feeds directly into the P&L budget. This plan covers all departments with fully loaded costs including employer NI (13.8%), pension (5%), and benefits.

Example data

Financial model

Department
FTE
Avg Salary
ER NI
Pension
Total Cost
Engineering
38
£68k
£356k
£129k
£3,069k
Product
8
£62k
£68k
£25k
£589k
Sales
18
£55k
£137k
£50k
£1,177k
Marketing
10
£52k
£72k
£26k
£618k
G&A
14
£58k
£112k
£41k
£923k
Customer Success
12
£48k
£79k
£29k
£684k
Total
100
£58k
£824k
£300k
£7,060k
Engineering

Engineering is 38% of headcount and 43% of total cost, reflecting above-average salaries. The plan includes 6 new hires (4 in Q1, 2 in Q3) with a 3-month ramp.

Sales

Sales costs include base salary only. OTE (on-target earnings) with commissions is budgeted separately in the variable compensation line to separate fixed from variable costs.

Total

Total headcount cost of £7.06M represents 101% of revenue -- common for a growth-stage tech company reinvesting heavily in the team. Target is to bring this below 85% as revenue scales.

Formulas

Key formulas

fxEmployer NI = (Salary - £9,100) * 13.8%

UK employer National Insurance at 13.8% above the secondary threshold. This is a significant additional cost that many budget holders underestimate.

fxPension = Salary * 5%

Employer pension contribution at 5% of salary. The legal minimum is 3% but most competitive employers offer 5%+ to attract talent.

fxFully Loaded Cost = Salary + ER NI + Pension + Benefits

The total cost of employment is typically 20-25% above base salary in the UK. This company's average multiplier is 1.22x, reflecting NI, pension, and a small benefits allowance.

Analysis

What makes this example good

Department-level view gives budget owners visibility into their own costs
Fully loaded costs prevent the common error of budgeting salary only
Employer NI and pension broken out separately for transparency
Average salary per department enables benchmarking against market data
New hire plans with ramp periods built into the quarterly phasing

Customisation

How to adapt for your business

1

Add individual position rows for detailed hire-by-hire planning

2

Include start date and ramp period for each planned hire

3

Add a contractor/freelancer section with day rates

4

Include a salary band table for benchmarking and offer management

5

Add a quarterly phasing view showing when costs hit the P&L

Common variations

  • --Position-level plan with individual hire details and start dates
  • --Contractor vs permanent split for flexible workforce planning
  • --Multi-location plan with different salary scales by geography
  • --Headcount plan with attrition assumptions and backfill timing

FAQ

Frequently asked questions

The total cost of employing someone, including base salary, employer NI (13.8%), pension contributions (3-10%), benefits (private health, life insurance), equipment, recruitment fees, and any other employment-related costs. In the UK, expect a 20-30% uplift on base salary.

Build this in Grove FP in 10 minutes

No credit card required. Set up in minutes. 30-day money-back guarantee.