The Data-Driven Approach Works. It's Also a Full Day of Your Life.

If you've read anything I've written, you know where I stand: the only ordering system that holds up is one built on your own numbers. A reorder point tells you when. An order quantity tells you how much. Both come from what your practice actually sold, not from what anyone remembers selling.

So this post isn't a warning about the data-driven approach. It's a confession about what it costs to do by hand, because I did it by hand for years. If you've tried it, you already know. If you're about to try it, you deserve to know where the hours go before you block out your calendar.

Stage one: the spreadsheet

It starts innocently. Export twelve months of sales from your practice management system, export your current counts, and open a spreadsheet.

Then the columns start multiplying. Average daily use for each item. The standard deviation of its monthly sales, because the average alone hides the swings. A safety stock formula with a service-level multiplier in it. Lead time worked in. A reorder point at the end of the row, and an order quantity next to it.

None of these formulas is hard on its own. I've walked through every one of them in the beginner's guide. The problem is never one formula. The problem is one formula times 1,500 items, stacked on top of the data cleanup nobody warns you about: the duplicate item names, the mg strengths hiding inside the descriptions, the negative counts from missed charges.

By the time the math is right, you've spent hours and you haven't made a single decision yet.

Stage two: the pack-size hunt

Here's the part that surprises people. The spreadsheet says order 83 tablets. Nobody sells you 83 tablets. The bottle holds 100, or the box holds 30, or the case holds 12 tubes.

So every raw number has to be rounded to something a distributor will actually ship, which means knowing the pack sizes for every item on the list. Small pack, large pack, whether a liquid comes as a single bottle or a 12-pack of bottles. If you don't have those memorized, and nobody does past the first hundred items, you're flipping between the spreadsheet and a distributor catalog, one lookup at a time.

This stage is pure data entry, and it's the one that eats the most clock. It's also where most spreadsheet projects quietly die, because it has to be redone every time an item changes suppliers or a pack gets discontinued.

Stage three: the lumpy items, where the real detective work lives

Some items behave. Carprofen moves every day, the average is honest, and the formula lands on a number you can trust.

Then there are the items that leave the building in clumps. A seizure medication that sells zero, zero, zero, then 120 tablets in one afternoon because one patient refilled. An average smoothed across the year tells you to keep 11 on the shelf, which is precisely enough to fail that patient.

For these, the formulas don't just need computing. They need overruling. And the only way to overrule them well is to dig through the item's actual transaction history and answer a question the spreadsheet can't: what does one real fill look like? Is it 60? 120? Does the practice sell it in 5s or in 30s?

That's per item. Every chronic medication, every clinical batch seller, every diet a single patient depends on. It's guesswork wearing a detective costume, and it is genuinely mentally draining. This is the stage that turns a long afternoon into a full day, and it's the stage where good managers start doubting a method that is, in fact, correct.

The quiet tax: next month, the data has moved

Say you push through. The spreadsheet works, the shelves get sane, the stockouts fade. Here's the tax nobody prices in: your numbers age. Sales shift with the seasons, a doctor changes a protocol, one big patient moves away. The spreadsheet you built in January is quietly wrong by June, and refreshing it means paying most of that day again.

That's why so many practices try the data-driven approach once, keep the printout for a year, and drift back to ordering by eye. Not because the method failed. Because the method, done by hand, asks for a day a month that nobody has.

What the fix has to look like

I didn't want a different method. The method works. I wanted the same method with the labor taken out, which means four specific things:

1. The math runs itself. Daily use, deviation, safety stock, reorder point, order quantity, computed for the whole catalog at once from the exports you already have.
2. Pack sizes come suggested. The rounding to real bottles and boxes happens for you, with a database of common veterinary pack sizes doing the catalog-flipping.
3. The evidence sits at the decision. For the lumpy items, the last twelve months of dispenses appear right next to the input, as a picture, with a suggested minimum shelf quantity based on the largest real fill. You're still the one deciding. You're just not the one digging.
4. Decisions get remembered. The minimum you set for that seizure medication, the pack size you corrected, the item you told it to ignore: all of it carries into the next run automatically. The first analysis is the longest one you'll ever do, and it's minutes, not a day.

That list is StockSolve, because I built it to be that list. What used to cost me a full day now takes minutes, and the parts that still need my judgment come with the evidence already on the table.

If you're doing this by hand right now, I mean it when I say the method is worth it, and the reorder point and order quantity math is worth understanding no matter what tool you use. But the workload isn't a rite of passage. It's just a problem, and problems like that are what software is for.