AttD.Cost-Reply.xlsx

XLSX spreadsheet 113 KB Posted

Attached to
DMS-2425-232 (Group Term Life Insurance)
Solicitation number
ITN-11871
Issued by
Leon County, Florida

About this file

The document is a Cost Reply Excel file (AttD.Cost-Reply.xlsx) for the State of Florida's Department of Management Services (DMS), Division of State Group Insurance (DSGI), related to Invitation to Negotiate (ITN) No. DMS-24/25-232 for Group Term Life Insurance. The solicitation seeks a vendor to provide comprehensive life insurance coverage for approximately 345,037 members, including active full-time and OPS employees, vested legislators, retired employees, and their dependents. The contract has an anticipated implementation date of January 1, 2026, with an initial four-year term and potential for up to four additional one-year renewals. The cost reply document requires detailed premium rates per $1,000 per month for six different coverage types, including basic life insurance, spouse coverage, dependent child coverage, and optional group term life insurance.

The pricing structure is broken down by various employee and dependent categories, with estimated annual enrollments ranging from 138 vested legislators to 153,145 active employees. Coverage options include basic life insurance of $25,000 for active employees, $150,000 for vested legislators, and optional term life insurance ranging from 1 to 7 times annual earnings (up to $1 million). The cost reply tabs provide rate sheets for initial four-year terms and renewal terms, with rates to be specified to the third decimal place. An optional supplemental benefits section allows vendors to propose additional services with per-member-per-month (PMPM) rates. The solicitation requires a performance bond of $5,000,000 and mandates integration with the state's existing People First system for data transmission and enrollment management.

View the file

Other files

File Type Posted
AttA.Administrative-Requirements.pdf PDF
AttD.Cost-Reply.xlsx XLSX spreadsheet
AttG.Additional-Information.pdf PDF
AttA.Administrative-Requirements.pdf PDF
AttC.Technical-Reply.xlsx XLSX spreadsheet
ITN-GTL-Final.pdf PDF
AttD.Cost-Reply.xlsx XLSX spreadsheet
Addendum No. 2.pdf PDF
AttC.Technical-Reply.xlsx XLSX spreadsheet
AttD.Cost-Reply.xlsx XLSX spreadsheet
Revised-Att.G-Additional-Information.pdf PDF
Addendum No. 1.pdf PDF
AttB.Performance-Guarantees.pdf PDF
Revised Attachment A - Administrative Requirements.pdf PDF
AttE.Interface-Files-Layouts-and-Enrollment-Schedule.pdf PDF
ITN-GTL-Final.pdf PDF
Addendum No. 2.pdf PDF
Revised Attachment A - Administrative Requirements.pdf PDF
AttB.Performance-Guarantees.pdf PDF
AttE.Interface-Files-Layouts-and-Enrollment-Schedule.pdf PDF
Addendum No. 1.pdf PDF
AttB.Performance-Guarantees.pdf PDF
AttE.Interface-Files-Layouts-and-Enrollment-Schedule.pdf PDF
AttH.PUR-7801.Vendor-Certification-Form.docx DOCX document
ITN-GTL-Final.pdf PDF
Revised Attachment A - Administrative Requirements.pdf PDF
AttB.Performance-Guarantees.pdf PDF
AttE.Interface-Files-Layouts-and-Enrollment-Schedule.pdf PDF
AttE.Interface-Files-Layouts-and-Enrollment-Schedule.pdf PDF
AttH.PUR-7801.Vendor-Certification-Form.docx DOCX document
AttB.Performance-Guarantees.pdf PDF
Revised Attachment A - Administrative Requirements.pdf PDF
AttI.Draft-Contract.pdf PDF
AttC.Technical-Reply.xlsx XLSX spreadsheet
AttI.Draft-Contract.pdf PDF
ITN-GTL-Final.pdf PDF
AttB.Performance-Guarantees.pdf PDF
AttD.Cost-Reply.xlsx XLSX spreadsheet
AttF.Census-File.xlsx XLSX spreadsheet
AttH.PUR-7801.Vendor-Certification-Form.docx DOCX document
AttC.Technical-Reply.xlsx XLSX spreadsheet
Revised-Att.G-Additional-Information.pdf PDF
Addendum No. 1.pdf PDF
ITN-GTL-Final.pdf PDF
Revised Attachment A - Administrative Requirements.pdf PDF
AttI.Draft-Contract.pdf PDF
AttI.Draft-Contract.pdf PDF
AttB.Performance-Guarantees.pdf PDF
AttC.Technical-Reply.xlsx XLSX spreadsheet
AttH.PUR-7801.Vendor-Certification-Form.docx DOCX document
Show 40 more

