5-PD 1.1 Attachment F- Pharmacy Claims Repricing Worksheet.xlsx

This is a Pharmacy Claims Repricing Worksheet attachment related to the City of Round Rock's Health and Pharmacy Benefits solicitation in Texas. The document serves as a supporting exhibit for the Request for Proposal (RFP) and is designed to collect detailed pharmacy claims repricing data from potential respondents. The worksheet functions as an analytical tool to evaluate how prospective vendors would handle the City's prescription drug claims and associated repricing methodologies. As part of this procurement, the City seeks qualified firms to provide comprehensive health benefits and prescription drug claims services for approximately 2,400 active employees, retirees, and dependents. The contract encompasses health, dental, vision, and prescription drug claims benefit administration services, with the successful respondent expected to deliver enhanced program recommendations and alternatives through internal or external sources. The City operates on a self-insured medical and dental benefit program with a plan year running January 1st through December 31st and a fiscal year from October 1st through September 30th.

The worksheet is intended to standardize the presentation of pharmacy repricing claims data across all bidders, enabling the City to conduct comparative analysis of vendor capabilities and cost structures. This document likely requests specific information regarding claim volumes, repricing methodologies, discount structures, and financial projections related to pharmacy claims administration. The current administrator is United Healthcare, serving as the incumbent Third-Party Administrator. The inclusion of this detailed repricing worksheet indicates that pharmacy cost management and claims processing efficiency are critical evaluation criteria for the City in selecting its next benefits administrator.