# Warehouse KPI Formulas and Definitions Reference > Source: https://netray.co/tools/warehouse-kpi-formulas-and-definitions-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A lookup of the common warehouse and distribution KPIs with how each is calculated, what it tells you and where it misleads. ## Category supply-chain ## Audience - Warehouse manager - Distribution center supervisor - Operations analyst ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### KPI **Key:** kpi **Type:** text #### Area **Key:** area **Type:** text #### Formula **Key:** formula **Type:** text #### Unit **Key:** unit **Type:** text #### What it tells you **Key:** tells **Type:** text #### Common pitfall **Key:** pitfall **Type:** text **Rows:** **Kpi:** Receiving accuracy **Area:** Receiving **Formula:** Lines received matching PO and ASN / total lines received x 100 **Unit:** percent **Tells:** How clean inbound data and counts are **Pitfall:** Counting by shipment hides line-level errors **Kpi:** Dock to stock time **Area:** Receiving **Formula:** Time stock is available in WMS minus time truck is checked in **Unit:** hours **Tells:** How fast inbound becomes sellable **Pitfall:** Measuring from unload instead of check-in hides yard wait **Kpi:** Putaway accuracy **Area:** Receiving **Formula:** Putaways to the correct location / total putaways x 100 **Unit:** percent **Tells:** Whether stock is where the system says **Pitfall:** Not scanning the location confirm makes it unmeasurable **Kpi:** Putaway cycle time **Area:** Receiving **Formula:** Putaway task completion time minus task creation time **Unit:** minutes **Tells:** Lag between receipt and storage **Pitfall:** Averages hide long tails; track the 90th percentile **Kpi:** Inventory accuracy (location) **Area:** Inventory **Formula:** Locations counted with zero variance / total locations counted x 100 **Unit:** percent **Tells:** Reliability of bin-level stock **Pitfall:** Item-level and value-level accuracy give different answers **Kpi:** Inventory turnover **Area:** Inventory **Formula:** Cost of goods sold / average inventory value **Unit:** turns per year **Tells:** How fast inventory cycles **Pitfall:** Seasonal businesses need monthly or rolling views **Kpi:** Days on hand **Area:** Inventory **Formula:** Inventory on hand / average daily usage or shipments **Unit:** days **Tells:** Coverage of current stock **Pitfall:** Spiky demand makes a flat daily average misleading **Kpi:** Shrinkage rate **Area:** Inventory **Formula:** (Book inventory value - counted value) / book inventory value x 100 **Unit:** percent **Tells:** Loss from theft, damage and process error **Pitfall:** Timing of cycle counts versus receipts can distort a month **Kpi:** Space utilization **Area:** Capacity **Formula:** Occupied locations / total usable locations x 100 **Unit:** percent **Tells:** How full the storage is **Pitfall:** Blocked, reserved or damaged locations may be counted as usable **Kpi:** Cube utilization **Area:** Capacity **Formula:** Volume of stored goods / available storage volume x 100 **Unit:** percent **Tells:** Use of vertical and cubic space **Pitfall:** Needs reliable item dimensions to be meaningful **Kpi:** Order picking accuracy **Area:** Picking **Formula:** Order lines picked correctly / total order lines picked x 100 **Unit:** percent **Tells:** Quality of the pick process **Pitfall:** Customer complaints undercount errors; use audit data too **Kpi:** Lines picked per labor hour **Area:** Picking **Formula:** Order lines picked / direct picking labor hours **Unit:** lines per hour **Tells:** Picker productivity **Pitfall:** Compare only within the same pick method and zone **Kpi:** Units picked per labor hour **Area:** Picking **Formula:** Units picked / direct picking labor hours **Unit:** units per hour **Tells:** Productivity with quantity weighted in **Pitfall:** Case and each picks should be tracked separately **Kpi:** Order cycle time **Area:** Fulfillment **Formula:** Time shipped minus time order released to the warehouse **Unit:** hours **Tells:** Speed through the building **Pitfall:** Start time must be consistent between sites **Kpi:** On-time shipping **Area:** Fulfillment **Formula:** Orders shipped by the promised ship date / total orders shipped x 100 **Unit:** percent **Tells:** Reliability against commitments **Pitfall:** Using the warehouse cutoff date instead of the customer date **Kpi:** Order fill rate **Area:** Fulfillment **Formula:** Orders shipped complete / total orders x 100 **Unit:** percent **Tells:** Share of orders delivered in full **Pitfall:** Do not confuse with line fill rate or unit fill rate **Kpi:** Line fill rate **Area:** Fulfillment **Formula:** Order lines shipped complete / total order lines x 100 **Unit:** percent **Tells:** Line-level availability **Pitfall:** Looks better than order fill rate on multi-line orders **Kpi:** Backorder rate **Area:** Fulfillment **Formula:** Order lines backordered / total order lines x 100 **Unit:** percent **Tells:** Stock availability gaps **Pitfall:** Rescheduled lines may not be counted as backorders **Kpi:** Perfect order rate **Area:** Fulfillment **Formula:** Orders on time, complete, undamaged and with correct documents / total orders x 100 **Unit:** percent **Tells:** End-to-end quality of delivery **Pitfall:** Each condition multiplies, so define each one clearly **Kpi:** Damage rate **Area:** Quality **Formula:** Units or orders damaged / total units or orders shipped x 100 **Unit:** percent **Tells:** Handling and packaging quality **Pitfall:** Carrier damage found later is often missed in the warehouse data **Kpi:** Return rate **Area:** Quality **Formula:** Units returned / units shipped x 100 **Unit:** percent **Tells:** Customer and quality issues **Pitfall:** Match returns to the period of the original shipment **Kpi:** Dock door utilization **Area:** Dock **Formula:** Hours doors are occupied / hours doors are available x 100 **Unit:** percent **Tells:** Dock capacity use **Pitfall:** Peak-hour use matters more than the daily average **Kpi:** Truck turn time **Area:** Dock **Formula:** Truck departure time minus truck arrival time **Unit:** minutes **Tells:** Yard and dock efficiency **Pitfall:** Separate wait time from load or unload time **Kpi:** Cost per order line **Area:** Cost **Formula:** Total warehouse operating cost / order lines shipped **Unit:** currency **Tells:** Unit cost of fulfillment **Pitfall:** Fixed costs inflate it in slow periods **Kpi:** Labor utilization **Area:** Labor **Formula:** Direct productive hours / total paid hours x 100 **Unit:** percent **Tells:** Share of paid time spent on value-adding work **Pitfall:** Target 100 percent is unrealistic; breaks and travel are real **Kpi:** Overtime ratio **Area:** Labor **Formula:** Overtime hours / total paid hours x 100 **Unit:** percent **Tells:** Labor planning health **Pitfall:** Seasonal peaks may be planned and should be flagged **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the list **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### What is a good order picking accuracy? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms warehouse kpi list, warehouse kpi formulas, order picking accuracy formula, dock to stock time definition, perfect order rate formula, warehouse metrics and kpis, fill rate vs service level, distribution center kpi dashboard --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json