Wholesale Buy Plan Optimizer
Optimize wholesale seasonal buys with margin analysis and demand forecasting
What You Can Do
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.
Features
Extract sales velocity, sell-through rates, and margin contribution from past seasons to identify winning styles and underperformers
Calculate wholesale pricing, tiered discounts, and margin impact for each product to align with profitability targets
Project category demand by season and occasion to inform open-to-buy allocation and reorder quantities
Build multi-scenario buy plans (conservative, balanced, aggressive) showing expected margin and inventory investment for each
Calculate remaining budget for mid-season additions based on committed spend and margin performance
Tailor assortment mix, price points, and quantities to specific wholesale partner requirements and performance benchmarks
Identify at-risk inventory early and model clearance scenarios to protect end-of-season margins
Generate leadership-ready summaries with margin waterfall, assortment breakdown, and risk mitigation strategies
Example Output
Example 1: Seasonal Buy Plan Summary
Spring 2024 Buy Plan (Missy Dresses)
- Total Investment: $185,000 | Projected Margin: 52% | Turn Rate: 4.2x
- Top 5 SKUs (60% of investment): Wrap Dress (18% margin lift vs. last year), Maxi Shirt Dress (5.8 turn), A-Line Midi (54% margin), Slip Dress (fastest velocity), Shirt Dress (accounts payable risk: Low)
- Underperformers from Fall: Shift down 40% on printed styles (sell-through: 62%), increase solid neutrals (sell-through: 89%)
Example 2: Retailer Account Assortment
Jennifer Account Tailored Mix (Nordstrom)
- Seg: 100 units dresses, 60 units separates, 40 units outerwear
- Price point: 60% $89-119 (vs. 40% for independent retailers)
- Margin requirement: 54% minimum (vs. 50% standard)
- Recommendation: Front-load premium knits (72% margin) over printed tops (44% margin)
Example 3: Open-to-Buy Forecast
Fall Season OTB Update (Mid-July)
- Original OTB: $250,000 | Committed Spend: $198,000 | Remaining OTB: $52,000
- Projected Season Margin: 51.2% (vs. 50% target ✓)
- Mid-season reorder opportunities: Solid knit tops (+15% demand vs. forecast), cardigans (emerging velocity trend)
What's Included
- SKILL.md instruction file with core workflow phases and decision framework:
- Historical Sales Analysis Template: spreadsheet structure for collecting 2-3 seasons of SKU-level sales, margin, and sell-through data
- Buy Plan Scenario Model: framework for building conservative/balanced/aggressive assortment mixes with margin and investment projections
- Retailer Account Profile Worksheet: guidelines for capturing account requirements, price mix, and performance benchmarks to inform assortment tailoring
- Open-to-Buy Tracker: mid-season OTB calculation template with committed spend, margin tracking, and reorder prioritization checklist
Who It's For
- Fashion Merchandisers planning seasonal wholesale buys and assortment strategy
- Wholesale Buyers evaluating SKU performance and optimizing order quantities across wholesale accounts
- Brand Merchandise Managers building data-backed buy plans for leadership approval and retailer presentations
- Fashion Business Analysts forecasting demand and modeling scenario outcomes for margin protection
- Independent Fashion Designers/Brands entering or expanding wholesale channels with limited historical data
Best For
- Seasonal buy planning (Spring, Fall, Holiday, Resort lines) with margin and inventory constraints
- Assortment mix optimization across wholesale accounts with different price points and retailer requirements
- Open-to-buy (OTB) calculation and mid-season reorder prioritization based on performance trends
- Markdown strategy planning and underperformer identification before end-of-season clearance
- Wholesale pricing and tiered discount structure development for profitability alignment
- Retailer account evaluation and tailored assortment recommendations based on historical performance
You might also like
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
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 synthesize fragmented campaign data across email, paid social, influencer, SMS, and owned channels to uncover hidden performance patterns and revenue drivers. The skill calculates channel efficiency metrics, isolates which campaigns or audience segments drive your lowest CAC and highest LTV, and quantifies the financial impact of reallocating budget to winning channels. You'll move beyond vanity metrics to make strategic recommendations grounded in unit economics and forecasted revenue impact.
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 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