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

This document is a cost reply attachment (AttD.Cost-Reply.xlsx) for the Florida Department of Management Services' Invitation to Negotiate (ITN) for Group Term Life Insurance, covering a contract period from 2025 to 2028 with potential renewal terms through 2031. The solicitation seeks a single vendor to provide comprehensive life insurance coverage for various employee groups, including active full-time and OPS employees, vested legislators, retired employees, spouses, and dependent children. The contract anticipates an implementation date of January 1, 2026, with an initial four-year term and up to four additional one-year renewal options.

The cost reply document details multiple coverage tiers with specific benefit amounts and enrollment estimates, including basic group term life insurance ($25,000 for active employees), vested legislator coverage ($150,000), retired employee options ($2,500 or $10,000), spouse coverage ($15,000 or $20,000), and dependent child coverage ($10,000). The Optional Group Term Life Insurance section allows coverage from 1-7 times annual earnings up to $1 million, with premium rates stratified by age groups. The document provides a structured format for respondents to quote rates for initial and renewal terms, with an additional tab (D8) allowing vendors to propose supplementary services and benefits on a per-member-per-month basis.

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
AttF.Census-File.xlsx XLSX spreadsheet
AttH.PUR-7801.Vendor-Certification-Form.docx DOCX document
AttE.Interface-Files-Layouts-and-Enrollment-Schedule.pdf PDF
AttG.Additional-Information.pdf PDF
AttI.Draft-Contract.pdf PDF
AttI.Draft-Contract.pdf PDF
AttI.Draft-Contract.pdf PDF
AttC.Technical-Reply.xlsx XLSX spreadsheet
ITN-GTL-Final.pdf PDF
Revised-Att.G-Additional-Information.pdf PDF
Addendum No. 2.pdf PDF
AttC.Technical-Reply.xlsx XLSX spreadsheet
AttD.Cost-Reply.xlsx XLSX spreadsheet
AttH.PUR-7801.Vendor-Certification-Form.docx DOCX document
Addendum No. 1.pdf PDF
Addendum No. 3.pdf PDF
Revised-Attachment-D.Revised-Cost-Reply.xlsx XLSX spreadsheet
AttC.Technical-Reply.xlsx XLSX spreadsheet
AttI.Draft-Contract.pdf PDF
ITN-GTL-Final.pdf PDF
AttB.Performance-Guarantees.pdf PDF
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
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 .