When to reorder lab supplies, item by item

Each item's reorder level comes from how much it is really used, how much that use swings from month to month, and how long its deliveries actually take. Pick an item, type a stock count, and see whether to order and how much.

Synthetic data: 150 invented supplies and 24,548 stock movements for a fictional lab network's central store, Oct 2025 – Sep 2026. The method is the one I built for a real central store; the figures are not real.

Check one item

Filled in with the example count at 30 Sep 2026. Type your own numbers.

Issued each month, Oct 2025 – Sep 2026 (line = average)

How these numbers are worked out
  1. Average use per day = total issued in the 12 months ÷ 365.
  2. Delivery time = the typical (median) days from raising a purchase order to receiving it, from this item's own orders. 30 days if it has none.
  3. Safety stock = safety factor (1.64 for 95%) × month-to-month swing in use × √(delivery time ÷ 30.4 days).
  4. Reorder level = use per day × delivery time + safety stock.
  5. Maximum stock = reorder level + one order (months of use). Order now = maximum − (on hand + already ordered).

The purchase list from the 30 Sep 2026 stock count

ItemOn hand + orderedReorder levelOrder nowDelivery (days)

Uses the settings above. Click a row to open that item.