Syntha Lab RU

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.

Working with stock: transfers, top-up, defects, prices, order entry For whom: Logistics and chain directors, category managers, regional managers.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Target stock coverweeks6How many weeks of sales a point’s stock should cover. You set it; there is no single standard in Russia.
Minimum display per pointpcs12We do not leave a point with fewer units than this, even with no sales.
Lot multiple of a transferpcs5We move quantities that are multiples of this number (a box, a pack). Rounded down.
Price per unit excl. VAT₽3,000Amount 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%30The discount depth needed to clear the surplus with no transfer.
Cost of moving one unit₽45Carriage, 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

StepFormula
Requiredthe larger of (sales a week × target cover, minimum display), rounded up
Surplus and shortagestock − required, if above zero; required − stock, if above zero
Transferthe smaller of (surplus, shortage) rounded down to the multiple; points with the lowest cover receive, points with the largest surplus give
Gainunits × 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

PointStockCover, weeksRequiredSurplusShortageGivesGets
Center4002012028001500
Mega120324001200120
North3003060240000
South60490030030

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.

Terms used

Calculate on your data →