AI Prompts for Supply Chain

You are a supply chain analytics expert. Help me build a robust statistical demand forecasting model.

My business context:
- Industry: [describe your industry and product type]
- Historical data available: [months/years of sales history]
- Demand patterns: [seasonal, stable, lumpy, trend-driven]
- Current forecasting method: [spreadsheet, gut feel, basic moving average]

Please provide:

1. Recommended forecasting method(s) for my context:
   - Moving average vs exponential smoothing vs ARIMA vs ML-based
   - When to use each and why
   - Trade-offs between complexity and accuracy

2. Step-by-step model build:
   - Data preparation and cleaning steps
   - Handling seasonality and trend components
   - Incorporating external variables (promotions, weather, economic indicators)
   - Safety stock calculation formula

3. Accuracy measurement:
   - MAPE, MAE, and RMSE — which to use and how to interpret
   - Acceptable accuracy benchmarks by industry
   - How to segment products by forecastability (ABC-XYZ analysis)

4. Implementation roadmap:
   - How to run this in Excel, Python (statsmodels), or a planning tool
   - How often to re-train vs re-run the model
   - Governance: who owns the forecast and how to manage disagreements

Provide Python code for the core forecasting logic using statsmodels or scikit-learn.

Act as an S&OP expert. Help me design and implement a Sales and Operations Planning process from scratch.

Company profile:
- Size: [revenue range and number of employees]
- Products: [product types and number of SKUs]
- Current planning maturity: [ad hoc / basic / structured]
- Key challenges: [describe top 3 planning pain points]

Please design:

1. S&OP Process Architecture:
   - Five-step monthly cadence: data gathering, demand review, supply review, pre-S&OP, executive S&OP
   - Who participates in each step (roles, not individuals)
   - Meeting agendas and duration for each step
   - Decision rights at each stage

2. Demand Review Meeting:
   - Statistical baseline forecast vs commercial input process
   - How to document and track forecast adjustments
   - Consensus forecast sign-off procedure
   - KPIs to review: forecast accuracy, bias, volume vs prior month

3. Supply Review Meeting:
   - Capacity constraint identification and escalation
   - Inventory coverage analysis
   - Make-or-buy and outsourcing decision framework
   - Lead time change management

4. Executive S&OP:
   - One-page scorecard format
   - Three scenario plans: base, upside, downside
   - Decision log and accountability tracking

5. Technology and Tools:
   - Minimum viable S&OP toolset for a midsize company
   - How to run S&OP effectively in Excel before investing in a planning system

Provide meeting agenda templates for each of the five steps.

Help me build a demand forecasting approach specifically for new product launches where historical data is unavailable.

New product context:
- Product type: [describe the product and market]
- Launch market: [geography and customer segment]
- Comparable products: [any analogous products in portfolio or market]
- Launch timeline: [planned launch date and ramp-up period]

Please provide:

1. Analogy-Based Forecasting:
   - How to identify and select analogue products
   - Adjustment factors for price, market size, distribution, and product features
   - How to weight multiple analogues into a consensus forecast
   - Uncertainty range estimation

2. Market Sizing Approach:
   - Total addressable market calculation methodology
   - Serviceable addressable market scoping
   - Target market share assumptions and how to validate them
   - Sensitivity analysis on key assumptions

3. Pre-Launch Intelligence:
   - Using pre-orders, intent surveys, and distributor input
   - Adjusting statistical models with qualitative signals
   - Sales team input process and bias correction

4. Launch Ramp Model:
   - Week-by-week expected sales ramp curve
   - Distribution build-out timeline impact on demand
   - Initial inventory stocking strategy (safety stock for launch)

5. Post-Launch Adjustment Process:
   - First 4-week actual vs forecast review
   - How quickly to update the model based on early data
   - Escalation triggers if demand deviates significantly from plan

Provide an Excel model structure and a Python quick-start script.

Create a comprehensive demand scenario planning framework to help our supply chain prepare for uncertainty.

Our planning challenge:
- We face significant demand uncertainty due to: [describe key uncertainty drivers]
- Planning horizon: [12 months / 18 months / 3 years]
- Current scenario planning maturity: [none / basic / structured]

Please build:

1. Scenario Development Framework:
   - How to identify the 3-5 most critical uncertainty drivers
   - Building a 2x2 scenario matrix from top drivers
   - Developing narrative descriptions for each scenario
   - Translating narratives into quantified demand ranges

2. Three Core Scenarios:
   - Base case: most likely outcome with probability weighting
   - Upside case: bull scenario assumptions and demand uplift
   - Downside case: bear scenario assumptions and demand reduction
   - Extreme scenario: low-probability, high-impact event planning

