Attachment F - LTD Group Paid by month.pdf
PDF 257 KB Posted
- Solicitation number
- 120084 O5
- Issued by
- Lancaster County, Nebraska
About this file
Attachment F is a detailed experience summary report from UnitedHealthcare for the State of Nebraska's Long-Term Disability (LTD) insurance program, covering the period from July 1, 2019 to October 25, 2024. The document provides a monthly breakdown of premium/fees, paid claims, covered lives, and volume of coverage for the state's LTD insurance program. The report tracks monthly data points including total premiums, number of claims, number of covered lives, and total coverage volume, showing a consistent trend of growth in premium collection and coverage from July 2019 through projected October 2024.
The report reveals that the State of Nebraska's LTD program has experienced steady expansion, with monthly covered lives ranging from approximately 5,400 to 5,868 employees and monthly premiums increasing from around $68,000 in 2019 to over $87,000 by 2024. The total paid claims have varied monthly, with some months showing negative adjustments and others showing significant claim payouts, ranging from $0 to over $43,482. The total volume of coverage has grown from about $22.8 million in July 2019 to nearly $31.8 million projected for July 2024, indicating a substantial increase in the program's scale and financial protection for state employees over the contract period.
View the file
Other files
Show 40 more
Latest 50 of 146 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
Number of Claims
$24,681,422 04/2021 $69,560.93 $21,637.07 5,661 $24,655,035 03/2021 $69,335.48 $21,967.28 5,665
$24,672,824 02/2021 $70,046.42 $4,729.96 5,648 $24,586,039 01/2021 $70,548.96 $9,005.91 5,655
$24,483,778 12/2020 $70,469.08 $8,651.16 5,662 $24,657,781 11/2020 $70,648.07 $3,903.76 5,666
$24,448,912 10/2020 $72,101.04 $11,355.94 5,652 $24,620,818 09/2020 $70,500.48 $11,852.48 5,604
$24,246,667 08/2020 $70,327.55 $10,494.42 5,593 $24,390,760 07/2020 $69,282.33 $4,012.41 5,635
$24,340,598 06/2020 $68,949.87 $19,815.91 5,697 $24,354,152 05/2020 $68,243.59 $3,452.11 5,701
$24,008,387 04/2020 $68,603.19 $1,402.31 5,649 $24,041,888 03/2020 $69,883.86 $3,455.10 5,620
$23,961,470 02/2020 $69,326.25 $0.00 5,606 $24,550,644 01/2020 $68,989.41 $0.00 5,604
$23,618,461 12/2019 $68,461.18 $0.00 5,595 $23,844,260 11/2019 $68,060.73 $0.00 5,549
$23,381,023 10/2019 $69,376.68 $0.00 5,492 $23,481,746 09/2019 $68,375.09 $0.00 5,470
$22,891,363 08/2019 $134,122.71 $0.00 5,435 $23,342,742 07/2019 $0.00 $0.00 5,405
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
All Subgroups and Products by Paid Month Paid Month/Year Premium/Fees Paid Claims Covered Lives Volume of Coverage
Business Segment: LTD LTD
FACETSSource System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
Experience Summary by Group by Paid Month Selection Parameters Values on Report
Group/Customer: 306147 00306147 - STATE OF NEBRASKA
Subgroup/Policy: ALL 1002
Paid Date Range: 07/01/2019 to 10/25/2024 07/01/2019 to 10/01/2024
Run Date: 10/25/2024 3:57:57 PM OFCR-04C; v2.5 Page 1 of 8
Attachment F
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
Business Segment: LTD LTD
FACETSSource System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
Experience Summary by Group by Paid Month Selection Parameters Values on Report
Group/Customer: 306147 00306147 - STATE OF NEBRASKA
Subgroup/Policy: ALL 1002
Paid Date Range: 07/01/2019 to 10/25/2024 07/01/2019 to 10/01/2024
28$28,161,19305/2023 $77,352.19 $27,365.07 5,868
$28,018,556 04/2023 $76,933.50 $43,482.21 5,741 $28,020,594 03/2023 $76,161.13 $17,377.03 5,726
$27,691,109 02/2023 $77,207.72 $19,494.51 5,668 $27,747,139 01/2023 $77,603.04 ($17,537.20) 5,666
$27,581,035 12/2022 $77,145.16 ($2,357.16) 5,675 $27,751,339 11/2022 $77,146.35 $19,102.11 5,632
$27,298,389 10/2022 $76,799.38 $24,080.39 5,603 $27,388,438 09/2022 $79,349.10 $9,327.08 5,583
$26,959,112 08/2022 $76,445.20 ($6,689.16) 5,573 $27,231,054 07/2022 $74,258.29 ($16,123.43) 5,536
$26,614,993 06/2022 $74,674.90 $9,702.10 5,597 $26,788,078 05/2022 $74,302.28 $27,613.93 5,600
$26,030,036 04/2022 $73,740.51 $22,218.52 5,553 $26,421,839 03/2022 $73,896.77 $13,893.21 5,481
$25,616,630 02/2022 $75,382.45 $25,329.81 5,425 $25,794,222 01/2022 $72,305.04 $30,337.90 5,386
$24,185,239 12/2021 $69,730.92 $37,253.60 5,426 $25,082,248 11/2021 $69,639.61 $25,962.34 5,395
$24,229,378 10/2021 $69,903.61 $22,995.56 5,385 $24,173,599 09/2021 $71,795.96 $24,407.69 5,404
$24,329,238 08/2021 $69,818.09 $4,958.33 5,433 $24,279,497 07/2021 $69,133.76 $15,440.90 5,456
$24,646,928 06/2021 $69,608.28 $15,372.69 5,590 $24,435,731 05/2021 $69,914.49 $14,987.42 5,632
Run Date: 10/25/2024 3:57:57 PM
OFCR-04C; v2.5 Page 1 of 8
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
Business Segment: LTD LTD
FACETSSource System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
Experience Summary by Group by Paid Month Selection Parameters Values on Report
Group/Customer: 306147 00306147 - STATE OF NEBRASKA
Subgroup/Policy: ALL 1002
Paid Date Range: 07/01/2019 to 10/25/2024 07/01/2019 to 10/01/2024
1,126All subgroups and
$4,802,594.62 $1,058,860.23
$30,579,665 10/2024 $87,634.43 $0.00 0 $0 09/2024 $87,634.43 $28,638.82 5,806
$30,992,185 08/2024 $85,476.11 $35,422.16 5,772 $31,858,224 07/2024 $82,433.05 $34,306.66 5,722
$30,707,668 06/2024 $83,561.34 $25,210.27 5,806 $30,579,665 05/2024 $83,768.83 $26,475.46 5,809
$30,645,057 04/2024 $83,309.53 $39,131.99 5,816 $30,752,457 03/2024 $82,944.97 $22,473.63 5,802
$30,621,391 02/2024 $83,902.50 $35,303.13 5,789 $30,489,787 01/2024 $85,206.91 $40,094.48 5,779
$30,738,110 12/2023 $84,595.38 $19,084.84 5,800 $30,802,976 11/2023 $85,196.12 $80,556.18 5,796
$30,338,620 10/2023 $84,243.39 $33,957.93 5,741 $30,486,551 09/2023 $90,592.75 $27,751.89 5,700
$29,850,135 08/2023 $82,916.02 $19,221.74 5,710 $30,303,472 07/2023 $76,853.28 $23,850.58 5,671 06/2023 $76,864.94 $23,649.20 5,764 $28,087,757
Run Date: 10/25/2024 3:57:57 PM
OFCR-04C; v2.5 Page 1 of 8
Sheet1
File details come from the government source that posted it. Updated .