Seasonal Assortment Planning Optimizer
Optimize seasonal assortments with data-driven buying strategy and margin forecasting
What You Can Do
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.
Features
evaluates past seasonal sales, AUR, units, and markdown rates by category to identify trends and inform sizing decisions
organizes vendor constraints, minimums, and delivery windows to ensure assortment viability
identifies underperforming SKUs to cut and high-potential gaps to fill within each category
projects markdown probability and impact based on category lifecycle stage, competitive environment, and inventory depth
calculates expected margin contribution by category, accounting for planned retail, cost, and estimated markdown rates
balances branded vendor offerings, private label penetration, and price tier distribution by department
flags category whitespace and over-allocation relative to key competitors to guide buying decisions
generates data-backed purchasing commitments and payment terms recommendations by vendor and category
Example Output
Example 1: Women's Apparel Spring Assortment
- Current season analysis shows blouses underperformed (45% markdown) while dresses drove full-price sales
- Recommendation: Reduce blouse units 20%, reallocate budget to dress depth in sizes 4-12, increase vendor A commitment 15%
- Projected impact: +$12K gross margin, -3% markdown rate
Example 2: Accessories Vendor Negotiation
- Vendor X historically delivers 85% on time; suggests 20% order increase for holiday
- Analysis shows capacity constraints may limit December delivery; recommends front-loading 40% of units to October
- Markdown risk by style: classic leather (8%) vs. trend-based novelty items (28%)
Example 3: Men's Basics SKU Rationalization
- Current assortment: 127 SKUs, 40% carry <$500 seasonal sales
- Recommendation: Consolidate from 127 to 89 SKUs, eliminate slow colors/sizes, expand core basics depth
- Projected impact: +12% inventory turns, -8% holding cost, maintained revenue
What's Included
- SKILL.md instruction file with assortment planning workflows and prompts:
- Historical Performance Template: data intake format for sales, units, markdown rates, and AUR by category and season
- Vendor Capacity & Constraint Worksheet: lead times, minimums, payment terms, and delivery windows by vendor
- SKU Rationalization Checklist: criteria for identifying cuts and gaps by category performance and lifecycle stage
- Markdown Risk & Margin Forecast Model: category-level financial projections with sensitivity analysis
Who It's For
- Department store fashion buyers — planning seasonal assortments and managing vendor partnerships
- Merchandising managers — analyzing category performance and building allocation recommendations
- Fashion category directors — evaluating assortment strategy across multiple locations or regions
- Sourcing and planning teams — preparing vendor negotiations and purchase commitment decisions
- Retail operations executives — reviewing financial impact of assortment changes on store-level profitability
Best For
- Seasonal assortment planning (spring, fall, holiday, transition seasons)
- Vendor proposal evaluation and purchase commitment negotiation
- SKU rationalization and category gap analysis
- Markdown risk forecasting and gross margin modeling
- Competitive assortment benchmarking and whitespace identification
- Presentation development for merchandising committees and executive review
You might also like
You can analyze your customer portfolio to develop risk-segmented collection strategies that maximize recovery while maintaining regulatory compliance. The skill prioritizes aging receivables based on recovery likelihood, helping you allocate resources to the highest-value opportunities. It also generates customized, compliant collection communications tailored to each customer segment.
by ecnu-icalk
You can develop complete media strategies tailored to fashion events that account for editorial lead times, media hierarchies, and industry-specific coverage opportunities. This skill creates fashion-focused press release frameworks, media contact segmentation strategies, influencer collaboration plans, and multi-channel promotion calendars that align with fashion industry standards and amplification rhythms from pre-event through post-event coverage.
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
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-icalk
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.
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 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