Calculation guide
Inventory position is on-hand plus on-order stock minus backorders. Demand and lead time are constant; safety stock is supplied separately. Round the trigger up to whole units.
trigger = ceil(daily*lead+safety); lead_demand = daily*lead
Inputs
Average units used per day
Example entry 12.
Lead time in days
Example entry 5.
Safety stock in units
Example entry 20. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Average units used per day | 12 |
| Lead time in days | 5 |
| Safety stock in units | 20 |
| Result | Value |
|---|---|
| Reorder point in units | 80 |
| Expected lead-time demand | 60 |
Calculation steps
Reorder point in units = round up(((Average units used per day × Lead time in days) + Safety stock in units))
round up(((12 × 5) + 20)) = 80
Expected lead-time demand = (Average units used per day × Lead time in days)
(12 × 5) = 60
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Average units used per day | 12 | 13 | Reorder point in units | 80 | 85 |
| Lead time in days | 5 | 6 | Reorder point in units | 80 | 92 |
| Safety stock in units | 20 | 22 | Reorder point in units | 80 | 82 |
