Absence Rates Sprint Capacity Formula
Learn how sprint capacity is estimated after expected absences and routine team overhead are allowed for.
This formula estimates the delivery-focused time a team may have in a sprint. It starts with scheduled team time, removes an allowance for absences, then removes time typically spent on ceremonies, support, meetings, and other non-delivery work.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Productive Sprint Capacity
Where:
Multiply the team's scheduled person-days by the share expected to remain after absences and then by the share expected to remain after non-delivery overhead.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| teamMembers - Team members | Number of people expected to contribute delivery work during the sprint. | number |
| sprintWorkdays - Sprint working days | Number of normal scheduled workdays in the sprint, excluding weekends. | days |
| absenceRate - Expected absence rate | Percentage of gross scheduled time expected to be lost to leave, sickness, holidays, or other absences. | percent |
| teamOverheadRate - Team overhead rate | Percentage of post-absence time reserved for ceremonies, meetings, support, administration, and other non-delivery work. | percent |
| hoursPerDay - Work hours per person per day | Scheduled work hours for one team member on a normal working day. | hours |
Step-by-Step Calculation
Calculate gross person-days
This is the team's total scheduled capacity before allowing for time away or non-delivery work.
grossPersonDays = teamMembers * sprintWorkdays
Estimate absence time
Apply the expected absence percentage to gross scheduled person-days.
absencePersonDays = grossPersonDays * absenceRate / 100
Find time available after absences
Subtract expected absence time from the gross team capacity.
availablePersonDays = grossPersonDays - absencePersonDays
Calculate productive sprint capacity
Remove the proportion of remaining time expected to go to overhead rather than planned delivery.
productivePersonDays = availablePersonDays * (1 - teamOverheadRate / 100)
Convert capacity into productive hours
Multiply productive person-days by the scheduled hours in one workday.
productiveHours = productivePersonDays * hoursPerDay
Calculate usable team availability
This shows the percentage of original scheduled capacity expected to remain for delivery work.
teamAvailabilityRate = productivePersonDays / grossPersonDays * 100
Worked example: six people over a 10-day sprint
Gross person-days
6 × 10
60 person-days
Expected absence time
60 × 8 / 100
4.8 person-days
Available after absences
60 − 4.8
55.2 person-days
Productive sprint capacity
55.2 × (1 − 20 / 100)
44.16 person-days
Productive hours
44.16 × 8
353.28 hours
Usable team availability
44.16 / 60 × 100
73.6%
Final Result
Estimated sprint capacity: 44.2 productive person-days, or about 353 productive hours.
Assumptions
- ✓All contributing team members have the same scheduled hours per working day.
- ✓The absence rate is applied evenly to the team's total scheduled sprint time.
- ✓The overhead rate is applied after the absence allowance has been removed.
- ✓Known leave, public holidays, and individual availability are represented adequately by the selected absence allowance.
- ✓Productive capacity means time available for planned delivery work, not a guarantee of completed work.
Limitations
- !Actual absences can be higher or lower than the allowance used in the calculation.
- !Team members may have different work schedules, delivery roles, or levels of availability.
- !Unexpected incidents, dependencies, rework, and scope changes can reduce completed work without changing scheduled capacity.
- !A single overhead percentage may not reflect unusually meeting-heavy or support-heavy sprints.
- !Person-days and hours do not directly predict story points because estimation practices differ by team.
Common Mistakes to Avoid
Entering calendar days rather than normal sprint working days.
Leaving known holidays or planned leave out of the absence allowance.
Treating every scheduled hour as delivery time and setting overhead to zero without evidence.
Applying the overhead percentage to gross time separately and then subtracting it again.
Using the calculated person-days as a universal conversion to story points.
Including people who attend the sprint but are not expected to contribute delivery work.
Related Formulas
Frequently Asked Questions
How is sprint capacity calculated with absence rates?
Gross person-days are calculated from team size and sprint workdays. The calculator removes the expected absence percentage and then removes the team overhead percentage from the remaining time.
What is the formula for productive sprint capacity?
Productive person-days = team members × sprint workdays × (1 − absence rate/100) × (1 − overhead rate/100).
Why is overhead removed after absences?
The calculation treats overhead as a share of the time still available after expected absences. This avoids assuming that absent time also produces meeting or support capacity.
How do I convert productive person-days to hours?
Multiply productive person-days by the scheduled hours per person per day. For example, 10 productive person-days at 8 hours per day equals 80 productive hours.
What does usable team availability mean?
It is productive person-days divided by gross scheduled person-days, expressed as a percentage. It shows the share of scheduled time expected to remain for delivery.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.