Supply Chain KPI Analysis and Reporting
Analyze supply chain metrics, generate performance dashboards, and uncover optimization opportunitie
What You Can Do
Transform raw supply chain data into actionable KPI reports with visual dashboards and root cause analysis. You provide operational metrics like on-time delivery rates, inventory turnover, supplier performance, or cost data, and Claude generates comprehensive performance summaries, identifies performance gaps, and delivers prioritized recommendations tied to business impact.
Features
Calculate industry-standard metrics like OTIF (on-time in-full), inventory days of supply, supplier quality scores, and cost variance with built-in formulas and validation
Create markdown-formatted visual dashboards with trend analysis, key metrics at a glance, status indicators, and period-over-period comparisons
Dig into performance gaps and anomalies to identify underlying causes such as supplier delays, process bottlenecks, or demand volatility
Spot concerning patterns in delivery times, quality metrics, or costs that warrant immediate attention or escalation
Compare your metrics against industry baselines and best-in-class performance to identify competitive positioning and improvement priorities
Receive prioritized, business-impact-focused recommendations ranked by effort and return, with estimated savings or risk reduction
Synthesize performance across quality, on-time delivery, cost, and responsiveness into weighted supplier scorecards and rankings
Example Output
Supply Chain Performance Report - Q3 2026
| Metric | Current | Target | Variance | Status |
|---|---|---|---|---|
| OTIF | 87.2% | 95% | -7.8% | ⚠ At Risk |
| Inventory DSO | 34 days | 28 days | +6 days | ⚠ High |
| Supplier Quality | 98.1% | 99% | -0.9% | ✓ On Track |
Root Causes Identified:
- Inbound logistics delays (+3.2% of late deliveries) tied to carrier congestion at Port of Los Angeles
- Excess safety stock in finished goods due to demand forecasting lag (correlation: 0.78)
- Two suppliers (IDs: SUP-042, SUP-089) causing 22% of quality defects
Top 3 Recommendations:
- Shift 15% of Port of LA shipments to alternate routing (Port of Long Beach): Est. $180K annual savings, 6-week implementation
- Implement demand sensing software: Est. $50K savings in inventory carrying costs, 8-week deployment
- Conduct quality audits at SUP-042 and SUP-089: Est. $75K in defect cost avoidance, 2-week execution
What's Included
- KPI Calculation Templates: Pre-built formulas and validation logic for 20+ supply chain metrics including OTIF, inventory turnover, days payable outstanding, and freight cost per unit
- Dashboard Framework: Markdown templates for status dashboards, executive summaries, department scorecards, and trend visualizations
- Data Validation Checklist: Quality checks and assumptions documentation to ensure data accuracy and establish confidence in analytical results
- Root Cause Analysis Framework: Structured prompts and hypothesis testing methodology to systematically investigate performance anomalies
- Supplier Performance Scorecard Template: Weighted multi-criteria evaluation framework combining quality, delivery, cost, and responsiveness metrics
- Recommendations Prioritization Matrix: Framework for ranking improvement initiatives by business impact, implementation effort, and risk mitigation potential
Who It's For
- Supply Chain Managers and Directors
- Operations and Logistics Coordinators
- Procurement Specialists and Sourcing Teams
- Chief Supply Chain Officers (CSCO) and Executive Leadership
- Business Analysts and Operations Research Teams
Best For
- Monthly or quarterly supply chain performance reviews and board-level reporting
- Identifying and prioritizing supply chain improvement projects
- Supplier performance evaluation and scorecard maintenance
- Investigating cost overruns, delivery failures, or quality issues
- Benchmarking your operations against industry standards
You might also like
You receive a structured framework for decomposing total cost-to-serve into fixed and variable components across channels, customers, and products. Claude helps you analyze profitability by segment, identify cost drivers, model optimization scenarios (consolidation, pricing, routing), and generate data-driven recommendations with quantified financial impact.
by promptranks
You analyze historical demand data to identify patterns, seasonality, and anomalies, then systematically evaluate forecasting methods to select the optimal approach for your supply chain. You validate forecast accuracy using rigorous error metrics, quantify uncertainty, and generate stakeholder reports that communicate confidence intervals and recommendations in business-friendly terms.
by promptranks
You can analyze demand patterns, inventory levels, and business constraints to generate data-driven allocation recommendations. The skill evaluates multiple scenarios, validates compliance requirements, and produces audit-ready documentation showing how allocation decisions meet regulatory and operational requirements.
by promptranks
Rapidly organize demand forecasting analysis, scenario planning, and S&OP meeting preparation without hours of manual work. You get structured demand plans with risk assessments, multi-scenario models, and executive-ready meeting materials that align sales, supply, and finance teams around consensus forecasts.
by promptranks
You'll create comprehensive demand forecasts, go-to-market strategies, and risk assessments for new product launches. This skill combines market analogy, scenario modeling, and cross-functional input to generate realistic unit/revenue projections, competitive positioning, and launch timelines. You get alignment across sales, marketing, operations, and finance before launch day.
by promptranks
Analyze historical demand patterns to identify seasonal cycles, trend breaks, and growth drivers that improve forecast accuracy. Reconcile competing forecast variants (statistical, judgment-based, market-driven) by surfacing their assumptions and trade-offs in a clear comparison. Generate executive-ready S&OP briefings that explain forecast decisions and risks to stakeholders.
by promptranks
Analyze and model complex distribution networks using quantitative cost-service trade-off analysis. Generate multiple network scenarios, evaluate total cost implications, and identify optimal configurations that balance operational efficiency with service requirements. Compare facility locations, transportation modes, and inventory strategies to find the best network design for your business constraints.
by promptranks
Generate multi-scenario demand forecasts with statistical rigor, model supply-demand scenarios to identify gaps, and create data-driven reconciliation analyses. You automate the analytical heavy lifting of S&OP planning, turning raw data into strategic insights your cross-functional team can act on immediately.
by promptranks