Syntha Lab RU

Open-to-buy budget (OTB)

OTB shows how much more can still be purchased for a period to meet the sales plan and reach the target closing stock. It protects against overbuying and empty shelves: it decides how much money to release for purchasing and how much to hold in reserve for in-season reorders.

Commerce and buying Brand and retail Verified: 2026-11-13

Open interactively →

Why this document

Purchasing is the costliest decision in a season: a mistake cannot be fixed until the goods are sold. OTB turns the sales plan into a money limit: to planned sales add the target closing stock and subtract what is already in the warehouse and on order. The remainder is open to buy. The buyer stays within the limit, the finance director sees how much cash goes into goods, and part of the budget stays in reserve to reorder what sells better than expected.

At a glance

What is this document and why is it needed?
OTB shows how much more can still be purchased for a period to meet the sales plan and reach the target closing stock. It protects against overbuying and empty shelves: it decides how much money to release for purchasing and how much to hold in reserve for in-season reorders.
Who owns the document and how often is it rebuilt?
Retailer: head of buying and category managers, monthly and per season, agreed with the finance director. Brand: collection planner, when ordering from factories for the season; for a brand “buying” means the production order.
What mistakes are the most common?
Retail and cost are mixed in one formula → the budget is overstated about twofold → compute retail, then convert to cost through IMU. Markdowns are taken as the share of sales on markdown → the needed stock is understated → OTB needs the markdown amount in money. Placed but not yet received orders are ignored → overbuying → always subtract orders in transit and confirmed ones.

For whom

Brand
For a brand OTB becomes the production budget: how many units and how much money can be placed with factories for the season. A reserve for reorders and the ending stock is added to the channel sales plan; the measure is cost, not selling price. Minimum order quantities (MOQ) and booking windows often make the budget stepwise.
Retail
A retailer computes OTB by category and month at retail: planned sales + planned markdowns + target ending stock − opening stock − already on order. It is then converted to cost through initial margin (IMU). It is refreshed each month in season: actual sales and adjusted markdowns move the budget.

What it consists of

The “Plan” block

  • Planned sales of the period excluding VAT, by category and month.
  • Planned markdowns: the amount of discounts in money, not the share of sales on markdown.
  • Target ending stock: weeks of sales or stock-to-sales, by category.
  • Retailer: Losses: the retail OTB formula adds planned losses (shrink, returns to the supplier) as a percentage of sales; in the example they are 1% of sales, from 0.6% for footwear to 1.8% for accessories.

The “What exists” block

  • Retailer: Opening stock at retail: stock at cost ÷ (1 − IMU), or inventory at selling prices.
  • Retailer: Orders placed but not yet received: by supplier, date and category, at retail and at cost.
  • Brand: the production order in units (Model B): planned season sales of 40,000 units (80,000 a year ÷ 2) plus a 12% reorder reserve and ending stock, minus opening stock; at cost of RUB 1,200 this is RUB 53.76 million before stock. The order is rounded to the factory MOQ and fabric multiples, so the real order is stepped.

The “Result” block

  • Retailer: OTB at retail and at cost, by category and month; a negative figure means overbuying.
  • Reserve: 10-20% of the budget for reorders after early sales; the share is a risk setting, not a norm (an editable hint, not verified).

Brand and retailer: what is computed differently

  • Brand: brand OTB turns into a production budget: planned channel sales plus a reorder reserve and ending stock, at cost, rounded to MOQ and fabric multiples; order placement windows make the budget stepped.
  • Retailer: retailer OTB is computed by category and month at retail and converted into cost through the purchase IMU of the category; it is updated every month of the season by actual sales and revised markdowns.

Brand: how the document differs and what to add

  • Brand: brand OTB is a production order in units: planned season sales, a reserve for top-ups and closing warehouse stock less opening stock.
  • Brand: the order is split into a confirmed part (wholesale preorders, factory MOQ) and a reserve; the reserve is bought later from actual demand in the first weeks.
  • Brand: brand OTB has no store shrink but has partner returns and factory defects; they are provided for as a percentage of the shipment.
  • Brand: brand IMU leads to the wholesale price and channel margin; OTB is computed separately at the wholesale price and at the retail price of own channels.
  • Brand: fabric and production lead times (60 to 120 days) make brand OTB a commitment a season ahead; revision is possible only through the reserve.
  • Brand: brand categories are lines and capsules; OTB is computed by line, and cannibalization by a new capsule is deducted from the old one’s sales.
  • Brand: brand closing stock is estimated with partner remaining stock: unsold stock at partners returns as returns or discounts.

Retailer: how the document differs and what to add

  • Retailer: retailer OTB is computed by category and week: open-to-buy is recomputed every week from actual sales and receipts.
  • Retailer: closing stock is tied to next-period sales, not current: otherwise a category is under-bought before the peak.
  • Retailer: markdowns and shrink enter OTB as separate lines: without them purchasing is understated by 8 to 15% of sales by category.

