A buying plan from revenue backwards: revenue, cost, delivery, order and the recalculation rules
The document shows how to derive the order for the next season from the revenue forecast of the current one and the plan growth: subtract the non-seasonal revenue, turn the seasonal revenue into cost through the markup coefficient and the discount, then into delivery through sell-through and into the order through the cancellation rate. The decision it supports: how large to order and which assumptions to move if the order does not fit the budget.
Why this document
A budget is often handed down as a number “buy this much” and then people argue about where it came from. Going backwards from revenue makes every assumption visible and open to challenge: growth, sale share, discount, sell-through, cancellation. The document is read by the buyer, the category manager, the commercial and finance directors before the budget defense. There are no common norms for sell-through and discount, all benchmarks are your own, from past seasons.
At a glance
- What is this document and why is it needed?
- The document shows how to derive the order for the next season from the revenue forecast of the current one and the plan growth: subtract the non-seasonal revenue, turn the seasonal revenue into cost through the markup coefficient and the discount, then into delivery through sell-through and into the order through the cancellation rate. The decision it supports: how large to order and which assumptions to move if the order does not fit the budget.
- Who owns the document and how often is it rebuilt?
- Brand and retail: the category manager builds the calculation, the finance director approves the assumptions; recalculate at each forecast update and before each budget review.
- What mistakes are the most common?
- Substituting the markup percent for the coefficient → cost is understated → take price ÷ cost. Not subtracting non-seasonal revenue → the order is overstated → subtract old seasons, consignment, made to order. Counting the share sold at revenue → the calculation does not match stock and purchases → count both sold and delivered at cost.
For whom
- Brand
- A brand counts the order to the factory and the production volume months before sales: an error in sell-through or cancellation turns into leftovers or a shortage at once. Subtract wholesale and consignment from the seasonal revenue separately.
- Retail
- A retailer orders from brands and suppliers and the confirmation comes later: separate ordered, confirmed and delivered, and count cancellation against the delivered.
What it consists of
The calculation chain
- Plan revenue = (forecast before the sale + forecast of the sale) × (1 + plan growth); you set the sale period share separately and compare it with the forecast share.
- Seasonal revenue = plan revenue of the period − non-seasonal revenue: old seasons, future ones, consignment, made to order.
- Cost of goods sold = seasonal revenue ÷ markup coefficient ÷ (1 − period discount).
- Delivery = cost before the sale ÷ sell-through before the sale; season sell-through = season cost ÷ delivery; order = delivery ÷ (1 − cancellation).
- The effective discount of the plan = 1 − seasonal revenue ÷ (cost × markup coefficient): it includes explicit and implicit discounts.
What is recalculated on a manual edit
- Three groups of cells: inputs (you set), derived (calculated) and locked (the forecast of the current season after it closes, the actual delivery). The dependency scheme in the scheme reference shows what depends on what.
- Editing sell-through changes delivery, order and the sale sell-through, but not revenue or cost. Editing a discount changes cost and through it delivery and order. Editing cancellation changes the order only.
- Choose one rule: when a derived cell is edited, either recalculate the inputs or lock the cell and mark it as locked. Mixing is not allowed: the figures stop adding up.
Seasonal and carried-over goods
- For seasonal (not carried-over) goods stock is not subtracted in the budget: even a matching SKU is a different style. For carried-over goods stock is subtracted so as not to over-buy.
- The stock under the budget is counted in the “Open-to-buy” calculation, the “planning type” flag is kept in the assortment reference.
Sanity checks
- Season sell-through above 100%: the plan must sell more than is delivered. A discount of 100% or more: division is impossible. Zero sell-through or 100% cancellation: the order is undefined.
- The non-seasonal revenue exceeds the plan revenue of the period: the seasonal one is negative, fix the input and not the sign.
- Recalculate the example by hand before signing the budget: five rows of arithmetic give the same figures.
How to defend the plan before finance and the supplier
- Show the chain link by link: revenue, the non-seasonal part, seasonal revenue, cost, delivery, order. Each assumption (growth, discount, share sold, cancellation) sits in its own row, and the argument is about a specific number rather than about the order as a whole.
- Give two scenarios side by side: a base one and a cautious one where the share sold before the sale is a few points lower and cancellation higher. The difference in the order shows the price of an error and helps agree a two-stage order: the confirmed part now, the rest after the control week.
- For the supplier turn the order into the language of its calendar: dates of the first, half and last delivery and the minimum run per style. If the order does not fit the run, change the number of styles or the depth, not the markup coefficient.
What to do with the result after the season
- Compare the actual share sold, discount and cancellation with the assumptions by period. A gap in one assumption explains most of the order error: record its cause (weather, price, a missed delivery) and correct that assumption for the next season rather than “fitting” everything at once.
- Keep plan and actual in one table by season: after two or three seasons it is visible which assumptions are systematically overstated, and the buying budget stops depending on mood.
Where the data comes from
| Data source | Fields |
|---|---|
| Forecast and plan | net revenue excl. VAT by period, non-seasonal revenue of four kinds, plan growth |
| Price and discounts | markup coefficient, average discounts of periods (explicit and implicit) |
| Orders and deliveries | ordered, confirmed, delivered at purchase prices, dates of the first, half and last delivery |
How to build it step by step
- Step 1: Collect the net revenue forecast of the current season by period excl. VAT.
- Step 2: Separate the non-seasonal revenue: old seasons, future ones, consignment, made to order.
- Step 3: Set the plan growth and the sale revenue share; explain the difference from the forecast.
- Step 4: Take the markup coefficient and the period discounts from your own past seasons.
- Step 5: Set Sell-through at cost before the sale and the cancellation rate from past deliveries.
- Step 6: Calculate cost, delivery, season sell-through and the order; check that sell-through is below 100%.
- Step 7: Compare the order with the open-to-buy remainder and the confirmation path.
- Step 8: Choose the recalculation rule for edits and mark the locked cells.
- Step 9: After the season compare the actual sell-through, discount and cancellation with the assumptions.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| The plan chain | Order = cost before the sale ÷ sell-through before the sale ÷ (1 − cancellation); cost = seasonal revenue ÷ coefficient ÷ (1 − discount) | Amounts excl. VAT; Sell-through and cancellation as shares of delivery and order. |
| Effective discount | 1 − seasonal revenue ÷ (cost × markup coefficient) | Includes explicit and implicit discounts. |
Formulas in notation
- Order
O = \frac{R_{BS}}{K (1 - d_{BS}) \cdot S_{BS} \cdot (1 - c)}
R: seasonal revenue before the sale, K: markup coefficient, d: discount, S: Sell-through, c: cancellation.
Worked example
The plan of the next season on illustrative data: forecast 100 m RUB, growth 10%, coefficient 2.4, sell-through before the sale 62%, cancellation 8%
| Period | Plan revenue, m RUB | Seasonal, m RUB | Cost, m RUB |
|---|---|---|---|
| Before the sale | 88.0 | 80.0 | 36.2 |
| The sale | 22.0 | 18.0 | 13.6 |
| Whole season | 110.0 | 98.0 | 49.9 |
Delivery 58.4 m RUB, order 63.5 m RUB, season sell-through 85.3%, effective discount 18.1%. All numbers are illustrative.
Figures
- Seasonal revenue
- Cost
Data as a table
| Measure | Seasonal revenue | Cost |
|---|---|---|
| Before the sale | 80 | 36.2 |
| The sale | 18 | 13.6 |
Revenue and cost by period. The sale gives a fifth of revenue but eats almost two fifths of cost: the discount is deeper.
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Sold at cost | +49.9 | 49.9 |
| Unsold | +8.6 | 58.5 |
| Cancellation | +5.1 | 63.6 |
| Order | — | 63.5 |
From delivery to order. Cancellation adds to the delivery the sum that has to be ordered on top to receive what is needed.
Specifics by category
- Apparel
- Apparel: many sizes, sell-through differs by size; set aside a reserve for size gaps.
- Footwear
- Footwear: the size grid is stiffer, cancellation and short delivery of extreme sizes cost more.
- Accessories
- Accessories: more carried-over styles, subtract stock more carefully.
- Kids
- Kids: height-size and the school season; the sale discount is usually deeper.
- Men
- Men: a steady core range, a higher carried-over share.
- Women
- Women: more novelties without history, take sell-through from analogs.
Common mistakes
- Substituting the markup percent for the coefficient → cost is understated → take price ÷ cost.
- Not subtracting non-seasonal revenue → the order is overstated → subtract old seasons, consignment, made to order.
- Counting the share sold at revenue → the calculation does not match stock and purchases → count both sold and delivered at cost.
- Ignoring sell-through above 100% → the plan is unrealistic → lower revenue or discounts.
- Defending only the final order amount → any assumption can be challenged and the haggling is blind → show the chain and two scenarios.
- Not recording the cause of the deviation after the season → the error repeats → record the cause for each assumption.
- Mixing the periods with BS, IS, AS, SO of “Sale stages” → figures are not comparable → use the period names.
Russian specifics
- The method is managerial and is not regulated; the price in the calculation is excl. VAT. The provision for inventory impairment under the Russian accounting standard FSBU 5/2019 depends on stock, which this method does not count.