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 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 architect multi-dimensional brand heritage narratives that authenticate luxury positioning and create emotional resonance with high-value customers. By identifying and amplifying unique heritage elements, founder mythology, and historical credibility, you develop coherent narratives that justify 300-500% price premiums and establish consistent brand storytelling across retail, digital, and communications touchpoints. This skill transforms your brand story from a marketing tactic into your primary competitive advantage.
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
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
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 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-icalk