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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Stock | pcs | 1,000 | How many units must be sold by the end of the horizon. The example value is illustrative. |
| Full price | ₽ | 5,000 | Excl. VAT, per unit. The example value is illustrative. |
| Unit cost | ₽ | 2,000 | At purchase prices: needed for the profit. The example value is illustrative. |
| Lot price for the stock at the end | ₽ | 800 | Per unit at which the stock goes at the end of the horizon. The example value is illustrative. |
| Sales rate in the first week | pcs/week | 60 | At the full price, normalized: without stock-outs and promotions. The example value is illustrative. |
| Weekly decay | × | 0.95 | How 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.2 | Enter 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. | |
| Horizon | weeks | 12 | How many weeks are left to the end of the season or the lot decision. The example value is illustrative. |
| Price not below cost | no, search all depths | Marketplaces 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
| Step | Formula |
|---|---|
| Rate of week k | r0 × g^k = 60 × 0.95^k |
| After a cut by d | rate × (1 − d)^ε, price × (1 − d) |
| Sales of the week | not above the remaining stock |
| Profit | revenue + lot × remaining stock − cost × batch, horizon 12 weeks |
| Search | 12 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
- No cut
Data as a table
| Measure | Profit | No cut |
|---|---|---|
| 10 % | 1,345 | 1,117 |
| 15 % | 1,477 | 1,117 |
| 20 % | 1,622 | 1,117 |
| 25 % | 1,783 | 1,117 |
| 30 % | 1,590 | 1,117 |
| 35 % | 1,355 | 1,117 |
| 40 % | 1,120 | 1,117 |
| 45 % | 885 | 1,117 |
| 50 % | 650 | 1,117 |
| 55 % | 415 | 1,117 |
| 60 % | 180 | 1,117 |
The best depth for each week of the cut
| Cut after, weeks | Depth | Profit | Closing stock, pcs |
|---|---|---|---|
| 0 | 25 % | 1.75 m ₽ | 0 |
| 1 | 25 % | 1.78 m ₽ | 14 |
| 2 | 25 % | 1.71 m ₽ | 65 |
| 3 | 30 % | 1.76 m ₽ | 0 |
| 4 | 30 % | 1.68 m ₽ | 56 |
| 5 | 35 % | 1.71 m ₽ | 6 |
| 6 | 40 % | 1.64 m ₽ | 0 |
| 7 | 40 % | 1.6 m ₽ | 55 |
| 8 | 45 % | 1.57 m ₽ | 46 |
| 9 | 50 % | 1.51 m ₽ | 61 |
| 10 | 60 % | 1.44 m ₽ | 0 |
| 11 | 60 % | 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.