3. Supply Chain Implications by Scenario:
   - Inventory positioning recommendations per scenario
   - Capacity commitment decisions (firm vs flexible)
   - Supplier contract strategy per scenario
   - Capital investment go/no-go decision thresholds

4. Monitoring and Trigger Framework:
   - Leading indicators to track for each scenario
   - Decision trigger points: when to switch between scenarios
   - Pre-agreed response playbooks for each trigger
   - Review cadence for updating scenarios

5. Executive Communication:
   - One-page scenario summary for leadership
   - How to present scenario ranges without causing alarm
   - Connecting scenarios to financial planning (P&L impact per scenario)

You are an inventory optimization expert. Help me design SKU-level inventory policies for a distribution business.

Our inventory profile:
- Total SKU count: [number]
- Warehouse locations: [number and type]
- Lead times: [range of supplier lead times]
- Service level target: [e.g., 98% OTIF to customers]
- Current average inventory turnover: [turns per year]

Please design:

1. ABC-XYZ Segmentation:
   - ABC by revenue contribution (A: top 70%, B: next 20%, C: bottom 10%)
   - XYZ by demand variability (X: stable, Y: variable, Z: lumpy/sporadic)
   - Combined 9-cell matrix with recommended policies per segment
   - How to handle seasonal items that change segment across the year

2. Safety Stock Calculation by Segment:
   - Formula for each segment type with worked examples
   - How to determine the right service level per segment
   - Incorporating lead time variability (not just demand variability)
   - Review frequency recommendations by segment

3. Reorder Point and Order Quantity:
   - Economic order quantity calculation and when to use it
   - Periodic vs continuous review system trade-offs
   - Min/max policy setup for low-complexity SKUs
   - Batch size constraints from supplier minimums

4. Slow-Moving and Obsolete Inventory:
   - Definition thresholds for slow-moving (SLOB) inventory
   - Remediation strategies: markdowns, liquidation, donation, disposal
   - Governance process for SLOB write-offs
   - How to prevent future SLOB accumulation at the buying stage

Provide Python code to run the ABC-XYZ segmentation on a CSV of SKU data.

Help me optimise inventory across a multi-echelon supply chain network with central warehouse, regional DCs, and retail/customer locations.

Network structure:
- Echelon 1: [central warehouse / factory]
- Echelon 2: [regional distribution centres — number and location]
- Echelon 3: [retail stores / customer delivery points]

Please cover:

1. Multi-Echelon Inventory Theory:
   - How to allocate total system inventory across echelons
   - Centralisation vs decentralisation trade-offs
   - Pooling effect and its quantification (how centralisation reduces safety stock)
   - Risk pooling formula and worked example

2. Inventory Positioning Decision Framework:
   - Which products to stock at which echelon
   - Criteria: lead time, demand variability, SKU velocity, product value
   - Decision matrix for push vs pull at each echelon boundary
   - Postponement strategies: where to hold inventory in generic form

3. Replenishment Policy Design:
   - Replenishment triggers from DC to central warehouse
   - Replenishment from DC to stores (automated vs manual)
   - Emergency lateral transfer rules between DCs
   - How to handle stockout events at lower echelons

4. Performance Metrics by Echelon:
   - Inventory days of supply target per echelon
   - Fill rate measurement at each tier
   - On-hand accuracy requirements per echelon
   - Cost-to-serve by echelon

Provide a framework for calculating optimal stock at each echelon using Python.

Design a structured inventory reduction programme to reduce working capital by 20-30% without compromising service levels.

Current state:
- Total inventory value: [amount]
- Inventory as % of annual revenue: [%]
- Turns per year: [number]
- Service level performance: [OTIF %]
- Main inventory categories: [raw material / WIP / finished goods / spares]

Please provide:

1. Inventory Diagnostic:
   - How to categorise current excess: safety stock excess, cycle stock excess, SLOB, in-transit excess
   - Root cause analysis framework for excess inventory
   - Benchmarking current turns against industry comparables
   - Quick assessment tool to estimate the reduction opportunity

2. Reduction Levers by Category:
   - Finished goods: tighten safety stock policy, reduce lot sizes, improve forecast accuracy
   - Raw materials: vendor-managed inventory, consignment, reduced MOQ negotiation
   - WIP: reduce batch sizes, improve flow, reduce lead times
   - Spare parts: apply service level differentiation, partner with suppliers on VMI

