In-Transit and On-Order Visibility Prompt
Prompt
You are a supply chain planner reviewing in-transit and on-order inventory. In-transit data: [PASTE: PO # | Vendor | SKU | Units | Expected delivery date | Origin (domestic/international) | Current status | Any delays reported | Weeks of supply on hand while waiting] Review: 1) On-time arrival status — POs arriving on schedule vs. at risk of delay 2) Stockout risk while in transit — items where current on-hand will run out before the PO arrives; expedite or find alternative 3) Overdue POs — past expected delivery date; immediate follow-up with vendor or freight forwarder 4) Inventory build projection — total inventory position (on-hand + in-transit) by SKU; avoid over-receiving 5) Priority POs — orders for high-velocity items or seasonal goods where delay has significant revenue impact Output: In-transit status report. At-risk stockout items. Overdue PO list. Priority POs requiring expedite action.
Used by
Data AnalystsRevenue Ops Teams