Decision software for grocery chains

Fill rate

Fill rate is the share of the quantity requested by a store, customer or warehouse that is met from stock, measured by units, order lines or whole orders.

Unit: %Tracking frequency: Daily; weekly product group reportHigher is better

Also calledorder fill rate, line fill rate, sipariş karşılama oranı

Formula

Fulfilled (units, lines or orders) ÷ Requested (same unit) × 100
Unit fill rate
Units shipped ÷ Units requested.
Line fill rate
Order lines filled in full ÷ Total lines.
Order fill rate
Orders with every line filled ÷ Total orders; always the lowest of the three.

Calculator

Enter your own figures and the result updates instantly. The defaults are the figures from the worked example below.

Result%81

Worked example

How to read it, and what good looks like

The three bases can differ by more than fifteen points in the same week. The unit rate is pulled up when high-volume items are complete; the line rate shows which item went short; the order rate shows whether the customer got the whole order. The report states its base in the header, and any commitment is written into the contract on the same base.

Fill rate is the outcome; service level is the target. Service level is the probability of not running out during the lead time and feeds the safety stock formula; fill rate measures the past. Do not set one target for every product: set it by product group, weighing the cost of a stockout against the carrying cost of the extra safety stock. A 100% target multiplies safety stock for the last few points and costs more than it returns.

Calculate the rate daily and read it weekly by product group and store; unfilled lines feed the lost sales calculation. In Mindpera, Mind Send produces the unmet demand report by store and product and prepares a replenishment proposal for any store that drops below threshold; Mind Stock holds warehouse and store balances in one place. Where order and shipment data sit in different systems, installation brings them into a single model.

Where it misleads

  • The unit fill rate goes on the dashboard; high-volume items keep it high and the incomplete orders customers experience stay hidden.
  • Order lines cut back or cancelled up front because stock was short are removed from the denominator; the rate rises artificially.
  • A line closed with a substitute counts as filled; the margin and satisfaction effect of the substitution disappears.

Data you need

  • Order lines: quantity requested and original request
  • Shipment or delivery lines: quantity sent
  • Cancellation and substitution records
  • Warehouse and store stock balances

Mindpera products that calculate this KPI

Frequently asked questions

What is fill rate?
Fill rate is the share of requested quantity met from stock. On a unit basis, units shipped are divided by units requested; on an order basis, orders filled complete are divided by total orders. A fill rate figure quoted without its base cannot be compared, because the gap between bases can exceed fifteen points in the same period.
Should fill rate be measured by units or by orders?
By orders on the dashboard. The unit rate tends to produce good news: if high-volume items are complete, it looks high. Customers feel whether they received the whole order. Keep unit and line rates for root-cause analysis; together they show which items and which volumes are causing the problem.

Track fill rate on your own data

Mindpera runs this calculation every day by product, branch and category; a value that crosses its threshold lands on its owner as a task.