Skip to content
CodexValley

Stock Reorder Planner

Available

Find the reorder point and order quantity for each product from daily sales, lead time and safety stock.

Your list

Edit, add or remove entries. Everything is worked out in your browser and nothing is sent to our server.

The list is kept only in this browser so it is here when you come back. Turn this off on a shared or public computer, and use Export CSV to keep a copy.

Summary

About this tool

Find out when to reorder each product and how much to order. For every SKU, enter the stock you have, average daily sales, the supplier lead time, safety days and how long one order should last. The planner shows days of stock left and an order list, and your figures stay in this browser.

How it works

  • Reorder point is average daily sales times the lead time days plus safety days, rounded up to a whole unit.
  • Status says Order now when the product sells and the stock in hand is at or below the reorder point.
  • Suggested order is daily sales times the lead time, safety days and the days one order should last added together, minus the stock in hand, rounded up and never below zero.
  • Days of stock left is stock in hand divided by daily sales. Runs out first names the product with the fewest days left.

Common questions

How do I work out average daily sales?

Take the units sold over a recent period, such as the last 30 or 90 days, and divide by the number of days. Use a longer period for slow sellers and think about seasons.

What is safety stock in days?

Extra days of sales you keep in case sales jump or the supplier is late. With 3 sales a day and 5 safety days, the reorder point goes up by 15 units.

Why does a product with stock left say Order now?

Because the stock in hand will run out before a new order arrives and your safety days are used. Ordering at the reorder point gives the supplier time to deliver.

Your entries stay in your browser. They are not uploaded, and you can delete them at any time with Clear all.

Want more from these tools?

We are building Pro: saved history so you do not have to import your files again, monthly reports and more marketplaces. Join the waitlist and we will email you once when it is ready.

We only use your email to tell you when Pro is ready. See the Privacy page.