Article #28

Professional Systems for Managing Supply Chain Depth
Global Supply Chain Management
KPI Implementation: Setting Goals First

PERCITE

Expert Logistics Solutions

The Strategic Context: Beyond Daily Operations

In our previous article, we began exploring an area often invisible to supply chain practitioners – those professionals in procurement, operations, logistics, finance, sales, and manufacturing who carry the daily burden of operational execution. These individuals plow the furrows of day-to-day operations, struggling against resistant soil and stubborn obstacles to achieve critical objectives within compressed timeframes.

Their focus necessarily remains on tactical execution – completing this shipment, resolving that supplier issue, meeting today's production schedule. However, effective supply chain management requires elevation beyond individual furrows to survey the entire field. This broader perspective encompasses the complete supply chain serving organizational needs: customer demand triggering procurement, development and manufacturing, logistics management, import/export coordination, raw material and finished goods management, delivery to customer sites, and ultimately cash collection and profit realization.

The Holistic View

We now address the holistic view of supply chain operations, attempting to define frameworks through which we can examine effectiveness – identifying criteria that can be detected, measured, compared, controlled, and improved to better support organizational objectives.

Our previous article (Article #27) presented the SCOR (Supply Chain Operations Reference) model developed by the Supply Chain Council (SCC) – a comprehensive framework for analyzing supply chain performance.

The SCOR Framework: A Holistic Model

SCOR provides a comprehensive view of supply chain processes, encompassing planning through execution. The model considers organizational planning influenced by two primary process streams:

  • Upstream: Supply chain management toward customers
  • Downstream: Supply chain management toward suppliers

This holistic model establishes formal structure for supply chain processes, enabling investigation and analysis through systematic tools. The framework enables answering seemingly simple questions such as:

Total Supply Chain Length (Days)

(RM + WIP + FG) Inventory Days of Annual Sales

Where: RM = Raw Material, WIP = Work in Process, FG = Finished Goods

Lower values indicate shorter, more efficient supply chains

Supply Chain Inefficiency Ratio (SCI)

SCI = SCC / NS

SCC = DC + (INV × ICC)

Where:

  • SCI = Supply Chain Inefficiency Ratio
  • SCC = Supply Chain Costs
  • DC = Distribution Cost (annual)
  • INV = Inventory Value (RM+WIP+FG) as of date
  • ICC = Inventory Carrying Cost
  • NS = Net Sales (annual)

Lower ratios indicate more efficient supply chain cost structures

These metrics appear straightforward. Now the challenge begins: collecting the required data.

Critical Warning: Start with Goals, Not Data

⚠️ Warning: Do not begin with data collection!

The fundamental error in KPI implementation is starting with data gathering. This approach leads to paralysis, not analysis. Organizations drown in irrelevant data series, achieving information overload rather than actionable insights.

The Correct Sequence:

  1. Define organizational objectives
  2. Identify analysis areas supporting those objectives
  3. Determine required metrics
  4. Establish data collection processes
  5. Implement measurement and continuous improvement cycles

The relevance of specific analysis areas depends entirely on organizational objectives. Data investigation against goals also depends on organizational paradigm – the worldview through which performance is evaluated.

Three Analytical Approaches

1. Process-Driven Measurement

This approach examines organizational effectiveness through process analysis:

  • Planning Effectiveness: How well does organizational planning match actual market consumption?
  • Procurement and Supplier Management: Supplier evaluation, inventory cycles, logistics effectiveness
  • Customer Order Processing: Delivery accuracy (quantity, schedule), documentation quality (completeness, accuracy)
  • Distribution Quality: Transportation utilization (container volume utilization, minimum shipment weights for cost-effective pricing)

2. Functional-Based Measurement

This approach investigates performance through functional analysis (complementary to process measurement):

  • Material Management: Material cost as percentage of sales, inventory turnover, production downtime due to material stockouts
  • Manufacturing Management: Material loss in production processes, quality control/defect rates, production line effectiveness, rework percentage
  • Customer Service Management: Order lifecycle duration, change order frequency, billing accuracy, return rates

3. Cross-Functional Analysis: QCDF

The QCDF framework (Quality, Cost, Delivery, Flexibility) provides cross-functional measurement:

  • Quality: Raw material quality, product quality, customer order handling quality, logistics operations quality
  • Cost: Raw material costs, logistics costs, overhead costs, inventory costs, storage costs, hurdle rates (opportunity cost of capital)
  • Delivery: On-time delivery performance, order accuracy, responsiveness to customer changes
  • Flexibility: Ability to adapt to demand fluctuations, product mix changes, volume variations

Regardless of methodology selected – potentially deploying multiple approaches simultaneously – formal, unified data collection becomes essential. Without standardization, organizations generate mountains of incomparable data.

Aligning Metrics with Organizational Objectives

Data collection and analysis must support specific organizational goals. Consider these example objective categories:

1. Reducing Supply Chain Costs

  • Reduce inventory carrying costs
  • Reduce logistics expenses
  • Reduce direct and indirect raw material costs

2. Increasing Revenue and Profitability

  • Increase product margin
  • Expand market segments (not directly supply chain related)
  • Reduce returns and order cancellations
  • Reduce supply chain time to market/money

3. Improving Manufacturing Effectiveness

  • Reduce manufacturing costs
  • Shorten raw material delivery cycles
  • Improve production line utilization
  • Defer production line capital investments (depending on other parameters)

4. Increasing Working Capital

  • Shorten customer credit lines
  • Extend supplier credit lines
  • Optimize financing terms and conditions

Important Note: Not all activities directly relate to supply chain operations. However, many areas remain subject to control, management, and improvement by operations, logistics, and import/export managers.

Even modest improvements yield significant results: A 3% cost reduction in expenses representing 70% of product costs can translate to 1-5% improvement in annual gross profit.

SCOR Strategic Metrics Framework

SCOR provides a comprehensive summary of strategic metrics (KPIs) aligned with supply chain categories:

Attribute Strategic Metric
Reliability Perfect Order Fulfillment
Responsiveness Order Fulfillment Cycle Time
Agility Upside Supply Chain Flexibility
Supply Chain Upside Adaptability
Supply Chain Downside Adaptability
Cost Supply Chain Management Cost
Cost of Goods Sold
Assets Cash-to-Cash Cycle Time
Return on Supply Chain Fixed Assets
Return on Working Capital

On the left side of the table appear categories and their strategic metrics (KPIs). Through these metrics – analyzing current state, identifying and extracting continuous data, and maintaining ongoing improvement control – organizations can enhance performance.

Each KPI requires processing substantial data volumes, some automatic (from ERP systems or specialized supply chain management systems like SCMaster) and some manual (observations and data from informal sources).

The data ultimately enabling investigation and analysis comprises second-tier diagnostic metrics supporting strategic KPI calculation and presentation. These diagnostic metrics drive organizational structured improvement processes.

Practical Example: International Transportation Analysis

Consider this diagnostic metric example – a Business Intelligence query analyzing international transportation duration:

Import ID# SCMatrix Territory Route Map Logistics Segments Actual Duration SCMatrix Duration
123001 AUSTRALIA AU-IL-OCEAN AU-IL-Pre Carriage – Ocean 10 8
123001 AUSTRALIA AU-IL-OCEAN AU-IL-Main Carriage – Ocean 45 47
123001 AUSTRALIA AU-IL-OCEAN IL-On Carriage - Ocean 9 7

This query evaluates diagnostic metrics assessing ground transportation planning at 8 days – from supplier readiness (Promise Date) to origin port – ocean freight from Australia to Israel at 47 days, and final delivery from port to factory gate at 7 days. Total port-to-port time: 64 days (standard time).

The query also presents actual elapsed time.

Dual Benefits of Diagnostic Metrics

This analysis yields two immediate benefits:

  1. Plan versus Actual Analysis: Total elapsed time enables more accurate planning for material requirements against supplier commitments and manufacturing schedules needed to fulfill customer orders.
  2. Process Granularity: Fine-grained resolution of logistics process details enables supplier evaluation – in this case, logistics service providers.

Adding cost and service quality dimensions enables remarkable comparative analysis among logistics service providers, process improvement in logistics operations, and transportation cost analysis and optimization – directly contributing to two categories from the earlier table: COST and ASSETS, reducing supply chain costs while improving cash flow and working capital.

Conclusion: The Foundation for Improvement

Effective KPI implementation requires disciplined methodology:

  1. Begin with organizational objectives – understand what the organization seeks to achieve
  2. Select relevant analytical approaches – process-driven, functional, or cross-functional
  3. Identify strategic metrics (KPIs) supporting those objectives
  4. Determine required diagnostic metrics enabling KPI calculation
  5. Establish formal data collection processes
  6. Implement continuous measurement and improvement cycles

Organizations that implement structured performance measurement gain competitive advantage through:

  • Objective visibility into supply chain performance
  • Data-driven decision making replacing intuition
  • Systematic identification of improvement opportunities
  • Quantifiable results from improvement initiatives
  • Cultural transformation toward continuous improvement

The journey from operational firefighting to strategic supply chain management requires commitment, discipline, and appropriate technological infrastructure. Organizations willing to make this investment position themselves for sustained competitive advantage through supply chain excellence.