Inventory rebalancing between regions, line by line
The short answer
Overstock in one region and stockouts in another usually mean the same line sits in the wrong place, and inventory rebalancing fixes it with transfers. Calculate weeks of cover for each line in each region, flag lines above 20 weeks in one place and under 4 in another, and move the difference.
A stock transfer between stores, worked through
Why it matters
Stock stranded in a slow region ends up marked down, while the same line sells out elsewhere at full price. A transfer costs freight, but a well-timed one usually costs far less than the markdown and lost full-price sales it replaces.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Calculate weeks of cover. Divide units on hand by average weekly units sold over the last eight weeks, for every line in every region.
2. Pair surplus with shortage. Match regions above your upper limit with regions below your lower limit on the same line, and size the transfer to bring both toward target.
3. Check who buys it where. Look at the customers behind demand in the receiving region and confirm they buy at full price, so the transfer earns more than a local markdown would.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for an outdoor retailer in early November. It compares stock on hand with weekly sales for a fleece jacket line, against a target of 8 weeks of cover.
- Southwest: 1,800 units, selling 60 a week. 30 weeks of cover.
- Mountain: 240 units, selling 120 a week. 2 weeks of cover.
What the data shows
The Southwest holds 1,320 units more than it needs. The Mountain region is 720 units short.
What it means
75% of the line's Mountain buyers paid full price last season, against 40% in the Southwest. Stock sitting in the Southwest is likely to end up on markdown.
What to do
Transfer 720 units to the Mountain region and pause Southwest replenishment. That leaves the Southwest at 18 weeks of cover.
Would you like the same check across every outerwear line?
Frequently asked questions
How do I set weeks of cover limits?
Base them on lead time and season length. The lower limit should cover the time a transfer or reorder takes to arrive, plus a buffer for demand swings. The upper limit is the point where you expect to need a markdown to clear, which for seasonal lines can be as little as the weeks left in the season.
When does a stock transfer cost more than it saves?
A transfer loses money when freight and handling per unit exceed the margin it protects. Low-price items, or stock that arrives after the receiving region's peak, often fail that test. Compare the cost of moving each unit with the markdown it avoids and the full-price sales it wins, and transfer only where the difference is clearly positive.
Is inventory rebalancing the same as store level inventory optimization?
Rebalancing is one part of it. Store level inventory optimization covers the first allocation, replenishment rules and transfers together. Rebalancing corrects mistakes after stock has landed, so frequent large transfers point to an allocation problem upstream that is worth fixing at the source.