Dearborn_Vision_Census.xls

XLS spreadsheet 25 KB Posted

Attached to
Employee Voluntary Benefit Products 2025-2026
Solicitation number
2025-08
Issued by
Hidalgo County, Texas

About this file

The file Dearborn_Vision_Census.xls is a vision insurance census document for an organization, likely in Dearborn, Michigan. The document details vision plan enrollment and premium rates for the 2024-25 period across two plan tiers (High Vision and Low Vision) with multiple coverage levels including Employee, Employee + Child(ren), Employee + Family, and Employee + Spouse. The census shows total enrollment of 312 lives for High Vision plans and 208 lives for Low Vision plans, with monthly premiums ranging from $6.34 for a single Employee Low Vision plan to $27.05 for an Employee + Family High Vision plan.

The pricing breakdown reveals per-employee monthly rates and total monthly premium collections, indicating a comprehensive view of vision insurance enrollment and associated costs. The tiered structure allows for flexible coverage options, with the High Vision plan consistently showing higher enrollment and premium rates compared to the Low Vision plan. The document provides a detailed snapshot of current vision insurance participation, which could be useful for benefits planning, budgeting, and understanding employee coverage preferences across different plan levels and family configurations.

View the file

Other files

Show all 21

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

Output

Dearborn Vision Census
Plan NameGroupingRateLivesMonthly Premium
High Vision 2024-25Employee$ 10.06313$ 3,148.78
High Vision 2024-25Employee + Child(ren)$ 21.5074$ 1,591.00
High Vision 2024-25Employee + Family$ 27.0583$ 2,245.15
High Vision 2024-25Employee + Spouse$ 18.3957$ 1,048.23
Low Vision 2024-25Employee$ 6.34149$ 944.66
Low Vision 2024-25Employee + Child(ren)$ 12.4028$ 347.20
Low Vision 2024-25Employee + Family$ 17.3611$ 190.96
Low Vision 2024-25Employee + Spouse$ 11.0720$ 221.40

File details come from the government source that posted it. Updated .