✏️Prompts

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