# The 340B Program Handbook: companion files

Julian R. Sterling, julianrsterling.com/340b

## What is here

- **340B_Program_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Talbryn Regional Medical Center, a private non-profit disproportionate share hospital with three eligible sites, an in-house retail pharmacy and four contract pharmacies, measured for calendar 2025. Every price, volume, fee and rate is a teaching assumption, never a market figure.

## The thirteen tabs, in the order to read them

1. **Sites**: the four sites, their cost report line, OPAIS registration and 340B start date, and whether each may buy at 340B on a given date.
2. **Products**: the seven product lines by class, with package size, WAC, the GPO price and the 340B price (the ceiling price, AMP less the unit rebate amount).
3. **Dispensations**: one row per location, product, status and payer for 2025 (the case keeps dispensations in aggregate), tested against the patient definition.
4. **Accounts and Accumulator**: one account per unit (340B, GPO or WAC), whole packages replenished and the year-end remainders.
5. **Medicaid**: carve-in at the hospital's own sites, carve-out at the contract pharmacies, and the discount passed to the state.
6. **Savings and Bridge**: gross savings against WAC and against the GPO price, then the bridge from potential gross savings to net savings, by channel.
7. **Contract Pharmacies**: the claims of each pharmacy, dispensing and TPA fees, and the net benefit per claim, kept apart from net savings.
8. **Restrictions**: the manufacturer restriction, the claims lost and its net effect.
9. **Rebate Scenario**: a separate scenario for 2027 on two product lines: purchase at WAC, rebates, float and cost of capital.
10. **Self-Audit**: the sample, its findings, the repayment and the extrapolation.
11. **Health Center**: a separate grantee health center scenario, on its own registers.
12. **Sensitivities**: the base case plus one declared change, one at a time.
13. **Controls**: the tests that must read zero before any figure leaves the file.

## How to use it

Change one input at a time, read the gross savings, the bridge and the net benefit per claim again, and look at Controls before reading any figure. A different price, fee or volume belongs in Sensitivities, run against the base case.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not legal, regulatory or reimbursement advice: the facts of your own program govern, and the program's counsel decides what applies to it.