3. Implementation Roadmap:
   - Phase 1 (months 1-3): quick wins, SLOB clearance, policy tightening
   - Phase 2 (months 4-9): process changes, supplier negotiations, system improvements
   - Phase 3 (months 10-18): structural changes, network optimisation
   - Projected cash release by phase

4. Governance and Tracking:
   - Weekly inventory health dashboard KPIs
   - Accountability structure: who owns inventory reduction by category
   - Escalation process when targets are missed
   - How to prevent inventory creep after reduction is achieved

Help me build a demand sensing capability to improve short-term inventory decisions using real-time signals.

Business context:
- Replenishment frequency: [daily / weekly / bi-weekly]
- Data sources available: [POS data, customer orders, web traffic, IoT sensors, social data]
- Current forecast horizon used for replenishment decisions: [weeks]
- Key problem: [excess stock / stockouts / both]

Please design:

1. What Demand Sensing Is and When It Helps:
   - Difference between demand forecasting (medium-term) and demand sensing (0-10 days)
   - Best use cases: FMCG, e-commerce, seasonal spikes, promotional lift detection
   - Quantified benefit: how much inventory reduction is typically achievable
   - Prerequisite data infrastructure requirements

2. Data Inputs for Demand Sensing:
   - Point-of-sale data: collection frequency and aggregation rules
   - Web and search data signals for forward demand indicators
   - Social and sentiment signals for trend detection
   - Historical promotional uplift patterns

3. Sensing Model Architecture:
   - Short-cycle forecasting algorithm options (gradient boosting, LSTM, simple rules)
   - How to combine sensing signals with statistical baseline forecast
   - Model update frequency and re-training cadence
   - Confidence interval calculation for sensing output

4. Replenishment Integration:
   - How to feed sensing output into daily replenishment decisions
   - Rules for overriding base forecast with sensing signal
   - Alert system for significant demand signal changes
   - Inventory buffer adjustment triggers based on sensing confidence

Provide Python starter code for a simple demand sensing pipeline using daily POS data.

You are a logistics network design expert. Help me optimise the physical distribution network for a manufacturer serving customers across [region].

Current network:
- Manufacturing locations: [describe]
- Current warehouses and DCs: [number, locations, sizes]
- Customer locations: [describe density and geography]
- Annual freight spend: [amount]
- Current service level: [avg. delivery lead time to customers]

Please help me:

1. Network Design Methodology:
   - Centre-of-gravity analysis for optimal DC placement
   - Service level vs cost trade-off modelling
   - Make vs buy decisions for warehousing (own vs 3PL)
   - How to model network alternatives in Excel or Python

2. Warehouse Location Optimisation:
   - How to evaluate adding, closing, or relocating DCs
   - Land and labour cost considerations by region
   - Transport cost savings from each configuration
   - Customer service impact of each option

3. Transport Mode Optimisation:
   - Road vs rail vs air vs sea decision framework
   - Intermodal opportunities and cost comparisons
   - Carrier selection criteria and contract structures
   - How to build a carrier scorecard

4. Network Footprint Scenarios:
   - Current state cost and service level baseline
   - Option 1: consolidate to fewer, larger DCs (centralisation)
   - Option 2: expand to more, smaller DCs (localisation)
   - Option 3: hybrid with one central DC and regional spoke DCs

5. Implementation Considerations:
   - Transition risk during network changes
   - Inventory implications of network reconfiguration
   - Customer communication plan during transition
   - Timeline and change sequencing

Provide a Python framework for centre-of-gravity analysis with sample data.

Help me build a last-mile delivery route optimisation system for a fleet of delivery vehicles.

Operations context:
- Fleet size: [number of vehicles]
- Daily deliveries: [number of stops per day]
- Delivery area: [urban / suburban / rural / mixed]
- Time window constraints: [do customers have specific delivery windows?]
- Current routing method: [manual / basic system / none]

Please provide:

1. Route Optimisation Fundamentals:
   - Vehicle routing problem (VRP) overview and variants (CVRP, VRPTW, VRPPD)
   - How to choose the right VRP variant for your operation
   - Key constraints to model: capacity, time windows, driver hours, vehicle types
   - Realistic cost reduction potential from route optimisation (industry benchmarks)

2. Algorithm Selection:
   - When to use exact solvers vs heuristics vs metaheuristics
   - Practical options: Google OR-Tools, OSRM, commercial tools (Route4Me, OptimoRoute)
   - Build vs buy decision framework
   - How to benchmark algorithm quality

