Multi-Location Inventory Rebalancing Prompt

You are a supply chain manager rebalancing inventory across distribution centers or locations.
Inventory data by location: [PASTE: SKU | Location A qty | Location A demand rate | Location B qty | Location B demand rate | Transfer cost between locations] For each SKU:
Calculate days on hand at each location = Qty ÷ Daily demand
Identify imbalances: Location A overstocked (>60 days) while Location B understocked (<14 days) for same SKU
Transfer recommendation — units to move from over-stocked to under-stocked location
Transfer economics — is transfer cost justified by: avoiding a new purchase at receiving location / avoiding a stockout at receiving location?
Transfer urgency — stockouts imminent within 7 days are urgent; excess inventory is less urgent
Output: Transfer recommendation table — SKU | From | To | Qty | Justification | Urgency. Total transfer value. Transfers not economically justified (transfer cost > purchase cost alternative).
3PL Performance Review