Attachment_C__Premium_Worksheet.xlsx
XLSX spreadsheet 144 KB Posted
- Solicitation number
- RFP-1-26-12
- Issued by
- Brevard County, Florida
About this file
This is a premium worksheet for a Florida county's Group Life, Disability, and Supplemental Health Benefits solicitation. The county seeks to procure fully insured group term life, accidental death and dismemberment (AD&D), short-term disability (STD), and long-term disability (LTD) coverage, along with expanding voluntary supplemental health offerings including accident, hospital indemnity, and critical illness/cancer coverage. The contract is effective January 1, 2027, with a single carrier/administrator selected to provide all requested lines. The incumbent carrier is Standard Insurance Company, which has administered the primary life and disability benefits since January 1, 2019. The county currently offers individual supplemental plans through multiple representatives including Aflac, Allstate, and Colonial Life, which will transition to group-administered products upon contract award. Employees currently enrolled in individual plans may continue those coverages on a direct-bill basis without payroll deduction or on-site enrollment options.
The premium worksheet requires bidders to complete rate proposals for multiple coverage tiers across life, AD&D, STD, and LTD products, with current total annual premiums of $2,114,474.84 for these lines. Proposed rates must be guaranteed for a minimum of three years (2027, 2028, and 2029), except for critical illness and cancer coverage, which requires a two-year guarantee. For supplemental health products, bidders may propose up to two plan options for accident, hospital indemnity, and critical illness/cancer coverage, with rates stratified by employee relationship status (employee only, employee plus spouse, employee plus child(ren), and employee plus family). The worksheet includes detailed enrollment counts and benefit volumes across multiple age brackets for voluntary life coverage, with separate rate structures for tobacco and non-tobacco populations. Bidders must submit completed proposals in Excel format as specified in the Request for Proposal.
View the file
Other files
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_STD_LTD Premiums
| Attachment C - Premiums Worksheet |
| Life/AD&D/STD/LTD Premiums |
| Instructions: |
| 1. Complete the highlighted cells for each line of coverage. Do not change any counts, volumes or fomulas included in this spreadsheet. |
| 2. Your proposed rates/monthly premiums must be guaranteed for at least three (3) years. |
| 3. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal. |
| BOARD PAID LIFE/AD&D - REQUIRED | ||||||
| Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 Per Month | Current Total | Proposed Total | |
| Basic Life | 3,985 | $239,425,700 | $0.100 | $23,942.57 | $0.00 | |
| Basic AD&D | 3,985 | $239,425,700 | $0.015 | $3,591.39 | $0.00 | |
| Total Basic Life/AD&D | 3,985 | $239,425,700 | $27,533.96 | $0.00 |
| RETIREE LIFE - REQUIRED | ||||||
| Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 | Current Total | Proposed Total | |
| Retiree Life | 47 | $310,000 | $7.19 | $2,228.90 | $0.00 |
Total Retiree Life 47 $310,000 $2,228.90 $0.00
| VOLUNTARY EMPLOYEE LIFE/AD&D - Combine life and AD&D premiums based on rate per $1,000 of coverage - NON-TOBACCO - REQUIRED | ||||||
| Age Bracket | Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 | Current Total | Proposed Total |
| 24 and Under | 115 | $7,450,000 | $0.087 | $648.15 | $0.00 | |
| 25-29 | 182 | $13,140,000 | $0.068 | $893.52 | $0.00 | |
| 30-34 | 158 | $14,460,000 | $0.077 | $1,113.42 | $0.00 | |
| 35-39 | 185 | $18,510,000 | $0.096 | $1,776.96 | $0.00 | |
| 40-44 | 215 | $22,700,000 | $0.134 | $3,041.80 | $0.00 | |
| 45-49 | 220 | $25,700,000 | $0.153 | $3,932.10 | $0.00 | |
| 50-54 | 238 | $24,110,000 | $0.258 | $6,220.38 | $0.00 | |
| 55-59 | 209 | $20,170,000 | $0.505 | $10,185.85 | $0.00 | |
| 60-64 | 214 | $16,780,000 | $1.046 | $17,551.88 | $0.00 | |
| 65-69 | 54 | $3,028,800 | $1.711 | $5,182.28 | $0.00 | |
| 70 and Older | 22 | $370,000 | $2.690 | $995.30 | $0.00 | |
| Total Voluntary Employee Life | 1,812 | $166,418,800 | $51,541.64 | $0.00 |
| VOLUNTARY EMPLOYEE LIFE/AD&D - Combine life and AD&D premiums based on rate per $1,000 of coverage - TOBACCO - REQUIRED | ||||||
| Age Bracket | Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 | Current Total | Proposed Total |
| 24 and Under | 3 | $210,000 | $0.096 | $20.16 | $0.00 | |
| 25-29 | 0 | $0 | $0.068 | $0.00 | $0.00 | |
| 30-34 | 6 | $530,000 | $0.087 | $46.11 | $0.00 | |
| 35-39 | 13 | $740,000 | $0.106 | $78.44 | $0.00 | |
| 40-44 | 15 | $1,430,000 | $0.144 | $205.92 | $0.00 | |
| 45-49 | 12 | $960,000 | $0.182 | $174.72 | $0.00 | |
| 50-54 | 21 | $2,090,000 | $0.305 | $637.45 | $0.00 | |
| 55-59 | 18 | $1,290,000 | $0.609 | $785.61 | $0.00 | |
| 60-64 | 21 | $1,240,000 | $1.322 | $1,639.28 | $0.00 | |
| 65-69 | 3 | $207,600 | $2.262 | $469.59 | $0.00 | |
| 70 and Older | 1 | $85,000 | $3.526 | $299.71 | $0.00 | |
| Total Voluntary Employee Life | 113 | $8,782,600 | $4,356.99 | $0.00 |
| SPOUSE LIFE/AD&D -Combine life and AD&D premium based on rate per $1,000 of Coverage - NON-TOBACCO - REQUIRED | ||||||
| Age Bracket | Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 | Current Total | Proposed Total |
| 24 and Under | 7 | $195,000 | $0.087 | $16.97 | $0.00 | |
| 25-29 | 19 | $625,000 | $0.068 | $42.50 | $0.00 | |
| 30-34 | 28 | $985,000 | $0.077 | $75.85 | $0.00 | |
| 35-39 | 55 | $1,985,000 | $0.096 | $190.56 | $0.00 | |
| 40-44 | 63 | $2,955,000 | $0.134 | $395.97 | $0.00 | |
| 45-49 | 76 | $2,980,000 | $0.153 | $455.94 | $0.00 | |
| 50-54 | 83 | $2,930,000 | $0.258 | $755.94 | $0.00 | |
| 55-59 | 71 | $2,230,000 | $0.505 | $1,126.15 | $0.00 | |
| 60-64 | 73 | $1,830,000 | $1.046 | $1,914.18 | $0.00 | |
| 65-69 | 19 | $426,400 | $1.711 | $729.57 | $0.00 | |
| 70 and Older | 7 | $45,000 | $2.690 | $121.05 | $0.00 | |
| Total Voluntary Employee Life | 501 | $17,186,400 | $5,824.67 | $0.00 |
| Spouse Life/AD&D - Combined premium based on rate per $1,000 of coverage - TOBACCO - REQUIRED | ||||||
| Age Bracket | Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 | Current Total | Proposed Total |
| 24 and Under | 0 | $0 | $0.096 | $0.00 | $0.00 | |
| 25-29 | 0 | $0 | $0.068 | $0.00 | $0.00 | |
| 30-34 | 0 | $0 | $0.087 | $0.00 | $0.00 | |
| 35-39 | 4 | $100,000 | $0.106 | $10.60 | $0.00 | |
| 40-44 | 3 | $110,000 | $0.144 | $15.84 | $0.00 | |
| 45-49 | 5 | $140,000 | $0.182 | $25.48 | $0.00 | |
| 50-54 | 5 | $170,000 | $0.305 | $51.85 | $0.00 | |
| 55-59 | 10 | $275,000 | $0.609 | $167.48 | $0.00 | |
| 60-64 | 8 | $215,000 | $1.322 | $284.23 | $0.00 | |
| 65-69 | 0 | $0 | $2.262 | $0.00 | $0.00 | |
| 70 and Older | 0 | $0 | $3.526 | $0.00 | $0.00 | |
| Total Voluntary Employee Life | 35 | $1,010,000 | $555.48 | $0.00 |
| Child Life (no AD&D) - REQUIRED | ||||||
| Count | Volume | Current Rate/1,000 | Proposed Rate/1,000 | Current Total | Proposed Total | |
| Child Life | 494 | $4,694,000 | $0.070 | $328.58 | $0.00 |
| Short Term Disability 14 Day- Per $10 of weekly covered benefit at 60% - REQUIRED | ||||||
| Count | Volume | Current Rates | Proposed Rates | Current Total | Proposed Total | |
| Under age 25 | 90 | $52,258 | $0.418 | $2,184.38 | $0.00 | |
| 25-29 | 132 | $82,457 | $0.418 | $3,446.69 | $0.00 | |
| 30-34 | 122 | $85,824 | $0.418 | $3,587.44 | $0.00 | |
| 35-39 | 133 | $92,405 | $0.380 | $3,511.38 | $0.00 | |
| 40-44 | 118 | $86,238 | $0.323 | $2,785.49 | $0.00 | |
| 45-49 | 102 | $80,846 | $0.380 | $3,072.16 | $0.00 | |
| 50-54 | 117 | $87,237 | $0.428 | $3,733.74 | $0.00 | |
| 55-59 | 116 | $86,148 | $0.580 | $4,996.58 | $0.00 | |
| 60 and Older | 147 | $95,247 | $0.713 | $6,791.10 | $0.00 | |
| Total STD 14 Day | 1,077 | $748,659 | $34,108.96 | $0.00 |
| Short Term 90 Day- Per $10 of weekly covered benefit at 60% - REQUIRED | ||||||
| Count | Volume | Current Rates | Proposed Rates | Current Total | Proposed Total | |
| Under age 25 | 62 | $34,823 | $0.105 | $365.64 | $0.00 | |
| 25-29 | 69 | $42,168 | $0.105 | $442.76 | $0.00 | |
| 30-34 | 54 | $36,246 | $0.114 | $413.20 | $0.00 | |
| 35-39 | 44 | $29,741 | $0.114 | $339.05 | $0.00 | |
| 40-44 | 47 | $32,856 | $0.114 | $374.56 | $0.00 | |
| 45-49 | 37 | $29,383 | $0.133 | $390.80 | $0.00 | |
| 50-54 | 31 | $27,110 | $0.133 | $360.56 | $0.00 | |
| 55-59 | 42 | $30,922 | $0.181 | $559.69 | $0.00 | |
| 60 and Older | 57 | $39,240 | $0.219 | $859.36 | $0.00 | |
| Total STD 90 Day | 443 | $302,489 | $4,105.63 | $0.00 |
| Long Term 90 Day- Per $100 of monthly Predisability earnings - REQUIRED | ||||||
| Count | Volume | Current Rates | Proposed Rates | Current Total | Proposed Total | |
| Age 29 and under | 50 | $216,257 | $0.152 | $328.71 | $0.00 | |
| 30-34 | 23 | $107,259 | $0.247 | $264.93 | $0.00 | |
| 35-39 | 23 | $114,346 | $0.342 | $391.06 | $0.00 | |
| 40-44 | 26 | $151,920 | $0.599 | $910.00 | $0.00 | |
| 45-49 | 28 | $152,107 | $0.941 | $1,431.33 | $0.00 | |
| 50-54 | 41 | $228,737 | $1.292 | $2,955.28 | $0.00 | |
| 55-59 | 31 | $164,394 | $1.520 | $2,498.79 | $0.00 | |
| 60-64 | 19 | $103,188 | $1.444 | $1,490.04 | $0.00 | |
| 65 and Over | 8 | $37,281 | $0.884 | $329.56 | $0.00 | |
| Total LTD 90 Day | 249 | $1,275,488 | $10,599.69 | $0.00 |
| Long Term 180 Day -Per $100 of monthly Predisability Earnings - REQUIRED | ||||||
| Count | Volume | Current Rates | Proposed Rates | Current Total | Proposed Total | |
| Age 29 and under | 265 | $1,141,013 | $0.105 | $1,198.06 | $0.00 | |
| 30-34 | 129 | $638,398 | $0.162 | $1,034.20 | $0.00 | |
| 35-39 | 143 | $704,617 | $0.238 | $1,676.99 | $0.00 | |
| 40-44 | 155 | $825,092 | $0.409 | $3,374.63 | $0.00 | |
| 45-49 | 142 | $815,198 | $0.637 | $5,192.81 | $0.00 | |
| 50-54 | 143 | $790,786 | $0.874 | $6,911.47 | $0.00 | |
| 55-59 | 145 | $750,619 | $1.017 | $7,633.79 | $0.00 | |
| 60-64 | 141 | $692,381 | $0.950 | $6,577.62 | $0.00 | |
| 65 and Over | 52 | $245,201 | $0.580 | $1,422.17 | $0.00 | |
| Total LTD 180 Day | 1,315 | $6,603,306 | $35,021.74 | $0.00 |
| Total Monthly Premium for Life & Disability lines of coverage | $176,206.24 | $0.00 |
| Total Annual Premium for Life & Disability lines of coverage | $2,114,474.84 | $0.00 |
Supplemental Health Premiums
| Attachment C - Premiums Worksheet |
| Supplemental Health Premiums |
| 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. Your proposed rates/monthly premiums must be guaranteed for at least three (3) years. Except for Critical Illness + Cancer which must be guaranteed for at least two (2) years, in compliance with Florida Administrative Code Rule 69O-149.005(14). |
| 3. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal. |
| REQUIRED - Accident | ||
| Monthly Rates | Proposed Plan 1 | Proposed Plan 2 |
| Employee Only: | ||
| Employee + Spouse: | ||
| Employee + Child(ren): | ||
| Employee + Family: | ||
| # of Years Guaranteed (minimum 2027, 2028, and 2029) | ||
| REQUIRED - Hospital Indemnity | ||
| Monthly Rates | Proposed Plan 1 | Proposed Plan 2 |
| Employee Only: | ||
| Employee + Spouse: | ||
| Employee + Child(ren): | ||
| Employee + Family: | ||
| # of Years Guaranteed (minimum 2027, 2028, and 2029) | ||
| REQUIRED - Critical Illness + Cancer | ||
| Monthly Rates | Proposed Plan 1 | Proposed Plan 2 |
| Provide age-banded rate table; include child(ren in employee rate) | ||
| # of Years Guaranteed (minimum 2027 and 2028) | ||
| OPTIONAL - Permanent Life with Long Term Care or Chronic Condition | ||
| Rate Illustrations | Proposed Plan 1 | |
| Provide 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 .