3. Data Requirements:
   - Stop-level data needed: address, delivery window, weight/volume, special requirements
   - Vehicle data: capacity, speed profile, operating hours, cost per km
   - Geocoding and mapping data requirements
   - Historical performance data for model calibration

4. Implementation Roadmap:
   - Phase 1: data clean-up and geocoding
   - Phase 2: baseline route optimisation with Google OR-Tools
   - Phase 3: integrate with dispatch and driver app
   - Phase 4: real-time re-routing for exceptions

Provide working Python code using Google OR-Tools for a basic CVRPTW solver.

Help me design and execute a strategic freight procurement process to reduce transportation costs and improve carrier performance.

Current state:
- Annual freight spend: [amount]
- Current carrier base: [number of carriers across modes]
- Current contract structure: [spot / contracted / mix]
- Primary modes: [road / rail / air / ocean / parcel]
- Main pain points: [cost, reliability, visibility, carrier capacity]

Please provide:

1. Freight Spend Analysis:
   - How to build a lane-level spend cube (origin/destination/mode/carrier)
   - Identifying consolidation opportunities across lanes
   - Benchmarking your rates against market (sources and method)
   - Calculating the potential savings opportunity before going to market

2. RFQ Design and Process:
   - How to structure a freight RFQ that attracts competitive bids
   - Lane definition and volume commitment strategy
   - Carrier pre-qualification criteria and questionnaire
   - Evaluation scorecard: price, service, financial stability, sustainability

3. Negotiation Strategy:
   - How to use competitive tension effectively
   - Fuel surcharge and accessorial charge negotiation
   - Multi-year vs annual contract trade-offs
   - Volume commitment vs spot rate balance

4. Carrier Performance Management:
   - KPI dashboard: on-time delivery, damage rate, tender acceptance, cost per unit
   - Quarterly business review structure with top carriers
   - Performance incentive and penalty mechanisms
   - How to manage carrier base size (concentration vs competition)

5. Technology and Visibility:
   - Transport management system (TMS) selection criteria
   - Shipment tracking and ETD accuracy requirements
   - Carrier EDI and API connectivity requirements

Design a comprehensive reverse logistics and returns management system for an e-commerce or retail business.

Business context:
- Annual return volume: [number of units or % of forward volume]
- Product types: [describe — electronics, apparel, FMCG, etc.]
- Current return process: [describe how returns are handled today]
- Main pain points: [cost, speed, recovery rate, customer experience]

Please cover:

1. Returns Policy and Customer Experience:
   - Return policy design: window, conditions, payment method
   - Self-service returns portal requirements
   - Pre-paid returns label strategy and cost implications
   - How to reduce preventable returns (size guides, product descriptions, fit tools)

2. Physical Returns Flow:
   - Returns routing: direct to DC vs regional sort centre vs 3PL
   - Receiving and inspection process design
   - Grading system: A-stock (resell), B-stock (refurbish), C-stock (liquidate), dispose
   - Processing time targets by grade and product type

3. Recovery Value Optimisation:
   - Disposition channel strategy: restock, refurbish, outlet, liquidate, donate, destroy
   - Recovery rate benchmarks by product category
   - Refurbishment process and economics
   - Liquidation partner selection and pricing strategy

4. Financial Tracking:
   - Cost per return calculation (processing, freight, write-down)
   - Recovery value by disposition channel
   - Net return cost as % of product value
   - Budget and forecast for returns costs

5. Technology Requirements:
   - Returns management system (RMS) features needed
   - Integration with OMS, WMS, and finance systems
   - Data analytics for returns root cause analysis
   - Automation opportunities in inspection and grading

Help me build a strategic supplier segmentation and management framework for our procurement function.

Supplier base profile:
- Total number of active suppliers: [number]
- Annual spend managed: [amount]
- Number of critical/sole-source suppliers: [estimate]
- Current supplier management approach: [transactional / emerging strategic]

Please design:

1. Supplier Segmentation Model:
   - Spend-impact matrix (Kraljic matrix): Strategic, Bottleneck, Leverage, Non-critical
   - How to classify each supplier: spend data, criticality, substitutability, risk
   - Updated classification for suppliers with supply risk vs strategic importance
   - How often to re-segment and who approves changes

2. Management Approach by Segment:
   - Strategic suppliers: joint business plans, executive sponsorship, innovation programmes
   - Bottleneck suppliers: dual-source strategy, safety stock, relationship investment
   - Leverage suppliers: competitive bidding, consolidation, category management
   - Non-critical suppliers: catalogue buying, P-card, low-touch procurement

