Trending Report for City of Placerville January 2017
This trending report provides insights on claim types, total paid and incurred amounts, total claims, loss days, closing ratio, litigation ratio, top causes of injury, and top parts of the body injured for the City of Placerville from 2011 to 2016.
Download Presentation

Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Trending Report for City of Placerville January 2017
Trending Report: City of Placerville 2011-2016 Claim Type by Fiscal Year 9 14 8 12 7 10 6 8 5 4 6 3 4 2 2 1 0 0 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016 First Aid 0 0 2 2 2 Indemnity 7 3 3 3 3 Medical Only 5 5 7 6 8 Total 12 8 12 11 13 Total Paid and Incurred by Fiscal Year $70,000 14 $60,000 12 $50,000 10 $40,000 8 $30,000 6 $20,000 4 $10,000 2 $0 0 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016 Total Paid $22,852 $14,033 $10,058 $13,309 $8,882 Incurred $49,011 $61,511 $38,428 $28,563 $46,838 Total Claims 12 8 12 11 13
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 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016 Total Paid $295,443 $291,543 $251,671 $164,621 $260,322 Loss Days for Date of Injury within Fiscal Year 60 50 40 30 20 10 0 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016 Loss Days 54 3 6 30 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 0% 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016 Open 12 8 12 11 13 Closed 16 10 13 13 25 Ratio 133% 125% 108% 118% 192% Litigation Ratio by Fiscal Year 14 10.0% 12 8.0% 10 6.0% 8 6 4.0% 4 2.0% 2 0 0.0% 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016 Litigated 1 0 1 0 0 Total Claims 12 8 12 11 13 Ratio 8.3% 0.0% 8.3% 0.0% 0.0%
Trending Report: City of Placerville 2011-2016 Top 6 Cause of Injury FY 2011-2016 7 $180,000 $160,000 6 $140,000 5 $120,000 4 $100,000 $80,000 3 $60,000 2 $40,000 1 $20,000 0 $0 CUT, FELLOW WORKER, PATIENT, STUDENT CUMULATIVE TRAUMA REPETITIVE MOTION PERSON IN ACT OF CRIME PUNCTURED, SCRAPED TWISTING Frequency 6 5 5 5 4 4 Severity $2,493 $1,301 $68,429 $64,254 $166,214 $29,196 Top 7 Part of Body Injured FY 2011-2016 12 $200,000 $180,000 10 $160,000 $140,000 8 $120,000 6 $100,000 $80,000 4 $60,000 $40,000 2 $20,000 0 $0 MULTIPLE BODY PARTS LOWER BACK KNEE FINGER(S) HAND EYE(S) EAR(S) Frequency 10 6 4 4 3 3 2 Severity $86,204 $181,529 $4,395 $5,058 $25,774 $19,775 $34,817
Trending Report: City of Placerville 2011-2016 Top 7 Nature of Injury FY 2011-2016 25 $350,000 $300,000 20 $250,000 15 $200,000 $150,000 10 $100,000 5 $50,000 0 $0 CUMULATIVE TRAUMA MENTAL STRESS STRAIN CONTUSION FOREIGN BODY PUNCTURE CONCUSSION Frequency 21 6 4 4 4 2 2 Severity $285,823 $17,334 $577 $1,345 $60,915 $19,474 $20,008 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 $0 Meter Repair Tech Police Officer Police Sgt Lifeguard Police Captain Building Official Frequency 25 5 3 2 2 2 Severity $221,427 $9,043 $1,370 $18,120 $85,270 $34,961
Trending Report: City of Placerville 2011-2016 Top 10 Claims 2011-2016 Claim Department DOI Injury Status Paid Incurred NCWA-554066 POLICE 1/30/2012Twisted left knee during foot pursuit O $90,450.01 $165,784.41 NCWA-552366 POLICE 10/28/2011Low back pain after foot patrol 9/10/2013Hearing loss from noise exposure C $60,464.33 $60,464.33 NCWA-556000 COMMUNITY DEVELOPMENT O $6,248.41 $34,816.86 NCWA-555580 POLICE 9/12/2012Left wrist/arm injured after being dragged by a vehicle trying to escape 1/13/2016Stress C $24,805.42 $24,805.42 NCWA-556899 ADMINISTRATIVE SERVICES O $344.60 $19,430.15 NCWA-556238 POLICE 3/27/2014Shoulder strain from refilling jug of water 9/17/2013Cumulative trauma to low back 9/4/2011Head injury from motor vehicle accident 1/15/2015Hit head while using a crow bar 2/23/2016Cumulative trauma to left wrist C $18,163.92 $18,163.92 NCWA-556033 PUBLIC WORKS C $17,384.45 $17,384.45 NCWA-551213 POLICE C $10,310.98 $10,310.98 NCWA-556533 PUBLIC WORKS C $9,696.72 $9,696.72 NCWA-556942 POLICE O $1,814.15 $7,514.14
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