Trending Report for City of Placerville January 2017

Trending Report for City of Placerville January 2017

Trending Report: City of Placerville 2011 -2016 Claim Type by Fiscal Year 9 8 7 6 5 4 3 2 1 0 First Aid Indemnity Medical Only Total 2011 -2012 0 7 5 12 2012 -2013 0 3 5 8 2013 -2014 2 3 7 12 2014 -2015 2 3 6 11 2015 -2016 2 3 8 13 14 12 10 8 6 4 2 0 Total Paid and Incurred by Fiscal Year $70 000 $60 000 $50 000 $40 000 $30 000 $20 000 $10 000 $0 Total Paid Incurred Total Claims 2011 -2012 $22 852 $49 011 12 2012 -2013 $14 033 $61 511 8 2013 -2014 $10 058 $38 428 12 2014 -2015 $13 309 $28 563 11 2015 -2016 $8 882 $46 838 13 14 12 10 8 6 4 2 0

Trending Report: City of Placerville 2011 -2016 Total Paid During Fiscal Year Regardless of Date of Injury $350 000 $300 000 $250 000 $200 000 $150 000 $100 000 $50 000 $0 Total Paid 2011 -2012 $295 443 2012 -2013 $291 543 2013 -2014 $251 671 2014 -2015 $164 621 2015 -2016 $260 322 Loss Days for Date of Injury within Fiscal Year 60 50 40 30 20 10 0 Loss Days 2011 -2012 54 2012 -2013 3 2013 -2014 6 2014 -2015 30 2015 -2016 0

Trending Report: City of Placerville 2011 -2016 Closing Ratio by Fiscal Year 30 250% 25 200% 20 150% 15 100% 10 50% 5 0 Open Closed Ratio 2011 -2012 12 16 133% 2012 -2013 8 10 125% 2013 -2014 12 13 108% 2014 -2015 11 13 118% 2015 -2016 13 25 192% 0% Litigation Ratio by Fiscal Year 14 12 10 8 6 4 2 0 Litigated Total Claims Ratio 2011 -2012 1 12 8, 3% 2012 -2013 0 8 0, 0% 2013 -2014 1 12 8, 3% 2014 -2015 0 11 0, 0% 2015 -2016 0 13 0, 0% 9, 0% 8, 0% 7, 0% 6, 0% 5, 0% 4, 0% 3, 0% 2, 0% 1, 0% 0, 0%

Trending Report: City of Placerville 2011 -2016 Top 6 Cause of Injury FY 2011 -2016 7 6 5 4 3 2 1 0 CUT, PUNCTURED, FELLOW WORKER, SCRAPED PATIENT, STUDENT Frequency 6 5 Severity $2 493 $1 301 CUMULATIVE TRAUMA 5 $68 429 REPETITIVE MOTION 5 $64 254 TWISTING 4 $166 214 PERSON IN ACT OF CRIME 4 $29 196 $180 000 $160 000 $140 000 $120 000 $100 000 $80 000 $60 000 $40 000 $20 000 $0 Top 7 Part of Body Injured FY 2011 -2016 12 10 8 6 4 2 0 Frequency Severity LOWER BACK KNEE FINGER(S) HAND 10 $86 204 6 $181 529 4 $4 395 4 $5 058 MULTIPLE BODY PARTS 3 $25 774 EYE(S) EAR(S) 3 $19 775 2 $34 817 $200 000 $180 000 $160 000 $140 000 $120 000 $100 000 $80 000 $60 000 $40 000 $20 000 $0

