Attachment_A_-_Additional_Reporting.pdf
PDF 651 KB Posted
- Solicitation number
- Y24-1002
- Issued by
- Orange County, Orlando City, Florida
About this file
This document is an Attachment A reporting file from the Orange County Board of County Commissioners, detailing a multi-year Accidental Death and Dismemberment (AD&D) insurance contract with contract number 641718, effective since 1/1/2014. The attachment provides comprehensive insurance experience data across three coverage types - Spouse AD&D, Basic AD&D, and Additional AD&D - spanning from 1/1/2019 through 12/31/2023, tracking key metrics such as lives covered, earned premiums, paid claims, and incurred claims.
The insurance experience data reveals fluctuating coverage lives across different AD&D categories, ranging from 2,279 to 8,196 lives depending on the specific coverage type and year. Earned premiums varied between $41,250 and $226,569, with notable claim activity particularly in 2020, when paid claims reached significant amounts like $258,000 for Basic AD&D and $400,000 for Additional AD&D. The data shows varying changes in reported and IBNR (Incurred But Not Reported) reserves, with some years experiencing negative claim adjustments, suggesting potential favorable claims experience or retrospective financial corrections.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Group_Term_Life,_Accidental_Death,_Long_and_Short_Term_Disability_and_Dismemberment_(Addendum_#2_Revision).pdf | ||
| Attachment_B_-_Experience_Report_Excel.xlsx | XLSX spreadsheet | |
| Appendix_D_-_EnterpriseSecurityStandards-InternalApplicationsRev4.pdf | ||
| Appendix_C_-_Life_and_Disability_Insurance_Experience_Reports_revised.pdf | ||
| Appendix_B_-_Life_and_Disability_Insurance_Documents.pdf | ||
| Appendix_A_-_Employee_Census.xlsx | XLSX spreadsheet | |
| Form_3_Worksheet.xlsx | XLSX spreadsheet | |
| Form_2_Worksheet.docx | DOCX document | |
| Form_1_Mandatory_Features.docx | DOCX document | |
| RFP_Y24-1002-KK.pdf |
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
Orange County Board of County Commissioners
Contract number - 641718
Coverage Effective Date: 1/1/2014
Spouse AD&D
Experience: Paid Basis
From 1/1/2019 1/1/2020 1/1/2021 1/1/2022 1/1/2023
Through 12/31/2019 12/31/2020 12/31/2021 12/31/2022 12/31/2023
Lives 2,326 2,401 2,434 2,279 3,741
Earned Premium 45,751 48,514 48,013 41,947 41,250
Paid Claims 0 0 0 0 0
Conversions 0 0 0 0 0
Change in Reported Reserves 0 0 0 0 0
Change in IBNR Reserves 120 43 0 -581 101
Incurred Claims 120 43 0 -581 101
ATTACHMENT A
Coverage Effective Date: 1/1/2014
Basic AD&D
Experience: Paid Basis
From 1/1/2019 1/1/2020 1/1/2021 1/1/2022 1/1/2023
Through 12/31/2019 12/31/2020 12/31/2021 12/31/2022 12/31/2023
Lives 8,090 8,196 8,093 7,600 7,666
Earned Premium 148,507 165,323 150,536 155,746 171,276
Paid Claims 40,000 258,000 74,000 0 0
Conversions 0 0 0 0 0
Change in Reported Reserves 40,000 34,000 -74,000 0 0
Change in IBNR Reserves 166 479 -11 140 1,107
Incurred Claims 80,166 292,479 -11 140 1,107
Coverage Effective Date: 1/1/2014
Additional AD&D
Experience: Paid Basis
From 1/1/2019 1/1/2020 1/1/2021 1/1/2022 1/1/2023
Through 12/31/2019 12/31/2020 12/31/2021 12/31/2022 12/31/2023
Lives * 4,835 4,998 4,961 4,544 4,694
Earned Premium 214,174 226,569 227,947 209,340 212,092
Paid Claims 0 400,000 140,000 0 0
Conversions 0 0 0 0 0
Change in Reported Reserves 0 160,000 -160,000 0 0
Change in IBNR Reserves 550 414 -8 -1,618 608
Incurred Claims 550 560,414 -20,008 -1,618 608
* Data pulled from end of period
File details come from the government source that posted it. Updated .