Liquidation channels for leftover stock
Compares how much money per unit of leftover stock each channel gives: own sale, outlet, a lot to a wholesale stock buyer, marketplace. From the channel price (a share of the full price), the share of stock that really sells, costs (commissions, returns), logistics and the term it counts the net return and its present value at the capital rate. Ranks the channels and counts the total return on the stock at your split between channels. It does not replace the price-cut scenarios in one channel (“Markdown scenarios”): here different channels are compared.
At a glance
- What question does it answer?
- Which channel returns more money per unit of stock taking time into account.
- What data is needed?
- Channel price, share sold, costs, term, logistics.
- How to read the result?
- Rank by present value and split by channel capacity. Example on the default values: Best channel by present value: RUB 1,644; Net return per unit in the best channel: RUB 1,700; Total return on the stock at your split: RUB 1.37 million; The same without discount: RUB 1.42 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A lot, an outlet and a marketplace give different money per unit and at different times. The net return is counted from the channel price, share sold, costs and logistics, then discounted to today. In the example own sale gives RUB 1,700 (present value RUB 1,644), the outlet RUB 1,380 (RUB 1,313), the lot RUB 1,250 (RUB 1,240), the marketplace RUB 945 (RUB 922).
When to use it
Apply when stock must be cleared and there are several channels; check the labeling requirements for the stock in your category.
How to read the result
Rank by present value and split by channel capacity, not all the stock into the best one.
Common mistakes
The lot price is taken as a retail price, the time to receive money and marketplace returns are ignored.
What data is needed?
- Channel price, share sold, costs, term, logistics.
- The capital rate and shares of stock by channel.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Full unit price | ₽ | 5,000 | The price excl. VAT from which the channel prices are counted. The example value is illustrative. |
| Capital rate | % per year | 44 | The yearly price of money for you: a loan, not a deposit. The longer the channel, the larger the discount. The example value is illustrative. |
| Stock | pcs | 1,000 | How many units must be liquidated. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Net return per unit | full price × channel price × share sold × (1 − costs) − logistics |
| Present value | net return ÷ (1 + rate × weeks ÷ 52) |
| Total return | the sum over channels: stock × channel share × present value |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Best channel by present value
- 1,644 ₽Own sale
- Net return per unit in the best channel
- 1,700 ₽
- Total return on the stock at your split
- 1.37 m ₽The sum over channels: stock × share × present value.
- The same without discount
- 1.42 m ₽
- If all the stock goes to the best channel
- 1.64 m ₽An upper estimate: the channel capacity is not counted.
- Total return per unit of stock
- 1,372 ₽
- Return as a % of the full price
- 27.4 %
- Present value
- Net return
Data as a table
| Measure | Present value | Net return |
|---|---|---|
| Own sale | 1,644 | 1,700 |
| Outlet | 1,313 | 1,380 |
| Lot to a wholesale stock buyer | 1,240 | 1,250 |
| Marketplace | 922 | 945 |
Channels by present value
| Channel | Channel price | Net return | Present value | Term, weeks | Share of stock |
|---|---|---|---|---|---|
| Own sale | 2,000 ₽ | 1,700 ₽ | 1,644 ₽ | 4 | 40 % |
| Outlet | 2,500 ₽ | 1,380 ₽ | 1,313 ₽ | 6 | 25 % |
| Lot to a wholesale stock buyer | 1,250 ₽ | 1,250 ₽ | 1,240 ₽ | 1 | 20 % |
| Marketplace | 2,250 ₽ | 945 ₽ | 922 ₽ | 3 | 15 % |
The part of the stock in channels with a share sold below 100% stays unsold and is not in the total: its fate is the next channel or a write-off.
What to do with the result: split the stock by the capacity of the channels, not all into the best one: the capacity of the best channel is limited. For some categories goods without labelling codes cannot be sold: check the requirements for your category before choosing a channel.
A typical mistake: counting the lot price as a retail price, ignoring the time to receive the money and not subtracting marketplace returns.
Nuances and limits
- The lot price as a retail price.
- The time to receive money ignored.