toolbox
Home / Jobs, Pay & Workforce / Workforce Planning Capacity Gap Calculator

Workforce Planning Capacity Gap Calculator

The Workforce Planning Capacity Gap Calculator compares required workforce capacity with the employees expected to be available after planned hiring and attrition. It converts each employee into productive capacity using a utilization assumption, then shows whether the plan leaves a shortfall or provides excess capacity.

The calculator is useful when a headcount plan needs to be tested against workload rather than viewed as a staffing number alone. Capacity is expressed in full-time-equivalent (FTE) units, so it can accommodate a productivity or availability factor without assuming every paid employee contributes 100% of theoretical capacity.

Calculator inputs

FTE
people
hires
%
%
Result
—
Workforce capacity gap
Expected available headcount—
Productive capacity—
Capacity surplus—

1. Enter required capacity
Use the FTE capacity needed to meet the workload or service target for the planning period.

2. Enter current headcount
Use the number of employees currently in the workforce population being modeled.

3. Add planned hires
Enter hires expected to join within the planning horizon.

4. Estimate attrition
Apply the expected departure rate to current headcount for the same period.

5. Set productive utilization
Enter the average share of nominal headcount that is available for productive capacity after normal non-productive time.

6. Review the gap
The calculator compares productive capacity with the required FTE level and reports any shortfall or surplus.

Expected available headcount = Current headcount × (1 − Attrition rate) + Planned hiresProductive capacity (FTE) = Expected available headcount × Utilization rateCapacity gap = max(Required capacity − Productive capacity, 0)

Where:

Required capacity = workload requirement expressed in FTE
Current headcount = employees in scope at the start of the period
Planned hires = employees expected to join during the period
Attrition rate = expected departure share of current headcount
Utilization rate = share of available headcount contributing productive capacity

Assumptions: Attrition is applied to current headcount only, and all planned hires are treated as available for the modeled period. The model does not prorate join or departure dates.

What the result means

Use the headline result as a planning estimate based on the inputs and assumptions shown above.

Keep all inputs on a consistent period, cohort, and unit basis when comparing scenarios.

Given:
Required capacity = 260 FTE
Current headcount = 240
Planned hires = 35
Expected attrition = 10%
Productive utilization = 90%

Calculation:
Expected available headcount = 240 × (1 − 0.10) + 35 = 251
Productive capacity = 251 × 0.90 = 225.9 FTE
Capacity gap = 260 − 225.9 = 34.1 FTE

Result:
Workforce capacity gap = 34.1 FTE

Even with 35 planned hires, attrition and a 90% utilization assumption leave the plan about 34.1 FTE below the required capacity.

Why use utilization instead of headcount alone?

Headcount does not always equal productive capacity because of meetings, training, leave, administrative work, or other non-productive time. Utilization converts available headcount into an FTE-equivalent capacity estimate.

Should attrition apply to planned hires too?

This simple model applies attrition only to current headcount. For a longer planning horizon or high turnover among new hires, use a more detailed cohort model.

What if productive capacity exceeds the requirement?

The main capacity gap becomes zero and the excess is reported as surplus capacity. That indicates the entered plan provides more productive FTE than required.

Can I use this for part-time employees?

Yes, if current headcount and planned hires are converted to consistent FTE equivalents before entry, or if your utilization assumption appropriately reflects the reduced availability.

Why can hiring more people still leave a gap?

Planned hires may be offset by attrition, and utilization below 100% reduces productive FTE. The required capacity can therefore remain above the modeled available capacity even when gross headcount grows.