Syntha Lab RU

Markdown grid: when and how deep

Searches the week from which to cut the price and the depth of the cut and finds the combination with the highest profit by the end of the horizon. The base sales rate decays week by week, after the cut it grows by the elasticity, sales are limited by stock, and the stock left at the end goes as a lot. Compares the best combination with “no cut” and shows which combination is needed for the stock not to exceed the target. It complements the “Discount ladder” and “Markdown scenarios”: those have three set scenarios, here the timing and depth are searched.

Markdown and exit price For whom: Category managers and buyers before a price cut.

Calculate on your data →

At a glance

What question does it answer?
From which week and by how much to cut the price to earn the most on the stock.
What data is needed?
Stock, prices, lot, rate and decay.
How to read the result?
Compare the best combination with “no cut” and check the depth: beyond 50% the elasticity is unchecked. Example on the default values: Profit with no cut: RUB 1.12 million; Best profit on the grid: RUB 1.78 million; Gain against “no cut”: +RUB 666,094; Full-price weeks before the cut: 1. The figures are illustrative: enter your own to see your result.

Why and how to reason

A price can be cut in different weeks and by different depths; a search finds the combination with the highest profit. In the example with no cut the profit is RUB 1,116,585 and the stock 448 pcs; the best combination: after week 1 by 25%, profit RUB 1,782,680 (+RUB 666,094), stock 14 pcs.

When to use it

Apply when stock must be sold within a horizon and there is an elasticity estimate at the needed depths; fit dates to the marketplace promotion calendar.

How to read the result

Compare the best combination with “no cut” and with the stock target; a depth of 50% and more goes beyond the observed.

Common mistakes

An elasticity from the full price is applied to deep discounts, the decay is taken as zero.

What data is needed?

  • Stock, prices, lot, rate and decay.
  • Elasticity, horizon, the ban on a price below cost.

Inputs

FieldUnitValue in the exampleMeaning
Stockpcs1,000How many units must be sold by the end of the horizon. The example value is illustrative.
Full price₽5,000Excl. VAT, per unit. The example value is illustrative.
Unit cost₽2,000At purchase prices: needed for the profit. The example value is illustrative.
Lot price for the stock at the end₽800Per unit at which the stock goes at the end of the horizon. The example value is illustrative.
Sales rate in the first weekpcs/week60At the full price, normalized: without stock-outs and promotions. The example value is illustrative.
Weekly decay×0.95How many times the rate changes in a week: 0.95 is minus 5% a week. A decay equal to one means demand does not age: that hardly ever happens. The example value is illustrative.
Elasticity at deep discounts (absolute value)−2.2Enter the absolute value without a sign. An elasticity estimated at the full price is usually overstated at deep discounts and is not the elasticity on a discount: do not take it without checking. The example value is illustrative.
Horizonweeks12How many weeks are left to the end of the season or the lot decision. The example value is illustrative.
Price not below costno, search all depthsMarketplaces and contracts may forbid a price below the purchase price without consent.
Target stock at the end (optional)pcs—Needed to show the most profitable combination that brings the stock down to the target. Empty: not set.

How it is calculated

StepFormula
Rate of week kr0 × g^k = 60 × 0.95^k
After a cut by drate × (1 − d)^ε, price × (1 − d)
Sales of the weeknot above the remaining stock
Profitrevenue + lot × remaining stock − cost × batch, horizon 12 weeks
Search12 weeks × 11 depths (10–60% in steps of 5)

Worked numbers

Default values from the app; in the interactive version you enter your own.

Profit with no cut
1.12 m ₽
Best profit on the grid
1.78 m ₽
Gain against “no cut”
+666,094 ₽
Full-price weeks before the cut
1
Best depth of the cut
25 %
Closing stock, best combination
14
Closing stock with no cut
448
Profit at the stock target
target not set
Profit when cutting after 1 weeks to different depths, thousand RUB
Line chart: Profit: 1,345 → 180; No cut: 1,117 → 1,11705001,0001,5002,00010 %20 %30 %40 %50 %60 %Profit, 10 %: 1,345Profit, 15 %: 1,477Profit, 20 %: 1,622Profit, 25 %: 1,783Profit, 30 %: 1,590Profit, 35 %: 1,355Profit, 40 %: 1,120Profit, 45 %: 885Profit, 50 %: 650Profit, 55 %: 415Profit, 60 %: 180No cut, 10 %: 1,117No cut, 15 %: 1,117No cut, 20 %: 1,117No cut, 25 %: 1,117No cut, 30 %: 1,117No cut, 35 %: 1,117No cut, 40 %: 1,117No cut, 45 %: 1,117No cut, 50 %: 1,117No cut, 55 %: 1,117No cut, 60 %: 1,117
  • Profit
  • No cut
Data as a table
MeasureProfitNo cut
10 %1,3451,117
15 %1,4771,117
20 %1,6221,117
25 %1,7831,117
30 %1,5901,117
35 %1,3551,117
40 %1,1201,117
45 %8851,117
50 %6501,117
55 %4151,117
60 %1801,117

The best depth for each week of the cut

Cut after, weeksDepthProfitClosing stock, pcs
025 %1.75 m ₽0
125 %1.78 m ₽14
225 %1.71 m ₽65
330 %1.76 m ₽0
430 %1.68 m ₽56
535 %1.71 m ₽6
640 %1.64 m ₽0
740 %1.6 m ₽55
845 %1.57 m ₽46
950 %1.51 m ₽61
1060 %1.44 m ₽0
1160 %1.28 m ₽226

The best combination: cut the price after 1 full-price weeks by 25 %. Profit 1.78 m ₽ against 1.12 m ₽ with no cut, a gain of 666,094 ₽; the closing stock is 14 pcs against 448 pcs.

What to do with the result: check the date against the marketplace promotion calendar and the control week; a cut deeper than the elasticity from history must be confirmed by the sales of the first week.

A typical mistake: taking the elasticity from the full price for deep discounts and counting the decay as zero.

Nuances and limits

  • Elasticity from the full price applied to deep discounts.
  • The decay set to zero.

Terms used

Calculate on your data →