Build supplier performance scorecards with KPIs, quality metrics, delivery performance, cost management, and improvement plans
npx skills add https://github.com/w95/awesome-claude-corporate-skills --skill supplier-scorecard
Establish supplier performance metrics that drive accountability, identify improvement opportunities, and ensure supplier excellence. Scorecards balance compliance, quality, delivery, cost, and relationship factors.
Quality Metrics (Product delivered meets specifications):
Delivery Metrics (Goods arrive on time, complete):
Cost Metrics (Pricing and cost management):
Service Metrics (Responsiveness and support):
Compliance Metrics (Legal, regulatory, contractual):
SUPPLIER PERFORMANCE SCORECARD
Supplier: [Name]
Reporting Period: [Month/Quarter]
Overall Score: [Score] / 100
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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)
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)
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.
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: _________
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)
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
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
10. 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.
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.
Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.
MATLAB and GNU Octave numerical computing for matrix operations, data analysis, visualization, and scientific computing. Use when writing MATLAB/Octave scripts for linear algebra, signal processing, image processing, differential equations, optimization, statistics, or creating scientific visualizations. Also use when the user needs help with MATLAB syntax, functions, or wants to convert between MATLAB and Python code. Scripts can be executed with MATLAB or the open-source GNU Octave interpreter.
UMAP dimensionality reduction. Fast nonlinear manifold learning for 2D/3D visualization, clustering preprocessing (HDBSCAN), supervised/parametric UMAP, for high-dimensional data.
Creating interactive data visualisations using d3.js. This skill should be used when creating custom charts, graphs, network diagrams, geographic visualisations, or any complex SVG-based data visualisation that requires fine-grained control over visual elements, transitions, or interactions. Use this for bespoke visualisations beyond standard charting libraries, whether in React, Vue, Svelte, vanilla JavaScript, or any other environment.
Access AlphaFold 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology.
Comprehensive Python library for astronomy and astrophysics. This skill should be used when working with astronomical data including celestial coordinates, physical units, FITS files, cosmological calculations, time systems, tables, world coordinate systems (WCS), and astronomical data analysis. Use when tasks involve coordinate transformations, unit conversions, FITS file manipulation, cosmological distance calculations, time scale conversions, or astronomical data processing.
Take w95/supplier-scorecard from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.