INVENTORY

Inventory Days of Supply Calculator

Compare uncommitted stock coverage with replenishment lead time at a steady daily demand rate.

Days of supply calculator

Compare uncommitted stock coverage with replenishment lead time at a steady daily demand rate.

How it works

Adjust the example values to match your scenario.

YOUR RESULT LIVE CALCULATION
Available stock coverage
15days
COVERS ENTERED LEAD TIME
One less spreadsheet to keep open.
Uncommitted stock
1,500 units
Lead-time demand
1,200 units
Coverage less lead time
3 days
Lead-time stock shortfall
0 units

Steady demand only. Incoming receipts and safety-stock requirements are not included.

BEHIND THE NUMBER

How the calculation works

Committed stock is already reserved and excluded from available units. Compare the resulting coverage with your expected replenishment lead time. Any shortfall is the extra uncommitted stock needed to cover that lead time at the entered rate. Incoming orders, safety stock, and demand variability are not included.

Available units = on-hand - committed; days of supply = available units / expected daily demand

When this calculation helps

This is a snapshot of uncommitted stock at an assumed daily demand rate. It helps reveal whether the current pool covers an entered replenishment lead time before new supply is considered.

Check the interpretation

A receipt due after depletion does not protect the gap simply because it is on order. Use dated inventory projection for changing demand and receipts. Separate quality holds and expiry restrictions from units that are genuinely available to fulfill demand.

Use consistent time units for demand and lead time. Seasonal demand, expiration dates, backorders, and uncertain receipts require more detailed planning.

Worked example: Reorder Point and Safety Stock: A Practical Example

Good to know

Do incoming orders count?

No. This snapshot uses stock physically on hand, less commitments. Incoming orders may arrive after current stock is depleted and need a time-phased plan.

What does the lead-time shortfall mean?

It is the difference between lead-time demand and available stock, floored at zero. It is not an automatic purchase recommendation or a safety-stock estimate.