The $98.6 Billion Healthcare Waste Problem: Open-Source Data Journalism Exposes Fixable Inefficiencies

The American Healthcare Conundrum is a data journalism project that quantifies fixable waste in US healthcare using open-source analysis of federal datasets. The project has identified $98.6 billion in annual savings through three detailed investigations into Medicare drug pricing, hospital procedure costs, and pharmacy benefit manager inefficiencies.

{{IMAGE:1}}

The Scale of the Problem

The US spends approximately $14,570 per person on healthcare, while Japan spends around $5,790 per person and achieves the highest life expectancy in the OECD. This creates a gap of roughly $3 trillion per year that the project aims to address systematically.

Core Methodology

Each issue follows a consistent approach:

• Identifies one fixable problem
• Quantifies waste using primary federal data
• Recommends specific policy fixes
• Provides fully reproducible code
• Names all caveats explicitly

All analysis uses primary sources including CMS cost reports, Part D claims data, OECD health statistics, and RAND pricing studies. Every number includes citations, and all scripts can be reproduced from a clean clone.

Issue #3: The 254% Problem (~$73.0B/year)

Commercial insurers pay 254% of Medicare rates for identical hospital procedures. For example, a hip replacement costs $29,000 in the US but under $11,000 in most peer nations.

{{IMAGE:4}}

The proposed solution involves capping commercial hospital payments at 200% of Medicare rates - a mechanism already used by Montana Medicaid and thousands of self-insured employers. This would save approximately $73 billion per year.

Issue #2: The Same Pill, A Different Price (~$25.0B/year)

Medicare pays 7-25× more than peer nations for the same brand-name drugs. The analysis shows that international reference pricing - benchmarking Medicare negotiations against what Germany, France, Japan, UK, and Australia pay - would save approximately $25 billion per year.

{{IMAGE:3}}

Issue #1: Medicare's OTC Drug Problem (~$0.6B/year)

Medicare Part D pays prescription prices for drugs available cheaply over-the-counter. Step therapy reform requiring OTC equivalents before prescription coverage activates would redirect roughly $0.6 billion per year in unnecessary spending.

What's Next

Issue #4 will examine pharmacy benefit managers - the largely invisible intermediaries who process 80% of US prescriptions and extract billions through spread pricing, rebate opacity, and formulary manipulation.

Why This Matters

The project demonstrates that healthcare waste isn't an abstract concept but a collection of specific, fixable problems. By using open-source methodology and primary data sources, it provides a transparent framework for understanding where money is being wasted and how to fix it.

The analysis shows that even small policy changes - like requiring OTC alternatives or benchmarking prices internationally - can yield billions in savings without reducing care quality.

Technical Approach

The project uses Python for data analysis, with scripts available for each issue. Data sources include:

• CMS Part D claims data
• CMS HCRIS cost reports
• OECD health statistics
• RAND pricing studies
• NHS Tariff data

Each analysis includes detailed methodology notes explaining assumptions, limitations, and calculation approaches.

Community Impact

By making all code and data publicly available, the project enables anyone to verify findings, adapt analyses for local contexts, or build upon the work. This open-source approach to healthcare policy analysis represents a new model for evidence-based advocacy.

The project is built by Andrew Rexroad, who provides contact information for questions, corrections, or data tips. The MIT License ensures that all findings and code remain freely available for use and adaptation.

{{IMAGE:2}}

Key Findings Summary

Through three issues, the project has identified:

• $73.0B/year from hospital procedure pricing inefficiencies
• $25.0B/year from drug price disparities with peer nations
• $0.6B/year from unnecessary prescription drug coverage

Total identified savings: $98.6 billion annually, representing 3.3% of the $3 trillion gap between US healthcare spending and more efficient systems.

The American Healthcare Conundrum demonstrates that significant healthcare savings are achievable through targeted policy changes backed by rigorous data analysis. By continuing to identify and quantify specific inefficiencies, the project provides a roadmap for reducing healthcare costs while maintaining or improving care quality.