Attachment_B__Plan_Design_Worksheet.xlsx

XLSX spreadsheet 162 KB Posted

Attached to
Group Life & Disability and Supplemental Health Benefits
Solicitation number
RFP-1-26-12
Issued by
Brevard County, Florida

About this file

This is a Plan Design Worksheet for a Group Life & Disability and Supplemental Health Benefits contract opportunity issued by a Florida county. The County seeks to expand its current fully insured group benefits program, effective January 1, 2027, by contracting with a single carrier/administrator to provide group-sponsored Accident, Hospital Indemnity, and Critical Illness/Cancer coverage alongside its existing Group Term Life, Accidental Death & Dismemberment (AD&D), Short-Term Disability (STD), and Long-Term Disability (LTD) plans currently administered by Standard Insurance Company since January 1, 2019. The worksheet details comprehensive plan design specifications across six benefit categories: Life/AD&D with provisions for basic employer-paid coverage (1x annual earnings up to $200,000 with age-based reductions beginning at age 65), voluntary supplemental life coverage (up to $500,000), and retiree flat benefits of $5,000 or $10,000; STD with 60% income replacement up to $1,500 weekly with elimination periods of 14 or 90 days and maximum benefit durations of 24 or 13 weeks; LTD with 60% income replacement up to $5,000 monthly and benefit duration varying by age; Accident coverage providing 24-hour protection; Hospital Indemnity with perpetual guarantee issue and day-one pregnancy coverage; and Critical Illness/Cancer with multiple covered conditions. Proposers must submit completed worksheets in Excel format and may offer up to two plan options for Accident, Hospital Indemnity, and Critical Illness/Cancer lines, with the County reserving selection rights.

Key provisions indicate all disability coverages are 100% employee-paid, participation is limited to active full-time employees working 30 or more hours weekly with specified departmental exclusions, and all plans feature perpetual guarantee issue with no pre-existing condition limitations for supplemental products. Eligibility includes eligible dependents (spouse and unmarried children through age 26), with effectiveness occurring on the first or second month following hire date based on employment commencement timing. Tobacco rating applies to Life/AD&D and Critical Illness/Cancer products. Salary and age band changes are effective January 1st annually, and Life/AD&D benefits include provisions for waiver of premium, portability, conversion rights, and accelerated death benefits. The worksheet also includes an optional Permanent Life with Long-Term Care or Chronic Condition rider section requiring proposers to specify policy type, guaranteed issue minimums of $150,000, and rider specifications including care triggers, benefit payout structures, and compliance documentation. Proposers must provide monthly rate illustrations for a $50,000 benefit with applicable guaranteed cash values or paid-up benefits.

View the file

Other files

File Type Posted
RFQ_Selection_Committee_Consolidated_Evaluation_Scoresheet.pdf PDF
Public_Meeting_Notice.pdf PDF
RFP_Tabulation__Names_Only.pdf PDF
Addendum_2.pdf PDF
Exhibit_C___Incurred__Paid_Updated_w_BL_Breakout.xlsx XLSX spreadsheet
Exhibit_C__Offset_Report.xlsx XLSX spreadsheet
Exhibit_A__Census.xlsx XLSX spreadsheet
Exhibit_C__Offset_Key.pdf PDF
Addendum_1.pdf PDF
Exhibit_C_Claimrun_Updated.xlsx XLSX spreadsheet
Exhibit_C__Incurred__Paid_Updated.pdf PDF
Exhibit_C__Brevard_Life__DI_SelfBill_2.1.26.xlsx XLSX spreadsheet
Exhibit_B__Allstate__Brevard_Fire_department.pdf PDF
Attachment_E__Draft_Contract.pdf PDF
Exhibit_C__641728_BREVARD_COUNTY_BOARD__Claimrun.pdf PDF
Attachment_C__Premium_Worksheet.xlsx XLSX spreadsheet
Exhibit_A__Census.pdf PDF
Exhibit_B__The_Standard_Life_Plan_Cert_Retirees.pdf PDF
Exhibit_B_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_B_Aflac__Brevard_2025.pdf PDF
Exhibit_B__Colonial_Life__Brevard_2025.pdf PDF
Attachment_A__Mandatory_Requirements__Proposal_Worksheet_revised_6.4.26.docx DOCX document
Exhibit_B__The_Standard_LTD_Cert.pdf PDF
Exhibit_B_Spouse_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_C_Incurred_vs._Paid_Exhibit.pdf PDF
Exhibit_B__The_Standard_STD_Cert.pdf PDF
Exhibit_B__The_Standard_Life_and_ADD_Cert_Active_EEs.pdf PDF
Attachment_D_Certification_of_Financial_Condition.pdf PDF
INV__SPECIFICATIONS.pdf PDF
Exhibit_C__Claim_Run_Reference_Sheet.pdf PDF
Show all 30

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

