ESBD_379720_1730749720275_Attachment M - Additional Disability Experience.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
Life, Short & Long Term Disability Employee Benefits
Solicitation number
2510-006
Issued by
Travis County, Austin City, Texas

About this file

This document is a Request for Proposals (RFP) issued by the Travis County Healthcare District d/b/a Central Health for basic life & AD&D, voluntary life & AD&D, employer paid short-term disability, voluntary short-term disability, and employer paid long-term disability insurance coverage. The RFP seeks qualified vendors to provide these benefits to approximately 1,900 Central Health employees, with a proposal due date of November 14, 2024. The initial contract term is two years, with optional four one-year renewal periods. Central Health is seeking to bundle the life and disability coverages with the same vendor, but will contract with separate vendors if that is most advantageous.

The RFP provides historical claims data and premium information, suggesting this is a significant employee benefits contract. However, it does not mention any set-aside designations, restrictions on the types of organizations that can respond, or provide details on existing infrastructure or technology that requires integration. Additionally, the RFP does not specify any incumbent vendors or current contractors, nor does it provide information on possible award values or budget ranges.

View the file

Other files

File Type Posted
ESBD_379720_1729031363367_Attachment G - TRAVIS COUNTY HEALTHCARE DISTRICT ltd mpr_std mars report 08.01.2023 - 07.31.2024.xlsx XLSX spreadsheet
ESBD_379720_1730752713714_Addendum 7_Q&As.pdf PDF
ESBD_379720_1729885511235_Addendum 4 - Post Additional Attachments.pdf PDF
ESBD_379720_1729885656635_Attachment L - UHC Life Experience 122023 - current report.pdf PDF
ESBD_379720_1729030860092_RFP 2510-006 Life, Short_Long Term Disability.pdf PDF
ESBD_379720_1729031136155_Attachment C - UHC Life Experience 032018-current.pdf PDF
ESBD_379720_1729274028478_Addendum #2_Pre-Proposal Conference.pdf PDF
ESBD_379720_1729031192350_Attachment D - UHC Life paid claim report.xlsx XLSX spreadsheet
ESBD_379720_1729031266148_Attachment E - UHC Plan Documents.pdf PDF
ESBD_379720_1730744991694_RFP 2510-006_Addendum 5_ Amendment 1 - Update to Exhibit B_Response Template.pdf PDF
ESBD_379720_1730745131589_REVISED - Exhibit B - Response Template_ RFP 2510-006.xlsx XLSX spreadsheet
ESBD_379720_1729031411097_Attachment H - STD LTD Claim Status 9.1.23-8.31.24_Claim Status Report.xlsx XLSX spreadsheet
ESBD_379720_1729031079107_Attachment B - Employee Census - RFP 2510-006 Life & Disability.xlsx XLSX spreadsheet
ESBD_379720_1730749696996_Addendum 6 - Post Additional Attachment.pdf PDF
ESBD_379720_1729103901241_2510-006_Addendum 1_FAQs.pdf PDF
ESBD_379720_1730749720275_Attachment M - Additional Disability Experience.xlsx XLSX spreadsheet
ESBD_379720_1731522844628_RFP Amendment 2 - Schedule of Events Change.pdf PDF
ESBD_379720_1729885601758_Attachment J - UHC Life Experience 032018-112022.pdf PDF
ESBD_379720_1729634933127_Addendum 3 - Pre-Proposal Conference - Attendees and Recording.pdf PDF
ESBD_379720_1729030935121_Exhibit B - RFP 2510-006 Life & Disability Response Template.xlsx XLSX spreadsheet
ESBD_379720_1729885561966_Attachment I - MetLife Invoice 11.24.xlsx XLSX spreadsheet
ESBD_379720_1729885624841_Attachment K - UHC Life Experience 122022 - 122023 report.pdf PDF
ESBD_379720_1730745094878_RFP 2510 -006 - Amendment 1 - Update to Exhibit B - Response Template.pdf PDF
ESBD_379720_1730744991694_RFP 2510-006_Addendum 5_ Amendment 1 - Update to Exhibit B_Response Template.pdf PDF
ESBD_379720_1729634933127_Addendum 3 - Pre-Proposal Conference - Attendees and Recording.pdf PDF
ESBD_379720_1729031363367_Attachment G - TRAVIS COUNTY HEALTHCARE DISTRICT ltd mpr_std mars report 08.01.2023 - 07.31.2024.xlsx XLSX spreadsheet
ESBD_379720_1729885656635_Attachment L - UHC Life Experience 122023 - current report.pdf PDF
ESBD_379720_1729885561966_Attachment I - MetLife Invoice 11.24.xlsx XLSX spreadsheet
ESBD_379720_1729031266148_Attachment E - UHC Plan Documents.pdf PDF
ESBD_379720_1729885601758_Attachment J - UHC Life Experience 032018-112022.pdf PDF
ESBD_379720_1729885624841_Attachment K - UHC Life Experience 122022 - 122023 report.pdf PDF
ESBD_379720_1729274028478_Addendum #2_Pre-Proposal Conference.pdf PDF
ESBD_379720_1729031136155_Attachment C - UHC Life Experience 032018-current.pdf PDF
ESBD_379720_1730745131589_REVISED - Exhibit B - Response Template_ RFP 2510-006.xlsx XLSX spreadsheet
ESBD_379720_1730749696996_Addendum 6 - Post Additional Attachment.pdf PDF
ESBD_379720_1729031192350_Attachment D - UHC Life paid claim report.xlsx XLSX spreadsheet
ESBD_379720_1730745094878_RFP 2510 -006 - Amendment 1 - Update to Exhibit B - Response Template.pdf PDF
ESBD_379720_1729031411097_Attachment H - STD LTD Claim Status 9.1.23-8.31.24_Claim Status Report.xlsx XLSX spreadsheet
ESBD_379720_1729030935121_Exhibit B - RFP 2510-006 Life & Disability Response Template.xlsx XLSX spreadsheet
ESBD_379720_1729030860092_RFP 2510-006 Life, Short_Long Term Disability.pdf PDF
ESBD_379720_1729885511235_Addendum 4 - Post Additional Attachments.pdf PDF
ESBD_379720_1729103901241_2510-006_Addendum 1_FAQs.pdf PDF
ESBD_379720_1729031079107_Attachment B - Employee Census - RFP 2510-006 Life & Disability.xlsx XLSX spreadsheet
ESBD_379720_1730752713714_Addendum 7_Q&As.pdf PDF
ESBD_379720_1729030935121_Exhibit B - RFP 2510-006 Life & Disability Response Template.xlsx XLSX spreadsheet
ESBD_379720_1729274028478_Addendum #2_Pre-Proposal Conference.pdf PDF
ESBD_379720_1729885511235_Addendum 4 - Post Additional Attachments.pdf PDF
ESBD_379720_1729103901241_2510-006_Addendum 1_FAQs.pdf PDF
ESBD_379720_1729031411097_Attachment H - STD LTD Claim Status 9.1.23-8.31.24_Claim Status Report.xlsx XLSX spreadsheet
ESBD_379720_1729885601758_Attachment J - UHC Life Experience 032018-112022.pdf PDF
Show 40 more

