Syntha Lab RU

Warehouse and data: capacity for the peak, stock and sales reconciliation, returns, RFID and slotting

The document links the warehouse and the ledger: how many places are needed for the peak, how to check that the stock movement and sales match between the till, the ledger and the bank, what one return costs and which measures (RFID, ABC layout) pay back. The decision it supports: what to spend the money and attention of the warehouse on and in what order to fix the data.

Production, logistics, channels Brand and retail Verified: 2026-11-17

Open interactively →

Why this document

A warehouse is designed for the average stock and breaks at the peak. Data are reconciled once a year at the stock count while the gap accumulates every day. Returns are counted by the receiving cost, forgetting scrap and frozen capital. Each of these mistakes is costly on its own but together they make the warehouse slow and the reports disputable. There are no common norms: utilization, tolerances and terms are your rules, the calculations show their price.

At a glance

What is this document and why is it needed?
The document links the warehouse and the ledger: how many places are needed for the peak, how to check that the stock movement and sales match between the till, the ledger and the bank, what one return costs and which measures (RFID, ABC layout) pay back. The decision it supports: what to spend the money and attention of the warehouse on and in what order to fix the data.
Who owns the document and how often is it rebuilt?
The head of the warehouse and logistics together with financial control: count before the season and at the close of each period.
What mistakes are the most common?
Designing a warehouse by the average stock → the peak breaks the work → count by the peak stock. Keeping utilization above 90% → processes interfere → allow 80–85% and a growth margin. Comparing stocks of different dates → the gap is spurious → reconcile at one date.

For whom

Brand
A brand with its own warehouse or an operator plans the capacity for November–December in advance: the operator needs a peak forecast several months ahead, and online returns go through the brand warehouse.
Retail
A retailer reconciles the till, the ledger and acquiring daily and keeps store stocks accurate because goods availability on the shelf directly gives revenue.

What it consists of

Warehouse capacity for the peak

  • Peak stock equals the average multiplied by the peak coefficient. The number of places comes from dividing the peak by units per place and by the target utilization: 120,000 units at 40 per place and 85% utilization give 3,529 places. The area equals the places multiplied by the place area and by one plus aisles: 6,353 m², and with a 15% growth margin 7,306 m².
  • Utilization above 90% slows the warehouse: receiving, put-away and picking interfere. In the low season with the same warehouse utilization is about 53%, so think of a seasonal warehouse or an operator capacity for the peak and not a yearly lease of the whole area.

Stock roll-forward reconciliation

  • The invariant is simple: beginning stock plus receipts, minus sales, plus returns, minus transfers and write-offs, plus adjustments equals the ending stock. In the example 10,650 pieces are expected while the actual is 10,400: a gap of −250 pieces, 1.4% of beginning plus receipts, −RUB 275,000 at a cost of RUB 1,100. The 0.5% tolerance is exceeded.
  • The sign of the gap hints where to look. Actual below the record: unposted write-offs or sales, short receipt, a transfer without receipt. Actual above the record: an unposted receipt, a return counted twice, a counting error. If the gap equals one of the lines or is twice it, that line is probably unposted, posted twice or with a reversed sign.
  • Compare stocks at one date and for one period; first reconcile on the total, then by the SKUs of the highest cost. Electronic documents and labeling data must agree with the movement.

Sales reconciliation: till, ledger, acquiring, bank

  • Net sales equal gross minus returns and discounts: in the example RUB 9.4 million against 9.4 million in the ledger, a gap of RUB 50,000. The expected non-cash receipt equals non-cash sales multiplied by one minus the acquiring fee: RUB 6.9 million against 6.8 million at the bank. The difference of −RUB 60,000 is explained by the effective fee of 2.9% instead of the contractual 2%.
  • Do not compare sales and receipts without the settlement lag: money for the sales of the last days comes in the next period. For this the calculation has fields for receipts of the previous period and not yet credited sales. Take till data from fiscal documents and not from manual shift reports.

Returns: what one costs and what to speed up

  • Processing adds up from receiving, inspection and packing: RUB 95 per unit. Of the price of RUB 3,000, RUB 2,556 comes back to sale (78% as new, 12% to B-grade at 60% of the price, 10% scrap). The loss per return is RUB 539, at 10,000 returns a month RUB 5.4 million, and that is 32% of the unit margin.
  • Capital frozen for four days costs RUB 31,342 a month; each day of shortening the time to restock saves RUB 7,836. This is often more important than saving on receiving. For marketplaces the return goes through the platform and it sets the refund time and the processing.

RFID and slotting: what pays back

  • The RFID effect adds up from the margin of higher availability, the saved stock count hours and reduced losses: RUB 4.9 million a year in the example. First-year costs are RUB 3.6 million, payback 8.8 months, but tags are bought every year and the effect after the first year is RUB 2.5 million. Confirm availability growth with a pilot and not a supplier estimate.
  • Slotting by ABC shortens the picker path: fast goods lie in the near zones. The gain equals the path reduction multiplied by the share of walking in picking time. Update ABC before the season: at the peak the set of fast items changes and an outdated layout lengthens the path.

