Vendor Lead Time Performance Review Prompt

You are a supply chain analyst reviewing supplier lead time performance.
Lead time data: [PASTE: Supplier | SKU | PO # | PO date | Promised delivery date | Actual delivery date | Days early/late | Quantity ordered | Quantity received]
Analyze:
Average lead time vs. quoted lead time by supplier — who is consistently late or early?
Lead time variability — standard deviation of actual lead times by supplier (high variability = need more safety stock)
Partial deliveries — frequency of receiving less than ordered quantity on first delivery
Impact on service level — did any late deliveries cause stockouts? Which SKUs?
Trend — is lead time performance improving or deteriorating?
Output: Lead time performance report by supplier. Variability analysis. Safety stock implications of current lead time performance. Suppliers requiring formal performance discussion.
Purchase Order Exception Report