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.
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 source | Fields |
|---|---|
| The ledger and the warehouse system | stocks at dates, receipts, transfers, write-offs, adjustments, storage places |
| Till, acquiring, bank | fiscal receipts, returns, cash, the contractual fee, credits by date |
| Warehouse and returns | return outcome shares, time to restock, ABC by order lines, picking timing |
How to build it step by step
- Step 1: Determine the peak coefficient from your own past seasons.
- Step 2: Count places and area for the peak and for growth.
- Step 3: Decide whether a seasonal warehouse or an operator capacity is needed.
- Step 4: Reconcile the stock movement at one date and find the sign of the gap.
- Step 5: Reconcile the till, the ledger and bank receipts with the settlement lag.
- Step 6: Count the loss per return and the cost of capital over the time to restock.
- Step 7: Check the RFID payback in a pilot and not by a supplier estimate.
- Step 8: Update ABC and count the slotting saving before the season.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Places for the peak | Places = average stock × peak coefficient ÷ units per place ÷ target utilization | Area = places × place area × (1 + aisles). |
| Stock gap | Gap = 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
| Metric | Value |
|---|---|
| Places for the peak | 3,529 |
| Area for the peak, m² | 6,353 |
| Stock gap, pcs | −250 |
| Gap against the bank, RUB | −60,000 |
| Loss per return, RUB | 539 |
| RFID payback, months | 8.8 |
All numbers are illustrative; tolerances, utilization and terms are your rules.
Figures
Data as a table
| Measure | Area |
|---|---|
| For the average stock | 3,971 |
| For the peak | 6,353 |
| With growth | 7,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.
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Beginning | +12k | 12k |
| Receipts | +5,500 | 17.5k |
| Sales | −6,200 | 11.3k |
| Returns | +300 | 11.6k |
| Transfers and write-offs | −950 | 10.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.