Fiscal_Year_Summary_-_Sarasota_Co_BOCC_WC.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- 242646FB
- Issued by
- Sarasota County, Florida
About this file
The provided file is a Fiscal Year Summary spreadsheet for workers' compensation claims data for Sarasota County Board of County Commissioners (BOCC), spanning policy years from 1980 to 2025. The document details a comprehensive Workers Compensation Claims Administration Services Request for Proposals (RFP) seeking a contractor to administer workers compensation claims for Sarasota County, with an anticipated initial contract term of three years. The spreadsheet meticulously tracks medical reserves, expense reserves, indemnity reserves, paid-to-date (PTD) amounts, incremental changes, and recoveries across multiple fiscal years.
The fiscal summary reveals significant cumulative claims data, with grand totals showing 17,538 total claims, $80,139,246.71 in total paid-to-date medical expenses, $29,382,511.68 in indemnity reserves, and $12,773,378.92 in total recoveries. The claims data demonstrates considerable variability across years, with peak years like 1998, 2000, and 2015 showing substantially higher claim volumes and financial impacts. The most recent years (2020-2024) show a declining trend in claim numbers and total financial exposure, potentially indicating improved workplace safety measures or claims management strategies. The RFP suggests Sarasota County is seeking a professional claims administration service to manage these ongoing workers' compensation claims with efficiency and expertise.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Fiscal_Year_Summary - Sarasota
| Fiscal_Year_Summary - Sarasota Co BOCC_Fiscal_Summ |
| Run Date: 11/3/2024 3:03:01 PM |
| Sort By: Policy Year Ascending |
| Filter: Tier 2 = Sarasota County |
| Arguments: Date-Begin Date = '10/01/1979', Date-End Date = '10/31/2024' |
| Policy Year | Claims | Medical Rsv | Expense Rsv | Indemnity Rsv | Medical PTD | Expense PTD | Indemnity PTD | Medical Incr | Expense Incr | Indemnity Incr | Outstanding Rsv | Total PTD | Total Incr | Recoveries PTD |
| 1980 | 1 | $0.00 | $0.00 | $0.00 | $201,987.46 | $36,205.51 | $329,008.42 | $201,987.46 | $36,205.51 | $329,008.42 | $0.00 | $567,201.39 | $567,201.39 | $141,750.05 |
| 1981 | 1 | $0.00 | $0.00 | $0.00 | $13,519.70 | $2,151.75 | ($5,550.58) | $13,519.70 | $2,151.75 | ($5,550.58) | $0.00 | $10,120.87 | $10,120.87 | $0.00 |
| 1985 | 1 | $0.00 | $0.00 | $0.00 | $28,178.32 | $256.61 | $0.00 | $28,178.32 | $256.61 | $0.00 | $0.00 | $28,434.93 | $28,434.93 | $0.00 |
| 1986 | 6 | $0.00 | $0.00 | $0.00 | $1,023,472.98 | $33,843.17 | $441,763.97 | $1,023,472.98 | $33,843.17 | $441,763.97 | $0.00 | $1,499,080.12 | $1,499,080.12 | $302,415.57 |
| 1987 | 1 | $0.00 | $0.00 | $0.00 | ($17,031.26) | $3,866.32 | $57,802.77 | ($17,031.26) | $3,866.32 | $57,802.77 | $0.00 | $44,637.83 | $44,637.83 | $0.00 |
| 1988 | 5 | $0.00 | $0.00 | $0.00 | $819,399.12 | $12,282.48 | $997,786.41 | $819,399.12 | $12,282.48 | $997,786.41 | $0.00 | $1,829,468.01 | $1,829,468.01 | $829,261.85 |
| 1989 | 363 | $0.00 | $0.00 | $0.00 | $1,123,889.14 | $30,847.25 | $643,872.71 | $1,123,889.14 | $30,847.25 | $643,872.71 | $0.00 | $1,798,609.10 | $1,798,609.10 | $124,779.79 |
| 1990 | 326 | $0.00 | $0.00 | $0.00 | $364,274.18 | $13,592.33 | $123,646.31 | $364,274.18 | $13,592.33 | $123,646.31 | $0.00 | $501,512.82 | $501,512.82 | $0.00 |
| 1991 | 388 | $0.00 | $0.00 | $0.00 | $515,176.16 | $32,361.38 | $485,457.52 | $515,176.16 | $32,361.38 | $485,457.52 | $0.00 | $1,032,995.06 | $1,032,995.06 | $0.00 |
| 1992 | 59 | $51,847.64 | $125.00 | $0.00 | $903,778.80 | $16,195.12 | $167,715.08 | $955,626.44 | $16,320.12 | $167,715.08 | $51,972.64 | $1,087,689.00 | $1,139,661.64 | $116,506.94 |
| 1993 | 465 | $0.00 | $0.00 | $0.00 | $390,092.50 | $32,050.45 | $279,435.57 | $390,092.50 | $32,050.45 | $279,435.57 | $0.00 | $701,578.52 | $701,578.52 | $0.00 |
| 1994 | 502 | $0.00 | $0.00 | $0.00 | $690,005.59 | $41,726.66 | $357,807.87 | $690,005.59 | $41,726.66 | $357,807.87 | $0.00 | $1,089,540.12 | $1,089,540.12 | $0.00 |
| 1995 | 616 | $49,811.61 | $2,875.00 | $0.00 | $1,313,849.13 | $113,897.29 | $977,396.51 | $1,363,660.74 | $116,772.29 | $977,396.51 | $52,686.61 | $2,405,142.93 | $2,457,829.54 | $507,126.48 |
| 1996 | 613 | $34,889.16 | $11,722.92 | $3,369.46 | $949,252.43 | $52,834.65 | $601,739.01 | $984,141.59 | $64,557.57 | $605,108.47 | $49,981.54 | $1,603,826.09 | $1,653,807.63 | $0.00 |
| 1997 | 625 | $106,587.01 | $1,685.10 | $938.36 | $1,107,325.43 | $39,257.91 | $985,466.94 | $1,213,912.44 | $40,943.01 | $986,405.30 | $109,210.47 | $2,132,050.28 | $2,241,260.75 | $15,780.00 |
| 1998 | 696 | $590,133.32 | $7,442.02 | $10,049.20 | $3,903,149.36 | $192,558.55 | $2,248,504.40 | $4,493,282.68 | $200,000.57 | $2,258,553.60 | $607,624.54 | $6,344,212.31 | $6,951,836.85 | $1,931,836.41 |
| 1999 | 609 | $136,842.06 | $6,549.65 | $0.00 | $2,237,294.20 | $158,762.17 | $1,056,659.62 | $2,374,136.26 | $165,311.82 | $1,056,659.62 | $143,391.71 | $3,452,715.99 | $3,596,107.70 | $886,102.80 |
| 2000 | 656 | $247,092.41 | $5,493.17 | $163,161.99 | $3,397,805.33 | $153,747.25 | $2,859,091.27 | $3,644,897.74 | $159,240.42 | $3,022,253.26 | $415,747.57 | $6,410,643.85 | $6,826,391.42 | $2,204,686.46 |
| 2001 | 667 | $133,875.28 | $16,848.33 | $20,663.03 | $2,397,450.23 | $36,486.95 | $489,885.19 | $2,531,325.51 | $53,335.28 | $510,548.22 | $171,386.64 | $2,923,822.37 | $3,095,209.01 | $347,050.74 |
| 2002 | 702 | $181,280.88 | $13,388.88 | $10,556.97 | $3,244,948.17 | $123,493.20 | $1,302,946.31 | $3,426,229.05 | $136,882.08 | $1,313,503.28 | $205,226.73 | $4,671,387.68 | $4,876,614.41 | $575,268.47 |
| 2003 | 702 | $260,106.37 | $4,750.22 | $5,554.17 | $2,688,710.73 | $149,340.55 | $810,975.33 | $2,948,817.10 | $154,090.77 | $816,529.50 | $270,410.76 | $3,649,026.61 | $3,919,437.37 | $30,665.31 |
| 2004 | 728 | $523,499.00 | $15,051.53 | $31,081.22 | $2,576,025.83 | $40,100.75 | $532,770.25 | $3,099,524.83 | $55,152.28 | $563,851.47 | $569,631.75 | $3,148,896.83 | $3,718,528.58 | $100,422.45 |
| 2005 | 612 | $615,051.64 | $28,072.71 | $317,255.91 | $3,318,064.20 | $129,721.97 | $1,740,565.62 | $3,933,115.84 | $157,794.68 | $2,057,821.53 | $960,380.26 | $5,188,351.79 | $6,148,732.05 | $12,971.83 |
| 2006 | 593 | $140,495.99 | $9,589.03 | $18,279.61 | $2,933,552.62 | $27,274.15 | $433,765.11 | $3,074,048.61 | $36,863.18 | $452,044.72 | $168,364.63 | $3,394,591.88 | $3,562,956.51 | $57,089.80 |
| 2007 | 568 | $25,156.48 | $5,946.82 | $903.75 | $1,553,915.47 | $43,768.87 | $372,098.73 | $1,579,071.95 | $49,715.69 | $373,002.48 | $32,007.05 | $1,969,783.07 | $2,001,790.12 | $51,310.23 |
| 2008 | 553 | $624,694.28 | $18,133.98 | $72,223.48 | $2,722,693.17 | $95,316.57 | $1,092,989.22 | $3,347,387.45 | $113,450.55 | $1,165,212.70 | $715,051.74 | $3,910,998.96 | $4,626,050.70 | $845,141.97 |
| 2009 | 430 | $280,203.32 | $1,846.06 | $561.20 | $1,180,044.26 | $27,725.09 | $268,155.31 | $1,460,247.58 | $29,571.15 | $268,716.51 | $282,610.58 | $1,475,924.66 | $1,758,535.24 | $27,730.21 |
| 2010 | 453 | $153,336.23 | $3,000.00 | $912.50 | $1,668,500.40 | $16,968.06 | $317,368.71 | $1,821,836.63 | $19,968.06 | $318,281.21 | $157,248.73 | $2,002,837.17 | $2,160,085.90 | $3,240.40 |
| 2011 | 426 | $434,051.37 | $19,030.86 | $64,792.27 | $2,691,745.65 | $33,083.21 | $997,913.20 | $3,125,797.02 | $52,114.07 | $1,062,705.47 | $517,874.50 | $3,722,742.06 | $4,240,616.56 | $606,844.62 |
| 2012 | 450 | $1,096,244.94 | $14,230.27 | $52,244.66 | $3,083,693.77 | $61,736.77 | $731,239.69 | $4,179,938.71 | $75,967.04 | $783,484.35 | $1,162,719.87 | $3,876,670.23 | $5,039,390.10 | $13,960.40 |
| 2013 | 509 | $181,425.89 | $5,000.00 | $544.80 | $1,753,991.10 | $46,404.21 | $625,360.44 | $1,935,416.99 | $51,404.21 | $625,905.24 | $186,970.69 | $2,425,755.75 | $2,612,726.44 | $163,461.42 |
| 2014 | 493 | $263,028.99 | $9,090.23 | $83,292.10 | $2,393,600.60 | $63,663.86 | $746,487.72 | $2,656,629.59 | $72,754.09 | $829,779.82 | $355,411.32 | $3,203,752.18 | $3,559,163.50 | $8,338.45 |
| 2015 | 517 | $893,247.27 | $84,788.96 | $563,886.36 | $3,334,888.18 | $144,886.21 | $1,485,147.82 | $4,228,135.45 | $229,675.17 | $2,049,034.18 | $1,541,922.59 | $4,964,922.21 | $6,506,844.80 | $5,840.88 |
| 2016 | 444 | $515,966.64 | $9,495.35 | $48,978.40 | $4,959,442.10 | $14,261.89 | $335,501.53 | $5,475,408.74 | $23,757.24 | $384,479.93 | $574,440.39 | $5,309,205.52 | $5,883,645.91 | $2,768,380.71 |
| 2017 | 466 | $475,817.78 | $58,161.78 | $45,454.46 | $3,401,131.85 | $48,186.50 | $712,080.14 | $3,876,949.63 | $106,348.28 | $757,534.60 | $579,434.02 | $4,161,398.49 | $4,740,832.51 | $38,680.80 |
| 2018 | 476 | $476,474.30 | $24,758.37 | $58,170.65 | $2,329,189.31 | $42,442.78 | $521,983.19 | $2,805,663.61 | $67,201.15 | $580,153.84 | $559,403.32 | $2,893,615.28 | $3,453,018.60 | $15,948.75 |
| 2019 | 321 | $145,800.07 | $7,285.88 | $26,091.60 | $1,063,764.19 | $36,167.06 | $387,826.51 | $1,209,564.26 | $43,452.94 | $413,918.11 | $179,177.55 | $1,487,757.76 | $1,666,935.31 | $5,125.49 |
| 2020 | 276 | $11,952.31 | $1,836.25 | $659.50 | $451,463.67 | $6,224.85 | $245,676.19 | $463,415.98 | $8,061.10 | $246,335.69 | $14,448.06 | $703,364.71 | $717,812.77 | $10,659.64 |
| 2021 | 282 | $46,520.10 | $10,364.37 | $11,111.25 | $746,830.16 | $68,640.50 | $424,863.88 | $793,350.26 | $79,004.87 | $435,975.13 | $67,995.72 | $1,240,334.54 | $1,308,330.26 | $0.00 |
| 2022 | 271 | $104,552.02 | $28,636.59 | $14,250.18 | $657,830.86 | $40,942.34 | $251,188.79 | $762,382.88 | $69,578.93 | $265,438.97 | $147,438.79 | $949,961.99 | $1,097,400.78 | $25,000.00 |
| 2023 | 266 | $111,790.86 | $26,633.11 | $8,694.30 | $400,278.69 | $38,680.42 | $59,752.68 | $512,069.55 | $65,313.53 | $68,446.98 | $147,118.27 | $498,711.79 | $645,830.06 | $0.00 |
| 2024 | 372 | $280,856.22 | $70,545.12 | $47,311.19 | $412,963.08 | $69,019.24 | $206,373.75 | $693,819.30 | $139,564.36 | $253,684.94 | $398,712.53 | $688,356.07 | $1,087,068.60 | $0.00 |
| 2025 | 28 | $15,750.00 | $3,182.50 | $612.66 | $728.41 | $52.50 | $387.34 | $16,478.41 | $3,235.00 | $1,000.00 | $19,545.16 | $1,168.25 | $20,713.41 | $0.00 |
Grand Totals 17,538 $9,208,381.44 $525,560.06 $1,681,605.23 $70,930,865.27 $2,371,025.35 $27,700,906.45 $80,139,246.71 $2,896,585.41 $29,382,511.68 $11,415,546.73 $101,002,797.07 $112,418,343.80 $12,773,378.92 image1.emf
File details come from the government source that posted it. Updated .