OTB Planning Benchmarks for Mid-Market Apparel Brands

Overview

Open-to-buy (OTB) is the financial framework that governs every apparel buying decision — the authorized budget available to commit against a future season. Despite its centrality to the planning process, OTB management at mid-market apparel brands remains largely undocumented. Enterprise retailers publish planning benchmarks through industry bodies; mid-market brands operate without comparable reference data.

This analysis draws on planning workflows, process reviews, and operational patterns from mid-market apparel brands in the $10M–$200M revenue range to establish benchmarks across four dimensions: planning cycle length, OTB revision frequency, budget accuracy, and the process characteristics that predict planning performance.

---

What Is Open-to-Buy, and Why It's Hard to Get Right

Open-to-buy is the difference between the merchandise a business needs (planned sales + planned ending inventory) and what it already has or has committed to receive (beginning inventory + on-order receipts). Expressed simply:

OTB = Planned Sales + Planned EOP Inventory − Beginning Inventory − On-Order Receipts

The calculation is simple. The execution is not.

OTB accuracy depends on the quality of four inputs: planned sales (a forecast), planned ending inventory (a strategic target), beginning inventory (an ERP actuals figure), and on-order receipts (a purchasing commitment register). In spreadsheet-based planning environments, these four inputs typically live in different places — sales forecasts in one file, inventory actuals exported from ERP, purchase orders in a separate tracker. The act of assembling and reconciling these inputs introduces errors before any planning decision is made.

The brands that manage OTB most accurately are not necessarily better forecasters. They are better at maintaining a single, current source of truth for all four inputs.

---

Benchmark 1: Planning Cycle Length

What we measured: The number of weeks between the start of the OTB planning process and the first committed purchase order for the season.

Findings:

• →Brands that begin OTB planning 20+ weeks before season start report meaningfully lower markdown rates on full-price merchandise than brands that begin 12 weeks or fewer before season start.
• →The benefit is not primarily from better forecasts — long-lead planning teams do not forecast sales materially more accurately. The benefit comes from having more decision time: more opportunity to analyze carry-over candidates, negotiate vendor terms, and make assortment adjustments before commitments are locked.
• →Short-lead planning (fewer than 12 weeks) is most common among brands that have not separated the OTB process from the buying execution process. When planners and buyers share the same workflow in the same spreadsheet, the planning cycle is compressed to match the buying timeline.

Benchmark target: Begin OTB planning 18–22 weeks before the first receipt date for the season.

---

Benchmark 2: OTB Revision Frequency

What we measured: The number of times the OTB plan is formally revised after initial setting and before the season close.

Findings:

