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