Attachment C Benefit Contracts.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
Consulting and Actuarial Services
Solicitation number
120005 O5
Issued by
Lancaster County, Nebraska

About this file

The file "Attachment C Benefit Contracts.xlsx" pertains to the State of Nebraska's Department of Administrative Services (DAS) State Purchasing Bureau and its employee benefits contract portfolio. The document covers Request for Proposal (RFP) Number 120005 O5 for Consulting and Actuarial Services, seeking a vendor to support five self-insured health plans covering approximately 13,300 eligible public servants and their dependents. The RFP requires comprehensive services including actuarial analysis, data analytics, premium equivalent calculations, IBNR calculations, wellness program reporting, budget reporting, RFP assistance, and ACA compliance tracking. Electronic responses were due January 6, 2025, at 2:00 PM Central Time, with a contract award expected February 20, 2025, and services commencing March 1, 2025. The initial contract term is two years with three optional one-year renewal periods.

The solicitation involves an annual health fund investment exceeding $167.2 million, covering approximately 27,580 total lives. Pricing must remain fixed for the first two years, with subsequent increases limited to 4% per period. Current incumbent vendors include United Healthcare (health and pharmacy benefits), Hartford (life insurance), ASI Flex (flexible spending), Deer Oaks (EAP services), and Gallagher Benefit Services (VEBA administration). Vendors must maintain specific insurance coverage, including $2 million general liability aggregate, $5 million umbrella/excess liability, and $5 million cyber liability. The evaluation will be based on Corporate Overview (25 points), Technical Approach (55 points), Cost Proposal (20 points), with a potential additional 20 points for an optional oral interview. A Business Associate Agreement (BAA) is mandatory to ensure HIPAA compliance, and no specific set-aside designations for disadvantaged enterprises are included in this solicitation.

View the file

Other files

File Type Posted
120005 O5 F31_SolicitationEvaluationCriteria Final.docx DOCX document
120005 O5 Intent to Award.pdf PDF
Attachment B Health Plan Annual Report.pdf PDF
120005 O5 SOLICITATION ADDENDUM ONE Final.pdf PDF
120005 O5 SOLICITATION LIST OF RESPONDENTS.docx DOCX document
120005 O5 Consulting and Actuarial Services RFP final.docx DOCX document
120005 O5 Segal stacked.pdf PDF
120005 O5 Cost Proposal Final.docx DOCX document
120005 O5 FinalEvaluationDocument.xlsx XLSX spreadsheet
Attachment A Requirements Matrix Final.docx DOCX document
120005 O5 Intent to Award.docx DOCX document
Attachment D BAA (v2) final.doc DOC document
120005 O5 FinalEvaluation.pdf PDF
120005 O5 Consulting and Actuarial Services RFP final.docx DOCX document
120005 O5 FinalEvaluation.pdf PDF
120005 O5 FinalEvaluationDocument.xlsx XLSX spreadsheet
Attachment D BAA (v2) final.doc DOC document
120005 O5 SOLICITATION LIST OF RESPONDENTS.docx DOCX document
Attachment B Health Plan Annual Report.pdf PDF
Attachment C Benefit Contracts.xlsx XLSX spreadsheet
120005 O5 SOLICITATION ADDENDUM ONE Final.pdf PDF
120005 O5 Segal stacked.pdf PDF
120005 O5 F31_SolicitationEvaluationCriteria Final.docx DOCX document
120005 O5 Intent to Award.docx DOCX document
120005 O5 Cost Proposal Final.docx DOCX document
120005 O5 Intent to Award.pdf PDF
Attachment A Requirements Matrix Final.docx DOCX document
120005 O5 Cost Proposal Final.docx DOCX document
Attachment D BAA (v2) final.doc DOC document
Attachment B Health Plan Annual Report.pdf PDF
120005 O5 F31_SolicitationEvaluationCriteria Final.docx DOCX document
120005 O5 SOLICITATION LIST OF RESPONDENTS.docx DOCX document
Attachment C Benefit Contracts.xlsx XLSX spreadsheet
120005 O5 SOLICITATION ADDENDUM ONE Final.pdf PDF
120005 O5 Consulting and Actuarial Services RFP final.docx DOCX document
Attachment A Requirements Matrix Final.docx DOCX document
Attachment C Benefit Contracts.xlsx XLSX spreadsheet
120005 O5 Cost Proposal Final.docx DOCX document
120005 O5 Consulting and Actuarial Services RFP final.docx DOCX document
Attachment D BAA (v2) final.doc DOC document
120005 O5 SOLICITATION ADDENDUM ONE Final.pdf PDF
Attachment A Requirements Matrix Final.docx DOCX document
Attachment B Health Plan Annual Report.pdf PDF
Attachment C Benefit Contracts.xlsx XLSX spreadsheet
Attachment B Health Plan Annual Report.pdf PDF
Attachment A Requirements Matrix Final.docx DOCX document
Attachment D BAA (v2) final.doc DOC document
120005 O5 Cost Proposal Final.docx DOCX document
120005 O5 Consulting and Actuarial Services RFP final.docx DOCX document
Show all 49

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

Sheet1 Contract # Contractor Description Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26 Jan-27 Feb-27 Mar-27 Apr-27 May-27 Jun-27 Jul-27 Aug-27 Sep-27 Oct-27 Nov-27 Dec-27 Jan-28 Feb-28 Mar-28 Apr-28 May-28 Jun-28 Jul-28 Aug-28 Sep-28 Oct-28 Nov-28 Dec-28 Jan-29 Feb-29 Mar-29 Apr-29 May-29 Jun-29 Jul-29 Aug-29 Sep-29 Oct-29 Nov-29 Dec-29 Jan-30 Feb-30 Mar-30

5953 Z184955 O4HartfordLife Insurance PlansInitial PeriodOptional Renewal 1Optional Renewal 2
5956 Z184958 O4UHCLong and Short Term DisabilityInitial PeriodOptional Renewal 1Optional Renewal 2Optional Renewal 3
6171 Z189260 O4ASI FlexFlexible SpendingInitial PeriodOptional Renewal 1Optional Renewal 2Optional Renewal 3Optional Renewal 4
6395 Z193348 O4Deer OaksEAP ServicesInitial PeriodOptional Renewal 1Optional Renewal 2Optional Renewal 3
5297 Z173507 O4SegalConsultingInitialOptional Renewal 1Optional Renewal 2Optional Renewal 3Optional Renewal 4One Time Extension
6201 Z189546 O4UHCHealth and PharmacyInitial PeriodOptional Renewal 1Optional Renewal 2Optional Renewal 3Optional Renewal 4
6591 Z198224 O4Ameritas Life Insurance Corp.Dental InsuranceInitial PeriodOptional Renewal 1Optional Renewal 2Optional Renewal 3
6729 Z1103238 O4EyeMedVision InsuranceInitial PeriodOptional Renewal 1Optional Renewal 2Optional Renewal 3
Agency96326 O4Gallagher Benefit ServicesVEBA (Agency Owned Contract)Initial PeriodOne Time Extension
deviation
Initial Period
Op Renewal 1
Op Renewal 2
Op Renewal 3
Op Renewal 4
One Time Extension

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