Prompt lesson · 23 prompts
Inventory Forecasting prompts for Supply Chain Managers
23 ready-to-use prompts from our AI for Supply Chain Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Inventory Turnover And Stock
Use this when you need to find slow-moving stock and align inventory levels with demand from your own data.
Role — You are a supply chain analyst who turns inventory data into clear turnover, stock-level, and forecasting insights.
Context you provide
- {{inventory_data}} — your inventory data (SKUs, stock levels, sales/turnover history) for the period and items in question
- {{items_or_categories}} — the specific items or categories to focus on
- {{demand_forecast}} — optional: projected demand you're comparing against
- {{time_frame}} — the period the analysis covers
Instructions
- Ask for missing inventory data or the time frame before starting.
- Calculate or summarize turnover rates and flag slow-moving or excess stock in the data provided.
- Compare current stock levels against projected demand, if supplied, and note gaps.
- Identify two or three root-cause hypotheses for any imbalance found (overordering, demand shift, supplier lead time).
- Recommend specific adjustments with expected impact on carrying cost or stockout risk.
Output format — A turnover/stock summary table, a gaps-and-causes section, and a prioritized recommendations list.
Guardrails
- Base all figures and trends only on the data supplied; don't invent turnover rates or demand numbers.
- Flag when external factors (seasonality, supplier issues) are likely but not confirmed by the data.
- Note where more historical data is needed for a confident recommendation.
Example — {{inventory_data}} = 12 months of SKU-level stock and sales data for 200 items; {{items_or_categories}} = electronics accessories; {{demand_forecast}} = Q3 sales projection; {{time_frame}} = last 12 months.
Open this prompt Analysis · Intermediate
Analyze Sales Trends For Inventory Planning
Use this when you need to turn sales data into trend, seasonality, and regional insights that inform inventory forecasting.
Role — You are a supply chain data analyst who optimizes for inventory-relevant insight, not a generic sales summary.
Context you provide
- {{sales_data}} — the sales data or summary you're providing (by product, region, or time period)
- {{time_frame}} — the period the data covers
- {{scope}} — what to focus on (e.g., specific product category, region, or overall trends)
Instructions
- Ask for the sales data, time frame, and scope if not provided.
- Identify significant growth or decline trends in {{sales_data}} for {{scope}} over {{time_frame}}.
- Look for seasonal or cyclical patterns and note when they occur.
- If regional data is present, compare regions and flag notable differences.
- Translate the findings into specific inventory forecasting implications (e.g., when to increase stock, which SKUs to watch).
Output format — A trends summary, then a table (product/region, trend, seasonality note, inventory implication), ending with 2–3 forecasting recommendations.
Guardrails
- Base all trends and implications strictly on {{sales_data}}; do not invent figures or assume causes not evidenced in the data.
- Flag when the {{time_frame}} may be too short to confirm a seasonal pattern.
- Note any data gaps (missing periods, incomplete regions) that limit confidence.
Example — {{sales_data}} = 3 years of monthly unit sales by SKU and region; {{time_frame}} = 2023–2025; {{scope}} = outdoor furniture category.
Open this prompt Analysis · Intermediate
Analyze Supplier Lead Times
Use this when you need to evaluate historical lead time data to improve replenishment timing.
Open this prompt Analysis · Intermediate
Build A Demand Forecast For Inventory
Use this when you need to project future demand for a product category using historical sales data and known trends.
Open this prompt Analysis · Intermediate
Calculate Dynamic Safety Stock
Use this when you need to dynamically calculate safety stock levels based on demand variability, lead times, and service level targets.
Open this prompt Analysis · Intermediate
Collaborative Forecasting Chatbot Design
Use this when you need to design a chatbot to facilitate collaborative inventory forecasting across departments.
Open this prompt Creating · Advanced
Cross-Functional Forecasting Framework
Use this when you need to develop a framework for gathering insights from sales, marketing, and other teams to improve inventory forecasting.
Open this prompt Planning · Intermediate
Demand Scenario Planning
Use this when you need to simulate different demand scenarios to proactively manage inventory and improve forecasting.
Open this prompt Analysis · Intermediate
Design Inventory Reports
Use this when you need to create clear, actionable reports and dashboards to communicate inventory forecasting insights to stakeholders.
Open this prompt Creating · Intermediate
Develop ML Forecasting Models
Use this when you want to build or improve machine learning models for inventory forecasting using historical data.
Open this prompt Coding · Advanced
Forecasting Software Evaluation
Use this when you need to evaluate and select inventory forecasting software to improve accuracy and efficiency.
Open this prompt Planning · Intermediate
Inventory Scenario Simulation
Use this when you need to simulate 'what-if' scenarios to understand their impact on inventory levels and adjust forecasting strategies.
Open this prompt Analysis · Intermediate
Monitor Forecasting Performance
Use this when you need to analyze forecasting accuracy, identify discrepancies, and improve inventory management practices.
Open this prompt Analysis · Intermediate
Optimize Inventory Levels
Use this when you need to balance carrying costs, stockouts, and service levels to improve supply chain efficiency.
Open this prompt Analysis · Intermediate
Plan Inventory Around Seasonal Demand
Use this when you need to identify seasonal demand patterns in sales data and time inventory decisions to them.
Open this prompt Planning · Intermediate
Predict Demand with Analytics
Use this when you need to forecast future demand using historical sales, market trends, and external factors to optimize inventory.
Open this prompt Analysis · Intermediate
S&OP Meeting Support Design
Use this when you need to design or enhance a chatbot to support Sales and Operations Planning (S&OP) meetings with real-time data and insights.
Open this prompt Planning · Advanced
Score Supplier Performance For Sourcing Decisions
Use this when you need to turn supplier delivery, quality and reliability data into a clear scorecard for sourcing decisions.
Open this prompt Analysis · Intermediate
Segment Demand by Customer Groups
Use this when you need to analyze customer data to segment demand for more accurate inventory forecasting.
Open this prompt Analysis · Intermediate
Segment Demand by Geography and Type
Use this when you need to segment customer demand by geography, product type, or purchasing behavior to enhance inventory forecasting.
Open this prompt Analysis · Intermediate
Sense Demand from Social Data
Use this when you need to analyze customer conversations and social media to identify emerging demand patterns and adjust forecasts.
Open this prompt Analysis · Advanced
Sense Demand with Real-Time Data
Use this when you need to leverage real-time market data, customer feedback, and external factors to sense demand changes and adjust inventory.
Open this prompt Analysis · Advanced
Supply Chain Risk Assessment
Use this when you need to identify and mitigate risks that could disrupt your supply chain and affect inventory forecasting accuracy.
Open this prompt Analysis · Intermediate