Open-to-buy (OTB)
Planned sales + planned markdowns + ending stock − opening stock − already on order, at retail; at cost: × (1 − initial margin)
- Formula
Planned sales + planned markdowns + ending stock − opening stock − already on order, at retail; at cost: × (1 − initial margin)- Unit
- RUB
- Aggregation rule
- Sum
- Source system
- Plan and budget model; ERP and accounting system
- Owning role
- Head of buying / buyer
- Frequency
- Per season
Passport
- Grain
- Category × season × month
- At zero or no data
- A result below 0 means the budget is used up: show 0 and the overrun separately.
- Limits
- The method version, planned markdowns and the basis (retail or cost) are fixed. At cost: × (1 − initial margin). “Already ordered” means confirmed receipts and commitments.
- Check example
- Planned sales, RUB: 10000000; Planned markdowns, RUB: 1000000; Closing stock, RUB: 4000000; Opening stock, RUB: 3000000; Already ordered, RUB: 5000000.
a+b+c-d-e. Result: RUB 7,000,000 - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Open-to-buy (OTB)
- Calculation: Open-to-buy (OTB) for the season
Definition
Open-to-buy (OTB): how much goods can still be ordered for the season given planned sales, price cuts and stock. It is counted at retail and at cost; the result is split by categories and months. It is used when planning the season buy.
Suppose sales are 100, price cuts 10, closing stock 30, opening stock 40 and orders 20: OTB is (100 + 10 + 30) − (40 + 20) = 80. A minus means orders and stock exceed the plan: no new buying is needed.