The Open-to-Buy Formula, Worked Line by Line
By: Samantha Rose
$41,500.
That is the open-to-buy for one category, for one month, in the example below. It means the brand can commit another $41,500 at cost to receipts landing that month and still end the month with the inventory it planned. Spend less and it risks running short. Spend more and the overage sits in the warehouse as cash that is not available for anything else.
Open-to-buy (OTB) is the budget left for new inventory in a period after you account for what you expect to sell, what you plan to hold at the end, what you already have, and what you have already ordered. The formula is short. The work is in the inputs.
The formula
At cost, for a single period:
Open-to-buy = Planned sales
+ Planned markdowns
+ Planned end-of-period inventory
- Beginning-of-period inventory
- Inventory on order (arriving in the period)
The first three terms are what the period needs. The last two are what you already have or have committed. The difference is what you can still buy.
Retailers often run this at retail value, because their plans are set in selling price. Brands that make or import their own product usually plan at cost, because cost is what leaves the bank account when a PO is paid. Pick one and use it everywhere. Mixing retail-value sales plans with cost-value inventory is the most common reason an OTB number looks wrong.
Planned markdowns appear as an addition because a markdown reduces the value of stock without a unit leaving. If you plan to mark down $8,000 of inventory, that value has to be bought back to hit the same ending position.
A worked month
One category, one month, at cost. The brand sells the category DTC, to two wholesale accounts, and to one retailer on EDI.
| Line | Value at cost | Where it comes from |
|---|---|---|
| Planned sales, DTC | $62,000 | Demand forecast for the month |
| Planned sales, wholesale | $28,000 | Confirmed pre-books plus a reorder estimate |
| Planned sales, retail EDI | $35,000 | Retailer forecast share, cross-checked against last 12 weeks of POs |
| Total planned sales | $125,000 | |
| Planned markdowns | $6,000 | End-of-season colorway being cleared |
| Planned end-of-month inventory | $150,000 | Six weeks of cover on next month’s forecast |
| Beginning-of-month inventory | $172,000 | Book inventory at cost on day one |
| On order, arriving this month | $67,500 | Open POs with confirmed ship dates landing in the month |
Open-to-buy = 125,000 + 6,000 + 150,000 - 172,000 - 67,500
= 41,500
The brand has $41,500 at cost left to commit to receipts this month.
Where the ending inventory number comes from
Planned end-of-period inventory is the input most teams set by habit. It deserves the most attention because it is the largest positive term and the easiest to inflate.
A common way to set it is weeks of cover: the number of weeks of future demand you want on hand at the end of the period.
Planned ending inventory = Weeks of cover x Average weekly forecast for the next period
6 weeks x $25,000 per week = $150,000
Weeks of cover should be set from supplier lead time and demand variability, and it should never fall below the safety stock each SKU needs; see safety stock basics for that calculation. A category with a reliable 3-week replenishment cycle does not need 10 weeks on hand. A category with a 14-week ocean lead time and a volatile retail account may need more than 6. Setting cover by category, rather than one number for the whole business, is one of the most effective changes you can make to an OTB plan.
Sensitivities
The formula is linear, so every input moves OTB dollar for dollar. The inputs differ in how often they are wrong.
| Change | Effect on OTB | How often it happens |
|---|---|---|
| Sales forecast 10% high ($12,500) | OTB overstated by $12,500 | Every month for some category |
| Ending cover set at 8 weeks instead of 6 | OTB higher by $50,000 | Common when cover is not reviewed by category |
| One PO slips from this month to next ($20,000) | OTB this month higher by $20,000, next month lower by $20,000 | Frequent with overseas suppliers |
| Beginning inventory overstated by 5% ($8,600) | OTB understated by $8,600 | Common when cycle counts lag |
| Markdown plan skipped | OTB understated by $6,000 | Common in the last month of a season |
Two patterns stand out. First, ending cover moves OTB more than anything else, and it is the input with the least scrutiny. Second, PO timing does not change total OTB across a season, but it moves dollars between months. A slipped PO makes this month look underbought and next month look overbought. Teams that react to the first month by placing another PO end up with both receipts landing in the second month.
Keeping OTB current after the plan is set
An OTB plan written at the start of the season is accurate for about as long as the first week of sales. After that, three things change it every day.
- Actual sales replace planned sales. If the category sells 15% ahead of plan for two weeks, the remaining months need a higher sales line and probably more OTB.
- POs change status. A PO placed moves dollars from open-to-buy to on-order. A PO cancelled or short-shipped moves them back.
- Inventory moves between channels. A wholesale order that ships early, or a retail allocation that pulls from DTC stock, changes beginning inventory for the next period.
When the inputs live in separate tools, someone rebuilds the OTB spreadsheet each week from exports: sales from the storefront and EDI, inventory from the warehouse, on-order from the purchasing tool. The rebuild is where the numbers drift, because each export is from a different moment.
Endless keeps on-hand inventory, open purchase orders, and orders from DTC, wholesale, and retail channels on one record. The inputs to the formula above are current when you read them instead of copied once a week, and a PO placed or cancelled changes on-order the moment it happens.
OTB and merchandise financial planning
Open-to-buy is one output of merchandise financial planning (MFP). MFP is the top-down plan for sales, margin, markdowns, and inventory by category and month, usually agreed between merchandising and finance before the season. OTB turns that plan into a buying budget and tracks how much of it is still uncommitted.
Retailers with hundreds of categories run MFP in dedicated planning software. A brand with 10 to 30 categories can run it in a structured spreadsheet as long as the inputs are current. The formula does not change with scale. The difficulty of keeping inputs current does.
A checklist before you trust the number
- Every term is at the same value basis: all cost or all retail.
- Sales plans include every channel that draws on the same stock.
- Ending inventory is set by weeks of cover per category, with the reasoning written down.
- On-order includes only POs with a confirmed arrival in the period.
- Beginning inventory reflects the latest count, not last month’s book value.
- Markdowns planned for the period are included.
- The plan is recalculated at least weekly once the season starts.
One OTB pool or one per channel?
Brands that sell the same products through several channels face a choice the classic retail formula does not address: does each channel get its own open-to-buy, or does the category share one?
A shared pool is right when the channels draw on the same physical stock. Splitting the budget by channel in that case creates false precision, because a unit bought for wholesale can and will be sold DTC if DTC demand shows up first. The sales plan should include every channel, as in the worked example above, and the OTB should be calculated once for the category.
Separate budgets make sense when channels need different stock: retail-ready packaging, retailer-exclusive items, or inventory held at a retailer-specific node. Those units cannot move between channels, so they should be planned separately.
Most brands end up with a mix: a shared pool for the core range and separate lines for channel-specific SKUs. The mistake to avoid is running separate budgets out of habit for stock that is in fact shared. It lets each channel plan its own safety buffer, and the category ends up carrying all of them.
Units or dollars?
Retail OTB is traditionally a money plan. For a brand buying from its own factories, units often matter more, because suppliers quote by the unit, enforce minimum order quantities, and ship in case packs.
A practical approach is to plan OTB in dollars at the category level, where finance sets the budget, and convert to units at the SKU level, where purchasing places orders. The conversion has to respect three constraints the dollar plan ignores:
- Minimum order quantities. A $4,000 OTB for a SKU with a $9,000 minimum is either a skipped buy or an overbuy. Decide which in advance.
- Case packs. Units round up to full cases, which pushes spend slightly over the dollar plan.
- Landed cost. Plan with landed cost per unit, including freight and duty, or the dollar plan will be overspent by the freight bill.
When the unit plan and the dollar plan disagree, the dollar plan usually wins at the category level, and the difference gets resolved by moving budget between SKUs within it.
Questions buyers ask
What is the open-to-buy formula?
Open-to-buy equals planned sales plus planned markdowns plus planned end-of-period inventory, minus beginning-of-period inventory, minus inventory on order for the period. The result is the amount you can still commit to new receipts in that period.
Should open-to-buy be calculated at cost or at retail?
Either works if every term uses the same basis. Retailers often plan at retail. Brands that manufacture or import usually plan at cost, because cost is what they pay suppliers.
How often should open-to-buy be updated?
At least weekly during a season. Sales, purchase order status, and inventory change daily, and a plan built from monthly exports will overstate or understate the budget by the time it is used.
What is the difference between open-to-buy and merchandise financial planning?
Merchandise financial planning sets the season’s targets for sales, margin, markdowns, and inventory by category and month. Open-to-buy converts those targets into the budget still available for purchases, after accounting for stock on hand and on order.
Commerce is chaos.
Tame your tech stack with one system that brings it all together—and actually works.
Get a DemoInsights to master the chaos of commerce
Stay ahead with expert tips, industry trends, and actionable insights delivered straight to your inbox. Subscribe to the Endless Commerce newsletter today.