Turns 180 days of sales history into reorder points, safety stock and ready-to-send purchase orders, for a fictional outdoor-gear store with 36 SKUs and 4 suppliers. Change the service level and everything recalculates.
Click a row to filter the table.
What to send each supplier today.
| Product | Status | On hand | On order | Avg / day | Days cover | Safety stock | Reorder pt | Order qty | Order $ |
|---|
For each SKU, demand rate d and its variability σd come from the last 56 days of sales. Supplier lead time L has its own variability σL.
Safety stock = z × √(L·σd² + d²·σL²), where z is set by the service level (95% → 1.645). It covers both demand spikes and late deliveries.
Reorder point = d × L + safety stock.
Order quantity = the larger of EOQ (√(2·annual demand·order cost / holding cost)) and enough to reach reorder point + d × review cycle, rounded up to whole supplier cases. Stock already on order counts toward the position.
The same logic runs as a plain Python script (reorder_engine.py), so it can run nightly against a Shopify, ERP or Google Sheets export and email the POs.