Syntha Lab RU

Post-season review by category

After the season shows what sold at full price, how much went on markdown, the margin that was left and how much money sits in leftovers. A basis for the next buy.

Season, price and discounts For whom: Buyers and category managers after the season.

Calculate on your data →

At a glance

What question does it answer?
What sold at full price, how much went on markdown, the margin and how much money sits in leftovers.
What data is needed?
By category: received, sold at full price, sold on markdown, markdown depth, price and cost.
How to read the result?
Red categories missed the sell-through goal. Compare sell-through, full-price share and margin together: a category may sell through but at the price of discounts. Leftover in money feeds the next buying budget. Example on the default values: 77.8% sold against an 80% goal, a full-price share of 63.5% against 65% and a season gross margin of 52.9%. The loss on discounts is RUB 5,755,000, leftovers at cost RUB 5,085,000 and gross profit RUB 20,050,000. Outerwear, knitwear and trousers fell short of the goals. If a category missed its goal, take a smaller share of budget or a lower depth next time until the cause (price, fit, delivery timing or season) is clear. Next: “Buying budget by category and weeks of supply” and “Clearance scenarios compared by goal”.

Why and how to reason

The season review turns results into a lesson for the next buy. For each category we look at what happened to what was received: how much sold at full price, how much on markdown, how much remained. Sold = (full + markdown) / received. Share at full price = full / sold: it shows the quality of sales, not only quantity.

Markdown loss = units sold on markdown x price x depth: how much money was given to buyers against full price. Leftover is counted at cost, because that is the cash frozen in unsold goods.

Example. Received 8,800 units, sold 4,350 at full price and 2,500 on markdown: 77.8% sold against an 80% target. Full-price share 63.5% against 65%. Markdown loss RUB 5.76 m. Leftover at cost RUB 5.1 m. Gross profit RUB 20.05 m, margin 52.9%.

When to use it

Use it right after the season ends, while data is fresh, and before planning the next one. Suitable for comparing categories. Assumption: all data is on one basis (ex VAT). It does not explain causes (weather, price, assortment): those are sought separately, but the review shows where to dig. Compare seasons of comparable length. Best done together with the buying and sales teams.

How to read the result

Compare sell-through and the full-price share with targets. A category with high sell-through but a low full-price share sells “on price”; that is a signal to buy less. A category with low sell-through has leftover: it must be redistributed or cleared. Markdown loss shows the price of a forecasting error. Decision: cut buying where leftover and markdowns are large; increase where everything sold at full price and ran short. Write three conclusions per category and carry them into next season’s buying plan: without this the review stays a report. Separately note categories where targets were met so as not to break what works.

Common mistakes

Typical trap: computing sell-through without allowing for returns; comparing categories with different season lengths; ignoring goods transferred to other stores. Also: judging success by revenue when it all came from markdowns. Also: drawing conclusions from a single season without allowing for weather and the calendar.

What data is needed?

  • By category: received, sold at full price, sold on markdown, markdown depth, price and cost.
  • Sell-through and full-price share goals.
  • Where to take it: received and sold by category from the goods and sales movement report in 1C or the ERP for the season; split sales into “at full price” (before the sale), “discounted” (in the sale) and what is left after it: your company may name these stages differently. Discount depth is the average on goods sold at a discount; price and cost from the price list and costing. Units net of returns.

Inputs

FieldUnitValue in the exampleMeaning
Season sell-through goal%80The share of received stock you planned to sell in the season; set it from your own past seasons.
Full-price share goal%65The share of sales that should go without discount.

How it is calculated

StepFormula
Sell-through(Full price + markdown) ÷ received
RevenueSold at full price × price + sold on markdown × price × (1 − depth)
Markdown lossUnits on markdown × price × depth

Worked numbers

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

Sell-through
77.8 %
Full-price share
63.5 %
Season gross margin
52.9 %
Lost to markdowns
5.76 m ₽Revenue not received because of price cuts.
Leftover at cost
5.09 m ₽
Gross profit
20.1 m ₽

By category

CategorySell-throughFull-price shareMarginLeftover, unitsLeftover at cost
Outerwear78 %64 %50 %4001.72 m ₽
Dresses81 %67 %55 %4501.13 m ₽
Knitwear80 %63 %56 %6001.14 m ₽
Trousers69 %59 %48 %5001.1 m ₽

Below goal: Outerwear, Knitwear, Trousers. In the next buy give these categories a smaller share of budget or a more cautious markdown until the cause is clear: price, fit, delivery timing or season.

Nuances and limits

  • Use units without returns; markdown depth is the average on units sold on markdown.
  • The sell-through and full-price goals are yours, not norms: set them from your own seasons’ history.
  • Do not mix seasons: compare the review of last season by category with the same season a year earlier.

Terms used

Calculate on your data →