Form_3_Worksheet.xlsx
XLSX spreadsheet 46 KB Posted
- Solicitation number
- Y24-1002
- Issued by
- Orange County, Orlando City, Florida
About this file
The document is a pricing worksheet for Orange County, Florida's 2025 Life and Disability Request for Proposal (RFP), specifically seeking group term life, accidental death and dismemberment (AD&D), long-term disability (LTD), and short-term disability (STD) insurance coverage. The solicitation seeks sealed electronic responses via the OpenGov e-Procurement Platform, with submissions due by 4:00 pm EST on Tuesday, June 25, 2024. The contract appears to be for a three-year period (2025-2027) with potential rate caps for years four and five, covering various life and disability insurance products for county employees with different age-based rate tiers.
The worksheet details current and proposed insurance rates across multiple coverage categories, including basic life, additional employee life (segmented by age groups from under 30 to 70+), spouse/domestic partner life, child life, employee and spouse AD&D, long-term disability, and short-term disability plans with varying benefit durations. The current monthly premiums total approximately $169,399.19, though proposed rates are not filled in on this worksheet. The document also includes sections for performance guarantee inquiries, seeking information on customer service standards, claims administration metrics, and potential financial penalties for not meeting specified service levels. Additional details request confirmation of rate guarantees, commission structures, and age-based rate calculations.
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 | |||||||
| 2025 Life and Disability RFP Proposal | |||||||
| 1. Complete the shaded cells for each line of coverage. | |||||||
| 2. Your proposed rates must be guaranteed for three (3) years (2025, 2026 and 2027) and a rate cap years four (4) and five (5). | |||||||
| 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 2025, 2026 and 2027 (y/n) | Rate Cap for 2028 and Beyond (indicate %) |
| Basic Life Cost | ||||
| $ 492,067,000 | $0.04 | $19,682.68 | $0.00 |
Basic AD&D Cost
$ 984,134,000 $0.015 $14,762.01 $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 2025, 2026 and 2027 (y/n) | Rate Cap for 2028 and Beyond (indicate %) | |
| Additional Employee Life | |||||||
| Under 30 | $ 53,950,000 | $0.040 | $2,158.00 | $0.00 | |||
| 30-34 | $ 40,630,000 | $0.060 | $2,437.80 | $0.00 | |||
| 35-39 | $ 58,030,000 | $0.120 | $6,963.60 | $0.00 | |||
| 40-44 | $ 65,400,000 | $0.200 | $13,080.00 | $0.00 | |||
| 45-49 | $ 68,200,000 | $0.300 | $20,460.00 | $0.00 | |||
| 50-54 | $ 75,150,000 | $0.460 | $34,569.00 | $0.00 | |||
| 55-59 | $ 63,030,000 | $0.530 | $33,405.90 | $0.00 | |||
| 60-64 | $ 40,610,000 | $0.680 | $27,614.80 | $0.00 | |||
| 65-69 | $ 14,482,000 | $1.370 | $19,840.34 | $0.00 | |||
| 70+ | $ 1,890,000 | $2.750 | $5,197.50 | $0.00 | |||
| Total | $165,726.94 | $0.00 | |||||
| Spouse/Domestic Partner Life | |||||||
| Under 30 | $ 1,860,000 | $0.040 | $74.40 | $0.00 | |||
| 30-34 | $ 5,905,000 | $0.060 | $354.30 | $0.00 | |||
| 35-39 | $ 10,155,000 | $0.120 | $1,218.60 | $0.00 | |||
| 40-44 | $ 13,776,500 | $0.200 | $2,755.30 | $0.00 | |||
| 45-49 | $ 14,800,000 | $0.300 | $4,440.00 | $0.00 | |||
| 50-54 | $ 16,245,000 | $0.460 | $7,472.70 | $0.00 | |||
| 55-59 | $ 15,975,500 | $0.530 | $8,467.02 | $0.00 | |||
| 60-64 | $ 10,771,500 | $0.680 | $7,324.62 | $0.00 | |||
| 65-69 | $ 4,318,500 | $1.370 | $5,916.35 | $0.00 | |||
| 70+ | $ 600,000 | $2.750 | $1,650.00 | $0.00 | |||
| Total | $39,673.28 | $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 2025, 2026 and 2027 (y/n) | Rate Cap for 2028 and Beyond (indicate %) | |
| Child Life | |||||||
| $ 24,275,000 | $0.350 | $1,699.25 | $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 2025, 2026 and 2027 (y/n) | Rate Cap for 2028 and Beyond (indicate %) |
| $ 962,744,000 | $0.02 | $19,254.88 | $0.00 |
| Spouse AD&D | ||||
| $ 188,814,000 | $0.02 | $3,776.28 | $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 2025, 2026 and 2027 (y/n) | Rate Cap for 2028 and Beyond (indicate %) | |
| Long Term Disability | |||||||
| $ 24,746,181 | $0.15 | $37,119.27 | $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 2025, 2026 and 2027 (y/n) | Rate Cap for 2028 and Beyond (indicate %) | |
| Short Term Disability | |||||||
| Plan 1: (120/120/9) | $ 30,678,013 | $0.082 | $2,902.61 | $0.00 | |||
| Plan 2: (90/90/13) | $ 33,410,524 | $0.12 | $4,626.07 | $0.00 | |||
| Plan 3: (60/60/18) | $ 39,258,375 | $0.21 | $9,512.61 | $0.00 | |||
| Plan 4: (30/30/22) | $ 49,851,599 | $0.27 | $15,530.69 | $0.00 | |||
| Plan 5: (15/15/24) | $ 179,020,270 | $0.31 | $64,034.17 | $0.00 | |||
| Total Monthly Short Term Disability |
Employee and Employer Total
&D &8&Z&F &G
Questions
| Orange County Government | |
| 2025 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 .