4-Vanguard Insurance Cost Proposal.xlsx
XLSX spreadsheet 19 KB Posted
- Solicitation number
- VAN 2026-10
- Issued by
- Utah
About this file
This is a cost proposal form for employee benefits insurance programs submitted by Vanguard Academy through the State of Utah Division of Purchasing. The solicitation (VAN 2026-10) requests comprehensive insurance coverage including medical, dental, vision, short-term disability, basic life insurance, and voluntary benefits for approximately 100 eligible employees. Offerors must propose two required medical plans—an HSA-qualified high-deductible health plan compatible with HealthEquity and a non-HSA option—with an optional third medical plan. Proposals are due November 12, 2026, with contract award anticipated to the responsive and responsible offeror providing best value. The rate guarantee period and contract term duration are to be specified by the offeror on the cost proposal form.
The cost proposal requires offerors to submit monthly premium rates for all coverage tiers across medical plans, dental, vision, and short-term disability, as well as basic life insurance rates per $1,000 of coverage. Vanguard's contribution structure is built into the evaluation formulas: 90 percent of employee-only medical costs, zero percent of dependent costs, 50 percent of dental, 80 percent of vision, 100 percent of short-term disability and basic life (capped at $25,000), and zero percent of voluntary benefits, which are fully employee-paid. Offerors must also complete a Coverage Details tab specifying plan design elements such as deductibles, out-of-pocket maximums, copays, coinsurance percentages, and benefit durations to enable calculation of a Plan Equivalency Factor. All yellow cells in the spreadsheet require offeror input; blue cells auto-calculate totals; and grey cells are fixed by Vanguard and cannot be modified. Voluntary benefit rates for accident, critical illness, hospital indemnity, long-term disability, and extended life insurance are informational and do not affect the cost evaluation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1-Claim of Business Confidentiality Updated.pdf.pdf | ||
| 5-Vanguard Insurance Score Sheet.xlsx | XLSX spreadsheet | |
| 3-Vanguard Insurance 2026 RFP.docx.pdf | ||
| 2-Vendor Prerequisites - RFP Agency.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
Cost Proposal
| Cost Proposal | ||||
| 1.0 | Offeror must provide a cost in all line items in yellow to be considered responsive. | |||
| 2.0 | All cells in yellow require an input. Cells in blue will auto populate. Grey cells are set by Vanguard and must not be changed. | |||
| 3.0 | Enter rates on the "Core Rates" and "Voluntary Rates" tabs and the coverage values on the "Coverage Details" tab. The totals on this tab populate automatically. | |||
| 4.0 | Vanguard's contribution rules from the RFP (Medical 90% of employee cost / 0% dependents; Dental 50%; Vision 80%; STD 100%; Basic Life 100% up to $25,000; voluntary benefits 0%) are built into the formulas. | |||
| Offeror Name: | ||||
| Carrier(s) proposed: | ||||
| Rate guarantee period (months): | ||||
| # | Total Overall Cost | COST | ||
| 1.0 | Total annual evaluated premium for core benefits plus fees (auto-calculated from the breakdown below) | $ - 0 | ||
| Total Overall Cost (Cost Points shall be determined by this amount, adjusted for plan equivalency) | $ - 0 | |||
| # | Cost Breakdown: premiums and fees for all work associated with providing the services described in the RFP | Total Annual Premium / Fee | Vanguard Share (Annual) | Employee Share (Annual) |
| 1.0 | Medical Insurance (all proposed plans) | $ - 0 | $ - 0 | $ - 0 |
| 2.0 | Dental Insurance | $ - 0 | $ - 0 | $ - 0 |
| 3.0 | Vision Insurance | $ - 0 | $ - 0 | $ - 0 |
| 4.0 | Short-Term Disability | $ - 0 | $ - 0 | $ - 0 |
| 5.0 | Basic Life Insurance (up to $25,000) | $ - 0 | $ - 0 | $ - 0 |
| 6.0 | Annual administrative, implementation, or service fees charged to Vanguard | $ - 0 | $ - 0 | |
| 7.0 | $ - 0 | $ - 0 | ||
| 8.0 | $ - 0 | $ - 0 | ||
| 9.0 | Offeror may add additional lines if necessary (describe in column B). | $ - 0 | $ - 0 | |
| Total Overall Cost (This total should match the amount in C13) | $ - 0 | $ - 0 | $ - 0 | |
| Voluntary benefits (Accident, Critical Illness, Hospital Indemnity, Long-Term Disability, Extended Life) are quoted on the "Voluntary Rates" tab, are 100% employee-paid, and are not included in the cost score. |
Core Rates
| Core Benefit Rates: Medical, Dental, Vision, Short-Term Disability, Basic Life (SOLICITATION #VAN 2026-10) | |||||||
| Legend: | Yellow = Offeror input | Blue = auto-calculated | Grey = set by Vanguard (do not change) | ||||
| Enter monthly rates as numbers, e.g. 612.45 for $612.45 per month. Leave Medical Plan 3 blank if not proposed. | |||||||
| Vanguard Contribution Rules and Evaluation Assumptions (set by Vanguard) | |||||||
| Medical: Vanguard pays this % of the employee's coverage cost (Employee Only rate) | 90% | ||||||
| Medical: Vanguard pays this % of the cost of added dependents | 0% | ||||||
| Dental: Vanguard pays this % (employee and added dependents) | 50% | ||||||
| Vision: Vanguard pays this % (employee and added dependents) | 80% | ||||||
| Short-Term Disability: Vanguard pays this % | 100% | ||||||
| Basic Life: Vanguard pays this % | 100% | ||||||
| Basic Life: maximum employer-paid coverage amount ($) | $25,000 | ||||||
| Eligible employees (approximate, used for Basic Life estimate) | 100 | ||||||
| NOTE: The "Assumed Enrolled" counts below are illustrative placeholders used only to compare proposals on equal terms. Vanguard replaces them with actual census data before the RFP is released. | |||||||
| # | Benefit / Plan | Coverage Tier | Monthly Premium Rate | Assumed Enrolled Employees | Annual Premium | Vanguard Share (Annual) | Employee Share (Annual) |
| MEDICAL: Plan 1, HSA-qualified HDHP (required; HealthEquity-compatible) | |||||||
| Plan name / carrier / network: | |||||||
| 1.0 | Employee Only | 20 | $ - 0 | $ - 0 | $ - 0 | ||
| Employee + Spouse | 5 | $ - 0 | $ - 0 | $ - 0 | |||
| Employee + Child(ren) | 5 | $ - 0 | $ - 0 | $ - 0 | |||
| Family | 10 | $ - 0 | $ - 0 | $ - 0 | |||
| MEDICAL: Plan 2, non-HSA option (required) | |||||||
| Plan name / carrier / network: | |||||||
| 2.0 | Employee Only | 15 | $ - 0 | $ - 0 | $ - 0 | ||
| Employee + Spouse | 5 | $ - 0 | $ - 0 | $ - 0 | |||
| Employee + Child(ren) | 5 | $ - 0 | $ - 0 | $ - 0 | |||
| Family | 10 | $ - 0 | $ - 0 | $ - 0 | |||
| MEDICAL: Plan 3 (optional) | |||||||
| Plan name / carrier / network: | |||||||
| 3.0 | Employee Only | 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Employee + Spouse | 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Employee + Child(ren) | 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Family | 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Medical Subtotal (all plans) | $ - 0 | $ - 0 | $ - 0 | ||||
| DENTAL (Vanguard pays the % above for the employee and added dependents) | |||||||
| Plan name / carrier / network: | |||||||
| 4.0 | Employee Only | 25 | $ - 0 | $ - 0 | $ - 0 | ||
| Employee + Spouse | 10 | $ - 0 | $ - 0 | $ - 0 | |||
| Employee + Child(ren) | 10 | $ - 0 | $ - 0 | $ - 0 | |||
| Family | 25 | $ - 0 | $ - 0 | $ - 0 | |||
| Dental Subtotal | $ - 0 | $ - 0 | $ - 0 | ||||
| VISION (Vanguard pays the % above for the employee and added dependents) | |||||||
| Plan name / carrier / network: | |||||||
| 5.0 | Employee Only | 20 | $ - 0 | $ - 0 | $ - 0 | ||
| Employee + Spouse | 8 | $ - 0 | $ - 0 | $ - 0 | |||
| Employee + Child(ren) | 8 | $ - 0 | $ - 0 | $ - 0 | |||
| Family | 14 | $ - 0 | $ - 0 | $ - 0 | |||
| Vision Subtotal | $ - 0 | $ - 0 | $ - 0 | ||||
| SHORT-TERM DISABILITY (100% Vanguard-paid) | |||||||
| Plan design: benefit %, weekly max, elimination period, max duration, and rate basis: | |||||||
| 6.0 | Estimated annual premium for all eligible employees (based on census) | $ - 0 | $ - 0 | ||||
| BASIC LIFE (100% Vanguard-paid up to the maximum above) | |||||||
| Plan design notes (AD&D, accelerated benefit, conversion/portability): | |||||||
| 7.0 | Monthly rate per $1,000 of coverage | All eligible employees | 100 | $ - 0 | $ - 0 | $ - 0 | |
| Assumptions: Annual premium = monthly rate x assumed enrolled employees x 12. Medical Vanguard share = (Employee Only rate x 90% + added-dependent cost x 0%) per enrolled employee. Dental/Vision share = Vanguard % x tier rate. Basic Life assumes every eligible employee is covered at the maximum employer-paid amount. All percentages come from the RFP (VAN 2026-10) and are set by Vanguard. |
Coverage Details
| Coverage Details (SOLICITATION #VAN 2026-10) | |||
| Enter the value of each coverage element for the plans you are proposing. These values are used to calculate the Plan Equivalency Factor (see RFP, Cost/Budget). Yellow cells require an input. Enter percentages as percents (e.g., 80%). | |||
| # | Coverage Element | Unit | Offered Value |
| Medical: HSA-qualified HDHP (Plan 1) | |||
| 1.0 | HSA-qualified HDHP: individual deductible | $ | |
| 2.0 | HSA-qualified HDHP: individual out-of-pocket maximum | $ | |
| 3.0 | HSA-qualified HDHP: member coinsurance after deductible | % | |
| Medical: non-HSA plan (Plan 2) | |||
| 4.0 | Non-HSA plan: individual deductible | $ | |
| 5.0 | Non-HSA plan: individual out-of-pocket maximum | $ | |
| 6.0 | Non-HSA plan: primary care visit copay | $ | |
| 7.0 | Non-HSA plan: specialist visit copay | $ | |
| 8.0 | Non-HSA plan: member coinsurance after deductible | % | |
| 9.0 | Non-HSA plan: preferred brand prescription copay | $ | |
| Dental | |||
| 10.0 | Dental: annual maximum per person | $ | |
| 11.0 | Dental: in-network preventive services coverage | % | |
| 12.0 | Dental: in-network major services coverage | % | |
| Vision | |||
| 13.0 | Vision: eye exam copay | $ | |
| 14.0 | Vision: frame allowance | $ | |
| Short-Term Disability (base plan) | |||
| 15.0 | STD: benefit (% of wages replaced) | % | |
| 16.0 | STD: maximum benefit duration | weeks | |
| 17.0 | STD: elimination period | days |
Voluntary Rates
| Voluntary Benefit Rates (employee-paid; SOLICITATION #VAN 2026-10) | |||||
| Vanguard makes no contribution to these benefits. Rates are informational and are considered under the Service criteria. Yellow cells require an input. | |||||
| # | Product | Plan Design / Benefit Summary | Sample Monthly Rate (Employee Only) | Rating Basis (age bands, tobacco, per $1,000, etc.) | Vanguard Contribution |
| Ex. | EXAMPLE: Accident Insurance | Example: lump-sum benefits for injuries, ER visits, and hospital admission; $1,000 hospital admission benefit | $ 18.50 | Example: flat rate, no age banding, tobacco-neutral | n/a (example row) |
| 1.0 | Accident | 0% | |||
| 2.0 | Critical Illness | 0% | |||
| 3.0 | Hospital Indemnity | 0% | |||
| 4.0 | Long-Term Disability | 0% | |||
| 5.0 | Extended Life Insurance (above $25,000 basic benefit) | 0% | |||
| 6.0 | 0% | ||||
| 7.0 | 0% | ||||
| Offeror may add additional voluntary products in the open yellow rows. |
File details come from the government source that posted it. Updated .