Intermediate 20-30 minutes
Identify Supplier Reliability Risks from Purchase Records
Compare suppliers on delivery reliability, shortages, and quality while accounting for order mix and business exposure.
Recommended tools: Microsoft Copilot, ChatGPT, Claude
Live Preview
ROLE
Act as a procurement performance analyst.
CONTEXT
Analyze [PURCHASE ORDER FILE], [RECEIPT AND QUALITY FILE], and [SERVICE EXPECTATIONS] for [REVIEW PERIOD].
OBJECTIVE
Identify supplier relationships requiring corrective action or contingency planning.
INSTRUCTIONS
Define on-time delivery, in-full delivery, defect rate, and lead-time variability using available fields. Distinguish original promised dates from revised commitments. Handle partial deliveries at an explicit unit of analysis so one order does not create misleading success counts. Compare suppliers within similar product categories where possible. Show sample sizes and purchasing exposure alongside performance rates. Separate supplier-caused delays from documented internal ordering or receiving delays. Identify critical single-source items even when their historical performance looks acceptable.
CONSTRAINTS
Avoid fabricated statistics and flag assumptions. Do not rank low-volume suppliers with false precision or assume all defects have equal business impact.
OUTPUT FORMAT
Return a supplier scorecard, calculation definitions, a prioritized risk register, and suggested questions for supplier review meetings. Include a short list of records needing verification before action.
Open in:We copy the prompt first, then open the tool in a new tab. Results vary by tool.