
Seasonal Merchandise Plan Optimizer
Build data-driven seasonal merchandise plans with category allocation and SKU strategy
What You Can Do
You can develop complete seasonal merchandise plans that balance growth objectives, inventory constraints, and assortment strategy. This skill guides you through analyzing historical performance data, defining category-level strategies, allocating budgets across departments, and rationalizing SKU counts to maximize sell-through and minimize markdowns. You'll produce financially accountable plans with clear rationales ready for stakeholder review.
Features
Extract sell-through rates, margin performance, and seasonal trends from prior year data to inform current planning
Map growth rates, assortment depth, and price architecture for each merchandise category
Distribute inventory investment across departments using data-driven weighting and growth targets
Right-size product assortment by analyzing velocity, profitability, and inventory turnover
Establish and validate sales, margin, and inventory turn targets tied to plan assumptions
Identify risk categories and build contingency planning into seasonal budgets
Cross-check category totals, inventory levels, and financial targets for plan coherence
Example Output
Example 1: Spring/Summer Apparel Plan
- Knits category: +15% budget allocation based on 18% YoY growth trajectory, 3,200 total SKUs (-12% from prior year), 450-piece min/max per style
- Dresses category: Flat budget, shift 60% investment to midi silhouettes (55% sell-through vs. 38% mini dresses), reduce SKU count from 1,850 to 1,320
- Total plan: $8.2M inventory investment, 42,000 units, 8.2x turn target
Example 2: Holiday Season Replan
- Analysis shows knit tops underperforming (-22% vs. plan); recommend 8% budget reallocation to outerwear
- Propose SKU consolidation in basic tees (reduce 340 SKUs to 220) while expanding novelty holiday prints (increase from 180 to 320 SKUs)
- Revised financial target: $1.2M additional margin through assortment optimization
What's Included
- SKILL.md instruction file: Complete framework for seasonal merchandise planning
- Historical Performance Analysis Template: Spreadsheet structure for extracting prior year sell-through, margin, and trend data
- Category Strategy Planner: Worksheet to map growth rates, assortment depth, and price points by merchandise category
- Budget Allocation Workbook: Tool for distributing inventory investment across departments and validating totals
- SKU Rationalization Checklist: Criteria matrix for evaluating product retention, velocity tiers, and profitability thresholds
- Plan Validation Checklist: Final review template to confirm category coherence, financial alignment, and inventory feasibility
Who It's For
- Fashion Merchandisers — Planning seasonal assortments aligned to financial targets and historical performance
- Merchandise Planning Managers — Building comprehensive departmental plans and allocating budgets across teams
- Retail Buyers — Developing SKU strategies and category-level assortment plans for upcoming seasons
- Fashion Business Analysts — Creating data-driven financial projections and validating plan assumptions
- Seasonal Planning Leads — Coordinating cross-functional seasonal planning cycles for multi-department retailers
Best For
- Spring/Summer and Fall/Winter seasonal plan development
- Holiday season merchandise planning and mid-season replans
- SKU rationalization and assortment right-sizing
- Budget allocation and inventory investment distribution across categories
- Markdown prevention strategy and financial target setting
- Plan documentation and stakeholder alignment presentations







