Seasonal Assortment Planning Optimizer
Plan seasonal apparel assortments using trend data, inventory constraints, and sales velocity
What You Can Do
You can develop coherent seasonal assortments that balance trend relevance, inventory investment, and profitability across multiple price tiers and distribution channels. By analyzing quantitative metrics (historical sell-through, inventory turns, margin contribution) alongside qualitative trend assessment, you move beyond intuition-driven buying to create strategic buying plans that align supplier commitments with actual market demand signals.
Features
assess trend momentum and consumer signals to inform style selection and colorway decisions
evaluate historical performance by style, size tier, and price point to predict seasonal viability
balance open-to-buy allocation against supplier minimums and delivery windows
calculate expected gross margin by assortment mix to protect profitability targets
reduce assortment complexity while maintaining style diversity and size coverage
quantify recommended quantities by style based on demand signals and inventory turns
document triggers for shifting open-to-buy between categories if sell-through deviates from plan
track key metrics (sell-through %, inventory turns, markdown %) against seasonal benchmarks
Example Output
Example 1: Spring Assortment Planning
- Analyzed Q2 historical sell-through data and identified denim as top performer (78% sell-through, 4.2 turns)
- Trend assessment flagged relaxed-fit silhouettes gaining momentum (+22% search interest vs. prior year)
- Recommended increasing relaxed-fit denim allocation from 22% to 35% of pants category OTB
- Calculated margin impact: +1.2% category gross margin while maintaining sell-through targets
- Provided supplier commitment quantities by wash, fit, and size tier with delivery window timing
Example 2: Inventory Rebalancing
- Flagged oversized inventory position in knits (+18% vs. seasonal average) with sell-through declining to 62%
- Identified core basics (white tees, navy sweaters) as consistently performing with 85%+ sell-through
- Reallocated $45K OTB from trend-heavy novelty knits to core basic depth and size range expansion
- Projected 8% reduction in seasonal markdown exposure
What's Included
- SKILL.md instruction file with methodology and decision frameworks:
- Seasonal assortment planning template (trend signals, inventory analysis, commitment quantities):
- Historical performance analysis checklist (sell-through by style, size tier, price point):
- Open-to-buy allocation worksheet with supplier commitment calculator:
- Assortment health scorecard for tracking sell-through %, inventory turns, and margin vs. plan:
Who It's For
- Fashion/apparel buyers planning seasonal assortments across multiple price tiers
- Merchandisers evaluating supplier line sheets and determining style/quantity commitments
- Inventory planners aligning assortment depth with warehouse capacity and turnover targets
- Category managers optimizing mix between trend-forward and core basics
- Sourcing teams using data-driven buying plans to negotiate quantities with suppliers
Best For
- Developing Q1, Q2, Q3, Q4 seasonal assortment plans 4-6 months pre-season
- Analyzing previous season underperformance and recalibrating assortment strategy
- Managing SKU proliferation while protecting margin integrity and sell-through rates
- Navigating conflicting signals between trend momentum and inventory constraints
- Mid-season reallocation of open-to-buy based on actual sell-through performance
You might also like
You can rapidly assess current planogram performance against sales data, identify underperforming SKUs and space inefficiencies, and generate detailed shelf layout recommendations that balance profitability, velocity, and compliance. Claude processes your category mix, fixture dimensions, regulatory constraints, and competitive positioning to produce actionable planograms ready for retail operations review and store execution.
by cowork-os
You can systematically analyze vendor performance data across multiple KPIs (sales, turn rate, on-time delivery, quality, margin contribution), identify root causes of underperformance, benchmark vendors against category standards, and develop specific improvement plans with calculated financial impact. This skill translates raw vendor metrics into compelling business cases for vendor investments, contract negotiations, or corrective actions, replacing intuition-based feedback with data-driven strategic conversations.
by cowork-os
You can upload sales velocity, margin, inventory, and competitive data to receive structured assortment analysis grounded in category management principles. The skill identifies low-performing SKUs for elimination, unmet customer demand (white space), and right-sizing opportunities—then delivers actionable recommendations with financial impact projections to justify decisions to leadership.
by cowork-os
This skill transforms raw sales, inventory, and market data into actionable assortment insights. You'll rank SKUs by velocity, margin, and trend trajectory to identify underperformers worth pruning. Discover whitespace gaps—missing size/color/price tier combinations that competitors stock but you don't. Model the financial impact of proposed assortment changes, projecting revenue and margin shifts before implementation.
by cowork-os
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
by cowork-os
You can strategically analyze store layouts and visual displays to identify optimization opportunities that drive unplanned purchases and improve customer navigation. This skill helps you create cohesive visual narratives aligned with brand guidelines, develop seasonal and campaign-driven display concepts, and audit existing installations against performance benchmarks to maximize conversion rates and basket size.
by cowork-os
You can upload sales data, margin metrics, and customer behavior patterns to uncover hidden performance trends across your product portfolio. Claude analyzes sales velocity, margin contribution, and customer engagement to surface optimization opportunities—identifying which SKUs to promote, bundle, or rationalize. The skill generates actionable category strategies, reorder rate analysis, and competitive positioning recommendations tailored to your digital channels and seasonal opportunities.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level targets.
by cowork-os