How to read the result and which decisions follow

  • Category OTB is negative: more is ordered than needed; stop new orders, check whether deliveries can be moved or canceled; do not close the hole with a discount.
  • Closing stock is above target weeks of cover by 20% or more (a guide): reduce deliveries and revisit price; the decision is taken by category, not by network.
  • OTB at retail agrees but at cost does not: check IMU and markdowns; the gap means the supplier order is computed with a wrong margin.

Control checks

  • The sum of category OTB equals total OTB (RUB 199.678 million at retail, 85826 at cost).
  • Season sales are tied to the sales plan (to Model R for the retailer); opening stock equals the balance at the date from warehouse records.
  • Typical traps: closing stock from current rather than next-period sales; shrink forgotten; IMU and realized margin confused; orders counted without cancellations.

Where the data comes from

Data sourceFields
The sales planSales by category and month, markdown share, season length in weeks.
Inventory records and WMSOpening stock at cost and in units; flows; write-offs.
Supplier order bookSKU, quantity, price, delivery date, status (the po template).
Margin dataInitial margin (IMU) by category from the price list; actual maintained margin (MMU).

How to build it step by step

  1. Step 1. Take the approved sales plan by category and month excluding VAT.
  2. Step 2. Define planned markdowns per category from history (the amount, not the share) and check against the promo plan.
  3. Step 3. Set the target ending stock: weeks of next-period sales. For seasonal categories the end-of-season weeks are lower than before the high season.
  4. Step 4. Convert opening stock and orders to selling price: cost ÷ (1 − IMU).
  5. Retailer: Step 5. Compute OTB at retail: sales + markdowns + ending stock − opening stock − orders.
  6. Step 6. Convert to cost: OTB × (1 − IMU). This is the commitment limit with suppliers.
  7. Step 7. Check convergence: the category sum equals the total; analyze negative OTB separately (carry over, sale, order cancellation).
  8. Step 8. Refresh monthly: actual sales, stock, new orders; reallocate budget between categories by sell-through.
  9. Step 9. Show the owner the total in money, the commitment limit and the working-capital need.

Formulas

MeasureFormulasNote
OTB at retailOTB = Sales + Markdowns + Losses (shrink, returns to the supplier) + Ending stock − Opening stock − On order (all at retail excluding VAT)The “Open-to-buy (OTB) for the season” calculation.
Ending stock via weeksEnding stock = Next-period sales ÷ Next-period weeks × Target weeks of coverTake next-period sales, not current: the ending stock must cover future sales; in the example this is the column “on next-period sales”. If current-season sales are used, stock of seasonal categories is understated or overstated.
OTB at costOTB (cost) = OTB (retail) × (1 − IMU)Use the category IMU, not the chain average: otherwise money is misallocated.
Stock-to-sales methodOpening stock of the month = Month sales × stock-to-sales ratioThe “Opening stock by month: stock-to-sales and open-to-buy” calculation.

Formulas in notation

Open-to-buy
OTB = S + MD + Sh + EOP − BOP − OO
S is sales, MD is markdowns, Sh is shrink, EOP is closing stock, BOP is opening stock, OO is on order; all at retail.
Closing stock
EOP = S_next / W · C
S_next is next-period sales, W is weeks in it, C is the target weeks of cover of the category.
Weeks of cover
WOS = Stock / (Sales / W)
Stock is divided by average weekly sales; compared with the category target.

Worked example

Retailer: season OTB for five categories (26 weeks), RUB m excluding VAT (season sales tied to Model R)

CategorySeason salesMarkdowns, %Losses, RUB mEnding weeks of cover (on next-period sales)Ending stockOpening stockOn order (retail)OTB, retailIMU, %OTB, cost
Women115.7131.16836.839.241.188.45837.1
Men52.3110.52816.416.820.537.65716.2
Kids26.1140.2166.26.510.319.4558.8
Footwear44.8100.271221.522.414.933.85216.2
Accessories22.480.41412.711.25.620.5637.6
Total261.42.5693.696.192.4199.785.8

Result: RUB 199.7 m at retail can be ordered, that is RUB 85.8 m at cost. Footwear and accessories hold more weeks of cover (12 and 14), so they need a larger closing stock at the same sales. Season sales equal half of the Model R sales (RUB 522.704 million a year ÷ 2), category shares are illustrative; the ending stock is computed on next-period sales; losses of RUB 2.56 m are inside OTB. Purchase IMU of 52 to 63% is an assumption of the example, not the margin after markdowns: with a realized margin the OTB at cost would be overstated. A brand would use the same formulas for the production order: add a reorder reserve to the channel plans and convert retail to cost at its own margin. Reconciliation with Model R: the opening stock covers 9.6 weeks of sales, while the Model R DIO of 150 days is 21.4 weeks. These are different stocks: DIO is computed at year end on the whole stock, including tails of past seasons, the warehouse safety stock and goods in transit, while OTB covers only the seasonal line stock; so the OTB purchase (RUB 85.8 m at cost for 26 weeks) is below half of the Model R purchases (RUB 136.1 m). To reconcile OTB with Model R, raise the weeks of cover by category or add carry-over stock as a separate line.