50 files 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

D1 General Instructions

Instructions
Provide a rate in each yellow shaded cell in Tabs 2 through 7 for the initial and renewal terms. The Respondent's rates shall be to the third decimal place. The initial term rates are for years one (1) through four (4) and shall be the same rate for each initial term year. The renewal rates are for years five (5) through eight (8), and may be a different rate for each renewal term year. Tab D8 is an optional section where the Respondent can offer supplementary services and their corresponding rates provided by your company.

&G &"-,Bold"Attachment D - Cost Reply

D1: GENERAL INSTRUCTIONS

DMS-24/25-232

Group Term Life Insurance &P of &N

D2 Eligible Employees

Respondent's Legal Name
Primary Contact
Financial Reply Contact (if different)
Financial Reply Contact email

Basic Group Term Life Insurance Coverage for Eligible Employees

Life Insurance Benefit$ 25,000.00
Equal to life insurance benefit
EligibilityActive Full-Time and OPS EmployeesRate per $1,000 per Month
Estimated Annual Enrollment1153,145YearsPremium Rate
Initial 41 to 4
Year Term
Renewal5
Terms6
7
8
1Enrollment as of January 2024.

&G &"-,Bold"Attachment D - Cost Reply

D2: BASIC GROUP TERM INSURANCE COVERAGE FOR ELIGIBLE EMPLOYEES

Group Term Life Insurance &P of &N

D3 Vested Legislator Basic Term Life Insurance Coverage for Vested Legislators

Life Insurance Benefit$ 150,000.00Rate per $1,000 per Month
Equal to life insurance benefit
EligibilityVested LegislatorsYearsPremium Rate
Estimated Annual Enrollment1138Initial 41 to 4
Year Term
5
Renewal6
Terms7
8
1Enrollment as of January 2024.

tc={BDFAE6A9-A2CE-4045-ADA8-6866568A20E0}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

[Tasks]

There is a task anchored to this comment that cannot be viewed in your client.

Comment:

@Seale, Zoe Should this be 2024?

Reply:

@Guerra, Christina I updated it to January 2024. There were not changes in the enrollment numbers though.

&G &"-,Bold"Attachment D - Cost Reply

D3: BASIC TERM LIFE INSURANCE COVERAGE FOR VESTED LEGISLATORS

Group Term Life Insurance &P of &N

D4 Retired Employees

Basic Term Life Insurance Coverage for Retired Employees
BenefitOptions of $2,500 or $10,000

Eligibility Retired Employees (must stay continuously covered)

Estimated Annual Enrollment1 12,334 Estimated Annual Enrollment1 16,397

$2,500 Coverage$10,000 Coverage
Rate Per $1,000 MonthRate Per $1,000 Month
YearPreium RateYearPremium Rate
Initial 4Initial 4
Year Term1 to 4Year Term1 to 4
55
Renewal6Renewal6
Terms7Terms7
88
1Enrollment as of January 2024.

&G &"-,Bold"Attachment D - Cost Reply

D4: BASIC TERM LIFE INSURANCE COVERAGE FOR RETIRED EMPLOYEES

Group Term Life Insurance &P of &N

D5 Spouses Spouse Term Life Insurance Coverage

Benefit Options of $15,000 or $20,000

Eligibility Spouses of Eligible Employees and Vested Legislators

Estimated Annual Enrollment1 2,838 Estimated Annual Enrollment1 11,090

