// Tools

Open-to-buy (OTB) calculator

Open-to-buy is the retail dollars you can still receive in a period without exceeding the plan. It is calculated as planned EOM stock + planned sales + planned markdowns − beginning stock − merchandise on order.

Enter your figures below to see your OTB and whether you are overbought.

Planned sales (retail $)

Planned markdowns / reductions ($)

Planned end-of-month stock ($)

Beginning-of-month stock ($)

Merchandise already on order ($)

Enter the planned figures to see your open-to-buy.

// How it works

01
Enter planned sales and markdowns
The sales and reductions you plan for the period, at retail.
02
Enter planned EOM and BOM stock
Planned end-of-month stock and the beginning-of-month stock you start with.
03
Enter merchandise on order
Anything already committed but not yet received.
04
Read the OTB
OTB = planned EOM + planned sales + planned markdowns − BOM − on order. A negative result means you are overbought.

Recalculating OTB across channels and months in a spreadsheet is where errors creep in. RetailNorthstar reconciles open-to-buy automatically as the plan and receipts change — see more retail tools.

Book a Demo →See it on RetailNorthstar →