Life-AD&D

Attachment B - Plan Design Worksheet
Life/AD&D Plan Design
Instructions:
1. Complete the highlighted cells for each line of coverage. For additional plan provisions, please see Exhibit B - Certificates of Coverage.
2. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal.
ItemCurrent ProvisionProposed ProvisionMeets/Exceeds? (Y/N)List Deviations
Eligibility & Enrollment
Participation requirementsWaive
Eligibility RulesActive FT 30+ Hours Per Week

Cannot be insured as both an employee and dependent

Retirees can receive a flat $5,000 or $10,000 life without AD&D benefit if they elect at time of retirement Waiting period / Termination rules DOH on 1st-15th day of the month: Effective 1st of the following month

DOH on 16th - 31st day of the month: Effective 1st day of the 2nd month

Last day of employment is last day of coverage

Dependent eligibility definitions (spouse/child)Legal spouse and unmarried children through age 26; cannot be full-time members of the armed forces
Basic Life & AD&D (Employer Paid)
Schedule of Benefits (Employees)1x annual earnings up to $200,000, rounded to the next higher $1,000
AD&D bundlingYes; matches life amount
Schedule of Benefits (Retirees)Flat $5,000 or $10,000 life benefit without AD&D or age reduction
Age reductions (if any) and timingReduce by 8% at age 65

Reduce by 16% at age 66 Reduce by 24% at age 67 Reduce by 32% at age 68 Reduce by 40% at age 69 Reduce by 50% at age 70 or older

Age reductions take effect January 1

Accelerated Death BenefitUp to 75% of benefit to $500,000 combined basic and voluntary life amount for those with 12 months life expectancy
Repatriation BenefitNot to exceed $5,000 or 10% benefit, whichever is less
Disability waiver of premiumIncluded
Portability / ConversionBoth included
Voluntary (Additional) Life & AD&D
Participation RequirementsN/A
Employee Voluntary Life/AD&D Benefit Maximum & Increments$500,000 (5x annual earnings limit) in $10,000 increments
AD&D bundlingYes; matches life amount
Age reductions (if any) and timingReduce by 8% at age 65

Reduce by 16% at age 66 Reduce by 24% at age 67 Reduce by 32% at age 68 Reduce by 40% at age 69 Reduce by 50% at age 70 or older

Age reductions take effect January 1

Employee Guarantee Issue Amount3x annual earnings up to $350,000
Spouse Voluntary Life/AD&D Benefit Maximum & Increments$250,000 (not to exceed 50% of employee election) in $5,000 increments
Spouse Guarantee Issue Amount$30,000
Spouse Life/AD&D age band based on Employee or Spouse AgeEmployee age
Spouse Life/AD&D age reductions based on Employee or Spouse AgeEmployee age
Child Voluntary Life Amount$10,000 (not to exceed 50% of employee election) in $1,000 increments
Child AD&D availabilityAD&D not offered for children
Child Life/AD&D Age Limit and Termination RuleUnmarried child up to age 26. Terminates end of calendar year following 26th birthday
Evidence of insurability rules (late entrant, increases)EOI required for any increase outside of new hire guarantee issue. EOI not required for children.
Tobacco rating (Y/N)Yes
Accelerated Death BenefitUp to 75% of benefit
Disability waiver of premiumIncluded
Portability / ConversionBoth included
Grandfathered coverage rulesN/A
Administration & Claims
Salary change effective dateJanuary 1st
Age band change effective dateJanuary 1st
Rounding rulesRound to the next higher $1,000

