Attachment I - Formulary and Network Disruption Analysis.xlsx

Attachment I is a Formulary and Network Disruption Analysis spreadsheet prepared for the City of Houston's Pharmacy Benefits Management (PBM) Services contract opportunity. This analytical document supports the City's procurement of third-party PBM services to administer prescription drug benefits for the City's self-funded medical plans covering employees and their dependents. The spreadsheet serves as a supporting exhibit to evaluate and compare formulary structures and network adequacy across potential service providers, enabling the City to assess how each bidder's proposed pharmacy networks and drug formularies would impact plan members and administrative operations.

The Formulary and Network Disruption Analysis provides detailed comparative data necessary for the City's evaluation committee to measure disruption risk associated with transitioning from the current PBM vendor to alternative providers. This analysis includes metrics on formulary changes, network pharmacy availability, and potential member access impacts, allowing procurement officials to quantify the costs and benefits of switching vendors against service quality and continuity considerations. As part of the broader procurement package for a five-year initial contract term with two optional one-year renewal periods, this attachment enables the City to make an informed decision regarding which qualified firm can best serve its pharmacy benefit administration needs while minimizing disruption to plan members and maintaining cost-effectiveness throughout the proposed seven-year contract period.