Absence Rates Capacity (Team) Calculator
Estimate your team's available working capacity after allowing for employee absence over a chosen period.
Overview
Use this team absence capacity calculator to estimate how many work hours and workdays remain available after accounting for an expected absence rate. Enter the team size, planning period, normal work schedule, and anticipated absence percentage to support workload and staffing plans.
How it works
The calculator first works out the team's total scheduled workdays by multiplying team size by the number of weeks and working days per week. It converts these days into scheduled hours using the hours worked each day. The expected absence rate is then applied to scheduled hours, and the estimated absence hours are deducted to show net available capacity. Average available team members are calculated as the team size remaining after the absence percentage is deducted.
How to use this calculator
- 1Enter the number of people in your team.
- 2Set the number of weeks you want to plan for.
- 3Add the usual working days per week and hours per day.
- 4Enter the expected absence rate as a percentage of scheduled time.
- 5Review the available capacity, expected absence time, and average available staffing level.
Example Calculation
Team size
10
Planning period
4
Working days per week
5
Working hours per day
8
Expected absence rate
5%
Available team capacity
1,520.0 hours
A 10-person team scheduled for four 5-day weeks has 1,600 gross hours. At a 5% absence rate, around 80 hours are lost, leaving an estimated 1,520 available hours, or 190 workdays.
Frequently asked questions
What is an absence rate capacity calculation?
It estimates the portion of your team's scheduled time that remains available after a percentage is allowed for absence. It can help with short-term workload and staffing planning.
How do I calculate team capacity with a 5% absence rate?
Calculate total scheduled hours, then multiply them by 5% to find expected absence hours. Subtract those hours from the scheduled total to estimate available capacity.
Does the absence rate include annual leave?
It can if your percentage has been set to include annual leave. If leave is planned separately, use an absence rate that excludes it to avoid deducting the same time twice.
Should I include public holidays in the working days input?
Use the actual working days in the selected period where possible. Reduce the working days or choose a shorter planning period if public holidays will reduce scheduled work.
Can I use this calculator for part-time teams?
Yes, but the result is most accurate when the hours and days entered reflect the team's average schedule. For significantly different individual schedules, calculate groups separately and combine the results.
Why might actual available capacity differ from the estimate?
Actual results can differ because absence patterns, vacancies, overtime, training, meetings, seasonal demand, and changes to schedules are not automatically included.
Explore Related Calculators
Assumptions and warnings
Assumptions
- The absence rate is applied evenly across the whole team and planning period.
- Each team member is assumed to work the same number of days and hours.
- The estimate treats all scheduled hours as capacity and does not deduct meetings, training, leave types, or non-productive time separately.
- Results are planning estimates and actual absence levels may vary.
Warnings
- Actual capacity can be affected by holidays, part-time schedules, overtime, workload mix, vacancies, and unexpected absences.
- Use this estimate alongside local staffing records and operational plans when making resourcing decisions.