Skip to main content
eECOMCAOutsourced Finance Team
Menu

Inventory Reorder Calculator

See when to reorder each SKU, how much to order, and how much cash is sitting in slow-moving stock.

Reviewed by CA Apurav GargUpdated Worked out in your browser; rows are saved in this browser only

On this page

Calculator

Note:
Example values — replace with yours.

Settings for every SKU

Enter sales as

How often you place orders. The order-up-to level covers this many days.

A SKU with more days of stock than this counts as slow-moving.

Your SKUs

One row per SKU, up to 200. On order = stock arriving within the lead time. Blank safety stock, on order or MOQ count as none.

SKUs and stock figures
Paste from Excel / Google Sheets

Copy eight columns from your sheet, in this order — SKU, sales, lead time, safety days, stock, on order, unit cost, MOQ — and paste them here. A header row is fine. Sales are read as an average a day.

Saved on this device only. Nothing is sent to us.

Your result

SKUs to reorder now

1of 3 SKUs

The suggested orders need ₹3,75,000. ₹5,60,000 (75.7%) of the cash in stock is in 1 slow-moving SKU.

Cash in stock
₹7,40,000
Cash in slow movers
₹5,60,000 (75.7%)
Cash for the suggested orders
₹3,75,000
SKU by SKU
SKUDays of coverStock + on orderReorder nowOrder-up-toSuggested qtyCash for orderStock-out dateCash in stockSlow mover
SKU-A15.0 days1,200900Yes2,4001,500₹3,75,00016 Jan 2000₹1,50,000No
SKU-B280 days2251,400No3750₹07 Oct 2000₹5,60,000Yes
SKU-C16.7 days264700No6240₹017 Jan 2000₹30,000No

Reorder point = daily sales × (lead time + safety days). Reorder now when stock + on order is at or below it; the suggested quantity tops up to daily sales × (lead time + review period of 30 days + safety days), rounded up to the MOQ. Stock-out date = today + whole days of cover, if nothing arrives. Slow mover = more than 180 days of cover.

What this tells you

Running out of a fast seller loses sales and can hurt your ranking on a marketplace; ordering too much of a slow one ties up cash that could pay suppliers or fund ads. This calculator works out, SKU by SKU, when to reorder and how much, from your own sales, lead times and stock.

It also adds up the cash sitting in stock and how much of it is in slow-moving SKUs — the stock that would take longer than your threshold to sell at today’s pace.

Assumptions used

  • Average daily sales stay at the figure entered; seasonality, promotions and trends are not forecast.
  • Supplier lead time is the same for every order of a SKU, and stock on order arrives within that lead time.
  • Blank safety stock or on order counts as zero; a blank MOQ means the suggested quantity is rounded up to whole units only.
  • A SKU with no recent sales (average daily sales of zero) is never suggested for reorder; it counts as a slow mover if it holds stock.
  • Cash in stock is current stock × unit cost; stock on order is not included.
  • The stock-out date assumes nothing new arrives, and uses today’s date on your device.
  • Rows are saved in this browser only and are not sent anywhere.

How this is calculated

  1. Average daily sales = the figure entered, or units sold in the last 30 days ÷ 30.
  2. Days of cover = current stock ÷ average daily sales.
  3. Reorder point = average daily sales × (supplier lead time + safety days).
  4. Reorder now when current stock + on order is at or below the reorder point.
  5. Order-up-to level = average daily sales × (lead time + review period + safety days).
  6. Suggested quantity = order-up-to level − (current stock + on order), rounded up to a multiple of the MOQ or case pack — only for SKUs to reorder now; otherwise zero.
  7. Stock-out date = today + whole days of cover.
  8. Cash in stock = current stock × unit cost. A SKU is a slow mover when its days of cover are above the threshold.

Worked examples

Example: three SKUs, review every 30 days, slow above 180 days

  • SKU-A: reorder 1,500 units now

    Sells 40 a day, lead time 20 days, safety 10 days, stock 600, on order 300, unit cost ₹250, MOQ 500. Reorder point 40 × (20 + 10) = 1,200; cover 15.0 days; stock + on order 900 is at or below it. Order-up-to 40 × (20 + 30 + 10) = 2,400; 2,400 − 900 = 1,500, rounded up to the MOQ = 1,500 units (₹3,75,000).

  • SKU-B: no reorder · slow mover

    Sells 5 a day, lead time 30 days, safety 15 days, stock 1,400, on order 0, unit cost ₹400, MOQ 200. Reorder point 5 × (30 + 15) = 225; cover 280 days; stock + on order 1,400 is above it.

  • SKU-C: no reorder

    Sells 12 a day, lead time 15 days, safety 7 days, stock 200, on order 500, unit cost ₹150, MOQ 300. Reorder point 12 × (15 + 7) = 264; cover 16.7 days; stock + on order 700 is above it.

Totals: ₹7,40,000 in stock, of which ₹5,60,000 (75.7%) is in slow movers; ₹3,75,000 needed for the suggested orders; 1 SKU to reorder now.

Our MIS & Reporting service reports stock cover, ageing and the cash tied up in stock alongside the monthly accounts.

Questions sellers ask

What is a reorder point?

The stock level at which you place the next order. Here it is your average daily sales × (supplier lead time + safety days): enough stock to keep selling while the order is on its way, plus a cushion for late deliveries or a sales spike.

Why is “on order” counted, but only stock arriving within the lead time?

Stock already ordered will arrive before a new order would, so it counts towards what you have. An order due after the lead time would not help you avoid a stock-out before the next delivery, so leave it out.

How do I pick the safety stock days?

Think about how late your supplier has been and how much your sales swing from week to week. A supplier who is often a week late needs more safety days than one who is always on time. Start with a figure you are comfortable with and adjust it after a few cycles.

What is the review period?

How often you place orders — for example every 30 days. When a SKU needs reordering, the suggested quantity tops it up to enough stock to cover the lead time, the review period and the safety days, so it lasts until the next time you order.

Why does a SKU with no recent sales show no reorder?

With zero average daily sales there is nothing to forecast, so the calculator never suggests reordering it and shows “No recent sales” instead of days of cover. If it still holds stock, it counts as a slow mover, because that stock is not turning into cash.

Are my SKUs saved or sent anywhere?

Your rows are saved in this browser only, so they are still here when you come back on the same device. Nothing is sent to us. Use “Clear all rows” to remove them.

Want our team to check these numbers against your actual settlement reports?

We reconcile marketplace settlements, GST and TDS for D2C and marketplace sellers every month. Share your reports and we will walk you through what we find.

Contact usWhatsApp us

Related

Disclaimer

A planning estimate for general information only, based on the figures you enter. It is not professional advice. Sales, lead times and supplier terms change; check the suggested orders against your own records before placing them.

Report a problem with this calculator