Inputs
Results
| SKU | d/day | L (days) | σd/day | σL (days) | Svc Lvl | z | DLT | σLT | SS | ROP | Review (days) | Target | On‑Hand | Open PO | Order Qty |
|---|
Example & Saved Scenarios
Three example rows are provided. Add your scenarios using the “Add to Table” button. Edit inputs directly and click Recompute to refresh outputs.
| SKU | Avg Demand | Unit | Lead Time (d) | σd | σd Unit | σL (d) | Svc % | Use LT Var | Review (d) | z | DLT | σLT | SS | ROP | Target |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A-Widget | 120 | week | 10 | 35 | week | 2 | 95 | yes | 0 | — | — | — | — | — | — |
| B-Gadget | 30 | day | 7 | 8 | day | 0 | 99 | no | 14 | — | — | — | — | — | — |
| C-Spare | 400 | month | 21 | 120 | month | 4 | 90 | yes | 0 | — | — | — | — | — | — |
Formulas Used
Notation — d: average demand per day; L: lead time (days); σd: std dev of demand per day; σL: std dev of lead time (days); z: service level factor.
Demand during lead time: DLT = d × L
Std dev during lead time (when demand & lead time vary independently):
σLT = √( L × σd2 + d2 × σL2 )
Std dev during lead time (only demand varies):
σLT = σd × √L
Safety stock: SS = z × σLT
Reorder point: ROP = DLT + SS
Periodic review target level: Target = d × (L + R) + SS, where R is review period (days).
z corresponds to the cycle service level (probability of no stockout during lead time). Typical values: 90%→1.2816, 95%→1.6449, 97.5%→1.96, 99%→2.3263, 99.9%→3.0902.
How to Use This Calculator
- Enter your average demand and unit (per day, week, or month). The tool converts to a daily basis automatically.
- Enter lead time (days) and the standard deviation of demand using the same unit you selected for average demand.
- Optionally enter the standard deviation of lead time and keep “Include lead time variability” checked to use the combined-variance formula.
- Choose the desired service level or switch to custom z. Click Calculate to see ROP and safety stock.
- For periodic review, set a review period (days) to compute a target order-up-to level.
- Use Add to Table to save a scenario, then export results as CSV or PDF.
FAQs
Disclaimer: results are for planning support only. Validate with your data quality, business rules, and supplier constraints.