Sell-through by delivery: speed and time to sell out
Compares the deliveries (drops) of a season: what share of each delivery is sold and what share at full price, at what speed it sells and in how many weeks it will finish at the current pace. Shows which delivery has become heavy.
At a glance
- What question does it answer?
- Which of the season’s deliveries sells slowly and when it will finish.
- What data is needed?
- For each delivery: delivered, sold at full price and at a discount, weeks on sale; optionally your sell-through goal.
- How to read the result?
- On the example of four deliveries (10,000 units) 5,720 were sold, a sell-through of 57.2%, at full price 45.2%; 21.0% of what was sold went at a discount. Delivery 2 goes fastest (8.6% a week), delivery 4 slowest (6.0%). Delivery 3 at the current pace will finish in 9.3 weeks, delivery 4 in 14.7. Example on the default values: Delivered: 10,000 pcs; Sold: 5,720 pcs; Sell-through, total: 57.2%; Full-price sell-through: 45.2%. The figures are illustrative: enter your own to see your result.
Why and how to reason
Season deliveries (drops) age differently: goods from the first delivery have lain on the shelf for weeks while the last has just arrived. To compare them fairly you need not only sell-through (share sold) but also speed: sell-through ÷ weeks on sale. Sell-through = (sold at full price + at a discount) ÷ delivered. In the example delivery 1: 4,000 units, 3,200 sold (80%) in 10 weeks, speed 8% a week. Delivery 4: 1,000 units, 120 sold (12%) in 2 weeks, speed 6% a week, the slowest. In total 10,000 delivered, 5,720 sold (57.2%), of which 4,520 at full price (45.2%) and 21% of sold units at a discount. Weeks to finish = remainder ÷ (sold ÷ weeks on sale): delivery 3 has 1,400 left and at 150 a week needs nine more weeks. So a “heavy” delivery is visible before it becomes a leftover.
When to use it
It fits in the weekly season review to decide in time which delivery to push with a promotion and which to leave alone. It suits a brand with several deliveries per season and a retailer. It does not suit a single delivery per season or basic assortment without seasonality. Assumptions: weeks on sale count from the date of display, not warehouse arrival; speed is constant (in fact it falls towards the end), so the time to finish is an estimate.
How to read the result
Compare not sell-through by delivery (a new one is always lower) but speed per week. A delivery whose speed is clearly below the others is the main candidate for action: moving between stores, a price promotion, transfer to another channel. Look at the share sold at full price: if the first delivery is 80% sold but 30% of that at a discount, it earned less than it seems. Compare sell-through with your target: the further from the target, the earlier the reaction is needed. The decision: what to do with the delivery remainder before the next one. Remember also that a delivery’s speed falls over time: treat the forecast of time to finish as a lower-bound estimate.
Common mistakes
Comparing sell-through of deliveries on sale a different number of weeks without converting to speed. Counting weeks from warehouse arrival: the goods were not yet on the shelf. Mixing store and online sales when stocks differ: speed by channel will be distorted.
What data is needed?
- For each delivery: delivered, sold at full price and at a discount, weeks on sale; optionally your sell-through goal.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Your planned sell-through of a delivery | % | — | Optional. The share sold that a delivery should reach by the check date. There is no single standard in Russia: enter your own threshold from your own data. |
How it is calculated
| Step | Formula |
|---|---|
| Sell-through | (sold at full price + at a discount) ÷ delivered |
| Speed | sell-through ÷ weeks on sale |
| Weeks to sell out | remaining ÷ (sold ÷ weeks on sale) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Delivered
- 10,000 pcs
- Sold
- 5,720 pcs
- Sell-through, total
- 57.2 %
- Full-price sell-through
- 45.2 %
- Share of sales at a discount
- 21 %
- Remaining
- 4,280 pcs
- Fastest delivery, % a week
- 8.6 % · Delivery 2
- Slowest delivery, % a week
- 6 % · Delivery 4
- Deliveries below your goal
- enter your own goal
By delivery
| Delivery | Sell-through | At full price | % a week | Remaining | Weeks to sell out |
|---|---|---|---|---|---|
| Delivery 1 (season start) | 80 % | 57.5 % | 8 % | 800 | 2.5 |
| Delivery 2 | 60 % | 50 % | 8.6 % | 1,200 | 4.7 |
| Delivery 3 | 30 % | 30 % | 7.5 % | 1,400 | 9.3 |
| Delivery 4 | 12 % | 12 % | 6 % | 880 | 14.7 |
Compare deliveries with a different number of weeks on sale by speed (percent a week), not by the share sold: a fresh delivery is always below an old one.
The time to sell out is counted at the current speed and ignores discounts and the change of season.
Nuances and limits
- Comparing a fresh delivery with an old one by the share sold: compare the speed.
- There is no single sell-through standard in Russia: you set the goal.