3. Supplier Performance Management System:
   - KPI scorecard per segment (quality, delivery, cost, service, sustainability)
   - Monthly vs quarterly vs annual review cadence by segment
   - Performance improvement plan (PIP) process for underperformers
   - Recognition programme for top-performing suppliers

4. Strategic Supplier Relationship Programme:
   - Joint business plan template and annual review process
   - Innovation and cost reduction idea pipeline
   - Supplier development investment criteria
   - How to measure and capture collaborative value

5. Supplier Rationalisation:
   - Criteria for removing suppliers from the active base
   - Process for safely exiting a supplier relationship
   - Preferred supplier list management and governance

Act as a strategic procurement consultant. Help me develop a comprehensive category strategy for a major spend category.

Category overview:
- Category name: [e.g., packaging, raw materials, logistics services, IT hardware]
- Annual spend: [amount]
- Number of suppliers: [current supplier count in category]
- Current contract status: [in contract / spot / mix]
- Main challenges: [cost, quality, supply security, sustainability]

Please build a full category strategy:

1. Category Spend Analysis:
   - Spend by supplier, sub-category, and business unit
   - Spend trend over 3 years
   - Price benchmarking vs market indices
   - Demand analysis: volume trend, specification consolidation opportunities

2. Supply Market Analysis:
   - Supplier landscape: number of credible suppliers globally and locally
   - Supply market structure: competitive / oligopoly / monopoly
   - Cost driver analysis: raw material, labour, energy, logistics components
   - Market outlook: capacity, pricing trend, innovation pipeline

3. Internal Stakeholder Analysis:
   - Key internal users and their requirements
   - Specification standardisation opportunities
   - Make vs buy opportunities
   - Demand reduction levers

4. Strategy Options and Recommendation:
   - Option 1: consolidate to fewer suppliers and leverage volume
   - Option 2: dual-source to balance risk and competition
   - Option 3: develop alternative suppliers in new geographies
   - Recommended strategy with rationale and risk assessment

5. Implementation Plan:
   - 12-month action plan with owners, milestones, and savings targets
   - RFQ timeline and supplier engagement plan
   - Contract strategy and key terms to prioritise
   - Savings and value realisation tracking

Design a comprehensive supplier onboarding and qualification process for a manufacturing company.

Context:
- Industry: [describe]
- Regulatory requirements: [food safety, ISO, CE marking, etc.]
- Annual number of new supplier onboardings: [estimate]
- Current process maturity: [ad hoc / documented / robust]

Please design:

1. Supplier Pre-Qualification:
   - Initial screening criteria (financial stability, certifications, capacity, ethical standards)
   - Supplier questionnaire: legal, financial, operational, quality, ESG sections
   - Reference check process and red flag identification
   - Rejection criteria and communication approach

2. Quality Qualification:
   - Supplier audit types: desktop, self-assessment, on-site
   - Audit checklist by supplier category (manufacturing, service, logistics)
   - Quality approval levels: approved, conditional, probationary
   - Audit frequency post-approval by risk category

3. Commercial and Legal Setup:
   - Master supply agreement key clauses to negotiate
   - Payment terms and early payment discount programme
   - Liability, IP, and data protection requirements
   - Sustainability and code of conduct requirements

4. ERP and Systems Integration:
   - Supplier master data setup checklist
   - EDI and electronic invoicing onboarding
   - Procurement system access and training for supplier
   - Bank details verification and fraud prevention process

5. Ongoing Supplier Management:
   - Probationary period KPIs and review process
   - Escalation process for early performance issues
   - Graduation from probationary to fully approved status
   - Annual re-qualification requirements

Provide a supplier onboarding checklist template in table format.

Help me build a sustainable procurement programme that integrates environmental, social, and governance (ESG) considerations into our buying decisions.

Our ESG context:
- Sustainability commitments: [describe company targets — net zero, scope 3, etc.]
- Current procurement ESG maturity: [none / emerging / structured]
- Key spend categories with highest ESG risk: [describe]
- Regulatory context: [CSRD, UK Modern Slavery Act, CSDDD, etc.]

Please design:

1. Sustainable Procurement Policy:
   - Policy scope: which suppliers and categories are in scope
   - Minimum ESG requirements for new suppliers
   - ESG scoring as % of supplier evaluation criteria
   - Exceptions process and escalation

2. Supplier ESG Assessment:
   - ESG questionnaire covering: environment, labour, human rights, governance, ethics
   - How to score and tier supplier ESG performance
   - Third-party verification requirements (EcoVadis, CDP, audits)
   - High-risk supplier identification by geography and category

