AI Prompts for Supply Chain and Logistics: Inventory, Routing, and Vendor Management

You are a supply chain analyst. Help me classify my inventory using the ABC-XYZ framework.

MY INVENTORY DATA:
- Total SKU count: [X]
- I can provide: [ANNUAL REVENUE PER SKU / UNIT VOLUME / BOTH]
- Demand variability data available: [YES / APPROXIMATE / NO]

Here's my data (or a representative sample):
[PASTE DATA — SKU, annual revenue, monthly demand for past 12 months]

Perform:
1. ABC classification by revenue contribution (A = top 80%, B = next 15%, C = bottom 5%)
2. XYZ classification by demand variability (X = stable/predictable, Y = moderate variation, Z = highly variable)
3. Combined ABC-XYZ matrix showing SKU count in each cell
4. Recommended inventory policy for each cell:
   - AX: [strategy]
   - AY: [strategy]
   - AZ: [strategy]
   - Through to CZ
5. Which SKUs are candidates for safety stock reduction? Which need more buffer?
6. Which SKUs should be reviewed for discontinuation?

Present the matrix as a table with clear action items for each quadrant.

Calculate optimal safety stock levels for these items.

ITEMS:
[For each item, provide:]
- SKU/Item: [NAME]
- Average daily demand: [X units]
- Demand standard deviation: [X units/day]
- Average lead time: [X days]
- Lead time standard deviation: [X days]
- Current safety stock: [X units]
- Target service level: [X% — e.g., 95%, 99%]
- Unit cost: $[X]
- Stockout cost estimate: $[X per incident or per unit]

For each item:
1. Calculate safety stock using the combined demand and lead time variability formula
2. Calculate reorder point (ROP)
3. Show the safety stock at 90%, 95%, and 99% service levels
4. Compare current safety stock to optimal — am I over or understocked?
5. Calculate the carrying cost of the recommended safety stock
6. Calculate the expected annual stockout cost at each service level

Summarize with a recommendation table: SKU, current safety stock, recommended safety stock, change, annual carrying cost impact, and recommended service level.

Analyze inventory turnover for my operation and identify improvement opportunities.

INVENTORY DATA:
- Total inventory value: $[AMOUNT]
- Annual COGS: $[AMOUNT]
- Industry: [INDUSTRY]
- Number of SKUs: [X]
- Top 10 slowest-moving items: [LIST WITH VALUES IF AVAILABLE]
- Current turns: [X] (if known)

Analyze:
1. Current inventory turnover ratio and days of inventory outstanding
2. How does this compare to industry benchmarks for [MY INDUSTRY]?
3. What's the carrying cost of my current inventory? (Use [X]% annual carrying cost rate, or suggest an appropriate rate)
4. Identify potential dead stock — what criteria should I use to flag items?
5. For slow-moving inventory, recommend disposition strategies: markdown, bundle, return to vendor, donate, scrap
6. What turnover improvement target is realistic, and what would that mean in working capital freed up?
7. Quick wins — what are 3-5 changes that could improve turns within 90 days?

Help me analyze demand patterns and build a forecasting approach.

PRODUCT/CATEGORY: [DESCRIBE]
HISTORICAL DATA: [PROVIDE MONTHLY OR WEEKLY DEMAND FOR 12-24 MONTHS]

Example format:
Month | Demand
Jan 2025 | [X]
Feb 2025 | [X]
[... continue]

Analyze:
1. TREND: Is demand growing, declining, or flat? What's the rate?
2. SEASONALITY: Are there recurring patterns by month, quarter, or season? Quantify the seasonal indices.
3. CYCLICALITY: Any patterns longer than 12 months?
4. OUTLIERS: Flag any data points that look anomalous. Should they be included in forecasting or excluded?
5. VOLATILITY: What's the coefficient of variation? Is this product predictable or erratic?

Then:
6. Recommend a forecasting method (moving average, exponential smoothing, seasonal decomposition, or other) and explain why it fits this pattern
7. Generate a forecast for the next [6/12] months with confidence intervals
8. What external factors should I monitor that could invalidate this forecast?

I'm launching a new product and need to build an initial demand plan without historical data.

NEW PRODUCT: [DESCRIPTION]
CATEGORY: [PRODUCT CATEGORY]
PRICE POINT: $[PRICE]
TARGET MARKET: [DESCRIBE]
LAUNCH DATE: [DATE]
DISTRIBUTION: [CHANNELS — e-commerce, retail, wholesale]

