01
Separate planned receipts from remaining OTB
Add planned sales, planned markdowns and target ending inventory, then subtract beginning inventory. That is planned receipts. Subtract eligible on-order commitments to calculate remaining open to buy.
InventoryFREE · NO SIGNUP
Open to Buy Calculator
Reconcile planned sales, markdowns and inventory at retail value, then subtract eligible on-order commitments to see the remaining merchandise budget.
FREE TO USEA LOOK ATLAS TOOL
01 USE IT NOW02 NO ACCOUNT03 FIELD NOTES BELOW
WORKING INPUTS
Match the merchandise plan to one period.
LIVE RESULT
Remaining open to buy
$8,350.00Remaining merchandise budget at retail value for the same period, after eligible on-order commitments. This is not bank cash or a purchase instruction.PLANNED RECEIPTS$10,350.00
ELIGIBLE ON ORDER$2,000.00
REMAINING OPEN TO BUY$8,350.00
VALUATION BASISRetail USD · same period
14
PLAN FIRST, COMMITMENTS SECOND
Show the merchandise budget already spoken for.
The receipts plan and remaining open to buy answer different questions. Keeping commitments visible avoids mistaking an already allocated merchandise budget for a new purchase allowance.
WORKING VIEW
$8,350.00ONE PERIOD · RETAIL USD
METHODplanned sales + markdowns + ending inventory − beginning inventory − on order
WORKING NOTE$10,350.00 planned receipts − $2,000.00 on order.
INPUTS → CLEAR OUTPUT
THE FIELD NOTES
Quick answer above. Better decisions below.
Use the result now, then read the practical notes for assumptions, examples, limitations, and the choices behind it.
ONE PERIOD · RETAIL USD$8,350.00
$10,350.00 planned receipts − $2,000.00 on order.
02
Reconcile a retail merchandise plan
With $15,000 planned sales, $350 markdowns, $25,000 ending inventory and $30,000 beginning inventory, planned receipts are $10,350. Subtract $2,000 of eligible open orders to leave $8,350 remaining open to buy.
03
Use retail dollars and count commitments once
Every amount must use the same planning period, assortment and retail USD valuation. Eligible on-order commitments are unreceived orders due during that period; do not include them in beginning inventory and subtract them again.
04
Keep a negative result visible
A negative result means stock or commitments exceed this entered merchandise plan. It is not bank cash, an order quantity or a purchase recommendation. Inputs allow at most two decimals and $1,000,000,000,000 each; derived totals can exceed that cap.
05
Read the plan beside inventory ratios
Use the stock-to-sales ratio calculator to compare inventory with matched-period sales. Use the inventory turnover calculator to examine cost-flow velocity separately; neither ratio replaces the merchandise budget.
THE PRODUCT IS NEXT
Give the planned assortment a campaign-ready image.
Use Look Atlas to create premium ecommerce imagery for the products in your merchandising plan.TRY YOUR FIRST SHOOT FREENO CREDIT CARD REQUIRED
Separate planned receipts from remaining OTB
Add planned sales, planned markdowns and target ending inventory, then subtract beginning inventory. That is planned receipts. Subtract eligible on-order commitments to calculate remaining open to buy.
Reconcile a retail merchandise plan
With $15,000 planned sales, $350 markdowns, $25,000 ending inventory and $30,000 beginning inventory, planned receipts are $10,350. Subtract $2,000 of eligible open orders to leave $8,350 remaining open to buy.
Use retail dollars and count commitments once
Every amount must use the same planning period, assortment and retail USD valuation. Eligible on-order commitments are unreceived orders due during that period; do not include them in beginning inventory and subtract them again.
Keep a negative result visible
A negative result means stock or commitments exceed this entered merchandise plan. It is not bank cash, an order quantity or a purchase recommendation. Inputs allow at most two decimals and $1,000,000,000,000 each; derived totals can exceed that cap.
Read the plan beside inventory ratios
Use the stock-to-sales ratio calculator to compare inventory with matched-period sales. Use the inventory turnover calculator to examine cost-flow velocity separately; neither ratio replaces the merchandise budget.
Questions, answered.
What is the open-to-buy formula?
Planned receipts equal planned sales plus planned markdowns plus target ending inventory minus beginning inventory. Remaining open to buy subtracts eligible on-order commitments from planned receipts.
Can open to buy be negative?
Yes. Negative receipts or remaining open to buy show that the entered stock or commitments exceed this merchandise plan. The calculator preserves that result rather than changing it to zero.
Should I enter inventory at cost or retail?
This calculator uses retail USD for all five inputs. Do not mix purchase cost with retail inventory value, and include only unreceived on-order commitments eligible for the same period.
BUILT BY LOOK ATLAS
Your product deserves more than a marketplace thumbnail.
Turn a simple product photo into polished, campaign-ready creative for your store, ads, and social channels. No studio. No reshoots.
Create your first shoot free, then keep going when you’re ready.
01 PRODUCT PHOTO → CAMPAIGN