The hidden margin leak in reagent distribution

For an IVD distributor, the most expensive inventory mistakes never show up as a line item called "mistake." They show up as expiry write-offs and missed orders — and they're the same decision.

Ask a diagnostics distributor where their margin goes and they'll point to supplier pricing, FX, or a hard customer negotiation. Those are real. But there's a quieter leak that rarely gets named, because it's spread thinly across hundreds of SKUs and two opposite-looking problems.

The first problem is over-ordering. Reagents and many lab consumables have a short, hard shelf life. Order more than a hospital or lab will consume before the expiry date, and the surplus doesn't just sit there — it expires. The write-off is a direct cash loss, and on top of it you carry the cost of disposing of physical medical stock. It feels like prudence at the time ("better not run short"), and it's invisible until the lot turns.

The second problem looks like the opposite: under-ordering. Run short on a fast mover and you miss the sale — but in diagnostics it's worse than a missed sale. A hospital can't run that test. You've lost the margin and damaged a service relationship your customer will remember at renewal.

Here's the part that makes it hard: these aren't two separate problems you can fix one at a time. They're the two failure modes of a single recurring decision — how much of each SKU to order this cycle. Push the quantity up to avoid stockouts and you create expiry risk. Pull it down to avoid write-offs and you create stockout risk. Every SKU sits somewhere on that knife edge, and the right point is different for each one and moves over time.

Why a spreadsheet can't hold it

A spreadsheet and an experienced procurement manager can hold this for a handful of SKUs. The trouble is scale. A distributor managing a few hundred active SKUs is making a few hundred of these knife-edge calls every cycle, each one shaped by demand velocity, current stock, lot-level expiry dates, seasonality, and bundle constraints. No one can hold that many moving variables in their head, and a spreadsheet flattens exactly the dimension that matters most: when each specific lot expires relative to how fast it's actually selling.

That last point is the crux. Expiry risk is not a product-level fact — it's a lot-level fact. The same SKU can have an old lot quietly heading for write-off sitting right next to fresh stock that's selling fast. A product-level view averages those together and hides the risk. Managing shelf life properly means reading expiry at the lot level and letting it actively pull back the recommended quantity when a SKU is at risk of expiring before it sells.

The fix isn't automation — it's a better-informed human

The instinct, once you see the problem, is to automate the order. We'd argue the opposite. The procurement manager holds context the data never sees: a forward commitment, a customer-specific arrangement, a supplier relationship. The goal isn't to replace that judgment — it's to arm it. A good order decision-support tool surfaces every signal (velocity, days of stock, expiry risk, margin) with the reasoning attached, recommends a quantity, and then leaves the final call exactly where it belongs.

Done that way, the hidden leak stops being invisible. Each recommendation can be defended, each override is deliberate, and the two-sided loss — money rotting on the shelf, margin you never earned — finally becomes something you can see and manage cycle by cycle.