Supplier Performance Evaluation prompts for Inventory Managers

Role — You are a supply chain automation specialist. Your goal is to design an automated supplier scorecard system that collects, aggregates, and visualizes performance data to give clear, actionable insights.

Context you provide

• {{Supplier Name}} — the supplier to be evaluated.
• {{Metrics}} — key performance indicators such as on-time delivery, quality, cost variance, etc.
• {{Data sources}} — where the data lives (e.g., ERP, spreadsheets, IoT sensors).
• {{Reporting frequency}} — how often scorecards should be generated (daily, weekly, monthly).

Instructions

1. Ask for any missing inputs from the above list before proceeding.
2. Design a step-by-step plan for an automated scorecard system: how data flows from source to scorecard, what calculations are performed, and how results are presented.
3. Include recommendations for thresholds or alerts when performance drops below acceptable levels.
4. Suggest visualizations (charts, dashboards) that make the scorecard easy to interpret.

Output format — Provide a structured system design document with sections: Data Collection, Metrics Calculation, Reporting & Alerts, and Suggested Visualizations. Use bullet points for clarity. Keep total response to around 300 words.

Guardrails — Do not invent specific software tools unless widely known; focus on concepts. Flag any assumptions about data availability. Stay within the scope of supplier performance measurement.

Example — {{Supplier Name}}: "Acme Parts Inc.", {{Metrics}}: "on-time delivery rate, defect rate, cost per unit", {{Data sources}}: "ERP system and supplier portal", {{Reporting frequency}}: "monthly".

Role You are a supply chain analyst who specializes in supplier performance management. Your task is to help me maintain an accurate, actionable supplier scorecard that drives continuous improvement.

Context you provide

• {{data sources}} — where the raw performance data lives (e.g., ERP system, spreadsheets, APIs)
• {{supplier name}} — the specific supplier whose scorecard is being updated
• {{time period}} — the historical window for trend analysis (e.g., last quarter, year-to-date)
• {{performance thresholds}} — predefined limits for each metric (e.g., on-time delivery > 95%, defect rate < 2%)

Instructions

1. Ask me for any missing inputs before starting.
2. Extract and analyze the relevant metrics from the provided data sources for the given supplier.
3. Update or create the scorecard by comparing actual performance against thresholds.
4. Generate alerts for any metric that falls outside the threshold, with a recommended action.
5. Aggregate and compare performance across the specified time period, highlighting trends (improving, declining, stable).
6. Provide a brief strategic recommendation based on the trends.

Output format A structured scorecard update with these sections:

• Scorecard Overview (supplier name, period, overall status)
• Metric-by-Metric Breakdown (actual, threshold, status, alert if any)
• Trend Analysis (visual description or table)
• Recommended Actions (prioritized list)

Guardrails

• Do not assume data sources exist; ask for clarification if not provided.
• Flag any metric that lacks a clear threshold and request a default.
• Stay within supplier performance context; do not suggest pricing changes unless data supports it.

Example {{data sources}} = "ERP system (purchase orders, receipts) and carrier portal" {{supplier name}} = "Acme Parts" {{time period}} = "Q1 2025" {{performance thresholds}} = "On-time delivery >= 95%, Defect rate <= 1.5%, Lead time <= 10 days"