Use when inventory levels need threshold calculation, restock quantities need computing, or demand-based reorder recommendations are needed.
Computes reorder points, restock quantities, and safety stock for each SKU using velocity data, lead times, and seasonal demand signals. Produces recommendations only — never makes purchase commitments.
Invoke when:
Do NOT use for:
orders table. Adjust for upcoming seasonal events.references/formulas.md. Flag immediately if a top-20 SKU is below critical alert threshold.references/formulas.md.| Rationalization | Reality |
|---|---|
| "Daily velocity is roughly known, I'll skip the label" | Every figure needs explicit confidence label — confirmed or estimated. |
| "The international lead time is probably shorter this time" | Use conservative lead time estimates. Never assume a faster timeline. |
| "Low-margin SKU, I'll skip the safety stock calc" | If it serves a customer need, compute it regardless of margin. |
| "Marketplace fields aren't in the snapshot, I'll use on-hand only" | Note the missing fields explicitly; do not silently ignore them. |