Headcount Forecast Calculator

Forecast headcount by month for every department quickly. Model hires, attrition, transfers, and backfills accurately. Download CSV or PDF to share with leaders securely.

Headcount Forecast Inputs

Add departments, set hiring and attrition, then calculate a month-by-month forecast.

Choose 1–36 months.
Uses YYYY-MM.
Optional reserve for planned coverage.
Controls fractional attrition handling.

Departments

Department Start HC Hires / mo Attrition % / mo In / mo Out / mo Other losses Rehires Avg FTE Remove
Tip: set Avg FTE below 1.00 for part-time heavy teams.

Example Data Table

Sample inputs you can try, then compare your own scenario.

Department Start HC Hires / mo Attrition % / mo Transfers In Transfers Out Other Losses Rehires Avg FTE
Operations 25 2 1.5 0 0 0 0 1.00
Sales 12 1 2.0 0 0 0 0 1.00
Suggested setup Horizon: 12 months • Buffer: 3% • Attrition rounding: Round to nearest

Formula Used

The calculator forecasts headcount per department, month by month, using a simple flow model.

AttritionCount = BeginHeadcount × (AttritionRate% ÷ 100)
EndHeadcountRaw = Begin + Hires + TransfersIn − TransfersOut − AttritionCount − OtherLosses + Rehires
BufferPositions = EndHeadcountRaw × (Buffer% ÷ 100)
EndHeadcount = max(0, EndHeadcountRaw + BufferPositions)
EndFTE = EndHeadcount × AvgFTE
  • Attrition rounding can round to nearest or round down.
  • Buffer adds planned reserve positions on top of the modeled end headcount.
  • Avg FTE converts headcount into full-time equivalent staffing.

How to Use This Calculator

  1. Set the forecast horizon and the starting month.
  2. Add each department and enter starting headcount.
  3. Enter monthly hiring, attrition rate, and transfers.
  4. Add other losses and rehires for backfill planning.
  5. Optionally add a buffer percent for coverage needs.
  6. Click Calculate Forecast to view results.
  7. Use Download CSV or Download PDF to share.

FAQs

1) What does “attrition % per month” mean?
It estimates monthly exits as a percent of beginning headcount. For example, 2% with 50 people forecasts about one exit per month, depending on rounding.
2) How is the buffer applied?
Buffer adds reserve positions after calculating the raw end headcount. It helps model coverage for leave, training time, or planned contingency hiring.
3) Can I forecast part-time teams?
Yes. Set Avg FTE below 1.00 for departments with part-time staff. The forecast will show both headcount and FTE totals.
4) How do transfers affect totals?
Transfers move people between teams. At company total level, they may cancel out if tracked consistently, but they matter for departmental planning and capacity.
5) What are “other losses” and “rehires”?
Other losses cover planned reductions like contract endings or role eliminations. Rehires represent returning employees or quick backfills beyond the standard hiring plan.
6) Why might my forecast drop to zero?
If exits and losses exceed hires, the model can reduce headcount. The calculator never allows negative values, so it floors at zero for safety.
7) How do I share results with leadership?
Run your scenario, then use the CSV for spreadsheets or the PDF for quick review. For multiple scenarios, rerun with new inputs and export each report.

Related Calculators

employee utilization rate

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.