• →High-performing teams revise OTB 3–5 times per season. The revision cadence is typically: initial plan → pre-buy revision (post-range review) → receipt plan adjustment (mid-season) → reforecast (when sell-through data indicates performance divergence) → close-of-season reconciliation.
• →Teams that revise fewer than twice per season tend to have one of two problems: either the initial plan is being treated as fixed (leading to buying decisions that don't reflect real-time sell-through), or there is no structured review cadence and revisions happen reactively rather than proactively.
• →Teams that revise more than six times per season typically have a data quality problem — the OTB model is being corrected repeatedly because the inputs (opening inventory, committed receipts) are not being maintained accurately between revisions.

Benchmark target: 3–5 structured OTB revisions per season, on a defined calendar cadence rather than ad hoc.

---

Benchmark 3: OTB Budget Accuracy

What we measured: The percentage deviation between initial OTB plan and actual receipts at season end — a measure of how closely the plan was executed.

The problem with this metric: OTB accuracy is frequently misinterpreted. A brand that achieves 98% adherence to its initial OTB plan is not necessarily performing well — it may simply be inflexible. A brand with 85% adherence that made deliberate mid-season adjustments in response to sell-through signals may be outperforming on margin.

What matters is not adherence to the initial plan but the quality of the final plan at the point of commitment — the OTB that governs the actual receipts, not the OTB set at the beginning of the cycle.

Findings:

• →Opening inventory accuracy is the largest single driver of OTB variance. Brands that reconcile beginning inventory against ERP actuals within 48 hours of period start report significantly lower final OTB variance than brands relying on manually maintained inventory estimates.
• →On-order accuracy (keeping committed purchase orders current) is the second driver. Brands maintaining a manual PO tracker separate from their OTB model consistently show higher final variance because the two records drift apart.
• →Sales forecast accuracy is the third driver — and the one most planning teams focus on. The analysis suggests this emphasis is misplaced: improving beginning inventory and on-order accuracy produces larger reductions in OTB variance than improving the sales forecast.

Benchmark target: Final OTB variance (plan vs. actual receipts at season end) below 8% for brands with a dedicated planning function.

---

Benchmark 4: Time Spent on Reconciliation vs. Analysis

What we measured: The proportion of planning team time spent on data reconciliation (assembling, cleaning, and reconciling inputs) versus analytical work (reviewing sell-through, evaluating carry-over candidates, stress-testing scenarios).

Findings:

• →In spreadsheet-based planning environments, the median planning team at a mid-market brand spends 55–65% of planning cycle time on reconciliation tasks: pulling ERP exports, reconciling beginning inventory, updating committed receipt trackers, and resolving discrepancies between files.
• →This ratio inverts in brands that have adopted purpose-built planning tools: reconciliation drops to 15–25% of planning time, with the majority of time available for analytical work.
• →The opportunity cost of high reconciliation time is not just efficiency — it is the analytical work that does not get done. Carry-over analysis, size curve review, and channel-level performance assessment require time that most spreadsheet-based planning teams do not have available.

Benchmark target: Reconciliation should represent no more than 25% of planning cycle time. If it exceeds this threshold, the tooling stack is limiting planning quality.

---

The Structural Ceiling: OTB in Spreadsheets Beyond 3 Users

One of the clearest patterns in mid-market apparel planning is the degradation of OTB accuracy as planning team size grows — specifically when more than three people work on the same spreadsheet-based OTB model.

The failure mode is consistent: version control breaks down, formula integrity degrades, and the "current" version of the OTB model becomes unclear. Brands respond to this by creating hybrid workflows — one person owns the "master" OTB file, others work in separate files and report out. This reduces the collaboration problem but introduces reconciliation overhead and reduces the value of having a team.

The structural ceiling is not a people problem. It is a tooling problem. Purpose-built planning platforms designed for collaborative access — where multiple users work in the same live data model — eliminate this constraint entirely.

---

OTB Process Characteristics of High-Performing Teams

Across planning workflow reviews, the following process characteristics consistently distinguish high-performing OTB teams from average performers:

1. Separated planning and buying roles High-performing teams maintain a clear distinction between the planner (who owns the OTB model and the financial framework) and the buyer (who makes assortment and style selections within that framework). When these roles collapse into a single person or a single undifferentiated process, OTB tends to be treated as a formality rather than a constraint.

2. ERP-connected beginning inventory Top performers pull beginning inventory directly from ERP at the start of each planning period rather than maintaining a manually updated estimate. The accuracy difference between these approaches is significant.

3. Defined revision calendar Top performers set a revision calendar at the start of the planning cycle — specific dates when OTB will be formally reviewed and updated — rather than revising on an ad hoc basis. This gives the buying team predictable "frozen windows" during which commitments can be made with confidence.

4. Connected OTB and assortment model Top performers do not maintain OTB and assortment planning in separate files. When the OTB changes, the assortment depth assumptions update automatically. When a style is added to the assortment, the OTB impact is immediately visible. This connectivity eliminates the reconciliation step between financial planning and style-level buying decisions.

5. Season-over-season comparison Top performers review the current season OTB alongside prior season actuals — not just as a reference point but as a diagnostic: where did we over-buy, where did we under-buy, and what carry-over assumptions drove the largest variances?

---

Common OTB Planning Failures and Their Root Causes

Failure: OTB overrun at receipt Root cause: On-order commitments are not being maintained in the OTB model. Buyers commit to receipts that are not reflected in the current OTB, leading to a cumulative overrun that only becomes visible at receipt.

Failure: OTB appears healthy but sell-through is poor Root cause: Beginning inventory is understated. Old inventory that should be cleared is not being reflected accurately, inflating OTB availability and leading to over-buying on top of existing slow movers.

Failure: Plan-vs-actual variance too high to use for future forecasting Root cause: Revisions are happening too late in the season. The plan is being revised to reflect actuals after the fact, rather than being used to drive forward-looking decisions.

Failure: OTB "disappears" mid-season Root cause: The OTB model is not connected to committed POs. As commitments are placed, they are not reflected in the model, causing OTB to appear available when it has already been committed.

---

Implications for Planning Infrastructure

The benchmarks in this analysis converge on a consistent implication: OTB planning performance at mid-market brands is determined more by the quality of the planning infrastructure — the tooling that assembles and maintains inputs — than by the sophistication of the planning methodology.

Brands running OTB in spreadsheets can implement every process recommendation in this analysis and still face a structural ceiling on accuracy — because the inputs will remain difficult to maintain in sync, the model will remain version-controlled informally, and the reconciliation overhead will continue to consume planning team capacity.

The investment case for purpose-built OTB planning tools at mid-market scale is not about accessing more sophisticated planning methodology. It is about eliminating the structural constraints that limit how well even a skilled planning team can execute the methodology they already have.