Exhibit 9 Resp_Supp_TermL_Pre_WrkSht.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- RFP Group Term Life
- Solicitation number
- RFP-09134
- Issued by
- Polk County, Florida
About this file
This document is an exhibit for a Request for Proposal (RFP) from the District to procure group term life with accidental death and dismemberment (AD&D) rider, and supplemental term life insurance coverage for its benefit-eligible employees. The RFP seeks proposals from qualified insurance providers to provide the requested coverages for a two-year base period, with options to renew for up to three additional 12-month periods. The RFP outlines the current coverage details and modifications required, including specific employee age bands, coverage types, total enrollments, and current unit rates.
The exhibit provides a premium worksheet for respondents to enter their proposed unit rates for the various coverage types and employee age bands. The total monthly and annual premiums will automatically populate based on the respondent's proposed rates. The RFP requires respondents to provide fixed rates for the two-year base period. No other pricing details or requirements are specified in the documents provided.
View the file
Other files
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
Employee Enrollments
| Respondent's Supplemental Term Life Premium Worksheet | ||||||
| Please enter your proposed premium rate for the applicable coverage in the yellow cells in column F. The premium totals in column G will automatically populate. | ||||||
| EMPLOYEE AGE BAND - PREMIUMS BASED ON EMPLOYEE AGE BAND | COVERAGE TYPE | TOTAL INDIVIDUAL COVERAGE | TOTAL ENROLLMENT | CURRENT UNIT RATE | PROPOSED UNIT RATE | TOTAL MONTHLY PREMIUM |
| 25 - 29 | Employee Life Insurance - Optional | $20,000.00 | 1 | $1.18 | $0.00 | |
| 25 - 29 | Employee Life Insurance - Optional | $50,000.00 | 2 | $2.95 | $0.00 | |
| 25 - 29 | Employee Life Insurance - Optional | $80,000.00 | 1 | $4.72 | $0.00 | |
| 25 - 29 | Employee Life Insurance - Optional | $100,000.00 | 1 | $5.90 | $0.00 | |
| 25 - 29 | Employee Life Insurance - Optional | $120,000.00 | 1 | $7.08 | $0.00 | |
| 25 - 29 | Employee Life Insurance - Optional | $150,000.00 | 1 | $8.85 | $0.00 | |
| 25 - 29 | Employee Life Insurance - Optional | $200,000.00 | 6 | $11.80 | $0.00 | |
| 25 - 29 | Spouse Life Insurance - Optional | $50,000.00 | 4 | $2.95 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $20,000.00 | 1 | $1.96 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $40,000.00 | 1 | $3.92 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $50,000.00 | 3 | $4.90 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $70,000.00 | 1 | $6.86 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $90,000.00 | 1 | $8.82 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $100,000.00 | 4 | $9.80 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $120,000.00 | 1 | $11.76 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $190,000.00 | 1 | $18.62 | $0.00 | |
| 30 - 34 | Employee Life Insurance - Optional | $200,000.00 | 3 | $19.60 | $0.00 | |
| 30 - 34 | Spouse Life Insurance - Optional | $25,000.00 | 1 | $2.45 | $0.00 | |
| 30 - 34 | Spouse Life Insurance - Optional | $50,000.00 | 4 | $4.90 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $20,000.00 | 1 | $2.34 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $40,000.00 | 1 | $4.68 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $100,000.00 | 6 | $11.70 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $130,000.00 | 1 | $15.21 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $150,000.00 | 2 | $17.55 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $200,000.00 | 2 | $23.40 | $0.00 | |
| 35 - 39 | Employee Life Insurance - Optional | $470,000.00 | 1 | $54.99 | $0.00 | |
| 35 - 39 | Spouse Life Insurance - Optional | $10,000.00 | 1 | $1.17 | $0.00 | |
| 35 - 39 | Spouse Life Insurance - Optional | $20,000.00 | 1 | $2.34 | $0.00 | |
| 35 - 39 | Spouse Life Insurance - Optional | $50,000.00 | 3 | $5.85 | $0.00 | |
| 35 - 39 | Spouse Life Insurance - Optional | $230,000.00 | 1 | $26.91 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $20,000.00 | 1 | $2.74 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $50,000.00 | 1 | $6.85 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $75,000.00 | 1 | $10.28 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $100,000.00 | 7 | $13.70 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $110,000.00 | 1 | $15.07 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $150,000.00 | 1 | $20.55 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $155,000.00 | 1 | $21.24 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $160,000.00 | 1 | $21.92 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $180,000.00 | 1 | $24.66 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $190,000.00 | 1 | $26.03 | $0.00 | |
| 40 - 44 | Employee Life Insurance - Optional | $200,000.00 | 8 | $27.40 | $0.00 | |
| 40 - 44 | Spouse Life Insurance - Optional | $5,000.00 | 1 | $0.68 | $0.00 | |
| 40 - 44 | Spouse Life Insurance - Optional | $10,000.00 | 1 | $1.37 | $0.00 | |
| 40 - 44 | Spouse Life Insurance - Optional | $25,000.00 | 2 | $3.42 | $0.00 | |
| 40 - 44 | Spouse Life Insurance - Optional | $40,000.00 | 1 | $5.48 | $0.00 | |
| 40 - 44 | Spouse Life Insurance - Optional | $50,000.00 | 6 | $6.85 | $0.00 | |
| 40 - 44 | Spouse Life Insurance - Optional | $100,000.00 | 1 | $13.70 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $10,000.00 | 2 | $2.05 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $50,000.00 | 1 | $10.25 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $60,000.00 | 1 | $12.30 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $90,000.00 | 1 | $18.45 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $100,000.00 | 8 | $20.50 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $130,000.00 | 2 | $26.65 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $150,000.00 | 1 | $30.75 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $170,000.00 | 1 | $34.85 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $200,000.00 | 5 | $41.00 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $300,000.00 | 1 | $61.50 | $0.00 | |
| 45 - 49 | Employee Life Insurance - Optional | $470,000.00 | 1 | $96.35 | $0.00 | |
| 45 - 49 | Spouse Life Insurance - Optional | $25,000.00 | 1 | $5.12 | $0.00 | |
| 45 - 49 | Spouse Life Insurance - Optional | $40,000.00 | 1 | $8.20 | $0.00 | |
| 45 - 49 | Spouse Life Insurance - Optional | $50,000.00 | 4 | $10.25 | $0.00 | |
| 45 - 49 | Spouse Life Insurance - Optional | $100,000.00 | 1 | $20.50 | $0.00 | |
| 45 - 49 | Spouse Life Insurance - Optional | $150,000.00 | 1 | $30.75 | $0.00 | |
| 45 - 49 | Spouse Life Insurance - Optional | $235,000.00 | 1 | $48.18 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $20,000.00 | 1 | $7.42 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $50,000.00 | 1 | $18.55 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $60,000.00 | 1 | $22.26 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $80,000.00 | 1 | $29.68 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $100,000.00 | 11 | $37.10 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $110,000.00 | 2 | $40.81 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $150,000.00 | 7 | $55.65 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $200,000.00 | 10 | $74.20 | $0.00 | |
| 50 - 54 | Employee Life Insurance - Optional | $250,000.00 | 1 | $92.75 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $10,000.00 | 1 | $3.71 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $20,000.00 | 1 | $7.42 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $25,000.00 | 2 | $9.28 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $30,000.00 | 1 | $11.13 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $50,000.00 | 16 | $18.56 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $75,000.00 | 2 | $27.83 | $0.00 | |
| 50 - 54 | Spouse Life Insurance - Optional | $125,000.00 | 1 | $46.39 | $0.00 | |
| 55 - 59 | Employee Life Insurance - Optional | $50,000.00 | 5 | $37.05 | $0.00 | |
| 55 - 59 | Employee Life Insurance - Optional | $60,000.00 | 3 | $44.46 | $0.00 | |
| 55 - 59 | Employee Life Insurance - Optional | $100,000.00 | 13 | $74.10 | $0.00 | |
| 55 - 59 | Employee Life Insurance - Optional | $150,000.00 | 2 | $111.15 | $0.00 | |
| 55 - 59 | Employee Life Insurance - Optional | $190,000.00 | 1 | $140.79 | $0.00 | |
| 55 - 59 | Employee Life Insurance - Optional | $200,000.00 | 4 | $148.20 | $0.00 | |
| 55 - 59 | Spouse Life Insurance - Optional | $10,000.00 | 1 | $7.41 | $0.00 | |
| 55 - 59 | Spouse Life Insurance - Optional | $20,000.00 | 1 | $14.82 | $0.00 | |
| 55 - 59 | Spouse Life Insurance - Optional | $25,000.00 | 2 | $18.52 | $0.00 | |
| 55 - 59 | Spouse Life Insurance - Optional | $30,000.00 | 1 | $22.23 | $0.00 | |
| 55 - 59 | Spouse Life Insurance - Optional | $50,000.00 | 9 | $37.05 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $15,000.00 | 1 | $13.46 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $30,000.00 | 1 | $26.91 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $50,000.00 | 3 | $44.85 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $100,000.00 | 3 | $89.70 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $150,000.00 | 2 | $134.55 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $190,000.00 | 1 | $170.43 | $0.00 | |
| 60 - 64 | Employee Life Insurance - Optional | $200,000.00 | 1 | $179.40 | $0.00 | |
| 60 - 64 | Spouse Life Insurance - Optional | $25,000.00 | 2 | $22.42 | $0.00 | |
| 60 - 64 | Spouse Life Insurance - Optional | $50,000.00 | 4 | $44.85 | $0.00 | |
| 65 - 69 | Employee Life Insurance - Optional | $97,500.00 | 1 | $157.85 | $0.00 | |
| N/A | Child Life Insurance - Optional (One rate and benefit amount for all eligible children in family, regardless of number) | $10,000.00 | 26 | $1.10 | $0.00 | |
| N/A | Child Life Insurance - Optional (One rate and benefit amount for all eligible children in family, regardless of number) | $20,000.00 | 45 | $2.20 | $0.00 | |
| TOTAL MONTHLY PREMIUM | $0.00 | |||||
| TOTAL ANNUAL PREMIUM | $0.00 |
File details come from the government source that posted it. Updated .