| % of Actual Change in Workers Compensation Claim Cost (Monthly)HR-Human Resources |
Measure Definition & Importance |
Accurately reflecting the actual claim cost reported for the Third Party Administrator (TPA). This data is imported from the TPA's claims system and allows Risk Management to track trending claim costs and to compare the costs with previous time periods. Comparing claim cost present an opportunity for Risk Management to implement cost saving measures.
Analysis | |
There was a 1.92% decrease in medical claim costs, 23% increase in expense claim cost due to adjustment to system changes and a 36.82% increase in indemnity claims cost due to increase lump sum IIB payments.
% of Actual Change in Workers Compensation Claim Cost (Monthly) |
Service Areas |
-
HR.6.1 Workers' Compensation
HR-Human Resources
Attachments |
Measure Data | Last Calculated 7 days ago |
| Period |  | Status | Actual | Overall Target | High Variance (FY Target) | Low Variance | Medical Claims Cost | Expense Claims Cost | Indemnity Claims Cost | Total |
|---|---|---|---|---|---|---|---|---|---|---|
| Oct-18 | | Insufficient Progress | 33.00% | 30.00 | 0.00 | $ 572,698.00 | $ 77,606.00 | $ 164,997.00 | $ 815,301.00 | |
| Nov-18 | | On Target | -8.95% | 30.00 | 0.00 | $ 431,769.00 | $ 67,467.00 | $ 243,060.00 | $ 742,296.00 | |
| Dec-18 | | On Target | -1.61% | 30.00 | 0.00 | $ 532,797.00 | $ 53,165.00 | $ 144,407.00 | $ 730,369.00 | |
| Jan-19 | | On Target | -3.57% | 30.00 | 0.00 | $ 420,202.00 | $ 112,285.00 | $ 171,786.00 | $ 704,273.00 | |
| Feb-19 | | On Target | -3.86% | 30.00 | 0.00 | $ 433,103.00 | $ 71,568.00 | $ 172,406.00 | $ 677,077.00 | |
| Mar-19 | | On Target | 8.75% | 30.00 | 0.00 | $ 463,342.00 | $ 121,600.00 | $ 151,368.00 | $ 736,310.00 | |
| Apr-19 | | On Target | 2.22% | 30.00 | 0.00 | $ 519,093.00 | $ 102,921.00 | $ 130,655.00 | $ 752,669.00 | |
| May-19 | | On Target | -8.52% | 30.00 | 0.00 | $ 451,029.00 | $ 81,664.00 | $ 155,830.00 | $ 688,523.00 | |
| Jun-19 | | On Target | -25.58% | 30.00 | 0.00 | $ 318,763.00 | $ 46,546.00 | $ 147,066.00 | $ 512,375.00 | |
| Jul-19 | | Insufficient Progress | 76.80% | 30.00 | 0.00 | $ 624,617.00 | $ 106,751.00 | $ 174,523.00 | $ 905,891.00 | |
| Aug-19 | | On Target | -13.44% | 30.00 | 0.00 | $ 559,370.00 | $ 80,668.00 | $ 144,111.00 | $ 784,149.00 | |
| Sep-19 | | On Target | -22.48% | 30.00 | 0.00 | $ 412,363.00 | $ 74,133.00 | $ 121,405.00 | $ 607,901.00 | |
| Oct-19 | | On Target | 9.46% | 30.00 | 0.00 | $ 411,363.00 | $ 88,507.00 | $ 165,565.00 | $ 665,435.00 | |
| Nov-19 | | On Target | -49.35% | 30.00 | 0.00 | $ 171,082.00 | $ 37,074.00 | $ 128,909.00 | $ 337,065.00 | |
| Dec-19 | | Insufficient Progress | 183.25% | 30.00 | 0.00 | $ 683,521.00 | $ 135,922.00 | $ 135,278.00 | $ 954,721.00 | |
| Jan-20 | | On Target | 20.22% | 30.00 | 0.00 | $ 910,699.00 | $ 80,894.00 | $ 156,169.00 | $ 1,147,762.00 | |
| Feb-20 | | On Target | -32.90% | 30.00 | 0.00 | $ 476,349.00 | $ 65,560.00 | $ 228,189.00 | $ 770,098.00 | |
| Mar-20 | | On Target | -3.21% | 30.00 | 0.00 | $ 453,604.00 | $ 62,365.00 | $ 229,432.00 | $ 745,401.00 | |
| Apr-20 | | Insufficient Progress | 32.26% | 30.00 | 0.00 | $ 600,902.00 | $ 65,268.00 | $ 319,677.00 | $ 985,847.00 | |
| May-20 | | On Target | -24.84% | 30.00 | 0.00 | $ 484,432.00 | $ 105,823.00 | $ 150,667.00 | $ 740,922.00 | |
| Jun-20 | | On Target | 7.63% | 30.00 | 0.00 | $ 585,601.00 | $ 72,292.00 | $ 139,582.00 | $ 797,475.00 | |
| Jul-20 | | On Target | -15.15% | 30.00 | 0.00 | $ 442,707.00 | $ 61,452.00 | $ 172,520.00 | $ 676,679.00 | |
| Aug-20 | | On Target | 12.74% | 30.00 | 0.00 | $ 512,521.00 | $ 67,576.00 | $ 182,799.00 | $ 762,896.00 | |
| Sep-20 | | On Target | -10.62% | 30.00 | 0.00 | $ 403,733.00 | $ 121,723.00 | $ 156,404.00 | $ 681,860.00 | |
| Oct-20 | | On Target | -22.56% | 30.00 | 0.00 | $ 336,981.00 | $ 26,793.00 | $ 164,244.00 | $ 528,018.00 | |
| Nov-20 | | Insufficient Progress | 59.22% | 30.00 | 0.00 | $ 594,602.00 | $ 153,953.00 | $ 92,141.00 | $ 840,696.00 | |
| Dec-20 | | Insufficient Progress | 49.27% | 30.00 | 0.00 | $ 944,825.00 | $ 104,058.00 | $ 206,020.00 | $ 1,254,903.00 | |
| Jan-21 | | On Target | -35.17% | 30.00 | 0.00 | $ 602,749.00 | $ 58,534.00 | $ 152,267.00 | $ 813,550.00 | |
| Feb-21 | | On Target | 6.49% | 30.00 | 0.00 | $ 644,746.00 | $ 58,141.00 | $ 163,435.00 | $ 866,322.00 | |
| Mar-21 | | On Target | 7.19% | 30.00 | 0.00 | $ 662,393.00 | $ 96,033.00 | $ 170,156.00 | $ 928,582.00 | |
| Apr-21 | | On Target | -20.14% | 30.00 | 0.00 | $ 505,203.00 | $ 49,866.00 | $ 186,462.00 | $ 741,531.00 | |
| May-21 | | On Target | 24.49% | 30.00 | 0.00 | $ 638,674.00 | $ 73,298.00 | $ 211,148.00 | $ 923,120.00 | |
| Jun-21 | | On Target | 0.98% | 30.00 | 0.00 | $ 544,581.00 | $ 68,254.00 | $ 319,343.00 | $ 932,178.00 | |
| Jul-21 | | On Target | -50.03% | 30.00 | 0.00 | $ 361,760.00 | $ 68,254.00 | $ 35,821.00 | $ 465,835.00 | |
| Aug-21 | | Insufficient Progress | 88.66% | 30.00 | 0.00 | $ 695,496.00 | $ 44,486.00 | $ 138,862.00 | $ 878,844.00 | |
| Sep-21 | | On Target | 5.48% | 30.00 | 0.00 | $ 682,135.00 | $ 54,887.00 | $ 189,985.00 | $ 927,007.00 | |
| Oct-21 | | On Target | -22.14% | 30.00 | 0.00 | $ 510,820.00 | $ 51,226.00 | $ 159,752.00 | $ 721,798.00 | |
| Nov-21 |  | Monitoring/No Info | ||||||||
| Dec-21 | | Monitoring/No Info | ||||||||
| Jan-22 | | Monitoring/No Info | ||||||||
| Feb-22 | | Monitoring/No Info | ||||||||
| Mar-22 | | Monitoring/No Info | ||||||||
| Apr-22 | | Monitoring/No Info | ||||||||
| May-22 | | Monitoring/No Info | ||||||||
| Jun-22 | | Monitoring/No Info | ||||||||
| Jul-22 | | Monitoring/No Info | ||||||||
| Aug-22 | | Monitoring/No Info | ||||||||
| Sep-22 | | Monitoring/No Info |
Data Source Details & Calculation Information |
Run a generalized a payment export from YCEa (TPA's Claim System) for the desired date range.
The claims system will produce an excel spreadsheet.
Open the spreadsheet; Sort for date range.
Sum the claim cost for each of the cost columns for each comparative date range.
Performance Liaison |
| CA | Courtney August (HR- Human Resources) |
Measure Type |
Data Owner |
Measure ID |
927966
Performance Liaison Notes |
Administrator Notes |