Workforce Capacity Planning Calculator

ANA›Life Services Authority›National Calculator Authority›Workforce Capacity Planning Calculator

.calc-container { max-width: 640px; margin: 2rem 0; padding: 1.5rem; background: #fff; border: 1px solid #ddd; border-radius: 8px; box-shadow: 0 1px 3px rgba(0,0,0,0.06); font-family: system-ui, -apple-system, sans-serif; } .calc-container h3 { font-family: Georgia, serif; font-size: 1.15rem; color: #1a1a1a; margin-bottom: 1rem; padding-bottom: 0.5rem; border-bottom: 2px solid var(--ac, #3d5a80); } .calc-row { display: flex; align-items: center; gap: 0.75rem; margin-bottom: 0.75rem; flex-wrap: wrap; } .calc-row label { min-width: 160px; font-size: 0.9rem; color: #333; font-weight: 500; } .calc-row input[type="number"], .calc-row select { flex: 1; min-width: 120px; max-width: 200px; padding: 0.5rem 0.6rem; border: 1px solid #ccc; border-radius: 4px; font-size: 0.9rem; font-family: system-ui, sans-serif; color: #1a1a1a; background: #fafaf8; } .calc-row input:focus, .calc-row select:focus { outline: none; border-color: var(--ac, #3d5a80); box-shadow: 0 0 0 2px rgba(26,74,138,0.12); } .calc-row .unit { font-size: 0.82rem; color: #888; min-width: 30px; } .calc-btn { display: inline-block; margin-top: 0.5rem; padding: 0.55rem 1.5rem; background: var(--ac, #3d5a80); color: #fff; border: none; border-radius: 4px; font-size: 0.9rem; font-weight: 600; cursor: pointer; font-family: system-ui, sans-serif; } .calc-btn:hover { opacity: 0.9; } .calc-result { margin-top: 1.25rem; padding: 1rem 1.25rem; background: #f0f6fc; border-left: 3px solid var(--ac, #3d5a80); border-radius: 0 6px 6px 0; display: none; } .calc-result.visible { display: block; } .calc-result-label { font-size: 0.78rem; text-transform: uppercase; letter-spacing: 0.06em; color: #666; margin-bottom: 0.25rem; } .calc-result-value { font-size: 1.6rem; font-weight: 700; color: var(--ac, #3d5a80); } .calc-result-detail { font-size: 0.85rem; color: #555; margin-top: 0.5rem; line-height: 1.5; } .calc-note { margin-top: 1rem; font-size: 0.8rem; color: #888; font-style: italic; } .calc-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 0.75rem; margin-top: 0.75rem; } .calc-grid-item { padding: 0.6rem 0.8rem; background: #f8f9fa; border-radius: 4px; border: 1px solid #eee; } .calc-grid-item .label { font-size: 0.75rem; color: #888; text-transform: uppercase; letter-spacing: 0.04em; } .calc-grid-item .value { font-size: 1.1rem; font-weight: 600; color: #1a1a1a; } @media (max-width: 720px) { .calc-row { flex-direction: column; align-items: flex-start; gap: 0.3rem; } .calc-row label { min-width: auto; } .calc-row input[type="number"], .calc-row select { max-width: 100%; width: 100%; } .calc-grid { grid-template-columns: 1fr; } } .calc-chart { margin: 1rem 0; text-align: center; } .calc-chart svg { max-width: 100%; height: auto; } .calc-chart-legend { display: flex; flex-wrap: wrap; justify-content: center; gap: 0.6rem 1.2rem; margin-top: 0.6rem; font-size: 0.8rem; color: #555; } .calc-chart-legend span { display: inline-flex; align-items: center; gap: 0.3rem; } .calc-chart-legend i { display: inline-block; width: 10px; height: 10px; border-radius: 2px; font-style: normal; } .calc-related { max-width: 640px; margin: 2rem 0 1rem; padding: 1.25rem 1.5rem; background: #f8f9fa; border: 1px solid #e8e8e8; border-radius: 8px; } .calc-related h3 { font-family: Georgia, serif; font-size: 1rem; color: #1a1a1a; margin: 0 0 0.75rem; padding-bottom: 0.4rem; border-bottom: 2px solid var(--ac, #3d5a80); } .calc-related-list { list-style: none; padding: 0; margin: 0 0 0.75rem; display: grid; grid-template-columns: 1fr 1fr; gap: 0.4rem 1.5rem; } .calc-related-list li a { font-size: 0.88rem; color: var(--ac, #3d5a80); text-decoration: none; } .calc-related-list li a:hover { text-decoration: underline; } .calc-browse-all { margin: 0.5rem 0 0; font-size: 0.9rem; font-weight: 600; } .calc-browse-all a { color: var(--ac, #3d5a80); text-decoration: none; } .calc-browse-all a:hover { text-decoration: underline; } @media (max-width: 720px) { .calc-related-list { grid-template-columns: 1fr; } }

Workforce Capacity Planning Calculator

Calculate required headcount, team utilization, and capacity gaps to align your workforce with business demand.

Total Demand (hours/month)

Working Hours per Employee/Month

Target Utilization Rate (%)

Current Headcount (employees)

Absence / Leave Rate (%)

Average Productivity Rate (%)

Calculate

### Workforce Capacity Results

function worCalc() { var errEl = document.getElementById('wor-error'); var resEl = document.getElementById('wor-result'); errEl.style.display = 'none'; resEl.style.display = 'none';

var demandHours = parseFloat(document.getElementById('wor-demand-hours').value); var workHours = parseFloat(document.getElementById('wor-work-hours').value); var utilizationPct = parseFloat(document.getElementById('wor-utilization').value); var currentHeadcount = parseFloat(document.getElementById('wor-current-headcount').value); var absencePct = parseFloat(document.getElementById('wor-absence-rate').value); var productivityPct = parseFloat(document.getElementById('wor-productivity').value);

// Validation var errors = []; if (isNaN(demandHours) || demandHours 100) errors.push("Target Utilization Rate must be between 1 and 100."); if (isNaN(currentHeadcount) || currentHeadcount = 100) errors.push("Absence Rate must be between 0 and 99."); if (isNaN(productivityPct) || productivityPct 100) errors.push("Productivity Rate must be between 1 and 100.");

if (errors.length > 0) { errEl.innerHTML = errors.join(''); errEl.style.display = 'block'; return; }

/ * Core Formulas * ───────────────────────────────────────────────────────────────────────── * Effective Hours per Employee = * workHours × (1 - absenceRate) × productivityRate * * Required Headcount = * demandHours / (effectiveHoursPerEmployee × utilizationRate) * * Current Capacity (hours) = * currentHeadcount × effectiveHoursPerEmployee × utilizationRate * * Capacity Gap (hours) = currentCapacity - demandHours * Positive → surplus; Negative → deficit * * Headcount Gap = currentHeadcount - requiredHeadcount * Positive → overstaffed; Negative → understaffed * * Actual Utilization of Current Team = * demandHours / (currentHeadcount × effectiveHoursPerEmployee) × 100 * ───────────────────────────────────────────────────────────────────────── /

var absenceRate = absencePct / 100; var utilizationRate = utilizationPct / 100; var productivityRate = productivityPct / 100;

var effectiveHours = workHours * (1 - absenceRate) * productivityRate; var requiredHeadcount = demandHours / (effectiveHours * utilizationRate); var requiredHeadcountCeil = Math.ceil(requiredHeadcount);

var currentCapacityHours = currentHeadcount * effectiveHours * utilizationRate; var capacityGapHours = currentCapacityHours - demandHours; var headcountGap = currentHeadcount - requiredHeadcount;

var actualUtilization = (currentHeadcount > 0)
? (demandHours / (currentHeadcount * effectiveHours)) * 100: 0;

// Build result rows var rows = [ ["Effective Hours per Employee / Month", effectiveHours.toFixed(1) + " hrs", "workHours × (1 − absenceRate) × productivityRate"], ["Required Headcount (exact)", requiredHeadcount.toFixed(2) + " FTE", "demandHours ÷ (effectiveHours × utilizationRate)"], ["Required Headcount (rounded up)", requiredHeadcountCeil + " FTE", "⌈ Required Headcount ⌉"], ["Current Team Capacity", currentCapacityHours.toFixed(1) + " hrs/month", "currentHeadcount × effectiveHours × utilizationRate"], ["Capacity Gap", (capacityGapHours >= 0 ? "+" : "") + capacityGapHours.toFixed(1) + " hrs/month", "currentCapacity − demandHours"], ["Headcount Gap", (headcountGap >= 0 ? "+" : "") + headcountGap.toFixed(2) + " FTE", "currentHeadcount − requiredHeadcount"], ["Actual Utilization of Current Team", (currentHeadcount > 0 ? actualUtilization.toFixed(1) + "%" : "N/A"), "demandHours ÷ (currentHeadcount × effectiveHours) × 100"], ];

var tbody = document.getElementById('wor-result-body'); tbody.innerHTML = rows.map(function(r, i) { var bg = i % 2 === 0 ? '#f9f9f9' : '#ffffff'; return '' + '' + r[0] + '' + '' + r[1] + '' + '' + r[2] + '' + ''; }).join('');

// Gap banner var banner = document.getElementById('wor-gap-banner'); if (capacityGapHours >= 0) { banner.style.background = '#eafaf1'; banner.style.color = '#1e8449'; banner.style.border = '1px solid #a9dfbf'; banner.innerHTML = '✅ Capacity Surplus: Your team has ' + capacityGapHours.toFixed(1) + ' hrs/month of spare capacity. ' + 'Consider redeployment or taking on additional demand.'; } else { banner.style.background = '#fdecea'; banner.style.color = '#c0392b'; banner.style.border = '1px solid #f5b7b1'; banner.innerHTML = '⚠️ Capacity Deficit: You need ' + Math.abs(capacityGapHours).toFixed(1) + ' hrs/month more capacity. ' + 'Hire approximately ' + Math.ceil(Math.abs(headcountGap)) + ' additional FTE(s) to meet demand.'; }

resEl.style.display = 'block'; }

#### 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.
Reference: Becker, B. E., Huselid, M. A., & Ulrich, D. (2001). The HR Scorecard. Harvard Business School Press.

Workforce Capacity Planning Calculator

Workforce Capacity Planning Calculator

More Calculators

Read Next

References

Workforce Capacity Planning Calculator

Workforce Capacity Planning Calculator

More Calculators

Read Next

References

Related Authorities