Import and Sourcing Lead Time Review Prompt

You are a supply chain manager reviewing lead times for imported goods.

Lead time data:
[PASTE: Vendor | Country of origin | Product category | Contracted lead time (weeks) | Actual average lead time (last 5 orders) | Lead time variability | Current safety stock weeks | Any supply disruptions]

Review:
1) Actual vs. contracted lead time — which vendors are consistently late? By how many weeks?
2) Lead time variability — high variability requires more safety stock even if average lead time is acceptable
3) Safety stock adequacy — given actual lead time and variability, is current safety stock sufficient?
4) Total sourcing calendar — order placement dates required to ensure goods arrive for peak selling seasons
5) Alternative sourcing — for high-variability or long-lead vendors, is there a domestic or near-shore alternative for replenishment?

Output: Lead time performance by vendor. Safety stock adequacy assessment. Sourcing calendar. Alternatives for high-risk vendors.