The order of work before the season

  • Three months before the peak count the capacity and agree with the operator. A month before reconcile stocks and sales, fix the largest gaps and update ABC. In the season look at the gap daily, count returns by weeks. After the season compare the actual with the assumptions: the peak coefficient, the scrap share, the time to restock.

Where the data comes from

Data sourceFields
The ledger and the warehouse systemstocks at dates, receipts, transfers, write-offs, adjustments, storage places
Till, acquiring, bankfiscal receipts, returns, cash, the contractual fee, credits by date
Warehouse and returnsreturn outcome shares, time to restock, ABC by order lines, picking timing

How to build it step by step

  1. Step 1: Determine the peak coefficient from your own past seasons.
  2. Step 2: Count places and area for the peak and for growth.
  3. Step 3: Decide whether a seasonal warehouse or an operator capacity is needed.
  4. Step 4: Reconcile the stock movement at one date and find the sign of the gap.
  5. Step 5: Reconcile the till, the ledger and bank receipts with the settlement lag.
  6. Step 6: Count the loss per return and the cost of capital over the time to restock.
  7. Step 7: Check the RFID payback in a pilot and not by a supplier estimate.
  8. Step 8: Update ABC and count the slotting saving before the season.

Formulas

MeasureFormulasNote
Places for the peakPlaces = average stock × peak coefficient ÷ units per place ÷ target utilizationArea = places × place area × (1 + aisles).
Stock gapGap = actual − (beginning + receipts − sales + returns − transfers − write-offs + adjustments)Stocks at one date; the tolerance in percent of beginning plus receipts.

Formulas in notation

Area for the peak
S = \frac{Q \cdot k}{u \cdot \lambda} \cdot s \cdot (1 + a)
Q: average stock, k: peak coefficient, u: units per place, λ: utilization, s: place area, a: aisles.

Worked example

The warehouse and data on illustrative figures

MetricValue
Places for the peak3,529
Area for the peak, m²6,353
Stock gap, pcs−250
Gap against the bank, RUB−60,000
Loss per return, RUB539
RFID payback, months8.8

All numbers are illustrative; tolerances, utilization and terms are your rules.

Figures

Warehouse area for different stocks
Bar chart: For the average stock 3,971, For the peak 6,353, With growth 7,30602,0004,0006,0008,000For the average stockFor the averagestockArea: 3,9713,971For the peakFor the peakArea: 6,3536,353With growthWith growthArea: 7,3067,306m²
Data as a table
MeasureArea
For the average stock3,971
For the peak6,353
With growth7,306

Warehouse area for different stocks. A warehouse for the peak is much bigger than needed in the low season at 53% utilization: paying for empty places all year is not worth it.

Stock movement
Waterfall: Beginning +12k, Receipts +5,500, Sales −6,200, Returns +300, Transfers and write-offs −950, Expected end 10.7k05,00010k15k20kBeginningBeginningBeginning: +12k+12kReceiptsReceiptsReceipts: +5,500+5,500SalesSalesSales: −6,200−6,200ReturnsReturnsReturns: +300+300Transfers and write-offsTransfers andwrite-offsTransfers and write-offs: −950−950Expected endExpected endExpected end: 10.7k10.7kpcs
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
Beginning+12k12k
Receipts+5,50017.5k
Sales−6,20011.3k
Returns+30011.6k
Transfers and write-offs−95010.7k
Expected end—10.7k

Stock movement. The gap against the actual shows where pieces are lost.

Specifics by category

Apparel
Apparel: the seasonal peak and size gaps make peak stocks and returns higher than average.
Footwear
Footwear: size returns cost more, the B-grade share is lower.
Accessories
Accessories: a small size, lower warehouse capacity, RFID tags costlier relative to the price.
Kids
Kids: the school season gives a sharp peak, plan shifts and warehouse with a margin.
Men
Men: steady demand, a lower peak coefficient.
Women
Women: more novelties and returns, a higher share of scrap and B-grade.

Common mistakes

  • Designing a warehouse by the average stock → the peak breaks the work → count by the peak stock.
  • Keeping utilization above 90% → processes interfere → allow 80–85% and a growth margin.
  • Comparing stocks of different dates → the gap is spurious → reconcile at one date.
  • Comparing sales and receipts without the lag → false gaps against the bank → enter previous-period receipts and not yet credited sales.
  • Ignoring scrap and the time to restock → the loss per return is understated → count outcomes and the cost of capital.
  • Believing RFID availability growth without a pilot → payback is overstated → measure in several stores.
  • Not updating ABC before the season → the path lengthens → update the layout before the peak.

Russian specifics

  • The method is managerial and is not regulated; for labeled goods the movement data must agree with the labeling system, the refund terms for a customer are set by the law and platform terms: check against the act in force at the date.

Open interactively →