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 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
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 make allocation decisions that balance competing objectives: maximizing sell-through rates and full-price sell, minimizing forced markdowns and clearance exposure, respecting floor space constraints, protecting margin-rich locations from stock-outs, and accounting for location-specific demand signals. This skill guides you through both quantitative metrics and qualitative judgment to distribute finite inventory pools strategically across 5+ locations based on productivity, seasonality, margin opportunity, and local market conditions.
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
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 build allocation strategies grounded in real demand data, promotional calendars, and inventory constraints for your store network. This skill helps you match supply to the specific demand profile of each location, eliminate guesswork in distribution decisions, and reduce markdown pressure by optimizing sell-through rates across your entire retail footprint.
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 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