Headcount Planning Calculator
Project ending headcount from hires and separations.
How headcount planning works
Headcount planning projects your ending headcount for a period from where you started, how many people you plan to (or did) hire, and how many separations occurred — the basic building block of workforce planning and budgeting.
Enter your starting headcount, planned or actual hires, and separations for the period. The calculator returns the ending headcount, the net change, and the growth rate.
Use this both for forward planning (projecting where headcount will land given a hiring plan) and for after-the-fact reporting (reconciling actual headcount movement).
The formula
Ending headcount = Starting headcount + Hires − Separations
Add hires to the starting headcount and subtract separations. Growth rate is the net change divided by the starting headcount, as a percentage.
Worked example
200 starting headcount, 30 hires, 12 separations
200 + 30 − 12 = 218 ending headcount, a net change of +18, or 9% growth.
Frequently asked questions
Can I use this for forward planning as well as reporting?
Yes — enter planned hires and expected separations (e.g. based on your historical turnover rate) to project where headcount will land, or enter actuals to reconcile what happened.
What if starting headcount is zero?
The ending headcount still calculates correctly, but a growth rate percentage isn't meaningful from a zero base, so the calculator reports it as not applicable in that case.
Does this account for internal transfers?
No — this tracks external hires and separations only. If you need to model transfers between teams that don't change overall company headcount, track those separately.
Related tools
Built by PanelRoster
PanelRoster is an enterprise operations management platform for organizations coordinating distributed teams, assignments, workflows, quality assurance and operational execution.
Explore PanelRoster