Weekly markdown ladder: discount steps and an ending-stock goal
Compares three scenarios to the end of the season: keep the price, cut in steps, or one deep cut at the end. Shows the ending stock, the result including the clearance of leftovers, the exit price and warns when a discount does not pay back.
At a glance
- What question does it answer?
- How to cut the price week by week so the leftover clears by the date without giving away margin.
- What data is needed?
- Stock now, shelf price and unit cost excl. VAT.
- How to read the result?
- Compare the result on the lot in the three scenarios, not revenue: the ladder should earn more than “no change”. The exit price is a single discount that brings the leftover to the goal; if it is “not reachable”, elasticity is too low for such a goal. If the ladder is worse than no discount, the leftover loses liquidity more slowly than the price falls. Example on the default values: Ending stock: keep the price — 200 pcs; Ending stock: weekly steps — 2 pcs; Result on the lot: keep the price — RUB 654,426; Result on the lot: weekly steps — RUB 668,852.
Why and how to reason
A markdown is needed to clear leftover by the end of the season, but you must choose when and how deep. Three scenarios show the difference: do not change the price, cut in steps, give one deep markdown at the end. Each is calculated week by week: sales = pace x (1 + elasticity x discount) x weeks, but not more than the stock. The deeper the discount, the more sells, but less money per unit.
The outcome is judged by result: sum of (price ex VAT - cost) x sold plus leftover x (liquidation price ex VAT - cost). The leftover also contributes to the result, and it can be negative if the liquidation price is below cost: the goods must be sold in the end. In the example the liquidation price is RUB 800 with VAT (about RUB 656 without VAT) against a cost of RUB 2,000: each of the 200 leftover units gives about -1,344, roughly -269 k in all, and the no-markdown result is RUB 654 k.
Example. Stock 640, price 5,000, pace 55 a week, elasticity 2, 8 weeks. Without markdowns 440 will sell, 200 remain: result RUB 654 k. Steps of 0 / 20 / 30 / 40% for two weeks each sell 638, leaving 2: result RUB 669 k. One deep markdown at the end gives RUB 633 k. A uniform discount of 11.4% (price 4,432) would bring leftover to the target of 100.
When to use it
Reach for it when there is time left before the end of the season and you must decide how to clear leftover. Suitable for groups of goods with a known pace. Assumption: elasticity is constant and demand reacts to a discount uniformly. In practice the reaction changes, so take elasticity from “Elasticity from a promotion”. Not suitable for goods with no time for a ladder, where a single step is needed.
How to read the result
Compare the scenario results. The difference is small (669 against 654 k): in this example the point of steps is that leftover almost disappears while the result is no worse. The leftover target matters: if you want 100 units and the scenario leaves 2, the discounts may be too generous. The exit price shows which uniform price leads to the target. Decision: choose a scenario by result and by leftover, and take the “discount does not pay back” warning seriously. Check whether a step gives a discount with no sales lift: then it is better removed or shifted.
Common mistakes
Typical trap: entering elasticity from another category; assuming the liquidation price above cost without basis; forgetting VAT in the price; building steps with no sales response. Also: ignoring that a deep discount trains customers to wait. Also: not including the possibility of ending markdowns earlier if the leftover went faster.
What data is needed?
- Stock now, shelf price and unit cost excl. VAT.
- Sales pace at full price over 2–4 weeks without promotions.
- Optional: elasticity, ending-stock goal, clearance price, VAT rate.
- Steps: the discount and length of each step in weeks.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Stock now | pcs | 640 | Only what can be sold: for labeled goods reconcile with the codes. |
| Shelf price now | ₽ | 5,000 | Including VAT if you pay it. “Clearance scenarios” takes the shelf price the same way, including VAT: with the same inputs both calculations give the same result. |
| Unit cost excl. VAT | ₽ | 2,000 | Delivered to the warehouse, excl. VAT. Needed to tell a discount that gives away margin from a loss-making one. |
| Sales pace at full price | pcs a week | 55 | Average of the last 2–4 weeks without promotions, adjusted for weeks with missing sizes. |
| Price elasticity (absolute) | × | 2 | One Syntha Lab model for “Weekly markdown ladder”, “Clearance scenarios” and “Elasticity from a past promotion”: sales = pace × (1 + elasticity × discount). Enter the absolute value of the simple elasticity without a sign: if “Elasticity from a past promotion” gave −2.8, enter 2.8. The 2.0 figure is an example, replace it with yours. Empty or 0: a discount adds no sales. Promotion elasticity is not the elasticity after a permanent price rise: a temporary discount overstates it in absolute value, take a more cautious figure. The value is illustrative: pick a set above the form or enter your own from past promotions. |
| Goal: ending stock | pcs | 100 | How many pieces are acceptable to leave by the date. Empty counts as zero. |
| Clearance price of leftovers (per piece) | ₽ | 800 | What you get for leftovers after the season, on the same price basis as the shelf price. Empty: the leftover is written off. |
| VAT rate in the price | % | 22 | 0 if you do not pay VAT; then take cost with input VAT. Base VAT rate 22% from 01.01.2026; 10% for children’s goods on the list. Confirm your regime and rate with an accountant. |
How it is calculated
| Step | Formula |
|---|---|
| Step sales | min(stock; pace × (1 + elasticity × discount) × weeks of the step) |
| Revenue excl. VAT | price × (1 − discount) ÷ (1 + VAT) × sold |
| Result on the lot | Σ (price excl. VAT − cost) × sold + leftover × (clearance price excl. VAT − cost) |
| Exit price | discount d = ((stock − goal) ÷ (pace × weeks) − 1) ÷ elasticity; price × (1 − d) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Ending stock: keep the price
- 200 pcs
- Ending stock: weekly steps
- 2 pcs
- Result on the lot: keep the price
- 654,426 ₽Gross profit of sales plus (clearance price excl. VAT − cost) × leftover. Empty clearance price: the leftover is written off to zero.
- Result on the lot: weekly steps
- 668,852 ₽
- Result on the lot: one cut at the end
- 632,787 ₽
- Best scenario by result
- 668,852 ₽ · Weekly steps
- Exit price (flat discount to the goal)
- 4,432 ₽ · discount 11.4 %One discount over the whole horizon that brings ending stock to the goal. A linear demand model: test it on small steps.
- Weeks to zero at the current pace
- 11.6 · horizon 8
- Stock, units
- Stock target
Data as a table
| Step | Stock, units | Stock target |
|---|---|---|
| Start | 640 | 100 |
| Step 1 | 530 | 100 |
| Step 2 | 376 | 100 |
| Step 3 | 200 | 100 |
| Step 4 | 2 | 100 |
Weekly steps
| Step | Discount | Shelf price | Sold, pcs | Stock after, pcs | Revenue excl. VAT | Gross profit |
|---|---|---|---|---|---|---|
| Step 1 | 0 % | 5,000 ₽ | 110 | 530 | 450,820 ₽ | 230,820 ₽ |
| Step 2 | 20 % | 4,000 ₽ | 154 | 376 | 504,918 ₽ | 196,918 ₽ |
| Step 3 | 30 % | 3,500 ₽ | 176 | 200 | 504,918 ₽ | 152,918 ₽ |
| Step 4 | 40 % | 3,000 ₽ | 198 | 2 | 486,885 ₽ | 90,885 ₽ |
Demand in the model is linear: weekly sales = pace × (1 + elasticity × discount). Sales fall on their own on the last sizes, so cut the price on the size tail rather than on the whole range.
Stages of a sale period (they may be named differently in your company): before the sale (BS, Before Sale) are the steps with a zero discount, in the sale (IS, In Sale) the steps with a discount, after the sale (AS, After Sale) and the final clearance of leftovers (SO, Sell-Out) is the leftover at the clearance price. Ready options can be compared on three goals in “Clearance scenarios”; take the elasticity for both calculations from “Elasticity from a past promotion”.
Taxes and labelling: a percentage discount off the shelf price is the same share of the price excl. VAT, but in margin it weighs more the higher the share of cost: calculate the result on the price excl. VAT. For leftovers of marking groups 1–3, selling without codes has been banned since 01.01.2026; for group 4 the ban applies from 01.08.2026. Check the group and dates in the regulation checklist; reconcile stock with the codes before the discount and check the rules with an accountant or a lawyer.
Nuances and limits
- One elasticity for the whole range gives an error: take it from “Elasticity from a past promotion” for a similar discount (the model is linear, like in “Clearance scenarios”).
- Measure the discount depth by margin, not by the tag: with VAT a discount is deeper in margin.
- Returns and platform fees are not included.
- Check VAT and the labeling of leftovers with an accountant before selling.