Syntha Lab RU

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.

Markdown and exit price For whom: Buyers, category managers and brand or store owners in mid-season.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Stock nowpcs640Only what can be sold: for labeled goods reconcile with the codes.
Shelf price now₽5,000Including 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,000Delivered to the warehouse, excl. VAT. Needed to tell a discount that gives away margin from a loss-making one.
Sales pace at full pricepcs a week55Average of the last 2–4 weeks without promotions, adjusted for weeks with missing sizes.
Price elasticity (absolute)×2One 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 stockpcs100How many pieces are acceptable to leave by the date. Empty counts as zero.
Clearance price of leftovers (per piece)₽800What 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%220 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

StepFormula
Step salesmin(stock; pace × (1 + elasticity × discount) × weeks of the step)
Revenue excl. VATprice × (1 − discount) ÷ (1 + VAT) × sold
Result on the lotΣ (price excl. VAT − cost) × sold + leftover × (clearance price excl. VAT − cost)
Exit pricediscount 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 across the discount ladder steps
Line chart: Stock, units: 640 → 2; Stock target: 100 → 1000200400600800StartStep 1Step 2Step 3Step 4Stock, units, Start: 640Stock, units, Step 1: 530Stock, units, Step 2: 376Stock, units, Step 3: 200Stock, units, Step 4: 2Stock target, Start: 100Stock target, Step 1: 100Stock target, Step 2: 100Stock target, Step 3: 100Stock target, Step 4: 100unitsStep
  • Stock, units
  • Stock target
Data as a table
StepStock, unitsStock target
Start640100
Step 1530100
Step 2376100
Step 3200100
Step 42100

Weekly steps

StepDiscountShelf priceSold, pcsStock after, pcsRevenue excl. VATGross profit
Step 10 %5,000 ₽110530450,820 ₽230,820 ₽
Step 220 %4,000 ₽154376504,918 ₽196,918 ₽
Step 330 %3,500 ₽176200504,918 ₽152,918 ₽
Step 440 %3,000 ₽1982486,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.

Terms used

Calculate on your data →