Does moving stock between stores pay back
Identifies donors and recipients by cover to the season end, the pieces to move, the gain per piece (with sale probabilities), the total result including fixed costs and the break-even transport cost.
At a glance
- What question does it answer?
- Whether moving surplus from one store to another pays after the season starts.
- What data is needed?
- Stock and average weekly sales by store.
- How to read the result?
- Donors are stores with stock above demand to the season end, recipients have a shortfall. The gain per piece accounts for sale chances and transport; if it is positive and the total exceeds fixed costs, the move pays. The break-even transport cost shows the ceiling for a trip’s price. Example on the default values: Available to give (donors) — 123 pcs; Needed by recipients — 72 pcs; To move — 72 pcs; Gain per piece — RUB 1,215.
Why and how to reason
Moving stock between stores puts goods where they will sell instead of where they sit idle. First work out who can give: a donor surplus is its stock minus the larger of the display minimum and sales until season end (weekly rate × weeks). Then who needs: a receiver gap is sales over the remaining weeks minus what it will still hold after delivery. You move the smaller of supply and need. Then the gain per unit: chance to sell it at the receiver minus chance to sell it at the donor, times margin (price minus cost), minus the transfer cost per unit. Default example: margin 4,100 − 2,000 = RUB 2,100, (90% − 25%) × 2,100 = RUB 1,365, minus RUB 150 transfer gives RUB 1,215 per unit. Donors can give 123 units, receivers need 72, so 72 move: 72 × 1,215 − 4,000 fixed = RUB 83,480. The break-even transfer cost per unit equals the gain before transfer, RUB 1,365.
When to use it
It fits while the season is still running and some stores are clearly over- or under-covered: 18 weeks of stock in one, 5 in another. It assumes sales rates per store are known and do not change because of the move. It does not fit when sizes and models at the donor and receiver differ (you ship what will not sell there), when delivery takes more than half the remaining time, or when the sale chances are guesses. For one or two units the fixed cost eats the gain, so check the minimum-volume line first.
How to read the result
Look at three numbers. Gain per unit: if it is below the transfer cost there is nothing to move. Break-even transfer cost: the larger the headroom, the more robust the decision to rate rises. Minimum volume (4 units here): if fewer units qualify, do not ship, or combine with another run. The RUB 83,480 total is an expected gain, not a guaranteed profit: it rests on the 90% and 25% chances. Set cautious values (70% and 40%) and check the total stays positive. If receivers need clearly less than donors can give, surplus remains in the network, which signals a price cut or sale rather than a transfer.
Common mistakes
The main error is inflating the receiver sale chance because it is a busy store, without checking its sales. Second, entering the whole shipment cost as a per-unit cost, or a per-unit cost as fixed. Third, forgetting delivery time, so goods arrive after the season ends. Also: picking a donor that sells exactly the sizes the receiver lacks. Do not enter 100% and 0% as sale chances: they make the gain unrealistically large.
What data is needed?
- Stock and average weekly sales by store.
- Weeks to the season end, price, cost, transport cost per piece.
- Optional: fixed costs, sale chances, delivery time, display minimum.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Weeks to the season end | weeks | 8 | How many weeks remain to the end of the season: the stores’ demand is calculated for them. |
| Price excl. VAT | ₽ | 4,100 | The selling price of a unit excl. VAT: the revenue from selling the moved goods is counted from it. |
| Unit cost | ₽ | 2,000 | Unit cost excl. VAT. |
| Transport cost per piece | ₽ | 150 | What it costs to move one unit between stores, excl. VAT. |
| Fixed cost of the move | ₽ | 4,000 | Trip, packing, labor. Empty: zero. |
| Chance to sell a piece at the recipient | % | 90 | By the season end at full price. An estimate from pace and cover, replace with yours. |
| Chance to sell that piece at the donor | % | 25 | A surplus piece at the donor goes to markdown: an estimate, replace with yours. |
| Delivery time | weeks | 1 | Empty: zero. Until arrival the recipient sells its own stock. |
| Store display minimum | pcs | 6 | A donor does not give what is below the minimum: otherwise the run breaks. Empty: zero. |
How it is calculated
| Step | Formula |
|---|---|
| Donor surplus | stock − max(display minimum; weekly sales × weeks to the end), rounded down |
| Recipient shortfall | weekly sales × (weeks − delivery) − stock left at arrival, rounded up |
| Whole pieces | the volume to move is split between stores in proportion to surplus and shortfall by the largest-remainder method: the sum equals the volume exactly |
| Result | min(surplus; shortfall) × ((recipient chance − donor chance) × (price − cost) − transport) − fixed |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Available to give (donors)
- 123 pcsStock above demand to the season end and the display minimum.
- Needed by recipients
- 72 pcsDemand to the season end above stock, allowing for delivery time.
- To move
- 72 pcsThe smaller of the two: either recipients or donors run out first.
- Gain per piece
- 1,215 ₽(recipient chance − donor chance) × (price − cost) − transport.
- Result of the move
- 83,480 ₽Pieces to move × gain per piece − fixed costs.
- Break-even transport cost per piece
- 1,365 ₽Above this the move does not pay at any volume.
- Minimum volume to cover the fixed cost
- 4 pcs
Stores: role and movement
| Store | Stock | Sales a week | Cover, weeks | Role | Movement, pcs |
|---|---|---|---|---|---|
| Store A | 180 | 10 | 18 | donor | −59 |
| Store B | 60 | 12 | 5 | recipient | +36 |
| Store C | 95 | 9 | 10.6 | donor | −13 |
| Store D | 20 | 7 | 2.9 | recipient | +36 |
| Store E | 40 | 5 | 8 | neutral | 0 |
A move pays for expensive items with a big cover gap; for cheap ones it is simpler to mark down. Do not take a store’s last set: it breaks the size run (see “Size-run completeness”).
Moving labelled goods between legal entities is done by a transfer through electronic document exchange; within one entity the procedure differs. Check the procedure with the labelling operator against the current rules.
Nuances and limits
- Do not take a store’s last set.
- The pieces in the table are whole: a donor’s surplus is rounded down, a recipient’s shortfall up, and the volume is split by the largest-remainder method.
- Do not count pace over promotion weeks.
- Allow for delivery time: it shortens selling time.
- Check the procedure for transferring labeled goods with the operator.