Form_3_Worksheet.xlsx
XLSX spreadsheet 38 KB Posted
- Attached to
- Group Term Life, Accidental Death, Long and Short Term Disability and Dismemberment Term Contract
- Solicitation number
- Y23-183
- Issued by
- Orange County, Orlando City, Florida
About this file
This is a pricing worksheet (Form_3_Worksheet.xlsx) for Orange County Government's 2024 Life and Disability Request for Proposal (RFP) covering group life, accidental death and dismemberment (AD&D), long-term disability (LTD), and short-term disability (STD) insurance. The solicitation is for a three-year contract period (2024-2026) with potential rate guarantees and caps for additional years, and responses were due by 4:00 pm EST on Tuesday, April 25, 2023, to be submitted electronically through the OpenGov e-Procurement Platform.
The worksheet details current and proposed rates across multiple coverage tiers, including basic life and AD&D, additional employee life insurance (segmented by age groups), spouse/domestic partner life insurance, child life insurance, and disability plans. The current monthly premium volumes are substantial, with basic life and AD&D at approximately $30,828.98, employee and spouse life insurance totaling $198,084.46, and disability plans ranging from $2,498.88 to $56,910.58 per month for short-term disability and $54,108.45 for long-term disability. The document also includes sections for performance guarantees and service standards, with spaces for respondents to outline their proposed customer service and claims administration metrics.
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
Rates
| Orange County Government | |||||||
| 2024 Life and Disability RFP Proposal | |||||||
| 1. Complete the shaded cells for each line of coverage. | |||||||
| 2. Your proposed rates must be guaranteed for at least three (3) years (2024, 2025 and 2026). Additional year rate guarantee or cap is requested (but is not mandatory) for additional years | |||||||
| 3. You must submit this completed form with your proposal and include an electronic copy in Excel format per the Request for Proposal. | |||||||
| Current Volume | Current rate per $1,000 | Proposed Rate Per $1,000 per month | Current Monthly Total Premium | Proposed Monthly Premium Total | Confirm Rates Guaranteed for 2024, 2025 and 2026 (y/n) | Rate Cap for 2027 and Beyond (indicate %) |
| Basic Life Cost | ||||
| $ 440,414,000 | $0.04 | $17,616.56 | $0.00 |
Basic AD&D Cost
$ 880,828,000 $0.015 $13,212.42 $0.00
Total Monthly Basic Life & AD&D Premiums
| Current Volume | Current rate per $1,000 | Proposed Rate Per $1,000 per month | Current Monthly Total Premium | Proposed Monthly Premium Total | Confirm Rates Guaranteed for 2024, 2025 and 2026 (y/n) | Rate Cap for 2027 and Beyond (indicate %) | |
| Additional Employee Life | |||||||
| Under 30 | $ 48,390,000 | $0.040 | $1,935.60 | $0.00 | |||
| 30-34 | $ 40,310,000 | $0.060 | $2,418.60 | $0.00 | |||
| 35-39 | $ 56,590,000 | $0.120 | $6,790.80 | $0.00 | |||
| 40-44 | $ 67,220,000 | $0.200 | $13,444.00 | $0.00 | |||
| 45-49 | $ 64,380,000 | $0.300 | $19,314.00 | $0.00 | |||
| 50-54 | $ 78,270,000 | $0.460 | $36,004.20 | $0.00 | |||
| 55-59 | $ 58,770,000 | $0.530 | $31,148.10 | $0.00 | |||
| 60-64 | $ 38,970,000 | $0.680 | $26,499.60 | $0.00 | |||
| 65-69 | $ 12,218,000 | $1.370 | $16,738.66 | $0.00 | |||
| 70+ | $ 2,030,000 | $2.750 | $5,582.50 | $0.00 | |||
| Total | $159,876.06 | $0.00 | |||||
| Spouse/Domestic Partner Life | |||||||
| Under 30 | $ 1,530,000 | $0.040 | $61.20 | $0.00 | |||
| 30-34 | $ 6,385,000 | $0.060 | $383.10 | $0.00 | |||
| 35-39 | $ 10,165,000 | $0.120 | $1,219.80 | $0.00 | |||
| 40-44 | $ 12,810,000 | $0.200 | $2,562.00 | $0.00 | |||
| 45-49 | $ 14,920,000 | $0.300 | $4,476.00 | $0.00 | |||
| 50-54 | $ 16,880,000 | $0.460 | $7,764.80 | $0.00 | |||
| 55-59 | $ 15,168,500 | $0.530 | $8,039.31 | $0.00 | |||
| 60-64 | $ 10,222,500 | $0.680 | $6,951.30 | $0.00 | |||
| 65-69 | $ 3,783,500 | $1.370 | $5,183.40 | $0.00 | |||
| 70+ | $ 570,000 | $2.750 | $1,567.50 | $0.00 | |||
| Total | $38,208.40 | $0.00 |
| Current Volume | Current rate per $5,000 | Proposed Rate Per $5,000 per month | Current Monthly Total Premium | Proposed Monthly Premium Total | Confirm Rates Guaranteed for 2024, 2025 and 2026 (y/n) | Rate Cap for 2027 and Beyond (indicate %) | |
| Child Life | |||||||
| $ 22,725,000 | $0.350 | $1,590.75 | $0.00 |
| Additional Employee AD&D | Current Volume | Current rate per $1,000 | Proposed Rate Per $1,000 per month | Current Monthly Total Premium | Proposed Monthly Premium Total | Confirm Rates Guaranteed for 2024, 2025 and 2026 (y/n) | Rate Cap for 2027 and Beyond (indicate %) |
| $ 934,296,000 | $0.02 | $18,685.92 | $0.00 |
| Spouse AD&D | ||||
| $ 184,869,000 | $0.02 | $3,697.38 | $0.00 | |
| Total Employee Paid Life and AD&D |
| Current Volume | Current rate per $100 per month | Proposed Rate Per $100 per month | Current Monthly Total Premium | Proposed Monthly Premium Total | Confirm Rates Guaranteed for 2024, 2025 and 2026 (y/n) | Rate Cap for 2027 and Beyond (indicate %) | |
| Long Term Disability | |||||||
| $ 36,072,303 | $0.15 | $54,108.45 | $0.00 | ||||
| Total Monthly LTD Premium |
| Annual Payroll Volume | Current rate per $10 of weekly covered benefit per month | Proposed Rate Per $10 weekly covered benefit per month | Current Monthly Total Premium | Proposed Monthly Premium Total | Confirm Rates Guaranteed for 2024, 2025 and 2026 (y/n) | Rate Cap for 2027 and Beyond (indicate %) | |
| Short Term Disability | |||||||
| Plan 1: (120/120/9) | $ 26,410,929 | $0.082 | $2,498.88 | $0.00 | |||
| Plan 2: (90/90/13) | $ 32,812,187 | $0.12 | $4,543.23 | $0.00 | |||
| Plan 3: (60/60/18) | $ 35,441,548 | $0.21 | $8,587.76 | $0.00 | |||
| Plan 4: (30/30/22) | $ 45,180,525 | $0.27 | $14,075.47 | $0.00 | |||
| Plan 5: (15/15/24) | $ 159,104,856 | $0.31 | $56,910.58 | $0.00 | |||
| Total Monthly Short Term Disability |
Employee and Employer Total
&D &8&Z&F &G
Questions
| Orange County Government | |
| 2024 Life and Disability RFP Proposal | |
| Premium Questions: | |
| Question | Response |
| 1. Confirm Spouse Life rates are based on Spouse’s own age. | |
| 2. Do your proposed rates include commissions? If so identify your company’s usual commissions for this proposal and estimate the annual commissions included in your proposed rates. | |
| 3. If commissions are included in proposed rates, identify the independent agent(s) or broker(s) to receive these commissions and the specific services that will be provided. | |
| Performance Guarantees: | |
| Question | Response |
| 1. Please indicate your proposed Customer Service performance standards, along with financial penalties you are willing to provide for failure to meet standards: | |
| · Average speed of answer | |
| · Call abandonment rate | |
| · Member complaints | |
| · Staff contact turnover | |
| 2. Please indicate your proposed Claims Administration performance standards, along with financial penalties you are willing to provide for failure to meet standards: | |
| · Claims turnaround time | |
| · Claims accuracy |
image1.jpeg
File details come from the government source that posted it. Updated .