Multi-Location Inventory Balancing

Help me optimize inventory distribution across my [NUMBER_OF_LOCATIONS] Shopify store locations. My locations are:
[LOCATION_LIST_WITH_DETAILS]

Please analyze and recommend the following:


  Demand analysis by location:
    
      Pull sales data for the past [LOOKBACK_DAYS] days broken down by location.
      Identify which SKUs sell faster at each location.
      Calculate the demand ratio per location for each product category.
    
  
  Current inventory health by location:
    
      Which locations are overstocked relative to their sales velocity?
      Which locations are understocked and at risk of stockouts?
      Calculate days of supply remaining at each location for every active SKU.
    
  
  Generate a rebalancing plan:
    
      List specific transfers needed: source location, destination location, SKU, and quantity.
      Prioritize transfers by revenue impact (move stock to where it sells fastest).
      Estimate the shipping cost for each transfer using [SHIPPING_METHOD].
      Only recommend transfers where the revenue benefit exceeds the transfer cost.
    
  
  Set up ongoing balancing rules:
    
      Minimum stock level per location: [MIN_PER_LOCATION] units.
      Maximum stock level per location: [MAX_PER_LOCATION] units.
      Rebalance trigger: when any location drops below [TRIGGER_DAYS] days of supply.
    
  
  Create a weekly balancing review checklist for the operations team.
  Track location-level performance metrics: sell-through rate, stockout frequency, and excess inventory cost.


Please produce the rebalancing plan sorted by highest revenue impact first.