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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Planned sales | ₽ | 120,000,000 | Season sales at retail price excluding VAT. |
| Planned markdown amount | % of sales | 12 | The 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 season | weeks | 26 | Season length in weeks; sales are divided by it to get the weekly pace behind the ending stock. |
| Target ending stock, weeks of sales | weeks | 8 | How 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,000 | Stock 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 price | 58 | The 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
| Step | Formula |
|---|---|
| Requirement | Planned sales + markdowns + ending stock |
| Coverage | Opening stock + orders at selling price |
| OTB | Requirement − coverage |
| At cost | OTB × (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.
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Needed: sales | +120m | 120m |
| Needed: markdowns | +14.4m | 134m |
| Needed: ending stock | +36.9m | 171m |
| Total need | — | 171m |
| opening stock | −40m | 131m |
| placed orders | −85.7m | 45.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.