Promo item selection under a margin-loss budget
Selects which items to put into a promotion so as to free as much cash tied up in stock as possible under a given margin-loss budget. For each item it counts the stock coverage in weeks, the extra pieces from the discount by its elasticity (not above the stock), the capital freed at cost and the margin lost on the volume that would have sold anyway. The priority is the capital freed per rouble of lost margin; items are taken by priority until the budget is exhausted. It complements “Item selection for buying” and “ABC by sales”: those choose the buy and classes, here is a selection for a promotion by stock and elasticity.
At a glance
- What question does it answer?
- Which items to put into a promotion to free more cash from stock at a given margin budget.
- What data is needed?
- Stock, rate, price, cost, elasticity by item.
- How to read the result?
- Look at the priority and coverage: bestsellers with a low coverage do not go into a promotion. Example on the default values: Items selected: 4; Margin loss: RUB 242,000; Left of the margin-loss budget: RUB 8,000; Capital freed: RUB 314,674. The figures are illustrative: enter your own to see your result.
Why and how to reason
A promotion should free cash from stock, not give margin to bestsellers. The priority is the capital freed per rouble of lost margin. In the example with a budget of RUB 250,000, C, A, E and B are selected: margin loss RUB 242,000, RUB 314,674 freed; D with a stock for 4 weeks will sell out anyway.
When to use it
Apply when planning a promotion on items with excess stock and a given discount budget.
How to read the result
Look at coverage and priority; recalculate after excluding items that cannot go into a promotion.
Common mistakes
Bestsellers in a promotion, looking at the discount depth instead of stock coverage.
What data is needed?
- Stock, rate, price, cost, elasticity by item.
- Discount, duration and the margin-loss budget.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Discount | % | 20 | One depth for all selected items. The example value is illustrative. |
| Duration | weeks | 4 | How many weeks the promotion runs. The example value is illustrative. |
| Margin-loss budget | ₽ | 250,000 | How much margin you are ready to give away by the discount on the volume that would have sold anyway. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Sales without the promotion over the term | min(stock; rate × weeks) |
| Sales in the promotion | min(stock; rate × weeks × (1 − discount)^ε) |
| Capital freed | (sales in the promotion − without) × cost |
| Margin loss | sales without the promotion × price × discount |
| Priority and selection | capital freed ÷ margin loss; taken in descending order while the budget lasts |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Items selected
- 4
- Margin loss
- 242,000 ₽The base: the volume that would sell without the promotion anyway.
- Left of the margin-loss budget
- 8,000 ₽
- Capital freed
- 314,674 ₽Extra pieces × cost.
- Stock reduction
- 214Extra pieces above the sales without the promotion.
- Capital per rouble of lost margin
- 1.3
Data as a table
| Measure | Priority |
|---|---|
| C | 1.49 |
| A | 1.43 |
| E | 1.22 |
| B | 1.06 |
| D | 0 |
Items by priority
| Item | Coverage, weeks | Priority | Margin loss | Freed | In promotion |
|---|---|---|---|---|---|
| C | 60 | 1.49 | 60,000 ₽ | 89,167 ₽ | yes |
| A | 30 | 1.43 | 60,000 ₽ | 85,781 ₽ | yes |
| E | 53 | 1.22 | 62,000 ₽ | 75,937 ₽ | yes |
| B | 12 | 1.06 | 60,000 ₽ | 63,787 ₽ | yes |
| D | 4 | 0 | 48,000 ₽ | 0 ₽ | no |
Selected 4 of 5 items: margin loss 242,000 ₽ of the budget 250,000 ₽, 314,674 ₽ of capital freed, the stock falls by 214 pcs.
Item “D”: stock for 4 weeks with a 4-week promotion: it will sell out without the promotion, the priority is zero.
What to do with the result: marketplace requirements for a minimum discount and the labelling of stock may rule out some items; recalculate after excluding them. Put items with a high coverage into the promotion, not bestsellers.
A typical mistake: putting bestsellers into a promotion and looking at the depth of the discount instead of the stock coverage.
Nuances and limits
- Bestsellers in a promotion.
- Looking at the discount depth, not the coverage.