Absence Rates Turnover Calculator
Calculate employee absence and staff turnover rates, along with estimated absence and replacement costs.
Overview
This Absence Rates Turnover Calculator estimates the percentage of working time lost to employee absence and the share of your workforce that left during a chosen period. Add your average headcount, absence days, working days, leavers and cost assumptions to review the potential business impact.
How it works
The absence rate is calculated by dividing estimated total absence days by total available working days, then multiplying by 100. The turnover rate is the number of leavers divided by average headcount, multiplied by 100. Estimated absence cost is total absence days multiplied by the daily employee cost, while estimated turnover cost is the number of leavers multiplied by the replacement cost per leaver.
How to use this calculator
- 1Enter the average number of employees during the period.
- 2Add the average absence days taken by each employee.
- 3Enter the number of possible working days per employee.
- 4Enter the number of employees who left during the same period.
- 5Add estimated daily employee and replacement costs.
- 6Review the absence rate, turnover rate and estimated costs.
Example Calculation
Average headcount
100
Average absence days per employee
6.5
Working days per employee
260
Number of leavers
12
Average daily employee cost
$200
Replacement cost per leaver
$8,000
Absence rate
2.50%
For 100 employees averaging 6.5 absence days each, the absence rate is 2.50%. With 12 leavers, turnover is 12.00%. The estimated combined absence and turnover cost is $226,000.
Frequently asked questions
How is the employee absence rate calculated?
The calculator divides total absence days by total available working days and expresses the result as a percentage.
How is employee turnover calculated?
Employee turnover is calculated by dividing the number of leavers during the period by the average headcount, then multiplying by 100.
What is average headcount?
Average headcount is the typical number of employees employed during the period. It is often calculated from opening and closing headcount or from periodic headcount records.
Should planned leave be included in the absence rate?
Usually, planned leave such as annual vacation is excluded from absence reporting. Use the absence definition that matches your internal reporting approach.
What costs should be included in replacement cost per leaver?
You may include recruitment, administration, onboarding, training, temporary cover and a reasonable estimate of lost productivity, depending on your purpose.
Can I use this calculator for a quarter rather than a year?
Yes. Use figures from the same quarter for every input, including working days, leavers and cost assumptions.
Explore Related Calculators
Assumptions and warnings
Assumptions
- The absence rate uses total absence days divided by total available working days.
- The turnover rate uses the number of leavers divided by average headcount for the same period.
- Cost estimates depend entirely on the daily employee cost and replacement cost you enter.
- The calculation does not distinguish between voluntary and involuntary turnover or between types of absence.
Warnings
- This calculator provides planning estimates only and is not financial, employment, or legal advice.
- Use consistent measurement periods for all inputs, such as one calendar year or one quarter.