← The Journal · Merchandise Planning
The Playbook

The plan says ₹48 crore. The buy is ₹40.43.

Open-to-Buy is where the sales plan meets the stock you already own. The formula, a worked March example, and why buying to the sales plan is how dead stock gets born.

Playbook8 min readAug 2026
Open-to-Buy worked table for a menswear division in March: planned sales +48.00, planned closing stock +80.00, planned markdowns +2.00, opening stock −83.57, on order −6.00, Open-to-Buy ₹40.43 crore
The five lines that turn a sales target into a purchase budget. Worked example on a sample MENS WEAR dataset, at retail value.

The fastest way to overbuy a store is to hand the buyer the sales plan. It sounds almost responsible: the division is planned at ₹48 crore for March, so go buy ₹48 crore of stock. Except the division is not starting March empty. There is ₹83.57 crore of inventory already on the floor at retail value, and another ₹6 crore already ordered and on its way. Buy to the sales plan on top of all that, and the season ends the way seasons like that always end: racks of stock, a clearance calendar, and a finance meeting about working capital. The number that prevents it is Open-to-Buy, and it is the only number in the whole planning cycle a buyer actually spends.

The equation that closes the loop

Open-to-Buy is bookkeeping applied to ambition. It takes the sales plan and asks the accountant's question: given what you want to sell, what you want to be holding at month-end, what you'll give away in markdowns, and everything you already own or have committed to, how much are you actually allowed to add?

Open-to-Buy = Planned Sales + Planned Closing Stock + Planned Markdowns − Opening Stock − On Order, usually at retail value. Each term is a plan or a fact; nothing in it is a guess about demand. The demand lives upstream, in the sales plan.

Walk the worked example in the table. Planned sales, ₹48 crore, comes straight from the reconciled plan. Planned closing stock, ₹80 crore, is the coverage you want standing when April opens, because a store that sells its last unit on March 31 has also ruined its April. Planned markdowns add ₹2 crore, stock that will leave at a lower realized value but leave nonetheless. Then the two subtractions that do the disciplining: ₹83.57 crore already owned, ₹6 crore already on order. What remains is ₹40.43 crore. That is the buy. Not ₹48.

A sales target is an ambition. Open-to-Buy is a permission. The gap between them, here nearly ₹8 crore, is the stock you were about to buy twice.

Why buying to the sales plan breeds dead stock

Every rupee committed above OTB has to go somewhere, and it only has one place to go: inventory the plan never asked for. It shows up first as a fat closing-stock line, then as lagging sell-through, and eventually as the two tails we've written about before: the dead stock that quietly stops selling at full price, and the markdown budget that grows to move it. Remember the best-seller that moved 2,518 units at 44% sell-through? That is what an OTB failure looks like at SKU level: real demand, bought at twice its depth.

The discipline cuts the other way too. When sales run ahead of plan mid-season, OTB opens up, and that surplus is the earliest, cleanest signal to chase: reorder the fast movers while the season can still absorb them. OTB is not a brake. It is a throttle that works in both directions, provided someone recalculates it monthly instead of filing it in the season binder.

Where the division's number comes from

One level up, the same reconciliation happens between the organization and its divisions, and it is worth seeing because it is where planning either becomes one conversation or twelve arguments.

Top-down versus bottom-up reconciliation table: an organization total of ₹250 crore split across five divisions, with menswear reconciled at ₹48 crore and two divisions flagged for review at plus 2% and minus 3% gaps
₹250 crore committed top-down, checked against each division's bottom-up build. Two divisions carry review flags; the gaps are the agenda.

Leadership commits one number for March, ₹250 crore in the sample. The system splits it across divisions by forecast weight, then checks every slice against the division's own bottom-up build, the one assembled factor by factor. Menswear reconciles cleanly: ₹48 crore top-down, ₹48 crore bottom-up. Two divisions don't, at +2% and −3%, and they get flagged. The gap is not an error. The gap is the agenda. A two-line disagreement, surfaced before the buy, is a conversation; discovered in June, it is an excuse.

Interactive allocation panel: a slider sets the menswear division's budget while four other divisions auto-rebalance proportionally, the organization total stays locked at ₹250 crore, and Open-to-Buy re-derives live
Move one division and the rest rebalance proportionally; the total stays pinned at ₹250 crore and OTB re-derives live.

One lever, everything re-derives

The last piece is what makes the whole structure worth building. When leadership moves a division's allocation, up for a festival quarter, down to protect cash, that decision cannot stop at the headline. In the sample panel, dragging menswear up draws the difference proportionally from the other divisions, the organization total stays pinned at ₹250 crore, and the division's Open-to-Buy re-derives on the spot, because the ₹7.57 crore of net inventory commitments doesn't move just because the ambition did.

That is the property to demand of any planning process, tooled or not: adjust once, reconcile everywhere. Sales plan, stock plan, markdown plan and buying budget are one system of equations, and the moment they are maintained as four separate spreadsheets, they will disagree, silently, in whichever cell costs the most.

The monthly cycle, then, in one line each: the plan sets the number and its reasons. The model layer sharpens it and prices its risk. Open-to-Buy converts it into the only number that spends money. And next month's actuals restart the loop, a little wiser.

A note on the numbers. The figures in this piece are a worked example on a representative sample dataset, not client data. Closing-stock, markdown and on-order values are sample stand-ins; the equation is the product, and your data produces your numbers.

A sales target is an ambition. Open-to-Buy is a permission.

Buyers do not overbuy because they are reckless. They overbuy because the sales plan is the loudest number in the room and the inventory already owned is the quietest. Open-to-Buy exists to make them the same volume: one line that has already heard the sales plan, counted the warehouse, remembered the purchase orders, and only then says what the till can take. ₹48 crore is the story. ₹40.43 crore is the cheque. Sign the second one.

What is Open-to-Buy?

The amount a buyer may still purchase in a period once existing commitments are counted: the sales plan reconciled with the inventory already owned and already ordered. It is the purchase budget the sales plan implies, and it is almost always smaller than the sales plan itself.

How do you calculate Open-to-Buy?

OTB = Planned Sales + Planned Closing Stock + Planned Markdowns − Opening Stock − On Order, usually at retail value. In the worked example: 48 + 80 + 2 − 83.57 − 6 = ₹40.43 crore.

What happens if you buy more than OTB?

Every rupee above OTB arrives as inventory the plan never asked for. It lands as rising closing stock, then slow sell-through, then markdowns or dead stock. Habitual overbuying against OTB is how working capital becomes a clearance rack.

How often should OTB be reviewed?

Monthly as a cycle, re-forecast in-season as actuals arrive. When sales beat plan, OTB opens room to chase demand; when they lag, it tightens before excess stock is committed. Reviewed only at season end, it protects nothing.

About Retalp

Embedded AI agents for retail operations.

Retalp builds AI agents that run real supply-chain and retail workflows (demand forecasting, replenishment, allocation and inventory health) on top of the systems you already use. The Journal is where we write about the operational problems underneath the software. The figures in this piece are from our Merchandise Financial Planning walkthrough, where the plan becomes the buy.

Know what you may actually spend.

Your divisions, your inventory, your commitments: the plan reconciled down to a live Open-to-Buy. Book a walkthrough.