Appendix_1_-_Vision_Experience_Data.xlsx

This is a Vision Experience Data appendix supporting the City of Phoenix's RFP PS 26-0317 for fully insured vision benefits, with a five-year contract term commencing January 1, 2028. The solicitation encompasses vision coverage for active employees, retirees, and COBRA participants of the City of Phoenix. The appendix provides comprehensive enrollment data, premium information, and claims history spanning from January 2023 through May 2026, establishing baseline metrics for prospective bidders to develop competitive proposals.

The enrollment data demonstrates stable to slightly growing membership across all categories, with active employee enrollment ranging from 7,103 members in January 2023 to 8,651 members in May 2026, while retiree enrollment increased from 1,626 to 2,058 members over the same period. Monthly premiums for active employees ranged from approximately $147,600 to $174,400, with retiree premiums ranging from approximately $28,000 to $36,600. COBRA enrollment remained relatively modest, averaging 100 to 200 participants monthly with corresponding premium contributions. Claims data indicates total paid amounts for active employees ranging from $1.7 million to $2.2 million annually, with retiree claims ranging from $293,000 to $399,000 annually and COBRA claims ranging from $20,000 to $30,000 annually. This historical experience data enables bidders to accurately project costs and develop pricing proposals for the upcoming five-year contract period.