Demand Planning Analyst
Accelerate demand forecasts with AI-driven scenario analysis and insights
What You Can Do
This skill transforms demand planning by automating data interpretation, running rapid scenario analyses, and generating stakeholder-ready forecasts. You can interpret complex sales patterns, test multiple demand scenarios in minutes instead of weeks, and communicate forecasts with confidence intervals and risk assessments. Compress your planning cycle from weeks to days while increasing forecast accuracy and cross-functional alignment.
Features
Automatically identify trends, seasonality, cyclical patterns, and anomalies in historical sales data to inform baseline forecasts.
Generate conservative, base, and aggressive demand scenarios with supporting assumptions and revenue impact analysis.
Create executive summaries, presentation decks, and risk summaries formatted for board meetings and cross-functional reviews.
Compare new forecasts against historical accuracy, identify outliers, and flag assumptions that need review.
Organize forecast assumptions, track stakeholder feedback, and document consensus decisions across sales, marketing, and operations.
Quantify how changes in key drivers (pricing, market share, seasonality) impact overall demand and revenue.
Highlight unusual patterns, missing data, or anomalies that require human expertise before finalizing forecasts.
Example Output
Forecast Summary
- Base Case: 12,500 units Q4 (margin: ±8%)
- Upside: 15,200 units (if market share grows 2%)
- Downside: 10,800 units (if supply chain disruptions continue)
Key Drivers Impacting Demand
- Seasonal lift typically peaks mid-October (35% above avg)
- New product launch expected to increase volume 12%
- Competitive pricing pressure may reduce share by 3-5%
Stakeholder Brief Recommend base-case planning with inventory buffers for upside. Monitor competitor announcements weekly. Market conditions favor Q4 performance if supply remains stable.
Risk Assessment
- ⚠️ Supply chain delays: High impact, Medium probability — mitigation needed ✓ Seasonality: Predictable, well-modeled
- ⚠️ Price elasticity: Untested at new discount levels — recommend A/B test
What's Included
- Forecast Interpretation Templates: Ready-to-use prompts for analyzing sales CSV files, identifying patterns, and extracting insights without manual pivot tables.
- Scenario Modeling Frameworks: Pre-built templates for best-case, base-case, and worst-case scenarios with standard assumption structures.
- Stakeholder Briefing Generator: Formats forecast insights into executive summaries, board-ready visuals, and risk/opportunity statements.
- Data Validation Checklists: Quality gates to verify input data completeness, outlier detection, and forecast reasonableness checks.
- Forecast Accuracy Tracker: Historical comparison framework to monitor forecast vs. actual performance and improve future model calibration.
Who It's For
- Demand Planners
- Supply Chain Managers
- Sales Operations Analysts
- Business Forecasting Leads
- Production Planning Teams
Best For
- Quarterly demand forecasting cycles
- What-if scenario analysis for strategic decisions
- Communicating forecasts to executive leadership
- Demand volatility and risk assessment
- Cross-functional planning and consensus building
You might also like
You'll create comprehensive, data-driven vendor negotiation briefs that synthesize vendor background, pricing history, market position, and negotiation leverage into a concise, actionable brief. The skill analyzes your vendor context and generates talking points, risk assessments, and strategic recommendations tailored to your negotiation objectives.
You can map your entire supply chain network, identify bottlenecks and inefficiencies, and model optimization scenarios. This skill helps you visualize supplier relationships, distribution channels, and logistics flows to find cost savings and reduce delivery times. You'll get actionable recommendations backed by network analysis and scenario modeling.
You can feed support ticket data, interaction logs, and customer engagement metrics into Claude, which automatically surfaces churn risk signals—declining engagement patterns, sentiment shifts toward frustration, feature adoption gaps, and escalation trajectories. Claude generates risk scores (Critical/High/Medium/Low) with specific evidence and recommends targeted interventions before customers reach the cancellation stage.
This skill quickly analyzes inventory discrepancies from cycle counts, pinpoints the likely root causes, and recommends specific corrective actions to improve accuracy. You can upload count data, review detailed variance breakdowns by location or SKU, and get actionable insights to close gaps in your inventory management.
You can analyze supplier performance across multiple dimensions, identify improvement opportunities, and develop collaborative action plans that strengthen your supply chain. Claude evaluates supplier capabilities, financial health, delivery performance, and quality metrics to surface risks early, then structures targeted development initiatives that drive mutual value creation and reduce supply chain vulnerability.
This skill analyzes complex supply chain networks to identify optimization opportunities across cost, service levels, and environmental impact. You can model network changes, evaluate supplier alternatives, and forecast the impact of disruptions before implementation. It provides data-driven recommendations for network redesign, inventory rebalancing, carrier selection, and sustainability improvements.
Analyze supplier capabilities and proposals using structured evaluation frameworks that score vendors across cost, quality, delivery, and risk dimensions. Claude builds comprehensive negotiation strategies with quantified leverage points, walkaway prices, and contract optimization recommendations. You'll reduce material costs by 10-20% while minimizing supply chain risks through data-driven decision-making.
You can analyze shipping expenses across multiple carriers, identify cost-saving opportunities, and evaluate carrier performance metrics to reduce logistics expenses. The skill compares rates, delivery times, reliability scores, and service quality to help you negotiate better contracts and make data-driven carrier selection decisions.