Syntha Lab RU

Season sell-through pace and leftover risk

From sales so far shows the sold share, stock in weeks, the forecast leftover at season end and the pace needed to reach the target.

Season, price and discounts For whom: Buyers and chain managers mid-season.

Calculate on your data →

At a glance

What question does it answer?
Whether you will reach the sell-through goal, what will be left and what pace is needed.
What data is needed?
How much was received and sold, how many weeks have passed and the season length.
How to read the result?
Compare weeks of supply with weeks left in the season: if stock is longer, the remainder will not sell without action. “Pace needed” shows how much faster you must sell to reach the goal. Example on the default values: 5,000 units received, 2,600 sold in 8 weeks: 52% sold, stock of 7.4 weeks. Sales are 325 units a week against the 137.5 needed, so the sell-through forecast at season end is 100% against an 85% goal, with no leftovers; if the pace falls, recalculate the forecast at the new pace.

Why and how to reason

Sell-through answers “will we sell the season in time”. First we count the share already sold: sold / received. Then the pace: how many units go per week. The pace shows how many weeks the remainder lasts. The forecast to season end continues the line: sold + pace x weeks to the end.

The required pace solves the reverse task: to reach the target, over the remaining weeks you must sell on average (target x received - sold) / weeks to the end.

Example. Received 5,000, sold 2,600 in 8 weeks: 52% sold, pace 325 a week. The remaining 2,400 / 325, about 7.4 weeks. The season is 20 weeks, 12 left: forecast 2,600 + 325 x 12 = 6,500, more than received, so it sells through completely. For an 85% target (4,250 - 2,600) / 12 = 137.5 a week is enough. The pace margin is large, so no markdowns are needed yet.

When to use it

Use it weekly during the season to decide in time: reorder, hold price or mark down. Suitable for a single style or group. It does not account for the seasonal peak: the pace at the peak is higher than at the start of the season, and a linear forecast may err. Assumption: the pace is constant. For goods with a peak use forecasts based on the season curve. Check the forecast every week, not once a season.

How to read the result

Compare the sell-through forecast with the target. Above the target, you can hold price or reorder; near it, monitor; below it, decide on a markdown or redistribution. Stock in weeks shows how long the remainder lasts: if it exceeds the remaining weeks of the season, part will not sell. The end-of-season leftover at cost is money you will have to recover through clearance. Decision: if the forecast is below target, start with a stepped markdown ladder rather than one deep discount at the end. It is worth comparing the pace with the plan for the same week of last season: if lower, decide earlier, while the markdown can still be moderate.

Common mistakes

Typical trap: computing the pace from a promotion week; not accounting for part of the run still in transit; setting an overly optimistic target; mixing seasonal and basic goods. Also: waiting for “the last week” to decide. Also: looking at revenue rather than units when prices changed in the season.

What data is needed?

  • How much was received and sold, how many weeks have passed and the season length.
  • Price excl. VAT, cost and the sell-through goal.

Inputs

FieldUnitValue in the exampleMeaning
Received for saleunits5,000How many units were received for sale over the season in total (first order plus reorders): this is the sell-through base, and if another calculation uses a different base, label it. Sold cannot exceed it.
Sold so farunits2,600How many units were sold from the start of the season to today, net of returns.
Weeks elapsedweeks8How many weeks have passed since sales began; not more than the season length.
Season lengthweeks20Planned length of the sales period in weeks, up to the start of the sale or the end of the season.
Sell-through goal at season end%85The share of received stock that should be sold. Set the goal from your own history. The value is illustrative: pick a set above the form or enter your own goal from past seasons.
Price excl. VAT₽6,000Average unit price excl. VAT at full price; used to value the leftover in money.
Unit cost₽2,400Unit cost excl. VAT; used for the leftover at cost.

How it is calculated

StepFormula
PaceSold ÷ weeks elapsed
Weeks of supply(Received − sold) ÷ pace
ForecastSold + pace × weeks left
Needed pace(Goal × received − sold) ÷ weeks left

Worked numbers

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

Sold so far
52 %
Weeks of supply
7.4 weeksRemaining ÷ average weekly sales. If higher than the weeks left, the remainder will not sell without action.
Projected sell-through at end
100 %At the current sales pace.
Pace needed per week
138 units (now 325)
Leftover at end, at cost
0 ₽Money left in stock.
Revenue value of the leftover
0 ₽At full price: what is at stake without clearance.
Cumulative season sales
Line chart: Actual: 0 → 2,600; At the current pace: 2,600 → 5,000; Needed for the target: 2,600 → 4,25001,0002,0003,0004,0005,00005101520whole batchActual, 0: 0Actual, 8: 2,600At the current pace, 8: 2,600At the current pace, 20: 5,000Needed for the target, 8: 2,600Needed for the target, 20: 4,250unitsSeason week
  • Actual
  • At the current pace
  • Needed for the target
Data as a table
Season weekActualAt the current paceNeeded for the target
00——
82,6002,6002,600
20—5,0004,250

If the pace slows: leftover forecast

Share of current paceSales per weekSold by the endLeftover, unitsLeftover at cost
100 %325100 %00 ₽
75 %244100 %00 ₽
50 %16391 %4501.08 m ₽
35 %11479 %1,0352.48 m ₽

At the current pace sell-through reaches 100 % and the 85 % goal is reachable without discounts.

Nuances and limits

  • The pace is assumed constant: seasonal demand varies by week, check against last season.
  • Take the discount decision together with the discount payback model.

Terms used

Calculate on your data →