AI Prompts for Supply Chain Managers: Forecasting, Logistics, Risk

Published: July 2026 | 8 min read

Supply chain managers orchestrate the flow of goods, information, and money across organizations and continents. AI can help you forecast demand, optimize inventory, evaluate suppliers, and plan for disruptions — if your prompts understand that supply chain is not just logistics, it is the nervous system of global commerce.

Demand Forecasting

1. Demand Forecasting Model Brief

Role: Supply chain demand planning analyst
Task: Create a demand forecasting brief for [product/category].
Product: [Name, SKU, category, current monthly volume]
Historical data: [Paste 12-24 months of sales data, or describe trends]
Factors to consider:
1. Seasonality (monthly/quarterly patterns, holiday spikes)
2. Trend (growing/declining/stable — at what rate?)
3. Promotions (upcoming marketing campaigns, price changes)
4. External factors (market trends, competitor actions, economic indicators)
5. New product launches or discontinuations in the same category
Output:
1. Forecast method recommendation (moving average, exponential smoothing, ARIMA, ML model — with rationale)
2. 6-month forecast (month by month, with confidence intervals)
3. Key assumptions (what the forecast depends on)
4. Risk factors (what could make actual demand deviate)
5. Data requirements (what data would improve this forecast?)
6. Review schedule (when to revisit and adjust)
Format: Forecasting brief for the S&OP meeting.

2. Sales & Operations Planning (S&OP) Scenario Generator

Role: S&OP facilitator and supply chain strategist
Task: Generate S&OP scenarios for [product family / business unit].
Current state:
- Demand: [current monthly units]
- Capacity: [current production capacity]
- Inventory: [current days of supply]
- Lead time: [supplier lead time in weeks]
- Constraints: [any bottlenecks or limitations]
Generate 3 scenarios:
Scenario 1 — Base Case (most likely):
1. Demand assumption (with growth rate)
2. Production plan (units per month for 6 months)
3. Inventory target (days of supply)
4. Supply requirements (raw materials, components)
5. Risk level: [Low/Medium/High]
Scenario 2 — Upside (demand 20% higher than base):
1. What needs to change (capacity, staffing, supply)
2. Cost implications (overtime, expedited freight, premium supply)
3. Timeline to scale (how fast can we respond?)
4. Decision triggers (what signals tell us to activate this plan?)
Scenario 3 — Downside (demand 20% lower than base):
1. What needs to change (reduced production, inventory drawdown)
2. Cost implications (underutilization, potential layoffs, contract penalties)
3. Protection plan (how to minimize damage)
4. Decision triggers (what signals tell us to activate this plan?)
For each scenario:
1. Monthly plan table (demand, production, inventory, supply needs)
2. Financial impact (revenue, margin, working capital)
3. Key decisions needed (what must leadership approve?)
Format: S&OP scenario pack ready for the monthly executive review.

3. Forecast Accuracy Analyzer

Role: Supply chain analytics specialist
Task: Analyze forecast accuracy for [product/category/period].
Data: [Paste actual vs forecast for last 12 months — month, forecast, actual]
Metrics to calculate:
1. Forecast Error (Actual - Forecast) per month
2. Absolute Error (|Actual - Forecast|) per month
3. MAPE (Mean Absolute Percentage Error) — overall and by month
4. Bias (consistent over-forecast or under-forecast?)
5. Tracking Signal (is the forecast drifting?)
Analysis:
1. Accuracy trend (getting better or worse over time?)
2. Worst months (which months had highest error? what was happening then?)
3. Bias identification (systematic over/under forecasting?)
4. Root cause hypotheses (promotions not accounted for? new product? seasonality shift?)
5. Improvement recommendations:
   - Forecast method change (if consistently wrong)
   - Data improvement (what data is missing?)
   - Cadence change (forecast more frequently? less?)
   - Granularity change (forecast by SKU vs by category?)
Format: Forecast accuracy report with monthly table, metrics, and recommendations.

Inventory Management

4. Inventory Optimization Plan

