Workforce Capacity Planning Calculator
Calculate required headcount, team utilization, and capacity gaps to align your workforce with business demand.
Formulas Used
Effective Hours per Employee / Month
= Working Hours × (1 − Absence Rate) × Productivity Rate
Required Headcount
= Total Demand (hrs) ÷ (Effective Hours × Target Utilization Rate)
Current Team Capacity (hrs)
= Current Headcount × Effective Hours × Target Utilization Rate
Capacity Gap (hrs)
= Current Team Capacity − Total Demand
Positive = surplus | Negative = deficit
Headcount Gap (FTE)
= Current Headcount − Required Headcount
Positive = overstaffed | Negative = understaffed
Actual Utilization of Current Team
= Total Demand ÷ (Current Headcount × Effective Hours) × 100
Assumptions & References
- A standard working month is assumed to be 160 hours (40 hrs/week × 4 weeks), adjustable per your organisation's calendar.
- Absence / Leave Rate accounts for vacation, sick leave, and public holidays as a percentage of available time. Industry averages typically range from 4–8% (CIPD Absence Management Survey).
- Productivity Rate reflects the proportion of time employees spend on productive work (vs. meetings, admin, etc.). Knowledge-worker benchmarks commonly cite 70–85% (McKinsey Global Institute).
- Target Utilization Rate is the planned percentage of effective hours allocated to demand. Sustained utilisation above 85–90% increases burnout risk (Harvard Business Review).
- Required headcount is always rounded up (ceiling) since partial employees cannot fulfil demand.
- This calculator assumes a homogeneous workforce. For multi-skill or tiered teams, segment calculations by role or grade.
- Reference: Becker, B. E., Huselid, M. A., & Ulrich, D. (2001). The HR Scorecard. Harvard Business School Press.