Trending Report: City of Placerville 2011 -2016 Top 7 Nature of Injury FY 2011 -2016 25 20 15 10 5 0 Frequency Severity STRAIN CONTUSION FOREIGN BODY PUNCTURE 21 $285 823 6 $17 334 4 $577 4 $1 345 CUMULATIVE MENTAL STRESS CONCUSSION TRAUMA 4 2 2 $60 915 $19 474 $20 008 $350 000 $300 000 $250 000 $200 000 $150 000 $100 000 $50 000 $0 Top 6 Occupation of Injury FY 2011 -2016 30 $250 000 25 $200 000 20 $150 000 15 $100 000 10 $50 000 5 0 Frequency Severity Police Officer 25 $221 427 Police Sgt 5 $9 043 Lifeguard 3 $1 370 Meter Repair Tech 2 $18 120 Police Captain 2 $85 270 Building Official 2 $34 961 $0

Trending Report: City of Placerville 2011 -2016 Top 10 Claims 2011 -2016 Claim Department NCWA-554066 POLICE DOI Injury Status Paid Incurred 1/30/2012 Twisted left knee during foot pursuit O $90, 450. 01 $165, 784. 41 10/28/2011 Low back pain after foot patrol NCWA-556000 COMMUNITY DEVELOPMENT 9/10/2013 Hearing loss from noise exposure C $60, 464. 33 O $6, 248. 41 $34, 816. 86 9/12/2012 Left wrist/arm injured after C being dragged by a vehicle trying to escape 1/13/2016 Stress O $24, 805. 42 $344. 60 $19, 430. 15 3/27/2014 Shoulder strain from refilling jug of water 9/17/2013 Cumulative trauma to low back 9/4/2011 Head injury from motor vehicle accident 1/15/2015 Hit head while using a crow bar 2/23/2016 Cumulative trauma to left wrist C $18, 163. 92 C $17, 384. 45 C $10, 310. 98 C $9, 696. 72 O $1, 814. 15 $7, 514. 14 NCWA-552366 POLICE NCWA-555580 POLICE NCWA-556899 ADMINISTRATIVE SERVICES NCWA-556238 POLICE NCWA-556033 PUBLIC WORKS NCWA-551213 POLICE NCWA-556533 PUBLIC WORKS NCWA-556942 POLICE

Trending Report: City of Placerville 2011 -2016 Departments FY 2011 -2016 Department Frequency Severity Average ADMINISTRATIVE SERVICES 4 $22, 923 $5, 731 COMMUNITY DEVELOPMENT 3 $38, 641 $12, 880 PARKS & RECREATION 8 $3, 172 $397 POLICE 33 $315, 115 $9, 549 PUBLIC WORKS 10 $34, 864 $3, 486 WASTEWATER TREATMENT 2 $742 $371 SEWER 2 $5, 109 $2, 554

Trending Report: City of Placerville 2011 -2016 NCCSIF Members FY 2011 -2016 NCCSIF Member Frequency Severity Average City of Anderson 56 $1, 085, 897 $19, 391 City of Auburn 67 $2, 645, 178 $39, 480 City of Colusa 20 $136, 736 $6, 837 City of Corning 40 $250, 955 $6, 274 City of Dixon 68 $2, 387, 658 $35, 113 City Of Elk Grove 155 $2, 747, 156 $17, 724 City of Folsom 375 $4, 986, 752 $13, 298 City of Galt 120 $1, 225, 770 $10, 215 City of Gridley 21 $166, 940 $7, 950 City of Ione 10 $5, 866 $587 City of Jackson 29 $1, 022, 620 $35, 263

Trending Report: City of Placerville 2011 -2016 NCCSIF Members FY 2011 -2016 NCCSIF Member Frequency Severity Average City of Lincoln 97 $1, 326, 241 $13, 673 City of Marysville 42 $1, 027, 370 $24, 461 City of Nevada City 33 $220, 278 $6, 675 City of Oroville 57 $729, 605 $12, 800 City of Placerville 62 $420, 566 $6, 783 City of Red Bluff 83 $1, 572, 224 $18, 942 City of Rio Vista 20 $171, 548 $8, 577 City of Rocklin 165 $1, 990, 341 $12, 063 City of Willows 20 $846, 223 $42, 311 City of Yuba City 225 $4, 604, 813 $20, 466 Town of Paradise 62 $1, 229, 525 $19, 831