The Pharmacy Owner's Guide to Inventory Optimization

Most pharmacy owners I have met treat inventory like furniture. It is just there. They order what the system tells them to order and they pay the wholesaler bill when it shows up. Meanwhile they cannot make payroll, and they cannot figure out why. Every extra bottle sitting on your shelf is a stack of cash you cannot spend.

The uncomfortable math most owners are ignoring

Here is the problem in one sentence. Your wholesaler gets paid in full on their schedule. Your PBMs pay you whatever they want, whenever they want. If the difference between those two numbers is negative for too long, you are out of business.

Inventory is where most of that gap lives. Every excess bottle on your shelf is money you already spent that is not working for you. You cannot pay rent with a bottle of atorvastatin. You cannot make payroll with a bin full of metformin. But you already paid cash for both.

The good news: you can probably free up tens of thousands of dollars in working capital without losing a single prescription, and you can do it inside of 90 days. The bad news is that most owners never do it because it requires looking at numbers they have been avoiding.

Reality Check

I have walked into pharmacies with $300K+ of inventory on the shelf that should have been running on $180K. That is $120K of working capital sitting there doing nothing. At 6% interest on their line of credit, that is over $7,000 a year in pure waste before we talk about expired returns.

The words you need to know

You cannot manage what you cannot measure, and you cannot measure what you cannot name. Here are the terms that matter. If you are not comfortable with these yet, get comfortable. This is pharmacy business 101.

Inventory Vocabulary

COGS

Cost of goods sold. What it cost you to buy the drugs you actually dispensed. This is the number accountants care about.

Inventory Purchases

What you paid your wholesaler. This is not the same as COGS and confusing them is a classic rookie mistake.

Turns

How many times the average bottle on your shelf gets replaced in a year. Higher is better. This is the single most important number in this guide.

Annualized

Monthly number multiplied by twelve. Used to compare numbers to yearly benchmarks even if you only have a month of data.

Min/Max

The reorder points in your PMS or wholesaler portal that trigger auto-reorders. This is where most of your inventory problems are hiding.

Just in time

Ordering a drug only when you actually need it for a specific prescription. Usually reserved for high cost specialty items where you cannot afford to hold stock.

Shrinkage

Inventory you paid for that is no longer there. Theft, damage, expired returns. Every pharmacy has some. Well run pharmacies have very little.

OOS

Out of stock. A patient walked in, you could not fill the script, they got annoyed. Too many OOS events and they stop coming back.

How to calculate your turns

There are two ways to do this. Pick one and stick with it forever. Mixing methods or comparing your number to someone else's without knowing which method they used is how pharmacy owners lie to themselves about performance.

Method 1: The accountant's way

This uses your actual cost of goods sold. It is the technically correct method and it is what your CPA will use. You need clean COGS numbers to do this, which means a real accounting system or at least a clean P&L.

Method 1 Formula

Turns = Annualized COGS ÷ Current Inventory Value

Method 2: The owner's way

This uses total sales revenue instead of COGS. It is not technically correct but it is easier to pull if you do not have clean COGS numbers. Most pharmacy owners I work with start here because they can get the number in five minutes.

Method 2 Formula

Turns = Annualized Sales ÷ Current Inventory Value

The 20% gotcha

Method 2 always produces a higher number than Method 1 by about 20 to 25 percent because it includes your gross profit in the numerator. If you are comparing your turns to another pharmacy owner, make absolutely sure you are using the same method or the comparison is meaningless.

What good actually looks like

Financially high performing pharmacies hit these targets. If you are below them, you have money sitting on your shelves that could be working for you instead.

Method 1 target: 16 to 18 turns per year
Method 2 target: 20 to 22 turns per year

If your current number is in the single digits, you are not alone. A lot of pharmacies are running at 8 to 10 turns and bleeding cash because of it. The gap between 8 turns and 16 turns is usually six figures of trapped working capital.

Calculating your ideal inventory level

Once you know what you want your turns to be, you can work backwards to figure out how much inventory you should actually be holding.

Ideal Inventory Calculation

Ideal Inventory = Annualized COGS (or Sales) ÷ Your Turns Goal

Run this number. Compare it to your current inventory value. The gap between those two is the cash you are going to free up. Write it down. That number is what you are working toward.

The six step plan to get there

