Coverage and efficiency calculations

The Schedule Effectiveness Summary report shows the coverage and efficiency percentage for each day in the reporting period.

Coverage is calculated using this formula:

1 - (Total Understaffed / Interval Requirement)

Efficiency is calculated using this formula:

1 - ((Total Overstaffed + Total Understaffed) / Interval Requirement)
Note: 
  • The percentage values are rounded to the nearest whole number.
  • The interval is defined in the SO_INTERVAL_REQ table.
  • Interval Requirement is the sum of required employees in the SO_INTERVAL_REQ table by department.
  • To count as scheduled for the interval, the employee must be working at or before the start of the interval and at or past the end of the interval.

This table explains how the coverage and efficiency percentages are calculated:

Hour Required Employees Scheduled Employees Understaffed Overstaffed
9:00 2 3 0 1
10:00 2 3 0 1
11:00 2 2 0 0
12:00 2 2 0 0
13:00 3 1 2 0
14:00 3 1 2 0
15:00 3 1 2 0
16:00 3 2 1 0
17:00 2 2 0 0
18:00 2 2 0 0
19:00 2 3 0 1
20:00 2 3 0 1
21:00 1 3 0 2
22:00 1 2 0 1
23:00 1 2 0 1
0:00 1 2 0 1
1:00 2 1 1 0
2:00 2 1 1 0
Totals 36 36 9 9

In this example, coverage is calculated as:

1 - (Total Understaffed / Total Required Employees) = 1 - (9/36) = 75%

Efficiency is calculated as:

1 - ((Total Overstaffed + Total Understaffed) / Total Required Employees) = 1 - (18/36) = 50%