Role: Inventory optimization specialist
Task: Create an inventory optimization plan for [product portfolio].
Data: [Paste or describe: SKUs, current inventory levels, demand, lead times, costs]
For each SKU category (A/B/C by volume or value):
1. Current state:
   - Days of supply (current inventory / daily demand)
   - Carrying cost (annual % of inventory value)
   - Stockout frequency (how often does this SKU run out?)
   - Obsolescence risk (how likely is this to become dead stock?)
2. Target state:
   - Safety stock level (formula: Z x σ x √L, where Z=service level, σ=demand std dev, L=lead time)
   - Reorder point (safety stock + demand during lead time)
   - Order quantity (EOQ or policy-based)
   - Target days of supply
3. Actions:
   - Reduce (which SKUs have too much? by how much? what to do with excess?)
   - Increase (which SKUs need more? how much? when?)
   - Discontinue (which SKUs should be phased out?)
   - Consolidate (which SKUs can be merged?)
4. Financial impact:
   - Current carrying cost ($)
   - Optimized carrying cost ($)
   - Savings ($ and %)
   - One-time cost to optimize (expedite some, dispose of others)
Format: Inventory optimization plan with SKU-level recommendations.

5. Safety Stock Calculator

Role: Supply chain inventory planner
Task: Calculate safety stock levels for [list of SKUs].
For each SKU:
Inputs needed:
1. Average daily demand (units)
2. Demand standard deviation (units)
3. Lead time (days)
4. Lead time variability (standard deviation in days, if available)
5. Target service level (95%? 99%? — what is the cost of a stockout?)
6. Review period (how often do we reorder? days)
Calculations:
1. Safety stock = Z × σ_demand × √(lead time + review period)
   Where Z = 1.645 for 95%, 2.326 for 99%, 1.96 for 97.5%
2. Reorder point = (avg daily demand × lead time) + safety stock
3. Max inventory = reorder point + order quantity
4. Expected stockouts per year (based on service level)
5. Annual carrying cost of safety stock ($)
Output per SKU:
1. Current safety stock
2. Recommended safety stock
3. Change needed (+/- units)
4. Service level achieved (current vs recommended)
5. Annual cost impact
Also provide:
1. Sensitivity analysis (what if demand variability increases by 20%?)
2. Service level recommendation (which SKUs need 99% vs 95% vs 90%?)
Format: Safety stock calculation table with recommendations.

Supplier & Vendor Management

6. Supplier Risk Assessment

Role: Supply chain risk analyst
Task: Conduct a supplier risk assessment for [supplier name or list].
Suppliers: [List with: name, category, annual spend, criticality, location, alternatives]
For each supplier:
1. Financial Risk:
   - Company health (public? private? recent news?)
   - Concentration risk (what % of our spend is with them? what % of their revenue is us?)
   - Payment terms and trends (are they tightening?)
2. Operational Risk:
   - Lead time performance (on-time delivery rate)
   - Quality performance (defect rate, return rate)
   - Capacity (can they scale if we grow? do they have backup capacity?)
   - Single source? (if they stop, can we get it elsewhere? how fast?)
3. Geographic Risk:
   - Location (political stability, natural disaster exposure, trade restrictions)
   - Distance (how far are they? what logistics risks?)
   - Multi-location? (do they have backup facilities?)
4. Relationship Risk:
   - How long have we worked together?
   - Contract terms (lock-in? exit clauses? penalties?)
   - Communication quality (responsive? transparent?)
   - Strategic alignment (do they invest in our success?)
5. Risk Score (1-5 per dimension, weighted by criticality)
6. Mitigation plan:
   - Dual source? (identify and qualify alternative suppliers)
   - Safety stock? (how much to buffer?)
   - Contract changes? (what to negotiate?)
   - Monitoring? (what to watch and how often?)
Format: Supplier risk scorecard with mitigation recommendations.

7. Supplier Negotiation Prep

Role: Procurement negotiation strategist
Task: Prepare a negotiation brief for [supplier name, category].
Current state:
- Supplier: [name, what they provide, annual spend, contract renewal date]
- Current pricing: [unit price, volume discounts, payment terms]
- Market intelligence: [competitor pricing, raw material trends, market dynamics]
- Switching cost: [what would it cost/time to change suppliers?]
Negotiation brief:
1. Our objectives (ranked):
   - Price reduction (target % — with rationale from market data)
   - Terms improvement (payment terms, delivery terms, quality guarantees)
   - Service levels (lead time, on-time delivery, minimum order quantity)
   - Strategic items (innovation, exclusivity, joint development)
