Vendor Performance Analytics & Optimization
Analyze vendor KPIs, identify gaps, and quantify financial impact for strategic improvements
What You Can Do
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.
Features
Process vendor scorecards across sales volume, turn rate, on-time delivery, quality, margin contribution, and category-specific metrics
Compare individual vendor performance against category standards, top performers, and historical trends to identify gaps
Analyze performance drivers and pinpoint underlying causes of underperformance (inventory issues, pricing, assortment, execution)
Calculate revenue loss, margin erosion, and opportunity costs tied to each performance gap with specific dollar amounts
Create prioritized, measurable action plans with realistic timelines and success metrics for vendor remediation
Generate data-backed business cases for leverage in renewal conversations, co-op funding decisions, and performance incentives
Segment vendors by performance tier to guide investment allocation, planogram support, and merchandising prioritization
Example Output
Example 1: Vendor Performance Gap Analysis
Vendor: ABC Apparel (Category: Women's Tops)
- Sales: $450K (target: $600K) — Gap: -$150K (-25%)
- Sell-through rate: 58% (category avg: 72%) — $42K annual margin loss
- On-time delivery: 82% (standard: 95%) — 3 emergency reorders at $8K each
- Total quantified impact: $66K annual opportunity
Root Causes: Slow inventory turns due to 40% excess spring inventory; pricing 12% above category average
Recommendations:
- Implement weekly inventory management (est. improve turn rate to 68% in 60 days) → $28K margin recovery
- Align pricing to competitive range (reduce 8-10%) → $18K sales uplift
- Right-size seasonal buys (reduce spring peak inventory) → $20K cash flow benefit
Example 2: Vendor Scorecard Summary
| Metric | ABC Apparel | Category Avg | Variance | Impact |
|---|---|---|---|---|
| Sales ($K) | 450 | 600 | -25% | -$150K |
| Sell-through % | 58% | 72% | -14% | -$42K margin |
| On-time % | 82% | 95% | -13% | -$24K expedite costs |
| Total Impact | -$216K annually |
What's Included
- VENDOR-PERFORMANCE-ANALYTICS-OPTIMIZER.md: Complete skill instructions with data requirements and workflow
- Vendor KPI Template: Standardized scorecard with 15+ key metrics and industry benchmarks
- Root Cause Analysis Framework: Guided worksheet for identifying performance drivers and underlying issues
- Financial Impact Calculator: Formulas for quantifying margin loss, inventory costs, and opportunity value
- Vendor Improvement Roadmap Template: Prioritized action plan with timelines, owners, and success metrics
- Contract Negotiation Brief Template: Business case summary for vendor conversations and renewal decisions
Who It's For
- Category Managers — Justify vendor rankings and performance decisions to leadership using data-backed analysis
- Vendor Managers — Conduct quarterly business reviews and contract renewal negotiations with quantified improvement targets
- Merchandising Directors — Allocate co-op budgets, planogram support, and marketing investments based on vendor tier performance
- Procurement Professionals — Build financial cases for vendor consolidation or expansion decisions
- Retail Operations — Identify vendors causing supply chain friction and quantify impact for corrective action
Best For
- Quarterly vendor performance reviews and scorecarding
- Contract renewal negotiations with data-driven leverage
- Vendor tiering and investment allocation decisions
- Root cause analysis of declining vendor metrics
- Building business cases for vendor remediation or consolidation
- New vendor onboarding baseline setting
- Finance/leadership reporting on vendor portfolio performance
You might also like
You can strategically analyze store layouts and visual displays to identify optimization opportunities that drive unplanned purchases and improve customer navigation. This skill helps you create cohesive visual narratives aligned with brand guidelines, develop seasonal and campaign-driven display concepts, and audit existing installations against performance benchmarks to maximize conversion rates and basket size.
by cowork-os
You can upload sales data, margin metrics, and customer behavior patterns to uncover hidden performance trends across your product portfolio. Claude analyzes sales velocity, margin contribution, and customer engagement to surface optimization opportunities—identifying which SKUs to promote, bundle, or rationalize. The skill generates actionable category strategies, reorder rate analysis, and competitive positioning recommendations tailored to your digital channels and seasonal opportunities.
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 quantify how customer segments respond to different discount depths and promotional timing by analyzing historical sales data. This skill helps you forecast demand under various discount scenarios, identify which product categories or customer groups are price-elastic versus price-inelastic, and recommend optimal promotional calendars that balance revenue maximization with efficient inventory clearance without training customers to expect constant discounts.
by cowork-os
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 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
This skill transforms raw sales, inventory, and market data into actionable assortment insights. You'll rank SKUs by velocity, margin, and trend trajectory to identify underperformers worth pruning. Discover whitespace gaps—missing size/color/price tier combinations that competitors stock but you don't. Model the financial impact of proposed assortment changes, projecting revenue and margin shifts before implementation.
by cowork-os
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
by cowork-os