STD

Attachment B - Plan Design Worksheet
STD Plan Design
Instructions:
1. Complete the highlighted cells for each line of coverage. No plan design change desired for STD (match current). For additional plan provisions, please see Exhibit B - Certificates of Coverage.
2. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal.
ItemCurrent ProvisionProposed ProvisionMeets/Exceeds? (Y/N)List Deviations
Eligibility & Enrollment
Participation requirementsWaive
Eligibility RulesActive FT 30+ Hours Per Week

Clerk of Courts & Tax Collector employees excluded Waiting period / Termination rules DOH on 1st-15th day of the month: Effective 1st of the following month

DOH on 16th - 31st day of the month: Effective 1st day of the 2nd month

Last day of employment is last day of coverage

Employee / Employer Contribution100% Employee Paid
Benefit Design – Match Current
Benefit percentage60% of the first $2,500 of predisability earnings, before reduction by Deductible Income
Maximum weekly benefit$1,500
Maximum benefit durationPlan 1: 24 weeks

Plan 2: 13 weeks Elimination period (accident / sickness) Plan 1: 14 days (accident & sickness) Plan 2: 90 days (accident & sickness)

Occupational sickness or injuryNot covered
Definition of earningsEarnings in effect on last full day of active work. Does not include bonuses, commissions, overtime pay, stock options or stock bonuses, employer contributions on employee's behalf to any deferred compensation arrangement or pension plan, or any other extra compensation
Pre-existing condition limitation (if any)None
Guarantee issue / EOI requirementsEOI required if coverage isn't elected in first 30 days of employment. No EOI required if switching from Plan 1 to Plan 2
Grandfathered coverage rulesN/A
Sick time offsetYes (employees can utilize sick pay before going out on a disability claim)
Deductible IncomeSee plan certificate for details
Administration & Claims
Age banded or composite ratesAge banded
Salary change effective dateCurrent salary
Age band change effective dateJanuary 1st
Pregnancy coverageTreated as sickness
Rounding rulesNone

LTD

Attachment B - Plan Design Worksheet
LTD Plan Design
Instructions:
1. Complete the highlighted cells for each line of coverage. No plan design change desired for LTD (match current). For additional plan provisions, please see Exhibit B - Certificates of Coverage.
2. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal.
ItemCurrent ProvisionProposed ProvisionMeets/Exceeds? (Y/N)List Deviations
Eligibility & Enrollment
Participation requirementsWaive
Eligibility RulesActive FT 30+ Hours Per Week

Tax Collector and Transportation & Planning Office employees excluded Waiting Period / Termination rules DOH on 1st-15th day of the month: Effective 1st of the following month

DOH on 16th - 31st day of the month: Effective 1st day of the 2nd month

Last day of employment is last day of coverage

Employee / Employer Contribution100% Employee Paid
Benefit Design – Match Current
Benefit percentage60% of the first $8,333 of predisability earnings, reduced by Deductible Income
Maximum monthly benefit$5,000 before reduction by Deductible Income
Maximum benefit duration61 or younger to age 65, or to SSNRA, or 3 years 6 months whichever is longest; Age 62 to SSNRA or 3 years 6 months; Age 63 to SSNRA or 3 years; Age 64 to SSNRA or 2 years 6 months; Age 65 2 years; Age 66 1 year 9 months; Age 67 1 year 6 months; Age 68 1 year 3 months; Age 69 or older 1 year.
Elimination PeriodPlan 1: 90 days

Plan 2*: 180 days

*If enrolled on STD and LTD is also requested, must elect Plan 2 LTD Definition of earnings Earnings in effect on last full day of active work. Includes commissions averaged over the preceding 12 months or over the period of your employment if less than 12 months.

Does not include bonuses, overtime pay, stock options or stock bonuses, employer contributions on employee's behalf to any deferred compensation arrangement or pension plan, or any other extra compensation