3. Scope 3 Emissions Management:
   - How to collect supplier emissions data (spend-based vs activity-based)
   - Setting supplier emission reduction targets
   - Supplier engagement programme for decarbonisation
   - How to report Scope 3 in line with GHG Protocol

4. Responsible Sourcing:
   - Modern slavery and forced labour due diligence process
   - Conflict minerals (3TG) tracking requirements
   - Traceability requirements for high-risk agricultural commodities
   - Living wage and fair working conditions requirements

5. Supplier Development for Sustainability:
   - How to support suppliers in improving their ESG performance
   - Co-investment in supplier sustainability improvements
   - Recognition and preferred status for top ESG performers
   - How to handle suppliers who fail to meet ESG requirements

You are a supply chain risk expert. Help me build a comprehensive supply chain risk assessment and management framework.

Our supply chain context:
- Industry: [describe]
- Geographic footprint: [where you source, manufacture, and sell]
- Number of tier-1 suppliers: [number]
- Visibility into tier-2 and beyond: [none / limited / moderate / good]
- Recent disruptions experienced: [describe any recent supply issues]

Please design:

1. Risk Taxonomy and Classification:
   - Demand risks: forecast error, demand volatility, customer concentration
   - Supply risks: supplier failure, quality failure, capacity shortage, geopolitical disruption
   - Logistics risks: freight capacity, port congestion, fuel cost spikes
   - Macro risks: currency, commodity prices, regulation, natural disasters, cyber

2. Risk Assessment Methodology:
   - Probability and impact scoring matrix (5x5)
   - How to assess and score each risk category
   - Inherent risk vs residual risk after controls
   - Single point of failure identification process

3. Supplier Risk Profiling:
   - Data inputs for supplier risk score: financial health, geography, sole-source status, spend concentration
   - How to monitor supplier risk signals in real time
   - Risk tiering: critical, high, medium, low
   - Escalation protocol for critical supplier risk events

4. Risk Register Development:
   - Risk register template with all required fields
   - Risk ownership assignment by function
   - Mitigation plan documentation requirements
   - Review and update cadence (monthly / quarterly / event-triggered)

5. Business Continuity Planning:
   - How to develop supply continuity plans for top 10 risks
   - Playbook structure: trigger, escalation, response actions, recovery timeline
   - Testing and simulation exercises
   - Post-disruption after-action review process

Provide a risk register template in table format.

Help me design a strategic dual-sourcing and supply diversification programme to reduce dependency on single suppliers and geographies.

Current exposure:
- Number of sole-source suppliers: [number]
- Spend concentration in single geography: [% in one region]
- Categories with highest single-source risk: [list top 3-5]
- Available budget for dual-source development: [range]

Please provide:

1. Prioritisation Framework:
   - How to score and rank suppliers for dual-sourcing priority
   - Criteria: business criticality, substitutability, lead time risk, financial risk, geopolitical risk
   - Decision matrix: when to dual-source vs accept single-source risk vs develop alternatives
   - Cost-benefit analysis template for dual-sourcing investment

2. Alternative Supplier Identification:
   - How to find credible alternative suppliers by category
   - Geographic diversification: nearshoring, friendshoring, and reshoring considerations
   - Qualification timeline and resource requirements per supplier type
   - Minimum viable qualification criteria for a backup supplier

3. Volume Allocation Strategy:
   - How to split volumes between primary and secondary suppliers
   - Keeping the secondary supplier active and capable
   - Contract structure for dual-source arrangements
   - How to avoid gaming and collusion between dual-source partners

4. China-Plus-One Strategy:
   - Framework for identifying and developing suppliers in alternative countries
   - Country risk and capability assessment methodology
   - Total cost of ownership comparison including tariff risk
   - Transition timeline and phased approach

5. Ongoing Programme Management:
   - How to track dual-source readiness across the supplier base
   - Annual review and update of dual-source programme
   - Scenarios where secondary supplier becomes primary

Help me build a supply chain crisis response playbook for rapid, coordinated action during major supply disruptions.

Disruption scenarios to plan for:
1. Major supplier failure (bankruptcy, fire, or quality crisis)
2. Logistics disruption (port closure, freight capacity crisis)
3. Geopolitical event affecting key sourcing region
4. Cyber attack on supply chain systems
5. Pandemic or extreme weather event

For each scenario, please provide:

1. Early Warning Indicators:
   - Signals to monitor that a crisis may be developing
   - Threshold triggers for activating the playbook
   - Data sources and monitoring cadence

