ESBD_360338_1716477844264_Attachment D.1 - Aggregate Stop-Loss 2021-March 2024.pdf
PDF 22 KB Posted
- Solicitation number
- RFp2024-P11
- Issued by
- Hays County, Texas
About this file
This document is an Aggregate Stop-Loss Report for the County of Hays, Texas covering the period from January 2021 through March 2024. The report provides monthly estimates of the Aggregate Stop-Loss (ASL) liability based on the number of subscribers enrolled in the medical plan and their claims experience. The ASL contract begins on January 1, 2021 and ends on December 31, 2024, covering medical, pharmacy, and dental benefits. The report includes detailed counts of covered subscribers and the estimated monthly and year-to-date ASL liability.
The County of Hays is issuing a Request for Proposals (RFP) for Employee Group Health, Dental, and Employee Assistance Plans with the intent to implement the selected plans effective January 1, 2025. The County is seeking a comprehensive benefits package and is looking to partner with insurance companies that can provide competitive and stable long-term financial solutions while offering robust employee benefits. The RFP response deadline is October 1, 2024, and open enrollment for the selected plans will begin on the same date.
View the file
Other files
Show all 23
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
PAGE #01 00000912772
REPORT DATE 12/01/2021
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2021
ASL END DATE 12/31/2021
COUNTS
SUF FACTOR 01/2021 02/2021 03/2021 04/2021 05/2021 06/2021 07/2021 08/2021 09/2021 10/2021 11/2021 12/2021
AD 1306.78 458 462 459 462 456 461 465 459 456 460 460 458
AE 1306.78 456 463 464 466 463 456 456 457 459 452 452 452
AF 1306.78 90 93 91 94 92 89 89 88 87 87 85 81
TOTAL 1,004 1,018 1,014 1,022 1,011 1,006 1,010 1,004 1,002 999 997 991
LIABILITY
SUF 01/2021 02/2021 03/2021 04/2021 05/2021 06/2021 07/2021 08/2021 09/2021 10/2021 11/2021 12/2021
AD 598,505 603,732 599,812 603,732 595,892 602,426 607,653 599,812 595,892 601,119 601,119 598,505 AE 595,892 605,039 606,346 608,959 605,039 595,892 595,892 597,198 599,812 590,665 590,665 590,665 AF 117,610 121,531 118,917 122,837 120,224 116,303 116,303 114,997 113,690 113,690 111,076 105,849
TOTAL 1312,007 1330,302 1325,075 1335,528 1321,155 1314,621 1319,848 1312,007 1309,394 1305,474 1302,860 1295,019
PAGE #02 00000912772
REPORT DATE 12/01/2021
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2021
ASL END DATE 12/31/2021
AGGREGATE RETROACTIVITY AGGREGATE CLAIMS CLAIMS CLAIMS CLAIMS PERCENT INSURANCE
LIABILITY (UP TO THREE LIABILITY EXPENSE EXPENSE CHARGED CHARGED AGGREGATE COMPANY
MONTH MONTHLY MONTHS PRIOR) YTD MONTHLY YTD MONTHLY YTD LIABILITY LIABILITY
JAN-21 1,312,007.12 0.00 1,312,007.12 947,061.14 947,061.14 947,061.14 947,061.14 72.18% 0.00 FEB-21 1,330,302.04 18,294.92 2,660,604.08 1,151,151.25 2,098,212.39 1,151,151.25 2,098,212.39 78.86% 0.00 MAR-21 1,325,074.92 16,988.14- 3,968,690.86 1,178,213.95 3,276,426.34 1,178,213.95 3,276,426.34 82.55% 0.00 APR-21 1,335,529.16 9,147.46 5,313,367.48 884,371.72 4,160,798.06 884,371.72 4,160,798.06 78.30% 0.00 MAY-21 1,321,154.58 43,123.74- 6,591,398.32 683,682.94 4,844,481.00 683,682.94 4,844,481.00 73.49% 0.00 JUN-21 1,314,620.68 20,908.48- 7,885,110.52 1,724,867.00 6,569,348.00 1,724,867.00 6,569,348.00 83.31% 0.00 JUL-21 1,319,847.80 1,306.78- 9,203,651.54 131,560.01 6,700,908.01 131,560.01 6,700,908.01 72.80% 0.00 AUG-21 1,312,007.12 24,828.82- 10,490,829.84 979,404.35 7,680,312.36 979,404.35 7,680,312.36 73.20% 0.00 SEP-21 1,309,393.56 5,227.12- 11,794,996.28 1,330,762.03 9,011,074.39 1,330,762.03 9,011,074.39 76.39% 0.00 OCT-21 1,305,473.22 28,749.16- 13,071,720.34 904,490.78 9,915,565.17 904,490.78 9,915,565.17 75.85% 0.00 NOV-21 1,302,859.66 13,067.80- 14,361,512.20 1,410,489.20 11,326,054.37 1,410,489.20 11,326,054.37 78.86% 0.00 DEC-21 1,295,018.98 28,749.16- 15,627,782.02 1,182,313.41 12,508,367.78 1,182,313.41 12,508,367.78 80.03% 0.00_____________ _____________
15,783,288.84 155,506.82-
REPORT DATE 12/01/2022
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2022
ASL END DATE 12/31/2022
COUNTS
SUF FACTOR 01/2022 02/2022 03/2022 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 10/2022 11/2022 12/2022
AD 1337.64 457 461 464 459 457 460 461 458 455 455 457 455
AE 1337.64 451 447 446 443 437 440 438 443 444 438 447 450
AF 1337.64 79 72 73 71 70 72 70 69 68 66 65 69
TOTAL 987 980 983 973 964 972 969 970 967 959 969 974
LIABILITY
SUF 01/2022 02/2022 03/2022 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 10/2022 11/2022 12/2022
AD 611,301 616,652 620,665 613,977 611,301 615,314 616,652 612,639 608,626 608,626 611,301 608,626 AE 603,276 597,925 596,587 592,575 584,549 588,562 585,886 592,575 593,912 585,886 597,925 601,938 AF 105,674 96,310 97,648 94,972 93,635 96,310 93,635 92,297 90,960 88,284 86,947 92,297
TOTAL 1320,251 1310,887 1314,900 1301,524 1289,485 1300,186 1296,173 1297,511 1293,498 1282,796 1296,173 1302,861
REPORT DATE 12/01/2022
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2022
ASL END DATE 12/31/2022
AGGREGATE RETROACTIVITY AGGREGATE CLAIMS CLAIMS CLAIMS CLAIMS PERCENT INSURANCE
LIABILITY (UP TO THREE LIABILITY EXPENSE EXPENSE CHARGED CHARGED AGGREGATE COMPANY
MONTH MONTHLY MONTHS PRIOR) YTD MONTHLY YTD MONTHLY YTD LIABILITY LIABILITY
JAN-22 1,320,250.68 0.00 1,320,250.68 706,395.36 706,395.36 706,395.36 706,395.36 53.50% 0.00 FEB-22 1,310,887.20 9,363.48- 2,621,774.40 910,698.59 1,617,093.95 910,698.59 1,617,093.95 61.67% 0.00 MAR-22 1,314,900.12 0.00 3,936,674.52 876,334.56 2,493,428.51 876,334.56 2,493,428.51 63.33% 0.00 APR-22 1,301,523.72 52,167.96- 5,186,030.28 849,715.84 3,343,144.35 849,715.84 3,343,144.35 64.46% 0.00 MAY-22 1,289,484.96 45,479.76- 6,430,035.48 944,469.94 4,287,614.29 944,469.94 4,287,614.29 66.68% 0.00 JUN-22 1,300,186.08 5,350.56 7,735,572.12 979,016.34 5,266,630.63 979,016.34 5,266,630.63 68.08% 0.00 JUL-22 1,296,173.16 26,752.80- 9,004,992.48 742,823.39 6,009,454.02 742,823.39 6,009,454.02 66.73% 0.00 AUG-22 1,297,510.80 12,038.76- 10,290,464.52 883,531.39 6,892,985.41 883,531.39 6,892,985.41 66.98% 0.00 SEP-22 1,293,497.88 22,739.88- 11,561,222.52 676,915.12 7,569,900.53 676,915.12 7,569,900.53 65.47% 0.00 OCT-22 1,282,796.76 28,090.44- 12,815,928.84 526,418.36 8,096,318.89 526,418.36 8,096,318.89 63.17% 0.00 NOV-22 1,296,173.16 13,376.40 14,125,478.40 1,532,280.40 9,628,599.29 1,532,280.40 9,628,599.29 68.16% 0.00 DEC-22 1,302,861.36 8,025.84- 15,420,313.92 1,006,063.53 10,634,662.82 1,006,063.53 10,634,662.82 68.96% 0.00_____________ _____________
15,606,245.88 185,931.96-
REPORT DATE 12/01/2023
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2023
ASL END DATE 12/31/2023
COUNTS
SUF FACTOR 01/2023 02/2023 03/2023 04/2023 05/2023 06/2023 07/2023 08/2023 09/2023 10/2023 11/2023 12/2023
AD 1332.61 452 460 448 457 466 468 470 476 473 477 490 490
AE 1332.61 443 450 443 451 457 460 464 466 464 466 477 469
AF 1332.61 68 68 67 68 68 69 72 72 71 74 77 76
TOTAL 963 978 958 976 991 997 1,006 1,014 1,008 1,017 1,044 1,035
LIABILITY
SUF 01/2023 02/2023 03/2023 04/2023 05/2023 06/2023 07/2023 08/2023 09/2023 10/2023 11/2023 12/2023
AD 602,340 613,001 597,009 609,003 620,996 623,661 626,327 634,322 630,325 635,655 652,979 652,979 AE 590,346 599,675 590,346 601,007 609,003 613,001 618,331 620,996 618,331 620,996 635,655 624,994 AF 90,617 90,617 89,285 90,617 90,617 91,950 95,948 95,948 94,615 98,613 102,611 101,278
TOTAL 1283,303 1303,293 1276,640 1300,627 1320,616 1328,612 1340,606 1351,266 1343,271 1355,264 1391,245 1379,251
REPORT DATE 12/01/2023
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2023
ASL END DATE 12/31/2023
AGGREGATE RETROACTIVITY AGGREGATE CLAIMS CLAIMS CLAIMS CLAIMS PERCENT INSURANCE
LIABILITY (UP TO THREE LIABILITY EXPENSE EXPENSE CHARGED CHARGED AGGREGATE COMPANY
MONTH MONTHLY MONTHS PRIOR) YTD MONTHLY YTD MONTHLY YTD LIABILITY LIABILITY
JAN-23 1,283,303.43 0.00 1,283,303.43 1,134,876.56 1,134,876.56 1,134,876.56 1,134,876.56 88.43% 0.00 FEB-23 1,303,292.58 19,989.15 2,606,585.16 827,813.45 1,962,690.01 827,813.45 1,962,690.01 75.29% 0.00 MAR-23 1,276,640.38 49,306.57- 3,833,918.97 956,872.96 2,919,562.97 956,872.96 2,919,562.97 76.15% 0.00 APR-23 1,300,627.36 35,980.47 5,170,526.80 1,027,881.01 3,947,443.98 1,027,881.01 3,947,443.98 76.34% 0.00 MAY-23 1,320,616.51 26,652.20 6,517,795.51 1,359,577.60 5,307,021.58 1,359,577.60 5,307,021.58 81.42% 0.00 JUN-23 1,328,612.17 2,665.22 7,849,072.90 1,129,003.79 6,436,025.37 1,129,003.79 6,436,025.37 81.99% 0.00 JUL-23 1,340,605.66 7,995.66 9,197,674.22 1,024,619.45 7,460,644.82 1,024,619.45 7,460,644.82 81.11% 0.00 AUG-23 1,351,266.54 15,991.32 10,564,932.08 1,284,607.95 8,745,252.77 1,284,607.95 8,745,252.77 82.77% 0.00 SEP-23 1,343,270.88 26,652.20- 11,881,550.76 955,991.41 9,701,244.18 955,991.41 9,701,244.18 81.64% 0.00 OCT-23 1,355,264.37 5,330.44 13,242,145.57 1,336,883.18 11,038,127.36 1,336,883.18 11,038,127.36 83.35% 0.00 NOV-23 1,391,244.84 33,315.25 14,666,705.66 1,040,323.12 12,078,450.48 1,040,323.12 12,078,450.48 82.35% 0.00 DEC-23 1,379,251.35 17,323.93- 16,028,633.08 1,040,026.40 13,118,476.88 1,040,026.40 13,118,476.88 81.84% 0.00_____________ _____________
15,973,996.07 54,637.01
REPORT DATE 03/01/2024
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2024
ASL END DATE 12/31/2024
COUNTS
SUF FACTOR 01/2024 02/2024 03/2024
AD 1396.66 499 510 509
AE 1396.66 478 498 489
AF 1396.66 77 78 77
TOTAL 1,054 1,086 1,075
LIABILITY
SUF 01/2024 02/2024 03/2024
AD 696,933 712,297 710,900
AE 667,603 695,537 682,967
AF 107,543 108,939 107,543
TOTAL 1472,079 1516,773 1501,410
REPORT DATE 03/01/2024
*******AGGREGATE STOP LOSS REPORT*******
THIS REPORT PROVIDES AN ESTIMATE OF THE ASL LIABILITY BASED ON THE MOST RECENT INFORMATION AVAILABLE AT THE BEGINNING OF EACH MONTH FINAL LIABILITY WILL BE DETERMINED AFTER THE CLOSE OF THE POLICY YEAR BASED UPON THE TERMS OF THE POLICY.
UNITEDHEALTHCARE
GROUP NAME COUNTY OF HAYS
CUSTOMER ID 00000912772 ELIG INDICATOR SUBSCRIBERS
CONTRACT NUMBER 00912772 FUND TYPE ASO
TRIG FREQ ROLLOVER BANK ACCOUNT # 3850159075
MANUAL REIMBURSEMENT N COVERED SUFFIXES AD AE AF
ASL BEGIN DATE 01/01/2024
ASL END DATE 12/31/2024
AGGREGATE RETROACTIVITY AGGREGATE CLAIMS CLAIMS CLAIMS CLAIMS PERCENT INSURANCE
LIABILITY (UP TO THREE LIABILITY EXPENSE EXPENSE CHARGED CHARGED AGGREGATE COMPANY
MONTH MONTHLY MONTHS PRIOR) YTD MONTHLY YTD MONTHLY YTD LIABILITY LIABILITY
JAN-24 1,472,079.64 0.00 1,472,079.64 1,286,244.32 1,286,244.32 1,286,244.32 1,286,244.32 87.37% 0.00 FEB-24 1,516,772.76 44,693.12 3,033,545.52 1,109,435.19 2,395,679.51 1,109,435.19 2,395,679.51 78.97% 0.00 MAR-24 1,501,409.50 27,933.20- 4,507,021.82 994,437.27 3,390,116.78 994,437.27 3,390,116.78 75.21% 0.00_____________ _____________
4,490,261.90 16,759.92
File details come from the government source that posted it. Updated .