A stockout is not all or nothing, and what customers feel is how many units are short. This fill rate calculator takes the average lead time demand, its variation, your reorder point and the order quantity and shows the fill rate, the cycle service level, the safety stock and the expected units short per replenishment cycle, using a normal demand model.
How the calculation works
- Safety stock = reorder point − average demand during the lead time.
- z = safety stock ÷ standard deviation of lead time demand.
- Loss function L(z) = φ(z) − z × (1 − Φ(z)), where φ and Φ are the normal density and distribution.
- Expected shortage per cycle = standard deviation × L(z).
- Fill rate = 1 − expected shortage ÷ order quantity.
Example
Demand during the lead time averages 100 units with a standard deviation of 30. A reorder point of 130 gives a safety stock of 30 and z = 1.00. The cycle service level is 84.1 %, but the expected shortage is only 2.5 units per cycle, so with orders of 200 units the fill rate is 98.75 %.
Why it matters
Two products with the same service level can behave very differently if one orders in big lots and the other orders often. The fill rate counts the units, so it gives a fairer picture of what customers experience and lets you set the safety stock for a service target without holding more stock than you need.
Good to know
The fill rate is higher for larger order quantities because a given shortage is spread over more units. The model assumes normal demand and a fixed lead time and ignores backorders versus lost sales. Use the standard deviation of demand over the whole lead time, not per day. A target of 95 to 99 percent is common for stocked items, and the cost of extra safety stock rises quickly beyond that. Revisit the reorder point whenever demand or lead time changes.
Related tools
The reorder point calculator sets the trigger from a service level, the EOQ calculator finds the best order quantity, and the inventory turnover calculator shows how fast stock sells.