Open-to-buy (OTB)
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.
Formula
Planned sales + markdowns + ending stock − opening stock − already ordered
How to read
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.
Where it is discussed
Topics
- Buying budget and cash
- Assortment and sizes
- Forecast and budget
- Order size and break-even
- Collection and range
- Wholesale terms and credit
- Owner’s cash and management dashboard
- Range: width, depth and price tiers
- The planning calendar
Calculations
- Open-to-buy (OTB) for the season
- Buying budget by category and weeks of supply
- Opening stock: stock-to-sales and the monthly buying budget
- The six-month plan and model stock: stock = sales × coverage + safety, purchases by month
- Buying plan from revenue backwards: revenue → cost → order
- Weekly receipts from target weeks of supply (WOS)
- Choosing items under the buying budget and the shelf: a greedy set and an exact scan
- Zero-based budget: cost packages, priority and the effect of cut-off by level
- Brand scorecard for a buyer: weighted criteria, stop criteria and a decision by thresholds
- Buying plan adherence: receipts, sales and stock
Documents
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Open-to-buy budget (OTB)
- Optimization of range and allocation: knapsack by budget and shelf, marginal stock allocation, the transport problem
- The six-month merchandise plan and model stock: sales, coverage, safety stock, purchases by month
- A buyer session: the brand scorecard, the agenda and the order terms
- Excel for retail, part I: lookup by key, pivot tables and data validation
- Excel for retail, part II: ABC analysis and the open-to-buy (OTB) budget in a spreadsheet