The Role-Input-Output Pattern: Why Most AI Supply Chain Advice Disappoints
The reason most people get mush from AI on supply chain questions is not the model, it is the prompt shape. "How can I reduce my inventory?" invites a listicle, because the model has no idea what your chain looks like, what your constraints are, or what output would be useful. The prompts that do real analysis work share a pattern: a defined role (inventory analyst, sourcing strategist, CFO translator), your actual inputs with placeholders marked so you know what to fill, and a required output, a table, a ranked list, a one-page brief, a defense card. These twelve supply chain AI prompts follow that pattern, one per job.
The second discipline is honesty about data quality, and it is baked into every prompt below: each one instructs the model to flag guessed inputs, because the fastest way to poison a supply chain decision is to let a confident number masquerade as a measured one. A landed-cost table with a GUESS beside the duty rate is useful; the same table without the flag is a liability. Treat the AI as a rigorous analyst with a marking pen, not an oracle, and treat every output as a draft that has not yet earned trust.
How to Use This Pack: The Honesty Rules
Three rules make the pack safe for real work. Rule one: paste what you can measure, describe what you cannot, a year of PO history pasted beats a paragraph of vibes, while supplier identities and secret pricing stay out entirely. Rule two: demand the middle, every calculation must show its window, its inputs, and its formula, because an answer without a method is an opinion with decimal points. Rule three: verify before it travels, anything that will be spoken in a review, pasted into a deck, or sent to finance gets checked against the source export first.
A practical order: run the mapping and baseline prompts first (they tell you where the money is), then the forecasting and inventory prompts (they price the buffers), then supplier and money prompts (they move the terms), then operations and risk prompts (they protect the gains). Each artifact hands the next prompt its inputs, run them out of order and you get answers to questions you have not earned yet, which is exactly how doomed initiatives get their charts.
Mapping and Baseline Prompts
The founding prompt draws the chain; the second prices it; the third prioritizes it. The SCOR-Lite Map Builder takes your business type, revenue, SKU count, suppliers with lead times, and fulfillment setup, and produces the five-link map with one exposing number per link and a weakness ranking with reasoning, the full method is walked in our guide to mapping a supply chain on one page. The CFO Translator closes the loop: it converts your map and numbers into a 300-word briefing where every claim carries a number and the final sentence is one your CFO can repeat to their team.
- SCOR-Lite Map Builder, business type, revenue, SKU count, suppliers with lead times in; a five-link map out with one exposing number per arrow and a weakness ranking.
- Four-Number Baseline, export descriptions in; exact spreadsheet formulas for fill rate, turns, OTIF, and cash conversion cycle out, with the data trap flagged for each.
- Weak-Link Prioritizer, map, numbers, and audit scores in; weaknesses ranked by cost-of-inaction times fixability, and it refuses to prescribe solutions until the diagnosis is sharp.
- CFO Translator, the map and numbers in; a 300-word briefing out where every claim carries a number and no jargon survives.
Forecasting and Inventory Prompts
This family prices your buffers honestly, which is where most mid-size chains either sit on cash or starve service. The Safety Stock Lab walks one SKU through the full calculation, deviation over the right window, service level by class, the lead-time term, and the honest test of whether your supplier's delivery spread demands the term most teams skip, and ends with the one-sentence defense you can say in a finance review. The safety stock formula guide pairs with it symbol by symbol.
- MAPE Baseline Builder, demand history in; forecast error scored at decision grain, portfolio and by ABC class, with the five worst SKUs ranked by dollar error rather than percentage.
- Bias-or-Noise Diagnostician, six months of errors in; a verdict on whether the error is bias with a findable mechanism or noise to buffer, using the one-third rule.
- Safety Stock Lab, one SKU's demand and supplier history in; the full calculation shown step by step, the class-based service level set, and the one-sentence finance defense out.
- ROP Calculator, lead times and review cadence in; reorder points out, including the cadence test that flags SKUs whose policy is dead on arrival.
- Buffer Repricing Auditor, current on-hand rules versus formula demands across your top hundred SKUs; the three lists out, starved, fitted, overfed, with dollar totals.
Supplier and Money Prompts
The money prompts turn relationship folklore into priced decisions. The Scorecard Evidence Puller converts messy operational data into five cited dimension scores, OTD from receipt dates, reject rates from receiving logs, landed-cost trend from your baseline, and names the two data gaps to fix before next quarter's scoring; the full method lives in our supplier scorecard guide. The Terms-Ladder Pricer computes what each rung is worth to you AND to them, because the gap between the two is where trades live.
- Scorecard Evidence Puller, receiving and PO data in; five cited dimension scores out, with the two data gaps named before next quarter's scoring.
- Negotiation One-Pager Builder, targets, history, and supplier pressures in; targets and floors for all six rungs out, price, lead time, MOQ, payment terms, quality protocol, flexibility, with any unverified walk-away flagged as a bluff risk.
- Terms-Ladder Pricer, your costs and their incentives in; what each rung is worth to both sides out, with the trade gap priced in dollars.
- Drill Partner, the deal brief in; a live role-play out where the AI plays your supplier, pushes price first, tests your walk-away once, and pauses the rehearsal whenever you concede without a get.
Operations and Risk Prompts
The operations family protects the gains the earlier prompts created. The Lead-Time Autopsy is the one to run before any speed initiative: it decomposes twelve months of POs into order, queue, make, ship, and clear, with medians, ranges, and the promised-versus-actual gap, and the "days hide here" ranking usually surprises. When you are ready to act on it, our guide to reducing lead time without asking anyone to work faster shows where the days actually come out.
- Lead-Time Autopsy, twelve months of POs in; the five-stage decomposition out with medians, ranges, and the promised-versus-actual gap.
- Documentation Pre-Check Builder, your lane and paperwork in; a ten-point checklist out with failure modes, timing rules, and the error taxonomy ranked by delay days.
- Risk Register Builder, your chain's known fragilities in; eight to ten named risks scored on probability, impact, AND detectability, with the trap called out: which ones would surprise you.
- Playbook Card Writer, each named risk in; a one-page card out with numeric trigger conditions, first-hour actions, cross-team fallbacks, and re-entry criteria.
- Downstream Repricer, a proposed lead-time or buffer change in; the five-line CFO summary out across buffers, pipeline cash, forecast horizon, and the cash cycle.
The Prompt Map: Route the Pack in One Table
When time is short, route by decision rather than by number. The map below shows each prompt family, the input you supply, and the artifact you keep, and it doubles as the day sequence of the full program, top to bottom.
| Decision | Prompt | Input you supply | Artifact you keep |
|---|---|---|---|
| Where are we weak? | SCOR-Lite Map Builder | Suppliers, lead times, volumes | Five-link map with exposing numbers |
| What are the numbers? | Four-Number Baseline | Export descriptions | Fill rate, turns, OTIF, cash cycle formulas |
| What do we fix first? | Weak-Link Prioritizer | Map, numbers, audit scores | Ranked weaknesses by cost and fixability |
| Can we trust the forecast? | Bias-or-Noise Diagnostician | Six months of errors | Bias verdict with the mechanism named |
| How much buffer? | Safety Stock Lab | One SKU's demand and supplier history | Auditable calculation plus finance defense |
| What are suppliers worth? | Terms-Ladder Pricer | Costs and incentives | Rung-by-rung trade values in dollars |
| Where do days hide? | Lead-Time Autopsy | Twelve months of POs | Five-stage decomposition with medians |
| What would the CFO ask? | Downstream Repricer | The proposed change | Five-line cash and service summary |
Source: ZLearning Supply Chain & Logistics Optimization prompt vault, Days 1-14
The AI Adoption Numbers in Planning Teams
It is worth knowing how fast this practice is spreading, because analysis speed is now competitive. McKinsey's global surveys found 33% of organizations regularly using generative AI in 2023, 65% in 2024, and 71% in 2025, a doubling in two years that shows up in planning teams as spreadsheet copilots, demand diagnosticians, and negotiation drill partners. Supply chain planning was one of the earliest functional adopters, because the work is already data-shaped and the cost of a good prompt is trivial next to the cost of a wrong buffer.
The practical reading for you: the analytical baseline is rising. When a competitor's planner runs a lead-time autopsy in an afternoon that used to take a consultant a month, the gap shows up in service levels and cash within two quarters. The tool-by-tool notes live in the FAQ above; the prompts supply the structure that makes any assistant useful.
Sources: McKinsey Global Survey on AI 2023 · McKinsey Global Survey on AI 2024 · McKinsey Global Survey on AI 2025
The Resilience Numbers Your Analysis Defends
The prompts are analysis tools, but the reason they matter is risk, and the risk is documented. Accenture's 2021 analysis found 94% of Fortune 1000 companies experienced pandemic-era supply chain disruptions, with 75% reporting negative business impact. McKinsey's 2020 survey of global supply chain leaders found 93% planning resilience actions, dual sourcing, more buffer, regionalization, and McKinsey Global Institute's value-chain research estimates firms sacrifice roughly 45% of one year's profits over a decade to disruptions. The supply chain statistics roundup collects the wider set with sources.
Read those numbers as a job description for the pack. The map exposes the single-source arrows that turn a disruption into a shutdown; the baseline prices the buffers that absorb one; the autopsy finds the lead-time lies that make the plan late; and the playbook cards put numeric triggers on the risks that would otherwise surprise you. Resilience is not a slide, it is the output of analysis someone was willing to run, and these prompts lower the cost of running it to an afternoon.
Sources: Accenture analysis 2021 · McKinsey supply chain survey 2020
Your 30-60-90 Analysis Plan
Analysis compounds when it meets a rhythm, so plan the ninety days rather than running prompts on inspiration. The calendar below is the one we teach in the Supply Chain & Logistics Optimization program, and it fits inside a normal planning cycle. If you want physical materials for a planning workshop, supply chain case studies books and coaching toolkits, the store versions of the same frameworks run offline in S&OP kickoffs and team training days.
One closing calibration: the machine is the analyst, not the decision-maker. Every prompt here ends in something you must own, a priority, a buffer, a trade, a trigger. The planners who thrive with AI are not the ones who outsource judgment but the ones who rehearse it at higher volume, and twelve prompts on a ninety-day rhythm are enough to run that rehearsal on your real chain, starting with the exports you already have open.
| Window | Focus | Proof it worked |
|---|---|---|
| Days 1-30 | Run the map, baseline, and prioritizer on real exports | One-page map, four clean baseline numbers, ranked weak links |
| Days 31-60 | Price the buffers with the Safety Stock Lab; rebalance the top hundred SKUs | Starved-fitted-overfed lists with dollar totals and fill rate moving |
| Days 61-90 | Run the autopsy and supplier prompts; deliver the CFO briefing | Lead-time gaps on file, one scorecard in use, one brief delivered |
Source: ZLearning Supply Chain & Logistics Optimization, capstone materials
Frequently asked questions
▸What makes a supply chain AI prompt actually useful instead of generic?
Three ingredients: a defined role ("act as a sourcing analyst", not "help me with suppliers"), your real numbers as inputs, lead times, reject rates, OTD history, filled in before you run, and a required output format: a table, a ranked list, a one-page brief. Generic prompts like "how do I improve my supply chain" produce listicles; structured prompts produce artifacts you can defend in a review. Every prompt below follows the role-input-output pattern and names the data to have open first.
▸Which AI tools do these supply chain prompts work with?
All twelve run in ChatGPT or Claude as-is, our best AI tools for supply chain teams shortlist has tool-by-tool notes. The spreadsheet-shaped ones, baseline calculators, ABC classing, freight audits, also work as Sheets formula walkthroughs: paste the prompt and ask for copy-pasteable formulas. Perplexity is useful for the market-facing prompts (freight rate context, supplier financial signals) because it cites sources. Power BI and Excel users can feed the same outputs into measures; the analysis logic is tool-agnostic.
▸How do I stop the AI from making up numbers in supply chain analysis?
Two habits. First, never ask it to estimate what you can paste, supply the actual history (demand, lead times, OTD) and instruct it to flag any input it had to guess, marking guesses GUESS so you know what to verify. Second, require intermediate steps: a safety stock calculation that jumps from inputs to an answer without showing the deviation, the window, and the service factor is a calculation you cannot audit, and unauditable calculations do not survive finance reviews.
▸Do prompts like these replace a supply chain course?
No, they are the daily practice layer. The prompts make the analysis fast; the free supply chain course walkthrough shows the sequence that decides which analysis is worth running: map before money, money before buffers, buffers before triggers. Run the pack on real exports, then use the structured program when you want the sequencing and the feedback.
▸Can AI really handle supplier negotiation preparation?
The preparation, yes, and preparation is most of the outcome. AI drafts the one-pager with targets and floors per negotiation rung, prices every give in dollars so nothing leaks for free, and rehearses the room by playing the supplier while logging every unpriced concession. What it cannot do is read the room or hold the relationship. Buyers who rehearse with AI before a renewal consistently catch their own expensive habits, giving away terms for free is the classic, before the real meeting charges them for it.
▸How do I use these prompts with confidential supplier data?
The describe-don't-dump rule applies: structure, not identities. "Component A, single source, 68-day lead time, 4% reject rate, price up 9% this year" gives the model everything it needs without naming anyone. Strip supplier names, contract numbers, and pricing you consider secret, the analysis works identically with placeholders, and you fill real figures in offline. Your contracts stay the source of truth; the AI drafts, you decide.
▸How often should I run these prompts?
Match the cadence to the artifact: the lead-time autopsy runs quarterly or after any sourcing change, the forecast diagnostics run monthly against your last cycle, the baseline calculator runs whenever your exports refresh, and the negotiation prompts run per event. A rhythm beats a burst, ten minutes a week on the numbers beats an annual heroics session nobody repeats.
