Tuesday morning in a small stockroom. The flour shelf looks thin, but is that order today thin or next week is fine thin? Ask that question for every item on your shelves and your whole morning is gone. The shelf looks fine at a glance and that is exactly the problem. A shelf can look half full and still run out on Thursday, because how long stock lasts is not about how full the shelf looks. It is about how fast it moves.
The maths is simple enough for one item. Stock on hand divided by average daily use gives you days left. Say you have 60 bags of flour and you use 4 a day. That is 15 days. One division, one answer, done in your head. The trouble starts when you have forty items and each one moves at its own speed. Doing that division forty times, then working out when to reorder each one, is a morning nobody gets back.
That is the job I hand to a small free tool now, the Multi-Item Stock Days Left Calculator. You list your items with the stock on hand, the average daily use, the lead time from your supplier and a safety buffer if you want one. It sorts the whole list urgent first, so the item that runs out soonest sits at the top. Each row shows its days left, its run-out date, the date you need to reorder by, and the reorder point in units. The reorder by date is the part that saves you, because it counts backwards from the run-out date and subtracts the lead time and the buffer. Order by that date and the delivery lands before the shelf empties.
A worked example with real numbers
The tool has a built-in example, and it is a small shop list with a count date of 1 November 2026. Press Load example and you get three items with different stock, daily use, lead time and buffer. The maths looks like this.
Flour in 1 kg bags: 3 days left, run-out date 4 November 2026, reorder by 1 November 2026, reorder point 6 units, status Order now. Milk in 1 litre cartons: 7 days left, run-out date 8 November 2026, reorder by 5 November 2026, reorder point 6 units, status Reorder in 4 days. Paper napkin packs: 40 days left, run-out date 11 December 2026, reorder by 4 December 2026, reorder point 7 units, status OK.
Flour jumps to the top of the queue even though milk shares the same reorder point. Flour simply runs out first. The summary strip backs it up: the soonest reorder by date is 1 November 2026, with one item to order now and two more due within 7 days. Watch what the buffer does. Milk carries a 1-day buffer, so its reorder by date lands on 5 November, a day earlier than lead time alone would give. And the napkins look perfectly safe with 40 days left, yet the queue still pins them a firm reorder by date of 4 December. Nothing drifts.
That is the shape of a good stock morning. The flour goes on the order today, the milk goes on in four days, and the napkins wait until December. Without the queue you would probably order more flour first, because the flour shelf looks emptier, and you would be right about the flour and wrong about everything else. The queue is not about the flour. It is about the item you were not looking at.
The reorder by date is the one that saves you
Most people watch the run-out date, and that is the wrong date to watch. The run-out date is when the shelf goes empty at your current pace. The reorder by date is earlier: run-out minus lead time minus your safety buffer. Order by that date so new stock arrives before you run out, not after. Watching the run-out date and ordering on the last day is already too late, because lead time is the gap between ordering and restocking, and the reorder by date already subtracts it for you.
The formula is printed on the page, and it is simple enough to check by hand. Days left equals stock on hand divided by average daily use, rounded down, so the estimate stays cautious and you never think you have more time than you do. Run-out date equals the count date plus days left. Reorder by date equals run-out date minus lead time minus safety buffer. Reorder point equals daily use times lead time plus buffer. Units only, no prices anywhere. Today is filled in as the count date for you, and each row takes seconds to type.
The status column does the triage for you. Order now, reorder in a few days, or OK. On a busy morning you only need the top of the list. Copy the result or print the queue and it goes straight into the order book.
Paste a list instead of typing rows
If you already have the list in a spreadsheet, use the paste box above the rows. One item per line with the name, stock on hand, average daily use, lead time in days and an optional safety buffer, separated by commas or tabs. A name can contain commas as long as you keep the numbers last. Lines that do not parse are skipped and named by line number, and up to 200 items can be built at once. Building the rows replaces whatever is in the table, so paste the full list in one go.
That is how a forty-item stockroom becomes a five-minute job. The list comes out of the spreadsheet, the queue comes back sorted urgent first, and the morning is yours again. Bad lines get named instead of breaking the list, so a typo in one row does not cost you the other thirty-nine.
Three mistakes I kept making
Ordering everything at once was the first. It feels safe, but it ties up cash and shelf space. Most items are fine for weeks, so order only what the queue flags, starting with the Order now items. Watching the run-out date and ordering on the last day was the second, and it is already too late by then. Lead time is the gap between ordering and restocking, and the reorder by date already subtracts it. Skipping the safety buffer was the third. No buffer assumes deliveries never slip and sales never spike. A buffer of one or two days costs almost nothing and stops a small delay turning into an empty shelf, and you can leave it at zero if you prefer a tight schedule.
Days left is the number most stock systems hide behind a value in pounds. But a small shop does not run out of money, it runs out of units. Stock on hand divided by daily use is the number that tells you when the shelf is actually empty, and a reorder point in units tells you when to act, not when to panic. That is the number I want on a Tuesday morning, and it is the number the queue puts in front of me.
Questions I get asked
How is days left calculated? Days left is your stock on hand divided by your average daily use, rounded down, so 6 units at 2 units a day gives 3 days left. Rounding down keeps the estimate cautious, so you never think you have more time than you do.
What is the difference between the run-out date and the reorder by date? The run-out date is when the shelf goes empty at your current pace. The reorder by date is earlier: run-out minus lead time minus your safety buffer. Order by that date so new stock arrives before you run out, not after.
Can I paste a list of items instead of adding them one by one? Yes. Paste the list with each item's stock, daily use, lead time and buffer, and the calculator reads it in one go. Bad lines are skipped with a note instead of breaking the list.
If your mornings still start with a walk around the shelves and a guess, give the list to the tool and keep the morning for the work that actually needs you. The shelves will still be there tomorrow. The question is whether they will still be full.
Top comments (0)