Supplier Performance Scorecard Builder

The Prompt

This prompt creates comprehensive supplier scorecards with weighted metrics and executive-ready visuals:

<role_activation>
You are the Chief Procurement Officer's strategic analyst, specializing in supplier performance management for Fortune 500 manufacturing and distribution companies. You've built scorecard systems for 500+ supplier bases and understand both the quantitative metrics and the relationship dynamics of supplier management.
</role_activation>

<analysis_objective>
Create a weighted supplier performance scorecard system that:
1. Evaluates suppliers across multiple dimensions
2. Produces visual comparisons (radar charts, rankings)
3. Identifies improvement opportunities and risks
4. Generates actionable development plans
</analysis_objective>

<supplier_data>
<raw_performance_data>
[PASTE YOUR SUPPLIER PERFORMANCE DATA HERE]

Suggested columns:
- Supplier Name
- Spend Category
- Annual Spend ($)
- On-Time Delivery % (last 12 months)
- Quality Defect Rate (PPM or %)
- Price Competitiveness (vs. market benchmark)
- Lead Time (days)
- Lead Time Variability (std dev)
- Invoice Accuracy %
- Responsiveness Score (1-5)
- Innovation/Value-Add Score (1-5)
- Financial Stability Rating
- Sustainability/ESG Score
</raw_performance_data>

<business_context>
- Industry: [e.g., Automotive, Aerospace, Consumer Goods]
- Strategic priorities: [e.g., Cost reduction, Quality improvement, Supply security]
- Critical categories: [e.g., Semiconductors, Specialty Chemicals]
- Suppliers requiring special attention: [list any]
</business_context>
</supplier_data>

<scorecard_methodology>
### Dimension Weights (customize based on your priorities)
Provide your weightings totaling 100%:

| Dimension         | Weight | Metrics Included                        |
|-------------------|--------|----------------------------------------|
| Quality           | 25%    | Defect rate, Returns, Certifications   |
| Delivery          | 25%    | OTD %, Lead time, Variability         |
| Cost              | 20%    | Price trend, Total cost, Savings       |
| Service           | 15%    | Responsiveness, Communication, Support |
| Innovation        | 10%    | New products, Process improvements     |
| Risk              | 5%     | Financial health, Capacity, Geography  |

Or state: "Use your recommended best-practice weights for [industry]"
</scorecard_methodology>

<required_outputs>
Execute Python code to produce:

### 1. Scorecard Calculation Engine
- Normalize all metrics to 0-100 scale
- Apply dimension weights
- Calculate composite score per supplier
- Rank suppliers overall and by category

### 2. Visual Dashboard
Create these charts:
a) **Radar Chart** (per supplier): 6-spoke chart showing each dimension
b) **Ranking Bar Chart**: Suppliers ranked by composite score with color bands
   - Green: 80+ (Preferred)
   - Yellow: 60-79 (Acceptable)
   - Red: <60 (Development Required)
c) **Quadrant Matrix**: Spend (Y) vs. Performance (X) with supplier bubbles
d) **Trend Lines**: Performance over last 4 quarters (if historical data provided)

### 3. Supplier Segmentation
Classify each supplier into:
- **Strategic Partners** (high spend + high performance)
- **Leverage Suppliers** (high spend + medium performance)
- **Bottleneck Suppliers** (low spend + critical risk)
- **Routine Suppliers** (low spend + adequate performance)

### 4. Action Plans
For each underperforming supplier, generate:
| Supplier | Gap Area | Current | Target | Action | Timeline | Owner |

### 5. Executive Summary
- Top 5 performers with recognition recommendation
- Bottom 5 with risk assessment
- Portfolio risk score
- Recommended strategic actions (3-5 bullets)
</required_outputs>

<output_format>
Structure as a board-ready presentation:
1. One-page visual dashboard (charts)
2. Detailed scorecards by supplier
3. Risk heat map
4. Action tracker
5. Appendix with methodology and raw scores
</output_format>

How to Use This Prompt

1. Export supplier metrics: Pull from your SRM system, ERP, or quality database
2. Customize weights: Align dimensions with your procurement strategy
3. Add business context: Help the AI understand what matters to your organization
4. Run analysis: Get instant scorecards with visualizations
5. Use for QBRs: Share radar charts directly with suppliers

Sample Input Data

Supplier,Category,AnnualSpend,OTD_Pct,DefectPPM,PriceIndex,LeadDays,Responsiveness
Acme Corp,Raw Materials,2500000,94.2,1200,98,14,4
BestParts Inc,Components,1800000,88.5,3500,95,21,3
ClearSource,Packaging,750000,97.8,500,102,7,5

Follow-Up Analysis Prompts

• “Deep dive into Acme Corp: what’s driving the quality gap?”
• “Model the impact if we shift 30% of spend from BestParts to ClearSource”
• “Generate talking points for the BestParts QBR focusing on delivery improvement”
• “Which suppliers should we dual-source to reduce risk?”