Skip to content

Open-to-Buy Inventory Calculator

See how much more inventory you can buy for the month after accounting for sales, markdowns, stock on hand, and deliveries already on order.

Your inputs

View results

Enter the selling-price value of stock on hand at the start of the month.

Value the stock you want at month-end at its expected selling prices then.

Use expected merchandise sales after discounts and returns, excluding tax and shipping.

Enter how much planned price reductions will lower inventory’s retail value during the month.

Enter the selling-price value of units already ordered for delivery during the month.

Enter the share of ticket price left after landed merchandise cost on new purchases.

Example results

Remaining open-to-buy at retail
$18,000

The retail value of additional receipts the plan allows. A negative result shows how far inventory and commitments exceed the plan.

Estimated buying budget at cost
$8,100

The estimated landed cost of any remaining buying room, based on your planned initial margin.

Planned receipt requirement
$50,000

The total retail value of receipts the plan calls for before subtracting open purchase orders.

Projected ending stock at retail
$22,000

The projected month-end balance if you place no new orders. A negative balance indicates a shortage.

You have room for more receipts in this month’s plan. Compare the estimated cost with vendor quotes and available cash.

Use one delivery month, product group, and set of locations. Enter inventory and receipts at planned selling prices in USD. The initial margin converts remaining retail dollars to estimated landed cost.

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

  1. Planned receipts at retail = planned net sales + planned markdowns + target ending inventory − beginning inventory.
  2. Remaining open-to-buy at retail = planned receipts at retail − committed receipts due in the period.
  3. 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.
  4. 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.