State of Apparel Merchandising Planning 2026

Overview

The apparel merchandising planning function is in a structural transition. After a decade of incremental spreadsheet sophistication — more complex workbooks, more tabs, more cross-file formulas — mid-market brands are encountering the ceiling of what disconnected tools can support.

This analysis examines the current state of apparel merchandising planning at brands in the $10M–$200M revenue range: the tools in use, where planning workflows break down, the cost of those breakdowns, and what distinguishes high-performing planning operations from the rest.

---

The Prevailing Planning Stack

For most mid-market apparel brands, the planning stack looks roughly like this:

OTB: A department-level spreadsheet managed by the planning team, updated manually as purchase orders are placed. The OTB file is typically separate from both the assortment plan and the buy plan.

Assortment plan: A style-level spreadsheet that exists at the category or department level. In most cases, this is the "planning file" that gets passed between planners and buyers during pre-season reviews.

Buy plan: A separate spreadsheet — sometimes an extension of the assortment plan, sometimes maintained by the buying team — that tracks style-level quantities by size, color, and vendor.

Allocation: Either a separate spreadsheet, a module inside an ERP system, or managed manually at the time of receipt.

The problem is not that any one of these tools is inadequate in isolation. The problem is the connection between them. When the assortment plan changes, the OTB file doesn't update automatically. When the buy quantities change, the allocation plan doesn't see it. The reconciliation required to keep these files aligned is the primary source of planning team overhead.

---

Where Planning Breaks Down

Industry patterns consistently reveal four recurring failure modes in spreadsheet-based apparel planning:

1. Pre-season reconciliation consumes the highest-value planning time

The weeks immediately before line review are when planning decisions have the most leverage — carry-over criteria, depth targets, newness ratios, and channel splits are all in motion. These same weeks are when planning teams are most consumed by file reconciliation: checking OTB against assortment quantities, updating the buy plan with revised depths, and re-reconciling the OTB after each revision.

Estimates from planning practitioners suggest 25–35% of pre-season planning bandwidth is consumed by reconciliation activity rather than analytical decision-making. At a three-person planning team, that is the equivalent of one full-time planner doing nothing but keeping files in sync.

2. In-season signals arrive too late to act on

Sell-through data in spreadsheet-based environments is typically delivered as a weekly export from the POS or e-commerce platform. The export is cleaned, reformatted, and entered into the tracking file — a process that introduces a 3–7 day lag between event and visibility.

A style that starts underperforming against sell-through targets in Week 2 of its selling window may not trigger a reallocation or markdown decision until Week 4. In a 12-week selling season, losing two weeks of decision window on underperforming styles has material markdown implications.

3. Size curve decisions are made from incomplete data

Size curves — the percentage of total units bought in each size — are among the most consequential decisions in the buy. A correctly sized buy converts at higher sell-through rates than a buy with the same total units but wrong size distribution.

In spreadsheet environments, size curves are typically maintained as a separate reference tab, updated once per season if at all. The result: buyers apply the same size distribution to new introductions that worked for last year's carry-overs, without systematic analysis of where the size distribution was profitable versus where it produced stockouts and markdowns.

4. Carry-over decisions lack systematic criteria

The decision to carry a style from one season to the next is made in most planning environments by reviewing prior-season sell-through informally — "that style did well" or "we had returns on that one." Systematic criteria (minimum STR%, margin contribution, size availability, vendor continuity) are less commonly applied.

The cost of poor carry-over decisions compounds: a carry-over style that was borderline on prior-season performance brings forward inventory risk and markdown exposure while occupying OTB budget that could have funded a new introduction.

---

What High-Performing Planning Operations Do Differently

Analysis of apparel brands that have moved beyond spreadsheet-only planning reveals consistent operational differences:

They set structural constraints before style selection. High-performing teams establish style count targets, newness ratios, and depth-per-style averages before the assortment review begins — not after. This means the financial implications of assortment decisions are visible before they're locked.

They build size curves from their own sell-through data. Rather than applying category averages or prior-season buying patterns as size curves, high-performing buyers analyze sold % by size (not bought %) and apply that as the forward distribution. This shift alone — from "what we bought" to "what sold" as the size curve basis — consistently produces higher sell-through rates.

They maintain a single planning model. Whether through a connected platform or disciplined spreadsheet architecture, high-performing teams maintain one plan. The OTB, assortment, and buy quantities live in the same model — not linked files that need to be reconciled.

They have in-season visibility within 48 hours of data availability. Rather than a weekly reporting cycle, high-performing teams have sell-through data available as it comes in and review it against plan frequently enough to act within the selling window.

---

The Scale Threshold

One consistent finding is that the pain of disconnected planning tools is non-linear with scale. Brands in the 50–150 SKU range can often manage the reconciliation overhead with discipline. Above 200–250 active SKUs, the reconciliation burden begins to exceed what the planning team can absorb alongside analytical work.

The primary trigger for platform adoption is not a single planning failure — it is the accumulation of small reconciliation errors, missed in-season signals, and pre-buy deadline pressure until the team can no longer absorb the overhead.

The secondary trigger is team growth. When a two-person planning team becomes three, the coordination cost of shared spreadsheets — version control, simultaneous editing, file ownership — begins to exceed the cost of a connected system.

---

The Market Gap

Enterprise merchandising planning platforms — the tools purpose-built for planning at scale — require 12–24 months of implementation time and total cost structures that put them out of reach for mid-market brands. ERP allocation modules are available but rarely address pre-season assortment and OTB planning. PLM platforms address product development, not planning.

The gap between "sophisticated spreadsheets" and "enterprise planning platform" is where purpose-built mid-market tools compete. The defining characteristics of tools that successfully serve this market:

• →Apparel-native structure (seasonal OTB, size curves, carry-over logic built in, not configured)
• →Implementation in weeks, not months
• →Designed for a 2–5 person planning team, not an IT-administered enterprise deployment
• →Connected OTB, assortment, and buy planning in one workflow