COMPARABLE PRODUCTS (if available):
- [PRODUCT A]: launched [DATE], first-year volume [X]
- [PRODUCT B]: launched [DATE], first-year volume [X]

MARKETING PLAN: [BRIEF DESCRIPTION OF LAUNCH MARKETING]

Help me build a demand plan:
1. Analog-based forecast: Based on comparable products, what's a reasonable range for Month 1-12 demand?
2. Launch curve modeling: Typical demand pattern for a new product in this category (spike-then-settle vs. slow-build vs. seasonal)
3. Scenario planning: Build low, base, and high scenarios with key assumptions for each
4. Inventory strategy: How much to produce/order for launch given uncertainty?
5. Trigger points: What early signals (pre-orders, week 1 sales, marketing response rates) would shift me between scenarios?
6. Supply plan: Recommended initial order and reorder strategy given lead time of [X WEEKS]

Help me build a vendor evaluation scorecard for my suppliers.

MY BUSINESS: [INDUSTRY / WHAT I BUY]
NUMBER OF VENDORS TO EVALUATE: [X]
CRITICAL FACTORS FOR MY BUSINESS: [LIST — e.g., lead time reliability, quality, price, flexibility]

Build a scorecard with:

1. EVALUATION CATEGORIES with suggested weights (I'll adjust):
   - Quality (defect rate, inspection results, certifications)
   - Delivery (on-time rate, lead time consistency, fill rate)
   - Cost (pricing competitiveness, total cost of ownership, cost reduction initiatives)
   - Responsiveness (communication, issue resolution time, flexibility to changes)
   - Financial stability (payment terms, company health indicators)
   - Compliance (regulatory, sustainability, ethical sourcing)
   - Innovation (product development support, continuous improvement)

2. For each category, provide 3-4 specific measurable KPIs
3. Suggested scoring scale (1-5 or 1-10) with clear definitions for each score
4. Weighting methodology — how to weight categories based on business priorities
5. A blank scorecard template I can use for each vendor
6. Red/yellow/green thresholds for overall score
7. Review cadence recommendation (monthly, quarterly, annual)

Help me prepare for a vendor negotiation.

VENDOR: [NAME / DESCRIPTION]
PRODUCT/SERVICE: [WHAT THEY SUPPLY]
CURRENT SPEND: $[ANNUAL AMOUNT]
CONTRACT STATUS: [CURRENT TERMS / UP FOR RENEWAL / NEW VENDOR]
RELATIONSHIP DURATION: [X YEARS]

MY POSITION:
- Alternative suppliers available: [YES/LIMITED/NO]
- Volume trend: [INCREASING / STABLE / DECREASING]
- Quality satisfaction: [HIGH / MEDIUM / LOW]
- Key issues: [LIST CURRENT PAIN POINTS]

WHAT I WANT TO ACHIEVE:
- [LIST 3-5 GOALS — price reduction, better terms, quality commitments, etc.]

Prepare:
1. BATNA analysis — what's my best alternative if negotiations fail?
2. Estimated vendor switching cost (time, qualification, ramp-up)
3. Leverage points I have — volume, relationship, market alternatives
4. Likely vendor priorities — what do they want from this deal?
5. Opening position vs. target vs. walk-away for each negotiable item
6. Concessions I can offer that cost me little but matter to them
7. Suggested agenda and talking points for the negotiation meeting
8. Red flags to watch for during negotiation

Conduct a supplier risk assessment for my critical vendors.

SUPPLY CHAIN CONTEXT:
- My industry: [INDUSTRY]
- Products sourced: [CATEGORIES]
- Geographic scope of suppliers: [REGIONS/COUNTRIES]
- Single-source dependencies: [LIST ANY]

For each risk category, help me assess exposure and develop mitigation strategies:

1. CONCENTRATION RISK: What percentage of spend is with my top 3 suppliers? What's at risk if any single supplier fails?
2. GEOGRAPHIC RISK: What region-specific risks affect my supply base? (Natural disasters, political instability, trade policy, logistics disruption)
3. FINANCIAL RISK: What signals indicate a supplier is in financial trouble? How do I monitor this?
4. QUALITY RISK: Where are my quality failure points? What's the impact of a quality event for each critical component?
5. LEAD TIME RISK: Which items have the longest lead times, and what happens if lead time doubles?
6. REGULATORY/COMPLIANCE RISK: What regulatory changes could disrupt supply? (Tariffs, environmental regulations, labor laws)
7. CYBER/DATA RISK: What data do I share with suppliers, and what's the exposure?

Deliverables:
- Risk matrix (likelihood vs. impact) for top risks
- Mitigation action plan with owner, timeline, and cost estimate
- Dual-sourcing candidates for single-source items
- Monitoring dashboard — what metrics to track weekly/monthly

Help me analyze and improve my distribution network.

CURRENT NETWORK:
- Warehouse/DC locations: [LIST WITH CITIES]
- Customer base: [GEOGRAPHIC DISTRIBUTION — regions, concentration]
- Average daily shipments: [X]
- Carrier mix: [LIST CARRIERS AND APPROXIMATE % OF VOLUME]
- Current average transit time: [X DAYS]
- Current average shipping cost per order: $[X]
- Service level target: [X% on-time, X-day delivery]

Analyze:
1. Does my warehouse footprint match my customer distribution? Where are the gaps?
2. What's the trade-off between adding a facility and increasing transit from existing locations?
3. Zone analysis — what percentage of shipments are going to each zone, and what's the cost by zone?
4. Carrier performance comparison — based on my data, which carriers should get more/less volume?
5. Consolidation opportunities — are there shipments that could be combined?
6. Mode optimization — am I using the right mode (ground, express, LTL, FTL) for each lane?
7. What would my cost and service look like with [SPECIFIC CHANGE — e.g., adding a West Coast DC, switching to regional carriers]?

Help me optimize last-mile delivery operations.

OPERATION TYPE: [E-COMMERCE / FOOD DELIVERY / B2B / FIELD SERVICE]
DELIVERY VOLUME: [X deliveries/day]
DELIVERY AREA: [GEOGRAPHIC DESCRIPTION]
CURRENT FLEET: [OWN FLEET / 3PL / CROWDSOURCED / MIX]
AVERAGE STOPS PER ROUTE: [X]
CURRENT COST PER DELIVERY: $[X]
TIME WINDOW REQUIREMENTS: [ANY DELIVERY WINDOWS?]
CURRENT CUSTOMER SATISFACTION: [SCORE OR DESCRIPTION]

Analyze and recommend:
1. Route density analysis — am I spreading routes too thin or clustering effectively?
2. Time window optimization — how do delivery windows affect route efficiency?
3. Vehicle capacity utilization — am I running full or partial loads?
4. Failed delivery rate and strategies to reduce it
5. Cost comparison: own fleet vs. 3PL vs. hybrid model
6. Technology recommendations for route planning and tracking
7. Customer communication strategy to reduce missed deliveries
8. Metrics dashboard — what should I track daily, weekly, monthly?

Help me evaluate and improve my warehouse layout and operations.

WAREHOUSE SPECS:
- Size: [X] sq ft
- Type: [RACKING TYPE — pallet, shelving, mixed]
- Current capacity utilization: [X]%
- SKU count: [X]
- Average daily orders: [X]
- Average lines per order: [X]
- Current pick method: [BATCH / ZONE / WAVE / DISCRETE]
- Current picks per hour per picker: [X]

PAIN POINTS:
[LIST CURRENT ISSUES — e.g., congestion in certain aisles, long pick walks, overflow storage, etc.]

Analyze:
1. Is my slotting optimized? How should I assign locations based on velocity?
2. Pick path efficiency — estimated current vs. optimal walk time per order
3. Receiving and putaway bottlenecks
4. Shipping and staging area adequacy
5. Recommended layout changes with expected impact on throughput
6. Labor productivity benchmarks — how do my picks/hour compare?
7. Quick wins vs. major changes — what can I fix this week vs. this quarter?
8. Technology opportunities: WMS, pick-to-light, voice picking, barcode/RFID

Help me design a KPI dashboard for warehouse operations.

MY OPERATION:
- Warehouse type: [DISTRIBUTION / FULFILLMENT / 3PL / MANUFACTURING SUPPORT]
- Team size: [X]
- Shifts: [X]
- Current tracking: [DESCRIBE WHAT YOU TRACK NOW]
- WMS: [SYSTEM NAME OR NONE]

Design a KPI dashboard covering:

1. RECEIVING: Dock-to-stock time, receiving accuracy, PO compliance, appointment adherence
2. STORAGE: Capacity utilization, location accuracy, inventory accuracy (cycle count results)
3. PICKING: Picks per hour, pick accuracy, order cycle time, lines per hour
4. PACKING: Pack rate, packaging accuracy, carton utilization
5. SHIPPING: On-time shipment rate, shipping accuracy, cost per order shipped, carrier compliance
6. LABOR: Units per labor hour, overtime percentage, absenteeism, cost per unit
7. QUALITY: Order accuracy rate, damage rate, returns due to warehouse error

For each KPI:
- Definition and formula
- Industry benchmark (where available)
- Suggested target
- Measurement frequency
- Data source
- Red/yellow/green thresholds

Help me build disruption scenarios and response plans for my supply chain.

MY SUPPLY CHAIN:
- Products: [DESCRIBE]
- Key raw materials/components: [LIST]
- Supplier locations: [COUNTRIES/REGIONS]
- Manufacturing: [LOCATIONS]
- Primary markets: [REGIONS]
- Total supply chain lead time (source to customer): [X WEEKS]

Build scenarios for:

1. SUPPLIER FAILURE: Primary supplier for [CRITICAL COMPONENT] goes offline for 90 days
   - Immediate actions (first 48 hours)
   - Short-term mitigation (weeks 1-4)
   - Long-term recovery (months 2-6)
   - Estimated revenue impact

2. LOGISTICS DISRUPTION: Major port/route closure affecting [SPECIFIC LANE]
   - Alternative routing options and cost impact
   - Inventory buffer requirements
   - Customer communication plan

3. DEMAND SURGE: Unexpected 3x demand spike for [PRODUCT]
   - Current capacity constraints
   - Supplier ability to scale
   - Allocation strategy if supply < demand

4. QUALITY EVENT: Recall or quality hold on [COMPONENT/PRODUCT]
   - Containment procedures
   - Replacement sourcing timeline
   - Financial exposure estimate

For each scenario, provide a one-page response playbook with decision triggers, action items, responsible parties (by role), and communication templates.

Help me create an RFP (Request for Proposal) for [PRODUCT/SERVICE].

CONTEXT:
- What I'm sourcing: [DETAILED DESCRIPTION]
- Annual volume: [X UNITS or $X]
- Current supplier (if any): [DESCRIPTION OF CURRENT ARRANGEMENT]
- Why I'm going to market: [REASON — cost, quality, capacity, diversification]
- Timeline: RFP issued [DATE], responses due [DATE], decision by [DATE]
- Number of vendors to invite: [X]

Generate an RFP document with these sections:
1. Company overview and project background
2. Scope of work / product specifications (with detail based on what I've described)
3. Volume and delivery requirements
4. Quality requirements and acceptance criteria
5. Pricing format — how should vendors structure their pricing? (unit price, volume tiers, tooling, NRE, etc.)
6. Commercial terms to address (payment terms, warranty, liability, IP)
7. Vendor qualification requirements (certifications, financial stability, references)
8. Evaluation criteria and weighting (show vendors how they'll be scored)
9. Response format and submission instructions
10. Timeline and key dates

Also generate:
- Vendor comparison scorecard template
- Key questions to ask in vendor presentations
- Red flags to watch for in responses

Help me build a total cost of ownership (TCO) model for [PRODUCT/COMPONENT].

I'm comparing these options:
OPTION A: [DESCRIPTION — supplier, location, unit price]
OPTION B: [DESCRIPTION — supplier, location, unit price]
OPTION C: [DESCRIPTION — if applicable]

ANNUAL VOLUME: [X UNITS]

Build a TCO model that includes:

1. ACQUISITION COSTS
   - Unit price
   - Tooling / setup / NRE
   - Minimum order quantities / order premiums

2. LOGISTICS COSTS
   - Freight (inbound to my facility)
   - Customs duties and brokerage (if international)
   - Insurance in transit
   - Packaging requirements

3. QUALITY COSTS
   - Expected defect rate and cost of defects
   - Inspection requirements
   - Warranty / return costs
   - Risk of quality event

4. INVENTORY COSTS
   - Lead time difference and impact on safety stock
   - Lead time variability impact
   - Carrying cost of additional inventory

5. OPERATIONAL COSTS
   - Supplier management overhead
   - Communication complexity (time zones, language)
   - Payment terms impact (cash flow cost)
   - Technology integration requirements

6. RISK COSTS
   - Supply disruption probability and estimated impact
   - Single-source risk premium
   - Currency risk (if applicable)
   - Regulatory/tariff risk

Present as a comparison table: per-unit TCO, annual TCO, and total cost ranking. Highlight where the lowest unit price does NOT equal the lowest total cost.