Retail Open-to-Buy

A merchandising purchase budget KPI. Distinct from stock-to-sales (coverage ratio) and GMROI (productivity).

OTB = planned sales + planned ending inventory − BOM − on-order.

Tip: Keep “Planned Sales” and “Planned Ending Inventory” on the same basis (period, units, and population) before calculating Retail Open-to-Buy.

Cluster: Retail hub · ATV · Logistics fill rate · Logistics return rate · Percentage guide

Open-to-buy (OTB) estimates how much additional inventory you can purchase for a period.

Enter planned sales, planned ending inventory, beginning inventory, and on-order for the same plan.

$
Planned sales for the period
$
Planned EOM inventory
$
BOM / beginning inventory
$
Inventory already on order

Open-to-Buy

Understanding Retail Open-to-Buy

How we calculate. OTB = planned sales + planned ending inventory − BOM − on-order. The form uses the same arithmetic as the worked examples on this page. See our methodology and accuracy policy.

Real-world scenario: A typical Retail Open-to-Buy case uses planned sales 80000 and planned ending inventory 40000. Enter the same figures below to reproduce the worked path.

What is Retail Open-to-Buy?

A merchandising purchase budget KPI. Distinct from stock-to-sales (coverage ratio) and GMROI (productivity).

  • Same dollar basis (retail or cost—label it)
  • On-order = already committed receipts
  • Negative OTB = overbought vs plan

The Formula

Retail Open-to-Buy
OTB = Planned sales + Planned EOM − Beginning inventory − On-order

Worked Example

Scenario: Planned sales $80,000; planned EOM $40,000; beginning $50,000; on-order $10,000.
Step 1: 80000 + 40000 − 50000 − 10000 = 60000
Answer: Open-to-buy is $60,000.

Common Use Cases

  • Monthly OTB: buy budget
  • Category plans: remaining buy
  • Receipt pacing: on-order impact

Pro Tips

  • Freeze retail vs cost method
  • Update on-order often
  • Pair with weeks of supply

Limitations: Retail Open-to-Buy results are educational retail merchandising aids—not accounting, tax, or inventory-system advice. Confirm definitions with your POS, ERP, and brand reporting standards.

FAQ

Same as stock-to-sales?

No. Stock-to-sales is inventory÷sales. OTB is a purchase budget: planned sales + EOM − beginning − on-order.

Can OTB be negative?

Yes. Negative OTB means inventory and on-order already exceed the plan—pause buys or revise the plan.

Authoritative References

For retail merchandising and store performance concepts, consult: