11-Exhibit F Detailed RX Cost Analysis.xlsx

This document is an Exhibit F Detailed RX Cost Analysis spreadsheet for the City of Scottsdale's healthcare benefits procurement. The file appears to be part of a comprehensive proposal for prescription drug management services, covering a potential three-year contract period with fill dates initially set from 12/16/2022 to 12/15/2023. The document is structured to analyze prescription drug costs across multiple transaction categories including retail, 90-day retail, mail order, and specialty pharmacy claims for both brand and generic medications.

The spreadsheet is designed to capture detailed pricing information, including total claims volume, Average Wholesale Price (AWP) values, pricing discount guarantees, dispensing fees, and expected rebates. Currently, all financial fields are populated with zero values, suggesting this is a template or preliminary document awaiting specific pricing details. The pricing analysis includes provisions for administration fees, estimated gross and net annual drug costs, and potential implementation credits. This document is part of a broader healthcare benefits solicitation by the City of Scottsdale, which seeks proposals for comprehensive benefit programs including medical, pharmacy, dental, employee assistance program, stop-loss coverage, and flexible spending/health savings account administration.