Syntha Lab RU

Open-to-buy (OTB) for the season

Calculates how much more you can buy for the season given planned sales, markdowns and target ending stock, net of orders already placed.

Buying budget and cash For whom: Buyers and merchandisers responsible for the season’s buying budget.

Calculate on your data →

At a glance

What question does it answer?
How much more can be bought for the season without exceeding the sales plan, markdowns and target ending stock.
What data is needed?
Planned sales, planned markdowns, weeks in the season and target cover in weeks.
How to read the result?
A positive budget is free money for buying (at selling price and at cost). A negative one means more orders than the plan needs: no new buying, and part of what is placed is worth revisiting while orders can change. Untick orders that can still be canceled. Example on the default values: season sales RUB 120m, planned markdowns 12% of sales, ending stock of 8 weeks of sales, i.e. RUB 36.9m. The buying budget is RUB 45.6m at selling price, or RUB 19.2m at cost; orders already placed come to RUB 85.7m at selling price.

Why and how to reason

OTB (open-to-buy) answers “how much more can we buy”, and the logic is a balance, like a wallet. To reach the end of the season you need as much goods as you will sell, plus what goes into markdowns, plus an ending stock to start the next period from. That is the need. It is covered by what already lies at the start and what is already ordered. What remains of the need is the buying budget.

Units matter here. Sales and stock are at selling price, while orders are entered at cost, so orders are converted to selling price through the initial margin: RUB 36 m at cost with a 58% margin is 36 / 0.42, about RUB 85.7 m at selling price.

Example. Plan RUB 120 m, markdowns 12% = RUB 14.4 m, ending stock of 8 weeks = 120 / 26 x 8, about RUB 36.9 m: the need is RUB 171.3 m. Cover: opening stock RUB 40 m + orders RUB 85.7 m = RUB 125.7 m. The budget is RUB 45.6 m at selling price and 45.6 x 0.42, about RUB 19.2 m, at cost.

When to use it

It is useful before buying the season and at every plan revision, especially when part of the orders is already placed. It suits the whole company or a group of categories. It does not replace the split by category and size: a total budget can be spent on the wrong things. Assumptions: planned sales are realistic and the initial margin is one for all orders. If sales depend strongly on weather or promotions, run two scenarios.

How to read the result

The main number is the buying budget. Positive: there is room for new orders, but it should be spent by category, not in one piece. Close to zero: the season is fully bought and new items must be paid for by dropping others. Negative: you have bought more than the plan, so markdowns are inevitable or deliveries must be canceled or moved. Check the budget at cost against your cash: will it cover the prepayments? If the ending stock came out too large, check whether you set too many weeks. It is worth reconciling category budgets: their sum must not exceed the total.

Common mistakes

A typical error is to enter orders at selling price when the field expects cost, and get an understated or even negative budget: in the example, instead of +45.6 m you get about -73 m. Another is to forget markdowns: the buy is then too small, because part of the revenue is lost to discounts. A third is to set the ending stock “as last year” when the sales pace has changed. A fourth is to mix planned sales with and without VAT.

What data is needed?

  • Planned sales, planned markdowns, weeks in the season and target cover in weeks.
  • Opening stock at selling price and the initial margin.
  • Orders already placed with suppliers at cost.

Inputs

FieldUnitValue in the exampleMeaning
Planned sales₽120,000,000Season sales at retail price excluding VAT.
Planned markdown amount% of sales12The amount of markdowns in money as a percentage of planned sales, not the share of sales sold on markdown (the same as “markdown amount” in the by-category calculation). If you know the share sold on markdown and its depth: amount = share × depth ÷ (1 − depth); example: 28% × 30% ÷ 70% = 12%. The example value is illustrative and there is no single norm in Russia: take it from past seasons. Your company may name the stage differently (In Sale, Sell-Out). The default is set for apparel; for footwear, accessories and children’s pick a set above the form or enter your own data.
Weeks in the seasonweeks26Season length in weeks; sales are divided by it to get the weekly pace behind the ending stock.
Target ending stock, weeks of salesweeks8How many weeks of sales should remain in stock at the end of the season. The default is set for apparel; for footwear, accessories and children’s pick a set above the form or enter your own data.
Opening stock, at selling price₽40,000,000Stock on the first day of the season converted to selling price excl. VAT. From stock records at cost: stock ÷ (1 − initial margin).
Initial margin% of selling price58The share of the selling price that is your margin before markdowns. Used to convert purchases from cost to selling price. The default is set for apparel; for footwear, accessories and children’s pick a set above the form or enter your own data.

How it is calculated

StepFormula
RequirementPlanned sales + markdowns + ending stock
CoverageOpening stock + orders at selling price
OTBRequirement − coverage
At costOTB × (1 − initial margin)

Worked numbers

Default values from the app; in the interactive version you enter your own.

OTB at selling price
45.6 m ₽How much merchandise at selling price you can still order.
OTB at cost
19.2 m ₽The same money at purchase prices: what you can commit to suppliers.
Target ending stock
36.9 m ₽Planned sales ÷ weeks × target weeks of cover.
Already ordered
85.7 m ₽Orders at cost converted to selling price.
Buying budget: from need to the free budget
Waterfall: Needed: sales +120m, Needed: markdowns +14.4m, Needed: ending stock +36.9m, Total need 171m, opening stock −40m, placed orders −85.7m, Free budget 45.6m050m100m150m200mNeeded: salesNeeded: salesNeeded: sales: +120m+120mNeeded: markdownsNeeded: markdownsNeeded: markdowns: +14.4m+14.4mNeeded: ending stockNeeded: ending stockNeeded: ending stock: +36.9m+36.9mTotal needTotal needTotal need: 171m171mopening stockopening stockopening stock: −40m−40mplaced ordersplaced ordersplaced orders: −85.7m−85.7mFree budgetFree budgetFree budget: 45.6m45.6m₽
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
Needed: sales+120m120m
Needed: markdowns+14.4m134m
Needed: ending stock+36.9m171m
Total need—171m
opening stock−40m131m
placed orders−85.7m45.6m
Free budget—45.6m

45.6 m ₽ is free at selling price (19.2 m ₽ at cost). Split it across categories by their share of sales.

Nuances and limits

  • All plan amounts are at selling price excl. VAT: mixing with cost gives an error of several times.
  • Split the budget across categories by share of sales, otherwise money goes to slow items.

Terms used

Calculate on your data →