Visualize “markup” on Medicaid generic drugs

In traditional PBM “spread” contracts with payers, the payer pays one price for a generic claim, and the provider is paid some other amount for that claim. While calculating the precise spread in Medicaid is not possible given that PBM payments to pharmacies are not public, we can get a feel for how disconnected the price paid is from the ingredient cost by comparing CMS’ state utilization data to CMS’ NADAC data. From this comparison, we have derived “markup” and have created a celestial-feeling visualization for you to see where all of it is and is not.

We recommend flipping through states, switching between managed care and fee for service, and studying the varying size of the bubbles (which represents the markup for each drug). Should our system really be designed to pay the supply chain wildly different margins for different drugs? What sort of incentives does this put in place for the supply chain? What sort of unintended consequences? For our thoughts on this matter, click here.

Data Sources

How we Created our Dataset

  1. 46brooklyn's visualization tool of choice = Tableau Prep

  2. Lag effect NADAC prices (NADAC is reported on roughly a one-month lag)

  3. Aggregate weekly NADAC into quarterly NADAC

  4. Join State Utilization Database and lagged quarterly NADAC on NDC and Year-Quarter

How to Use   

  1. Each bubble is a different NDC Description (i.e. generic drug name)

  2. The size of the bubble corresponds to the average markup per prescription

  3. The color of the bubble corresponds to the number of prescriptions dispensed in Medicaid within the chosen time period

  4. The viz defaults to "All" states, but you can choose individual states as well

  5. Choose fee for service or managed care

  6. Choose one or multiple quarters

  7. Hover over any bubble to bring up a “tooltip” with the drug name, prescription count, markup, and other pertinent information

  8. If you are looking for a specific drug start typing the name of the drug into the “Highlight NDC Description” field. The viz will immediately start to filter as you type. You can then select a drug from the list and Tableau will highlight the bubble for you.

v 1.1 - posted October 24,2018
For full release notes click here