Workforce headcount bridge calculator

Calculate calculated closing headcount by team and calculated company closing headcount with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use calculated closing headcount by team and calculated company closing headcount to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Teams: name, opening headcount, independently observed closing headcount
A,10,9 B,5,8
Movements in order: record ID, hire/exit/transfer, from team or none, to team or none, people
M1,hire,none,A,2 M2,exit,B,none,1 M3,transfer,A,B,3
Calculated closing headcount by team
A: 9; B: 7
Calculated company closing headcount
16
External hires, exits and internal transfers
2, 1, 3
Observed minus calculated closing headcount by team
A: 0; B: 1

Try another scenario

Teams: name, opening headcount, independently observed closing headcount
A,10,9 B,5,7
Movements in order: record ID, hire/exit/transfer, from team or none, to team or none, people
M1,hire,none,A,2 M2,exit,B,none,1 M3,transfer,A,B,3
Calculated closing headcount by team
A: 9; B: 7
Calculated company closing headcount
16
External hires, exits and internal transfers
2, 1, 3
Observed minus calculated closing headcount by team
A: 0; B: 0
Calculation method

Calculation method

Calculated closing headcount by team

Apply supplied movement records in order, rejecting negative or unsafe intermediate headcounts.

Calculated company closing headcount

Sum team balances; internal transfers do not change the company total.

External hires, exits and internal transfers

Sum people by movement type, counting each transfer once rather than as an external hire/exit.

Observed minus calculated closing headcount by team

Compare supplied observed closing team counts to the movement bridge.

Symbols and units
a
Teams: name, opening headcount, independently observed closing headcount
b
Movements in order: record ID, hire/exit/transfer, from team or none, to team or none, people

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A supplied headcount movement bridge, not an HR system update. Movement dates, employment status and the period boundary must already be consistently defined.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

ILO: full-time-equivalent measurement background; the reference schedule here is supplied ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.