Seasonal Assortment Planning Optimizer
Build data-driven seasonal assortments that maximize sell-through and minimize markdowns
What You Can Do
You can systematically evaluate historical performance, upcoming trends, and operational constraints to build balanced seasonal assortments that reduce markdown pressure and improve profitability. The skill helps you determine optimal breadth versus depth across categories, identify which SKUs deserve increased or decreased allocation, and model the financial impact of assortment decisions. This approach replaces guesswork with data-driven recommendations that typically improve sell-through rates and protect margins.
Features
Review previous season sell-through, velocity, and profitability metrics by category and SKU to identify proven winners and underperformers
Incorporate emerging trends and market forecasts into assortment recommendations while balancing against baseline performance data
Calculate ideal number of SKUs and units per SKU based on inventory capacity, supplier minimums, and target sell-through rates
Determine budget and inventory distribution across departments and subcategories using performance-weighted recommendations
Work within warehouse capacity limits, capital budgets, supplier lead times, and minimum order quantities
Forecast markdown requirements and adjust assortment strategy to reduce excess inventory and clearance pressure
Assess supplier reliability, lead times, and cost structure to optimize supplier mix and minimize risk
Compare multiple assortment scenarios and their projected financial outcomes before committing to buys
Example Output
Example 1: Spring/Summer Assortment Plan
- Denim Category: Increase allocation to cropped styles (+25% units) based on 40% sell-through lift last season; maintain classic straight-leg depth for core audience
- Color Palette: Prioritize neutrals (40% of units) and pastels (35%) per trend data; reduce bold brights to 15% test allocation due to inconsistent historical performance
- Sizing Strategy: Expand size 8-12 range (60% of units) following demographic shift; maintain petite/tall offerings at 20% based on sell-through data
- Projected Outcome: 78% full-price sell-through, 12% markdown rate (vs. 18% previous year)
Example 2: Vendor Mix Adjustment
- Current State: 70% allocation to primary vendor with 45-day lead time; 30% to secondary vendor with 60-day lead time
- Recommendation: Shift to 50/50 split with two secondary vendors to reduce lead-time risk while maintaining cost targets
- Constraint Handling: Secondary vendors require $5K minimums per style; recommend consolidating to 8 core styles vs. current 12
- Financial Impact: Reduces markdown exposure by 6 percentage points through better responsive buying flexibility
Example 3: Category Rebalancing
- Footwear: Decrease allocation from 18% to 15% of total inventory (underperformed last 3 seasons at 68% sell-through)
- Activewear: Increase allocation from 12% to 16% (achieving 89% sell-through, trending up 15% YoY)
- Accessories: Maintain at 22% (consistent 81% sell-through with lower markdown sensitivity)
- Outcome: Projected improvement to 80% blended sell-through vs. 74% baseline
What's Included
- SKILL.md instruction file: Complete skill configuration and usage guidelines
- Historical Performance Analysis Template: Data input structure for previous season sales, velocity, and profitability by SKU
- Assortment Planning Framework: Step-by-step methodology for evaluating breadth, depth, and category allocation
- Financial Modeling Worksheet: Scenarios for comparing assortment options and projecting sell-through, markdown, and margin outcomes
- Constraint Tracker: Inventory capacity, budget, supplier minimums, and lead-time planning checklist
- Trend Integration Checklist: Process for validating trend recommendations against historical performance data before inclusion
Who It's For
- Fashion Merchandisers — Plan seasonal assortments that balance trend relevance with historical performance and profitability targets
- Inventory Planners — Optimize SKU breadth and unit depth to maximize warehouse efficiency and sell-through rates
- Buying Teams — Make data-driven allocation decisions across categories and vendors to reduce markdown exposure
- Retail Managers — Understand assortment strategy drivers and financial impact of seasonal planning decisions
- Product Development Leads — Evaluate which new styles, colors, and sizes to include in seasonal assortments based on risk assessment
Best For
- Seasonal assortment planning for Spring/Summer, Fall/Winter, and shoulder seasons with 3-6 month lead times
- Previous season analysis and next season strategy refinement using historical sell-through and markdown data
- Category rebalancing decisions when allocation needs to shift based on performance trends
- Vendor and supplier optimization when reconciling multiple sourcing options with lead times and costs
- Markdown reduction planning by modeling assortment adjustments that lower excess inventory and clearance pressure
- New product category testing with constrained budgets while protecting baseline performance
You might also like
You can rapidly assess closeout inventory positions and translate them into actionable buying strategies. This skill helps you parse vendor offers into risk/opportunity matrices, calculate multiple markdown scenarios with breakeven analysis, and build negotiation frameworks with concrete floor and ceiling positions. You'll validate inventory claims against historical performance data and identify hidden quality or fit issues before committing capital.
by ecnu-icalk
You can transform wholesale buy planning from intuition-based decisions into data-driven strategy. Analyze historical sales patterns across SKUs and channels, calculate optimal order quantities balancing margin targets against demand forecasts, model scenario outcomes for different assortment mixes, and generate defensible buy plans with clear margin validation. The skill helps you justify purchasing decisions to leadership and identify underperforming styles early for markdown strategy.
by ecnu-icalk
Analyze SKU performance across size, color, and price dimensions to segment products into expand/maintain/reduce/discontinue categories. You'll evaluate seasonal trends, margin health, and channel-specific performance to build data-driven assortment strategies that balance selection breadth with inventory efficiency. The skill helps you identify profitable size-color-price combinations and plan phased inventory adjustments that protect margins while improving sell-through.
by ecnu-icalk
You can transform merchandising data into actionable visual strategies that optimize customer flow, increase dwell time, and boost conversion rates. The skill synthesizes color theory, behavioral science, spatial design principles, and inventory constraints to create floor plans, window displays, and seasonal concepts with documented strategic rationale. You'll produce data-backed merchandising recommendations that align with your retail goals and brand positioning.
by ecnu-icalk
You can assess incoming closeout and overstock lots to determine acquisition viability at target margins, analyze current inventory performance to prioritize reorders vs. liquidation, and structure negotiations that balance volume commitments against margin requirements. This skill helps you identify which SKUs justify acquisition at various price points, establish minimum acceptable margin thresholds, and build data-driven clearance strategies that accelerate sell-through while protecting profitability.
by ecnu-icalkThis skill helps you develop, analyze, and optimize deductive reasoning strategies for solving complex logic puzzles, validating arguments, and constructing rigorous proofs. You'll learn structured approaches to break down logical problems, identify patterns, and build compelling arguments with confidence.
by ecnu-icalk
You can synthesize multiple data streams—social media trends, competitor launches, sales velocity metrics, and supply chain constraints—to make rapid, data-backed product decisions. The skill guides you through trend viability assessment, competitive response planning, and production feasibility validation, enabling you to identify micro-trends 6-12 weeks before mainstream adoption and execute products within compressed timelines while managing inventory risk.
by ecnu-icalk
You can analyze seasonal buying decisions across multiple departments and SKUs by integrating historical sales data, trend analysis, and vendor constraints. This skill helps you build data-backed assortment strategies that balance inventory investment with markdown risk, negotiate vendor commitments confidently, and forecast gross margin impact before committing budget. You'll reduce guesswork in category allocation decisions and create presentation-ready analyses for merchandising committees.
by ecnu-icalk