Open-to-Buy (OTB): Concept, Planning & Calculations
1. What is Open-to-Buy (OTB)?
Open-to-Buy (OTB) is a vital financial and inventory control tool utilized by retail merchandise buyers. It specifies the precise currency amount of uncommitted funds available to purchase additional merchandise for delivery within a given budgetary period (typically a month or season).
Think of OTB as a retailer’s dynamic inventory checkbook:
- If customer demand surges and sales exceed forecasts, OTB expands, allowing buyers to order replenishment stock.
- If sales lag behind projections, OTB contracts, preventing buyers from placing unnecessary purchase orders that would lead to bloated inventories and forced clearance markdowns.
2. Importance & Objectives of OTB Planning
3. Core Terminology in the OTB Framework
Before performing mathematical calculations, five key components of the retail merchandising budget must be understood:
- Planned Sales: The projected revenue the department or store anticipates generating during the target month based on historical data and market trends.
- Planned Reductions: Anticipated revenue erosions, comprising three elements:
- Markdowns: Planned promotional price reductions to clear seasonal or slower-moving stock.
- Employee Discounts: Discounts granted to store staff on personal purchases.
- Inventory Shrinkage: Losses arising from shoplifting, internal employee pilferage, administrative errors, and physical transit damage.
- Beginning of Month (BOM) Stock: The physical inventory valuation present on the retail sales floor and backroom at the start of the first day of the month.
- End of Month (EOM) Stock: The targeted inventory required at the close of the final day of the month to sustain smooth trading for the following month. (Note: EOM of October is identical to BOM of November).
- On-Order Merchandise: Inventory purchase orders already placed with suppliers that have not yet arrived at the retail distribution center.
4. Fundamental OTB Formulas
5. Comprehensive Worked Numerical Problem
Problem Statement (DAVV Exam Style):
The menswear department of a department store presents the following financial estimates for the month of October:
- Planned Sales for October: ₹ 8,00,000
- Planned Markdowns and Reductions: ₹ 60,000
- Planned EOM Stock (October 31): ₹ 12,00,000
- Planned BOM Stock (October 1): ₹ 10,50,000
- Merchandise already on order for October delivery: ₹ 4,20,000
- Planned Markup on Retail: 40%
Calculate:
- Planned Purchases at Retail.
- Open-to-Buy (OTB) at Retail.
- Open-to-Buy (OTB) at Cost.
Step-by-Step Solution:
Interpretation: The department buyer has ₹ 5,90,000 of retail merchandise value (or ₹ 3,54,000 in wholesale cost terms) available to issue new supplier purchase orders for October delivery.
6. Managing Inventory Variances: Overbought vs Underbought
In dynamic retail operations, actual sales rarely match projections with 100% precision:
| Operational Condition | Cause & Symptoms | Strategic Corrective Action |
|---|---|---|
| Overbought Situation (Negative OTB) |
• Sales fell short of forecasts. • Planned purchases were exceeded or stock was over-ordered. • Store is congested with unsold goods. |
1. Cancel unconfirmed outstanding purchase orders. 2. Negotiate delayed delivery with vendors. 3. Take immediate strategic markdowns to stimulate turnover. 4. Transfer excess inventory to other branches. |
| Underbought Situation (Positive High OTB) |
• Sales surged well beyond forecast. • Stock levels depleted faster than expected. • Risk of empty shelves and lost revenue. |
1. Expedite repeat reorders with primary vendors. 2. Secure quick delivery from localized secondary suppliers. 3. Procure off-price opportunistic clearance job-lots. |
Summary Keypoints for DAVV Exams
- Definition: OTB is the net financial allowance remaining for inventory purchases during a specific period.
- Master Formula: Planned Purchases = Planned Sales + Planned Reductions + Planned EOM - Planned BOM.
- Net OTB: OTB = Planned Purchases - Outstanding Orders.
- Conversion to Cost: Multiply Retail OTB by
(1 - Markup %)to obtain the wholesale purchase budget. - Correction Measures: Overbought conditions demand cancellations, transfers, and markdowns; underbought conditions require expedited replenishment.
Frequently Asked Questions (DAVV Exam Pattern)
Q1. Define Open-to-Buy. Why is it referred to as a “retail checkbook”?
Answer: Open-to-Buy (OTB) is the calculated amount of money a retail buyer has available to purchase inventory for a future time frame. Just as a personal bank checkbook prevents an individual from writing checks beyond their bank balance, an OTB plan prevents a retail department buyer from ordering more inventory than what can be profitably absorbed and sold by the store. It provides a financial ceiling that protects working capital liquidity.
Q2. What happens if a buyer operates with a negative OTB? How can it be rectified?
Answer: A negative OTB indicates that the department is in an overbought status—the sum of current inventory and existing on-order commitments exceeds the planned requirements for sales and end-of-period stock. If uncorrected, this causes severe liquidity crunches, cramped storage, and steep terminal markdowns.
To rectify negative OTB, buyers must:
- Contact suppliers immediately to cancel backorders or push shipment dates to subsequent months.
- Implement promotional sales and flash discounts to convert existing stock into cash.
- Shift excess merchandise to higher-performing regional stores within the retail chain.