Business
Headcount Scenario Calculator
Reconcile opening headcount through planned hires and attrition, estimate scenario-year workforce cost, recruiting expense, and ending revenue capacity. Review the workforce bridge, hiring sensitivity, caveats, and decision guidance.
Ending employee count-
Fully loaded annual cost per FTE-
Current annualized workforce cost-
In-year loaded cost of planned hires-
Annualized loaded cost of departures-
Recruiting and onboarding cost-
Modeled scenario-year workforce cost-
Ending annualized revenue capacity-
Decision view
Headcount scenario cost bridge
Headcount scenario cost bridgeCurrent cost, hires, departures, recruiting, and scenario-year cost are reconciled explicitly.
Scenario-year cost and supported revenue capacityPlanned hires change across the exact scenarios; annual workforce cost and ending revenue capacity are compared as distinct monetary outcomes.
Exact scenario comparisonPlanned hires changes while all other entered assumptions remain constant.
| Planned hires | Ending employee count | Fully loaded annual cost per FTE | Current annualized workforce cost | In-year loaded cost of planned hires | Annualized loaded cost of departures | Recruiting and onboarding cost | Modeled scenario-year workforce cost | Ending annualized revenue capacity |
|---|
Period-by-period detail
Headcount movement and cost ledger
How to use Headcount Scenario Calculator
- Confirm current FTE and loaded annual cost on one workforce definition.
- Enter planned hires and a realistic average in-year start fraction.
- Apply expected attrition and recruiting cost separately.
- Compare in-year cost with ending annualized capacity rather than treating them as the same period measure.
Calculator guide
Understanding Headcount Scenario Calculator
A headcount plan must distinguish closing FTE from in-year cost. Hires contribute only for the entered fraction of the year, while departures remove cost and recruiting adds a separate cash requirement.
Calculation method
How the calculation works
Reconcile current headcount through hires and departures, then estimate loaded in-year cost, recruiting cost, and ending revenue capacity. Expected attrition is applied to current FTE. Ending FTE adds hires and deducts departures. Current annual cost, prorated hire cost, avoided departure cost, and recruiting cost reconcile to scenario-year cost; ending FTE times revenue capacity per FTE gives an annualized capacity reference.
Workforce planning
Separate hiring quantity from hiring readiness
An approved position does not create capacity until the surrounding system is ready.
Worked situations
Practical examples
- Ten hires starting halfway through the year add five full-year cost equivalents.
- Ending revenue capacity is annualized and may exceed revenue achievable during the hiring year.
- Attrition can reduce cost while also removing experienced productive capacity.
Better inputs
Useful tips
- Model hiring cohorts by month when start dates are uneven.
- Include benefits, payroll taxes, bonuses, and recurring tools in loaded cost.
- Track backfills separately from growth hires.
Before relying on the result
Limitations and common mistakes
- The model uses average timing rather than monthly cohorts.
- Ramp productivity, vacancies, severance, equity, promotions, and geography are excluded.
- Revenue capacity per FTE is an assumption, not a forecast.
Reference
Key terms
- Ending FTE
- Opening FTE plus planned hires less expected departures.
- Average start fraction
- Share of a full-year cost attributed to an average planned hire.
- Loaded cost
- Entered recurring annual employment cost per FTE.
- Annualized capacity
- Ending FTE multiplied by entered revenue capacity per FTE.
Important note
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Frequently asked questions
Why prorate hire cost?
A person starting during the year does not normally create twelve months of that year's expense.
Does ending revenue capacity equal forecast revenue?
No. It is an annualized reference that excludes ramp and demand constraints.
How is attrition timed?
The simplified model uses the entered average start fraction as a timing proxy.
Should replacement hires be included?
Yes, but identify them separately in operational planning because they restore rather than expand capacity.