Free toolsResources
All free tools
Inventory & Margin

Weeks of Supply Calculator

Weeks of Supply (WOS) is how many weeks your current on-hand stock will last at recent sales pace. It's the fastest read on whether an item is over- or under-stocked.

Your numbers
Result
8.0
Weeks of supply
Overstocked — cash tied up
Weeks of supply8.0 weeks
Days of supply56 days
vs. target+4.0 weeks
Excess units above target240 units
Formula: Weeks of Supply = On-hand Units ÷ Average Weekly Units Sold

How to use weeks of supply

WOS turns a raw inventory number into a decision. Set a target band per category (say 3–6 weeks). Items far above the band are overstocked — candidates for markdown, bundling or slower reordering. Items under 1–2 weeks are stockout risks that need a reorder now. It's the same signal that flags both dead stock and lost sales.

Set targets by lead time

Your target WOS should cover supplier lead time plus a safety buffer. If a vendor takes two weeks to deliver, a one-week target guarantees stockouts. Tie the target to real lead times and velocity, not a single number across the store.

Stop calculating one item at a time

AssortIQ computes this for every product and store automatically — and tells you what to do about it. Free for 7 days.

© 2026 AssortIQ. Built for grocery, retail & agriculture.