ESBD_379720_1730749720275_Attachment M - Additional Disability Experience.xlsx
XLSX spreadsheet 15 KB Posted
- 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 and a contract term of two years with optional four one-year renewal periods. The RFP allows for a one-time open enrollment for all employees with no underwriting up to the guarantee issue amount, and Central Health is seeking to bundle the life and disability coverages with the same vendor if most advantageous.
The RFP does not mention any set-aside designations or restrictions on the types of organizations that can respond, and there are no listed incumbent vendors or current contractors. The RFP does not provide any information on possible award values or budget ranges, though the historical claims data and premium information suggests this is a significant employee benefits contract for the Travis County Healthcare District.
View the file
Other files
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 | |||
| Date | Premium ($) | Lives | Total Claims ($) |
| 09/01/2020 | $22,539.93 | 891 | $9,457.94 |
| 10/01/2020 | $11,523.14 | 836 | $15,949.33 |
| 11/01/2020 | $20,174.75 | 828 | $25,714.65 |
| 12/01/2020 | $20,751.39 | 827 | $33,399.89 |
| 01/01/2021 | $19,640.98 | 818 | $11,200.60 |
| 02/01/2021 | $21,197.73 | 835 | $16,950.83 |
| 03/01/2021 | $28,781.10 | 856 | $19,244.55 |
| 04/01/2021 | $32,002.15 | 925 | $19,904.34 |
| 05/01/2021 | $31,046.22 | 905 | $12,772.03 |
| 06/01/2021 | $29,927.01 | 898 | $19,363.82 |
| 07/01/2021 | $30,839.59 | 912 | $34,666.78 |
| 08/01/2021 | $32,122.57 | 939 | $22,775.64 |
| 09/01/2021 | $31,316.87 | 935 | $25,743.48 |
| 10/01/2021 | $29,886.09 | 907 | $3,386.24 |
| 11/01/2021 | $31,083.65 | 902 | $23,175.68 |
| 12/01/2021 | $25,057.92 | 895 | $39,948.62 |
| 01/01/2022 | $31,531.77 | 891 | $18,624.57 |
| 02/01/2022 | $31,329.86 | 887 | $38,970.77 |
| 03/01/2022 | $30,701.75 | 862 | $20,442.02 |
| 04/01/2022 | $35,567.16 | 906 | $31,935.33 |
| 05/01/2022 | $33,597.48 | 919 | $29,863.14 |
| 06/01/2022 | $33,395.80 | 917 | $12,920.22 |
| 07/01/2022 | $33,488.82 | 915 | $22,736.71 |
| 08/01/2022 | $35,303.24 | 934 | $12,014.54 |
| 09/01/2022 | $33,412.03 | 919 | $9,233.98 |
| 10/01/2022 | $34,038.18 | 909 | $24,849.10 |
| 11/01/2022 | $36,067.93 | 927 | $23,718.06 |
| 12/01/2022 | $34,874.41 | 927 | $22,726.64 |
| 01/01/2023 | $34,859.38 | 926 | $26,985.50 |
| 02/01/2023 | $38,346.59 | 953 | $36,778.52 |
| 03/01/2023 | $42,612.70 | 1,054 | $19,636.35 |
| 04/01/2023 | $36,637.92 | 1,009 | $15,287.80 |
| 05/01/2023 | $39,520.66 | 1,006 | $7,006.89 |
| 06/01/2023 | $40,930.56 | 1,019 | $26,306.33 |
| 07/01/2023 | $40,622.77 | 1,030 | $35,159.03 |
| 08/01/2023 | $41,064.55 | 1,035 | $35,216.90 |
LTD Premium Experience
| TRAVIS COUNTY HEALTHCARE DISTRICT | ||
| 05924797 | ||
| Date | Premium ($) | Lives |
| 05/01/2019 | $16,694.53 | 981 |
| 06/01/2019 | $16,958.69 | 992 |
| 07/01/2019 | $16,666.25 | 992 |
| 08/01/2019 | $16,979.04 | 1,002 |
| 09/01/2019 | $16,654.34 | 998 |
| 10/01/2019 | $16,761.31 | 1,000 |
| 11/01/2019 | $17,343.64 | 1,022 |
| 12/01/2019 | $21,305.47 | 1,178 |
| 01/01/2020 | $19,276.03 | 1,179 |
| 02/01/2020 | $18,490.79 | 1,156 |
| 03/01/2020 | $20,000.99 | 1,159 |
| 04/01/2020 | $19,509.46 | 1,166 |
| 05/01/2020 | $19,569.58 | 1,172 |
| 06/01/2020 | $19,807.18 | 1,192 |
| 07/01/2020 | $20,007.52 | 1,198 |
| 08/01/2020 | $20,095.04 | 1,209 |
| 09/01/2020 | $20,046.91 | 1,220 |
| 10/01/2020 | $20,923.89 | 1,243 |
| 11/01/2020 | $20,545.05 | 1,250 |
| 12/01/2020 | $20,436.98 | 1,240 |
| 01/01/2021 | $20,775.20 | 1,248 |
| 02/01/2021 | $21,041.59 | 1,267 |
| 03/01/2021 | $32,177.10 | 1,305 |
| 04/01/2021 | $31,666.67 | 1,313 |
| 05/01/2021 | $32,432.95 | 1,287 |
| 06/01/2021 | $32,356.99 | 1,289 |
| 07/01/2021 | $32,506.33 | 1,304 |
| 08/01/2021 | $32,901.06 | 1,326 |
| 09/01/2021 | $34,727.95 | 1,351 |
| 10/01/2021 | $33,671.69 | 1,354 |
| 11/01/2021 | $33,733.18 | 1,360 |
| 12/01/2021 | $26,040.61 | 1,340 |
| 01/01/2022 | $33,734.88 | 1,333 |
| 02/01/2022 | $33,906.29 | 1,337 |
| 03/01/2022 | $37,795.43 | 1,339 |
| 04/01/2022 | $39,472.72 | 1,325 |
| 05/01/2022 | $39,613.34 | 1,348 |
| 06/01/2022 | $39,717.91 | 1,356 |
| 07/01/2022 | $39,495.63 | 1,353 |
| 08/01/2022 | $41,422.80 | 1,370 |
| 09/01/2022 | $41,412.17 | 1,379 |
| 10/01/2022 | $40,703.73 | 1,373 |
| 11/01/2022 | $41,114.85 | 1,370 |
| 12/01/2022 | $41,708.04 | 1,387 |
| 01/01/2023 | $41,086.94 | 1,381 |
| 02/01/2023 | $43,187.95 | 1,384 |
| 03/01/2023 | $47,382.53 | 1,456 |
| 04/01/2023 | $44,752.79 | 1,452 |
| 05/01/2023 | $45,229.35 | 1,459 |
| 06/01/2023 | $47,203.78 | 1,486 |
| 07/01/2023 | $48,110.72 | 1,523 |
| 08/01/2023 | $48,217.83 | 1,537 |
LTD Claims Experience
| TRAVIS COUNTY HEALTHCARE DISTRICT | |||||||||
| 05924797 | |||||||||
| Experience Number | Status | Gender | SS Type | DOD | DIS Code | 2 YR Limit | Gross Benefit | Net Benefit | Accum Benefit Amt |
| 5924797 | 03 | F | UN | 2019-09-23 | 6 | N | $2,615.60 | $0.00 | $50,742.46 |
| 5924797 | 03 | F | NE | 2019-10-29 | 10 | N | $6,000.00 | $0.00 | $132,431.55 |
| 5924797 | 00 | F | IA | 2019-10-17 | 6 | N | $5,941.03 | $3,643.03 | $149,168.20 |
| 5924797 | 03 | F | JP | 2020-01-16 | 6 | Y | $3,914.03 | $0.00 | $93,675.79 |
| 5924797 | 01 | F | NF | 2020-12-23 | 9 | N | $0.60 | $0.00 | $0.00 |
| 5924797 | 00 | F | IA | 2022-03-26 | 1 | N | $4,954.49 | $2,356.49 | $25,921.39 |
| 5924797 | 02 | F | IA | 2021-08-13 | 13 | N | $3,396.22 | $1,200.22 | $56,414.04 |
| 5924797 | 00 | F | IP | 2022-01-17 | 13 | N | $2,692.56 | $822.56 | $35,003.28 |
| 5924797 | 01 | F | UN | 2021-08-09 | 17 | N | $0.60 | $0.00 | $0.00 |
| 5924797 | 03 | F | NE | 2021-10-01 | 2 | N | $2,008.37 | $0.00 | $11,488.03 |
| 5924797 | 01 | F | UN | 2021-06-04 | 18 | N | $2,069.60 | $0.00 | $0.00 |
| 5924797 | 01 | F | UN | 2022-04-11 | 17 | N | $2,104.96 | $0.00 | $0.00 |
| 5924797 | 00 | F | NF | 2023-02-14 | 9 | N | $3,407.05 | $3,407.05 | $0.00 |
| 5924797 | 01 | F | UN | 2022-05-13 | 17 | N | $0.60 | $0.00 | $0.00 |
| 5924797 | 00 | F | NF | 2022-11-09 | 7 | N | $6,000.00 | $6,000.00 | $18,000.00 |
File details come from the government source that posted it. Updated .