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
This skill systematically evaluates RFQ responses across multiple dimensions—price, quality, delivery, capability, and risk—to generate scoring matrices, risk assessments, and supplier rankings. You'll make data-driven sourcing decisions with transparent methodology and reduce vendor bias through weighted evaluation criteria aligned to your procurement priorities.
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.
You can analyze historical demand patterns, generate statistical forecasts with explicit assumptions, and create best/base/worst-case scenarios for supply chain planning. The skill evaluates demand seasonality, trends, and volatility to produce actionable forecasts with confidence intervals. Your results include documented methodology, key assumptions, and specific recommendations for inventory and production planning.
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 provide historical sales data, supplier lead times, and market context—Claude analyzes patterns, detects seasonality, and generates demand forecasts with confidence intervals. You get actionable inventory recommendations, scenario projections, and early warnings for demand anomalies to optimize stock levels and reduce waste.
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 analyze your historical sales data, demand patterns, and inventory metrics to identify optimal stock levels, reorder points, and safety stock quantities. The skill integrates with your ERP system's data to reduce excess inventory, prevent stockouts, and provide cost-benefit analysis for inventory decisions. You get actionable recommendations on ABC analysis, seasonal adjustments, and inventory turnover optimization.
This skill guides you through structured demand forecasting and launch planning when you have limited historical data for a new product. It builds multiple demand scenarios using comparable products, market signals, and validated growth curves, then creates cross-functional alignment frameworks to stress-test your assumptions and reduce launch risk.