2. Their likely position:
   - What do they want? (price increase? volume commitment? longer contract?)
   - What are their constraints? (capacity, cost structure, margin pressure?)
   - What are their alternatives? (can they replace our volume?)
3. Leverage points:
   - Our volume / growth trajectory
   - Competitor pricing benchmarks
   - Market alternatives we have qualified
   - Total value of relationship (not just this contract)
4. Concession ladder (what we give to get):
   - What we can offer (longer contract, larger volume, better payment terms, reference)
   - What we want in return (price reduction, better terms, service levels)
5. Walk-away point (at what point is the deal not worth it?)
6. BATNA (Best Alternative To Negotiated Agreement — what if we walk away?)
Format: Negotiation brief for the category manager.

8. Vendor Scorecard Generator

Role: Supplier performance management specialist
Task: Create a vendor scorecard for [supplier category].
Metrics by category (weight in parentheses):
Quality (25%):
- Defect rate (PPM or %)
- First-pass yield
- Quality complaints (count and severity)
- Corrective action responsiveness
Delivery (25%):
- On-time delivery rate (target: 95%+)
- Lead time adherence (actual vs promised)
- Order fill rate (complete orders / total orders)
- Late delivery frequency
Cost (20%):
- Price competitiveness (vs market and vs last year)
- Cost reduction track record (year-over-year)
- Total cost of ownership (not just unit price)
- Invoice accuracy
Service (15%):
- Responsiveness (how fast do they respond to inquiries?)
- Technical support (do they help solve problems?)
- Flexibility (can they handle rush orders? design changes?)
- Communication quality (proactive vs reactive?)
Innovation (10%):
- New product/process suggestions
- Technology investments
- Joint improvement initiatives
ESG (5%):
- Environmental compliance
- Labor practices
- Certifications (ISO, sustainability)
For each metric:
1. Target (what good looks like)
2. Current performance
3. Score (1-5)
4. Weighted score
5. Trend (improving/stable/declining)
Output: Supplier scorecard with overall rating and improvement recommendations.

Risk & Disruption Planning

9. Supply Chain Risk Register

Role: Supply chain risk manager
Task: Create a risk register for [supply chain / product line / region].
Risk categories:
1. Supply risks (supplier failure, raw material shortage, price spike)
2. Demand risks (demand drop, demand spike, customer loss)
3. Logistics risks (port closure, carrier failure, customs delay)
4. Operational risks (plant fire, system outage, quality failure)
5. Financial risks (currency, payment terms, supplier bankruptcy)
6. Geopolitical risks (trade war, sanctions, conflict, regulation)
7. Natural risks (earthquake, flood, hurricane, pandemic)
For each risk:
1. Risk ID (R-001 format)
2. Description (what could happen)
3. Probability (1-5: rare, unlikely, possible, likely, almost certain)
4. Impact (1-5: negligible, minor, moderate, major, severe)
5. Risk score (probability × impact)
6. Velocity (how fast would this happen? days, weeks, months?)
7. Early warning indicators (what to watch for)
8. Mitigation strategy (prevent, reduce, transfer, accept)
9. Mitigation actions (specific, with owner and timeline)
10. Response plan (if it happens — what do we do immediately?)
11. Recovery plan (how to get back to normal)
12. Review date (when to revisit)
Format: Risk register table sorted by risk score (highest first).
Include: Top 5 risks summary for executive review.

10. Business Continuity Plan (BCP) for Supply Chain

Role: Supply chain continuity planner
Task: Create a BCP for [critical product / supply chain node].
Critical node: [What facility, supplier, or lane is this plan for?]
What depends on it: [Products, customers, revenue at risk if it goes down]
Plan structure:
1. Risk Scenarios:
   - Supplier shutdown (sudden, planned, partial)
   - Transportation disruption (port closure, carrier strike, weather)
   - Facility outage (fire, power, IT failure)
   - Regulatory change (export controls, tariffs)
