Exhibit_C___Incurred__Paid_Updated_w_BL_Breakout.xlsx
XLSX spreadsheet 2 MB Posted
- Solicitation number
- RFP-1-26-12
- Issued by
- Brevard County, Florida
About this file
This is an expenditure tracking document (Exhibit C) related to a Florida county's Group Life & Disability and Supplemental Health Benefits contract solicitation. The document appears to be a detailed spreadsheet tracking incurred and paid costs with budget line item breakouts for the county's employee benefits programs. The solicitation seeks a single carrier/administrator to consolidate group-sponsored Accident, Hospital Indemnity, and Critical Illness/Cancer coverage effective January 1, 2027, expanding beyond the current fully insured Group Term Life, Accidental Death & Dismemberment, Short-Term Disability, and Long-Term Disability coverage provided through Standard Insurance Company since January 1, 2019. The county intends to unify voluntary benefit offerings that are currently fragmented across multiple individual representatives including Aflac, Allstate, and Colonial Life under one group-administered program with payroll deduction eligibility.
The expenditure document provides financial data necessary for evaluating the cost structure and budget requirements associated with the current benefits offerings and projected costs for the consolidated program. Employees currently enrolled in individual Colonial, Aflac, and Allstate plans may maintain direct-bill coverage but will lose access to on-site enrollment and payroll deduction options beginning January 1, 2027. The spreadsheet format with budget line item breakouts suggests the county is conducting detailed financial analysis to support the RFP evaluation process and cost comparison among competing carriers/administrators for the expanded voluntary benefits program.
View the file
Other files
Show all 30
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
BL
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 4/1/2008 |
| Basic Life |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 3,789 | 3,912 | 3,958 | 3,984 | 4,055 | 19,698 |
| Earned Premium | 242,272 | 251,998 | 283,544 | 311,977 | 168,045 | 1,257,836 |
| Paid Claims | 478,500 | 542,440 | 198,300 | 432,400 | 225,360 | 1,877,000 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | -155,328 | 32,588 | -96,636 | -46,562 | 26,718 | -239,220 |
| Change in IBNR Reserves | 10,713 | -7,859 | 5,810 | 5,845 | 2,837 | 17,346 |
| Incurred Claims | 333,885 | 567,169 | 107,474 | 391,683 | 254,915 | 1,655,126 |
| Loss Ratio | 138% | 225% | 38% | 126% | 152% | 132% |
* Data pulled from end of period
BL Act
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 4/1/2008 |
| Basic Life |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 3,740 | 3,866 | 3,910 | 3,936 | 4,008 | 19,460 |
| Earned Premium | 219,696 | 229,098 | 259,601 | 286,381 | 155,678 | 1,150,454 |
| Paid Claims | 453,500 | 532,440 | 193,300 | 407,400 | 225,360 | 1,812,000 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | -155,328 | 32,588 | -96,636 | -46,562 | 26,718 | -239,220 |
| Change in IBNR Reserves | 9,715 | -7,145 | 5,319 | 5,365 | 2,628 | 15,883 |
| Incurred Claims | 307,887 | 557,883 | 101,983 | 366,203 | 254,706 | 1,588,663 |
| Loss Ratio | 140% | 244% | 39% | 128% | 164% | 138% |
* Data pulled from end of period
BL Ret
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 4/1/2008 |
| Basic Life |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 49 | 46 | 48 | 48 | 47 | 238 |
| Earned Premium | 22,576 | 22,900 | 23,943 | 25,596 | 12,367 | 107,382 |
| Paid Claims | 25,000 | 10,000 | 5,000 | 25,000 | 0 | 65,000 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in IBNR Reserves | 998 | -714 | 491 | 480 | 209 | 1,463 |
| Incurred Claims | 25,998 | 9,286 | 5,491 | 25,480 | 209 | 66,463 |
| Loss Ratio | 115% | 41% | 23% | 100% | 2% | 62% |
* Data pulled from end of period
BA
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 1/1/2018 |
| Basic AD&D |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 3,746 | 3,866 | 3,910 | 3,938 | 4,011 | 19,471 |
| Earned Premium | 37,840 | 38,706 | 43,512 | 47,379 | 24,229 | 191,666 |
| Paid Claims | 0 | 46,000 | 0 | 0 | 0 | 46,000 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in IBNR Reserves | 641 | -488 | 299 | 293 | 188 | 933 |
| Incurred Claims | 641 | 45,512 | 299 | 293 | 188 | 46,933 |
| Loss Ratio | 2% | 118% | 1% | 1% | 1% | 24% |
* Data pulled from end of period
AL
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 1/1/2018 |
| Additional Life |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 1,782 | 1,830 | 1,863 | 1,849 | 1,904 | 9,228 |
| Earned Premium | 595,966 | 601,876 | 612,561 | 586,822 | 313,899 | 2,711,124 |
| Paid Claims | 385,000 | 328,400 | 410,000 | 384,800 | 257,600 | 1,765,800 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | -245,440 | 68,300 | -140,860 | -221,520 | 24,380 | -515,140 |
| Change in IBNR Reserves | -1,319 | 5,051 | -4,529 | -1,144 | 8,224 | 6,283 |
| Incurred Claims | 138,241 | 401,751 | 264,611 | 162,136 | 290,204 | 1,256,943 |
| Loss Ratio | 23% | 67% | 43% | 28% | 92% | 46% |
* Data pulled from end of period
AA
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 1/1/2018 |
| Additional AD&D |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 1,782 | 1,836 | 1,863 | 1,849 | 1,904 | 9,234 |
| Earned Premium | 40,402 | 35,712 | 36,348 | 41,116 | 20,898 | 174,476 |
| Paid Claims | 0 | 0 | 0 | 0 | 0 | 0 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in IBNR Reserves | -57 | -1,650 | 1,575 | 39 | 116 | 23 |
| Incurred Claims | -57 | -1,650 | 1,575 | 39 | 116 | 23 |
| Loss Ratio | -0% | -5% | 4% | 0% | 1% | 0% |
* Data pulled from end of period
DL
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 1/1/2018 |
| Dependents Life |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 1,111 | 1,090 | 1,032 | 1,007 | 1,007 | 5,247 |
| Earned Premium | 78,678 | 75,977 | 75,093 | 71,559 | 37,347 | 338,654 |
| Paid Claims | 120,000 | 60,000 | 201,800 | 93,200 | 25,000 | 500,000 |
| Conversions | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in IBNR Reserves | -123 | -243 | -40 | -131 | 225 | -312 |
| Incurred Claims | 119,877 | 59,757 | 201,760 | 93,069 | 25,225 | 499,688 |
| Loss Ratio | 152% | 79% | 269% | 130% | 68% | 148% |
* Data pulled from end of period
ST
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 1/1/2018 |
| Short Term Disability |
| Experience: Paid Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 1,307 | 1,340 | 1,396 | 1,456 | 1,493 | 6,992 |
| Earned Premium | 338,847 | 345,003 | 372,295 | 385,470 | 227,965 | 1,669,580 |
| Paid Claims | 211,575 | 219,948 | 220,687 | 196,641 | 81,489 | 930,340 |
| FICA | 596 | 0 | 0 | 0 | 0 | 596 |
| Change in Reported Reserves | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in IBNR Reserves | 3,718 | 4,749 | 4,143 | 5,682 | 11,243 | 29,535 |
| Incurred Claims | 215,889 | 224,697 | 224,830 | 202,323 | 92,732 | 960,471 |
| Loss Ratio | 64% | 65% | 60% | 52% | 41% | 58% |
* Data pulled from end of period
LT
Brevard County Board Of County Commissioners
| Contract number - 641728 |
| Coverage Effective Date: 1/1/2018 |
| Long Term Disability |
| Experience: Incurred Basis |
| From | 1/1/22 | 1/1/23 | 1/1/24 | 1/1/25 | 1/1/26 | Totals |
| Through | 12/31/22 | 12/31/23 | 12/31/24 | 12/31/25 | 6/30/26 |
| Lives * | 1,498 | 1,505 | 1,532 | 1,519 | 1,545 | 7,599 |
| Earned Premium | 453,025 | 465,939 | 487,935 | 480,347 | 272,544 | 2,159,790 |
| Paid Claims | 68,146 | 193,555 | 19,752 | 54,049 | 0 | 335,502 |
| FICA | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in Reported Reserves | 0 | 110,582 | 0 | 281,504 | 0 | 392,086 |
| Change in IBNR Reserves | 0 | 0 | 0 | 0 | 310,602 | 310,602 |
| Incurred Claims | 68,146 | 304,137 | 19,752 | 335,553 | 310,602 | 1,038,190 |
| Loss Ratio | 15% | 65% | 4% | 70% | 114% | 48% |
* Data pulled from end of period
File details come from the government source that posted it. Updated .