The Challenge
Managing vendor performance requires tracking multiple KPIs across hundreds of suppliers. Procurement teams needed a unified view of fill rates, in-stock percentages, and shortage values to drive vendor negotiations and identify at-risk suppliers.
Key Business Questions
- Which vendors have the worst fill rate performance?
- What is the total dollar exposure from vendor shorts?
- How do DC out-of-stock rates trend over fiscal weeks?
- Which product categories have the highest shortage risk?
The Solution
I built a two-dashboard vendor performance suite:
📊 Vendor Scorecard
Comprehensive vendor performance tracking with CSL (Customer Service Level), in-stock percentage trends, and vendor summary comparisons.
📉 Shorts Analysis
Dollar exposure from shortage events with trending analysis showing improvement/degradation patterns over fiscal periods.
🏭 DC OOS Tracking
Distribution center out-of-stock rates correlated with vendor shipment performance.
🎯 Action Items
Prioritized vendor improvement recommendations based on impact and improvement potential.
Dashboard Views
