Absence Rates Workload (Team) Calculator Examples
Worked examples show how expected absences affect team capacity, workload coverage, and staffing needs.
These examples use different team sizes, absence rates, and workload levels to show how absence-adjusted capacity can be interpreted for workforce planning.
Capacity meets a small team's planned workload
Small support team planning for a 20-day period.
Input Summary
Team size
5 people
Working days
20 days
Hours per day
8 hours
Absence rate
5%
Planned workload
720 hours
Calculation Breakdown
- 1Scheduled hours5 × 20 × 8800 hours
- 2Available capacity800 × (1 − 0.05)760 hours
- 3Workload shortfallmax(720 − 760, 0)0 hours
- 4Capacity utilisation720 ÷ 760 × 10094.7%
Result Summary
Capacity utilisation
94.7%
Absence Rates Workload (Team) Calculator
The team has an estimated 760 available hours and no workload shortfall.
Monthly workload gap for a ten-person team
Standard monthly workforce planning example.
Input Summary
Team size
10 people
Working days
22 days
Hours per day
8 hours
Absence rate
6%
Planned workload
1,750 hours
Calculation Breakdown
- 1Scheduled hours10 × 22 × 81,760 hours
- 2Absence hours1,760 × 0.06105.6 hours
- 3Available capacity1,760 − 105.61,654.4 hours
- 4Additional FTE95.6 ÷ 1760.54 FTE
Result Summary
Additional FTE
0.54 FTE
Absence Rates Workload (Team) Calculator
The plan has a 95.6-hour shortfall, or approximately 0.54 FTE.
High absence rate in a larger operations team
Fifteen people are planned over 21 days with a 12% absence rate.
Input Summary
Team size
15 people
Working days
21 days
Hours per day
7.5 hours
Absence rate
12%
Planned workload
2,150 hours
Calculation Breakdown
- 1Scheduled hours15 × 21 × 7.52,362.5 hours
- 2Available capacity2,362.5 × 0.882,079 hours
- 3Workload shortfall2,150 − 2,07971 hours
- 4Capacity utilisation2,150 ÷ 2,079 × 100103.4%
Result Summary
Capacity utilisation
103.4%
Absence Rates Workload (Team) Calculator
Expected capacity is 2,079 hours, leaving a 71-hour shortfall.
How to Read Your Results
Available capacity is the estimated staff hours remaining after the selected absence rate is applied.
A workload shortfall of zero means total estimated capacity meets planned hours; it does not confirm skill or shift coverage.
Additional FTE translates the gap into an average full-time staffing equivalent for the selected period.
Capacity utilisation below 100% indicates headroom; above 100% indicates that planned demand exceeds estimated capacity.
Assumptions & Important Notes
- Examples assume all staff have identical daily hours.
- Absence is treated as an even percentage of scheduled time.
- Planned workload and capacity cover exactly the same dates.
- Hours are treated as interchangeable across the team.
Related Examples
Frequently Asked Questions
Can I use the calculator for weekly and monthly planning?
Yes. Use matching working days, daily hours, absence rate, and workload hours for whichever period you are planning.
Why can a team have no shortfall but still be at risk?
A small amount of spare capacity can be used quickly if absences increase, new work arrives, or capacity is not available in the required roles or shifts.
Should I enter overtime as team capacity?
Only include overtime if it is genuinely planned, feasible, and measured consistently with the workload hours.
Can I calculate separate teams or roles?
Yes. Running separate estimates for different roles or skill groups can be more useful when staff are not interchangeable.
Ready to calculate your own result?
Use the live calculator with your own inputs, timing, and preferences.