Syntha Lab RU

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.

Size runs, stores and range in season For whom: Chain managers, merchandisers and logisticians.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Weeks to the season endweeks8How many weeks remain to the end of the season: the stores’ demand is calculated for them.
Price excl. VAT₽4,100The selling price of a unit excl. VAT: the revenue from selling the moved goods is counted from it.
Unit cost₽2,000Unit cost excl. VAT.
Transport cost per piece₽150What it costs to move one unit between stores, excl. VAT.
Fixed cost of the move₽4,000Trip, packing, labor. Empty: zero.
Chance to sell a piece at the recipient%90By the season end at full price. An estimate from pace and cover, replace with yours.
Chance to sell that piece at the donor%25A surplus piece at the donor goes to markdown: an estimate, replace with yours.
Delivery timeweeks1Empty: zero. Until arrival the recipient sells its own stock.
Store display minimumpcs6A donor does not give what is below the minimum: otherwise the run breaks. Empty: zero.

How it is calculated

StepFormula
Donor surplusstock − max(display minimum; weekly sales × weeks to the end), rounded down
Recipient shortfallweekly sales × (weeks − delivery) − stock left at arrival, rounded up
Whole piecesthe volume to move is split between stores in proportion to surplus and shortfall by the largest-remainder method: the sum equals the volume exactly
Resultmin(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

StoreStockSales a weekCover, weeksRoleMovement, pcs
Store A1801018donor−59
Store B60125recipient+36
Store C95910.6donor−13
Store D2072.9recipient+36
Store E4058neutral0

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.

Terms used

Calculate on your data →