Spark Inventory
Free inventory tool

Weeks of supply calculatorformula, days of supply and order size

Weeks of supply tells you how long your stock lasts at the rate it is selling. Enter recent sales and stock on hand to get weeks and days of supply, and how much to order to reach a target.

Sales window

The starting numbers are example values, not Spark data. Replace them with your own.

Weeks of supply

12weeks

At 50 units a week, your stock on hand lasts about 84 days.

Average weekly sales

50 units

Days of supply

84

Weeks of supply = units on hand ÷ average weekly sales. Days of supply = weeks × 7.

The weeks of supply formula

How to calculate weeks of supply

Average your weekly unit sales over a recent window, then divide the units on hand by that rate. Add units on order to see how long stock lasts once they arrive.

Weeks of supply = units on hand ÷ average weekly unit sales

Units to order = (target weeks × weekly sales) − on hand − on order

A target in weeks comes from your lead time, how often you order and your buffer. Size the buffer with the safety stock calculator and the trigger with the reorder point calculator.

Worked example (illustrative numbers)

  1. 1. Weekly sales. 400 units sold over the last 8 weeks: 400 ÷ 8 = 50 units a week.
  2. 2. Weeks of supply. 600 units on hand: 600 ÷ 50 = 12 weeks, or 84 days.
  3. 3. Order to a target. With 100 units on order and a 20 week target: (20 × 50) − 600 − 100 = 300 units to order.

Past sales assume the next weeks look like the last ones. If a busy season is coming, 12 weeks of supply at last month’s pace can run out in 6.

Demand ESP

Weeks of supply for every SKU, from the forecast

A spreadsheet divides by last month. Spark Inventory divides by what each SKU is forecast to sell, in every warehouse, and keeps the number current as orders come in. See how the demand forecasting software picks a method for each SKU.

Forward weeks, not past weeks

Days on hand divides available stock by the planning rate: the higher of the Demand ESP forecast and recent sales, so stock ahead of a busy season is not overstated.

Seasons and promotions included

Each SKU gets its own seasonal curve, borrowed from similar items when it has less than a year of history, and Demand Calendar events lift or lower the forecast for a set window.

Stockouts do not shrink demand

Sales lost while an item was out of stock are added back before forecasting, so a stockout does not make the next weeks of supply look longer than they are.

Honest when the data is thin

Days on hand is hidden when there is no real demand signal, shown as a range for lumpy demand, and labeled when it rests on your own estimate instead of sales.

Excess flagged and priced

Stock beyond 180 days of supply counts as excess by default (you can retune the bands). It lowers the item’s health score and is shown as a monthly carrying cost.

Orders sized to the forecast

Reorder recommendations net stock on hand and on order against each SKU’s forecast, and a reorder rule can draft the purchase orders for you to approve.

Weeks of supply FAQ

Weeks of supply questions

Checking how fast stock sold through instead? Use the sell-through rate calculator.

What is the weeks of supply formula?+

Weeks of supply = units on hand ÷ average units sold per week. With 600 units in stock and sales of 50 units a week, you have 12 weeks of supply. Add units already on order to the top of the formula to see how long stock lasts once they arrive.

How do you calculate weeks of supply?+

Total the units sold over a recent window, such as the last 4, 8 or 13 weeks, and divide by the number of weeks to get average weekly sales. Then divide units on hand by that weekly rate. Use the same window for every product so the results compare, and leave out weeks when the item was out of stock, since they understate real demand.

What is forward weeks of supply?+

Forward weeks of supply divides stock by forecast sales for the coming weeks instead of past sales. It matters when demand is changing: before a peak season, past sales make stock look like it lasts longer than it will. Spark Inventory uses the forward view, based on each SKU’s Demand ESP forecast.

How many weeks of supply should I keep?+

Enough to cover your supplier lead time plus your safety stock, plus the time between orders. A product with a 4 week lead time that you order every 2 weeks, with 1 week of safety stock, needs about 7 weeks at the moment you place an order. Far more than that usually means cash tied up in overstock.

Is weeks of supply the same as days of supply or weeks on hand?+

They measure the same thing in different units. Days of supply = weeks of supply × 7. Weeks on hand and weeks of cover are other common names. Retail planners often say weeks of supply, while warehouses and finance teams often say days on hand.

How does Spark Inventory track weeks of supply?+

Spark shows days on hand for every SKU and warehouse, using the higher of the Demand ESP forecast and recent sales as the planning rate. It hides the number when there is no real demand signal, shows a range when demand is lumpy, and counts stock past 180 days of supply as excess by default (you can change the bands). Reorder recommendations net stock on hand and on order against the forecast.

Free for one user

Stop recalculating weeks of supply by hand

Connect your sales history and Demand ESP forecasts every SKU, shows how long its stock lasts, and turns it into monthly reorder recommendations.

  • Free: per-SKU Demand ESP forecasts and seasonal curves
  • Free: stock-risk reports and monthly reorder recommendations
  • Solo ($99/mo): continuous forecasts, live alerts and Text with Sparki