Supply Chain & InventoryFree referencePDF, Excel, Word export

Warehouse KPI Formulas and Definitions Reference

Most warehouse arguments about performance are arguments about definitions. This reference lists the common warehouse KPIs with one clear formula each, the unit and the pitfalls that lead to bad comparisons.

Download:

KPI	Area	Formula	Unit	What it tells you	Common pitfall
Receiving accuracy	Receiving	Lines received matching PO and ASN / total lines received x 100	percent	How clean inbound data and counts are	Counting by shipment hides line-level errors
Dock to stock time	Receiving	Time stock is available in WMS minus time truck is checked in	hours	How fast inbound becomes sellable	Measuring from unload instead of check-in hides yard wait
Putaway accuracy	Receiving	Putaways to the correct location / total putaways x 100	percent	Whether stock is where the system says	Not scanning the location confirm makes it unmeasurable
Putaway cycle time	Receiving	Putaway task completion time minus task creation time	minutes	Lag between receipt and storage	Averages hide long tails; track the 90th percentile
Inventory accuracy (location)	Inventory	Locations counted with zero variance / total locations counted x 100	percent	Reliability of bin-level stock	Item-level and value-level accuracy give different answers
Inventory turnover	Inventory	Cost of goods sold / average inventory value	turns per year	How fast inventory cycles	Seasonal businesses need monthly or rolling views
Days on hand	Inventory	Inventory on hand / average daily usage or shipments	days	Coverage of current stock	Spiky demand makes a flat daily average misleading
Shrinkage rate	Inventory	(Book inventory value - counted value) / book inventory value x 100	percent	Loss from theft, damage and process error	Timing of cycle counts versus receipts can distort a month
Space utilization	Capacity	Occupied locations / total usable locations x 100	percent	How full the storage is	Blocked, reserved or damaged locations may be counted as usable
Cube utilization	Capacity	Volume of stored goods / available storage volume x 100	percent	Use of vertical and cubic space	Needs reliable item dimensions to be meaningful
Order picking accuracy	Picking	Order lines picked correctly / total order lines picked x 100	percent	Quality of the pick process	Customer complaints undercount errors; use audit data too
Lines picked per labor hour	Picking	Order lines picked / direct picking labor hours	lines per hour	Picker productivity	Compare only within the same pick method and zone
Units picked per labor hour	Picking	Units picked / direct picking labor hours	units per hour	Productivity with quantity weighted in	Case and each picks should be tracked separately
Order cycle time	Fulfillment	Time shipped minus time order released to the warehouse	hours	Speed through the building	Start time must be consistent between sites
On-time shipping	Fulfillment	Orders shipped by the promised ship date / total orders shipped x 100	percent	Reliability against commitments	Using the warehouse cutoff date instead of the customer date
Order fill rate	Fulfillment	Orders shipped complete / total orders x 100	percent	Share of orders delivered in full	Do not confuse with line fill rate or unit fill rate
Line fill rate	Fulfillment	Order lines shipped complete / total order lines x 100	percent	Line-level availability	Looks better than order fill rate on multi-line orders
Backorder rate	Fulfillment	Order lines backordered / total order lines x 100	percent	Stock availability gaps	Rescheduled lines may not be counted as backorders
Perfect order rate	Fulfillment	Orders on time, complete, undamaged and with correct documents / total orders x 100	percent	End-to-end quality of delivery	Each condition multiplies, so define each one clearly
Damage rate	Quality	Units or orders damaged / total units or orders shipped x 100	percent	Handling and packaging quality	Carrier damage found later is often missed in the warehouse data
Return rate	Quality	Units returned / units shipped x 100	percent	Customer and quality issues	Match returns to the period of the original shipment
Dock door utilization	Dock	Hours doors are occupied / hours doors are available x 100	percent	Dock capacity use	Peak-hour use matters more than the daily average
Truck turn time	Dock	Truck departure time minus truck arrival time	minutes	Yard and dock efficiency	Separate wait time from load or unload time
Cost per order line	Cost	Total warehouse operating cost / order lines shipped	currency	Unit cost of fulfillment	Fixed costs inflate it in slow periods
Labor utilization	Labor	Direct productive hours / total paid hours x 100	percent	Share of paid time spent on value-adding work	Target 100 percent is unrealistic; breaks and travel are real
Overtime ratio	Labor	Overtime hours / total paid hours x 100	percent	Labor planning health	Seasonal peaks may be planned and should be flagged

Definitions vary by company and system. Write down the exact formula, the data source and the period you use, and apply the same definition across sites before comparing numbers.

Automate your warehouse KPI pack

Want these KPIs produced from your WMS or ERP tables on a schedule? We can discuss what is feasible with your data.

Optional. The tool and every export work without this. No spam.

How to use the list

Search by KPI name or area, such as Picking or Dock, and read the formula and pitfall columns together. Pick a small set that matches your operation, usually accuracy, speed, productivity and cost, and write the formulas into your reporting spec. Export the rows you select to Excel to build a KPI dictionary your team can sign off.

Choose a balanced set

A single KPI invites gaming. Pairing an accuracy measure with a productivity measure, for example order picking accuracy with lines per labor hour, keeps speed from being traded for errors. Add one capacity measure such as space utilization and one financial measure such as cost per order line so management sees the full picture.

Accuracy: picking, receiving, inventory
Speed: dock to stock, order cycle time
Productivity: lines or units per labor hour
Capacity and cost: utilization, cost per line

Where the data comes from

Most of these KPIs come from timestamps and counts already in your WMS or ERP: receipt, putaway, pick confirmation, pack and ship transactions, plus labor from time and attendance. If the timestamps are missing or batch-confirmed at the end of a shift, the KPI is not trustworthy. Fix the scan discipline first, then the dashboard.

Common mistakes

Teams often compare sites that define a KPI differently, report only averages, or track too many measures to act on any. Treat the pitfall column as a checklist when you review a report. If a number looks too good, check whether the denominator was narrowed.

Frequently Asked Questions

What is a good order picking accuracy?

Many operations target 99 percent or higher, and high-performing sites with scanning often reach well above that. The right target depends on order value, error cost and your pick method, so set it with your customers in mind.

What is the difference between order fill rate and line fill rate?

Order fill rate counts orders shipped fully complete. Line fill rate counts individual order lines shipped complete. On orders with many lines, line fill rate is usually higher because one short line spoils the whole order for order fill rate.

How is dock to stock time measured?

From the time the truck is checked in at the gate or dock to the time the goods are received and available in the system. Some sites measure from unload start; whichever you use, apply it consistently.

How many KPIs should a warehouse track?

Usually five to ten for a site, reviewed weekly, with a deeper set for supervisors. Too many KPIs dilute focus. Pick the ones that match your biggest problems and your customer promises.

If your KPIs are rebuilt by hand from ERP exports each month, we can help automate them from the source tables with the definitions you choose.

Talk to an Expert Explore More Free Tools

Related Tools

Costing & Finance

More Supply Chain & Inventory tools

See all

Back to All Tools