Absence Rates Job Offer (Team) Formula
Learn how to estimate the team headcount, accepted hires and job offers needed after allowing for absences.
This calculation estimates how many people must be assigned to a team so the expected available workforce reaches a planned active team size. It then converts the remaining headcount gap into an estimated number of job offers using an expected offer acceptance rate.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Estimated Job Offers Needed
Where:
First, increase the planned active team size to cover expected absences. Subtract the current team size to find accepted hires needed, then divide by the expected offer acceptance rate and round up to a whole offer.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| P - plannedTeamSize | The number of people required to be actively available during the planning period. | people |
| A - absenceRate | The expected percentage of assigned team members who will be unavailable. | percent |
| C - currentTeamSize | The number of people currently assigned to the team before new hires start. | people |
| O - offerAcceptanceRate | The expected percentage of job offers that candidates will accept. | percent |
Step-by-Step Calculation
Calculate the availability rate
This is the percentage of assigned team members expected to be available.
availabilityRate = 100 - absenceRate
Calculate required total headcount
Divide the active-team target by the expected availability proportion, then round up because a fraction of a person cannot be assigned.
requiredTeamHeadcount = ceil(plannedTeamSize / (1 - absenceRate / 100))
Calculate the absence allowance
This shows the extra headcount included to cover expected absences.
expectedAbsentPeople = requiredTeamHeadcount - plannedTeamSize
Calculate accepted hires needed
Subtract the current team from the required total, but do not show a negative hiring requirement.
hiresNeeded = max(0, requiredTeamHeadcount - currentTeamSize)
Calculate offers needed
Convert required accepted hires into offer volume using the expected acceptance rate and round up.
jobOffersNeeded = ceil(hiresNeeded / (offerAcceptanceRate / 100))
Example: Maintaining an active team of 20 people
Availability rate
100% - 8%
92%
Required total headcount
ceil(20 / 0.92)
22 people
Absence allowance
22 - 20
2 people
Accepted hires needed
max(0, 22 - 15)
7 hires
Estimated job offers needed
ceil(7 / 0.75)
10 offers
Final Result
Estimated recruitment requirement: 7 accepted hires and about 10 job offers.
Assumptions
- ✓The absence rate applies consistently across the team during the selected planning period.
- ✓The offer acceptance rate reflects the expected candidate pool and recruitment conditions for the roles.
- ✓New hires are assumed to start and become available in time for the period being planned.
- ✓Headcount and job offers are rounded up because partial people and partial offers are not practical.
Limitations
- !Actual absences can be uneven across roles, shifts, locations or time periods.
- !Actual offer acceptance can change with pay, candidate availability, competing offers and recruitment conditions.
- !The calculation does not include employee turnover, vacancies arising later, notice periods, onboarding or training capacity.
- !A headcount estimate does not measure skills, working patterns, productivity or statutory staffing requirements.
Common Mistakes to Avoid
Entering the percentage expected to be available rather than the percentage expected to be absent.
Using the current team size as the target active team size when a different level of active coverage is required.
Treating the estimated offer count as a guarantee of accepted hires.
Including expected turnover within the absence rate instead of modelling likely leavers separately.
Rounding down the required headcount or offer volume.
Related Formulas
Frequently Asked Questions
How do you calculate job offers needed for absence cover?
Calculate the total headcount needed after absences, subtract the current team size, then divide accepted hires needed by the expected offer acceptance rate and round up.
Why is required headcount higher than the planned active team size?
The extra headcount allows for the proportion of the assigned team expected to be unavailable during the planning period.
What happens if the current team is already large enough?
Accepted hires needed becomes zero, so the estimated number of job offers is also zero under this calculation.
Why are results rounded up?
Rounding up avoids planning for less than the calculated coverage requirement, and neither people nor job offers can be fractional.
Does the formula include turnover?
No. Turnover is separate from absence and should be reflected separately when estimating the likely current team size or additional hiring demand.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.