darikwaStock · Free · Works in your browser
Reorder planner
Paste your stock list with on-hand, on-order, recent sales and each supplier's lead time, minimum order and case pack. See how many days each product has left, the date to order by, and how many to order, by supplier.
It answers
- 1.How many days of stock each product has left.
- 2.The date each order has to go in by.
- 3.How many to order, rounded to the minimum order and case pack.
- 4.What this round of orders costs, by supplier.
Settings
Order now
4
At or below the reorder point
Order soon
1
Before the next ordering round
Units to order
325
Rounded to minimum order and case pack
Order value at cost
£2,912
3 suppliers
Days until each product reaches its reorder point
Order nowOrder soonOK
9 rows · example data, replace it with yours
| # | SKU | Status | Order by | Suggested order | Days on hand | Reorder point | Daily rate | Order value | Description | Supplier | On hand | On order | Units sold, last 30 days | Lead time (days) | Safety stock (days) | Minimum order | Case pack | Unit cost (£) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OK | 26 Feb | 0 | 94 | 36 | 1.3 | £0 | ||||||||||||
| OK | 21 Jan | 0 | 67 | 12 | 0.4 | £0 | ||||||||||||
| Order now | 19 Oct | 48 | 13 | 29 | 1.0 | £149 | ||||||||||||
| OK | 18 Feb | 0 | 95 | 12 | 0.4 | £0 | ||||||||||||
| Order now | 19 Oct | 96 | 28 | 71 | 1.3 | £595 | ||||||||||||
| Order soon | 29 Oct | 96 | 66 | 37 | 0.7 | £595 | ||||||||||||
| Order now | 19 Oct | 55 | 21 | 61 | 0.9 | £1,018 | ||||||||||||
| Order now | 19 Oct | 30 | 60 | 51 | 0.7 | £555 | ||||||||||||
| No sales | – | 0 | – | – | 0.0 | £0 | ||||||||||||
Take it into Excel
The download carries your rows and the same rules as live Excel formulas, so it keeps working as you add lines: yellow cells for your data, blue-grey cells calculated, drop-down lists, red and amber flags, frozen headers and filters. Tabs: Start here · Settings · Products (runway and orders) · Summary by supplier.
Your data never leaves this browser: nothing is uploaded, and the workbook is built on your device. Copy rows from Excel or Google Sheets and paste into any cell; include the header row to match columns by name.
Want this running on live data? Retail Loom does it over your shop platform, accounts and stock system, every day. See Retail Loom or get in touch.