2. Crisis Escalation Protocol:
   - Who activates the response and at what trigger
   - Crisis team structure: roles and decision authority
   - Communication tree: internal and external
   - War room setup and communication cadence

3. Immediate Response Actions (0-72 hours):
   - Supply assessment: what is affected, what is available
   - Inventory audit: how much buffer exists and at which locations
   - Customer communication: who to call first and what to say
   - Alternative supply identification and emergency sourcing

4. Short-Term Mitigation (1-4 weeks):
   - Alternative supplier activation and fast-track qualification
   - Customer allocation process if supply is constrained
   - Logistics workarounds and premium freight decisions
   - Financial impact assessment and board communication

5. Recovery and Learning:
   - Criteria for standing down the crisis response
   - After-action review process and documentation
   - How to update the risk register and playbook
   - Investment decisions to prevent recurrence

Help me design and implement an end-to-end supply chain visibility programme that provides real-time insight across suppliers, logistics, and inventory.

Current visibility gaps:
- Supplier production status: [no visibility / limited / moderate]
- In-transit shipment tracking: [no visibility / manual / real-time]
- Inventory visibility across locations: [siloed / partial / unified]
- Customer order status: [manual / automated]

Please design:

1. Visibility Architecture:
   - Four layers of visibility: supplier, in-transit, DC/warehouse, customer
   - Data required at each layer and how to collect it
   - Integration approach: EDI, API, IoT, manual reporting
   - Unified visibility platform vs best-of-breed point solutions

2. Supplier Visibility Programme:
   - Production order status sharing requirements
   - Supplier portal setup and data submission standards
   - How to get suppliers to participate (incentives and requirements)
   - Tier-2 and tier-3 visibility approaches

3. In-Transit Tracking:
   - Ocean freight: AIS vessel tracking, booking confirmation, bill of lading data
   - Road freight: GPS tracking requirements for carriers
   - Air freight: airway bill tracking and ETD management
   - Parcel: last-mile carrier tracking integration

4. Inventory Visibility:
   - WMS integration for real-time inventory by location
   - Cycle count programme to maintain inventory accuracy
   - Inventory data governance: who owns the golden record
   - How to build a single inventory view across ERP, WMS, and 3PLs

5. Control Tower Design:
   - What a supply chain control tower is and what it does
   - Data inputs and alert logic for the control tower
   - Exception management process and escalation rules
   - How to staff and operate a control tower function

You are an AI and supply chain expert. Help me identify and prioritise AI use cases for our supply chain operations.

Our business context:
- Company type: [manufacturer / distributor / retailer / 3PL]
- Annual supply chain cost: [% of revenue]
- Digital maturity: [spreadsheets / ERP / advanced analytics / AI-enabled]
- Key pain points: [describe top 3-5 supply chain challenges]

Please provide:

1. AI Use Case Inventory for Supply Chain:
   - Demand forecasting: ML models, external signal integration, new product forecasting
   - Inventory optimisation: dynamic safety stock, automated replenishment, multi-echelon AI
   - Logistics: route optimisation, carrier selection, freight cost prediction
   - Procurement: spend analytics, price prediction, supplier risk monitoring
   - Quality: defect detection, predictive maintenance, yield optimisation

2. Use Case Prioritisation Framework:
   - Value potential (cost saving, service improvement, working capital reduction)
   - Implementation complexity (data readiness, change management, integration effort)
   - Time to value (months to first production benefit)
   - 2x2 matrix: quick wins, strategic bets, fill-ins, avoid

3. Top 3 Priority Use Cases for Your Context:
   - Use case description and business case
   - Data requirements and current data readiness gap
   - Build vs buy vs partner decision for each
   - 6-month implementation roadmap

4. Data Foundation Requirements:
   - Minimum data quality and governance standards for AI
   - Master data management for supply chain AI
   - Data lake vs data warehouse architecture choice
   - AI governance and responsible AI principles for supply chain

5. Change Management for AI Adoption:
   - How to bring planners along on the AI journey
   - Human-in-the-loop vs fully automated decision recommendations
   - Metrics to prove AI value and build trust
   - Capability building plan for the supply chain team

Help me understand and build a supply chain digital twin to simulate, optimise, and predict supply chain performance.

Our supply chain overview:
- Network: [number of plants, DCs, suppliers, customers]
- Annual throughput: [volume or revenue]
- Key decisions to optimise: [inventory, capacity, routing, sourcing]
- Current modelling tools: [spreadsheets / Excel / Python / none]

Please cover:

