Warehousing KPIs

Here are the main KPIs for the Warehousing. They are part of the Warehouse Dashboard or Balanced Scorecard.

Please see the following table.

-> Recommended bibliography about warehousing KPIs

Activity Subject Calculation
Cost Cost value evolution vs. budget
Cost value as % of COGS evolution vs. budget
Rent or annual amortization of the warehouse value
Racks, sprinklers, automatized preparation, … amortizations value
Total cost rent + equipment value
Cost per order Total cost / number of orders shipped during the same period
Process Receiving HR (temporary & proper workers) + Equipment Cost for one palet (homogeneous, heterogeneous), one container… received
Order picking HR (temporary & proper workers) + Equipment Cost for one order line, ton, m3… prepared
Cross docking HR (temporary & proper workers) + Equipment Cost for one palet, ton, m3… cross docked
Shipping HR (temporary & proper workers) + Equipment Cost for one palet, ton, m3 shipped
Stock control HR (temporary & proper workers) + Equipment Cost for one item controlled
Activity COGS (Cost Of Goods Sold) or Cost of sales of the warehouse COGS = Beginning Merchandise Inventory + Net Purchases of Merchandise – Ending Merchandise
Seasonality (monthly, weekly, daily) and trend Evolution of the number of order picking lines, trucks, m3 or tons shipped
Receiving flow vs capacity Flow identification vs. HR capacity
Order picking flow vs capacity Flow identification vs. HR capacity
Shipping flow vs capacity Flow identification vs. HR capacity
Warehouse capacity use rate Number of palets stored in warehouse ÷ overall warehouse capacity in palets number
Shrinkage value as % of COGS Total shrinkage value ÷ COGS
Quality Warehousing discrepancies Products lost value (at COGS value) ÷ total products shipped value (at COGS value)
Products lost value (at COGS value) ÷ total Inventory value
Dispute (for suppliers and clients) Number of order lines delivered in dispute÷ number of order lines delivered during the same period
Goods amount delivered in dispute÷ total goods amount delivered during the same period
Customer returns Number of items returned by customers ÷ total number of items shipped during the same period
Items incorrectly located Number of SKUs incorrectly located ÷ total number of SKUs
Items with incorrect Inventory balance Number of SKUs with incorrect Inventory balance ÷ total number of SKUs
Service Average lead time in the warehouse
Service rate – DIFOT (Delivery In Full On Time) Number of order lines shipped on time ÷ total number of order lines shipped during the same period
Back orders Number of order lines on back orders status ÷ total number of order lines shipped during the same period
HR Temporary workers as % of total HR Number of temporary workers ÷ total HR
Absenteeism Total of non worked hours ÷ total hours
Productivity Number of lines or heterogeneous / homogeneous palets received per man per hour
Number of lines or  palets put away per man per hour
Number of lines picked per man per hour
Number of lines or palets shipped per man per hour
Number of cross-docking palet per man per hour
Number of items controlled per man per day


Recommended bibliography