Clearance scenarios compared by goal
Compares several price-reduction scenarios (at most two steps in each) by three goals: the result including leftovers, sales volume and capital tied up in stock. The demand model is the same as in “Weekly markdown ladder”, so with the same data the results match. This is a Syntha Lab model, not a forecast.
At a glance
- What question does it answer?
- Which of several price-reduction scenarios is best by result including leftovers, by volume and by capital frozen in stock.
- What data is needed?
- Stock, shelf price including VAT and the VAT rate, cost, weekly sales at full price, the horizon and the price of leftovers after it.
- How to read the result?
- On the example stock is 640 pieces, shelf price 5,000 incl. 22% VAT, cost 2,000, sales 55 a week, elasticity 2, leftover price 800 and 8 weeks (the same figures as in “Weekly markdown ladder”). With no reduction 440 pieces sell, 200 are left and the result including leftovers is 654,426. One reduction of 30% at once sells everything (640 pieces); the result is lower at 556,066, but the average stock is the smallest at 504,000. A reduction of 30% from week 4 leaves 35 pieces and gives the best result, 681,475, which is 27,049 above no reduction. The goals diverge (by result the cut from week 4 wins, by volume and capital the cut at once), so the choice is yours. Example on the default values: Best by result including leftovers: RUB 681,475 · Later: −30% from week 4; Best by volume: 640 pcs · One reduction: −30% at once; Best by tied-up capital: RUB 504,000 · One reduction: −30% at once; Best result against “no reduction”: RUB 27,049. The figures are illustrative: enter your own to see your result.
Why and how to reason
A markdown on leftover stock can be done in different ways: deep at once, in two steps or later. The best depends on the goal: earn more counting the units left, sell as many as possible or release frozen money faster. The calculation runs all scenarios through one demand model: weekly sales = base per week × (1 + elasticity × discount), capped at stock. Elasticity 2 means a 30% discount lifts demand by 60%. Profit is counted at the price excluding VAT: shelf × (1 − discount) ÷ 1.22 − cost, and unsold units after the horizon are valued at the leftover price. Mini example with no markdown: a price of 5,000 including VAT gives 4,098 excluding VAT and 2,098 margin; in 8 weeks at 55 units we sell 440, profit 923,279, and the remaining 200 units go at 800 with a loss of 268,852: total 654,426. The best scenario in the example gives 681,475.
When to use it
It comes in handy for season leftovers when deciding when and how deeply to cut the price and you want three views at once: profit, volume and money in stock. Do not use it as a forecast: it is a Syntha Lab model with your assumptions. It does not fit goods whose demand does not respond to price, or where advertising and competitors dominate. Assumptions: elasticity is constant, sales are linear in the discount, and the leftover price after the horizon is known. Enter your own cost of money if you want to see the price of freezing capital.
How to read the result
The three result lines answer three different questions and the winner on each can differ. Best by result with leftover is for those who want to earn. Best by volume is for when the warehouse must be freed. Best by frozen capital matters when cash is short. Compare not only the best but the gap to “no markdown”: 27 thousand on 650 thousand is 4% and it melts if real elasticity is lower. So test sensitivity: set elasticity to 1.5 and see whether the winner holds. Confirm the result with a test in some stores.
Common mistakes
The main trap is trusting an elasticity pulled out of thin air. It determines everything. The second is entering a leftover price ignoring that a bulk buyout may be cheaper. The third is comparing scenarios with different horizons: compare on the same number of weeks.
What data is needed?
- Stock, shelf price including VAT and the VAT rate, cost, weekly sales at full price, the horizon and the price of leftovers after it.
- Price elasticity as an absolute value: from “Elasticity from a past promotion”.
- Two to four scenarios: the discount and the starting week, at most two steps.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Stock to sell | pcs | 640 | The same starting figures as in “Weekly markdown ladder” (an example): then the two calculations give the same result. |
| Shelf price now (incl. VAT) | ₽ | 5,000 | Including VAT if you pay it (“Weekly markdown ladder” takes the price the same way). If you do not pay VAT, set the rate to 0. |
| VAT rate in the price | % | 22 | The general VAT rate is 22% from 01.01.2026; 10% for children’s goods on the list. Confirm the rate and your regime with an accountant. |
| Unit cost excl. VAT | ₽ | 2,000 | Unit cost excl. VAT, delivered to the warehouse. |
| Horizon | weeks | 8 | A whole number of weeks; a fraction is rounded. |
| Price of leftovers after the horizon (per piece, incl. VAT) | ₽ | 800 | What you get for the leftover after the horizon (clearance, resale), on the same basis as the shelf price. 0 or empty: the leftover is written off, so its cost is lost. An example, replace with yours. |
| Weekly sales at full price | pcs a week | 55 | What you sell now with no reduction. |
| Price elasticity (absolute) | × | 2 | The absolute value of the simple elasticity from “Elasticity from a past promotion” (if it shows −2.75, enter 2.75): sales = base × (1 + elasticity × discount). Then on the data of that promotion the model reproduces the observed growth. There is no single standard in Russia; 2 here is an example, replace with yours. 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. |
| Your cost of money | % a year | — | Optional. Take the rate of your own loan or overdraft from the bank contract. Empty: no comparison. |
How it is calculated
| Step | Formula |
|---|---|
| Sales of a week | base per week × (1 + elasticity × discount), capped by the stock |
| Price excl. VAT | shelf price × (1 − discount) ÷ (1 + VAT) |
| Gross profit | Σ sold × (price excl. VAT − cost) |
| Result with leftovers | gross profit + leftover × (leftover price excl. VAT − cost) |
| Tied-up capital | average stock over the horizon × cost |
| Cost of money | average stock × rate × weeks ÷ 52 |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Best by result including leftovers
- 681,475 ₽ · Later: −30% from week 4Gross profit of what was sold plus leftover × (leftover price excl. VAT − cost) minus the cost of money in stock. If the leftover price is not set, the leftover is written off.
- Best by volume
- 640 pcs · One reduction: −30% at once
- Best by tied-up capital
- 504,000 ₽ · One reduction: −30% at onceThe average stock at cost over the horizon: lower is better.
- Best result against “no reduction”
- 27,049 ₽
Scenarios side by side
| Scenario | Steps | Sold, pcs | Share sold | Revenue excl. VAT | Gross profit | Left, pcs | Result with leftovers | Average stock |
|---|---|---|---|---|---|---|---|---|
| No reduction | 0 | 440 | 69 % | 1.8 m ₽ | 923,279 ₽ | 200 | 654,426 ₽ | 785,000 ₽ |
| One reduction: −30% at once | 1 | 640 | 100 % | 1.84 m ₽ | 556,066 ₽ | 0 | 556,066 ₽ | 504,000 ₽ |
| Two steps: −20%, then −40% | 2 | 640 | 100 % | 1.83 m ₽ | 546,230 ₽ | 0 | 546,230 ₽ | 548,000 ₽ |
| Later: −30% from week 4 | 1 | 605 | 95 % | 1.94 m ₽ | 728,525 ₽ | 35 | 681,475 ₽ | 661,250 ₽ |
The goals give different winners: the choice depends on what matters more to you now, profit, clearing the warehouse or cash.
One Syntha Lab model for “Weekly markdown ladder”, this calculation and “Elasticity from a past promotion”: weekly sales = base × (1 + elasticity × discount), capped by the stock; the shelf price includes VAT, money in the result is excl. VAT. It is exact for the discount at which you measured elasticity and approximate for much deeper ones. At most two steps per scenario: simpler for the customer and for bookkeeping.
When to use which: “Weekly markdown ladder” has up to four steps and an exit price for an ending-stock goal; this calculation compares several ready options by three goals. The stages of a sale period (before the sale, in the sale, after it, final clearance) may be named differently in your company: here “after the horizon” is what remains at its end.
Nuances and limits
- Elasticity is your estimate and the result is as imprecise as it is: take it from a past sale, not from memory.
- The result depends strongly on the leftover price: check it against a real leftover deal.
- Frequent reductions teach the customer to wait for discounts: see “Frequent promotions: reference price”.