Earnings Test First 24 Months InitialLoss of at least 20% of pre-disability earnings
Earnings Test After 24 Months InitialLoss of at least 40% of pre-disability earnings
Social Security OffsetPrimary Only
Zero Day ResidualIncluded
Pre-existing condition limitation (if any)3 month look-back, 12 month exclusion
Prudent Person LanguageIncluded in Pre-Ex
Mental/Nervous Limitation24 months
Substance Abuse Limitation24 months
Limited Conditions LanguageIncluded
Mandatory RehabilitationYes
Reasonable AccomodationUp to $25,000
Survivor BenefitsIncluded
Waiver of PremiumIncluded
Guarantee issue / EOI requirementsEOI required if coverage isn't elected in first 30 days of employment
Grandfathered coverage rulesN/A
Own occupation period24 months
Any occupation definitionExpected to earn at least 60% of Indexed Predisability Earnings within 12 months following return to work, regardless of whether working in that or any other occupation.
Deductible IncomeSee plan certificate for details
Assisted living benefit (if any)Yes
Return to Work IncentivesSee plan certificate for details
Administration & Claims
Age banded or composite ratesAge banded
Salary change effective dateCurrent salary
Age band change effective dateJanuary 1st
Rounding rulesNone

Accident

Attachment B - Plan Design Worksheet
Accident - Plan Design
Instructions:
1. Complete the highlighted cells for each line of coverage. Include no more than 2 plan options. County reserves the right to choose one or both options. For current plan provisions, please see Exhibit B - Certificates of Coverage.
2. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal.
ItemDesired ProvisionProposed Plan 1Proposed Plan 2Meets/Exceeds? (Y/N)List Deviations
Eligibility & Enrollment
Participation RequirementsWaive
Eligibility RulesState your minimum rules; age; length of service; FT/PT Status; exclusions if any
Covered DependentsSpouse and Child(ren)
Waiting Period / Termination rulesNo waiting periods
Pre-existing condition limitationNo pre-existing conditions
Benefit ReductionNone
Employee / Employer ContributionEmployee contributions; State if both pre-tax and post-tax would be options
Plan Scope
Coverage type (24 Hour or Off Job)24 hour
Guaranteed issue / late entrant rulesPerpetual Guarantee Issue
Portability / ConversionFull portability at the same rates even if the master contract is cancelled in the future
ExclusionsPlease list
Coverage Outside the United StatesIndicate if benefits are payable if the accident occurs and/or if treatment is received outside the United States
Waiver of PremiumInclude if available
Benefits (Provide Schedule)
Initial treatment (Hospital/Urgent Care/Physician)Match or improve
Follow up TreatmentsMatch or improve
Hospital admissionMatch or improve
Hospital confinement (per day and max)Match or improve
ICU confinement (per day and max)Match or improve
Rehabilitation Unit Confinement (per day and max)Match or improve
Therapy - occupational, physical, or speech (per day and max)Match or improve
Ambulance (ground/air)Match or improve
Blood/Plasma/PlateletsMatch or improve
Lacerations max (provide schedule)Match or improve
Outpatient Surgery & AnesthesiaMatch or improve
Inpatient Surgery & AnesthesiaMatch or improve
TransportationMatch or improve
Family Member LodgingMatch or improve
Burn - Second Degree max (provide schedule)Match or improve
Burn - Third Degree max (provide schedule)Match or improve
Paralysis (Paraplegia / Quadriplegia)Match or improve
ProsthesisMatch or improve
ConcussionMatch or improve
ComaMatch or improve
Dislocation max (provide schedule)Match or improve
Fracture max (provide schedule)Match or improve
Medical imaging (CT, CAT, EEG, EMG, MR, or MRI)Match or improve
Knee cartilage surgical repairMatch or improve
Ruptured disc surgical repairMatch or improve
Tendon/ligament/rotator cuff surgical repairMatch or improve
Dental InjuryMatch or improve
Eye InjuryMatch or improve
Hearing loss injuryMatch or improve
Accidental Death Benefit (Employee / Spouse / Child)Match or improve
Dismemberment max (provide schedule)Match or improve
Organized Sports BenefitInclude for all covered persons
Wellness / Health Screening Benefit$100 for all covered persons

Hospital Indemnity

