Fill rate

A customer orders ten lines, and you can ship nine of them today. That is nine out of ten, or 90 per cent. The share of what was ordered that you could ship from the stock you had is called the fill rate.

How fill rate is calculated

The calculation is what you shipped, divided by what was ordered, multiplied by 100. The question is what "what" means, and four answers are in circulation.

The line version counts order lines shipped complete against order lines received. This is the one for the warehouse, because it follows the work. The order version counts whole orders where every line went, and it is much harsher: one missing line out of twenty fails the order. The unit version counts pieces and the value version counts money. For the same week the four give four different answers, and the gap is not small.

So put the version on the report. Two departments quoting different fill rates at each other and both being right is a common and entirely avoidable argument.

There is no good number

A pharmaceutical wholesaler promising next-day delivery on forty thousand lines runs a different business from a furniture importer who orders a container once the orders are in. The first needs a fill rate in the high nineties and pays for it in stock; the second does not measure it in any way that means anything.

The comparison worth making is against your own target and your own previous year, broken down by product group. A site figure of 94 per cent usually means the A items are at 99 and a long tail is at 70, and only the second half of that sentence is something you can work on.

Worked example

A distributor receives 10,000 order lines in a week and ships 9,450 of them complete from stock. The line version is 9,450 divided by 10,000, which is 94.5 per cent.

Those 550 incomplete lines were spread across 240 of the week's 2,000 orders, so 1,760 orders went out complete. The order version is 88 per cent. Same week, same warehouse, two figures six and a half points apart, and both true.

Now look at where those 550 sat. If they concentrate on a handful of slow movers that each sell twice a month, it is a reorder point problem. If they are spread across the twenty best sellers, it is a forecasting problem, and no safety stock on the long tail will fix it. The figures here are an example.

What moves the number

  • Forecast quality on the fast movers. Most of the gap usually comes from a short list of items, and there the forecast matters more than the buffer.
  • The chosen service level. Fill rate cannot come out higher than your safety stock was sized to deliver. See service level.
  • Supplier reliability, not just supplier lead time. Three weeks that sometimes turn into five are harder to buffer than a dependable four.
  • Stock accuracy. Stock the system believes in and the shelf does not have creates a promised line that then fails at the pick face. See stock accuracy.
  • Allocation rules. When one channel takes the last units, the other channel's fill rate falls. That is a policy decision, and it should be taken on purpose.
  • Minimum order quantities. A supplier minimum that does not fit your demand pattern produces either dead stock or a chronic shortfall on the same item.

Frequently asked questions

Which version should we report?

The line version for the warehouse, because it follows the work. The order version for the conversation with sales, because it is what the customer experiences. Unit and value versions have their uses, but they flatter a business that ships short on small quantities of cheap items.

Is this the same as service level?

No. Service level is the target you set, and it decides how much safety stock you hold. Fill rate is what you actually achieved. One is a dial, the other a reading, and mixing them up is why safety stock gets blamed for a forecasting problem.

Do backorders count as filled once they ship?

Not in this figure. Fill rate asks what you could supply at the moment of the order. An item that went out three weeks later was a stockout the customer was patient about.

Why do our two reports disagree?

Almost always because one counts lines and the other counts orders, or because one measures at order entry and the other at despatch. Both are defensible; publishing them unlabelled is not.

Ready to see BizBloqs on your own process?

Book a demo and we will walk your warehouse and order flow end to end — inbound, storage, picking, shipping, returns — and tell you honestly what BizBloqs would change.

Two questions about your own operation

Book a demo