Interdepartmental Correspondence Sheet
Date:
8-22-2012
To:
James E. Craig, Police Chief
From:
Sergeant Dan Carder, Inspections Section
Copies to: Subject:
Ten Hour Shift Audit and Evaluation
Recently, the Inspections Section conducted an Audit and Evaluation of the ten hour shifts versus eight hour shifts for Patrol Officers in Districts Two, Three, Four, and Five. Officers assigned to units other than Patrol are not included in this evaluation. Due to reconfiguration which would lead to inaccuracies, District One and the Central Business Section are excluded from this review. THE FINAL PAGE IS A SUMMARY OF THE AUDIT AND EVALUATION INFORMATION. OBJECTIVE The objective of the audit is to compare data prior to and after ten hour shifts were implemented. This audit gauges the impact of the revised workday / off day schedule. SCOPE Data reviewed by the Districts was submitted from various sources, including: Assignment Reports; District Lineups; Fleet Management Monthly Mileage Reports; Fiscal and Budget Payroll Reports, as well as locally prepared forms. Areas reviewed include both operational and financial. Operational refers to the calls for service; single/double units; off time/sick time usage; and fleet usage/mileage. Financial refers to the cost of the officers’ incremental overtime; contingency overtime; court time; and shift differential. The evaluation period began with Pay Period 2 and ended with Pay Period 7 for 2011 (base line) and 2012 (new schedule). METHODOLOGY Each affected District submitted a summary report to Inspections Section. Operational Impact comparisons used data to examine calls for service and on duty officers available to respond. Number of units (single/double officer) available is also reviewed. Officers’ use of various accrued leave (off time) balances and sick time usage was examined. Personnel levels vary slightly from year to year in the affected districts and require a per officer average to accurately depict fluctuations in the off time/sick time usage for the evaluation period. Financial Impact refers to the cost of the officers’ incremental overtime; contingency overtime; court time; and shift differential. The specific cost of the overtime is documented in detail. Different personnel levels in the affected districts required a cost per officer average to accurately depict any fluctuation in cost in overtime for the evaluation period.
DISTRICT TWO 1) STAFFING Starting Times: 2011 (8 hour shifts)
2012 (10 hour shifts)
First Relief:
0600 / 0700 hours
0600 hours
Second Relief:
1300 hours
1400 hours
Late Power:
2100 hours
1900 hours
Third Shift:
2300 hours
2100 hours
The following indicates District Two’s average number of patrol officers on duty and calls for service (CFS). Hourly Average of On-Duty Officers
Hour
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
2011 8 Hr Staffing Averag e 11 11 11 10.9 10 5.5 10 9.6 9.7 9.8 9.8 9.7 9.6 14.3 10.8 12.9 13 12.8 12.7 13.6 13.1 13.3
2012 10 Hr Staffing Averag e 10 10 10 9.8 9.8 5.2 12.1 7.7 7.8 7.8 7.8 7.8 7.7 8.6 15.5 15.7 9.9 9.9 9.9 13.4 13.4 17.5
2
Differenc e
2011 CFS
2012 CFS
Difference
-1 -1 -1 -1.1 -.2 -.3 +2.1 -1.9 -1.9 -2 -2 -1.9 -1.9 -5.7 +4.7 +2.8 -3.1 -2.9 -2.8 -.2 +.3 +4.2
317 235 230 178 120 109 143 224 310 393 402 425 439 415 431 481 481 488 436 392 345 381
321 230 207 154 104 110 143 254 329 396 437 426 430 415 460 517 529 488 459 418 433 381
+4 -5 -23 -24 -16 +1 0 +30 +19 +3 +35 +1 -9 0 +29 +36 +48 0 +23 +26 +88 0
22 23 Average
12.6 11 10.3
17.3 17.1 10.9
+4.7 +6.1 +.6
364 322 336
411 315 349
+47 -7 +13
Following are the average number of hours worked during the study period for each relief. Calculations were made by dividing the total number of hours worked during each shift; that number was then divided by the number of days in the study period. The numbers in ( ) indicates police officers then supervisors assigned to each relief. 2011 - Eight Hour Shifts First Shift: (20/4) Second Shift: (24/6) Third Shift: (22/6)
9.7 PO/PS 12.8 PO/PS 11.2 PO/PS
2.3 Supervisors 2.9 Supervisors 2.9 Supervisors
2012 – Ten Hour Shifts First Shift: (19/5) Second Shift: (22/6) Third Shift: (22/5)
7.4 PO/PS 9.2 PO/PS 9.5 PO/PS
2.1 Supervisors 2.4 Supervisors 2.4 Supervisors
The following table shows the average number of patrol officers fielded on a daily basis. Daily Average of On-Duty Units Shift First Second Third Total Daily
2011 Eight Hour Plan 10.3 13.2 11.8 35.3
2012 Ten Hour Plan 8.2 9.9 9.9 28
Difference -2.1 -3.3 -1.9 -7.3
2) PATROL HOURS/ TOTAL LEAVE HOURS / SICK LEAVE USAGE Patrol Hours represent hours an officer is present for duty during the review period. All forms of sick leave are included. First Shift Patrol Hours 2011 2012
6491 6186 - 305
Total Leave Hours 1739 1376 - 363
Leave % 26.8% 22.2% - 4.6%
Sick Leave Hours Used 577 539 - 38
Sick Leave % 8.9% 8.7% - 0.2%
Second Shift Patrol Hours 2011 2012
8609 7755 - 854
Total Leave Hours 1766 1208 - 558
Overtime % 20.5% 15.6% - 4.9% Third Shift
3
Sick Leave Hours Used 540 437 - 103
Sick Leave % 6.3% 5.6% - 0.7%
2011
7411
Total Leave Hours 1950
2012
8030 + 619
1277 - 673
Patrol Hours
26.3%
Sick Leave Hours Used 736
15.9% - 10.4%
398 - 338
Overtime %
Sick Leave % 9.9% 5.0% - 4.9%
3) FLEET USAGE MILEAGE The following was compiled from Monthly Mileage Reports from January, February, and March of 2011 versus same time period 2012. District Vehicle Assignments There are 51 vehicles assigned to District Two, including: •
39 marked vehicles o o o o o o o o o o
• • •
18 vehicles for patrol use 2 radar equipped vehicles for use by all reliefs 1 ALPR equipped vehicle for use by all reliefs 6 vehicles, including a CDOP van assigned to District sergeant 2 vehicles assigned to District lieutenants 4 vehicles assigned to Neighborhood Liaison Unit and Power Shift 1 scout car used by all reliefs 1 SUV assigned to administrative office 2 vehicles assigned to School Resource Officers 2 vehicles assigned to Canine Officers
8 vehicles assigned to Investigations Unit 3 “forfeiture” vehicles assigned to Violent Crimes Squad 1 vehicle assigned to the District Captain Total Mileage
2011 2012
58139 58594
77109 77066
56612 60540
TOTAL MILES 191860 196200
Difference
+ 455
- 43
+ 3928
+ 4340
January
February
March
4) OVERTIME / COMPENSATORY TIME EARNED /SHIFT DIFFERENTIAL
2011 Overtime Category (8 Hour) Increment Contingency
Total Earned Average Hours Per Hours Officer 34.53 74
.3 .78
4
Total Cost
Average Cost Per Officer (94)
$ 1515.46 $ 3625.55
$ 16.12 $ 38.56
Compensatory Court FLSA Off Time/ Dead Time
207.65 104 535.76 568
Court Comp Time
466.68
2012 Overtime Category (10 Hour Day)
Average Earned Hours Per Hours Officer
Increment Contingency Compensatory Court FLSA Off Time/ Dead Time Court Comp Time
2.2 1.1 5.6 6.0 4.9 Average Cost Per Officer Total Cost (82)
$ 4689.36 $ 24107.56 $17107.74
$ 49.88 $ 256.46 $181.99
-
-
+/- Difference in Total Hours
% +/- Difference in Total Costs -42.8 % 48.6 % 1.9 % 7.6 %
19.75 110 133.35 106 577
0.2 1.3 1.6 1.3 7.0
$ 959.20 $ 5279.44 -$ 4878.76 $ 26295.79
$ 11.69 $ 64.38 $ 59.49 $320.68
-14.78 hours 36 hours -74.3 hours 2 hours 41.24 hours
658
8.0
$ 20065.88
$ 244.70
90 hours
15.8
372
4.5
-94.68 hours
-20.2 %
SHIFT DIFFERENTIAL Year
Earned Hours
Average Hours Per Officer
Total Cost
Average Cost Per Officer
2011
23250
215
$21157
$196
2012
25482
234
$23189
$213
Difference =
2232
19
$2032
$17
Difference =
+0.9%
District 2 Commander’s Comments: There is no question the ten hour shifts have raised morale on the reliefs. Relief supervisors and patrol officers enjoy having a four day work week. However, from a management perspective, averaging seven fewer officers a day on the street has an impact on staffing levels. Officer safety and response time to calls for service could be adversely affected. I would recommend the Department analyze data on incidents where our officers are assaulted, incidents where officers use force, and response time to calls for service to see if there’s a correlation with the decreased staffing levels.
5
DISTRICT THREE 1) STAFFING
Starting Times 2011 (8 hour shifts)
First Relief: Second Relief: Late Power Third Relief:
2012 (10 hour shifts)
0600/0700 hours 1300/1500 hours 2000 hours 2300 hours
0600 hours 1100 hours 1900 hours 2100 hours
The following indicates District Three’s average number of patrol officers on duty and calls for service. Hourly Average of On-Duty Officers 2012 10 Hr 2011 CFS Differenc Staffing 12/25/10e Avg 3/17/11
Hour
2011 8 Hr Staffing Avg
2012 CFS 12/25/113/17/12
Difference
0
19.68
17.55
-2.13
531
542
11
1
19.68
17.55
-2.13
483
445
-38
2
19.68
17.55
-2.13
387
389
2
3
19.68
17.55
-2.13
267
314
47
4
12.30
17.55
5.25
215
185
-30
5
12.30
8.70
-3.60
153
155
2
6
18.54
13.99
-4.55
219
221
2
7
15.11
13.93
-1.18
450
443
-7
8
15.11
13.93
-1.18
537
462
-75
9
15.11
13.93
-1.18
641
550
-91
10
15.11
13.93
-1.18
634
601
-33
11
15.11
23.18
8.07
749
638
-111
12
15.11
23.18
8.07
740
720
-20
13
22.80
30.27
7.48
764
873
109
14
16.65
30.27
13.62
777
897
120
15
18.15
30.27
12.12
828
879
51
16
18.15
16.35
-1.81
935
950
15
17
18.15
16.35
-1.81
885
918
33
18
18.15
16.35
-1.81
824
828
4
19
18.15
25.23
7.07
757
747
-10
20
25.58
25.23
-0.36
757
811
54
21
17.89
24.69
6.80
685
754
69
22
17.89
24.69
6.80
643
692
49
23
19.82
24.69
4.87
621
629
8
Average
17.66
19.87
2.20
603.41
610.12
6.70
6
Following are the average number of hours worked during the study period for each relief. Calculations were made by dividing the total number of hours worked during each shift; then that number was divided by the number of days in the study period. The numbers in ( ) indicates police officers then supervisors assigned to each relief. 2011 - Eight Hour Shifts: First Shift: (27/6) Second Shift: (33/7) Third Shift: (35/6)
15.12 PO/PS 18.01 PO/PS 19.89 PO/PS
3.58 Supervisors 3.80 Supervisors 3.80 Supervisors
2012 – Ten Hour Shifts First Shift: (32/5) Second Shift: (36/6) Third Shift: (36/6)
13.35 PO/PS 16.35 PO/PS 17.62 PO/PS
2.39 Supervisors 3.17 Supervisors 2.51 Supervisors
The following table shows the average amount of patrol officers fielded on a daily basis. Shift First Second Third Total Daily
Daily Average of On-Duty Units Eight Hour Plan Ten Hour Plan 15.12 13.35 18.01 16.35 19.89 17.62 53.02 47.32
Difference - 1.77 - 1.67 - 2.27 - 5.7
2) PATROL HOURS / TOTAL LEAVE HOURS / SICK LEAVE USAGE Patrol Hours represent hours an officer is present for duty during the review period. All forms of sick leave are included FIRST SHIFT Patrol Hours 2011 2012
15700 13220 -2480
Total Leave Hours 2991 3141.5 +151
Leave % 16.0% 19.2% +3.2%
Sick Leave Hours 1153 1392 +239
Sick Leave % 6.84% 9.53% +2.69%
SECOND SHIFT Patrol Hours 2011 2012
18320 16390 -1930
Total Leave Hours 2661 2304 -357
Leave % 12.68% 12.32% -13.40%
7
Sick Leave Hours 871 729.75 -141
Sick Leave % 4.54% 4.26% -16.22%
THIRD SHIFT Total Leave Hours 3044 2985.75 -58
Patrol Hours 2011 2012
19900 16910 -2990
Leave % 13.27% 15.01% 1.91%
Sick Leave Hours 1184 1142.25 -42
Sick Leave % 5.62% 6.33% -3.53%
3) FLEET USAGE MILEAGE The following was compiled from Monthly Mileage Reports from January, February, and March of 2011 versus same time period 2012. Total Mileage
2011 2012
January 46001 53302
Difference
+7301
February 46267 71018 + 24751
March 74411 65103
TOTAL MILES 166679 189423
- 9308
+ 22744
The increase in mileage can be contributed to the increase in total numbers of patrol vehicles. In 2011, District Three had 38 vehicles in service for patrol, compared to the current 51 vehicles. District Vehicle Assignments District Three has 51 marked vehicles assigned to District Three. Listed below are the uniform vehicles currently accessible by relief personnel: Group A:
18 vehicles - Includes the Scout Car, a Radar car and two bike cars
Group B:
17 vehicles - Includes the ALPR car, a Radar car and two bike cars
Total =
35 vehicles
Capt / Lt / Sgts:
7
NLU/SRO/VCS:
9
Three of these marked vehicles are currently at the Municipal Garage and/or Body Shop. One vehicle containing a test computer is at Radcliff. Two vehicles are awaiting parts to repair the MVRs; these vehicles are used by police personnel working extension of police service details.
8
4) OVERTIME / COMPENSATORY TIME EARNED /SHIFT DIFFERENTIAL 2011 Overtime Category (Baseline) Increment Contingency Compensatory Court FLSA Off Time/ Dead Time Court Comp Time
2012 Overtime Category (10 Hour Day) Increment Contingency Compensatory Court FLSA Off Time/ Dead Time Court Comp Time
Earned Hours
Average Hours Per Officer (124)
Total Cost
Average Cost Per Officer (124)
0.5 0.5 1.82 1.82 14.2 12.1 6.9
$ 3070.31 $ 3257.23 $ 10257.00 $ 80488.86 $ 45877.31 -
$ 24.76 $ 26.26 $ 82.71 $ 649.10 $ 369.97 -
67.70 65.50 226.09 226 1768.09 1504 860
Total Cost
Average Cost Per Officer(120 )
+/- Difference in Total Hours - 11.9 hours 75 hours - 116.59 hours 2 hours 53.38 hours
Earned Hours
Average Hours Per Officer (120)
55.80 140.50 109.50 224 1821.47
0.4 1.1 0.9 1.8 15.1
2616.64 6985.67 10268.49 83593.68
$ 21.80 $ 58.21 $ 85.50 $ 696.14
1650 684.53
13.7 5.7
50687.17 -
$ 422.39 -
146 hours - 175.47 hours
% +/Difference in Total Costs - 14.77 % 114.46 % 0.11 % 3.85 % 10.48 % - 20.4 %
SHIFT DIFFERENTIAL: Year
Earned Hours
Average Hours Per Officer
Total Cost
Average Cost Per Officer
2011
30064.65
248.47
$27358.83
$226.10
2012
32432.80
268.04
$29513.85
$243.92
Difference=
+ 2368.15
+ 19.57
+ $2155.02
+ $17.82
Difference=
+ 7.9%
9
DISTRICT FOUR 1) STAFFING Starting Times: 2011 (8 hour shifts) First Relief: Second Relief Late Power: Third Relief:
2012 (10 hour shifts)
0600/0700 1400/1500 2100 2300
0600 1400 1900 2100
This table shows the District Four average hourly count of police officers on duty irregardless of their assigned shift. This information was gathered from daily lineups and daily activity logs. Hourly Average of On-Duty Officers
Hour
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Average
2011 8 Hr Staffing Averag e 18 18 18 18 18 10 10 19 18 18 18 18 18 18 28 19 21 21 21 21 21 28 18 18 19
2012 10 Hr Staffing Averag e 29 13 13 13 13 13 6 18 12 12 12 12 12 12 12 28 28 16 16 16 23 23 29 29 17
10
Differenc e
2011 CFS
2012 CFS
Difference
11 -5 -5 -5 -5 3 -4 -1 -6 -6 -6 -6 -6 -6 -16 9 7 -5 -5 -5 2 -5 11 11 -1
1690 1290 1448 1091 693 516 544 630 983 1215 1270 1671 1580 1733 1822 2286 2064 2110 2166 2269 2212 2124 2194 1969 37570
2002 1355 1489 1135 766 625 578 745 931 1149 1434 1887 1905 1976 2217 2577 2325 2128 2079 1988 2155 1847 2053 2164 39510
312 65 41 44 73 109 34 115 -52 -66 164 216 325 243 395 291 261 18 -87 -281 -57 -277 -141 195 1940
Following are the average number of hours worked during the study period for each relief. Calculations were made by dividing the total number of hours worked during each shift; that number was then divided by the number of days in the study period. The numbers in ( ) indicates police officers then supervisors assigned to each relief. 2011 - Eight Hour Shifts First Shift ( 30/10) Second Shift (37/6) Third Shift (29/6)
15.02 PO/PS 18.96 PO/PS 15.62 PO/PS
3.57 Supervisors 3.36 Supervisors 3.68 Supervisors
2012 – Ten Hour Shifts First Shift (31/6) Second Shift (37/7) Third Shift (32/7)
12.04 PO/PS 16.33 PO/PS 13.99 PO/PS
3.3 Supervisors 3.46 Supervisors 3.51 Supervisors
The following table shows the average amount of patrol officers fielded on a daily basis. Shift First Second Third Total Daily
Daily Average of On-Duty Units Eight Hour Plan Ten Hour Plan 18 12 21 16 18 13 56 42
Difference -6 -5 -5 -14
2) PATROL HOURS /TOTAL LEAVE HOURS / SICK LEAVE USAGE Patrol Hours represent hours each officer is present for duty during the review period. All forms of sick leave time are included. FIRST SHIFT Patrol Hours 2011 2012
15620 12970 -2650 -16.97%
Total Leave Hours 2485.5 2134.95 -350.55 -14.10%
Leave %
Sick Leave Hours
Sick Leave %
15.91% 16.46%
903 763 -140 -15.50%
5.78% 5.88 % 0.10%
.55 % SECOND SHIFT
Patrol Hours 2011 2012
18750 16630 -2120 -11.31%
Total Leave Hours 3186 2549.2 -636.8 -19.99%
Leave %
Sick Leave Hours
Sick Leave %
16.99% 15.32%
1037 601 -436 -42.04%
5.53% 3.61%
-1.67%
-1.92%
THIRD SHIFT Patrol Hours 2011 2012
16210 14700 -1510
Total Leave Hours 2308.25 1840.75 -467.5
Leave %
Sick Leave Hours
Sick Leave %
14.23% 12.52% -1.71%
877 641.5 -236
5.41% 4.36% -1.05%
11
-9.32%
-20.25%
-26.85%
3) FLEET USAGE MILEAGE The following was compiled from Monthly Mileage Reports from January, February, and March of 2011 versus same time period 2012. District Vehicle Assignments Currently District Four has 40 vehicles assigned to the fleet. Listed below are the uniform vehicles currently accessible by relief personnel. Reliefs: 31 vehicles (Used by all shifts) ALPR: 1 vehicle (Used by all shifts) Scout Car: 1 (Used by all shifts) Supervisors: 5 marked vehicles (Used by all shifts) 4 Sergeants/1 Lieutenant CDOP Van: 1 (Driven by Relief Sergeant) Administration 1 (Toyota Highlander Hybrid) Total Mileage January
February
March
2011 2012
49028 65165
59956 79152
Difference
16137
64499 67539 3040
19196
TOTAL MILES 173483 211856 + 38373 (22.12%)
Analysis/Findings District Four total mileage increased by 38,373 miles. This is a 22.12% increase from 2011 to 2012. District Four can offer no cause for the significant increase in mileage. 4) OVERTIME / COMPENSATORY TIME EARNED /SHIFT DIFFERENTIAL District Four had 118 sworn officers assigned during the 2011 rating period versus 120 sworn officers assigned during the 2012 review period. The totals have been divided by the number of officers listed above in order to achieve an average baseline earned hours and cost per sworn officer. 2011 Overtime Average Category Earned Hours Per (Baseline) Hours Officer (118) Increment 65.73 .55 Contingency 78.5 .66 Compensatory 87.6 .74 Court 122 1.03 FLSA 1045.27 8.85 Off Time/ Dead Time 964 8.16 Court Comp Time 648.69 5.49 Shift 27516.1 191.4
Total Cost $3124.10 $3616.94 $5578.86 $47066.18
Average Cost Per Officer (118) $26.47 $30.65 $47.27 $398.86
$29234.01
$247.74
$ 25039.65
$ 173.89
12
Differential
Total Cost
Average Cost Per 103 Officers
+/-Difference in Total Hours
% +/Difference in Total Costs
.39 1.14 .53 1.6 11.9
$ 1907.63 $ 5620.78 ----$7601.65 56180.64
$ 18.50 $ 545.70 ----$73.80 $ 545.44
- 35.4 hours 41.3 hours 272.4 hours 34 hours 341.12 hours
- 45.84% 53.98 % -52% 25 % 38.5 %
1094
10.6
$33530.91
$325.54
176 hours
19.1 %
Court Comp Time
365.25
3.5
-----
-----
-254.41 hours
-51%
Shift Differential
33715
290
$25286
$218
3452 hours
14%
2012 Overtime Category (Pilot)
Increment Contingency Compensatory Court FLSA Court Off Time/Dead Time
Earned Hours
Average Hours Per 103 Officers
41.0 117.80 54.60 166 1226.52
Analysis/Findings - District Four experienced an increase in all the above listed categories. DISTRICT FIVE 1) STAFFING Starting Times (2011) 8 hour shifts First Relief: Second Relief: Late Power: Third Shift:
(2012) 10 hour shifts
0600/0700 1400/1500 2100 2300
0600 1400 1900 2100
13
This table indicates District Five’s average number of patrol officers on duty and calls for service. Hourly Average of On-Duty Officers
Hour
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Average
2011 8 Hr Staffing Averag e 16 16 16 16 9 9 15 13.5 13.5 13.5 13.5 13.5 13.5 13.5 15 15.5 15.5 15.5 15.5 15.5 22.5 22.5 15 16 15
2012 10 Hr Staffing Averag e 14 14 14 14 14 14 18.5 11.5 11.5 11.5 11.5 11.5 11.5 11.5 24 24 13 13 13 20 20 27 27 27 16
Differenc e
2011 CFS
2012 CFS
Difference
-2 -2 -2 -2 +5 +5 +3.5 -2 -2 -2 -2 -2 -2 -2 +9 +8.5 -2.5 -2.5 -2.5 +4.5 -2.5 +4.5 +12 +11 +1
479 420 358 228 193 183 196 402 465 483 525 541 536 533 636 652 740 703 611 572 602 534 545 435 482
515 414 366 280 182 109 210 408 533 510 606 602 662 700 673 745 769 731 621 578 610 567 559 500 519
+36 -6 +8 +52 -11 -74 +14 +6 +68 +27 +81 +61 +126 +67 +37 +93 +29 +28 +10 +6 +8 +33 +14 +65 +37
Following are the average number of hours worked during the study period for each relief. Calculations were made by dividing the total number of hours worked during each shift; that number was then divided by the number of days in the study period. The numbers in ( ) indicates police officers then supervisors assigned to each relief. 2011 - Eight Hour Shifts: First Shift: (31/6) Second Shift: (34/6) Third Shift: (34/6)
13.60 PO/PS 15.67 PO/PS 16.08 PO/PS
3.34 Supervisors 3.54 Supervisors 3.39 Supervisors
2012 – Ten Hour Shifts First Shift: (30/5) Second Shift: (32/6) Third Shift: (36/6)
11.43 PO/PS 12.94 PO/PS 14.05 PO/PS
14
2.72 Supervisors 2.82 Supervisors 2.92 Supervisors
Daily Average of On-Duty Units Eight Hour Plan Ten Hour Plan 13.60 11.43 15.67 12.94 16.08 14.05 45.35 38.42
Shift First Second Third Total Daily
Difference -2.17 -2.73 -2.03 -6.93
2) PATROL HOURS/ TOTAL LEAVE HOURS / SICK LEAVE USAGE Patrol Hours represent hours each officer is present for duty during the review period. All forms of sick leave time are included. FIRST SHIFT Total Leave Patrol Hours Leave % Sick Leave Hours Sick Leave % Hours 2011 10120 2014 19.90 1054 10.41 2012 10630 1537 14.45 1120 10.53 +510 -477 -5.45 +66 +.12 SECOND SHIFT Patrol Hours 2011 2012
11664 12040 +376
Total Leave Hours 1933 1379 -554
Leave %
Sick Leave Hours
Sick Leave %
16.57 11.45 -5.12
879 902 +23
7.53 7.49 +.04
THIRD SHIFT Patrol Hours 2011 2012
11968 13070 +1102
Patrol Hours 2011 2012
33752 35740 +1988
Total Leave Hours 1832 1587 -245
Leave %
Sick Leave Hours
Sick Leave %
15.30 12.14 -2.86
1032 1026 -6
8.62 7.85 -.77
DISTRICT FIVE TOTALS Total Leave Leave % Sick Leave Hours Hours 5779 17.12 2965 4503 12.59 3048 -1276 -4.53 +83
Sick Leave % 8.78 8.52
3) FLEET USAGE MILEAGE The following was compiled from Monthly Mileage Reports from January, February, and March of 2011 versus same time period 2012. District Vehicle Assignments Currently District Five has 40 vehicles assigned to the fleet. First Relief: Second Relief: Third Relief:
7 marked police vehicles. 7 marked police vehicles. 7 marked police vehicles. 15
ALPR: Scout Car: Supervisors: CDOP Van: ADM/NLU/VCS SRO/K9
2 vehicles (Used by all shifts) 1 (Used by all shifts) 5 marked vehicles 1 (Driven by Relief Sgt) 9 1
Total Mileage January 2011 2012
55,157 56,833
Difference
1,676
February 61,670 66,060 -4,390
March
TOTAL MILES
74,479 69,801
191,306 192,694
4,678
1,388
4) OVERTIME / COMPENSATORY TIME EARNED/SHIFT DIFFERENTIAL
76.40 76.50 327 132 885.40
Average Hours Per 107 Officers .71 .71 3.0 1.2 8.2
$3522.65 $3685.87 ----$ 6013.04 $ 40065.61
Average Cost Per 107 Officers $32.92 $34.44 ----$ 56.19 $ 374.44
918
8.5
$ 27881.26
$ 260.57
619.66
5.8
-----
-----
30263
277
$22697
$208
2011 Overtime Category (Baseline)
Earned Hours
Increment Contingency Compensatory Court FLSA Court Off Time/Dead Time Court Comp Time Shift Differential
Total Cost
Average Cost Per 103 Officers
+/-Difference in Total Hours
% +/Difference in Total Costs
.39 1.14 .53 1.6 11.9
$ 1907.63 $ 5620.78 ----$7601.65 56180.64
$ 18.50 $ 545.70 ----$73.80 $ 545.44
- 35.4 hours 41.3 hours 272.4 hours 34 hours 341.12 hours
- 45.84% 53.98 % -52% 25 % 38.5 %
1094
10.6
$33530.91
$325.54
176 hours
19.1 %
Court Comp Time
365.25
3.5
-----
-----
-254.41 hours
-51%
Shift Differential
33715
290
$25286
$218
3452 hours
14%
2012 Overtime Category (Pilot)
Increment Contingency Compensatory Court FLSA Court Off Time/Dead Time
Earned Hours
Average Hours Per 103 Officers
41.0 117.80 54.60 166 1226.52
Total Cost
16
SUMMARY Ten Hour Shift Summary CATEGORY
DISTRICT 2
DISTRICT 3
DISTRICT 4
DISTRICT 5
- 7.3 per day
- 5.7 per day
- 14 per day
- 6.93 per day
- 305 - 854 +619
- 2480 - 1930 - 2990
- 16.97 - 11.31 - 9.32
+ 510 + 376 + 1102
+ 4.6 + 4.9 + 10.4
+ 12.23 - 2.84 - 3.53
+ 0.4 - 1.23 - 1.33
- 5.45 - 5.12 - 2.86
+ 0.2 + 0.7 + 4.9
+ 2.69 - 16.22 - 3.35
+ 0.9 - 1.75 - 0.10
+ 0.12 + 0.04 - 0.77
+ 4340
+22744
+38373
+1388
- 42.8 + 48.6 + 35.7 + 1.9 + 7.6 + 15.8 - 20.2
- 14.7 + 114.4 - 0.9 - 3.8 + 0.1 + 10.4 - 20.4
+ 59.2 + 236.8 + 47.3 + 15.5 + 44.2 + 27.9 + 39.9
- 45.8 + 53.98 - 52 + 38.5 + 25 + 19.1 + 51
+ 0.9
+ 7.9
+ 11
+ 14
STAFFING
PATROL HOURS First Relief Second Relief Third Relief ACCRUED LEAVE USAGE (%) First Relief Second Relief Third Relief SICK TIME USAGE (%) First Relief Second Relief Third Relief FLEET MILEAGE (miles)
TIME EARNED (%) Increment Contingency Compensatory FLSA Court Off time/ Dead time Court Comp Time SHIFT DIFFERENTIAL (%)
DC
17