Portfolio demo · sample data

Inventory Reorder Dashboard

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.

SKUs with zero on hand
Suggested purchase orders
Cash tied up in > 120 days of cover

SKUs by status

Click a row to filter the table.

Suggested order value by supplier

What to send each supplier today.

Reorder plan

Click a product for its demand and stock projection
Product Status On hand On order Avg / day Days cover Safety stock Reorder pt Order qty Order $

How the numbers are calculated

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.