Reorder Point + Safety Stock Calculator

How it works

Classification drives the whole model: once a SKU is placed in the ABC times XYZ matrix, its service level, safety stock, and reorder point all follow automatically.

1. ABC-XYZ Matrix: The service-level matrix. Editable target service levels for each ABC times XYZ combination
2. SKU Calculator: The main engine: 20 SKUs across 37 columns covering inputs, classification, safety stock, reorder point, and order quantity
3. Method Comparison: Four safety stock methods compared side by side for any SKU you choose
4. Dashboard: The weekly review starting point: KPI tiles and reorder priorities
5. Z-Score Reference: A service-level to Z-score lookup table

Steps to use it

1. Edit only the blue cells in SKU Calculator; on-hand, on-order, and in-transit update from your inventory system each cycle
2. Let ABC, XYZ, and service level recalculate automatically: no need to set them per SKU
3. Adjust the ABC times XYZ matrix if you want different service-level targets
4. Use Dashboard as your weekly review starting point

Safety stock uses the combined-variance formula, accounting for variability in both demand and supplier lead time rather than just one or the other. Reorder point adds a review-period buffer for operators who check inventory on a cycle instead of continuously. Order quantity is constrained to clear your supplier’s MOQ and round to packaging lot size.