UC15: Pharmacy Rebate Optimiser

The Problem

Drug manufacturer rebates depend on volume thresholds: a PBM or health plan earns rebates based on achieving target prescription volumes. Rebate contracts typically specify: "achieve 50,000 units of Drug X in calendar year 2026, earn 12% rebate on all units; below 50,000 units, earn 8%." Underestimating volume and missing thresholds costs significant rebate revenue. Conversely, formulary decisions (which drugs are covered, at what tier) drive member utilization and thus rebate performance. Optimizing formulary to hit rebate thresholds requires analyzing projected volumes vs. contracts to identify opportunities for formulary changes that increase volume on high-rebate drugs.

What the Agent Does

Rebate Contract Parsing: Ingests manufacturer rebate contracts (typically Excel or PDF) to extract volume tiers, rebate rates, therapeutic class definitions, and performance measures.
Prescription Volume Auditing: Analyzes claims data (NCPDP pharmacy claims) to calculate actual prescription volumes by drug (NDC code), therapeutic class, and period (month, quarter, year-to-date).
Threshold Analysis: Compares actual volumes against rebate contract thresholds; identifies drugs where payer is above, below, or near threshold; calculates volume gap.
Rebate Shortfall Identification: For drugs where volume is below threshold, calculates revenue impact (e.g., "On Drug X, we'll earn $500K at 8% rebate vs. $750K at 12% rebate if we hit 50K unit threshold; gap is 5,000 units").
Formulary Opportunity Recommendation: Suggests formulary changes (e.g., "move Drug A to Tier 1 copay, down from Tier 2") that could increase volume on high-rebate drugs to hit thresholds; estimates member cost impact.
Competitor Therapy Analysis: For therapeutic classes with multiple drugs, compares rebate rates and volumes, recommends promoting higher-rebate alternatives.
Rebate Reconciliation: Tracks manufacturer rebate invoices vs. predicted rebates based on volumes; flags discrepancies for investigation.

Data Requirements

Data Sources:

Manufacturer rebate contracts (Excel/PDF) , drug list, volume tiers, rebate percentages, effective dates
Pharmacy claims data (NCPDP) , NDC codes, quantity, member counts, fill dates
Formulary data (Tier 1, 2, 3, Non-Covered by drug/NDC) , current formulary design
Member demographics (if available) , age, diagnosis to estimate utilization
Claims history (2+ years) , baseline utilization patterns, trend
Pharmacoeconomic data (if available) , comparative effectiveness, clinical outcomes by drug

Data Classification:

Public: None typically
Internal Structured: Rebate contracts, pharmacy claims, formulary data, member demographics
Internal Unstructured: Prior rebate analysis, formulary change rationale, contract negotiations notes
External Third-Party: Pharmacy claims (from PBM or pharmacy adjudication system)
Sensitive/Regulated: Claims data is PHI; rebate contracts are confidential/proprietary; formulary optimization is business strategy

Data Quality Requirements:

Timeliness: Pharmacy claims should be available within 5 to 10 business days; rebate contracts should be current (updated annually or upon renegotiation).
Completeness: Pharmacy claims should have 98%+ NDC codes; claim counts should match formulary drug universe.
Accuracy: NDC codes must be valid; volumes must be accurate; rebate rates must match authoritative contracts.

Integration Complexity: Medium , Requires pharmacy claims integration (standard for payers with pharmacy benefit), contract data import, and formulary optimization logic. Complexity is mainly in handling contract variations (different tiers, therapeutic class definitions vary by manufacturer) and estimating member utilization impact of formulary changes.

Score Breakdown

Criterion	Weight	Score (1-5)	Weighted
Time Recaptured	15%	3	0.45
Error Reduction	10%	3	0.30
Cost Avoidance	10%	4	0.40
Strategic Leverage	5%	4	0.20
Data Availability	15%	4	0.60
Process Clarity	15%	4	0.60
Ease of Implementation	10%	3	0.30
Fallback Available	10%	4	0.40
Audience (Int/Ext)	10%	4	0.40
Composite	100%		3.90

Why It Scores Well

Direct financial value: achieving rebate thresholds yields incremental revenue (potentially $1 to 5M annually for large payers). Time savings from automated analysis (FTE reduction in pharmacy operations). Error reduction from systematic threshold tracking. Data is available. Strategic leverage is high because rebate optimization directly impacts pharmacy margin and premium pricing.

Regulatory Alignment

PMPY & Transparency: Drug rebates are increasingly scrutinized; payer should have transparent processes for rebate optimization.
Formulary Design Requirements: Formulary changes must comply with CMS/state requirements (e.g., therapeutic alternatives must be available, patient protections); agent recommendations must be compliant.

Sprint Factory Fit

Sprint 0 (2 weeks) + 3 build sprints (6 weeks)

Pharmacy rebate optimization is a natural use case for agentic analysis. Implementation is medium complexity (contract parsing, threshold analysis). Recommended for payers with significant pharmacy benefits (100K+ members). Can be implemented iteratively: start with high-volume drugs, expand to full formulary. Fallback is manual rebate contract review.

Comparable Implementations

CVS Caremark Rebate Optimization Services , Industry standard for pharmacy rebate management
Express Scripts Pharmacy Analytics , Competing PBM with pharmacy analytics capabilities
OptumRx Formulary & Rebate Management , Industry competitor with similar offerings

Deploy This Use Case with the Sprint Factory

From zero to a governed, production agent in 6 weeks.

Sprint Factory Schedule a Briefing

Related Use Cases

Batch Claims Operations

Claims Auto-Adjudication Sentinel

Score: 4.3/5.0

Batch Finance & Actuarial

Risk Adjustment (HCC) Capture Agent

Score: 4.2/5.0

Batch Quality & Compliance

HEDIS Quality Score Monitor

Score: 4.15/5.0