Attachment B - Plan Design Worksheet
Hospital Indemnity - Plan Design
Instructions:
1. Complete the highlighted cells for each line of coverage. Include no more than 2 plan options. County reserves the right to choose one or both options. For current plan provisions, please see Exhibit B - Certificates of Coverage.
2. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal.
ItemDesired ProvisionProposed Plan 1Proposed Plan 2Meets/Exceeds? (Y/N)List Deviations
Eligibility & Enrollment
Participation RequirementsWaive
Eligibility RulesState your minimum rules; age; length of service; FT/PT Status; exclusions if any
Covered DependentsSpouse and Child(ren)
Waiting Period / Termination rulesNo waiting periods
Pre-existing condition limitationNo pre-existing conditions
Benefit ReductionNone
Pregnancy Day 1 benefitPregnancy included day 1, no limitations or waiting periods
Employee / Employer ContributionEmployee contributions; State if both pre-tax and post-tax would be options
HSA CompatibleYes
Plan Scope
Guaranteed Issue / late entrant rulesPerpetual Guarantee Issue
Portability / ConversionFull portability at the same rates even if the master contract is cancelled in the future
ExclusionsPlease list
Coverage Outside the United StatesIndicate if benefits are payable if occurred and/or if treatment is received outside the United States
Waiver of PremiumInclude
Core Benefits
Hospital Admission (per confinement)Match or improve
Hospital Confinement (per day and max)Match or improve
ICU Confinment (per day and max)Match or improve
Intermediate ICU Step-Down Unit (per day and max)Match or improve
Major Diagnostic ExamsMatch or improve
Outpatient Doctor's Office Visit (per visit and max)Match or improve
Inpatient Surgery and AnesthesiaMatch or improve
Outpatient Surgery and Anesthesia (Hospital or ASC)Match or improve
Outpatient Surgery and Anesthesia (Doctor's Office, Urgent Care, or ER)Match or improve
Newborn BenefitsInclude
Wellness / Health Screening Benefit$100 for all covered persons

Critical Illness + Cancer

Attachment B - Plan Design Worksheet
Critical Illness + Cancer - Plan Design
Instructions:
1. Complete the highlighted cells for each line of coverage. Include no more than 2 plan options. County reserves the right to choose one or both options. For current plan provisions, please see Exhibit B - Certificates of Coverage.
2. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal.
ItemDesired ProvisionProposed Plan 1Proposed Plan 2Meets/Exceeds? (Y/N)List Deviations
Eligibility & Enrollment
Participation RequirementsWaive
Eligibility RulesState your minimum rules; age; length of service; FT/PT Status; exclusions if any
Covered DependentsInclude 100% of employee amount for all covered dependents
Waiting Period / Termination rulesNo Waiting Periods
Pre-existing condition limitationNo Pre-existing conditions
Benefit ReductionNone
Coverage Outside the United StatesList any stipulations; for example if diagnosis is made outside the United States would a benefit be payable?
Employee / Employer ContributionEmployee contributions; State if both pre-tax and post-tax would be options
Plan Scope
Guarantee Issue Amounts (Employee / Spouse / Child)$50,000 GI in increments of $5k
Issue or attained ageAttained Age; include Child in Employee Rate; 5 year age bands
Guaranteed issue / late entrant rulesPerpetual Guarantee Issue
Benefit amounts available (min/increments/max for Employee / Spouse / Child)All covered persons: $5,000 - $50,000 in $5,000 increments
AgeIs age based on effective date; what date is used when changing age bands; is Spouse based on their age or employee age?
Tobacco rating (if any)Indicate if quoting NT/T or Antitobacco. If NT/T is spouse status based on employee NT/T status?
Portability / ConversionFull portability at the same rates even if the master contract is cancelled in the future
ExclusionsPlease list
Waiver of PremiumInclude
Additional Diagnosis BenefitInclude with no limits or caps; quote with the minimum separation period available
Recurrence BenefitInclude with no limits or caps; quote with the minimum separation period available
Covered Conditions
Heart Attack (not cardiac arrest)Include, or state if unavailable to include
Cardiac ArrestInclude, or state if unavailable to include
StrokeInclude, or state if unavailable to include
Major Organ Failure / TransplantInclude, or state if unavailable to include
Kidney Failure (End-Stage Renal Failure)Include, or state if unavailable to include
Bone Marrow Transplant (Stem Cell Transplant)Include, or state if unavailable to include
ComaInclude, or state if unavailable to include
ParalysisInclude, or state if unavailable to include
Severe BurnsInclude, or state if unavailable to include
Loss of SightInclude, or state if unavailable to include
Loss of HearingInclude, or state if unavailable to include
Loss of SpeechInclude, or state if unavailable to include
HIV or HepatitisInclude, or state if unavailable to include
Advanced Alzheimer's DiseaseInclude, or state if unavailable to include
Advanced Parkinson's DiseaseInclude, or state if unavailable to include
Benign Brain TumorInclude, or state if unavailable to include
Coronary Artery Disease (Major)Include, or state if unavailable to include
Coronary Artery Bypass SurgeryInclude, or state if unavailable to include
Mitral/Aortic Valve Replacement or RepairInclude, or state if unavailable to include
Surgical Treatment of Abdominal Aortic AneurysmInclude, or state if unavailable to include
Wellness / Health Screening Benefit$100 for all covered persons
Dependent Child Covered Conditions
Cerebral PalsyInclude, or state if unavailable to include
Cleft Lip or PalateInclude, or state if unavailable to include
Cogenital Heart DiseaseInclude, or state if unavailable to include
Cystic FibrosisInclude, or state if unavailable to include
Down SyndromeInclude, or state if unavailable to include
Sickle Cell AnemiaInclude, or state if unavailable to include
Spina BifidaInclude, or state if unavailable to include
Type 1 DiabetesInclude, or state if unavailable to include
OtherAdditional conditions not listed above
Cancer Specific Conditions
Internal or Invasive CancerInclude, or state if unavailable to include
Non-Invasive CancerInclude, or state if unavailable to include
Skin CancerInclude, or state if unavailable to include
Additional Covered Conditions Not Listed AbovePlease list; include infectious diseases

Permanent Life with LTC

Attachment B - Plan Design Worksheet
OPTIONAL - Permanent Life with Long Term Care or Chronic Condition

Instructions: Include 1 plan option. County reserves the right not to offer this plan, or may choose to offer at a future date, including the ability to offer offcycle from Open Enrollment.

LIFE INSURANCEDesired ProvisionsProposed Plan 1Meets/Exceeds? (Y/N)List Deviations
Policy TypeState Type Quoting - UL/WL/Term
Eligibility RulesState your minimum rules; age; length of service; FT/PT Status; exclusions if any
Dependent CoverageSpouse; Child(ren); and Grandchild(ren)
Participation RequirementWaive
PortabilityInclude
Maximum Benefit AmountState Maximum Benefit available
Guaranteed IssueMinimum of $150,000
Benefit ReductionNone
Cash Value or Paid Up BenefitsState if policy builds cash value or provides paid up benefits
Guaranteed Interest RateState if applicable
Current Interest RateState if applicable
LTC/CC RIDER
Long Term Care or Chronic Condition RiderState Rider
Trigger for benefit to be payable under this riderProvide cert language
PayoutState how the benefit is paid; monthly benefit percent and/or lump sum options
Extension of BenefitsInclude maximum benefit
RestorationInclude maximum benefit
Care RequirementState care and/or confinement requirements
Family CareState if a family member can provide care including any licensed care requirements
Permanency LanguageState if the condition has to be deemed permanent
Pre-exState if there is a pre-ex
Waiver of PremiumState if premiums are waived while benefits are being paid under this rider
ComplianceState if the plan is considered to be 7702(b) or 101(g) compliant.
Other Rider(s)
Accelerated Death Benefit for Terminal IllnessState if available and automatically included or optional at the employee or employer level
Spouse Term RiderState if available and automatically included or optional at the employee or employer level
Child Term RiderState if available and automatically included or optional at the employee or employer level
Accidental Death BenefitState if available and automatically included or optional at the employee or employer level
Waiver of Premium for DisabilityState if available and automatically included or optional at the employee or employer level
Other Riders not listed aboveList any additional riders not listed above
Rate IllustrationsProvide monthly rates for a $50,000 benefit. As applicable include either guaranteed cash values at age 65 or Paid up Benefits.

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