KPIs for Warehouses and Fulfilment Centres
These are the KPIs a warehouse or fulfilment centre tracks for accuracy, speed and space. Order accuracy and cycle time describe service; storage use and labour productivity describe cost.
The KPIs to track
Order fill rate is the percentage of ordered quantity that was shipped from stock on the first attempt.
Formula and SQL query on the Order Fill Rate page.
Inventory accuracy is the share of counted items where the physical count matches the system record.
Formula and SQL query on the Inventory Accuracy page.
Order cycle time is the average time from a customer placing an order to receiving it.
Formula and SQL query on the Order Cycle Time page.
Perfect order rate is the share of orders that arrive on time, complete, undamaged and correctly invoiced.
Formula and SQL query on the Perfect Order Rate page.
OTIF is the share of orders delivered both on time and with the complete quantity ordered.
Formula and SQL query on the On-Time In-Full (OTIF) page.
Dock-to-stock time
The average time between a delivery arriving at the dock and the goods being available to pick.
Orders picked per labour hour
Orders or order lines picked divided by the labour hours spent picking.
Storage utilisation
Locations or space in use divided by the locations or space available.
Where the data usually lives
A warehouse management system, scanner and picking logs, carrier systems and labour scheduling.
Measurement mistakes to avoid
- Order lines and orders are different units; keep one for productivity comparisons.
- Peak periods distort averages; compare the same season year on year.
- Stock count adjustments hide errors if they are not logged by cause.
Questions to ask your data
You can type these as plain questions. SchemaChat turns each one into SQL against your connected database or uploaded file, runs it, and shows the SQL and the figures it used so you can check the answer before you share it. Check that the result matches how your business defines each KPI.
- What was order accuracy by shift last week?
- How long does goods-in take from dock to stock?
- What is storage utilisation by zone?
- How many orders were shipped late and why?