Latest 50 of 68 listed here. See the rest on GovTribe.

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

STD Experience

TRAVIS COUNTY HEALTHCARE DISTRICT
05924797
DatePremium ($)LivesTotal Claims ($)
09/01/2020$22,539.93891$9,457.94
10/01/2020$11,523.14836$15,949.33
11/01/2020$20,174.75828$25,714.65
12/01/2020$20,751.39827$33,399.89
01/01/2021$19,640.98818$11,200.60
02/01/2021$21,197.73835$16,950.83
03/01/2021$28,781.10856$19,244.55
04/01/2021$32,002.15925$19,904.34
05/01/2021$31,046.22905$12,772.03
06/01/2021$29,927.01898$19,363.82
07/01/2021$30,839.59912$34,666.78
08/01/2021$32,122.57939$22,775.64
09/01/2021$31,316.87935$25,743.48
10/01/2021$29,886.09907$3,386.24
11/01/2021$31,083.65902$23,175.68
12/01/2021$25,057.92895$39,948.62
01/01/2022$31,531.77891$18,624.57
02/01/2022$31,329.86887$38,970.77
03/01/2022$30,701.75862$20,442.02
04/01/2022$35,567.16906$31,935.33
05/01/2022$33,597.48919$29,863.14
06/01/2022$33,395.80917$12,920.22
07/01/2022$33,488.82915$22,736.71
08/01/2022$35,303.24934$12,014.54
09/01/2022$33,412.03919$9,233.98
10/01/2022$34,038.18909$24,849.10
11/01/2022$36,067.93927$23,718.06
12/01/2022$34,874.41927$22,726.64
01/01/2023$34,859.38926$26,985.50
02/01/2023$38,346.59953$36,778.52
03/01/2023$42,612.701,054$19,636.35
04/01/2023$36,637.921,009$15,287.80
05/01/2023$39,520.661,006$7,006.89
06/01/2023$40,930.561,019$26,306.33
07/01/2023$40,622.771,030$35,159.03
08/01/2023$41,064.551,035$35,216.90

