Attachment N Historical LTD and STD Premium Payments.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
State of Nebraska Short-Term Disability (STD) and Long-Term Disability (LTD) Insurance
Solicitation number
120084 O5
Issued by
Lancaster County, Nebraska

About this file

The file "Attachment N Historical LTD and STD Premium Payments.xlsx" is a detailed historical premium payment record for Short-Term Disability (STD) and Long-Term Disability (LTD) insurance for the State of Nebraska. The document covers premium payments for five consecutive plan years from 2019/20 to 2023/24, tracking monthly premium contributions for approximately 17,221 state employees working 20+ hours per week. The State of Nebraska, through its Department of Administrative Services (DAS) and State Purchasing Bureau (SPB), is seeking a fully insured disability insurance program with STD offering first-day accident and eighth-day illness coverage at 60% income replacement for up to six months, and LTD providing a six-month elimination period with 60% income replacement. The procurement timeline includes questions due by November 27, 2024, proposal submissions due December 19, 2024, an Intent to Award posting on January 8, 2025, and contract award on February 10, 2025, with an initial contract term from July 1, 2025, through June 30, 2027, and three optional one-year renewal periods.

The current program is 100% voluntary, with employees paying full premiums through post-tax deductions, and existing enrollment shows 3,100 employees in STD and 5,763 in LTD coverage. Monthly premiums are approximately $172,798.51 for STD coverage and $87,366.51 for LTD coverage, suggesting an annual contract value around $3.1 million. The historical data demonstrates significant program growth, with STD premiums increasing from $1.15 million in 2019/20 to $1.95 million in 2023/24, and LTD premiums rising from $822,725 to $1 million during the same period. UnitedHealthcare is the incumbent vendor since July 1, 2019, and another vendor, MetLife, has also submitted a response. The procurement does not appear to have specific set-aside designations or restrictions limiting respondent types, and vendors must maintain comprehensive insurance coverage including workers' compensation, commercial general liability, automobile liability, professional liability, and cyber liability, with a true open enrollment and no Evidence of Insurability requirement for current enrollees.

View the file

Other files

File Type Posted
120084 O5 SOLICITATION ADDENDUM ONE final.docx DOCX document
Attachment I - STD Payment Details.xlsx XLSX spreadsheet
120084 O5- Addendum Two- Revised Schedule of Events.pdf PDF
120084 O5 RFP STD LTD Insurance.docx DOCX document
Attachment P Claim details for SAE from 07.01.2019.pdf PDF
Attachment A Requirements Matrix.docx DOCX document
Attachment C Current Short Term Disability Benefits.pdf PDF
UnitedHealthCare BAFO cost.pdf PDF
120084 O5 Cost Proposal.xlsx XLSX spreadsheet
BAFO 120084 O5 FinalEvaluationDocument.pdf PDF
Attachment F - LTD Group Paid by month.pdf PDF
Attachment J - LTD Claims Status.pdf PDF
List of Respondents.pdf PDF
Attachment G- STD Group Paid by month.pdf PDF
120084 O5 RFP STD LTD Insurance.pdf PDF
Attachment K - STD Claims Status.pdf PDF
UnitedHealthCare (stacked).pdf PDF
120084 O5- Addendum Three - Revised Schedule of Events.pdf PDF
Metlife Response (stacked).pdf PDF
Addendum 4 - Revised Schedule of Events.pdf PDF
120084 O5 Intent to Award.pdf PDF
Attachment O October 2024 STD LTD Monthly Invoice.pdf PDF
Attachment E - STD open and closed paid claim summary.pdf PDF
120084 O5 SolicitationEvaluationCriteria.pdf PDF
Metlife Response BAFO cost.pdf PDF
Attachment D - LTD open and closed paid claim summary.pdf PDF
120084 O5 BAFO Cost Proposal.xlsx XLSX spreadsheet
Attachment H - LTD Payment Details.xlsx XLSX spreadsheet
Attachment M EligibilityCensus.xlsx XLSX spreadsheet
Attachment L Census LTD STD.xlsx XLSX spreadsheet
Attachment B Current Long Term Disability Benefits.pdf PDF
120084 O5 RFP STD LTD Insurance.docx DOCX document
Attachment L Census LTD STD.xlsx XLSX spreadsheet
Attachment G- STD Group Paid by month.pdf PDF
120084 O5 SOLICITATION ADDENDUM ONE final.docx DOCX document
Attachment B Current Long Term Disability Benefits.pdf PDF
Attachment I - STD Payment Details.xlsx XLSX spreadsheet
120084 O5 Cost Proposal.xlsx XLSX spreadsheet
Attachment O October 2024 STD LTD Monthly Invoice.pdf PDF
Attachment J - LTD Claims Status.pdf PDF
Metlife Response (stacked).pdf PDF
Attachment H - LTD Payment Details.xlsx XLSX spreadsheet
Attachment K - STD Claims Status.pdf PDF
Metlife Response BAFO cost.pdf PDF
120084 O5 Intent to Award.pdf PDF
Attachment E - STD open and closed paid claim summary.pdf PDF
120084 O5- Addendum Three - Revised Schedule of Events.pdf PDF
Attachment D - LTD open and closed paid claim summary.pdf PDF
Attachment C Current Short Term Disability Benefits.pdf PDF
Attachment M EligibilityCensus.xlsx XLSX spreadsheet
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

