Reorder from early sales
Builds a season forecast from the first weeks of sales and the cumulative curve of past seasons, estimates the reorder needed (low, central and high) and calculates the profit of the reorder lot including the rush surcharge and the minimum lot.
At a glance
- What question does it answer?
- How much to reorder after the first weeks of sales and whether it is worth it at the rush surcharge.
- What data is needed?
- Sold in the first weeks and the share of the season these weeks usually give.
- How to read the result?
- Compare the low, central and high estimates of the reorder: if they differ widely, lean towards the low one. The lot pays if at least the shown share sells. A reorder below the minimum lot is not considered. Example on the default values: Season forecast (central) — 1,400 pcs · 1,167–1,680; Reorder needed: low — 367 pcs; Reorder needed: central — 600 pcs; Reorder needed: high — 880 pcs.
Why and how to reason
The first weeks of sales hint at how the whole season will go. If in past seasons these weeks usually account for 30% of the total, and 420 units are sold now, the whole season is about 420 / 0.30 = 1,400. That is the forecast. But the share can fluctuate, so three estimates are computed: low (by the larger share), main and high (by the smaller).
Required reorder = how much remains to sell minus current stock, but not more than the demand that will remain by the time the goods arrive (the share of season after delivery). A reorder costs more: a rush surcharge.
Example. Sold 420, share 30%: season 1,400, remaining 980, stock 380: reorder 600. At a 36% share the season is 1,167, reorder 367; at 25% the season is 1,680, reorder 880. Price 4,100, cost with a 12% surcharge is 2,240: profit 600 x 1,860 = RUB 1.116 m. The run pays back if at least 35.9% sells, with leftover going at 1,200.
When to use it
Use it for seasonal hits when a quick reorder in small runs is possible (local production, nearby imports). Not suitable if the reorder lead time is longer than the remaining season. Assumption: past seasons' accumulation curve will repeat. For a new category without history the season share is unknown: use a wide range. Enter the factory’s minimum run into the calculation. Check the lead time in advance: the reorder must arrive in time for the season.
How to read the result
Look at the three reorder estimates: if they differ greatly (367, 600, 880), uncertainty is high, and it is wiser to order the low or mid part. The pay-back point shows what share of the run must sell so as not to lose money: in the example 35.9%, and under the main estimate the run sells fully, so the margin of safety is large. Decision: order the recommended run if payback is reasonable even under the low estimate; otherwise reduce the run. Before ordering check that the factory has material and capacity: the calculation assumes the run arrives on time. If not, evaluate a reorder from another maker at a higher price and check whether it still pays back at that price.
Common mistakes
The usual mistakes: taking the season share from a single season; not noticing that the season will have moved on by the time the reorder arrives; not including the rush surcharge; entering stock without what is ordered in transit. Also: reordering “by feel” without recalculating. Also: ordering the high estimate when the main or low one is needed.
What data is needed?
- Sold in the first weeks and the share of the season these weeks usually give.
- Stock, price, cost, minimum lot.
- Optional: spread of the share, time to arrival, surcharge, leftover price.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sold in the first weeks | pcs | 420 | How many units were sold in the first weeks of the season. Do not take a promotion week. |
| Share of the season sold in these weeks (from past seasons) | % | 30 | The cumulative sales curve of the same brand and category. Do not take another brand’s curve. |
| Spread of the share: from | % | 25 | From the spread of past seasons. Empty: equals the main share. |
| Spread of the share: to | % | 36 | The upper bound of the spread of the season share that the first weeks give. Together with the lower one it gives the low and high reorder estimates. The default is set for apparel; for footwear, accessories and children’s take your own data. |
| Stock now | pcs | 380 | Including ordered and not yet received. |
| Share of the season left when the reorder arrives | % | 55 | Accounts for production and delivery time. Empty: the reorder arrives at once. No more than what is left now. |
| Price excl. VAT | ₽ | 4,100 | The selling price of a unit excl. VAT: from the price list or the actual average; the revenue of the top-up is counted from it. |
| Unit cost | ₽ | 2,000 | Unit cost excl. VAT at a normal batch. The rush surcharge is set separately. |
| Rush surcharge | % of cost | 12 | The surcharge on the factory price for urgency in percent of cost: from the factory’s offer for a quick order; empty means zero. |
| Price of leftovers after the season (per piece) | ₽ | 1,200 | The price per unit excl. VAT at which the leftover goes after the season; empty means the leftover is written off with no revenue. |
| Minimum reorder lot | pcs | 100 | The minimum batch the factory will take for a reorder. A reorder below it is not considered. |
How it is calculated
| Step | Formula |
|---|---|
| Season forecast | sold ÷ share of the season in those weeks; low uses the high share, high uses the low share |
| Reorder needed | min(demand after arrival; left to sell − stock) |
| Lot profit | sold × (price − cost × (1 + surcharge)) − unsold × (cost × (1 + surcharge) − leftover price) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Season forecast (central)
- 1,400 pcs · 1,167–1,680Sold in the first weeks ÷ the share of the season in those weeks.
- Reorder needed: low
- 367 pcs
- Reorder needed: central
- 600 pcs
- Reorder needed: high
- 880 pcs
- Suggested lot
- 600 pcsThe central estimate rounded down to a multiple of the minimum lot; if the central estimate is below a lot but the high one is above, one lot.
- Lot profit: central
- 1.12 m ₽
- Lot profit: low / high
- 439,333 ₽ / 1.12 m ₽
- The lot pays if at least this share sells
- 35.9 %The share of the lot that must sell to cover the loss on the leftover.
Three demand estimates
| Estimate | Season forecast | Left to sell | Reorder needed | Lot profit |
|---|---|---|---|---|
| Low | 1,167 | 747 | 367 | 439,333 ₽ |
| Central | 1,400 | 980 | 600 | 1.12 m ₽ |
| High | 1,680 | 1,260 | 880 | 1.12 m ₽ |
Do not extrapolate a promotion week or a new brand’s curve; allow for production time: a reorder arriving after the peak will not sell. For foreign buying see “Exchange rate and duty scenario”.
Nuances and limits
- Do not extrapolate a promotion week.
- Take the cumulative curve of your own brand and category.
- A reorder arriving after the peak will not sell.