Guide · Inventory

Days of supply and stockout risk: a weekly check for small manufacturers and brands

Lead Time Labs · November 2026 · 7-minute read

Inventory reports usually answer "how much do we have?" The more useful question is "how long will it last, and will the next delivery get here first?" Days of supply answers the first part. Comparing it with your open purchase orders answers the second. Together they give you a short, ranked list of the items that need attention this week.

Here's how to build that list with data most small manufacturers, distributors, and e-commerce brands already have.

What days of supply means

Days of supply (also called days of cover) is how many days your current stock will last at your normal rate of use:

Days of supply = on-hand quantity / average daily usage

If you have 300 units and use about 20 a day, you have 15 days of supply. It's simple, but it beats raw quantities because it puts every item on the same scale. Fifty units of a slow mover might be months of cover. Five hundred units of a fast mover might be a week.

Getting average daily usage right

The denominator matters more than the numerator. A few practical rules:

From days of supply to stockout risk

Days of supply alone doesn't tell you whether you're in trouble. Ten days of cover is fine if a delivery lands in four days, and a problem if the next PO isn't promised for three weeks. So compare two dates for each item:

  1. Projected stockout date = today + days of supply.
  2. Next inbound date = the earliest promised date on an open PO line for that item. If that date has already passed and the line is still open, treat it as arriving today at the earliest, and flag it, because that PO is already late.

Then classify:

RiskRuleWhat to do
HighStock runs out before the next PO is promised, or there's no open PO and cover is shorter than the supplier's lead timeExpedite, split-ship, or place an order today
MediumCover is below your safety-stock daysConfirm the next PO's date with the supplier
LowEverything elseNo action

The gap between the two dates, in days, is the best way to sort the list. An item that runs out 12 days before its PO arrives needs attention before one with a 2-day gap.

Why the PO side matters: most stockouts at small companies aren't caused by too little ordering. They come from a PO that was placed on time but slipped and nobody noticed. Tying inventory cover to open-PO promise dates catches that early.

Setting safety-stock days without a statistics project

Textbook safety-stock formulas need demand and lead-time variability. That's worth doing eventually, but a practical starting point is a few days of cover for each item, based on two questions: how variable is this supplier's lead time, and how bad is it if we run out? A component that stops a production line deserves more cover than packaging you can buy locally the same day. Use your lead-time variance by supplier to adjust: when the actual lead time regularly runs past the quote, add that slippage to the item's safety days.

Watch the other end, too

The same calculation flags excess. Items with very high days of supply, for example several months for something you can reorder in two weeks, tie up cash and shelf space. Sort the list the other way once a month and look for POs you can push out or cancel.

The weekly routine

  1. Refresh on-hand inventory, usage, and open POs.
  2. Review the High-risk list, sorted by gap days. Expedite or reorder.
  3. Review Medium items and confirm promise dates with suppliers.
  4. Check any open PO lines that are already past their promised date. Those feed straight into next week's risk list.

Done by hand in spreadsheets, this takes a buyer a few hours every week, which is why it often gets skipped. In Power BI, the list rebuilds itself on each refresh, and a simple flow can email the High-risk items every morning.

See it working

The live demo calculates days of supply and stockout risk on a sample dataset. You can filter by category and supplier region and sort the risk list by gap. Our Supply Visibility Sprint builds the same view on your own inventory and PO data in 3 to 4 weeks, at a fixed price.