LTD Premium Payments

HISTORICAL LTD PREMIUM PAYMENTS
LTD Premium Payments for 5 Plan Years
Plan Year 19/206 Month Elimination
July 2019$67,061.35
August 2019$68,375.09
September 2019$68,141.37
October 2019$68,216.02
November 2019$68,386.53
December 2019$68,818.90
January 2020$68,893.88
February 2020$69,808.90
March 2020$68,603.19
April 2020$68,534.26
May 2020$68,949.87
June 2020$68,935.65
Plan Year Totals$822,725.01
Plan Year 20/216 Month Elimination
July 2020$70,327.55
August 2020$70,514.70
September 2020$70,521.99
October 2020$70,640.78
November 2020$70,476.37
December 2020$70,587.29
January 2021$70,068.06
February 2021$69,722.15
March 2021$69,906.84
April 2021$69,729.80
May 2021$69,785.32
June 2021$69,077.60
Plan Year Totals$841,358.45
Plan Year 21/226 Month Elimination
July 2021$70,525.81
August 2021$70,347.75
September 2021$70,081.39
October 2021$69,905.67
November 2021$69,906.64
December 2021$72,304.07
January 2022$72,984.69
February 2022$73,215.86
March 2022$73,508.94
April 2022$74,009.20
May 2022$74,174.64
June 2022$74,092.85
Plan Year Totals$865,057.51
Plan Year 22/236 Month Elimination
July 2022$76,526.99
August 2022$76,914.96
September 2022$76,798.98
October 2022$76,874.36
November 2022$77,069.78
December 2022$77,407.62
January 2023$76,869.88
February 2023$76,698.87
March 2023$77,104.51
April 2023$76,946.55
May 2023$77,022.90
June 2023$76,776.93
Plan Year Totals$923,012.33
Plan Year 23/246 Month Elimination
July 2023$83,161.99
August 2023$84,207.68
September 2023$84,242.92
October 2023$84,115.21
November 2023$84,723.10
December 2023$84,599.02
January 2024$84,026.58
February 2024$83,517.41
March 2024$83,818.70
April 2024$83,768.83
May 2024$83,309.92
June 2024$82,891.96
Plan Year Totals$1,006,383.32

STD Premium Payments

HISTORICAL STD PREMIUM PAYMENTS
STD Premium Payments for 5 Plan Years
Plan Year 19/201st day injury, 8th day sickness
July 2019$87,337.06
August 2019$89,532.35
September 2019$90,856.90
October 2019$91,843.99
November 2019$93,294.36
December 2019$95,594.13
January 2020$96,199.74
February 2020$99,745.98
March 2020$99,855.36
April 2020$100,650.99
May 2020$104,448.21
June 2020$103,514.92
Plan Year Totals$1,152,873.99
Plan Year 20/211st day injury, 8th day sickness
July 2020$102,141.03
August 2020$103,375.18
September 2020$104,433.03
October 2020$106,429.89
November 2020$106,176.09
December 2020$106,154.35
January 2021$107,175.31
February 2021$107,289.11
March 2021$107,933.23
April 2021$107,939.67
May 2021$107,765.83
June 2021$107,061.75
Plan Year Totals$1,273,874.47
Plan Year 21/221st day injury, 8th day sickness
July 2021$111,117.32
August 2021$110,320.65
September 2021$110,105.80
October 2021$109,730.64
November 2021$109,806.15
December 2021$116,562.53
January 2022$122,474.20
February 2022$124,432.94
March 2022$126,730.80
April 2022$130,588.49
May 2022$132,509.71
June 2022$134,986.67
Plan Year Totals$1,439,365.90
Plan Year 22/231st day injury, 8th day sickness
July 2022$132,855.98
August 2022$135,513.97
September 2022$136,895.47
October 2022$137,925.12
November 2022$138,967.23
December 2022$141,032.35
January 2023$141,739.26
February 2023$142,804.27
March 2023$144,870.09
April 2023$145,407.66
May 2023$147,620.61
June 2023$148,532.22
Plan Year Totals$1,694,164.23
Plan Year 23/241st day injury, 8th day sickness
July 2023$157,319.83
August 2023$159,511.01
September 2023$159,382.64
October 2023$161,282.30
November 2023$163,408.54
December 2023$163,678.82
January 2024$162,982.99
February 2024$163,445.25
March 2024$163,039.99
April 2024$164,895.61
May 2024$164,290.01
June 2024$164,103.30
Plan Year Totals$1,947,340.29

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