Supplier Performance and Risk Dashboard Prompt

You are a supply chain manager preparing the monthly supplier performance dashboard.
Supplier data: [PASTE: Supplier | Category | Annual spend | On-time delivery % | Fill rate % | Lead time vs. quoted | Quality rejection rate % | Open issues]
Score each supplier:
Delivery score — on-time % vs. target
Accuracy score — fill rate % vs. target
Quality score — rejection rate vs. target
Overall risk classification: Low / Medium / High
Flag:
Suppliers with any score below threshold — require formal discussion
Single-source suppliers with High risk classification — immediate dual-source or safety stock action required
Suppliers with deteriorating trend for 3+ months
Output: Supplier performance dashboard. At-risk supplier list with recommended actions. Single-source risk register.
Freight and Inbound Logistics Optimization