Working with stock: transfers, top-up, defects, prices, order entry
Where to move surplus, what and how much to top up by size, what defects cost, where your price stands against the market from scraped data and whether an order to a supplier is in order before entry.
About the topic
Stock is money lying around in the form of goods: it earns no profit until sold and loses value every day. Working with stock consists of several decisions that must be made consistently. Where should goods move between stores? What and how much should be topped up by size? What do you do with defects? What price relative to the market? And how do you check a supplier order before it becomes a commitment?
Start with transfers. Store A has excess of a model while store B lacks it. A transfer costs money (logistics, time), a discount costs money too. Example: price RUB 3,500, a 30% discount takes RUB 1,050 per unit, a transfer costs RUB 80. If the probability of selling in B at full price is 70%, the expected benefit is 0.7 x 1,050 = RUB 735 against RUB 80 of cost, so move. If the probability is 5%, the benefit is RUB 52, less than 80, and moving is not worth it. The decision is made on the difference, not for tidiness.
Top-up works by cells of store by size. Target stock is set in weeks of cover. Example: a size sells 4 a week, the target is 3 weeks, so 12 units; the display minimum is 2 units so the item is visible; the store has 5, so 7 must be sent, and packs are of 2, so we send 8. If the warehouse can give 100 units and 150 were requested, splitting in proportion to the request is simpler, but better by demand: well-selling sizes get more.
Defects must be counted as a money loss. Example: a batch of 1,000 units, a 3% defect rate gives 30 units; the supplier takes back 60%, so 18 are returned, while 12 units at a cost of RUB 1,500 give a loss of RUB 18,000 to be placed in a reserve. A supplier order must be checked against minimum quantity, multiples, delivery window and payment: with a minimum of 300 and multiples of 12, an order of 310 rounds up to 312. Order size can be estimated with the EOQ formula (economic order quantity): the square root of 2 x annual demand x order cost / holding cost per unit. Example: demand 2,400, order cost RUB 6,000, holding RUB 300 per unit a year: the square root of 96,000 is about 310. But if the minimum is 500, you take 500 and assess what that costs.
Start with stock by store and the question of where goods stand idle. Traps: moving goods without a calculation, holding price against the market on old scraping data, not provisioning for defects.
Key ideas
Transfer versus discount
It is better to calculate the probability threshold in advance. A 25% discount on a RUB 2,400 item takes RUB 600 and a transfer costs RUB 90, so moving pays when the probability of selling there at full price is above 90 / 600 = 15%. Busy stores almost always clear the threshold; for slow ones, look at how this size has sold in recent weeks.
Stock is set in weeks of cover
A size sells 4 a week, a target of 3 weeks gives 12. A display minimum of 2 keeps the shelf from being empty. With 5 on hand 7 are needed, packs of 2 make 8. Rules are applied per cell of store and size.
A limited warehouse is split by demand
Three stores ask for 60, 50 and 40 units of a fast size (150), the warehouse has 100. Proportional splitting gives 40, 33 and 27. But the stores sell 20, 8 and 4 units a week: for three weeks they need 60, 24 and 12, 96 in total. Splitting by demand does not leave the first store with an empty shelf, and spares the other two from excess stock.
Defects are a provision
The provision depends on return terms, not only on the defect rate. In a batch of 2,000 units at RUB 1,200, a 2% defect rate gives 40 pieces. If the supplier takes back half, the loss is 20 x 1,200 = RUB 24,000 (1% of the batch), and if defects are not returned, RUB 48,000 (2%). Return terms change the provision twofold.
An order is checked before sending
A supplier constraint has a price, and it can be calculated. With demand of 3,600 a year, an order cost of RUB 4,000 and holding of RUB 200 per unit, EOQ is about 380: costs of RUB 75,900 a year. With a minimum batch of 600 they are RUB 84,000, which is RUB 8,100 (11%) higher. That is a figure worth raising with the supplier.
Price to market and data age
The price index equals our price divided by the market price. 3,500 / 3,200 gives 1.09, 9% above. But if the scraping data is two weeks old, the index does not reflect the market after promotions. Data freshness is part of the conclusion.
How to work through it
- List stock by store and weekly sales by cell of store and size.
- Find surpluses and shortages and calculate the benefit of a transfer against a discount.
- Set target stock in weeks of cover and a display minimum.
- Calculate top-up with pack rounding and fair warehouse splitting.
- Calculate defects and supplier returns; set a provision.
- Compare prices with the market taking the age of scraped data into account.
- Check the supplier order: minimum, multiples, window, payment; compare with EOQ.
Where to start
Stock by point: “Transfers”, then “Top-up” by size. After the season: “Defects”. Before a price decision: “Price monitoring”, before entering an order: “Order check”. Calculations of the topic in order: “Transfers between points: surplus, need and the gain against a discount”, “Replenishment by size: what and how much to send to stores by size”, “Defects: losses, supplier recovery and a reserve”, “Price monitoring by SKU: index to the market, position and price-scraping freshness”, “Order entry: a check of MOQ, multiples, the delivery window and payment”, “Footwear returns: reasons, reverse logistics, the share back on sale and the loss”, “EOQ: economic order quantity with a minimum lot and volume discounts”, “Allocating a stock among stores: by demand and limits against the proportional”.
Calculations in this topic
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.
Where to move surplus and whether moving pays better than a discount on the spot.
Replenishment by size: what and how much to send to stores by size
From the stock, the goods in transit and the sales of each “store × size” cell calculates the target stock in weeks of cover with a minimum display, the need rounded up to the pack multiple and distributes the limited warehouse across sizes: cells with the lowest cover first. Shows how much to send and what the warehouse lacks.
What and how much to send to stores by size from a limited warehouse.
Defects: losses, supplier recovery and a reserve
By category counts the defect rate, the loss at cost, the proceeds from selling defective items (second grade), the supplier’s recovery, the net loss and an estimate of a reserve for the next period. Shows where defects cost most.
What defects cost, how much the supplier will return and what reserve to set aside.
Price monitoring by SKU: index to the market, position and price-scraping freshness
From a table of prices collected by scraping competitors calculates for each SKU the market median and minimum, your price index, your place among the competitors and the status against the corridor. Excludes stale data and SKUs with too few competitors from the total so that the index is not built on noise.
Where our price stands against the market for each SKU and whether the parsing data can be trusted.
Order entry: a check of MOQ, multiples, the delivery window and payment
Checks an order to a supplier before entry: the minimum lots by SKU, the multiple of the size run or box, the minimum order amount, whether the delivery falls into the window before the sales start and the payment schedule (prepayment and the balance). Suggests corrected quantities.
Is the supplier order right before entry: lots, multiples, the minimum amount, timing and payment.
Footwear returns: reasons, reverse logistics, the share back on sale and the loss
Splits footwear returns by reason (size, defect, did not like), calculates reverse logistics and handling, what share went back on sale as new and at a reduced price (worn returns), how much is lost on the price reduction and write-offs and what one return costs.
What footwear returns cost, what part goes back on sale as new and worn, and what cutting size returns would give.
EOQ: economic order quantity with a minimum lot and volume discounts
Finds the order size at which ordering and holding costs together are lowest, tests volume price breaks, respects the minimum lot and the pack multiple, and shows annual costs and the saving against your size.
In what lots to order so that ordering and holding together cost least, and whether a volume discount pays for a larger lot.
Allocating a stock among stores: by demand and limits against the proportional
Allocates the warehouse stock among stores: first the display minimum, then one pack at a time to the store with the lowest cover while the cover is below the target and there is room. Compares with allocation proportional to demand: cover, the number of stores below target and the expected lost sales over the horizon.
How much to send to each store so that stock cover evens out and how much better that is than allocation proportional to demand.
Self-check questions
- Where does goods sit idle and what does it cost per day?
- What is the probability of selling the transferred goods at full price?
- How many weeks of cover do we hold by size?
- What is the display minimum for each model?
- Do we split a limited warehouse by demand?
- What is the defect rate and what share does the supplier take back?
- How fresh is the price scraping data?
- Does the order break the minimum quantity, multiples or delivery window?
Knowledge check
Multiple-choice questions. The correct answer and the explanation follow each question.
A point sells 15 units a week, the required cover is 4 weeks, there is no minimum display, 100 units are on hand. What does the transfer calculation show?
- A. A shortage of 40 units
- B. A surplus of 40 units
- C. A surplus of 85 units
- D. A surplus of 100 units
Correct answer: B. A surplus of 40 units. The need is 15 × 4 = 60 units, 100 are on hand: the surplus is 100 − 60 = 40, they can be given to points with a shortage. 100 is the whole stock, not its excess; 85 appears if only weekly sales are subtracted; “a shortage” is the opposite sign: the stock is above the need.
Cover 6 weeks, no minimum display, transfer multiple 10. Point A: 150 on hand, sells 10 a week. Point B: 60 on hand, sells 20 a week. Moving costs RUB 50 a unit; an on-the-spot discount on the same batch would be 25% of a price of RUB 2,400. How many units are moved and what is the gain against the discount?
- A. 60 units, a gain of RUB 33,000
- B. 90 units, a gain of RUB 49,500
- C. 60 units, a gain of RUB 36,000
- D. 60 units, a gain of RUB 3,000
Correct answer: A. 60 units, a gain of RUB 33,000. A needs 60 and has a surplus of 90; B needs 120 and has a shortage of 60. The smaller is moved: 60 units. The cost is 60 × 50 = RUB 3,000, a discount on the same batch is 60 × 2,400 × 25% = RUB 36,000, the gain is 36,000 − 3,000 = RUB 33,000. 90 units have nowhere to go: B is short of only 60. RUB 36,000 is the discount without subtracting the cost, RUB 3,000 is the cost alone.
The sales window is 4 weeks, a “store × size” cell sold 6 units. The target cover is 4 weeks, the minimum display is 2, stock 1, in transit 2, shipments are in multiples of 2. How many units should be sent from the warehouse (the warehouse has enough)?
- A. 3 units
- B. 5 units
- C. 6 units
- D. 4 units
Correct answer: D. 4 units. The speed is 6 / 4 = 1.5 a week, the target is max(2, 1.5 × 4 = 6) = 6. The position is 1 + 2 = 3, the need is 6 − 3 = 3, with the multiple of 2 it is 4. 3 appears without rounding to the multiple; 5 if goods in transit and the multiple are ignored (6 − 1); 6 if goods in transit are ignored but rounding to the multiple is applied (5 to 6).
10,000 units sold, 250 defective units (2.5%), a unit cost of RUB 1,200. Defects go as second grade at RUB 500 a unit; the supplier compensates 40% of the residual loss. What is the net loss from defects?
- A. RUB 175,000
- B. RUB 180,000
- C. RUB 105,000
- D. RUB 300,000
Correct answer: C. RUB 105,000. The loss at cost is 250 × 1,200 = RUB 300,000; second grade is 250 × 500 = RUB 125,000; the residual loss is RUB 175,000; the supplier compensates 40%, the net loss is 175,000 × 0.6 = RUB 105,000. RUB 300,000 is the loss before all recoveries, RUB 175,000 is without the supplier compensation, RUB 180,000 (300,000 × 0.6) is without second grade.
Annual demand is 2,000 units, an order costs RUB 400, a unit price is RUB 200, holding is 20% of the price a year. Which batch minimizes the cost of orders and holding (EOQ)?
- A. 100 units
- B. 141 units
- C. 200 units
- D. 2,828 units
Correct answer: C. 200 units. EOQ = √(2 × 2,000 × 400 / (0.2 × 200)) = √40,000 = 200 units. At this batch 10 orders cost RUB 4,000, and holding 200 / 2 × 40 = RUB 4,000: the costs are equal, this is the minimum of the sum. 141 appears without the factor 2 under the root, 100 is the average stock (half the batch), 2,828 if 0.2 is put in the denominator instead of holding per unit of RUB 40.
Common mistakes
- Moving goods without a calculation. Consequence: logistics cost without revenue. Avoid: compare benefit and cost by sales probability.
- Topping up by a general percentage. Consequence: shortage of fast sizes and surplus of slow ones. Avoid: calculate by cell and weeks of cover.
- Not provisioning for defects. Consequence: a sudden loss after receipt. Avoid: a reserve by defect rate and return terms.
- Deciding on price from old data. Consequence: price above market, lost sales. Avoid: record the data age.
- Sending an order without checking conditions. Consequence: supplier refusal or excess stock. Avoid: check minimum, multiples and window.
Russia and the EAEU
Goods flows in Russia go through electronic document exchange: a universal transfer document (UPD) on delivery, a corrective one (UKD) for returns and discrepancies, and a discrepancy act on receipt. For transfers between your own stores internal waybills are used; for marked goods the transfer is also recorded in the marking system, so check the procedure for your group with the operator. Receipt with code checks matters: goods without a code cannot be sold.
Defects and returns to the supplier are handled under the supply contract: deadlines for claims, the return procedure and document corrections are in the contract, so check them before ordering. A provision for inventory impairment is created under FSBU 5/2019 on inventories if net realizable value is below cost. Under consumer protection law a customer can return footwear and clothing of proper quality within 14 days if unused and in original condition; distance selling has its own periods. Check the terms with a lawyer.
Monitoring competitor prices is permitted, but agreeing prices with competitors is prohibited by the competition law (135-FZ). Scraping public pages has legal limits set by site terms, so check with a lawyer. When working with marketplaces, stock is divided by storage scheme (at the platform or with you); see terms and tariffs in the contract and the seller account.
Stock calculations are the same. Documents and taxes differ. For reference: VAT rates by country are on the page “EAEU and CIS countries” (as of 14.11.2026). Moving goods between union countries carries indirect taxes at the place of destination and an import notification, so it is not an internal transfer. Electronic invoices and waybills are local in each country. Marking is introduced at different dates: in Kazakhstan mandatory marking starts on 01.12.2026 in stages (guide, please verify), and in other countries dates: indicative as of 14.11.2026, check the text of the act. Logistics times and rates differ, so use your own.
Categories and audiences
- Apparel
- In apparel: the size run and season determine top-up, stock loses value quickly, so transfers and replenishment are done early. Prices change heavily in promotions, so monitoring is needed often. Defects: seams, stains and size discrepancies.
- Footwear
- For footwear: a wider size grid and more cells, stock breaks at the ends of the run, so transfers between stores are more valuable. Size returns are high: the decision to resell or write off depends on condition. Defects: sole, glue, zips.
- Accessories
- If it is accessories: few sizes, so top-up is simpler and turnover faster. Small SKUs often come in packs, so multiples matter. Defects: hardware, leather seams. Transfers of small items rarely pay back, so count logistics cost per unit.
- Kids
- On children’s wear: sizes by height and a seasonal peak before school, so the order must arrive early and the delivery window is critical. A leftover size loses value after a season. Safety of materials and hardware makes defect inspection stricter.
- Men
- The men’s basket has many core SKUs that repeat from season to season, so transfers and top-up are calculated from the sales history of exactly these store-by-size cells. Most demand falls on middle sizes while extreme ones sell rarely: keep them at the central warehouse and ship to order instead of spreading them across all stores. Leftover core stock need not be cleared with a discount at season end; it carries over.
- Women
- In the women’s line there are many models and a little of each, so a store-by-size cell sells one or two units a week and its sales history is noisy. It is better to count cover by model and color across the network and keep the display minimum: an incomplete size run sells worse. Leftover stock of a fashion SKU loses value toward the end of its window, so move it earlier.
Questions this topic answers
- Where to move surplus and does moving pay against a discount?
- What and how much to top up by size if the warehouse is limited?
- What do defects cost and what reserve is needed?
- Where is our price against the market and can the parsing data be trusted?
- Is the supplier order right before entry?
Key measures and terms
- Transshipment
- Replenishment
- Allocation across stores
- Display minimum
- Stock shrink
- Inventory record accuracy (IRA)
- MOQ (minimum order quantity)
- Median and price corridor
- OTIF
- Transfer: surplus and shortage
- Re-assortment (top-up, “podsortirovka”)
- Reserve and net loss from defects
- Price index to the market (price parsing)
- Order entry: fields and sequence
- Available stock (AS)
- Re-assortment by sales rate and weeks of supply
- Re-assortment by min and max
Study first
What next
Related: “Size runs, stores and range in season”, “Stock accuracy, shrink and availability”, “Stock and turnover”.
Documents on this topic
- Merchandise stock balance
- Stock turnover and dead stock
- Management report pack
- AQL and batch quality inspection
- Buyout, commission sale and consignment: operating cycle and cash
- Warehouse: WMS, handling cost, SLA, returns and cycle counting
- Loss prevention: shrinkage, counting, fraud
- Safety stock, service level and newsvendor: how much to hold and how much to order
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range
- Resale, collaborations and packaging: economics of buy-back and resale, capsule P&L and partner deal structure, the eco fee (EPR)
- Excel for retail, part I: lookup by key, pivot tables and data validation