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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Received for sale | units | 5,000 | How 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 far | units | 2,600 | How many units were sold from the start of the season to today, net of returns. |
| Weeks elapsed | weeks | 8 | How many weeks have passed since sales began; not more than the season length. |
| Season length | weeks | 20 | Planned 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 | % | 85 | The 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,000 | Average unit price excl. VAT at full price; used to value the leftover in money. |
| Unit cost | ₽ | 2,400 | Unit cost excl. VAT; used for the leftover at cost. |
How it is calculated
| Step | Formula |
|---|---|
| Pace | Sold ÷ weeks elapsed |
| Weeks of supply | (Received − sold) ÷ pace |
| Forecast | Sold + 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.
- Actual
- At the current pace
- Needed for the target
Data as a table
| Season week | Actual | At the current pace | Needed for the target |
|---|---|---|---|
| 0 | 0 | — | — |
| 8 | 2,600 | 2,600 | 2,600 |
| 20 | — | 5,000 | 4,250 |
If the pace slows: leftover forecast
| Share of current pace | Sales per week | Sold by the end | Leftover, units | Leftover at cost |
|---|---|---|---|---|
| 100 % | 325 | 100 % | 0 | 0 ₽ |
| 75 % | 244 | 100 % | 0 | 0 ₽ |
| 50 % | 163 | 91 % | 450 | 1.08 m ₽ |
| 35 % | 114 | 79 % | 1,035 | 2.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.