This is the exact sequence I use when I am walking an owner through an inventory cleanup. It is not complicated but it is not optional either. Skip steps and you will end up right back where you started.

Get the team in the room. Inventory is not a one person problem and it cannot be a one person solution. Call a meeting. Explain the numbers. Show them what the gap looks like. I like to visualize it as stacks of money on the shelf that should be stacks of money in the bank. If the team does not understand why they are doing this, they will not do it.
Assign a project lead. One person owns this. They do not do all the work but they are the one who makes sure the work gets done and reports to you every week. This person needs access to your wholesaler portal and needs to understand the returns process cold.
Clean up what you already have. Pull every full unopened bottle that is in date and return it to the wholesaler. Ask for a one time override on restocking fees if you need to. List the non-returnable but still saleable items on MatchRx or to other local pharmacies. Process everything expired through your reverse distributor for credit. If you do not have an accurate inventory baseline, pay a third party service to count after the cleanup is done. This single step usually frees up 15 to 25 percent of your excess on its own.
Set your goals and your timeline. You know the gap now. Decide how aggressively you want to close it. If the gap is $60K and you want to close it in six months, that means averaging $10K a month in net inventory reduction. Post this somewhere visible. Track it weekly.
Set a daily ordering limit. This is where the magic happens. Calculate your average daily COGS. If you order more than that every day, your inventory grows. If you order less, it shrinks. Pick a daily ordering cap that is below your average daily COGS by the percentage you need to hit your goal. Ten percent below average daily COGS will shrink your inventory by about ten percent over time. The person doing the ordering should have a clear limit and should understand the exception process for the times it has to be broken.
Maintain it. Once you hit your target, the work is not done. Your sales change. Your patient mix changes. Drug prices change. The targets move. Revisit the numbers at least quarterly and adjust. Rotate assigned shelf sections between employees every month so there are always fresh eyes looking at the stock.

The biggest unlock

For most pharmacies, the fastest wins are in your high cost bottles. Anything over $150 a unit should be on a just in time or tight min/max system. Those bottles are where the real cash is trapped and where a small change in ordering behavior produces the biggest free cash swing.

Rules I live by for ongoing inventory health

Every high cost item above $150 per unit gets reviewed for just in time ordering. Full stop.
When a high cost special order comes in, label it or package it immediately so it does not get damaged. Damaged high cost items that are non-returnable are pure losses.
Larger sizes on cheap generics can be worth it, but only if you are actually going to turn them. Do the math before you buy the 1000 count bottle.
Playing the drug pricing market almost never pays off. Buying extra of something because you think the price is going up is a game you will lose more often than you win.
Rotate shelf ownership monthly. The person who has been looking at the same aisle for a year stops seeing what is on it.
Keep a binder with the return policies of every wholesaler you work with. When you need that info, you need it fast.
Document every exception to the ordering limit. Track who approved it and why. Without this, the limit becomes meaningless within three weeks.

What this looks like when it is working

When an inventory optimization program is actually running, here is what you should expect to see inside of 90 to 120 days.

Your cash position improves. The gap between what you are spending on drugs and what you are collecting from PBMs tightens up. Payroll stops feeling like a cliff every two weeks.

Your out of stocks drop. Counterintuitive but true. When you actually have eyes on your inventory instead of just letting the system auto-order, you catch the edge cases that cause OOS events. Patients notice. They come back.

Your team gets sharper. Employees who understand the financial impact of their ordering decisions make better decisions. It becomes a game they can win instead of a chore they resent.

Your business is worth more. If you ever want to sell, efficient inventory is one of the first things a buyer or their lender looks at. A pharmacy running 16 turns is worth more than an otherwise identical pharmacy running 8 turns because the working capital requirements are completely different.

The honest truth about doing this yourself

Most owners can implement the first three steps on their own without much help. Pull the returns. Run the numbers. Get the team on the same page. That alone will get you most of the way there for most pharmacies.

Where owners get stuck is on the ongoing management piece. Setting the daily ordering limit. Catching the exceptions. Keeping the system tight when life gets busy. That is the part that requires either a disciplined team or outside eyes. If your team is not doing it and you cannot add it to your plate, that is where consulting or the right software comes in.

But start with steps one through three. Do them this month. The cash you free up just from a clean return run usually pays for everything else.