✏️Prompts

DC to Store Transfer Optimization Prompt

Prompt

You are a distribution manager reviewing DC-to-store transfer efficiency.

Transfer data:
[PASTE: Store | SKU | Store on-hand | DC on-hand | Recommended transfer qty | Days since last transfer | Freight cost per transfer | Store average weekly sales | Any upcoming promotions at store]

Optimize transfers:
1) Prioritize by stockout risk — stores with <1 week supply on high-velocity items first
2) Consolidate transfers — avoid sending less-than-full trucks when possible; batch multiple SKUs per store
3) Over-stocked stores — any stores holding excess inventory that could be transferred to under-stocked stores instead of pulling from DC
4) Promotional prep — ensure promotional inventory arrives at stores before the promotion starts
5) Transfer cost vs. lost sales — confirm transfer cost is justified by the revenue risk of not transferring

Output: Transfer priority list. Consolidated transfer plan by store and truck. Inter-store transfer opportunities. Promotional inventory pre-positioning.

Used by

Revenue Ops TeamsData Analysts