Prompt lesson · 20 prompts
Demand Forecasting for Production prompts for Production Planners
20 ready-to-use prompts from our AI for Production Planners course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Collection for Demand Forecasting
Use this when you need to gather and analyze data from multiple sources to inform demand forecasting.
Role You are a data analyst specializing in demand forecasting. Your goal is to collect and analyze relevant data to identify patterns and trends that inform production planning.
Context you provide
- {{data_sources}}: List of databases, platforms, or files containing historical sales, market trends, or customer feedback.
- {{time_period}}: The time range for data collection (e.g., past five years, last quarter).
- {{industry}}: The industry or sector for market trend analysis.
Instructions
- Ask for any missing information from the context above before starting.
- Collect data from the provided sources, ensuring it is relevant to demand forecasting.
- Analyze the data to identify patterns, trends, and anomalies.
- For customer feedback, categorize themes and sentiments.
- Present findings in a structured format, highlighting key insights.
Output format Provide a comprehensive report with sections for historical sales analysis, market trends, and customer feedback insights. Use bullet points and tables where appropriate. Keep the tone professional and concise.
Guardrails
- Do not invent data; only use provided sources.
- Flag any assumptions about data completeness or reliability.
- Stay within the scope of demand forecasting data collection and analysis.
Example Data sources: sales database, market reports, social media; time period: past year; industry: consumer electronics.
Open this prompt Analysis · Intermediate
Statistical Demand Forecasting
Use this when you need to build or refine statistical models to forecast demand from historical data.
Role You are a data scientist specializing in demand forecasting and statistical modeling. Your goal is to help me select and apply appropriate models to forecast demand accurately and explain the results in business terms.
Context you provide
- {{historical_demand_data}}: A dataset with historical demand values and relevant dates (e.g., daily, weekly, monthly).
- {{product_or_service}}: The product or service being forecast.
- {{modeling_goal}}: The specific objective, such as short-term vs. long-term forecasting, or identifying key demand drivers.
- {{preferred_techniques}}: Optional: any specific methods you want to explore (e.g., ARIMA, regression, random forest).
Instructions
- Ask for missing inputs if necessary.
- Explore the data for trends, seasonality, and outliers.
- Based on the goal, apply appropriate statistical techniques: time series analysis (e.g., ARIMA, exponential smoothing), regression analysis, or machine learning models (e.g., random forest, gradient boosting).
- Evaluate model performance using relevant metrics (e.g., MAE, RMSE) and compare models if multiple are used.
- Provide actionable insights: which factors drive demand, and what forecast accuracy can be expected.
Output format Deliver a structured report with sections: Data Overview, Model Selection, Results, and Recommendations. Include equations or model descriptions in plain language, and use tables for metrics. Keep the tone technical yet accessible.
Guardrails
- Do not fabricate data or results; base everything on the provided dataset.
- Clearly state assumptions about data quality and model limitations.
- Do not overcomplicate; recommend the simplest model that meets the forecasting goal.
Example
- {{historical_demand_data}}: "Monthly sales units for our software subscriptions from Jan 2021 to Dec 2024"
- {{product_or_service}}: "Software subscriptions"
- {{modeling_goal}}: "Forecast next 6 months and identify key drivers like marketing spend."
- {{preferred_techniques}}: "Try ARIMA and random forest."
Open this prompt Analysis · Advanced
Generate Demand Forecasts
Use this when you need to create demand forecasts for different time periods based on historical data and market factors.
Open this prompt Analysis · Intermediate
Seasonality Pattern Analysis
Use this when you need to analyze historical data to uncover seasonal demand patterns and their implications for forecasting.
Open this prompt Analysis · Intermediate
Segment Demand by Customer Groups
Use this when you need to understand demand patterns across different customer segments, regions, or channels.
Open this prompt Analysis · Intermediate
Analyze Demand Sensitivity to Changes
Use this when you need to evaluate how changes in price, promotions, or other factors affect demand.
Open this prompt Analysis · Advanced
Evaluate Forecast Accuracy
Use this when you need to measure how accurate your demand forecasts are against actual sales.
Open this prompt Analysis · Intermediate
Cross-Team Demand Collaboration
Use this when you need to improve communication and alignment on demand forecasts across teams.
Open this prompt Communication · Intermediate
Plan Demand Scenarios
Use this when you need to assess the impact of different market conditions, product launches, or supply chain disruptions on demand.
Open this prompt Planning · Advanced
Demand Forecasting Reports and Visualizations
Use this when you need to create clear reports and visualizations of demand forecasts for decision-making.
Open this prompt Creating · Intermediate
Analyze Historical Production Data
Use this when you need to uncover patterns and trends in historical production data to improve demand forecasting.
Open this prompt Analysis · Intermediate
Incorporate Market Research into Forecasting
Use this when you need to integrate market trends, customer preferences, and competitor analysis into your demand forecasting.
Open this prompt Research · Advanced
Seasonal Demand Analysis
Use this when you need to identify seasonal patterns in demand and adjust production plans accordingly.
Open this prompt Analysis · Intermediate
Sense Real-Time Demand Signals
Use this when you need to monitor external signals like customer feedback and social media to adjust production plans in real time.
Open this prompt Analysis · Advanced
Collaborative Forecasting Facilitation
Use this when you need to improve cross-departmental collaboration on demand forecasting to align on assumptions and improve accuracy.
Open this prompt Planning · Intermediate
Forecast Demand with Predictive Analytics
Use this when you need to leverage predictive modeling to forecast future demand based on historical data and market conditions.
Open this prompt Analysis · Advanced
Shape Demand with Pricing and Promotions
Use this when you need to influence customer demand through pricing, promotions, or product launch strategies to optimize production planning.
Open this prompt Planning · Intermediate
Forecast Accuracy Monitoring
Use this when you need to compare actual sales with forecasted values to improve forecasting accuracy.
Open this prompt Analysis · Intermediate
Optimize Inventory Levels
Use this when you need to determine optimal inventory levels to balance stockouts and excess stock based on forecasts and capacity.
Open this prompt Analysis · Intermediate
Supplier Collaboration for Demand Alignment
Use this when you need to align production plans with suppliers based on demand forecasts.
Open this prompt Communication · Intermediate