Figures

What OTB consists of: sales, markdowns, shrink, stock
Waterfall: Sales +261,352, Markdowns +30,728, Shrink +2,561, Closing stock +93,584, Opening stock −96,140, Already on order −92,407, OTB 199,6780100,000200,000300,000400,000SalesSalesSales: +261,352+261,352MarkdownsMarkdownsMarkdowns: +30,728+30,728ShrinkShrinkShrink: +2,561+2,561Closing stockClosing stockClosing stock: +93,584+93,584Opening stockOpening stockOpening stock: −96,140−96,140Already on orderAlready on orderAlready on order: −92,407−92,407OTBOTBOTB: 199,678199,678RUB thousand
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
Sales+261,352261,352
Markdowns+30,728292,080
Shrink+2,561294,641
Closing stock+93,584388,225
Opening stock−96,140292,085
Already on order−92,407199,678
OTB—199,678

What OTB consists of: sales, markdowns, shrink, stock. The purchase budget equals sales and shrink plus closing stock less opening stock and what is on order; each category is computed and summed.

OTB by category: how much can still be purchased
Bar chart: Women 88,435, Men 37,577, Kids 19,449, Footwear 33,756, Accessories 20,461020,00040,00060,00080,000100,000WomenWomenOTB at retail: 88,43588,435OTB at cost: 37,14337,143MenMenOTB at retail: 37,57737,577OTB at cost: 16,15816,158KidsKidsOTB at retail: 19,44919,449OTB at cost: 8,7528,752FootwearFootwearOTB at retail: 33,75633,756OTB at cost: 16,20316,203AccessoriesAccessoriesOTB at retail: 20,46120,461OTB at cost: 7,5717,571RUB thousand
  • OTB at retail
  • OTB at cost
Data as a table
MeasureOTB at retailOTB at cost
Women88,43537,143
Men37,57716,158
Kids19,4498,752
Footwear33,75616,203
Accessories20,4617,571

OTB by category: how much can still be purchased. Women has the largest free budget; decisions are taken by category, each with its own stock and orders.

Specifics by category

Apparel
Ending cover is shorter: seasonal goods lose value quickly, so end-of-season stock is kept minimal; planned markdowns are material (10-14% of sales as a starting hint, editable, not verified).
Footwear
A long ending stock (12-16 weeks) because of the size run: each style holds 8-12 sizes that sell unevenly. Buying splits by size, so OTB is accompanied by a size plan; the extreme sizes often remain as dead stock.
Accessories
There are no sizes and turnover is lower, so weeks of cover are higher (12-20) with fewer markdowns. Basic accessories can be reordered almost freely; the limit comes from the budget, not from sizes.
Kids
OTB is split by seasonal waves (school, winter, summer) and age groups; unsold sizes “age out”, so carry-over to the next season is limited by the child growing. Ending stock is shorter than in adult lines.
Men
More stable demand and a high basics share: you can hold a longer stock with fewer markdowns and top up on actuals. OTB is refreshed less often.
Women
More fashion and more risk: keep a larger reorder reserve, split buying into an early and a late order (a two-stage order), and refresh OTB more often, reallocating between categories by sell-through.

Common mistakes

  • Retail and cost are mixed in one formula → the budget is overstated about twofold → compute retail, then convert to cost through IMU.
  • Markdowns are taken as the share of sales on markdown → the needed stock is understated → OTB needs the markdown amount in money.
  • Placed but not yet received orders are ignored → overbuying → always subtract orders in transit and confirmed ones.
  • The average margin is applied to categories → wrong money split between footwear, apparel and accessories → use each category IMU.
  • OTB is not refreshed in season → after an early surge or slump buying follows the old plan → recompute monthly.

Russian specifics

  • Purchases from a Russian supplier include VAT: input VAT is deductible, so OTB is computed on cost excluding VAT (general regime); on the simplified regime VAT enters the cost if the company is not a payer. Rule: Tax Code Art. 171: Tax Code, Art. 171 (VAT deductions) (rule check not completed).
  • Imported goods: OTB includes the full landed cost with duty and customs fees, and import VAT is shown separately (the landed calculation). Rule: Tax Code Art. 160: Tax Code, Art. 160 (tax base on import) (rule check not completed).
  • Light-industry marking: unmarked stock cannot be circulated after the set dates; reflect this when planning opening stock. Rule: Decree 2129 of 25.12.2025: Government Decree of 25.12.2025 No. 2129 (amendments to Decree No. 1956; fourth marking wave).

Open interactively →