Vendor Assortment Optimization Analyzer
Analyze vendor assortments to maximize sell-through, margins, and inventory efficiency
What You Can Do
You can analyze vendor product assortments against category performance targets to quantify sales distribution, identify SKUs driving profitability, and spot white-space opportunities. This skill transforms subjective vendor reviews into data-backed recommendations that improve sell-through rates and margin contribution while maintaining market coverage. You'll uncover which of a vendor's 30-200+ SKUs are worth defending, expanding, or removing—giving you concrete negotiation points for vendor reviews and contract renewals.
Features
Rank vendor SKUs by sales velocity, margin contribution, and inventory turnover to identify top performers vs. underperformers
Calculate which SKUs are driving profitability and which are margin-draining, factoring in cost of goods, promotional spend, and overhead
Identify redundant or overlapping SKUs within a vendor's portfolio and recommend consolidation to reduce complexity
Spot gaps in the vendor's assortment where competitor SKUs or unmet customer demand suggest expansion opportunities
Quantify the 80/20 distribution of sales and recommend SKU depth adjustments to improve overall category sell-through
Evaluate stock-turn metrics and identify slow-moving SKUs that tie up working capital without proportional sales contribution
Generate data-backed talking points for vendor meetings, including specific SKU actions (keep, expand, test, delete)
Compare vendor depth and SKU mix against seasonal demand patterns to guide seasonal planning and promotional calendars
Example Output
Example 1: Vendor Consolidation Analysis
Vendor: Acme Foods (Snacks Category)
- Total SKUs: 127 | Sales concentration: 72% from top 18 SKUs (14% of portfolio)
- Consolidation opportunity: 34 SKUs with <$5K annual sales and 3%+ margin drain
- Recommendation: Recommend vendor delete 25 low-velocity items; reallocate shelf to 6 proven gaps (organic/better-for-you segment)
- Expected impact: +8% category margin, -12% inventory count, +15% velocity on retained assortment
Example 2: Margin-Driven Assortment Adjustment
Vendor: Premium Brand Co. (Beauty Category)
- Top 12 SKUs: 58% of volume, 72% of margin
- Problem SKUs: 4 promotional-heavy items with negative margin after marketing spend
- Recommendation: Migrate promotional volume to full-price alternatives; test 3 emerging sub-categories vendor doesn't currently serve
- Expected impact: +340 bps margin, +2.1% category growth, improved brand positioning
Example 3: White-Space Opportunity
Vendor: Global Beverages (Functional Drinks)
- Current assortment: 52 SKUs across energy, sports, hydration
- Gap identified: Zero presence in adaptogens/wellness category (growing +31% YoY)
- Recommendation: Co-develop 2-3 SKUs; allocate 8 linear feet of current space
- Expected impact: +$340K annual category sales, vendor revenue expansion, competitive differentiation
What's Included
- SKILL.md instruction file: Complete vendor assortment analysis methodology
- Vendor Portfolio Audit Template: Data input sheet for SKU-level sales, margin, and inventory metrics
- Assortment Consolidation Checklist: Step-by-step guide to evaluate SKUs for deletion, retention, or expansion
- Margin Contribution Scorecard: Framework to calculate profitability by SKU including COGS, promotions, and overhead allocation
- Negotiation Brief Template: Pre-formatted talking points and recommendations for vendor meetings and contract reviews
Who It's For
- Category Managers — optimize vendor assortments during quarterly/annual reviews and contract negotiations
- Merchandisers — identify SKU rationalization opportunities and support assortment planning decisions
- Retail Buyers — evaluate vendor depth, consolidation opportunities, and strategic fit for category strategies
- Operations Managers — assess inventory efficiency and working capital tied up in slow-moving vendor SKUs
- Vendor Managers — develop data-backed performance feedback and collaboration roadmaps with key suppliers
Best For
- Vendor portfolio consolidation — Reduce SKU count and complexity while protecting sales and margin
- Quarterly/annual vendor reviews — Replace subjective assessments with quantified performance analysis
- Pre-negotiation preparation — Build evidence-based recommendations for shelf space, pricing, and assortment depth
- Seasonal assortment planning — Validate vendor depth and SKU mix alignment with demand seasonality
- White-space identification — Spot unmet customer demand and expansion opportunities within vendor portfolios
You might also like
You can systematically analyze competitor pricing strategies across product categories, quantify price-demand elasticity relationships, and identify market positioning gaps. This skill helps you build defensible pricing recommendations backed by competitive data, assess margin implications, and create scenario analyses for executive decision-making—moving beyond reactive price matching to strategic positioning.
by cowork-os
You develop strategic visual merchandising plans that integrate business objectives, customer behavior analysis, and brand guidelines into actionable retail presentations. This skill guides you through spatial psychology, color theory, product hierarchy, and sales velocity analysis to create zone-specific placement strategies, seasonal displays, and fixture specifications that drive conversion and average transaction value. You'll analyze competitor approaches, align visual hierarchy with margin targets, and build frameworks for multi-location consistency.
by cowork-os
You can convert raw pricing data into defensible, actionable price recommendations by analyzing competitor behavior, demand elasticity, inventory health, and seasonal factors simultaneously. This skill helps you balance revenue maximization against competitive positioning and inventory velocity, enabling you to prioritize which SKUs to adjust first and justify price changes to stakeholders with quantitative rationale.
by cowork-os
You can systematically analyze vendor quotes by deconstructing cost structures, identifying hidden costs and margin compression points, and modeling multiple pricing scenarios. The skill enables you to forecast margin impact across volume tiers, develop proactive negotiation strategies grounded in vendor financials, and build data-backed proposals that improve both your margins and vendor sustainability—transforming reactive price-pushing into strategic partnership analysis.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level targets.
by cowork-os
You can rapidly assess current planogram performance against sales data, identify underperforming SKUs and space inefficiencies, and generate detailed shelf layout recommendations that balance profitability, velocity, and compliance. Claude processes your category mix, fixture dimensions, regulatory constraints, and competitive positioning to produce actionable planograms ready for retail operations review and store execution.
by cowork-os
Transform raw sales data into strategic insights by decomposing performance variance into specific drivers, benchmarking category health against targets, and quantifying the financial impact of merchandising decisions. You'll uncover hidden patterns in customer behavior, identify performance bottlenecks, and build executive-ready business cases backed by rigorous data analysis—moving beyond dashboards to actionable strategy.
by cowork-os
You can systematically analyze vendor performance data across multiple KPIs (sales, turn rate, on-time delivery, quality, margin contribution), identify root causes of underperformance, benchmark vendors against category standards, and develop specific improvement plans with calculated financial impact. This skill translates raw vendor metrics into compelling business cases for vendor investments, contract negotiations, or corrective actions, replacing intuition-based feedback with data-driven strategic conversations.
by cowork-os