Why use this calculator?
A strong sales forecast can make a new buy look sensible until you account for the stock already on hand and the orders due to arrive. Open-to-buy measures how much room you still have for new receipts within a category and period. It gives you a way to assess a supplier offer, a repeat order, or a seasonal buy before committing cash.
Run the numbers separately for delivery months when you buy apparel, footwear, or other seasonal products. A September shortage may call for an earlier delivery, while a full October plan may leave little room for the same shipment. Review the budget alongside demand by SKU and store so that money goes toward the products and locations where it can support sales.
How this calculator works
Start with one category, one set of stores or channels, and one delivery month. Value opening inventory, ending inventory, and committed receipts at their planned selling prices. Use net merchandise sales at the prices shoppers are expected to pay. Add markdowns that reduce inventory value during the period and assign outstanding purchase orders to their expected delivery month. Oracle’s retail merchandise planning guide
- Planned receipts at retail = planned net sales + planned markdowns + target ending inventory − beginning inventory.
- Remaining open-to-buy at retail = planned receipts at retail − committed receipts due in the period.
- Estimated buying budget at cost = positive remaining open-to-buy × (1 − planned initial margin as a decimal). The buying budget is zero when the retail result is zero or negative.
- Projected ending stock at retail = beginning inventory + committed receipts − planned net sales − planned markdowns.
Worked example. A footwear retailer starts the month with $45,000 in running shoes at retail. It plans $52,000 in sales, $3,000 in markdowns, and $40,000 in ending inventory. The plan calls for $50,000 in receipts. With $32,000 at retail already on order for that month, it has $18,000 in open-to-buy at retail. A planned initial margin of 55% puts the estimated landed cost at $8,100. If it places no new orders, its projected ending stock is $22,000 at retail.
Who this calculator is for
Retail buyers and merchandise planners can use it to budget by category, brand, or delivery month. A footwear buyer can check a proposed running shoe order against the monthly budget, then review the assortment by size, how long it takes to replenish, and which stores need the new stock.
Owners and inventory teams can use it to compare purchase commitments with the category’s sales and stock plans. A multi-location retailer can start with a combined budget for a group of stores and then check demand at each location before assigning orders or transferring stock. Guide to planning how much inventory to buy
Frequently asked questions
What is open-to-buy in retail?
Open-to-buy is the value of merchandise you can still commit to for a planning period. It accounts for what you expect to sell and mark down, the inventory you want at the end, the stock you start with, and the deliveries you have already committed to receive.
Which purchase orders should I count?
Count the remaining units on confirmed purchase orders due to arrive within the period you are planning. When a shipment is split across two months, assign each part to its expected receipt month. A purchase order placed in May with delivery in July belongs in the July plan.
How do I update the plan partway through the month?
Use your current on-hand inventory and forecasts for the remaining days of the month. Include only the receipts that are still due before month-end. A delivery already reflected in on-hand inventory has already been counted.
How should I account for markdowns?
Use the planned reduction in inventory’s retail value during your planning period. For a unit valued at $100 at the start of the period that drops to $80 and sells, record $20 in markdowns and $80 in sales. If the unit was already valued at $80 at the start, the earlier $20 reduction has already been counted.
Should I enter inventory and purchase orders at cost or retail?
Use planned selling prices for the inventory and receipts fields. For a confirmed order of 100 units ticketed at $80 each, enter $8,000 in committed receipts. The calculator uses the planned initial margin to estimate the landed cost of additional purchases separately.
What does negative open-to-buy mean?
Your opening stock and scheduled receipts exceed the amount needed for the month’s planned sales, markdowns, and ending inventory. Review which orders can move to a later month, and check which specific products still need support. An overall surplus can still include shortages in key sizes or locations.
How do I calculate planned initial margin?
Divide the planned ticket price minus landed product cost by the ticket price and multiply by 100. A product ticketed at $100 with a landed cost of $45 has a 55% initial margin. For a mix of new products, calculate the percentage on total ticket value and total landed cost.
Does a positive result mean I have the cash to buy?
It shows room for receipts in the merchandise plan. Check the at-cost estimate against vendor quotes, minimum orders, deposits, payment dates, and available cash before committing.
What should I use for the ending inventory target?
Start with the stock you expect to need for the next selling period, especially before the following receipts arrive. Consider the products, sizes, and locations you want to keep in stock. Check what seasonal merchandise you would prefer to sell through by month-end.
How do open-to-buy and replenishment quantity work together?
Open-to-buy sets the buying budget for a category and receipt period. The replenishment quantity calculator then helps you estimate how many units of a particular item to order. Use both to check that the order fits the budget and covers demand.
Important retail metrics
Use these metrics to see why the buying budget changed and whether the merchandise plan is still on track.
- Net merchandise sales
-
Merchandise sales after discounts and returns, excluding taxes and shipping.
Compare actual sales with your plan before updating expected receipts.
- Markdown dollars
-
The sum of price reductions that lower the retail value of inventory during the period.
Check how much clearance and other price changes reduce the retail inventory balance.
- Committed receipts
-
The retail value of outstanding units on confirmed orders due in the period.
Track changes to quantities and delivery dates so each receipt is counted in the right month.
- Ending inventory variance
-
Actual or projected ending inventory minus the target ending inventory, at retail.
See where stock may be too high or too low as sales and deliveries change.
- Initial margin rate
-
Planned ticket value minus landed merchandise cost, divided by planned ticket value and multiplied by 100.
Translate remaining retail dollars into an estimate of the cost of new orders.