Please enable JavaScript.
Coggle requires JavaScript to display documents.
SCM KPIs - Coggle Diagram
SCM KPIs
Inventory
Inventory :check:Value
Inventory Turnover :check:
Number of Turns (12months COGS/Inventory EOM)
Proper Calculation = 12Month COGS/Average Inventory
DIO = 365/Turns
Inventory Velocity
Forecast Item
Inventory Value/(average next 3 months forecast COGS)/12*365
Non Forecast item
Inventory Value/(average last 3 months COGS)/12*365
Dimensions
Product
Product Category (WL Units/Non WL Units/WL Filtes ...)
LOB (POU_WL/POU_NWL...)
Product Family (WL100/WL7/WL3...)
SKU (WL7_CAS, WL100_FS_CA....)
Segmentation (ABC/XYZ)
Inventory Policy (Forecast Items/Non stock Item/Stock Item)
Time
Year
Quarter
Month
Week
Day
Geography
Global
Region (EMEA/NAM/APAC)
Country/BU
Warehouses
Regional DC
Local DC
Customer Service
On Shelf Availability
Stock Out Rate = sum of OOS per item per day / (total number of SKU * number of days)
On Shelf Availability = 1-OOS
OOS Duration rate = # of time item OOS/total period
Service Level
Fill Rate (Qty supplied ex stock) = Qty Supplied from Stock/Total Qty ordered
Service Level = # order in Full/Total number of orders
Cycle Time
Order Cycle Time = time between order and dispatch
Lead time = Time between Dispatch and Receipt
SCM Cost
Transport
Sea Freight
Cost per TEU
Fixed Cost per container
Land Freight
Transport Rate
Fuel Surchage
Warehouse
Building Cost
Labor cost
Packaging cost
Admin Cost
Demand Planning
Forecast Accuracy :check:
WMAE =1-Abs(sum(Forecast-Actual)/sum(Actuals) :check:
Bias = Sum(Forecast-Actuals) :check:
Bias% = Sum(Forecast)/Sum(Actuals :check:)
Lag
Overseas Supplier= 4 months :check:
Regional Suppliers= 3 Month :check:
DRP Accuracy
Adherence to Demand Plan = Sum(Weekly Forecast over period)/Sum(DP for same period)
Sustainability
Mileage
Land Freight
Sea Freight
Circular economy
Pallet recycling
Packaging usage
Kg/CO2
Supply Planning
Lead Time :check:
Port to Port Transit Time :check:
Land Transit time :check:
Adherence to Supply Plan = Sum(Dispatch qty over period)/Sum(SP for same period)