Syntha Lab RU

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.

Buying budget and cash For whom: Buyers, category managers, commercial and finance directors who build the buying budget of the next season from the forecast of the current one.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Forecast net revenue before the sale₽80,000,000Net 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,000The same for the sale period (the last month of the season by your calendar). The example value is illustrative.
Plan growth over the forecast%10By 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%20What 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,000Revenue from leftovers of past seasons. The example value is illustrative.
Future seasons₽1,000,000Revenue from goods of next seasons that arrived early. The example value is illustrative.
Consignment₽2,000,000Revenue from goods on commission, they are not part of the buy. The example value is illustrative.
Made to order₽1,000,000Revenue from individual orders. The example value is illustrative.
Old seasons₽3,000,000The same for the sale period. The example value is illustrative.
Future seasons₽0The same for the sale period. The example value is illustrative.
Consignment₽1,000,000The same for the sale period. The example value is illustrative.
Made to order₽0The same for the sale period. The example value is illustrative.
Markup coefficient (price ÷ cost)×2.4The 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%8The average discount on seasonal goods in the period before the sale (promotions, bonuses). Below 100%. The example value is illustrative.
Discount in the sale%45The average discount on seasonal goods in the sale period. Below 100%. The example value is illustrative.
Sell-through at cost before the sale%62What 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%8What 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

StepFormula
Plan revenue(80 m ₽ + 20 m ₽) × (1 + 10%) = 110 m ₽
Seasonal revenue of a periodplan revenue of the period − non-seasonal revenue of the period
Cost of goods soldseasonal revenue ÷ markup coefficient ÷ (1 − period discount)
Deliverycost before the sale ÷ sell-through before the sale
Sell-through of the sale and the seasoncost of the period ÷ delivery
Orderdelivery ÷ (1 − cancellation rate)
Effective discount1 − 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 %
Revenue and cost by period, m RUB
Bar chart: Before the sale 80, The sale 18020406080Before the saleBefore the saleSeasonal revenue: 8080Cost of goods sold: 36.236.2The saleThe saleSeasonal revenue: 1818Cost of goods sold: 13.613.6
  • Seasonal revenue
  • Cost of goods sold
Data as a table
MeasureSeasonal revenueCost of goods sold
Before the sale8036.2
The sale1813.6
From plan to order, m RUB
Bar chart: Plan revenue 110, Seasonal revenue 98, Cost 49.9, Delivery 58.4, Order 63.5020406080100120Plan revenuePlan revenueAmount: 110110Seasonal revenueSeasonal revenueAmount: 9898CostCostAmount: 49.949.9DeliveryDeliveryAmount: 58.458.4OrderOrderAmount: 63.563.5
Data as a table
MeasureAmount
Plan revenue110
Seasonal revenue98
Cost49.9
Delivery58.4
Order63.5

Calculation by period

PeriodPlan revenueNon-seasonalSeasonalDiscountCostSell-through
Before the sale88 m ₽8 m ₽80 m ₽8 %36.2 m ₽62 %
The sale22 m ₽4 m ₽18 m ₽45 %13.6 m ₽23.3 %
Whole season110 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.

Terms used

Calculate on your data →