Exhibit_C___Incurred__Paid_Updated_w_BL_Breakout.xlsx

XLSX spreadsheet 2 MB Posted

Attached to
Group Life & Disability and Supplemental Health Benefits
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

File Type Posted
RFQ_Selection_Committee_Consolidated_Evaluation_Scoresheet.pdf PDF
Public_Meeting_Notice.pdf PDF
RFP_Tabulation__Names_Only.pdf PDF
Addendum_2.pdf PDF
Exhibit_C__Offset_Report.xlsx XLSX spreadsheet
Exhibit_A__Census.xlsx XLSX spreadsheet
Exhibit_C__Offset_Key.pdf PDF
Addendum_1.pdf PDF
Exhibit_C_Claimrun_Updated.xlsx XLSX spreadsheet
Exhibit_C__Incurred__Paid_Updated.pdf PDF
Exhibit_C__Brevard_Life__DI_SelfBill_2.1.26.xlsx XLSX spreadsheet
Exhibit_B__Allstate__Brevard_Fire_department.pdf PDF
Attachment_E__Draft_Contract.pdf PDF
Exhibit_C__641728_BREVARD_COUNTY_BOARD__Claimrun.pdf PDF
Attachment_C__Premium_Worksheet.xlsx XLSX spreadsheet
Exhibit_A__Census.pdf PDF
Exhibit_B__The_Standard_Life_Plan_Cert_Retirees.pdf PDF
Exhibit_B_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_B_Aflac__Brevard_2025.pdf PDF
Exhibit_B__Colonial_Life__Brevard_2025.pdf PDF
Attachment_A__Mandatory_Requirements__Proposal_Worksheet_revised_6.4.26.docx DOCX document
Exhibit_B__The_Standard_LTD_Cert.pdf PDF
Exhibit_B_Spouse_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_C_Incurred_vs._Paid_Exhibit.pdf PDF
Attachment_B__Plan_Design_Worksheet.xlsx XLSX spreadsheet
Exhibit_B__The_Standard_STD_Cert.pdf PDF
Exhibit_B__The_Standard_Life_and_ADD_Cert_Active_EEs.pdf PDF
Attachment_D_Certification_of_Financial_Condition.pdf PDF
INV__SPECIFICATIONS.pdf PDF
Exhibit_C__Claim_Run_Reference_Sheet.pdf PDF
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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *3,7893,9123,9583,9844,05519,698
Earned Premium242,272251,998283,544311,977168,0451,257,836
Paid Claims478,500542,440198,300432,400225,3601,877,000
Conversions000000
Change in Reported Reserves-155,32832,588-96,636-46,56226,718-239,220
Change in IBNR Reserves10,713-7,8595,8105,8452,83717,346
Incurred Claims333,885567,169107,474391,683254,9151,655,126
Loss Ratio138%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *3,7403,8663,9103,9364,00819,460
Earned Premium219,696229,098259,601286,381155,6781,150,454
Paid Claims453,500532,440193,300407,400225,3601,812,000
Conversions000000
Change in Reported Reserves-155,32832,588-96,636-46,56226,718-239,220
Change in IBNR Reserves9,715-7,1455,3195,3652,62815,883
Incurred Claims307,887557,883101,983366,203254,7061,588,663
Loss Ratio140%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *4946484847238
Earned Premium22,57622,90023,94325,59612,367107,382
Paid Claims25,00010,0005,00025,000065,000
Conversions000000
Change in Reported Reserves000000
Change in IBNR Reserves998-7144914802091,463
Incurred Claims25,9989,2865,49125,48020966,463
Loss Ratio115%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *3,7463,8663,9103,9384,01119,471
Earned Premium37,84038,70643,51247,37924,229191,666
Paid Claims046,00000046,000
Conversions000000
Change in Reported Reserves000000
Change in IBNR Reserves641-488299293188933
Incurred Claims64145,51229929318846,933
Loss Ratio2%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *1,7821,8301,8631,8491,9049,228
Earned Premium595,966601,876612,561586,822313,8992,711,124
Paid Claims385,000328,400410,000384,800257,6001,765,800
Conversions000000
Change in Reported Reserves-245,44068,300-140,860-221,52024,380-515,140
Change in IBNR Reserves-1,3195,051-4,529-1,1448,2246,283
Incurred Claims138,241401,751264,611162,136290,2041,256,943
Loss Ratio23%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *1,7821,8361,8631,8491,9049,234
Earned Premium40,40235,71236,34841,11620,898174,476
Paid Claims000000
Conversions000000
Change in Reported Reserves000000
Change in IBNR Reserves-57-1,6501,5753911623
Incurred Claims-57-1,6501,5753911623
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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *1,1111,0901,0321,0071,0075,247
Earned Premium78,67875,97775,09371,55937,347338,654
Paid Claims120,00060,000201,80093,20025,000500,000
Conversions000000
Change in Reported Reserves000000
Change in IBNR Reserves-123-243-40-131225-312
Incurred Claims119,87759,757201,76093,06925,225499,688
Loss Ratio152%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *1,3071,3401,3961,4561,4936,992
Earned Premium338,847345,003372,295385,470227,9651,669,580
Paid Claims211,575219,948220,687196,64181,489930,340
FICA5960000596
Change in Reported Reserves000000
Change in IBNR Reserves3,7184,7494,1435,68211,24329,535
Incurred Claims215,889224,697224,830202,32392,732960,471
Loss Ratio64%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
From1/1/221/1/231/1/241/1/251/1/26Totals
Through12/31/2212/31/2312/31/2412/31/256/30/26
Lives *1,4981,5051,5321,5191,5457,599
Earned Premium453,025465,939487,935480,347272,5442,159,790
Paid Claims68,146193,55519,75254,0490335,502
FICA000000
Change in Reported Reserves0110,5820281,5040392,086
Change in IBNR Reserves0000310,602310,602
Incurred Claims68,146304,13719,752335,553310,6021,038,190
Loss Ratio15%65%4%70%114%48%

* Data pulled from end of period

File details come from the government source that posted it. Updated .