DEV Community

ClawGear
ClawGear

Posted on

35 ChatGPT Prompts for Supply Chain Planners: Optimize Forecasts, Reduce Risk, and Move Faster

#ai #chatgpt #career #productivity

Supply chain planners operate at the intersection of data, uncertainty, and operational urgency. From demand forecasting and inventory optimization to supplier risk and S&OP facilitation, the job demands analytical depth and cross-functional communication at the same time. These 35 prompts help supply planners use AI to accelerate analysis, improve decision frameworks, and communicate insights with clarity.

1. Demand Forecasting and Planning 

I have 24 months of historical sales data for a SKU with strong seasonality and a recent product relaunch that changed the demand baseline. Walk me through a step-by-step approach to build a reliable forecast, including how to handle the structural break from the relaunch.
Enter fullscreen mode Exit fullscreen mode 
Explain the differences between moving average, exponential smoothing, and ARIMA forecasting methods. For each, describe the ideal use case, the data requirements, and the key parameter I need to tune.
Enter fullscreen mode Exit fullscreen mode 
My forecast accuracy is consistently poor for new product introductions (NPIs). What are the best practices for forecasting NPIs when there is no historical data? Include approaches like analogous product mapping, market research inputs, and phase-in curves.
Enter fullscreen mode Exit fullscreen mode 
Create a demand review meeting agenda template for a monthly S&OP cycle. Include sections for statistical baseline review, commercial overrides, new product pipeline, and consensus forecast sign-off.
Enter fullscreen mode Exit fullscreen mode 
I need to present forecast error analysis to senior leadership. Explain the difference between MAPE, WMAPE, and bias metrics, when each is most appropriate, and how to visualize them in a way that non-technical stakeholders will understand.
Enter fullscreen mode Exit fullscreen mode

2. Inventory Optimization 

Explain how to calculate safety stock using the standard deviation of demand and lead time variability. Provide the formula, define each variable, and give a worked numerical example for a SKU with a 95% service level target.
Enter fullscreen mode Exit fullscreen mode 
I manage 5,000 SKUs across three distribution centers. Outline an ABC-XYZ segmentation framework I can apply to prioritize my planning effort and set differentiated inventory policies for each segment.
Enter fullscreen mode Exit fullscreen mode 
We are experiencing a buildup of slow-moving and obsolete inventory (SLOB). Design a decision framework for classifying SLOB, escalating to commercial teams, and recommending disposition options (liquidation, rework, donation, write-off).
Enter fullscreen mode Exit fullscreen mode 
Walk me through a min/max replenishment policy setup for a distribution center. What inputs do I need, how do I calculate the min and max levels, and how should I review and refresh them over time?
Enter fullscreen mode Exit fullscreen mode 
Our fill rate has dropped from 97% to 91% over the last quarter despite inventory levels staying flat. List the most common root causes I should investigate and the diagnostic data I should pull to identify the issue.
Enter fullscreen mode Exit fullscreen mode

3. Supplier and Procurement Planning 

I need to evaluate three potential suppliers for a critical component. Create a supplier scorecard template with weighted criteria covering cost, quality, lead time reliability, financial stability, geographic risk, and sustainability.
Enter fullscreen mode Exit fullscreen mode 
One of our key single-source suppliers just informed us they cannot fulfill our next two months of purchase orders. Walk me through an emergency supply continuity playbook: immediate actions, communication steps, alternative sourcing options, and customer prioritization.
Enter fullscreen mode Exit fullscreen mode 
Explain the concept of supply chain tiering (Tier 1, Tier 2, Tier 3 suppliers) and why visibility beyond Tier 1 matters for risk management. What tools and approaches can planners use to gain sub-tier visibility?
Enter fullscreen mode Exit fullscreen mode 
Draft a supplier performance review agenda for a quarterly business review (QBR) with a critical contract manufacturer. Include KPI review, root cause analysis of misses, joint action planning, and forward-looking capacity confirmation.
Enter fullscreen mode Exit fullscreen mode 
I want to introduce a vendor-managed inventory (VMI) program with our top three suppliers. Outline the key design elements, data sharing requirements, contractual considerations, and change management steps.
Enter fullscreen mode Exit fullscreen mode

4. Risk Management and Resilience 

