Returns processing: cost and restocking
Counts what one return costs: receiving, inspection and packing plus the part of the price that will not come back because some items go to B-grade at a discount and some to scrap. From this it gets the loss per return and per month, the cost of the capital frozen for the time until the return to sale, and how much shortening this time saves.
At a glance
- What question does it answer?
- What one return costs and what shortening the time to restock gives.
- What data is needed?
- Returns, price, cost.
- How to read the result?
- Loss per return against the unit margin; the scrap share. Example on the default values: Scrap: 10%; Processing of one return: RUB 95; Expected restock value per unit: RUB 2,556; Loss per return: RUB 539. The figures are illustrative: enter your own to see your result.
Why and how to reason
A return costs more than it seems: of the price of RUB 3,000, RUB 2,556 comes back to sale, the loss with processing is RUB 539 per return, 5.39 m RUB a month at 10,000 returns. Capital frozen for 4 days costs another RUB 31,342 a month.
When to use it
When revising the returns process and the policy for online sales.
How to read the result
The loss against the unit margin and the scrap share; the saving per day of reduction.
Common mistakes
Scrap and the time to restock are not counted; the loss is compared with the price, not the margin.
What data is needed?
- Returns, price, cost.
- Processing costs and outcome shares.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Returns per month | pcs | 10,000 | The number of units returned in a month. The example value is illustrative. |
| Selling price excl. VAT | ₽ | 3,000 | The average price of a returned unit excl. VAT. The example value is illustrative. |
| Cost | ₽ | 1,300 | The unit cost: the frozen capital is counted from it. The example value is illustrative. |
| Receiving per return | ₽ | 30 | The receiving costs of one unit: time and warehouse. The example value is illustrative. |
| Inspection per return | ₽ | 40 | Inspecting the condition and completeness, cleaning. The example value is illustrative. |
| Packing per return | ₽ | 25 | New packaging, tags, relabeling. The example value is illustrative. |
| Returned to sale as new | % | 78 | The share of units without a loss of price. The example value is illustrative. |
| Went to B-grade | % | 12 | The share of units sold at a discount. The remainder to 100% counts as scrap. The example value is illustrative. |
| B-grade price as a percent of the price | % | 60 | What share of the price you manage to get for B-grade. The example value is illustrative. |
| Days until the return to sale | days | 4 | The average time from the return to appearing on the shelf or in the listing. The example value is illustrative. |
| Cost of capital rate | % | 22 | The annual rate at which you value the frozen money. The example value is illustrative. |
| Time reduction to evaluate | days | 1 | By how many days you want to speed up the return to sale. Empty = 0. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Processing | 30 ₽ + 40 ₽ + 25 ₽ = 95 ₽ |
| Restock value | 78% × 3,000 ₽ + 12% × 3,000 ₽ × 60% = 2,556 ₽ |
| Loss per return | 3,000 ₽ − 2,556 ₽ + 95 ₽ = 539 ₽ |
| Frozen capital | returns × cost × days ÷ 365 × rate |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Scrap
- 10 %100% − as new − B-grade.
- Processing of one return
- 95 ₽
- Expected restock value per unit
- 2,556 ₽Share of new × price + share of B × price × discount.
- Loss per return
- 539 ₽Price − restock value + processing.
- Losses per month
- 5.39 m ₽
- Loss as a share of the price
- 18 %
- Loss as a share of the unit margin
- 31.7 %How much margin each return eats: price minus cost.
- Cost of frozen capital per month
- 31,342 ₽
- Capital saved per day of reduction
- 7,836 ₽
- Saving at the given time reduction
- 7,836 ₽
Data as a table
| Measure | Per unit |
|---|---|
| B-grade: price loss | 144 |
| Scrap: price loss | 300 |
| Processing | 95 |
Where the return goes
| Where | Share | Revenue per unit | Price loss per unit |
|---|---|---|---|
| As new | 78 % | 3,000 ₽ | 0 ₽ |
| B-grade | 12 % | 1,800 ₽ | 1,200 ₽ |
| Scrap | 10 % | 0 ₽ | 3,000 ₽ |
What to do with the result: compare the monthly losses with the contribution the category gives; shorten the time to restock and the scrap share, not only the receiving cost. For marketplaces the return goes through the platform: it sets the refund time and the processing.
A typical mistake: not accounting for scrap and the time to restock. The loss here is counted from the selling price: it includes the lost sale; the “Returns” and “Return policy” calculations look at returns as a whole.
Nuances and limits
- Ignoring scrap.
- Not counting the time to restock.
- Comparing the loss with the price, not the margin.