Syntha Lab RU

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.

Promotions: planning and evaluation For whom: Commercial teams and category managers planning promotions.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Discount%20One depth for all selected items. The example value is illustrative.
Durationweeks4How many weeks the promotion runs. The example value is illustrative.
Margin-loss budget₽250,000How 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

StepFormula
Sales without the promotion over the termmin(stock; rate × weeks)
Sales in the promotionmin(stock; rate × weeks × (1 − discount)^ε)
Capital freed(sales in the promotion − without) × cost
Margin losssales without the promotion × price × discount
Priority and selectioncapital 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
Item priority: capital freed per rouble of lost margin
Bar chart: C 1.49, A 1.43, E 1.22, B 1.06, D 000.511.5CCPriority: 1.491.49AAPriority: 1.431.43EEPriority: 1.221.22BBPriority: 1.061.06DDPriority: 00
Data as a table
MeasurePriority
C1.49
A1.43
E1.22
B1.06
D0

Items by priority

ItemCoverage, weeksPriorityMargin lossFreedIn promotion
C601.4960,000 ₽89,167 ₽yes
A301.4360,000 ₽85,781 ₽yes
E531.2262,000 ₽75,937 ₽yes
B121.0660,000 ₽63,787 ₽yes
D4048,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.

Terms used

Calculate on your data →