Assortment Optimization Analyzer
Analyze product mix performance and generate data-driven assortment recommendations
What You Can Do
You can upload sales velocity, margin, inventory, and competitive data to receive structured assortment analysis grounded in category management principles. The skill identifies low-performing SKUs for elimination, unmet customer demand (white space), and right-sizing opportunities—then delivers actionable recommendations with financial impact projections to justify decisions to leadership.
Features
rank SKUs by profitability, identify slow-moving items, and spot margin leakage across the category
detect white space opportunities where customer demand isn't being met and competitive blind spots
receive specific recommendations for how many variants, how many brands, and how many products to carry
compare your assortment against competitors to identify share-loss risks and differentiation opportunities
get clear elimination and consolidation candidates with estimated inventory write-off and cost savings
analyze which SKUs serve which customer segments and identify unserved or under-served groups
receive financial impact projections (revenue, margin, turns) to justify assortment changes to stakeholders
Example Output
Example 1: Low-Velocity SKU Elimination
- SKU A-2847 (Organic Almond Butter, 16oz): 0.8 units/week, 18% margin, 89 days supply → Recommend DELETE. Impact: +$12,400 annual margin through elimination of slow-turning inventory and reduced labor.
Example 2: White Space Opportunity
- Category carries 12 SKUs in ready-to-drink coffee; none in plant-based protein smoothies. Competitors carry 3–4 SKUs. Recommend ADD 2 SKUs in this emerging subcategory. Projected impact: +$45,000 annual revenue, capture 8% of segment demand.
Example 3: Depth Optimization
- Salsa category currently carries 14 SKUs (7 brands × 2 sizes). Top 6 SKUs generate 78% of category sales. Recommend consolidate to 10 SKUs (5 brands × 2 sizes). Impact: -8% revenue, +$18,500 labor savings, +3 turns/year.
What's Included
- SKILL.md: instruction file with category management frameworks
- Sales Velocity Assessment Template: structure for uploading and categorizing SKU performance data
- Competitive Assortment Benchmarking Checklist: questions to gather competitor data
- Assortment Optimization Scorecard: worksheet to score SKUs across velocity, margin, and strategic fit
- Executive Summary Business Case Template: format for presenting recommendations with financial impact
Who It's For
- Category Managers — evaluating annual assortment resets and seasonal SKU mix changes
- Merchandising Directors — optimizing portfolio across multiple categories and regions
- Retail Buyers — managing vendor assortment and justifying product deletions or additions
- eCommerce Merchants — right-sizing online catalogs and identifying high-performing product mixes
- CPG Product Line Managers — analyzing SKU profitability and planning rationalization initiatives
Best For
- Annual or seasonal assortment resets and category reviews
- Low-velocity SKU elimination and inventory obsolescence prevention
- Competitive response analysis after market share loss
- White space identification and new subcategory entry planning
- Category depth and breadth optimization within space and labor constraints
- Justifying assortment changes with financial impact projections
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