Paste your SKU list and get the whole reorder picture in one go: reorder points, safety stock, EOQ order sizes, days of cover, turnover and exactly what to reorder today.
Paste a CSV or spreadsheet copy. First row = headers. Recognised columns: sku, name, demand, period, lead, onhand, onorder, cost, price, moq. .
| SKU / name | Avg demand | Per (days) | Lead time (days) | On hand | On order | Unit cost £ | Sale price £ | MOQ |
|---|
Demand is units sold over the period you set (e.g. 900 per 30 days). Everything recalculates as you type.
| SKU | Status | Safety stock | Reorder point | Order qty (EOQ) | Days cover | Turnover | GMROI | ABC |
|---|
Right now you're pasting numbers into a calculator. In an OpsMavix system, your live stock, sales and supplier lead times feed these calculations on their own, so the reorder list is already waiting for you each morning, the buffers apply themselves, and dead stock gets flagged before it costs you. We map exactly where your stock leaks time and cash, and build the system that plugs it.
Book a free Operations Leak Audit →daily demand × lead time + safety stock
The stock level that triggers a new order. When on-hand plus on-order falls to this number, buy, so replenishment lands before you hit zero. A reorder point without safety stock only works if demand and delivery are perfectly steady, which they never are.
Z × √(LT × σdemand² + demand² × σlead²)
The buffer that absorbs the two things that go wrong: a sales spike, and a late supplier. It scales with your service level (via Z) and with how variable your demand and lead times are. Set those sliders to match reality and the buffer stops being a guess.
√(2 × annual demand × order cost ÷ (holding rate × unit cost))
The order size that balances the cost of ordering too often against the cost of holding too much. Order below EOQ and you drown in POs; order above it and cash sits on shelves. We round up and honour your MOQ.
stock on hand ÷ daily demand
How many days the current shelf lasts at today's sales rate. When it's below the lead time, you're already too late to reorder without a stockout. The tool flags these as at risk.
annual demand ÷ average inventory
How many times a year a line sells through. Low turnover ties up cash and shelf space; the ABC column and dead-stock flag show you where it's happening so you can cut orders or clear it.
annual gross margin ÷ average inventory cost
GMROI shows the profit each pound of stock earns. ABC ranks every SKU by revenue share. Your A-lines deserve tight service levels and attention; your C-lines usually deserve less stock than they're getting.
This calculator is powered by a free, zero-dependency JavaScript engine, the same code that runs on this page. Use it in your own app, ops dashboard or spreadsheet replacement.
