What should you order this week?
Upload a sales history and, if you have it, your current stock. You get a reorder point and an order quantity per product, the items that stopped selling, and purchase orders grouped by supplier. Every formula is shown, so you can check the numbers before you spend on them.
- Free
- No signup
- Runs in your browser
Sales history
What you sold and when. The longer the period, the steadier the answer.
Current stock, optional
Without it we can tell you the reorder point but not how much to order.
Your file stays on this device. This tool runs entirely in your browser. Your file is never uploaded, stored, or sent anywhere. You can disconnect from the internet and it still works.
Add a sales file to get started.
How it works
- 1
Add your sales
A line per sale or an already-summarised file both work, including the sales summary this site’s QuickBooks POS tool writes.
- 2
Add your stock
Optional. Without it you get reorder points; with it you get quantities, days of cover and a purchase order per supplier.
- 3
Set your lead time
Lead time, how long an order should cover, and the service level you want. The list reorders itself as you change them.
What it does not do
- It measures average demand. It does not model seasons, promotions or a product being launched.
- Minimum order quantities and pack sizes from your supplier are not applied.
- The purchase orders are drafts. Nothing is sent anywhere.
Questions
How is the reorder point calculated?
Daily demand is the units you sold divided by the number of days your file actually covers, not an assumed year. Safety stock is the service-level factor times daily demand times the square root of the lead time. The reorder point is lead-time demand plus safety stock. The order quantity brings you up to the reorder point plus the cover period, minus what you already hold.
What if I have no stock figures?
You still get demand per day, the reorder point and the ABC class for every product. You do not get an order quantity, because working one out from an unknown stock level would be the wrong answer wearing the right clothes. The page says so on every row rather than showing a zero.
What does the service level do?
It is the chance of not running out while you wait for the order. A higher level buys more safety stock, which costs money to hold, so it is a trade rather than a setting to max out. 95% is the usual starting point and is the default here.
How much history do I need?
Three months is enough to be useful and a year is better, because a short window turns one seasonal spike into a permanent trend. Products with only one or two sale lines are marked as thin history rather than given a confident forecast.
Does it handle seasonality?
No, and it says so rather than pretending. It measures average demand over the period you give it, so a file covering only your busy season will overstate the rest of the year and a file covering only your quiet season will understate it. Feed it a full year where you can, and treat the output as a starting list to review rather than an order to place unread.
When you want this every week
With your stock ledger and purchase orders in Vender, the reorder list is always current instead of being rebuilt from exports.