$15,000 Coverage$20,000 Coverage
Rate Per $1,000 MonthRate Per $1,000 Month
YearPreium RateYearPremium Rate
Initial 4Initial 4
Year Term1 to 4Year Term1 to 4
55
Renewal6Renewal6
Terms7Terms7
88
1Enrollment as of January 2024.

&G &"-,Bold"Attachment D - Cost Reply

D5: SPOUSE TERM LIFE INSURANCE COVERAGE

Group Term Life Insurance &P of &N

D6 Dependent Child Dependent Child Term Life Insurance Coverage

Benefit$10,000Rate Per $1,000 Month (covers all children in a family)
EligibilityDependent Children of Eligible
Employees and Vested LegislatorsYearPremium Rate
Estimated Annual Enrollment124,441Initial 4
Year Term1 to 4
5
Renewal6
Terms7
8
1Enrollment as of January 2024.

&G &"-,Bold"Attachment D - Cost Reply

D6: DEPENDENT CHILD TERM LIFE INSURANCE COVERAGE

Group Term Life Insurance &P of &N

D7 Optional Group Term Life

Optional Term Life Insurance Coverage for Active Employees
Multiple of 1 to 7 times annual earnings up to $1 million maximum
Life Insurance Benefit:Equal to life insurance benefit

Eligibility: Active Full-Time, Part-Time Employees

Estimated Annual Enrollment: 39,222

Initial Term - Years 1 to 4Premium Rate
Rate per $1,000
Active EmployeesEstimated
Enrollment1
< 302,033
30 - 342,841
35 - 394,243
40 - 445,447
45 - 495,835
50 - 546,649
55 - 595,896
60 - 644,088
65 - 691,501
≥70462
Renewal Term - Year 5Premium Rate
Rate per $1,000
Active EmployeesEstimated
Enrollment1
< 302,033
30 - 342,841
35 - 394,243
40 - 445,447
45 - 495,835
50 - 546,649
55 - 595,896
60 - 644,088
65 - 691,501
≥70462
Renewal Term - Year 6Premium Rate
Rate per $1,000
Active EmployeesEstimated
Enrollment1
< 302,033
30 - 342,841
35 - 394,243
40 - 445,447
45 - 495,835
50 - 546,649
55 - 595,896
60 - 644,088
65 - 691,501
≥70462
Renewal Term - Year 7Premium Rate
Rate per $1,000
Active EmployeesEstimated
Enrollment1
< 302,033
30 - 342,841
35 - 394,243
40 - 445,447
45 - 495,835
50 - 546,649
55 - 595,896
60 - 644,088
65 - 691,501
≥70462
Renewal Term - Year 8Premium Rate
Rate per $1,000
Active EmployeesEstimated
Enrollment1
< 302,033
30 - 342,841
35 - 394,243
40 - 445,447
45 - 495,835
50 - 546,649
55 - 595,896
60 - 644,088
65 - 691,501
≥70462
1Enrollment as of January 2024.

&G &"-,Bold"Attachment D - Cost Reply

D7: OPTIONAL GROUP TERM LIFE

Group Term Life Insurance &P of &N

D8 Supplementals

■ This tab provides an opportunity for the Respondent to propose information about supplementary benefits and services for consideration by the State of Florida.
■ Fees must be provided for an initial four year contract (entirety of 2025 - 2028) plus up to four optional one year renewals (occurring in 2029, 2030 and 2031).

Instructions: Please specify the supplemental benefits and services in the Description of Service/Benefit field. Include rates in terms of Per Member Per Month (PMPM) and, if applicable, provide the annual rate.

Description of Benefit Premium Rate Initial Term (1 to 4) Premium Rate Renewal Term 5 Premium Rate Renewal Term 6 Premium Rate Renewal Term 7 Premium Rate Renewal Term 8 Annual Rate

&G &"-,Bold"Attachment D - Cost Reply

D8: SUPPLEMENTAL BENEFITS AND SERVICES (OPTIONAL)

Group Term Life Insurance &P of &N image1.png

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