STRATEGIC PROCUREMENT OPTIMISATION

Supplier Portfolio Analysis & Performance Improvement Initiative

£1.8M

Value Opportunity Identified

279%

ROI in Year 1

5.64% → <3%

Defect Rate Reduction

£45.4M

Spend Analyzed

Project Overview

Context

Analyzed £45.4M procurement portfolio across 5 strategic suppliers and 5 product categories to identify value optimization opportunities and operational risks.

Challenge

Despite achieving 7.97% cost savings (£3.93M), the organization faced a "value leakage" situation where 41-46% of negotiated savings were eroded by quality issues and supplier performance problems.

Solution

Conducted comprehensive supplier performance analysis, quantified cost of poor quality (COPQ), developed risk-based supplier segmentation model, and created 90-day transformation roadmap to capture additional £1.8M in annual value.

Impact

Identified £1.6-1.8M in hidden quality costs, developed actionable improvement plan with 279% ROI, and provided strategic recommendations for supplier portfolio optimization.

Interactive Dashboard

The Original Dataset includes purchase order records, pricing data, delivery timelines, and defect counts, which were cleaned, transformed, and analyzed to produce the findings in the report

Methodology & Tools

Data Collection

Data Modeling

Analysis & DAX

Insights & Report

Key Strategic Insights

Value Leakage Identified

Despite achieving 7.97% cost savings, 41-46% of negotiated savings were eroded by quality issues. Beta Supplies and Delta Logistics account for 69% of total COPQ (£1.76M) despite representing only 42% of spend.

£1.6M COPQ annually

Supplier Performance Polarization

Clear bifurcation in supplier performance: Alpha Inc and Epsilon Group maintain <2.6% defect rates while Beta Supplies and Delta Logistics exceed 7.6% defects with compliance below 76%.

5.6x quality variance

Transformation Opportunity

By addressing supplier quality issues and implementing risk-based portfolio management, organization can unlock £1.8M in additional annual value with 279% ROI and 3.2-month payback period.

279% ROI in Year 1

Strategic Recommendations

Exit High-Risk Suppliers

Issue 90-day performance improvement mandates to Beta Supplies and Delta Logistics. Begin competitive RFQ process for £19.1M in replacement volume.

Expand Top Performers

Increase Alpha Inc volume by 30% (£7.84M → £10.2M) and negotiate long-term strategic partnership with volume discounts and innovation initiatives.

Mitigate Dependency Risk

Develop qualified backup suppliers for Epsilon Group critical items. Implement dual-sourcing strategy to reduce concentration risk below 25%.

Deploy Scorecard System

Implement automated supplier performance scorecards with Quality (40%), Delivery (30%), Cost (20%), Compliance (10%) weighting and monthly reporting.

Project Deliverables

Access comprehensive project documentation and analysis files

Strategic Report

25-page McKinsey-style analysis with strategic recommendations and 90-day roadmap

Sample Dataset

Anonymized procurement data for analysis replication and methodology validation

Have a data challenge? Let’s work together!

© 2025 Ezechukwunonso. All right reserved.