Retail Open-to-Buy OTB Calculation Formula: 6 Planning Steps to Balance Merchandise Budgets

In retail merchandise accounting and multi-store inventory control, maintaining precise liquidity while avoiding catastrophic stockouts or inventory gluts requires rigorous financial budgeting. In mastering the retail open-to-buy OTB calculation formula, store owners, retail buyers, and inventory controllers deploy a time-tested financial governance framework that dictates exactly how many dollars of inventory can be purchased in any given month without violating working capital limits or destroying gross margins.

Without an active Open-to-Buy (OTB) control system, retail buyers frequently over-order inventory during seasonal transitions, tying up cash flow in slow-moving merchandise that eventually requires aggressive margin-crushing promotional markdowns to clear. Conversely, under-buying starves top-performing product categories of fast-turning inventory, resulting in lost sales and alienated customers. A structured OTB calculation balances planned sales, markdown budgets, beginning-of-month inventory, and ending-of-month stock targets to keep inventory fresh and working capital fluid.

This technical financial guide breaks down the six foundational steps of Open-to-Buy calculations—including retail-to-cost conversion formulas, inventory-to-sales ratio benchmarks, on-order merchandise absorption, markdown reserve allocations, and Till Trainer cashier discount audit controls. Protect your store's cash conversion cycle and GMROI with verified retail financial mathematics.

Key Takeaways & Architectural Comparison

• Core Definition: Open-to-Buy (OTB) represents the net dollar amount of inventory a retail buyer is authorized to purchase for a specific department within a designated calendar month.
• OTB at Retail Master Formula: \(\text{OTB}_{\text{retail}} = \text{Planned Sales} + \text{Planned Markdowns} + \text{Planned EOM} - \text{Planned BOM} - \text{On Order}\).
• Retail-to-Cost Conversion: \(\text{OTB}_{\text{cost}} = \text{OTB}_{\text{retail}} \times (1 - \text{Planned IMU}\%)\), converting retail budget limits into actionable vendor purchasing dollars.
• Over-Bought Risk Management: If calculated OTB produces a negative dollar figure, the department is "Over-Bought," mandating immediate order cancellations, delivery deferrals, or accelerated markdowns.
• Till Trainer Cashier Control: Unbudgeted point-of-sale cashier discounts and unauthorized manual overrides directly erode Planned EOM inventory, artificially inflating apparent shrinkage.

Step 1: Establishing the Planned Sales Forecast and Seasonal Trend Vectors

The foundation of any Open-to-Buy plan is a realistic, data-driven sales forecast. Rather than relying on optimistic revenue targets, inventory controllers construct monthly sales projections based on historical point-of-sale (POS) performance from the corresponding period of the previous fiscal year, adjusted for current macroeconomic trends, category growth rates, and planned promotional events.

Let \(S_{planned}\) represent the planned retail sales volume for the target month. In specialty apparel, footwear, or consumer goods, sales volume exhibits severe seasonal volatility. A ski shop in October plans aggressive inventory intake for high-velocity November and December sales, whereas a garden nursery plans heavy spring intake in March and April.

Historical sales data must be scrubbed of anomalous events—such as one-off institutional bulk purchases, severe weather store closures, or non-recurring clearance events. If last year's October sales were $180,000 and the category is trending at +8% year-to-date, the baseline planned sales forecast is established at \(S_{planned} = \$180,000 \times 1.08 = \$194,400\).

Step 2: Budgeting Planned Markdowns and Promotional Reductions

The second critical component of OTB is Planned Markdowns (\(MD_{planned}\)). Many amateur retailers fail to account for markdowns in their purchasing budgets, assuming every item purchased will sell at full Initial Markup (IMU) retail price. In reality, retail merchandise inevitably encounters promotional discounts, end-of-season clearance cuts, employee discounts, and damaged goods write-downs.

Because markdowns reduce the total retail value of inventory on hand without generating corresponding cash sales, they create an "inventory void" that must be accounted for in replenishment budgets. If an item priced at $100 is marked down to $70, $30 of retail value has evaporated from store inventory.

Markdowns are typically budgeted as an explicit percentage of planned sales based on historical category performance. If historical seasonal markdowns run at 12% of sales in a fashion department projecting $194,400 in revenue, the planned markdown reserve is calculated as \(MD_{planned} = \$194,400 \times 0.12 = \$23,328\). Budgeting markdowns ensures that inventory intake covers both sold goods and promotional price reductions.

By balancing demand variables against existing inventory and open orders, the master OTB calculation prevents capital over-extension while ensuring stock intake matches November sales velocity.

Step 3: Calculating Beginning-of-Month (BOM) and Target End-of-Month (EOM) Inventory

To calculate OTB, inventory controllers must define the starting inventory available at the beginning of the month (BOM) and the desired buffer inventory required at the end of the month (EOM) to support subsequent sales.

BOM inventory is an absolute physical number: it represents the actual retail value of merchandise physically present in the store on the first calendar day of the month, verified through physical inventory counts or perpetual POS stock records. In our working example, assume BOM inventory on October 1st is recorded at $420,000 at retail.

Target EOM inventory is calculated using the Stock-to-Sales (STS) ratio. The STS ratio defines how many dollars of inventory must be maintained in stock to generate one dollar of sales in the following month: \(\text{STS} = \text{BOM Stock} / \text{Monthly Sales}\). If November sales are projected at $240,000 and the target STS ratio for November is 2.2:1, the required EOM inventory for October (which becomes the BOM inventory for November) is calculated as \(\text{EOM}_{planned} = \$240,000 \times 2.2 = \$528,000\).

Mathematical Worked Example: Calculating Monthly Retail Open-to-Buy

To calculate the actionable purchasing budget at retail and cost for a specialty retail department:

