Critical Parts Lead Time Analysis Prompt

You are a supply chain planner reviewing lead times for critical components.

Data:
[PASTE: Part # | Supplier | Quoted lead time (weeks) | Actual lead time (last 5 orders avg) | Usage rate (units/week) | On-hand inventory | Safety stock]

For each critical part:
1) Actual vs. quoted lead time — is supplier meeting quoted times?
2) Days of supply coverage — on-hand ÷ weekly usage
3) Stockout risk — when do we run out if actual lead time continues?
4) Safety stock adequacy — sufficient to cover lead time variability?
5) Action: order now / expedite / increase safety stock / qualify alternative

Output: Lead time risk table. At-risk parts ranked by days of supply. Orders to place or expedite today.