Buying plan from revenue backwards: revenue → cost → order
Goes from the net revenue forecast of the current season to the order for the next one: adds the plan growth, subtracts the non-seasonal revenue (old seasons, future ones, consignment, made to order), turns the seasonal revenue into cost of goods sold through the markup coefficient and the period discount, then through Sell-through at cost and the cancellation rate into delivery and order. Shows the effective discount of the plan. The stock under this budget is counted in the “Open-to-buy” calculation; here we answer how large the order must be for the plan revenue to add up.
At a glance
- What question does it answer?
- How large the order must be for the plan revenue to add up at your markup, discounts, sell-through and cancellation, and what effective discount the plan holds.
- What data is needed?
- The net revenue forecast excl. VAT by period: before the sale and the sale.
- How to read the result?
- First the season sell-through: above 100% means the plan is unrealistic. Then the effective discount against your history and the order against the open-to-buy remainder. Example on the default values: Plan revenue: RUB 110 million; Seasonal plan revenue: RUB 98 million; Cost of goods sold: before the sale: RUB 36.2 million; Cost of goods sold: the sale: RUB 13.6 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A buying budget is easier to defend if you go backwards from revenue: each assumption is visible on its own. Plan revenue comes from the forecast and the growth, then the non-seasonal part (old seasons, future ones, consignment, made to order) is subtracted and the seasonal remains. It is divided by the markup coefficient and by one minus the period discount: this gives the cost of goods sold. Sell-through at cost turns it into delivery, the cancellation rate into the order. In the example plan revenue is 110 m RUB, seasonal 98 m RUB, cost of goods sold 49.9 m RUB, delivery 58.4 m RUB, order 63.5 m RUB, season sell-through 85.3%, effective discount 18.1%.
When to use it
Apply when building the budget of the next season from the forecast of the current one, when defending the budget before the finance director and at each forecast update. It does not replace the “Open-to-buy” calculation: that one subtracts stock and orders in transit, this one answers how much must be ordered for the plan revenue to add up.
How to read the result
Look at the season sell-through: above 100% means an unrealistic plan. Then at the effective discount against your past seasons and at the sale share in the plan against the forecast. Compare the order with the budget remainder and the confirmation path.
Common mistakes
They take the markup percent instead of the coefficient, count sell-through at revenue, do not subtract the non-seasonal revenue, mix the periods with the BS, IS, AS, SO of “Sale stages” and fit sell-through to the wanted order instead of checking the assumptions.
What data is needed?
- The net revenue forecast excl. VAT by period: before the sale and the sale.
- Non-seasonal revenue: old seasons, future ones, consignment, made to order.
- The markup coefficient, period discounts, sell-through before the sale and the cancellation rate from past seasons.
- An example at the default values: plan revenue 110 m RUB, cost of goods sold 49.9 m RUB, delivery 58.4 m RUB, order 63.5 m RUB, season sell-through 85.3%, effective discount 18.1% (illustrative numbers).
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Forecast net revenue before the sale | ₽ | 80,000,000 | Net revenue excl. VAT for the period before the sale across all goods, seasonal and non-seasonal. The example value is illustrative. |
| Forecast net revenue of the sale | ₽ | 20,000,000 | The same for the sale period (the last month of the season by your calendar). The example value is illustrative. |
| Plan growth over the forecast | % | 10 | By how many percent the plan net revenue is above the forecast. May be negative. The example value is illustrative. |
| Sale share of the plan revenue | % | 20 | What part of the plan revenue you assign to the sale period. Compare with the share in the forecast (shown in the result) and with your own past seasons. The example value is illustrative. |
| Old seasons | ₽ | 4,000,000 | Revenue from leftovers of past seasons. The example value is illustrative. |
| Future seasons | ₽ | 1,000,000 | Revenue from goods of next seasons that arrived early. The example value is illustrative. |
| Consignment | ₽ | 2,000,000 | Revenue from goods on commission, they are not part of the buy. The example value is illustrative. |
| Made to order | ₽ | 1,000,000 | Revenue from individual orders. The example value is illustrative. |
| Old seasons | ₽ | 3,000,000 | The same for the sale period. The example value is illustrative. |
| Future seasons | ₽ | 0 | The same for the sale period. The example value is illustrative. |
| Consignment | ₽ | 1,000,000 | The same for the sale period. The example value is illustrative. |
| Made to order | ₽ | 0 | The same for the sale period. The example value is illustrative. |
| Markup coefficient (price ÷ cost) | × | 2.4 | The planned price excl. VAT divided by the cost at purchase prices. It is not the markup percent: a coefficient of 2.4 is a markup of 140%. The example value is illustrative. |
| Discount before the sale | % | 8 | The average discount on seasonal goods in the period before the sale (promotions, bonuses). Below 100%. The example value is illustrative. |
| Discount in the sale | % | 45 | The average discount on seasonal goods in the sale period. Below 100%. The example value is illustrative. |
| Sell-through at cost before the sale | % | 62 | What part of the delivered goods (at purchase prices) is sold before the sale. Take it from your own past seasons. Above 100% is impossible: the calculation will warn. The example value is illustrative. |
| Cancellation rate | % | 8 | What share of the ordered is not delivered: 1 − delivered ÷ ordered. Look at the gaps “ordered → confirmed” and “confirmed → delivered” separately (confpath). The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Plan revenue | (80 m ₽ + 20 m ₽) × (1 + 10%) = 110 m ₽ |
| Seasonal revenue of a period | plan revenue of the period − non-seasonal revenue of the period |
| Cost of goods sold | seasonal revenue ÷ markup coefficient ÷ (1 − period discount) |
| Delivery | cost before the sale ÷ sell-through before the sale |
| Sell-through of the sale and the season | cost of the period ÷ delivery |
| Order | delivery ÷ (1 − cancellation rate) |
| Effective discount | 1 − seasonal revenue ÷ (cost × markup coefficient) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Plan revenue
- 110 m ₽(forecast before + forecast of the sale) × (1 + growth).
- Seasonal plan revenue
- 98 m ₽
- Cost of goods sold: before the sale
- 36.2 m ₽
- Cost of goods sold: the sale
- 13.6 m ₽
- Cost of goods sold: whole season
- 49.9 m ₽
- Delivery at cost
- 58.4 m ₽Cost before the sale ÷ sell-through before the sale.
- Order
- 63.5 m ₽Delivery ÷ (1 − cancellation).
- Sell-through of the sale
- 23.3 %
- Season sell-through
- 85.3 %
- Effective discount of the plan
- 18.1 %1 − seasonal revenue ÷ (cost × markup coefficient).
- Not delivered in the plan
- 5.08 m ₽
- Sale share in the forecast
- 20 %
- Seasonal revenue
- Cost of goods sold
Data as a table
| Measure | Seasonal revenue | Cost of goods sold |
|---|---|---|
| Before the sale | 80 | 36.2 |
| The sale | 18 | 13.6 |
Data as a table
| Measure | Amount |
|---|---|
| Plan revenue | 110 |
| Seasonal revenue | 98 |
| Cost | 49.9 |
| Delivery | 58.4 |
| Order | 63.5 |
Calculation by period
| Period | Plan revenue | Non-seasonal | Seasonal | Discount | Cost | Sell-through |
|---|---|---|---|---|---|---|
| Before the sale | 88 m ₽ | 8 m ₽ | 80 m ₽ | 8 % | 36.2 m ₽ | 62 % |
| The sale | 22 m ₽ | 4 m ₽ | 18 m ₽ | 45 % | 13.6 m ₽ | 23.3 % |
| Whole season | 110 m ₽ | 12 m ₽ | 98 m ₽ | 18.1 % | 49.9 m ₽ | 85.3 % |
The periods here: before the sale, the sale, the whole season. They do not match the BS, IS, AS, SO stages of the “Sale stages” calculation, where AS is the period after the sale. All benchmarks are your own: there are no common norms, compare with your own seasons.
What to do with the result: compare the order with the open-to-buy remainder and with the confirmation path; if the order does not fit, change the plan growth or discounts, not sell-through “for looks”.
A typical mistake: taking the markup percent instead of the coefficient, dividing by sell-through at revenue, and forgetting that stock is counted only for carried-over goods.
Nuances and limits
- Substituting the markup percent for the coefficient: price ÷ cost, not price ÷ cost − 1.
- Counting the share sold at revenue: here it is counted at cost, like purchases and stock.
- Not subtracting non-seasonal revenue: the order is overstated by what will sell from other sources.
- Mixing the periods with the BS, IS, AS, SO stages of the stages calculation.