Lessons › Retail Supply Chain › Service and excess
Retail Supply Chain lesson
Fill rate and service level
Fill rate compares units shipped with units ordered.
Try this lesson free →The idea
Fill rate compares units shipped with units ordered:
Formulas
Shipped ÷ Ordered × 100Key points
Fill rateUnits shipped ÷ Units ordered × 100.
Service levelThe fill rate you promise, often 95% or more.
Why it mattersEvery unfilled unit is a lost sale or an unhappy customer.
Fill rate is how the business measures whether replenishment is working.
Practice
1. What's Canada's fill rate?
450 ÷ 600 × 100 = 75%2. In D4, work out Canada's fill rate: shipped ÷ ordered, as a decimal.
=C4/B43. Tap a market below the 95% service level.
Canada (75%) and Australia (92%).4. What's Australia's fill rate?
460 ÷ 500 × 100 = 92%Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →