Absence Rates Workload (Individual) Calculator
Estimate how planned absences reduce an individual’s annual working capacity and affect the workload that can realistically be completed.
Overview
This Absence Rates Workload (Individual) Calculator estimates how much annual working capacity remains after expected absence days. Enter contracted hours, normal working days, working weeks, expected absence, and planned workload to see whether the workload fits within the time likely to be available.
How it works
The calculator first estimates annual scheduled hours from weekly hours and working weeks. It calculates average hours per workday, then converts expected absence days into lost hours. Subtracting those lost hours from scheduled annual hours gives the available workload capacity. The planned workload is then compared with that capacity to show the remaining hours and the percentage of available capacity required.
How to use this calculator
- 1Enter the individual’s contracted weekly working hours.
- 2Add the number of days they normally work each week.
- 3Enter the contracted working weeks in the year.
- 4Add the expected number of absence days to allow for.
- 5Enter the planned productive workload in annual hours.
- 6Review the absence-adjusted capacity and any remaining capacity or shortfall.
Example Calculation
Contracted weekly hours
37.5
Working days per week
5
Working weeks per year
52
Expected absence days
15
Planned annual workload
1600
Available annual workload capacity
,1837.5 hours
A person working 37.5 hours over five days has 1,950 scheduled annual hours. Allowing for 15 absence days removes about 113 hours, leaving roughly 1,838 hours of capacity. A 1,600-hour workload therefore leaves about 238 hours available.
Frequently asked questions
What is an individual absence rate?
It is the number of absence days expressed as a percentage of the person's scheduled working days over the period being assessed.
How are absence days converted into hours?
The calculator divides weekly contracted hours by working days per week, then multiplies that average daily hours figure by the expected absence days.
Should annual leave be included as absence?
Usually, annual leave is planned separately from unplanned absence. You can include it only if your workload planning approach treats it as unavailable time and it has not already been removed from working weeks or workload hours.
What does a negative remaining capacity result mean?
A negative result means the planned workload is greater than the estimated capacity available after absences. The size of the negative figure is the estimated hours shortfall.
Why is the available capacity different from contracted annual hours?
Contracted annual hours represent scheduled time before absence. Available capacity deducts the hours estimated to be lost through the absence days entered.
Can this calculator be used for part-time employees?
Yes. Enter the part-time weekly hours, normal working days per week, and the relevant working weeks and absence days for that individual.
Explore Related Calculators
Assumptions and warnings
Assumptions
- Absence days are spread across normal working days and have the same average length as a usual workday.
- Contracted weekly hours and working patterns remain consistent throughout the year.
- The planned workload is measured in productive hours and can be compared directly with available working hours.
- The result is an estimate and does not account for changes in workload, overtime, training, public holidays, annual leave, or cover arrangements unless included in the values entered.
Warnings
- This calculator provides a planning estimate only; actual absence and available capacity can vary.
- Do not use the result as the sole basis for employment, performance, or staffing decisions.