Logistics & Warehousing KPIs
Purpose
The purpose of these KPIs is to assist Logistics & Warehousing staff and management optimise throughput thereby helping reduce costs, and maximise profit.
They provide pointers at the Logistics & Warehousing performance in the business, both as individuals and contributory components of teams and departments.
KPIs use either a single parameter or a combination of parameters, often generated automatically by 'counters' whereby the output is a comprehensive performance indicator in itself.
These counters can be built into the Logistics & Warehousing tools, the Logistics & Warehousing management systems or programmed individually to suit local requirements.
Scope
The scope of these Key Performance Indicators is limited to activities, as defined by the organisation, to lie inder the relevant business area.
However the data used by and/or collected by the counters and measurement tools could originate from anywhere within - or without - the business.
Each individual KPI is reviewed to assess it's "
fitness for purpose" on a periodic basis as defined by the KPI owner.
This is a temporary message - once each individual 'scope" document is written, it will be replaced within the coding that produced this KPI document.
Definitions
Each KPI is described by the following items:
- KPI ID Number: contains the full name of the KPI.
- Target Value: contains the max or min threshold
- Frequency: describes the type of measurement i.e. daily, weekly, or monthly.
- Description: this item provides short explanation of the KPI.
- Formula: this item contains the formula composed by the counters for the KPI.
- Counters: this item contains counters used for calculation and described how they are triggered.
- Object Class: this item shows from which element the measurement statistical data are taken.
- Tools: this item shows which tool is used to calculate the KPI.
- Trigger: the event that starts the KPI measurement.
- Terminator: the event that stops the KPI measurement.
- Unit Range: this items shows the unit range value of the KPI.
- Review Period: this defines the aging process of the KPI. It helps management ensure it's use is relevant.
- Owner: this item reflects who has the authority to adjust the KPI paramaters and to whom any queries should be addressed concerning the measurements.
- Remark: this item is sometimes added to write notes and additional information.
- Process: the process or processes (or work instruction/procedure) to which this KPI is applicable.
A measurement type can have several sub-counters; therefore the used sub-counters are listed in brackets with following meanings as examples:
- [3]: sub-counter 3 has to be taken.
- [1,2,4]: sub-counters 1, 2 and 4 have to be added.
- [1 - 4, 7 - 10]: sub-counters 1, 2, 3, 4, 7, 8, 9 and 10 have to be added.
- [all]: all sub-counters have to be added.
Not all Definitions apply to every KPI. Where an element has no value in the database, it is not displayed.
Note that when the average of a series of inputs is calculated, this is taken to be the arithmetic MEDIAN.
Measurables
Details
| KPI LW1 |
Turnover |
| Description |
Turnover |
| Process |
|
|
| KPI LW2 |
Turnover At Cost |
| Description |
Turnover At Cost (Without Margin) |
| Process |
|
|
| KPI LW3 |
Warehouses (Number) |
| Description |
Number Of Warehouses |
| Process |
|
|
| KPI LW4 |
Branches (Number) |
| Description |
No. Of Branches |
| Process |
|
|
| KPI LW5 |
Suppliers (Number) |
| Description |
No. Of Suppliers |
| Process |
|
|
| KPI LW6 |
Suppliers Accounting For 80% Of Purchases (Number) |
| Description |
No. Of Suppliers Accounting For 80% Of Purchases |
| Process |
|
|
| KPI LW7 |
Suppliers Accounting For 80% Of Purchases (%) |
| Description |
% Of No. Of Suppliers Accounting For 80% Of Purchases |
| Process |
|
|
| KPI LW8 |
Product Family Turnover |
| Description |
% Of Turnover Product Family 1...N |
| Process |
|
|
| KPI LW9 |
Customer Service Rate |
| Description |
Customer Service Rate Of Studied Unit |
| Formula |
Nº of order lines received on time in period / order lines received during period number |
| Process |
|
|
| KPI LW10 |
KPI Availability Rates |
| Description |
Kpi Availability Rates |
| Formula |
Nº of product code in shortage / product code managed number |
| Process |
|
|
| KPI LW11 |
Other Branch Sourced Replacement Flow |
| Description |
% Of Repl. Flow Coming From Other Branches |
| Process |
|
|
| KPI LW12 |
Other Branch Delivery |
| Description |
% Of Delivery On Behalf Of Other Branches |
| Process |
|
|
| KPI LW13 |
Warehouse Through Stock Flow |
| Description |
Warehouse - Part Of Flow Which Is Through Stock |
| Process |
|
|
| KPI LW14 |
Warehouse Cross-Dock Stock Flow |
| Description |
Warehouse - Part Of Flow Which Is Cross-Dock |
| Process |
|
|
| KPI LW15 |
Branch Through Stock Flow |
| Description |
Branch - Part Of Flow Which Is Through Stock |
| Process |
|
|
| KPI LW16 |
Branch Cross-Dock Stock Flow |
| Description |
Branch - Part Of Flow Which Is Cross-Dock |
| Process |
|
|
| KPI LW17 |
Warehouse Stock Cash Value |
| Description |
Cash Value Of Stock Level Warehouse |
| Process |
|
|
| KPI LW18 |
Branch Stock Cash Value |
| Description |
Cash Value Of Stock Level Branch |
| Process |
|
|
| KPI LW19 |
Total Stock Cash Value |
| Description |
Cash Value Of Stock Level Total |
| Process |
|
|
| KPI LW20 |
Stock Days Cover (Total) |
| Description |
Stock Days Cover Total |
| Process |
|
|
| KPI LW21 |
Shrinkage |
| Description |
Shrinkage As % Of Stock Sales (At Cost) |
| Process |
|
|
| KPI LW22 |
Warehouse Turnover (Retail) |
| Description |
Warehouse Turnover |
| Process |
|
|
| KPI LW23 |
Warehouse Indoor Surface |
| Description |
Warehouse Indoor Surface |
| Process |
|
|
| KPI LW24 |
Warehouse Outdoor Surface |
| Description |
Warehouse Outdoor Surface |
| Process |
|
|
| KPI LW25 |
Deliveries (Number) |
| Description |
No. Of Deliveries |
| Process |
|
|
| KPI LW26 |
Order Lines Deliveries (Number) |
| Description |
No. Of Order Lines Delivered |
| Process |
|
|
| KPI LW27 |
Employees (Number) |
| Description |
No. Of Employees |
| Process |
|
|
| KPI LW28 |
Warehouse Turnover (Cost) |
| Description |
Warehouse Turnover (At Cost) |
| Process |
|
|
| KPI LW29 |
Warehouse Personal (Cash Value) |
| Description |
Warehouse Personal (Cash Value) |
| Process |
|
|
| KPI LW30 |
Warehouse Personal (%) |
| Description |
Warehouse Personal (%) |
| Process |
|
|
| KPI LW31 |
Warehouse General Costs (Cash Value) |
| Description |
Warehouse General Costs (Cash Value) |
| Process |
|
|
| KPI LW32 |
Warehouse General Costs (%) |
| Description |
Warehouse General Costs (%) |
| Process |
|
|
| KPI LW33 |
Warehouse Equipment (Cash Value) |
| Description |
Warehouse Equipment (Cash Value) |
| Process |
|
|
| KPI LW34 |
Warehouse Equipment (%) |
| Description |
Warehouse Equipment (%) |
| Process |
|
|
| KPI LW35 |
Warehouse Rent (Cash Value) |
| Description |
Warehouse Rent (Cash Value) |
| Process |
|
|
| KPI LW36 |
Warehouse Rent (%) |
| Description |
Warehouse Rent (%) |
| Process |
|
|
| KPI LW37 |
Warehouse Others (Cash Value) |
| Description |
Warehouse Others (Cash Value) |
| Process |
|
|
| KPI LW38 |
Warehouse Others (%) |
| Description |
Warehouse Others (%) |
| Process |
|
|
| KPI LW39 |
Warehouse Total Without Transport (Cash Value) |
| Description |
Warehouse Total Without Transport (Cash Value) |
| Process |
|
|
| KPI LW40 |
Warehouse Total Without Transport (%) |
| Description |
Warehouse Total Without Transport (%) |
| Process |
|
|
| KPI LW41 |
Transport Warehouse - Branches (Cash Value) |
| Description |
Transport Warehouse - Branches (Cash Value) |
| Process |
|
|
| KPI LW42 |
Transport Warehouse - Branches (%) |
| Description |
Transport Warehouse - Branches (%) |
| Process |
|
|
| KPI LW43 |
Warehouse Total Transport Included (Cash Value) |
| Description |
Warehouse Total Transport Included (Cash Value) |
| Process |
|
|
| KPI LW44 |
Warehouse Total Transport Included (%) |
| Description |
Warehouse Total Transport Included (%) |
| Process |
|
|
| KPI LW45 |
Warehouse Rent |
| Description |
Warehouse Rent / Stock Value |
| Process |
|
|
| KPI LW46 |
Warehouse Personnel Costs |
| Description |
Warehouse Personnel Costs/ Warehouse Turnover |
| Process |
|
|
| KPI LW47 |
Branch Logistics Personal (Cash Value) |
| Description |
Branch Logistics Personal (Cash Value) |
| Process |
|
|
| KPI LW48 |
Branch Logistics Equipment (Cash Value) |
| Description |
Branch Logistics Equipment (Cash Value) |
| Process |
|
|
| KPI LW49 |
Branch Rent Of Logistics Surfaces (Cash Value) |
| Description |
Branch Rent Of Logistics Surfaces (Cash Value) |
| Process |
|
|
| KPI LW50 |
Branch Others (Cash Value) |
| Description |
Branch Others (Cash Value) |
| Process |
|
|
| KPI LW51 |
Branch Total (Cash Value) |
| Description |
Branch Total (Cash Value) |
| Process |
|
|
| KPI LW52 |
Branch Rent (Logistics Surfaces) / Stock Value |
| Description |
Branch Rent (Logistics Surfaces) / Stock Value |
| Process |
|
|
| KPI LW53 |
Branch Logistics Employees (Number) |
| Description |
Branch No. Of Logistics Employees |
| Process |
|
|
| KPI LW54 |
Branch Personnel Costs / Flow (At Cost) |
| Description |
Branch Personnel Costs / Flow (At Cost) |
| Process |
|
|
| KPI LW55 |
Total Downstream Transport Cost (Cash Value) |
| Description |
Total Downstream Transport Cost (Cash Value) |
| Process |
|
|
| KPI LW56 |
Internal Downstream Transport Cost (Cash Value) |
| Description |
Internal Downstream Transport Cost (Cash Value) |
| Process |
|
|
| KPI LW57 |
Downstream Transport Personal (Cash Value) |
| Description |
Downstream Transport Personal (Cash Value) |
| Process |
|
|
| KPI LW58 |
Downstream Transport Equipment (Trucks) |
| Description |
Downstream Transport Equipment (Trucks) |
| Process |
|
|
| KPI LW59 |
External Downstream Transport Cost (Cash Value) |
| Description |
External Downstream Transport Cost (Cash Value) |
| Process |
|
|
| KPI LW60 |
Total Downstream Transport Cost As % Of Delivered Sales |
| Description |
Total Downstream Transport Cost As % Of Delivered Sales |
| Process |
|
|
| KPI LW61 |
Downstream Deliveries (By Weight) |
| Description |
Annual Number Of Downstream Deliveries (Tons) |
| Process |
|
|
| KPI LW62 |
Downstream Deliveries (By Volume) |
| Description |
Annual Number Of Downstream Deliveries (Cubic metres) |
| Process |
|
|
| KPI LW63 |
Downstream Transport Drivers (Number) |
| Description |
No. Of Downstream Transport Drivers |
| Process |
|
|
| KPI LW64 |
Downstream Transport Driver (Cost) |
| Description |
Average Cost Of A Downstream Transport Driver |
| Process |
|
|
| KPI LW65 |
Downstream Transport Trucks (Number) |
| Description |
No. Of Downstream Transport Trucks |
| Process |
|
|
| KPI LW66 |
Goods Returned By Clients (Cash Value) |
| Description |
Total Value Of Goods Returned By Clients (Cash Value) |
| Process |
|
|
| KPI LW67 |
Goods Returned To Suppliers (Cash Value) |
| Description |
Total Value Of Goods Returned To Suppliers (Cash Value) |
| Process |
|
|
| KPI LW68 |
Goods In Warehouses (Cash Value) |
| Description |
Total Value Of Goods In Warehouses (Cash Value) |
| Process |
|
|
| KPI LW69 |
Cost Value Evolution (At Cost) |
| Description |
Cost Value Evolution Vs. Objective, Budget (At Cost) |
| Process |
|
|
| KPI LW70 |
Flow Value Evolution |
| Description |
Cost In % Flow Value Evolution Vs. Objective, Budget |
| Process |
|
|
| KPI LW71 |
Warehouse Rent Or Annual Amortisation |
| Description |
Rent Or Annual Amortization Of The Warehouse |
| Process |
|
|
| KPI LW72 |
Racks, Sprinklers, Automated Preparation, … Amortisations |
| Description |
Racks, Sprinklers, Automated Preparation, … Amortizations |
| Process |
|
|
| KPI LW73 |
Total Cost |
| Description |
Total Cost |
| Formula |
Rent + Equipment |
| Process |
|
|
| KPI LW74 |
Warehouse Capacity Use |
| Description |
Warehouse Capacity Use Rate % |
| Formula |
pallets No stored in warehouse / warehouse capacity in pallets No. |
| Process |
|
|
| KPI LW75 |
Absenteeism |
| Description |
Absenteeism |
| Formula |
Total of non worked hours / total hours (%) |
| Process |
|
|
| KPI LW76 |
Goods Reception Human Resource |
| Description |
Reception Hr |
| Formula |
(temporary & proper workers) + Equipment = Cost for 1 pallet (homogeneous, heterogeneous, container…) received… |
| Process |
|
|
| KPI LW77 |
Order Picking Human Resource |
| Description |
Order Picking Hr |
| Formula |
(temporary & proper workers) + Equipment = Cost for 1 order line, 1 ton, 1 m3… prepared |
| Process |
|
|
| KPI LW78 |
Cross Docking Human Resource |
| Description |
Cross Docking Hr |
| Formula |
(temporary & proper workers) + Equipment = Cost for one pallet, 1 ton, 1 m3… cross docked |
| Process |
|
|
| KPI LW79 |
Shipping Human Resource |
| Description |
Shipping Hr |
| Formula |
(temporary & proper workers) + Equipment = Cost for one pallet, 1 ton, 1 m3 shipped |
| Process |
|
|
| KPI LW80 |
Stock Control Human Resource |
| Description |
Stock Control Hr |
| Formula |
(temporary & proper workers) + Equipment = Cost for one reference controlled |
| Process |
|
|
| KPI LW81 |
Seasonality |
| Description |
Seasonality |
| Formula |
(monthly, weekly, daily) and trend = Follow Up of picking lines number, trucks, m3 or tons shipped |
| Process |
|
|
| KPI LW82 |
Heterogeneous/Homogeneous Pallet Lines Received (Number) |
| Description |
No Of Lines, Of Heterogeneous/Homogeneous Pallets Received Per Man Hour. |
| Process |
|
|
| KPI LW83 |
Lines, Pallets Put Away (Number) |
| Description |
No Of Lines, Pallets Put Away Per Man Hour. |
| Process |
|
|
| KPI LW84 |
Lines Picked (Number) |
| Description |
No Of Lines Picked Per Man Hour. |
| Process |
|
|
| KPI LW85 |
Lines, Pallets Shipped (Number) |
| Description |
No Of Lines, Pallets Shipped Per Man Hour. |
| Process |
|
|
| KPI LW86 |
Receiving Flow / Capacity |
| Description |
Receiving Flow / Capacity |
| Process |
|
|
| KPI LW87 |
Preparing Flow / Capacity |
| Description |
Preparing Flow / Capacity |
| Process |
|
|
| KPI LW88 |
Shipping Flow / Capacity |
| Description |
Shipping Flow / Capacity |
| Process |
|
|
| KPI LW89 |
Warehousing Discrepancies |
| Description |
Warehousing Discrepancies |
| Process |
|
|
| KPI LW90 |
Warehousing Discrepancies |
| Description |
Warehousing Discrepancies |
| Process |
|
|
| KPI LW91 |
Dispute (For Suppliers And Clients) |
| Description |
Dispute (For Suppliers And Clients) |
| Process |
|
|
| KPI LW92 |
Dispute (For Suppliers And Clients) |
| Description |
Dispute (For Suppliers And Clients) |
| Process |
|
|
| KPI LW93 |
Service Rate |
| Description |
Service Rate |
| Process |
|
|