Bradford Factor report

Overview

This report provides insight into team member attendance levels. It displays data related to the calculation of the individual Bradford Factor Score and Weighted Bradford Factor Score for each team member.

The Bradford Factor is a simple calculation that can be used to highlight frequent, short-term, unplanned employee absences. It was originally designed to highlight the greater disruption to an organisation's performance caused by many short absences compared with occasional long absences. In this report, the calculation is used to help identify those individuals with absence patterns that may warrant further investigation. It can be run at a Staff, Team, Department or Group level.

Bradford Factor Score calculation.

B = Bradford Factor Score

S = an individual's total number of instances (spells) of unplanned absence over a set period

D = the total number of days of unplanned absence of the individual over the same period

 

Weighted Bradford Factor Score calculation.

The normal Bradford Factor calculation does not differentiate between an individual being absent for a whole day, and them being absent for only part of a day. A partial day of absence will always be rounded up to one whole day. The weighted Bradford Factor therefore adjusts the normal Bradford Factor Score calculation to take account of these partial days of absence.

The Weighted Bradford Factor Score weights the number of days of unplanned absence (D) by the proportion of the total working hours within these days that the individual was actually absent.

To calculate WD (Weighted Days of Absence), we divide the number of hours of unplanned absence by the number of hours in a normal working day,

WD = Number of hours of unplanned absence

Number of hours in a working day

Example

Imagine an individual was absent for one whole day (7 hours), 3 hours of another day and 3.5 hours of yet another day. This would give 3 rounded days, but 1.93 Weighted Days:

(7 + 3 + 3.5) ÷ 7 = 1.93 days

Please note while Bradford Factor calculations are used by many Human Resources departments, they aren’t considered the universal standard for analysing absence patterns, and they may be difficult to use effectively in some environments.

 

Last Date

Select the last date in the period for which you want to run the report.

You can do this by typing the date directly into the cells or by clicking on the calendar function

Period

Select the number of weeks you would like to view the report for. You can select 52,13 or specify weeks from the drop-down menu.

If you select the Specify Weeks option another field will appear allowing you to enter the number of week of data, you would like to view between 1 and 52 weeks.

Downtime

Select the Downtime categories that you would like included in the report from the drop-down menu.

You will see all the Downtime categories linked to the workgroup you are running the report for.

You can choose to include all categories or specific ones by selecting the checkbox next to the category names.

Trigger Point

Here you set a threshold value for the Bradford Factor Score, above which some form of action may be required. Scores above this threshold will be highlighted in red in the resulting report, so that they can be easily identified. The Trigger Point should be defined by your organisation.

If your organisation has not set these parameters another approach to viewing the report would be to consider the calculation used to determine the score and what you might consider an acceptable number of absences for the period being reviewed.

1 instance of absence with a duration of ten days (1 × 1 × 10) = 10 points

2 instances of absence, each of five days (2 × 2 × 10) = 40 points

5 instances of absence, each of two days (5 × 5 × 10) = 250 points

10 instances of absence, each of one day (10 × 10 × 10) = 1000 points

View Report

Click to confirm parameters and View Report.

 

 

The workgroup overview chart details the number of team members that fall within each of the score ranges for the Bradford Factor and Weighted Bradford Factor scores.

.

 

The workgroup details table displays all the team members linked to the workgroup you have run the report for.

Period

Confirms the date range being reviewed.

Search

Refine the list of team members displayed in the table by searching using team member or team names.

Export / Filters

Export the report to Excel. This will export all data even if filters have been applied.

Filter the data displayed in the table using Staff Member or Team.

Staff Member

Team member the row of data relates to. All team members linked to the workgroup will be displayed here.

Team

The team that the team member is linked to, their home team.

Ref ID

If Ref ID’s have been added for team members during setup those will be displayed here.

Employment Type

Employment type currently set for the team member in the staff member setup form.

Episodes of Absences (S)

Total number of instances (spells) of unplanned absence over the selected period.

Days Absence (D)

Total number of days of unplanned absence of the team member over the selected period.

Weighted Days Absence (WD)

The weighted total number of days of unplanned absence of the team member over the selected period.

Bradford Factor Score (S2XD)

The Bradford Factor Score of the team member. Scores highlighted in red, indicate that they are above the Trigger Point chosen in the report parameters.

Weighted Bradford Score (S2XWD)

The Weighted Bradford Factor Score of the team member. Scores highlighted in red, indicate that they are above the Trigger Point chosen in the report parameters.

In the above example we can see that my workgroup has 4 team members 1 of them (Andy Uren) has a Bradford and Weighted Bradford score that is higher than the trigger point set in the report parameters. Clicking on his name will provide me with a calendar view detailing the data captured for him that has driven those Bradford scores.

The summary tiles give you a breakdown of the key metrics used in the Bradford and Weighted Bradford scores for the selected team member.

Staff Member

Confirms the team members name and their Bradford Factor score.

5 x 5 x 12 = 300

Episodes of absence (S) x Episodes of absence (S) x Days absence (D)

Working Days

Number of days within the reporting period that the team member was expected to work.

Episodes of Absence (S)

Separate instances of absence.

Days Absence (D)

Total days of absence. In the period reviewed Andy had 5 instances:

2 x 1 day

1 x 3 days

1 x 2 days

5 x 0.5 days

In the normal Bradford score calculation partial day absences are rounded to 1 giving a total of 12 days.

Weighted Days Absence (WD)

Weighted days of absence. In the period reviewed Andy had 5 instances:

2 x 1 day

1 x 3 days

1 x 2 days

5 x 0.5 days

In the weighted Days Absence partial days are not rounded giving a total of 9.5 days.

Bradford Factor Score (S2XD)

Bradford Factor Score

5 x 5 x 12 = 300

Episodes of absence (S) x Episodes of absence (S) x Days absence (D)

Weighted Bradford Score

Weighted Bradford Factor Score

5 x 5 x 9.5 = 237.5

Episodes of absence (S) x Episodes of absence (S) x Weighted Days absence (WD)

The calendar view details all the episodes of absence for each month within the reporting period. This view will also highlight where Overtime has been worked.

The table also provides a view of the Bradford Factor and Weighted Bradford Factor scores for each month included in the reporting period.

Header Description
S Episodes of Absence (S) for the month
D Days Absence (D) for the month
WD Weighted Days Absence (WD) for the month
S2XD Bradford Factor Score for the month
S2XWD Weighted Bradford Factor Score for the month

 

 

For more information on...

Calculations

See Key Equations
Frequently Asked Questions See FAQs