Attachment R_Pharmacy GeoAccess Analysis Template.xlsx

This is a pharmacy geo-access analysis template for the Oregon Public Employees Benefit Board (PEBB) Medical & Pharmacy Benefit RFP (OregonBuys Bid No. S-44300-00014758). The document provides census zip code data for PEBB members and retirees across all 50 states, with detailed participant information organized by zip code, city, state, plan name (Statewide or Choice), employment status (full-time or part-time), and member counts. Vendors responding to the RFP must complete network geo-access analyses for both Retail-30 and Retail-90 pharmacy networks, measuring driving distances from participant home zip codes to proposed network pharmacies using established access standards of 1 mile for urban areas, 3 miles for suburban areas, and 10 miles for rural areas. The template requires bidders to provide comprehensive analyses including the total number of network pharmacies, identification of major pharmacy chains not in the proposed network, participant access metrics, and detailed descriptions of methodologies used for geo-analysis, including software platforms, distance calculations, and assumptions employed.

The census file contains approximately 40,000 PEBB participants and retirees distributed across numerous zip codes, with significant concentrations in Oregon (particularly the Portland, Salem, Eugene, and Bend areas), California, Washington, and Idaho. Bidders must explain why any participants were excluded from the geo-analysis, identify specific pharmacies not in their proposed network but available to participants, describe procedures and timing for achieving required network participation standards by the effective date, and detail the process for allowing PEBB and participants to recommend pharmacies for network addition. The RFP requires vendors to submit an electronic file containing complete geo-access results alongside summary responses, with all proposals due November 14, 2025, through the Proposal Technologies Network online platform at www.proposaltech.com. The procurement process indicates a multi-year contract opportunity for large-scale healthcare benefits administration with diverse membership across multiple states and plan designs.