Fill Rate Calculator
Calculate order/line fill rate and service level from safety stock. Measures order fulfillment performance through fill rate (% of orders shipped complete) and…
Measures order fulfillment performance through fill rate (% of orders shipped complete) and calculates service level from safety stock using Z-score probability. Key metrics for supply chain KPI dashboards.
What is Fill Rate and How Does It Differ from Service Level?
Fill rate measures the percentage of customer demand that is immediately satisfied from available stock. Order fill rate tracks complete orders shipped; line fill rate tracks individual line items fulfilled. Both are key supply chain KPIs indicating customer service performance.
Service level (cycle service level) is the probability of not stocking out during a replenishment cycle, derived from safety stock and demand variability. While related to fill rate, they measure different things: a 95% service level typically results in a 97-99% fill rate because stockouts usually affect only a fraction of demand.
Fill rate is the more customer-facing metric and directly impacts customer satisfaction and retention. Service level is more useful for inventory planning. Best practice is to track both and set targets by product category — e.g., 99% fill rate for A items, 95% for B items.
Formula: Order Fill Rate = Orders Shipped Complete / Total Orders × 100% Line Fill Rate = Lines Filled / Total Lines × 100% Z-Score = Safety Stock / σ_DDLT Service Level = Φ(Z) [cumulative normal distribution]
Example Calculation
Out of 200 orders, 186 were shipped complete. Order fill rate = 186/200 = 93.0%. For service level: safety stock = 120 units, demand std dev during lead time σ = 52 units. Z = 120/52 = 2.31. Service level = Φ(2.31) = 98.96%.
When to Use This Calculator
- A supply chain KPI dashboard builder calculating fill rate metrics for monthly performance reviews
- An inventory planner converting safety stock levels to expected service levels for management reporting
- A logistics manager benchmarking order fulfillment performance against industry standards or SLA targets
- A warehouse operations team diagnosing whether poor customer satisfaction stems from inventory shortages or other fulfillment issues
Common Mistakes to Avoid
- Confusing fill rate with service level — they measure different things; a 95% service level does not mean 95% of units are delivered on time; fill rate is typically higher
- Measuring only order fill rate when line fill rate is more actionable — order fill rate drops to zero if any single line is short, masking that 95% of items were actually available
- Not segmenting fill rate by product category — aggregate fill rate can hide poor performance on critical A-items behind strong performance on less important C-items
- Using the wrong demand standard deviation for service level calculation — use the standard deviation of demand during lead time (DDLT), not just daily demand variability
How to Interpret Results
- If fill rate is high but order fill rate is low, you likely have broad but shallow stockouts affecting many orders — improve availability of a few chronic problem SKUs
- If service level exceeds 99% but fill rate is below 95%, the issue is likely concentrated in a few high-frequency items — focus safety stock investment there
- A stockout probability of 5% means roughly 1 in 20 replenishment cycles will experience a shortage — for weekly ordering, that is about 2-3 stockout events per year
Related Standards & References
- APICS/ASCM Dictionary — distinguishes cycle service level (Type 1: probability of no stockout per cycle) from fill rate (Type 2: fraction of demand met from stock)
- Silver, Pyke & Peterson — defines the fill-rate (β service level) formulation via expected shortage per replenishment cycle
- Order fill rate vs unit fill rate — line-level and order-level availability metrics commonly written into distribution SLAs
Frequently Asked Questions
Why can service level be high while fill rate is low?
Service level measures the probability of ANY stockout during a cycle, while fill rate measures the PROPORTION of demand met. A single stockout event (lowering service level) might only affect 2% of unit demand (high fill rate). Conversely, a warehouse with 95% service level across 100 SKUs may have disappointing order fill rate if multi-SKU orders frequently have at least one item out of stock.
What is a good fill rate target for e-commerce?
Top e-commerce companies target 97-99% line fill rate. Amazon aims for 99.5%+ on Prime items. For most businesses, 95% order fill rate is the minimum acceptable level. Improving from 95% to 99% typically requires 40-60% more safety stock investment, so the cost-benefit analysis is critical.