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
This file is an Excel spreadsheet tracking various benefit contracts for the State of Nebraska, showing contract timelines and renewal periods from 2018 to 2030. The contracts tracked include Hartford Life Insurance Plans (contract #5953 Z1), UHC Long and Short Term Disability (contract #5956 Z1), ASI Flex Flexible Spending (contract #6171 Z1), Deer Oaks EAP Services (contract #6395 Z1), Segal Consulting (contract #5297 Z1), UHC Health and Pharmacy (contract #6201 Z1), Ameritas Life Insurance Corp. Dental Insurance (contract #6591 Z1), EyeMed Vision Insurance (contract #6729 Z1), and Gallagher Benefit Services VEBA (Agency #96326 O4).
The spreadsheet displays contract periods using color-coding to distinguish between initial contract periods and various optional renewal phases. Most contracts include an initial period followed by multiple optional renewal periods, typically ranging from 2-4 renewal options. For example, the UHC Health and Pharmacy contract includes an initial period plus four optional renewals, while the Hartford Life Insurance Plans contract shows an initial period with two optional renewals. The Gallagher Benefit Services VEBA contract notably includes a one-time extension deviation within its timeline structure.
View the file
Other files
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 Z1 | 84955 O4 | Hartford | Life Insurance Plans | Initial Period | Optional Renewal 1 | Optional Renewal 2 | |||||||||||||
| 5956 Z1 | 84958 O4 | UHC | Long and Short Term Disability | Initial Period | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | ||||||||||||
| 6171 Z1 | 89260 O4 | ASI Flex | Flexible Spending | Initial Period | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | Optional Renewal 4 | |||||||||||
| 6395 Z1 | 93348 O4 | Deer Oaks | EAP Services | Initial Period | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | ||||||||||||
| 5297 Z1 | 73507 O4 | Segal | Consulting | Initial | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | Optional Renewal 4 | One Time Extension | ||||||||||
| 6201 Z1 | 89546 O4 | UHC | Health and Pharmacy | Initial Period | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | Optional Renewal 4 | |||||||||||
| 6591 Z1 | 98224 O4 | Ameritas Life Insurance Corp. | Dental Insurance | Initial Period | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | ||||||||||||
| 6729 Z1 | 103238 O4 | EyeMed | Vision Insurance | Initial Period | Optional Renewal 1 | Optional Renewal 2 | Optional Renewal 3 | ||||||||||||
| Agency | 96326 O4 | Gallagher Benefit Services | VEBA (Agency Owned Contract) | Initial Period | One 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 .