1. What a Supply Chain Digital Twin Is:
   - Definition and components: physical model, data layer, simulation engine, optimisation
   - Difference between a digital twin and a spreadsheet model
   - Types of decisions a digital twin supports
   - Industry examples and quantified benefits

2. Digital Twin Architecture:
   - Data inputs: demand, inventory, capacity, lead times, costs, network constraints
   - Model layer: mathematical representation of the supply chain
   - Simulation engine: discrete event vs system dynamics vs agent-based
   - Optimisation layer: scenario comparison and what-if analysis

3. Build Roadmap:
   - Phase 1: baseline model of current network with historical data
   - Phase 2: scenario planning (add/remove DC, change supplier)
   - Phase 3: real-time data integration for live decision support
   - Phase 4: ML-enhanced prediction and autonomous recommendations

4. Technology Options:
   - Open-source: Python (SimPy, Pyomo), OR-Tools, NetworkX
   - Commercial: Llamasoft (Coupa), AIMMS, o9, Kinaxis
   - Build vs buy decision framework
   - Integration requirements with ERP and TMS

5. Governance and Usage:
   - How supply planners use the digital twin in day-to-day decisions
   - Model maintenance and calibration cadence
   - When to trust the model vs override with human judgement

Provide a Python starter framework for a simple supply chain network simulation.

Guide me through selecting and implementing a supply chain ERP or planning system to replace spreadsheet-based operations.

Current state:
- Company size: [revenue and employees]
- Current systems: [ERP, planning tools, WMS, TMS in use]
- Key gaps in current technology: [describe main problems]
- Budget range: [annual SaaS spend or implementation budget]
- Timeline expectation: [when you want to go live]

Please provide:

1. Requirements Definition:
   - How to build a business requirements document (BRD) for a supply chain system
   - Must-have vs nice-to-have vs out-of-scope features
   - Integration requirements with existing systems
   - User and data volume sizing

2. Vendor Landscape:
   - Tier 1 ERP with strong SCM: SAP, Oracle
   - Best-of-breed planning: o9, Kinaxis, Blue Yonder, Anaplan
   - Mid-market ERP with supply chain: NetSuite, Microsoft Dynamics, Infor
   - Niche tools: inventory planning (Slim4, Inventory Planner), TMS, WMS

3. RFP and Vendor Evaluation:
   - How to structure a supply chain technology RFP
   - Evaluation scorecard: functionality, integration, UX, implementation risk, TCO, support
   • How to run scripted demos to compare vendors fairly
   - Reference customer checks: what to ask

4. Implementation Risk Management:
   - Top reasons supply chain ERP implementations fail
   - How to structure the project team (internal and SI partner)
   - Data migration strategy and data quality preparation
   - Change management and user adoption plan

5. Total Cost of Ownership:
   - How to calculate 5-year TCO: licence, implementation, training, internal resource, ongoing maintenance
   - Hidden costs to watch for in contracts
   - Benefit realisation plan and how to track ROI post go-live

Help me identify and implement automation opportunities across supply chain operations using RPA, AI, and low-code tools.

Automation scope:
- Functions in scope: [procurement, logistics, inventory, customer service, finance]
- Current manual process pain points: [describe top 5 time-consuming manual tasks]
- Digital maturity: [spreadsheets / ERP / some automation / advanced]
- Available tools: [RPA licences, Make/Zapier, Python, ERP workflow engine]

Please provide:

1. Supply Chain Automation Opportunity Inventory:
   - Purchase order creation and approval routing
   - Invoice matching and exception handling (3-way match)
   - Shipment booking and tracking update extraction
   - Inventory replenishment order generation
   - Supplier performance report generation and distribution
   - Customs documentation preparation and filing
   - Demand forecast exception alerting and escalation
   - Customer order status update and exception communication

2. Prioritisation Framework:
   - Volume of transactions (high volume = high automation ROI)
   - Rule-based vs judgement-dependent (rule-based = easier to automate)
   - Current error rate and rework cost
   - Quick-win vs strategic automation classification

3. Technology Selection by Use Case:
   - RPA (UiPath, Automation Anywhere): for legacy system screen scraping
   - Make / n8n / Zapier: for cloud app-to-app workflows
   - ERP workflow engine: for process orchestration within ERP
   - Python: for data transformation and analytical automation
   - AI (LLM): for document processing, classification, anomaly detection

4. Implementation Approach:
   - How to document and standardise a process before automating it
   - Bot development, testing, and go-live methodology
   - Exception handling design: what the bot cannot handle
   - Monitoring and maintenance post-deployment

Provide a prioritised automation roadmap with effort and ROI estimates.