Your stock levels, your supplier lead times, and your real sales velocity in one place — so the dashboard works out the reorder point for you instead of asking you to guess it. Everything saves to this browser. Nothing is uploaded anywhere.
These settings drive every calculation on the Reorder Engine tab.
Stock value broken down by supplier, largest first.
Three numbers, one decision. No formula to build, no cell to maintain.
The engine counts every sold movement for a SKU inside your velocity window and divides by the window length. That is its real daily sales rate — measured, not estimated.
Daily rate × that supplier's lead time gives the units you will sell while waiting for a delivery. Add your safety-stock days and you have the level at which you must place the order.
Quantity on hand divided by the daily rate tells you how many days until you hit zero — so a SKU with 400 units can still be more urgent than one with 40.
Your master product list. Every other tab reads from this table.
| SKU | Product | Supplier | Unit cost | Sell price | On hand | Stock value | Margin | |
|---|---|---|---|---|---|---|---|---|
| Totals | 0 | $0 | 0% | |||||
Every unit in and out. This log is what the Reorder Engine measures velocity from — the more honestly you keep it, the sharper the reorder points get.
| Date | SKU | Type | Qty | Balance after | Note |
|---|
The part a spreadsheet cannot do on its own: velocity measured from your own movement log, multiplied by each supplier's real lead time, turned into a live reorder point — and the same maths run backwards to find the cash frozen on your shelves.
Sorted by days of cover remaining. The top of this list runs out first.
SKUs with no sold movement inside your velocity window, and exactly how much cash each one is holding.
| SKU | Product | On hand | Sold/day | Lead time | Reorder point | Days of cover | Status |
|---|
Lead time is the number the Reorder Engine depends on most. Getting it right per supplier is what makes the reorder points trustworthy.
| Supplier | Lead time (days) | Min order qty | Contact | Notes |
|---|
Expected arrival is calculated from the order date plus that supplier's lead time.
| PO ref | Supplier | SKU | Qty | Order date | Expected | Status |
|---|
You're in the live demo. Unlock every tab, save your data, and keep it forever for a one-time purchase.
Get it on Etsy →