Purpose-built LLM systems, multi-agent reasoning workflows, and domain-adapted models.
Universal semantic metric layers, natural language querying, and executive intelligence.
Mathematical constraint solvers (MILP, CP-SAT) for scheduling, allocation, and routing.
Pragmatic ERP modernisation, event-driven API mesh, and custom operational applications.
55 copy-paste prompts for planners, buyers and OR analysts. Use them with Claude, ChatGPT or Gemini.
FREE PROMPT LIBRARY · SUPPLY CHAIN & OPERATIONS
55 copy-paste prompts for planners, buyers and OR analysts. Use them with Claude, ChatGPT or Gemini.
Get the Prompt Library
What's inside
01 Daily planning02 Inventory
Forecast error, safety stock, ABC/XYZ and S&OP prompts, with the standard formulas built in
03 Procurement and suppliers04 Logistics
Supplier scorecards, RFQ comparisons, landed cost and freight audits from a pasted table
05 Operations research modelling with AI
Turn planning problems into LP/MIP models and working PuLP or OR-Tools code, with two tested worked examples
The Excel file
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ID | Section | Title | When to use it |
| 2 | 1.1 | 1. Daily planning | Morning demand review | Start of the day or week, when you want a quick read on what moved in demand and what needs attention. |
| 3 | 1.2 | 1. Daily planning | Forecast error and bias from a pasted table | Monthly or weekly forecast accuracy review, by SKU, category or planner. |
| 4 | 1.3 | 1. Daily planning | Find forecasts that are drifting (tracking signal) | When you suspect a forecast is consistently high or low and want an objective flag rather than a gut call. |
| 5 | 1.4 | 1. Daily planning | Planning exception triage | When the ERP or planning tool gives you a long exception list and you need to decide what to work on first. |
| 6 | 1.5 | 1. Daily planning | Stock-out and overstock alert scan | Daily or weekly scan of the inventory position across SKUs and locations. |
| 7 | 1.6 | 1. Daily planning | Explain a demand spike or drop | When a SKU or customer moves sharply and someone asks "why?" before the planning meeting. |
| 8 | 1.7 | 1. Daily planning | S&OP meeting pre-read | A day or two before the demand review, supply review or executive S&OP meeting. |
| 9 | 1.8 | 1. Daily planning | S&OP minutes to decisions and actions | Straight after the meeting, from your notes or a transcript. |
From the Read me tab: “Go to the Prompts tab. Use the filter on the Section column to see one area at a time.”
Prompt preview
Calculate safety stock and reorder point for each SKU in the table. Use these standard formulas, and keep all time units consistent (convert lead time into the same period as demand): - d = average demand per period - sd = standard deviation of demand per period - L = average lead time in periods - sL = standard deviation of lead time in periods - z = service factor for the target cycle service level: 90% = 1.28, 95% = 1.65, 97.5% = 1.96, 98% = 2.05, 99% = 2.33 If lead time is treated as fixed: Safety stock = z x sd x sqrt(L) If lead time also varies: Safety stock = z x sqrt( L x sd^2 + d^2 x sL^2 ) Reorder point = d x L + Safety stock Target service level: [SERVICE LEVEL BY CLASS, e.g. A = 98%, B = 95%, C = 90%]. Output a table with SKU, d, sd, L, sL, z, safety stock, reorder point, safety stock value in [CURRENCY], and the days of cover the safety stock represents. Round up to [PACK SIZE / WHOLE UNITS]. Show the full calculation for the first SKU. Flag SKUs where the calculated safety stock differs from the current setting by more than [25]%. [PASTE TABLE]
Paste with it: SKU, class, demand history (or average and standard deviation), lead time and its variability if known, unit cost, current safety stock.
Calculate the landed cost per unit for the import below and lay it out as a step-by-step build-up. Shipment: [PRODUCT], HS code [HS CODE], quantity [QTY] [UOM], unit price [PRICE] [CURRENCY], Incoterm [INCOTERM], origin [COUNTRY], destination [COUNTRY / PORT / PLANT]. Cost elements (use my numbers; where I have not given one, say so and show it as a separate line): - Product cost - International freight and insurance - Customs value, on the basis the destination country uses ([e.g. India: assessable value, generally CIF; US: generally the transaction value, excluding international freight and insurance]) - Duties and taxes, each on its correct base, at the rates I provide: [RATES, e.g. India: Basic Customs Duty on assessable value, Social Welfare Surcharge on BCD, IGST on assessable value + BCD + SWS; US: duty rate, MPF, HMF] - Customs broker, port and handling charges - Inland freight to [PLANT / DC] - Other: [BANK CHARGES, INSPECTION, PACKAGING] Output a table with each element, its calculation base, rate, amount and per-unit amount. Separately show which taxes are normally recoverable as input credit (for example IGST in India, where eligible) so I can see cash outlay versus true cost. State every assumption. Do not look up or guess duty rates; use only the rates I give and flag any that are missing.
Paste with it: Commercial terms, HS code, duty and tax rates from your broker or the tariff, freight and local charges.
I am a production planner. Formulate a multi-period production planning model and write it in [PuLP / Pyomo / OR-Tools]. Products: [LIST]. Periods: [e.g. 12 weeks]. Resources: [LINES / MACHINES] with available hours per period [HOURS] and hours per unit for each product [TABLE]. Demand by product and period: [TABLE]. Opening stock: [TABLE]. Costs: variable production cost per unit [TABLE], holding cost per unit per period [TABLE], overtime [HOURS AVAILABLE AND COST PER HOUR], [BACKORDER COST IF ALLOWED / no backorders]. Other rules: [MINIMUM BATCH, SAFETY STOCK FLOOR, STORAGE LIMIT, CHANGEOVERS]. Give me: (1) the problem in plain words, (2) sets, parameters and decision variables, (3) objective and constraints in maths notation with a one-line explanation of each, (4) assumptions, (5) commented code that reads the data from [CSV / EXCEL FILE NAMES], solves with [CBC / HiGHS] and writes the plan to Excel, (6) how to read the output, including the shadow prices on capacity.
Paste with it: Products, periods, capacities, hours per unit, demand, opening stock, costs, and any extra rules.
PDF + Excel
55 copy-paste prompts for planners, buyers and OR analysts. Use them with Claude, ChatGPT or Gemini.
