Awesome-claude-corporate-skills supplier-scorecard
Build supplier performance scorecards with KPIs, quality metrics, delivery performance, cost management, and improvement plans
git clone https://github.com/w95/awesome-claude-corporate-skills
T=$(mktemp -d) && git clone --depth=1 https://github.com/w95/awesome-claude-corporate-skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/12-procurement-supply-chain/supplier-scorecard" ~/.claude/skills/w95-awesome-claude-corporate-skills-supplier-scorecard && rm -rf "$T"
12-procurement-supply-chain/supplier-scorecard/SKILL.mdSupplier Scorecard
Overview
Establish supplier performance metrics that drive accountability, identify improvement opportunities, and ensure supplier excellence. Scorecards balance compliance, quality, delivery, cost, and relationship factors.
Scorecard Framework
1. Core KPI Categories
Quality Metrics (Product delivered meets specifications):
- Defect rate (# defects / total units delivered)
- First-pass yield (units meeting spec without rework)
- Return rate (units returned due to quality issues)
- PPM (parts per million) defects
- Quality certifications maintained (ISO 9001, etc.)
Delivery Metrics (Goods arrive on time, complete):
- On-time delivery rate (% orders delivered by promised date)
- Delivery accuracy (% orders with correct quantity/items)
- Lead time performance (actual vs. promised)
- Order fill rate (complete orders vs. partial shipments)
- Forecast accuracy (supplier delivery vs. demand forecast)
Cost Metrics (Pricing and cost management):
- Price per unit trend (month-over-month, year-over-year)
- Total cost of ownership (all-in cost vs. competitors)
- Volume discounts earned (reflect volume commitment)
- Cost reduction initiatives (savings from supplier improvements)
- Contract compliance (pricing matches agreement)
Service Metrics (Responsiveness and support):
- Response time to inquiries (<24 hours, <4 hours)
- Issue resolution rate (% resolved within SLA)
- Complaint resolution time (average days to close)
- Customer satisfaction score (monthly survey)
- Proactive communication (advance notice of changes)
Compliance Metrics (Legal, regulatory, contractual):
- SLA compliance (99.9% uptime, etc.)
- Documentation accuracy (invoices, packing slips)
- Regulatory certifications (current and maintained)
- Code of conduct compliance (ethics, labor, environmental)
- Data security/privacy compliance (SOC 2, GDPR, etc.)
Scorecard Template
SUPPLIER PERFORMANCE SCORECARD Supplier: [Name] Reporting Period: [Month/Quarter] Overall Score: [Score] / 100
Quality (Weight: 30%)
| Metric | Target | Actual | Score | Notes |
|---|---|---|---|---|
| Defect Rate (PPM) | <500 | 425 | 95 | Within target |
| First-Pass Yield (%) | >98% | 97.5% | 90 | Slight downtrend |
| Return Rate (%) | <1% | 0.8% | 95 | Acceptable |
| Certifications | ISO 9001 | Current | 100 | Maintained |
| Category Score | 95 | Good performance |
Delivery (Weight: 25%)
| Metric | Target | Actual | Score | Notes |
|---|---|---|---|---|
| On-Time Delivery (%) | >98% | 96.5% | 85 | 2 late shipments this month |
| Delivery Accuracy (%) | 100% | 99.8% | 95 | 1 order short |
| Lead Time vs. Promise | 0 days | -1 day | 100 | Delivering early |
| Fill Rate (%) | 100% | 100% | 100 | All complete shipments |
| Category Score | 95 | Strong performance |
Cost (Weight: 20%)
| Metric | Target | Actual | Score | Notes |
|---|---|---|---|---|
| Price Per Unit ($) | $50 | $50.25 | 85 | 0.5% increase vs. contract |
| Volume Discount (%) | 10% | 10% | 100 | Earning full discount |
| Cost Reduction Ideas | 2/quarter | 1 | 70 | Below target improvement |
| Contract Compliance | 100% | 100% | 100 | Pricing per agreement |
| Category Score | 89 | On track |
Service (Weight: 15%)
| Metric | Target | Actual | Score | Notes |
|---|---|---|---|---|
| Response Time (<24hr) | 100% | 100% | 100 | Always quick to respond |
| Issue Resolution (SLA) | 95% | 92% | 85 | 1 issue took 5 days |
| Customer Satisfaction | 4.5/5 | 4.3/5 | 90 | Slight dip this month |
| Proactive Communication | Yes | Yes | 100 | Monthly business reviews |
| Category Score | 94 | Good |
Compliance (Weight: 10%)
| Metric | Target | Actual | Score | Notes |
|---|---|---|---|---|
| SLA Compliance (%) | 99.9% | 99.85% | 90 | Minor downtime reported |
| Documentation Accuracy | 100% | 99% | 95 | 1 invoice error |
| Regulatory Certs | Current | Current | 100 | All up-to-date |
| Code of Conduct | Compliant | Compliant | 100 | No violations |
| Category Score | 96 | Excellent |
OVERALL SCORE CALCULATION
| Category | Weight | Score | Weighted |
|---|---|---|---|
| Quality | 30% | 95 | 28.5 |
| Delivery | 25% | 95 | 23.75 |
| Cost | 20% | 89 | 17.8 |
| Service | 15% | 94 | 14.1 |
| Compliance | 10% | 96 | 9.6 |
| TOTAL | 100% | 93.75 |
RATING: EXCELLENT (90-100) / GOOD (80-89) / ACCEPTABLE (70-79) / NEEDS IMPROVEMENT (<70)
Scoring Methodology
Establish Clear Scoring Ranges:
QUALITY - Defect Rate (PPM): Target: <500 PPM 100 points: 0-250 PPM (excellent) 90 points: 251-500 PPM (good) 75 points: 501-1,000 PPM (acceptable) 50 points: 1,001-2,000 PPM (needs improvement) 25 points: 2,001+ PPM (poor) DELIVERY - On-Time Rate (%): Target: 98%+ 100 points: 99%+ (excellent) 95 points: 98-99% (good) 85 points: 96-98% (acceptable) 60 points: 94-96% (needs improvement) 30 points: <94% (poor) COST - Price Per Unit Variance (%): Target: Contract price (0% variance) 100 points: -2% to 0% (excellent, beating price) 90 points: 0% to +1% (good, at contract) 75 points: +1% to +3% (acceptable, slight overage) 50 points: +3% to +5% (needs improvement) 25 points: +5%+ (poor, significant overage)
Performance Trends & Analysis
Track Performance Over Time:
SUPPLIER SCORECARD TRENDS - LAST 6 MONTHS Month | Quality | Delivery | Cost | Service | Overall | Trend -------|---------|----------|------|---------|---------|------- Jan | 92 | 94 | 85 | 92 | 90.5 | Baseline Feb | 94 | 92 | 87 | 93 | 91.2 | Slight up Mar | 93 | 95 | 88 | 94 | 91.8 | Improving Apr | 95 | 96 | 90 | 94 | 93.2 | Strong May | 95 | 95 | 89 | 94 | 92.9 | Sustained Jun | 95 | 95 | 89 | 94 | 93.75 | Excellent TREND ANALYSIS: - Overall score: UP 3.25 points (3.6% improvement) - Quality: Consistently strong; improving process - Delivery: Improved from 92% to 95% (positive trend) - Cost: Slight improvement but watch price increases - Service: Consistently excellent ASSESSMENT: Supplier performing well and improving. Recommend continued partnership.
Improvement Plans (for underperforming suppliers)
When Supplier Falls Below Threshold (e.g., <80 overall score):
SUPPLIER IMPROVEMENT PLAN - ACME Parts Inc. Effective Date: March 1, 2024 Duration: 90 days (30/60/90 day reviews) CURRENT PERFORMANCE: Overall Score: 72/100 (Below acceptable threshold) - Quality: 65 (High defect rate: 1,200 PPM vs. target 500) - Delivery: 72 (On-time rate 93% vs. target 98%) - Cost: 85 (Acceptable) - Service: 75 (Slow response times) SPECIFIC IMPROVEMENT TARGETS: By 30 days (April 1): - Defect rate: Down to 900 PPM - On-time delivery: Up to 95% - Response time: <12 hours for all inquiries By 60 days (May 1): - Defect rate: Down to 700 PPM - On-time delivery: Up to 96.5% - Service satisfaction: 4.2/5 or higher By 90 days (June 1): - Defect rate: Down to 500 PPM (target) - On-time delivery: Up to 98% (target) - Overall score: 80+ (acceptable minimum) ACTION ITEMS: 1. Root cause analysis: Why defect rate high? (Due: March 8) 2. Quality improvement plan: Specific fixes (Due: March 15) 3. Production schedule review: Can they meet 98% on-time? (Due: March 15) 4. Staffing assessment: Adequate resources? (Due: March 15) 5. Weekly touchpoints: Verify progress (Every Monday) SUPPORT FROM US: - Dedicated account manager (assigned: Sarah Kim) - Quarterly business reviews (instead of annual) - Shared visibility to demand forecast - Technical support if needed ESCALATION PATH: - 30-day mark: If not meeting targets, escalate to suppliers' VP - 60-day mark: If still missing targets, consider alternate suppliers - 90-day mark: If overall score <75, begin transition to new supplier SIGNATURE: Our Company: _________________ Date: _________ ACME Parts Inc.: _________________ Date: _________
Strategic Supplier Relationships
Tier Suppliers by Strategic Importance:
TIER 1 - STRATEGIC PARTNERS (5-10% of suppliers, 60-80% of spend) Examples: Primary component supplier, sole-source materials Approach: Collaborative, long-term partnership Frequency: Quarterly business reviews + monthly operational check-ins Governance: Dedicated account managers; joint planning Investment: Joint improvement projects, shared risk/reward TIER 2 - PREFERRED SUPPLIERS (20-30% of suppliers, 15-30% of spend) Examples: Alternative suppliers, secondary components Approach: Performance-based, competitive incentives Frequency: Quarterly business reviews; monthly scorecard reviews Governance: Account manager; escalation path defined Investment: Annual benchmarking; selective improvements TIER 3 - TRANSACTIONAL (60-70% of suppliers, <10% of spend) Examples: Commodity suppliers, spot purchases Approach: Cost-focused, minimal relationship investment Frequency: Annual performance review Governance: Procurement team manages Investment: Minimal beyond scorecard tracking EXAMPLE SCORECARD WEIGHTS BY TIER: Metric | Tier 1 | Tier 2 | Tier 3 --------|--------|--------|-------- Quality | 35% | 30% | 20% Delivery | 30% | 25% | 25% Cost | 15% | 30% | 40% Service | 15% | 10% | 10% Compliance | 5% | 5% | 5% (Tier 1: Invest in quality; Tier 3: Optimize for cost)
Supplier Communication
Monthly Scorecard Review (with supplier):
AGENDA (30-minute call): 1. Overall score review (5 min) - Congratulate on improvements - Flag any concerns 2. Category deep-dives (15 min) - Quality: Any issues to address? - Delivery: On track for month? - Cost: Any challenges? 3. Improvement initiatives (5 min) - What's working well? - What needs focus next month? - Support needed from us? 4. Relationship/feedback (5 min) - How's our partnership? - Any concerns from their side? - Schedule next meeting TONE: Collaborative problem-solving, not punitive
Quarterly Business Review (Tier 1 suppliers):
QBR AGENDA (60 minutes): 1. Business update (10 min) - Company/product roadmap - Market changes - Volume forecast 2. Supplier performance (10 min) - Scorecard trends (6-month view) - Achievements and improvements - Challenges/red flags 3. Strategic initiatives (15 min) - Joint projects (cost reduction, quality improvement) - Product development opportunities - Supply chain optimization 4. Planning (15 min) - Next quarter demand forecast - Capacity planning - Any risks/constraints? 5. Relationship/closing (10 min) - Feedback exchange - Commitment to next quarter - Action items and owners DOCUMENTATION: Distribute meeting notes within 24 hours; track action items
Escalation Triggers
Automatic Escalation to Supplier Leadership if:
- Overall scorecard drops below 75 for 2 consecutive periods - Quality: Defect rate increases >50% from baseline - Delivery: On-time rate falls below 90% - Cost: Price increases >5% without notice - Service: Response time >48 hours or SLA breach - Compliance: Any regulatory/safety violation - Financial: Public evidence of financial distress - Relationship: Loss of key account manager or technical support ESCALATION NOTIFICATION: Send formal letter to supplier's VP/President documenting: - Performance metrics below acceptable threshold - Business impact to our organization - Required improvements and timeline - Consequences if not addressed (supplier review, transition) - Offer to collaborate on improvement plan ESCALATION RESOLUTION: - Executive-level commitment to improve - Detailed action plan with weekly updates - If not improving: Begin transition to alternate suppliers
Best Practices
- Clear Metrics: Align on definitions; avoid ambiguity
- Regular Reviews: Monthly scorecards, quarterly business reviews
- Transparency: Share scores and trends openly with suppliers
- Collaborative: Position as partnership, not adversarial
- Fair Weighting: Reflect what matters to business
- Benchmark: Compare to industry standards and competitors
- Actionable Feedback: Specific improvement areas identified
- Recognition: Celebrate Tier 1 suppliers' achievements
- Continuous Improvement: Joint projects to reduce costs, improve quality
- Risk Mitigation: Diverse supplier base; avoid over-concentration
Use this skill to: Drive supplier accountability, improve performance, manage supply chain risk, and build strategic partnerships.