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 an Attachment D Cost Reply Excel spreadsheet for the Florida Department of Management Services (DMS) Division of State Group Insurance (DSGI) Group Term Life Insurance solicitation (ITN No. DMS-24/25-232). The solicitation seeks a group term life insurance provider for approximately 345,037 members, including active full-time and OPS employees, vested legislators, retired employees, and their dependents, with an anticipated implementation date of January 1, 2026. The contract duration is four years with potential for up to four additional one-year renewals, and the Reply submission deadline is April 14, 2025, with evaluation and negotiation phases scheduled from April 21 to July 21, 2025.

The cost reply document details six distinct life insurance coverage options with varied benefit levels: basic group term life insurance for active employees ($25,000), vested legislators ($150,000), retired employees ($2,500 or $10,000), spouse coverage ($15,000 or $20,000), dependent child coverage ($10,000), and optional group term life insurance ranging from 1-7 times annual earnings up to $1 million. Premium rates are requested per $1,000 per month, with separate rates for initial four-year terms and subsequent renewal terms, broken down by age groups and coverage types. The largest enrollment group is active employees at 153,145 participants, and the document provides a tab for supplemental benefits and services, allowing respondents to propose additional offerings with associated rates.

View the file

Other files

File Type Posted
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
AttD.Cost-Reply.xlsx XLSX spreadsheet
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
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
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
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
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 .