Step 1: Establish Financial Inputs
- Planned October Sales (\(S_{\text{planned}}\)): $194,400.00
- Planned October Markdowns (\(MD_{\text{planned}}\)): $23,328.00
- Target Planned EOM Stock (\(\text{EOM}_{\text{planned}}\)): $528,000.00
- Actual BOM Stock on Hand (\(\text{BOM}_{\text{actual}}\)): $420,000.00
- Outstanding On-Order Merchandise (\(OO\)): $65,000.00
- Department Planned Initial Markup (IMU%): 52.0%

Step 2: Calculate Open-to-Buy at Retail
\[ \text{OTB}_{\text{retail}} = S_{\text{planned}} + MD_{\text{planned}} + \text{EOM}_{\text{planned}} - \text{BOM}_{\text{actual}} - OO \] \[ \text{OTB}_{\text{retail}} = 194,400 + 23,328 + 528,000 - 420,000 - 65,000 = \mathbf{\$260,728.00} \]

Step 3: Convert OTB at Retail to Purchasing Dollars at Cost
\[ \text{OTB}_{\text{cost}} = \text{OTB}_{\text{retail}} \times (1 - \text{IMU}\%) \] \[ \text{OTB}_{\text{cost}} = \$260,728.00 \times (1 - 0.52) = \$260,728.00 \times 0.48 = \mathbf{\$125,149.44} \] The buyer is authorized to spend exactly $125,149.44 on wholesale merchandise orders for October delivery.

Step 4: Tracking Outstanding Purchase Orders and Merchandise On-Order

Merchandise On-Order (\(OO\)) encompasses all committed, open purchase orders that have been placed with manufacturers or wholesalers but have not yet been received and checked into the store's warehouse or stockroom during the target month.

On-Order commitments represent pre-allocated capital. If a buyer has already issued purchase orders for $65,000 worth of winter outerwear scheduled for delivery between October 10th and October 25th, those goods will arrive and absorb budget capacity during October.

Failing to track On-Order commitments leads directly to over-buying. If a buyer calculates an apparent OTB surplus of $80,000 but forgets that $65,000 of purchase orders are already in transit, ordering another $80,000 of goods will flood the stockroom with $145,000 of inventory, creating cash flow crises and unbudgeted warehouse storage costs.

Step 5: Executing the Master OTB Calculation and Retail-to-Cost Conversion

With all five variables established, the inventory controller executes the master Open-to-Buy formula at retail: \[ \text{OTB}_{retail} = S_{planned} + MD_{planned} + \text{EOM}_{planned} - \text{BOM}_{actual} - OO \] Applying our working financial figures: \[ \text{OTB}_{retail} = \$194,400 + \$23,328 + \$528,000 - \$420,000 - \$65,000 = \$260,728 \] This reveals that the buyer is authorized to intake $260,728 worth of inventory at retail value during October to hit the November stock targets.

However, purchase orders placed with wholesale vendors are negotiated at cost, not retail. To convert OTB at retail into an actionable purchasing budget, the buyer applies the department's Planned Initial Markup Percentage (IMU%): \[ \text{OTB}_{cost} = \text{OTB}_{retail} \times (1 - \text{IMU}\%) \] If the department operates at an average IMU of 52% (keystone markup plus 2%), the cost multiplier is \((1 - 0.52) = 0.48\). The actionable wholesale purchasing budget is calculated as \(\text{OTB}_{cost} = \$260,728 \times 0.48 = \$125,149.44\). The buyer can spend exactly $125,149 on new wholesale inventory orders.

Step 6: Managing Over-Bought Penalties, Markdown Timing, and Till Trainer Audit Controls

When actual BOM inventory is excessively high or sales trend below forecast, the calculated OTB can result in a negative number. This condition is known in retail management as being "Over-Bought." An Over-Bought status indicates that the store already owns more inventory than its sales velocity can support, freezing all new open-market purchase orders.

To resolve an Over-Bought condition, inventory controllers deploy three tactical remediations: (1) Vendor Cancellations and Deferrals: Cancel past-due purchase orders or negotiate push-outs of delivery dates to subsequent months; (2) Aggressive Mid-Season Markdowns: Accelerate promotional markdowns on aged, slow-turning SKUs to liquidate dead stock into cash; (3) Re-allocating Open Budget: Shift surplus inventory dollars between thriving and lagging departments.

Furthermore, inventory controllers must enforce strict point-of-sale discount governance. At the cash register, unauthorized manual discounts, excessive "friends and family" overrides, or unrecorded promotional promotions directly erode EOM retail inventory without appearing in planned markdown ledgers. In retail operations utilizing cashier gamification platforms like Till Trainer, cashiers are trained on POS discount compliance, ensuring that every markdown is accurately categorized, eliminating phantom inventory shrink, and protecting department GMROI.

Frequently Asked Questions

What does it mean when Open-to-Buy (OTB) is negative?

A negative OTB figure indicates that the department is "Over-Bought"—meaning current inventory on hand plus outstanding on-order purchase orders exceed planned sales and target stock requirements. Buyers must halt new purchasing until inventory normalizes.

How does Initial Markup (IMU%) affect the OTB budget?

OTB is initially calculated at retail value. Applying the formula \(\text{OTB}_{\text{cost}} = \text{OTB}_{\text{retail}} \times (1 - \text{IMU}\%)\) converts the retail budget into the actual wholesale dollar amount authorized for vendor purchase orders.

How does Till Trainer help protect retail inventory budgets?

Till Trainer trains cashiers on POS discount compliance, ensuring that every promotional discount or manual override is properly recorded in POS ledgers, preventing unbudgeted inventory shrinkage and protecting gross margin return on investment (GMROI).