2. Impact Assessment:
   - Revenue at risk ($ per day of disruption)
   - Customer impact (which customers, how quickly affected)
   - Alternative supply timeline (how fast can we switch?)
3. Immediate Response (first 24-72 hours):
   - Who is notified (call tree — names, roles, contact info)
   - What decisions are needed (who decides what, how fast)
   - What actions happen (activate backup, reallocate inventory, inform customers)
4. Short-term Continuity (1-4 weeks):
   - Backup supplier activation (who, lead time, capacity)
   - Inventory bridging (how much safety stock, how long does it last?)
   - Alternative logistics (different port, different carrier, different mode)
   - Customer communication (who calls them, what do they say?)
5. Long-term Recovery (1-6 months):
   - Permanent supplier change or qualification
   - Supply chain redesign (if the disruption reveals structural weakness)
   - Contract renegotiation (what to change to prevent recurrence)
6. Plan Maintenance:
   - Review frequency (quarterly? annually?)
   - Test/exercise (tabletop, simulation, live test)
   - Update triggers (what changes trigger a plan review?)
Format: Business continuity plan ready for approval and distribution.

11. Supply Chain Dashboard Design

Role: Supply chain analytics consultant
Task: Design a supply chain performance dashboard for [business unit].
Audience: [Who uses it — SC manager, operations director, executive team?]
Refresh frequency: [Real-time / daily / weekly / monthly]
Dashboard sections:
1. Executive Summary (top of dashboard):
   - Customer service level (OTIF % — on-time in-full)
   - Inventory days of supply (total and by category)
   - Forecast accuracy (MAPE)
   - Supply chain cost (% of revenue)
   - Key risk indicator (green/yellow/red)
2. Demand & Forecasting:
   - Demand vs forecast (last 12 months, with accuracy trend)
   - Top 5 SKU forecast variance (which are hardest to predict?)
   - Promotion impact (demand spike vs baseline)
3. Inventory:
   - Inventory value and days of supply (trend)
   - Slow-moving and obsolete (by category, $ value)
   - Stockout incidents (count, duration, impacted SKUs)
   - Safety stock compliance (% of SKUs at or above safety stock)
4. Supplier Performance:
   - On-time delivery rate (by supplier, trend)
   - Quality rate (defect PPM by supplier)
   - Supplier risk score (top 5 critical suppliers)
5. Logistics:
   - Freight cost per unit (trend)
   - On-time delivery rate (by carrier)
   - Customs/tariff cost (trend, by region)
6. Risk Indicators:
   - Supplier financial health alerts
   - Geographic risk alerts (weather, political, port congestion)
   - Inventory risk alerts (critical SKUs below safety stock)
For each metric:
1. What it measures
2. Target/threshold
3. Data source
4. Visualization type
5. Alert condition
Format: Dashboard specification ready for BI team to build.

Sustainability & Cost

12. Supply Chain Cost Reduction Analysis

Role: Supply chain cost optimization analyst
Task: Identify cost reduction opportunities in [supply chain description].
Current cost breakdown:
1. Materials (raw materials, components — % of total)
2. Manufacturing/Processing (production, labor, overhead — %)
3. Warehousing (storage, handling, depreciation — %)
4. Transportation (freight, customs, duties — %)
5. Inventory carrying (capital, storage, obsolescence — %)
6. Administration (planning, IT, management — %)
Analysis:
For each cost category:
1. Current cost ($ and % of total)
2. Benchmark (industry average or best-in-class)
3. Gap (how far above/below benchmark)
4. Top 3 cost drivers (what specifically drives this cost?)
5. Reduction opportunities (ranked by $ impact and ease):
   - Quick wins (implement in 90 days, low risk)
   - Strategic (6-18 months, medium risk)
   - Transformational (18+ months, higher risk but large impact)
6. Implementation plan for top 5 opportunities:
   - What to do
   - Expected savings ($ and %)
   - Investment required ($)
   - Payback period
   - Risk and mitigation
7. Total potential savings:
   - Conservative ($)
   - Likely ($)
   - Aggressive ($)
Format: Cost reduction analysis with prioritized opportunities and implementation roadmap.

Best Practices

For more operations content, see our ChatGPT prompts for operations managers and ChatGPT prompts for logistics coordinators.