Latest Order Date Calculator

When to reorder inventory: the formula

Latest order date = today + (current stock − safety stock) ÷ daily sales − lead time. Read it right to left. Current stock minus safety stock is the inventory you are willing to sell down before the buffer gets touched. Divided by daily sales, that becomes the days until stock reaches the buffer line. Subtract the supplier lead time — the days a replenishment order spends in production and transit — and what remains is how long you can still afford to wait before ordering.

Add that count to today and you have the latest safe order date. Order on or before it, and new stock lands just as you reach the buffer. Order after it, and some stretch of stockout — or an emergency air-freight bill — is already locked in no matter how fast you move.

The calculator also returns the projected stockout date (current stock ÷ daily sales, added to today, assuming you never reorder) and your total runway in days. Deciding when to reorder inventory gets easier when the whole timeline is visible, not just the deadline.

What each input means, and where to get it

Four inputs decide when to reorder inventory, and all of them are available without special tooling. Getting them honest matters more than getting them precise.

• Current stock on hand: physically sellable units right now. Subtract anything reserved, damaged or committed to wholesale.
• Average daily sales: units sold over the last 30 to 90 days divided by the days in the window — recent enough to reflect how the product sells today.
• Supplier lead time: from PO sent to units sellable on your shelf, taken from actual recent orders rather than the supplier’s brochure.
• Safety stock: the buffer you refuse to dip below. Size it with the safety stock calculator if you have never set one deliberately.

Worked example: 320 units and a 25-day supplier

A skincare brand holds 320 units of its cleanser, sells 8 a day, keeps a 60-unit buffer, and its manufacturer takes 25 days door to shelf. Sellable-down stock is 320 − 60 = 260 units, which lasts 260 ÷ 8 = 32.5 days. Subtract the 25-day lead time and the brand has 7.5 days left to place the PO — the latest order date is about a week from today.

The other outputs frame the stakes. Runway is 320 ÷ 8 = 40 days, so the projected stockout date sits 40 days out. Forty days sounds comfortable; seven does not. That gap between how the situation feels and when the decision is actually due is exactly what this calculation exposes — and why gut feel about when to reorder inventory runs late so often.

Latest order date vs reorder point

A reorder point answers when to reorder inventory as a stock level: order when on-hand units fall to lead-time demand plus buffer. Same physics, different packaging — the reorder point assumes someone is watching the level, while the latest order date is a deadline that can sit in a calendar and interrupt you.

The two agree with each other. On the day stock touches your reorder point, this calculator reports zero days left — the latest order date is today. Use the level as an always-on trigger if you check stock daily; use the date if, like most small teams, you batch inventory work weekly and mostly need to know which week each PO must go out.

Mistakes that quietly move the deadline

The formula is stable; the inputs drift. Five habits produce most late orders.

• Using stale sales speed. After an ad push or a price cut, velocity rises and the deadline moves earlier — yesterday’s average buys you imaginary days.
• Quoting lead time from the supplier’s pitch instead of measuring door to shelf on real orders.
• Entering zero safety stock to make the date look further away. You are not gaining days, you are spending your insurance.
• Treating the date as fixed. It shifts every week demand shifts; re-run it before it feels due, not after.
• Confusing when with how much. Knowing when to reorder inventory does not settle order size — a PO below the supplier’s MOQ bounces back and eats days you no longer have.

One SKU is a calculator; forty is a spreadsheet problem

For a single hero product, re-running this page each week takes a minute and answers when to reorder inventory precisely enough. The failure mode arrives with the catalog: forty SKUs, each with its own velocity, buffer and supplier, and the deadline math silently stops being done for most of them.

That is the case the paid ShelfOwl forecaster handles: upload one CSV of sales and stock levels, get back a latest order date for every SKU plus an email reminder before each one comes due — $29 per month, 14-day trial, no card up front. The single-SKU calculator on this page stays free regardless.