Days of supply calculator
Find out how many days your current stock will cover at today's demand, and how much time you have before the next purchase order is late. Use it per SKU, not for the warehouse as a whole.
Calculate days of supply
Use available stock only, not quarantined or held units.
- Days of supply
- 22.5
- Days left to place an order (negative means late)
- 8.5
Calculated in your browser. Nothing you enter is sent or stored.
Track the stock behind your plan.
Keep warehouse quantities, locations and movements in one workspace. Explore sample stock in the demo or start with your own items for free.
Free during open beta. No card. No sales call.
The formula
Days of supply = units on hand ÷ average daily demand; days left to place an order = days of supply − supplier lead time
- Units on hand
- Sellable units you hold now, in base units. Leave out stock on hold, in quarantine or damaged, and units already allocated to open orders.
- Average daily demand (units)
- Units shipped per day, averaged over a recent period of normal trading. Use calendar days if your lead time is in calendar days.
- Supplier lead time (days)
- Days from placing the purchase order to the stock being available to pick, including transit, receiving and putaway. Use observed receipt dates, not the quoted figure.
Worked example
Suppose you hold 1,260 units of serum SKU SER-030 and it sells 45 units a day. Days of supply is 1,260 ÷ 45 = 28.0 days. The supplier takes 21 days from order to shelf, so days left to place an order is 28.0 − 21 = 7.0. You have a week before the next order is late. If the lead time were 30 days instead, the result would be 28.0 − 30 = −2.0: the order should have gone out two days ago, and you will likely run short before stock arrives.
How to read days of supply
Days of supply answers two questions. The first is "how long will this last?" The second, once you subtract lead time, is "how long can I wait before ordering?" A positive result is slack. Zero means order today. A negative result means the gap is already there, and the order you place now will arrive after the shelf empties.
The second number is a simple version of a reorder point with no safety stock. If you want a buffer, subtract the days of cover you want to keep as well. For example, with 5 days of buffer, the SKU above has 7.0 − 5 = 2 days left instead of 7.
Days of supply vs inventory turnover
Both measure how stock relates to demand, but they answer different questions. Inventory turnover looks backward over a year and tells you how hard your inventory worked. Days of supply looks forward from today and tells you when you will run out.
For purchasing decisions, days of supply is more useful because it is per SKU and current. A high number flags overstock and cash tied up. A number close to or below lead time flags a coming stockout.
When days of supply misleads
- Seasonal or promoted items: an average from a quiet month will overstate cover right before a peak. Use expected demand for the coming weeks instead.
- Averages that include out-of-stock days: zero sales on empty days make demand look lower and cover look longer.
- Stock already on order: days of supply on hand ignores open purchase orders. If one is due in 10 days, you have more cover than the number says.
- Expiry: 90 days of supply on a product with 60 days of shelf life left is a write-off in waiting, not cover.
- Stock spread across warehouses: total days of supply can look fine while one site runs out.
Keeping days of supply current in a WMS
Both inputs change daily, which is why a number worked out in a spreadsheet goes stale fast. A warehouse system that records every shipment as a stock movement gives you actual demand, and stock statuses keep held units out of the on-hand figure.
In NextStock, the supplier catalog stores lead times per supplier item, and replenishment suggestions propose purchases and transfers based on demand and cover. Lot and expiry tracking shows whether the stock that makes up your cover will still be sellable when you need it.
Frequently asked questions
Short, direct answers to the questions warehouse teams ask most.
What is a good days of supply number?
It depends on the SKU. It should be at least the supplier lead time plus the buffer you want to hold, and not much more than you can sell before expiry or before the product goes out of season. Fast movers from reliable suppliers can run lower than slow movers from distant ones.
Should I use calendar days or working days?
Use the same kind of day for demand and lead time. If the supplier quotes 21 calendar days, divide demand by calendar days too. Mixing the two overstates or understates cover by a fifth or more.
What does a negative number of days left mean?
It means stock will run out before a new order can arrive. Order now, and look for ways to close the gap: a transfer from another warehouse, an expedited shipment or a partial delivery from the supplier.
Your next warehouse move starts here.
Create your own workspace for free, or explore a stocked demo without an account.