LTD Premium Experience

TRAVIS COUNTY HEALTHCARE DISTRICT
05924797
DatePremium ($)Lives
05/01/2019$16,694.53981
06/01/2019$16,958.69992
07/01/2019$16,666.25992
08/01/2019$16,979.041,002
09/01/2019$16,654.34998
10/01/2019$16,761.311,000
11/01/2019$17,343.641,022
12/01/2019$21,305.471,178
01/01/2020$19,276.031,179
02/01/2020$18,490.791,156
03/01/2020$20,000.991,159
04/01/2020$19,509.461,166
05/01/2020$19,569.581,172
06/01/2020$19,807.181,192
07/01/2020$20,007.521,198
08/01/2020$20,095.041,209
09/01/2020$20,046.911,220
10/01/2020$20,923.891,243
11/01/2020$20,545.051,250
12/01/2020$20,436.981,240
01/01/2021$20,775.201,248
02/01/2021$21,041.591,267
03/01/2021$32,177.101,305
04/01/2021$31,666.671,313
05/01/2021$32,432.951,287
06/01/2021$32,356.991,289
07/01/2021$32,506.331,304
08/01/2021$32,901.061,326
09/01/2021$34,727.951,351
10/01/2021$33,671.691,354
11/01/2021$33,733.181,360
12/01/2021$26,040.611,340
01/01/2022$33,734.881,333
02/01/2022$33,906.291,337
03/01/2022$37,795.431,339
04/01/2022$39,472.721,325
05/01/2022$39,613.341,348
06/01/2022$39,717.911,356
07/01/2022$39,495.631,353
08/01/2022$41,422.801,370
09/01/2022$41,412.171,379
10/01/2022$40,703.731,373
11/01/2022$41,114.851,370
12/01/2022$41,708.041,387
01/01/2023$41,086.941,381
02/01/2023$43,187.951,384
03/01/2023$47,382.531,456
04/01/2023$44,752.791,452
05/01/2023$45,229.351,459
06/01/2023$47,203.781,486
07/01/2023$48,110.721,523
08/01/2023$48,217.831,537

LTD Claims Experience

TRAVIS COUNTY HEALTHCARE DISTRICT
05924797
Experience NumberStatusGenderSS TypeDODDIS Code2 YR LimitGross BenefitNet BenefitAccum Benefit Amt
592479703FUN2019-09-236N$2,615.60$0.00$50,742.46
592479703FNE2019-10-2910N$6,000.00$0.00$132,431.55
592479700FIA2019-10-176N$5,941.03$3,643.03$149,168.20
592479703FJP2020-01-166Y$3,914.03$0.00$93,675.79
592479701FNF2020-12-239N$0.60$0.00$0.00
592479700FIA2022-03-261N$4,954.49$2,356.49$25,921.39
592479702FIA2021-08-1313N$3,396.22$1,200.22$56,414.04
592479700FIP2022-01-1713N$2,692.56$822.56$35,003.28
592479701FUN2021-08-0917N$0.60$0.00$0.00
592479703FNE2021-10-012N$2,008.37$0.00$11,488.03
592479701FUN2021-06-0418N$2,069.60$0.00$0.00
592479701FUN2022-04-1117N$2,104.96$0.00$0.00
592479700FNF2023-02-149N$3,407.05$3,407.05$0.00
592479701FUN2022-05-1317N$0.60$0.00$0.00
592479700FNF2022-11-097N$6,000.00$6,000.00$18,000.00

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