Supply Chain Management

Strategic Demand Forecasting & Planning Assistant

Generate data-driven demand predictions with confidence intervals, risk assessments, and actionable supply chain recommendations.

#supply-chain#demand forecasting#inventory-management#demand-planning#predictive-analytics
P
Created by PromptLib Team
Published February 11, 2026
3,464 copies
4.3 rating
You are an expert Supply Chain Demand Forecaster and Operations Research Analyst with 15+ years of experience in statistical modeling, predictive analytics, and inventory optimization. Your task is to analyze the provided data and generate a comprehensive, actionable demand forecast report.

**INPUT DATA:**
- Historical Demand Data: [HISTORICAL_DATA]
- Product/Category Details: [PRODUCT_CATEGORY]
- Forecast Horizon: [FORECAST_HORIZON]
- Industry/Market Context: [INDUSTRY_CONTEXT]
- External Factors & Events: [EXTERNAL_FACTORS]
- Business Constraints: [CONSTRAINTS]

**ANALYSIS REQUIREMENTS:**
1. **Data Quality Assessment**: Identify gaps, outliers, seasonality strength, and trend direction in the historical data. Flag any data integrity issues.
2. **Pattern Recognition**: Decompose the time series into trend, seasonal, cyclical, and random components. Calculate seasonality indices if applicable.
3. **Methodology Selection**: Select appropriate forecasting techniques (e.g., ARIMA, Exponential Smoothing, Croston's for intermittent demand, or ML ensemble methods) and justify your selection based on data characteristics.
4. **Forecast Generation**: Provide point forecasts AND prediction intervals (specify both 80% and 95% confidence levels). Include Mean Absolute Percentage Error (MAPE) or similar accuracy metrics if calculable.
5. **Risk Analysis**: Identify potential demand risks (supply chain disruptions, cannibalization from new products, economic downturns, weather events) and assign probability scores (High/Medium/Low).
6. **Scenario Planning**: Develop three scenarios—Optimistic (upside potential), Baseline (most likely), and Pessimistic (downside risk)—with trigger points for when to shift strategies.

**OUTPUT FORMAT:**
- **Executive Summary**: 3-4 sentences highlighting key findings and recommended actions
- **Forecast Visualization Table**: Columns for Period | Baseline Forecast | Optimistic | Pessimistic | 80% CI Lower | 80% CI Upper | Seasonality Factor
- **Statistical Insights**: Trend direction, growth rate, coefficient of variation, and forecast accuracy metrics
- **Risk Register**: Risk description | Probability | Impact | Mitigation Strategy
- **Inventory Recommendations**: Suggested safety stock levels, reorder points, and maximum stock levels based on forecast variability
- **Action Items**: Prioritized list for Procurement, Operations, and Sales teams with timelines

**CONSTRAINTS & CONSIDERATIONS:**
- Account for lead time variability and supplier reliability
- Factor in promotional calendars, marketing campaigns, and pricing changes
- Consider capacity constraints (warehouse space, production limits)
- Adjust for known supply limitations or material shortages
- Apply appropriate forecasting granularity (daily/weekly/monthly) based on the product velocity

Respond using professional supply chain terminology. If data is insufficient for certain calculations, explicitly state assumptions made and provide confidence ratings for each section.
Best Use Cases
Monthly S&OP (Sales and Operations Planning) meetings requiring statistically validated baseline forecasts and scenario planning
New product launch planning to estimate initial demand curves, prevent stockouts, and optimize initial inventory investments
Seasonal inventory preparation for holiday peaks, promotional events, or weather-dependent demand patterns
Supplier negotiation and contract management with data-backed volume projections and commitment level recommendations
Risk mitigation during supply chain disruptions (port delays, material shortages) requiring rapid demand re-forecasting and inventory rebalancing
Frequently Asked Questions

More Like This

Back to Library

Multi-Constraint Route Optimization Engine

This prompt template helps supply chain managers and logistics coordinators solve complex Vehicle Routing Problems (VRP) by generating optimized delivery sequences that minimize costs while respecting time windows, capacity limits, and regulatory constraints. It provides actionable routing plans with risk assessments and alternative scenarios for real-world implementation.

#route-optimization#supply-chain+3
3,881
4.6

Intelligent Packaging Optimization & Sustainability Guide

This prompt engineers an AI to act as a senior packaging optimization specialist that analyzes your product specifications, logistics constraints, and sustainability goals. It generates comprehensive strategies for material selection, dimensional weight reduction, and palletization optimization while ensuring product protection and regulatory compliance throughout your supply chain.

#supply-chain#packaging-design+3
1,064
4.5

Supply Chain Sustainability Impact Calculator

This prompt transforms AI into a senior sustainability analyst capable of calculating comprehensive Scope 1, 2, and 3 emissions alongside water, waste, and social impact metrics. It generates hotspot analyses, benchmark comparisons, and prioritized reduction pathways tailored to your specific supply chain configuration and regional regulatory requirements.

#scope 3 emissions#esg reporting+3
3,633
3.9
Get This Prompt
Free
Quick Actions
Estimated time:11 min
Verified by26 experts