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
- Y22-1005
- Issued by
- Orange County, Orlando City, Florida
About this file
The document is a Form 3 Worksheet from Orange County Government for a 2023 Life and Disability Request for Proposal (RFP) covering group term life, accidental death and dismemberment (AD&D), long-term disability (LTD), and short-term disability (STD) insurance. The solicitation was issued for contract Y22-1005, with sealed electronic responses due by 4:00 pm EST on Tuesday, June 14, 2022, through the OpenGov e-Procurement Platform. The contract appears to be for a three-year term (2023-2025), with potential rate guarantees and rate caps for additional years.
The worksheet details current volumes and rates for various life and disability insurance categories, including basic life, additional employee life (segmented by age groups), spouse/domestic partner life, child life, employee and spouse AD&D, LTD, and multiple short-term disability plans. The document requests proposed rates and includes sections for performance guarantees related to customer service and claims administration standards. Notably, the current monthly premiums for these various coverage types total approximately $238,706.79, though the proposed rates are blank, suggesting this is a template for potential bidders to complete with their pricing information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Form_1_Mandatory_Features.docx | DOCX document | |
| Appendix_C_-_Plan_Experience.pdf | ||
| Appendix_B_-_Plan_Documents.pdf | ||
| Form_2_Worksheet.docx | DOCX document | |
| Appendix_D_-_EnterpriseSecurityStandards-InternalApplicationsRev4.pdf | ||
| Appendix_A_-_Census.xlsx | XLSX spreadsheet | |
| RFP_#Y22-1005-KK_FINAL.pdf |
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 | |||||||
| 2023 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 (2023, 2024 and 2025). 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 2023, 2024 and 2025 (y/n) | Rate Cap for 2026 and Beyond (indicate %) |
| Basic Life Cost | ||||
| $ 417,266,000 | $0.04 | $16,690.64 | $0.00 |
Basic AD&D Cost
$ 834,532,000 $0.015 $12,517.98 $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 2023, 2024 and 2025 (y/n) | Rate Cap for 2026 and Beyond (indicate %) | |
| Additional Employee Life | |||||||
| Under 30 | $ 41,860,000 | $0.040 | $1,674.40 | $0.00 | |||
| 30-34 | $ 40,330,000 | $0.060 | $2,419.80 | $0.00 | |||
| 35-39 | $ 57,950,000 | $0.120 | $6,954.00 | $0.00 | |||
| 40-44 | $ 68,920,000 | $0.200 | $13,784.00 | $0.00 | |||
| 45-49 | $ 63,990,000 | $0.300 | $19,197.00 | $0.00 | |||
| 50-54 | $ 80,960,000 | $0.460 | $37,241.60 | $0.00 | |||
| 55-59 | $ 59,770,000 | $0.530 | $31,678.10 | $0.00 | |||
| 60-64 | $ 42,410,000 | $0.680 | $28,838.80 | $0.00 | |||
| 65-69 | $ 14,830,000 | $1.370 | $20,317.10 | $0.00 | |||
| 70+ | $ 2,070,000 | $2.750 | $5,692.50 | $0.00 | |||
| Total | $167,797.30 | $0.00 | |||||
| Spouse/Domestic Partner Life | |||||||
| Under 30 | $ 1,090,000 | $0.040 | $43.60 | $0.00 | |||
| 30-34 | $ 6,055,000 | $0.060 | $363.30 | $0.00 | |||
| 35-39 | $ 10,565,000 | $0.120 | $1,267.80 | $0.00 | |||
| 40-44 | $ 13,490,000 | $0.200 | $2,698.00 | $0.00 | |||
| 45-49 | $ 14,685,000 | $0.300 | $4,405.50 | $0.00 | |||
| 50-54 | $ 17,240,000 | $0.460 | $7,930.40 | $0.00 | |||
| 55-59 | $ 15,323,500 | $0.530 | $8,121.46 | $0.00 | |||
| 60-64 | $ 11,037,500 | $0.680 | $7,505.50 | $0.00 | |||
| 65-69 | $ 4,538,500 | $1.370 | $6,217.75 | $0.00 | |||
| 70+ | $ 650,000 | $2.750 | $1,787.50 | $0.00 | |||
| Total | $40,340.80 | $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 2023, 2024 and 2025 (y/n) | Rate Cap for 2026 and Beyond (indicate %) | |
| Child Life | |||||||
| $ 24,755,000 | $0.350 | $1,732.85 | $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 2023, 2024 and 2025 (y/n) | Rate Cap for 2026 and Beyond (indicate %) |
| $ 946,180,000 | $0.02 | $18,923.60 | $0.00 |
| Spouse AD&D | ||||
| $ 189,349,000 | $0.02 | $3,786.98 | $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 2023, 2024 and 2025 (y/n) | Rate Cap for 2026 and Beyond (indicate %) | |
| Long Term Disability | |||||||
| $ 34,917,081 | $0.15 | $52,375.62 | $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 2023, 2024 and 2025 (y/n) | Rate Cap for 2026 and Beyond (indicate %) | |
| Short Term Disability | |||||||
| Plan 1: (120/120/9) | $ 26,443,790 | $0.082 | $2,501.99 | $0.00 | |||
| Plan 2: (90/90/13) | $ 33,000,697 | $0.12 | $4,569.33 | $0.00 | |||
| Plan 3: (60/60/18) | $ 34,742,746 | $0.21 | $8,418.43 | $0.00 | |||
| Plan 4: (30/30/22) | $ 44,878,008 | $0.27 | $13,981.23 | $0.00 | |||
| Plan 5: (15/15/24) | $ 154,771,545 | $0.31 | $55,360.59 | $0.00 | |||
| Total Monthly Short Term Disability |
Employee and Employer Total
&D &8&Z&F &G
Questions
| Orange County Government | |
| 2023 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? 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 .