Conduct a supply chain risk assessment framework for a manufacturing company with suppliers in Southeast Asia. Categorize risks by type (geopolitical, natural disaster, logistics, financial), likelihood, and impact, and suggest mitigation strategies for the top five risks.
Enter fullscreen mode Exit fullscreen mode 
Our supply chain team needs to build a business continuity plan (BCP) for our top 10 critical components. What information should be in each component's BCP, and how should we prioritize recovery time objectives?
Enter fullscreen mode Exit fullscreen mode 
Explain the concept of supply chain resilience versus efficiency, the classic tradeoffs, and how companies are rebalancing toward resilience post-pandemic. What metrics can I use to measure resilience?
Enter fullscreen mode Exit fullscreen mode 
We are considering nearshoring part of our supply base from Asia to Mexico. Outline the cost-benefit analysis framework I should use, including total landed cost modeling, lead time reduction benefits, tariff considerations, and transition risks.
Enter fullscreen mode Exit fullscreen mode 
Design a supply chain scenario planning exercise for our annual strategic planning process. Include three scenarios (optimistic, base, pessimistic), the key assumptions that differentiate them, and how each scenario should translate into supply plan adjustments.
Enter fullscreen mode Exit fullscreen mode

5. S&OP and Cross-Functional Collaboration 

Write a one-page executive summary template for a monthly S&OP cycle that I can use to brief the CEO and CFO. Include sections for demand vs. plan, supply constraints, inventory position, financial bridge, and top decisions required.
Enter fullscreen mode Exit fullscreen mode 
Our S&OP process is siloed — sales submits optimistic forecasts, operations builds conservatively, and finance uses a third number. Draft a facilitation guide for a consensus-building workshop to align these three functions on a single operating plan.
Enter fullscreen mode Exit fullscreen mode 
Explain the difference between S&OP (Sales and Operations Planning) and IBP (Integrated Business Planning). What capabilities and maturity level does a company need to evolve from S&OP to IBP?
Enter fullscreen mode Exit fullscreen mode 
I need to present a capacity constraint to our commercial team that will require us to allocate short supply across customers. Draft talking points and a proposed allocation methodology that balances profitability, customer relationships, and contractual commitments.
Enter fullscreen mode Exit fullscreen mode 
Create a RACI matrix for the monthly S&OP process covering the demand review, supply review, pre-S&OP, and executive S&OP meetings. Include roles for supply planner, demand planner, sales director, finance, and operations.
Enter fullscreen mode Exit fullscreen mode

6. Data Analysis and Tools 

I work in Excel and want to build a simple inventory health dashboard. List the key metrics to include, the formulas I need, and how to structure the data model so the dashboard updates automatically when I refresh the source data.
Enter fullscreen mode Exit fullscreen mode 
Explain how to use a Monte Carlo simulation to model demand uncertainty in a supply plan. What inputs do I need, what does the output look like, and how do I translate the simulation results into a safety stock recommendation?
Enter fullscreen mode Exit fullscreen mode 
Our team is evaluating supply chain planning software (e.g., Blue Yonder, Kinaxis, o9, SAP IBP). What are the key capability dimensions I should evaluate, and what questions should I ask vendors during demos to expose real-world weaknesses?
Enter fullscreen mode Exit fullscreen mode 
I have a large dataset of purchase orders, receipts, and invoice dates. Walk me through how to calculate supplier on-time delivery (OTD) performance and lead time variability using Python pandas, including the key columns I need and the step-by-step logic.
Enter fullscreen mode Exit fullscreen mode 
Explain the bullwhip effect: what causes it, how to quantify it, and what supply chain design and process changes most effectively reduce it. Give examples from retail and manufacturing contexts.
Enter fullscreen mode Exit fullscreen mode

7. Career Development and Communication 

I am a supply chain planner preparing for an interview for a Senior Supply Chain Manager role. Generate 10 behavioral interview questions focused on supply chain planning, and for each question provide a framework for structuring a strong STAR-method answer.
Enter fullscreen mode Exit fullscreen mode 
Help me write a LinkedIn summary for a supply chain planner with 7 years of experience in consumer goods, specializing in demand planning and S&OP. Emphasize quantifiable achievements, systems experience (SAP APO, Kinaxis), and cross-functional leadership.
Enter fullscreen mode Exit fullscreen mode 
I need to write a post-mortem report for a major stockout event that caused $2M in lost sales. Draft a structured report template including executive summary, timeline of events, root cause analysis (using 5 Whys), corrective actions, and preventive measures.
Enter fullscreen mode Exit fullscreen mode 
Create a 30-60-90 day onboarding plan for a new supply chain planner joining a mid-size manufacturing company. Include learning objectives, key stakeholder meetings, quick-win projects, and 90-day performance milestones.
Enter fullscreen mode Exit fullscreen mode 
I want to mentor a junior planner on how to improve their analytical thinking. Design a 4-week structured mentoring curriculum with weekly themes, recommended exercises, and discussion questions that build from data literacy to strategic supply chain thinking.
Enter fullscreen mode Exit fullscreen mode

Get All 35 Prompts in One Place

If these prompts were useful, I've compiled all 35 into a ready-to-use toolkit with bonus prompts and usage notes.

Get the complete AI Prompt Toolkit for this profession →

Works with ChatGPT, Claude, and DeepSeek.

Top comments (0)