Assortment Planning Practices at Mid-Market Apparel Brands
How brands in the $10M–$200M revenue range structure assortment decisions — by category, channel, and season — and where spreadsheet-based assortment planning breaks down as the business grows.
Overview
Assortment planning — the process of determining which products to carry, in what depth, across which channels and time periods — is the core decision-making function of the merchandising team. It is also the area where mid-market apparel brands most frequently operate without structured process, relying instead on buyer intuition, historical precedent, and seasonal spreadsheets that are rebuilt from scratch each planning cycle.
This analysis examines assortment planning practices at mid-market apparel brands, with a focus on how assortment decisions are structured (or not), where the process breaks down as brands scale, and what the operational characteristics of high-performing assortment teams look like.
What Assortment Planning Actually Covers
The term "assortment planning" is used inconsistently in the industry. For the purposes of this analysis, assortment planning refers to the pre-season decisions that establish the structure and composition of the offering:
- Style count targets: How many styles per category, by season and channel?
- Category architecture: What is the balance across core, fashion, and carry-over? What share of OTB goes to each category?
- Depth decisions: How many units per style, and how does that vary by newness vs. carry-over vs. replenishment?
- Carry-over analysis: Which styles from the prior season warrant continued investment, at what revised depth?
- Channel allocation: For multi-channel brands, how is the assortment differentiated across DTC, wholesale, and owned retail?
What assortment planning does not include (for the purposes of this analysis): style-level design decisions (PLM territory), demand forecasting at the SKU level (forecasting tool territory), and purchase order execution (buying execution territory).
The assortment planning process sits between OTB (which establishes the financial envelope) and buying execution (which converts the assortment plan into committed purchase orders). It is the bridge between budget and buy.
How Mid-Market Brands Currently Approach Assortment Planning
The typical process (and its limitations)
At most mid-market brands, the seasonal assortment planning process looks roughly like this:
- The merchant or planning team exports prior season sales data from ERP or the BI tool.
- The export is imported into a seasonal planning spreadsheet — often a template carried over from the prior year with updated column headers.
- Buyers and merchants review the prior season data and begin populating the new season assortment: adding new styles, deciding which carry-over styles to continue, and assigning initial depth estimates.
- The assortment spreadsheet is reviewed in a range review meeting, often for the first time as a complete document.
- OTB reconciliation happens — or does not happen — depending on whether the financial planning file and the assortment file are maintained by the same person.
The limitations of this process are structural, not methodological. The planning team may be highly skilled; the process will still produce predictable failure modes.
Failure mode 1 — Late OTB reconciliation: When assortment depth is set before OTB reconciliation, the common outcome is that the assortment exceeds the OTB. The reconciliation meeting becomes a negotiation over which styles to cut or at what depth — a reactive process that is less analytically rigorous than building the assortment within OTB constraints from the start.
Failure mode 2 — Carry-over accumulation: Without a formal carry-over review process, styles persist season over season by inertia. The carry-over candidate list grows, OTB is committed to styles that have not been formally re-evaluated, and style count inflates. The team becomes aware of the problem when markdowns on carry-over merchandise spike.
Failure mode 3 — Channel plan divergence: For brands selling across multiple channels, separate assortment files for each channel are common. Without a consolidated view, the aggregate OTB commitment across channels is not visible until someone manually reconciles the files — typically at the buy stage, when it is late to adjust.
Assortment Architecture: The Missing Framework
One of the most consistent gaps in mid-market assortment planning is the absence of a documented assortment architecture — a set of targets and guardrails that define what the assortment should look like before individual style decisions are made.
Assortment architecture includes:
Style count targets by category How many styles should the brand carry per category, per season? This target, set at the start of the planning cycle, constrains the assortment before the range review rather than after it. Brands that set style count targets in advance report shorter range review cycles and less post-review cutting.
Core / fashion / carry-over mix What proportion of the assortment should be core (replenishment or stable product, low markdown risk), fashion (newness, higher sell-through risk, higher margin opportunity), and carry-over (prior season styles continuing)? This ratio drives OTB allocation and risk posture. Brands that define this ratio explicitly tend to manage it more deliberately than brands that let it emerge from the buying process.
Newness ratio What share of the assortment by style count and by OTB should be new introductions? High newness ratios increase sell-through risk; low newness ratios increase carry-over accumulation risk. Setting a target range creates a planning constraint that guides buying decisions.
Carry-over criteria What sells-through threshold must a carry-over style meet to earn continued investment? What criteria trigger exit? Brands that define carry-over criteria before the planning season begins make more consistent carry-over decisions than brands that evaluate each style on a case-by-case basis in the range review.
The Carry-Over Problem
Carry-over management is the area where mid-market assortment planning most commonly fails in ways that compound over time.
The dynamic is predictable: in a given season, the buying team identifies 15 styles from the prior season that performed adequately and are candidates for carry-over. Some are continued. Some are cut. The process is informal — driven by buyer memory and sell-through data pulled ad hoc.
The following season, the carry-over list is 18 styles. Some are styles that should have been exited the prior season but weren't. The list grows. OTB committed to carry-over styles reduces the budget available for new introductions. New styles are bought at lower depths to preserve OTB for carry-over. The assortment gradually shifts toward a higher carry-over ratio than the brand intends.
The operational fix: Carry-over analysis should be a standalone process that happens before the range review — not a decision made during it. The output of the carry-over analysis is a recommended carry-over list with supporting sell-through, margin, and inventory data for each candidate. The range review then works with a pre-vetted carry-over list rather than making carry-over decisions in real time.
Brands that structure carry-over analysis this way report materially lower carry-over accumulation over 3–4 seasons compared to brands that handle carry-over decisions in the range review.
Multi-Channel Assortment Planning: The Inflection Point
Single-channel assortment planning — even complex assortment planning — can be managed in a well-designed spreadsheet by a skilled team. Multi-channel assortment planning is where spreadsheet-based processes reliably break down.
The challenge is not complexity in the individual channel plan. It is the consolidated view: the total OTB commitment across channels, the assortment overlap analysis (which styles are carried in which channels), and the channel-differentiation decisions (which styles are channel-exclusive and why).
In a spreadsheet environment, multi-channel assortment planning produces one of two outcomes:
- Separate channel files: Each channel has its own assortment plan, maintained separately. The consolidated view requires manual aggregation. OTB overruns are not visible until the aggregation happens.
- Single combined file: One file attempts to represent all channels. As the number of channels and the assortment size grow, the file becomes unwieldy. Formula errors accumulate. The file slows.
Brands adding a second or third channel of distribution consistently cite multi-channel assortment management as the primary driver of their technology evaluation. It is the operational breaking point where the spreadsheet ceiling becomes acute.
Process Characteristics of High-Performing Assortment Teams
1. Financial targets drive the assortment, not the reverse High-performing teams establish OTB, margin targets, and sell-through targets before beginning style selection. The assortment is built to fit these targets. Lower-performing teams select styles first and reconcile financials afterward — a process that reliably produces OTB overruns and post-range-review cutting.
2. Carry-over analysis is a pre-process, not a range-review task Top performers complete carry-over analysis as a separate step before the range review. The range review works with a pre-vetted carry-over list.
3. Style count targets are set before range review Top performers set style count targets by category at the start of the planning cycle. These targets function as planning constraints during the range review, not aspirational guidelines.
4. The assortment plan and OTB are in the same system Top performers do not maintain separate assortment and OTB files. When a style is added to the assortment at a given depth, the OTB impact is immediately visible. This eliminates the reconciliation step.
5. Channel differentiation is explicit For multi-channel brands, top performers document which styles are channel-differentiated and why — not as a post-hoc description but as a planning decision made during the assortment process.
Assortment Planning Technology: What the Tools Need to Do
The tooling requirements for assortment planning at mid-market brands are well-defined. The gap between what spreadsheets provide and what purpose-built tools provide maps directly onto the failure modes described in this analysis:
| Planning need | Spreadsheet capability | Purpose-built tool capability | |---|---|---| | Style count targets by category | Manual tracking | Enforced targets with real-time count | | OTB-connected assortment depth | Manual reconciliation | Automatic OTB impact on depth changes | | Multi-channel consolidated view | Manual file aggregation | Single model, all channels | | Carry-over candidate list with sell-through data | Manually assembled | Integrated with prior season actuals | | Assortment architecture guardrails | Not enforced | Configurable targets with alerts | | Range review collaboration | One file, version conflicts | Multi-user, live |
The migration path from spreadsheet-based assortment planning to purpose-built tools is typically not driven by the desire to do something new. It is driven by the need to stop doing something old — specifically, the manual reconciliation that consumes planning capacity and introduces errors that compound season over season.
Summary: What the Data Shows
The assortment planning practices of high-performing mid-market apparel brands share three structural characteristics that are largely independent of team size, brand category, or channel mix:
Structure before selection: Financial targets and assortment architecture are set before style selection begins, not derived from it.
Pre-process carry-over analysis: Carry-over decisions are made analytically, before the range review, not reactively during it.
Connected financial and assortment planning: OTB and assortment are maintained in a single model, not reconciled across separate files.
These characteristics are process choices, but they are also tooling choices. A planning team working in a spreadsheet environment can approximate these practices; a planning team with purpose-built tooling can execute them systematically, at scale, without the reconciliation overhead that consumes capacity in spreadsheet-based environments.
See how RetailNorthstar structures assortment planning — style count targets, carry-over analysis, OTB-connected depth setting, and multi-channel planning in a single connected workflow.
Book a Demo →Read the full assortment planning research.
How mid-market apparel brands structure assortment decisions — and where the process breaks down as brands scale.
- How high-performing teams build assortment architecture before range review
- Carry-over management benchmarks: what exit criteria top performers use
- The multi-channel inflection point where spreadsheet planning consistently fails
- Process characteristics that distinguish high-performing assortment teams
Enter your work email to get instant access. No spam, promise.
We respect your inbox and only send relevant merchandising, planning, and retail operations content.