Transfers between points: surplus, need and the gain against a discount
From the stock and selling speed of each point (a store or a warehouse) finds where there is a surplus above the required cover and where a shortage, picks transfers with lot multiples and compares the cost of moving with the discount that would have to be given to clear the surplus on the spot.
At a glance
- What question does it answer?
- Where to move surplus and whether moving pays better than a discount on the spot.
- What data is needed?
- By point: stock and sales a week; rules: cover in weeks, minimum display, lot multiple.
- How to read the result?
- On the example of 4 points with a 6-week cover the surplus is 520 units and the shortage 150 (“Mega” 120, “South” 30). 150 units are moved: a cost of 6,750 against a discount on the same units of 135,000, a gain of 128,250 (855 per unit). The remaining 370 units of surplus are candidates for a price cut or a return to the warehouse. Example on the default values: Surplus above the required cover: 520 pcs; Shortage below the required cover: 150 pcs; Can be moved: 150 pcs; Surplus left after transfers: 370 pcs. The figures are illustrative: enter your own to see your result.
Why and how to reason
The same item can be surplus in one store and short in another. Before cutting the price of an excess, check whether it can be moved to where it sells. How much to hold at a point: max (weekly sales × target cover, minimum display). Surplus = stock − needed, shortage = needed − stock. In the example, with 6 weeks of cover: Central needs 120 units but holds 400, surplus 280; Mega needs 240, holds 120, shortage 120. Total surplus 520 and shortage 150. We move no more than the smaller of the two, in multiples of the pack of 5: 150 units. The move costs 45 per unit, 6,750; the same batch with a 30% discount on the spot would cost 150 × 3,000 × 30% = 135,000. Benefit 128,250 (855 per unit). A surplus of 370 units remains: moving does not solve it.
When to use it
Use it mid-season, while demand still exists, and when balancing stock between stores. It suits a chain and a brand with several warehouses. It does not suit cases where moving costs are comparable to the item price, nor expensive one-off pieces with a specific buyer. Assumptions: sales speed at a point will be the same after the move; cost per unit is constant; the on-the-spot discount is your estimate of the alternative.
How to read the result
Look at “can be moved” and “benefit of moving versus a discount”: if positive, moving beats a sale. The remaining surplus is what can only be solved by a discount, a sale or another channel. A shortage that nothing can cover means a reorder is needed. Check cover: if the recipient’s cover after the move is below target you need another source. But consider not only money: a move takes days and for seasonal goods time costs money. The decision: which pairs of points to move now and which remainder to leave for a discount. Write down which stock you move and which you give to a discount, and check the result after a week.
Common mistakes
Counting sales speed from one week: a random spike gives a false surplus. Ignoring minimum display: a store with stock below it is counted as “short” although there are almost no sales. Forgetting that goods in transit do not sell. Another mistake: comparing the cost of moving only with the price difference, ignoring sales lost during the days in transit.
What data is needed?
- By point: stock and sales a week; rules: cover in weeks, minimum display, lot multiple.
- Price, the discount “on the spot”, the cost of moving a unit.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Target stock cover | weeks | 6 | How many weeks of sales a point’s stock should cover. You set it; there is no single standard in Russia. |
| Minimum display per point | pcs | 12 | We do not leave a point with fewer units than this, even with no sales. |
| Lot multiple of a transfer | pcs | 5 | We move quantities that are multiples of this number (a box, a pack). Rounded down. |
| Price per unit excl. VAT | ₽ | 3,000 | Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
| The discount that would have to be given on the spot | % | 30 | The discount depth needed to clear the surplus with no transfer. |
| Cost of moving one unit | ₽ | 45 | Carriage, picking, receiving. Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
How it is calculated
| Step | Formula |
|---|---|
| Required | the larger of (sales a week × target cover, minimum display), rounded up |
| Surplus and shortage | stock − required, if above zero; required − stock, if above zero |
| Transfer | the smaller of (surplus, shortage) rounded down to the multiple; points with the lowest cover receive, points with the largest surplus give |
| Gain | units × price × discount − units × cost of moving |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Surplus above the required cover
- 520 pcs
- Shortage below the required cover
- 150 pcs
- Can be moved
- 150 pcs
- Surplus left after transfers
- 370 pcs
- Shortage left after transfers
- 0 pcs
- Cost of transfers
- 6,750 ₽
- A discount on the same units on the spot
- 135,000 ₽
- Gain of moving against a discount
- 128,250 ₽
- Gain per unit
- 855 ₽
By point
| Point | Stock | Cover, weeks | Required | Surplus | Shortage | Gives | Gets |
|---|---|---|---|---|---|---|---|
| Center | 400 | 20 | 120 | 280 | 0 | 150 | 0 |
| Mega | 120 | 3 | 240 | 0 | 120 | 0 | 120 |
| North | 300 | 30 | 60 | 240 | 0 | 0 | 0 |
| South | 60 | 4 | 90 | 0 | 30 | 0 | 30 |
It is assumed that the units moved sell at the new point at full price within the cover; if demand there is weaker, the gain is smaller. Surplus that could not be moved is a candidate for a price reduction or a return to the warehouse.
Nuances and limits
- Counting the gain without checking that demand really exists at the new point.
- Moving small lots: the cost per unit can eat the gain.