Question 18 - Act vs. Ret.pdf
PDF 77 KB Posted
- Solicitation number
- 20-416CMS-BENF4-B-12595
- Issued by
- St. Clair County, Illinois
About this file
This document is an experience analysis related to a state and local government contract opportunity for life insurance services in Illinois. The Department of Central Management Services is seeking a vendor to provide a group life and accidental death & dismemberment (AD&D) insurance program for its employees and annuitants. The analysis provides historical claims data for active and retired employees across various insurance coverages including basic term life, supplemental employee life, spouse life, child life, and AD&D. The data is broken down by fiscal year from 2015 to 2019 and includes metrics such as lives, volume, paid premium, claim count, and loss ratio.
The related state and local contract opportunity is for "Life Insurance Services - Technical Proposal Only", and electronic responses are required with no paper submissions accepted. Pricing will be submitted under a separate bid number. The contract term is not specified in the provided information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Appendices 1 thru 7.xlsx | XLSX spreadsheet | |
| Question 18 - Financial Experience July 2019 through March 2020.xlsx | XLSX spreadsheet | |
| Vendor Instruction to submit Technical Proposals B-12595.docx | DOCX document | |
| Addendum 1_3.doc | DOC document | |
| Appendix 8 Census Data.xlsx | XLSX spreadsheet | |
| Appendix 9 Census Data Life Summary Report Basic and Optional Age Count 1000 Units.xlsm | XLSM spreadsheet | |
| Attachment - Notice of Electronic Submission Only v.20.2.pdf | ||
| CMS Benefits B12595 Notice of Award Form Life Insurance Services_1.pdf | ||
| Met. Life Protest.zip | ZIP file | |
| Appendix 10 Certificate of Insurance.pdf | ||
| Forms A~24.doc | DOC document | |
| Group Life Insurance RFP.docx | DOCX document | |
| MetLife Protest CPO Determination.pdf | ||
| Utilization Plan Version 20.0.pdf | ||
| CountyCodes.xlsx | XLSX spreadsheet | |
| Forms B Section V.20.1~17.docx | DOCX document | |
| Group Life Insurance RFP Revisions 5-19-20.docx | DOCX document | |
| Question 18 - Optional Life Split.docx | DOCX document |
Show all 18
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
Active
Year Months Lives Volume Paid Premium Claim Count Claims Loss Ratio
FY 2015 12 109,690 7,386,342 29,249,913 226 14,553,540 49.8%
FY 2016 12 107,724 7,281,674 28,835,431 236 15,186,400 52.7%
FY 2017 12 106,864 7,149,561 28,312,260 231 14,670,750 51.8%
FY 2018 12 105,666 7,188,835 28,467,785 202 13,269,561 46.6%
FY 2019 12 106,219 7,306,321 28,933,032 222 15,065,824 52.1%
FY15-FY19 60 107,233 7,262,546 143,798,421 1,117 72,746,076 50.6%
Retiree
Year Months Lives Volume Paid Premium Claim Count Claims Loss Ratio
FY 2015 12 86,066 1,126,880 4,462,447 2,641 16,131,834 361.5%
FY 2016 12 88,801 1,160,548 4,595,769 2,569 15,514,238 337.6%
FY 2017 12 90,975 1,174,317 4,650,297 2,702 16,412,640 352.9%
FY 2018 12 92,761 1,174,638 4,651,565 2,857 18,500,673 397.7%
FY 2019 12 94,945 1,173,964 4,648,898 2,716 16,449,537 353.8%
FY15-FY19 60 90,710 1,162,069 23,008,976 13,485 83,008,923 360.8%
Notes
- Excludes conversion charges
Policy 32491-G
State of Illinois
EXPERIENCE ANALYSIS
Basic Term Life - Experience by Active vs. Retiree
FY 2015 12 56,537 13,366,305 38,863,206 103 20,959,386 57.1%
FY 2016 12 55,528 13,174,172 38,570,522 119 28,501,100 78.3%
FY 2017 12 54,371 12,859,786 37,959,351 117 23,570,729 65.8%
FY 2018 12 52,574 12,573,906 37,373,122 95 21,227,900 60.2%
FY 2019 12 52,292 12,548,004 35,471,570 108 22,067,223 62.2%
FY15-FY19 60 54,260 12,904,435 188,237,771 542 116,326,338 64.7%
Retiree
Year Months Lives Volume Paid Premium Claim Count Claims Loss Ratio
FY 2015 12 38,040 1,642,789 11,939,311 1,478 18,651,127 160.6%
FY 2016 12 39,075 1,750,235 12,668,971 1,463 18,793,032 152.5%
FY 2017 12 39,561 1,807,319 13,325,462 1,440 18,538,414 143.0%
FY 2018 12 40,358 1,827,683 13,669,156 1,475 20,976,237 157.7%
FY 2019 12 40,973 1,810,909 13,587,286 1,445 17,980,985 132.3%
FY15-FY19 60 39,601 1,767,787 65,190,186 7,301 94,939,795 148.8%
Notes
- Excludes conversion charges
State of Illinois
Supplemental Employee Life - Experience by Active vs. Retiree
FY 2015 12 22,135 221,353 1,591,470 72 720,000 45.2%
FY 2016 12 21,450 214,500 1,542,447 68 680,000 44.1%
FY 2017 12 20,864 208,562 1,492,305 83 820,000 54.9%
FY 2018 12 19,988 199,610 1,441,721 55 550,000 38.1%
FY 2019 12 19,588 194,450 1,402,590 62 620,000 44.2%
FY15-FY19 60 20,805 207,695 7,470,533 340 3,390,000 45.4%
Retiree
Year Months Lives Volume Paid Premium Claim Count Claims Loss Ratio
FY 2015 12 14,183 82,133 591,249 254 1,333,143 225.5%
FY 2016 12 14,502 84,153 606,065 263 1,405,099 231.8%
FY 2017 12 14,422 83,792 602,135 237 1,210,080 201.0%
FY 2018 12 14,648 84,765 610,849 293 1,550,117 253.8%
FY 2018 12 14,861 86,645 622,989 272 1,455,265 233.6%
FY15-FY19 60 14,523 84,297 3,033,286 1319 6,953,704 229.2%
Notes
- Excludes conversion charges
State of Illinois
Spouse Life - Experience by Active vs. Retiree
FY 2015 12 62,512 625,116 280,334 32 320,001 114.2%
FY 2016 12 62,345 623,446 278,582 34 340,010 122.1%
FY 2017 12 60,791 607,937 274,614 24 240,000 87.4%
FY 2018 12 59,486 594,826 273,071 31 310,026 113.5%
FY 2019 12 59,438 594,434 272,645 25 250,000 91.7%
FY15-FY19 60 60,914 609,152 1,379,246 146 1,460,037 105.9%
Retiree
Year Months Lives Volume Paid Premium Claim Count Claims Loss Ratio
FY 2015 12 4,583 45,832 27,163 2 20,000 73.6%
FY 2016 12 5,086 50,863 29,994 8 80,000 266.7%
FY 2017 12 6,588 65,883 32,395 2 20,000 61.7%
FY 2018 12 7,467 74,646 34,209 2 20,000 58.5%
FY 2019 12 7,736 77,357 35,328 2 20,000 56.6%
FY15-FY19 60 6,292 62,916 159,089 16 160,000 100.6%
Notes:
- Excludes conversion charges
State of Illinois
Child Life - Experience by Active vs. Retiree
FY 2015 12 55,564 11,134,712 2,680,022 1 123,200 4.6%
FY 2016 12 55,090 10,885,822 2,620,428 8 1,082,700 41.3%
FY 2017 12 54,087 10,570,017 2,527,822 10 2,161,900 85.5%
FY 2018 12 52,617 10,405,053 2,476,553 6 492,300 19.9%
FY 2019 12 52,288 10,338,559 2,487,786 13 2,211,943 88.9%
FY15-FY19 60 53,929 10,666,833 12,792,611 38 6,072,043 47.5%
Retiree
Year Months Lives Volume Paid Premium Claim Count Claims Loss Ratio
FY 2015 12 35,774 1,796,179 431,827 37 438,500 101.5%
FY 2016 12 36,769 1,892,784 454,875 35 136,501 30.0%
FY 2017 12 37,514 1,945,124 467,850 19 641,043 137.0%
FY 2018 12 38,393 1,952,107 469,360 16 405,010 86.3%
FY 2019 12 39,303 1,937,917 467,296 20 230,004 49.2%
FY15-FY19 60 37,551 1,904,822 2,291,208 127 1,851,059 80.8%
State of Illinois
AD&D - Experience by Active vs. Retiree
File details come from the government source that posted it. Updated .