35 ChatGPT Prompts for Logistics and Supply Chain Coordinators: Streamline Operations with AI

#logistics #chatgpt #productivity #ai

Supply chain disruptions, carrier negotiations, inventory imbalances, and compliance documentation are daily realities for logistics and supply chain coordinators. AI can help you draft sharper communications, build faster SOPs, analyze vendor performance, and plan around disruptions before they become crises. These 35 prompts are designed for coordinators who want to move faster, communicate clearly, and keep their supply chains resilient.

1. Carrier & Vendor Management

Write a professional email to a freight carrier requesting a rate review for our LTL shipment lanes between [ORIGIN CITY] and [DESTINATION CITY]. We ship approximately [NUMBER] pallets per week averaging [WEIGHT] lbs. Highlight our consistent volume, low claims history, and long-term partnership value. Request a revised rate schedule and propose a meeting to discuss a 12-month contract.

Create a carrier performance scorecard template for evaluating our top 5 truckload carriers on a monthly basis. Include the following KPIs: on-time pickup percentage, on-time delivery percentage, claims ratio (dollar value of claims / total freight spend), tender acceptance rate, and communication responsiveness (rated 1-5). Add a weighted scoring formula and a rating scale (Preferred, Approved, Probationary, Disqualified).

Draft a vendor corrective action request (CAR) letter to a supplier who has had three late deliveries in the past 30 days, resulting in a production line stoppage on one occasion. The letter should: state the performance issue with specific dates and shipment numbers, quantify the business impact, request a root cause analysis and corrective action plan within 5 business days, and note the potential consequences of continued non-performance (removal from approved vendor list).

Write negotiation talking points for a meeting with our primary 3PL provider regarding a 15% rate increase they have proposed for the upcoming contract year. Our counter-position is: we accept a 5% increase, in exchange for guaranteed dedicated storage space, improved SLA commitments (48-hour order fulfillment), and a quarterly business review cadence. Structure the talking points as: our position, rationale, trade-offs we are willing to make, and our walk-away point.

Create a request for proposal (RFP) template for selecting a new less-than-truckload (LTL) carrier. Include sections for: carrier company overview, lane coverage and capacity, service level commitments (transit time by lane), claims handling process and ratio, technology capabilities (EDI, tracking portal, API integration), pricing structure (base rates, fuel surcharge methodology, accessorial schedule), and references from similar shippers.

2. Inventory Management

Explain the step-by-step process for calculating safety stock for a high-demand SKU using the formula: Safety Stock = Z-score x Standard Deviation of Lead Time Demand. Use the following values: average daily demand = 120 units, standard deviation of daily demand = 18 units, average lead time = 7 days, standard deviation of lead time = 1.5 days, and desired service level = 98% (Z = 2.05). Show the calculation and explain what the result means operationally.

Write a memo to the warehouse team announcing a cycle count program to replace the annual physical inventory. Include: the rationale for switching to cycle counting (reduced disruption, more frequent accuracy data), the counting schedule (A items weekly, B items monthly, C items quarterly based on ABC analysis), counting procedure, how discrepancies will be investigated and resolved, and the accuracy target (99.5% location accuracy).

Create an ABC inventory classification analysis template for a SKU portfolio of 200 items. Describe the methodology: rank SKUs by annual dollar volume (unit cost x annual units sold), classify top 20% of items by value as A items (typically ~80% of total value), next 30% as B items (~15% of value), remaining 50% as C items (~5% of value). Include a column structure for the spreadsheet and explain how the classification should drive replenishment frequency and safety stock policy.

Draft a root cause analysis memo for an inventory discrepancy of 450 units of [SKU NAME] discovered during a cycle count. The system showed 1,200 units on hand; the physical count found 750. Walk through a structured 5-Why analysis framework, list the most probable root causes (receiving errors, unreported damage, mislabeled locations, theft, system entry errors), and propose corrective actions with owners and due dates.

Write an escalation email to the procurement team notifying them that [PRODUCT SKU] is at a critically low inventory level (2 days of supply remaining) due to a delayed shipment from the primary supplier. Include: current inventory on hand, average daily consumption, days of supply remaining, last known shipment status, impact on customer orders if not resolved, and the immediate action being taken (emergency PO to backup supplier, allocation to priority customers).

3. Shipping & Freight Operations

Create a standard operating procedure (SOP) for outbound LTL shipment processing. Cover: order release from the WMS, bill of lading preparation (required fields, special instructions for hazmat or temperature-sensitive freight), pallet labeling requirements (carrier label placement, pallet count), carrier scheduling and pickup confirmation, and documentation filing (BOL, packing list, POD tracking).

Draft a freight claim letter to [CARRIER NAME] for damage discovered on delivery of shipment PRO# [NUMBER]. The shipment contained [QUANTITY] units of [PRODUCT], valued at $[AMOUNT]. Damage was documented at delivery with signed exception on the POD and photographs. Include: claim amount, description of damage, documentation enclosed list, request for inspection if required, and the 9-month filing deadline reminder per the Carmack Amendment.

Write an email to our customs broker requesting the tariff classification (HTS code) and estimated duties for importing [PRODUCT DESCRIPTION] from [COUNTRY OF ORIGIN] into the United States. Provide: a product description, materials composition, intended use, and country of origin. Ask for the HTS-10 code, applicable duty rate, any applicable Section 301 tariff, and an estimated landed cost per unit if possible.

Create a shipping mode selection decision framework for our team. When do we use: (1) standard LTL, (2) volume LTL or partial truckload, (3) full truckload (FTL), (4) intermodal, (5) air freight, and (6) parcel (UPS/FedEx). For each mode, specify the ideal shipment size range, transit time expectations, cost relative to other modes, and the top two or three use cases where it is the best choice.

Draft a carrier routing guide for our top 20 shipping lanes. Structure it as a table with columns: Origin State/Region, Destination State/Region, Primary Carrier, Secondary Carrier, Service Level (standard/expedited), Estimated Transit Days, and Special Instructions. Add a preamble paragraph explaining that carriers must be used in the order listed and that deviations require manager approval.

4. Supply Chain Risk & Disruption Management

Create a supply chain risk assessment matrix for our top 15 suppliers. For each supplier, evaluate: supply concentration risk (% of spend), geographic risk (single-country source?), financial stability risk, lead time variability, quality performance history, and logistics dependency. Score each risk factor 1-3 (low/medium/high) and calculate a composite risk score. Flag suppliers with a score above 12 as high-priority for contingency planning.

Write a business continuity plan outline for a supply chain disruption caused by a major port closure at [PORT NAME] for an estimated 3-4 weeks. Cover: immediate actions (in-transit inventory assessment, customer communication), short-term alternatives (rerouting through alternative ports, air freight for critical SKUs), mid-term alternatives (activating secondary suppliers, adjusting production schedules), and communication cadence with internal stakeholders and customers.

Draft a supplier diversification proposal memo to the VP of Supply Chain recommending that we qualify a second source for [COMPONENT/PRODUCT] currently sole-sourced from [SUPPLIER NAME]. Include: the current single-source risk, recent disruptions that have impacted supply continuity, the proposed qualification process and timeline (NDA, samples, quality audit, pilot orders), estimated cost impact of dual sourcing (price premium), and the risk reduction benefit.

Create a supply disruption communication template to send to key customers when we anticipate a product shortage. The template should: acknowledge the situation without over-disclosing internal supply chain details, state the expected duration of the shortage, describe what we are doing to mitigate the impact, provide a prioritization policy (how we will allocate available inventory), and give a specific point of contact for questions. Keep the tone proactive, transparent, and solution-focused.

Write a post-disruption lessons-learned report template for use after a significant supply chain disruption event. Include sections for: event summary and timeline, root cause analysis (using 5-Why or fishbone diagram framework), business impact assessment (lost revenue, expedite costs, customer chargebacks), response effectiveness evaluation (what worked, what did not), and corrective actions with owners, due dates, and success metrics.

5. Procurement & Purchasing

Draft a purchase order terms and conditions summary (plain-English version for internal training) covering the 10 most important clauses: acceptance of PO, price and payment terms, delivery schedule and penalties for late delivery, quality and inspection rights, warranties, changes and cancellations, intellectual property, confidentiality, force majeure, and governing law. Note one key implication for the procurement team under each clause.

Write a request for quotation (RFQ) email to three potential suppliers for [PRODUCT/COMPONENT NAME]. Include: product specifications (reference attached data sheet), quantity required (annual volume and initial order quantity), required delivery lead time, quality and certification requirements (ISO, RoHS, etc.), packaging requirements, and response deadline. Ask each supplier to quote unit price by volume tier, lead time, minimum order quantity, and payment terms.

Create a total cost of ownership (TCO) comparison framework for evaluating two suppliers for the same component: Supplier A (domestic, higher unit price, short lead time) vs. Supplier B (overseas, lower unit price, 8-week lead time). Include TCO factors beyond unit price: freight cost per unit, inventory carrying cost (based on lead time difference), quality cost (estimated defect rate x rework cost), risk premium, and administrative cost. Show the calculation structure with placeholder values.

Draft a supplier onboarding checklist for a new raw material supplier. Include: legal and compliance documents (W-9, certificate of insurance, business license), quality documentation (ISO certification, control plan, PPAP or first article inspection), logistics setup (EDI capability, lead time, minimum order quantity, packaging specs), payment and banking setup, and a 90-day performance review schedule.

Write an internal memo requesting approval to place an emergency purchase order outside of the standard bid process for [PRODUCT] due to a critical production shortage. Include: the urgency and business impact of not acting immediately, the supplier selected and rationale (fastest available lead time, qualified supplier), the unit price and total PO value, the deviation from standard procurement policy being requested, and a plan to return to competitive bidding at the next regular procurement cycle.

6. Warehouse & Distribution Operations

Create a warehouse layout optimization recommendation for a 50,000 sq ft distribution center that currently handles a mix of fast-moving consumer goods and slow-moving industrial parts. Describe: the principles of slotting (golden zone, velocity-based slotting, product affinity grouping), where fast-moving SKUs should be located relative to packing and shipping, how to handle seasonal fluctuation in SKU velocity, and key metrics to track after re-slotting (picks per labor hour, travel distance, order accuracy).

Write a training guide for new warehouse associates on the correct procedures for receiving inbound shipments. Cover: advance shipment notice (ASN) review, count verification and quality inspection at dock, discrepancy documentation (overage, shortage, damage), put-away procedures using the WMS, and when to escalate (refused shipment criteria, supervisor notification triggers).

Draft a warehouse KPI dashboard outline for weekly review with the distribution center manager. Include 8 metrics: inbound receipts per labor hour, put-away accuracy rate, order fill rate, order picking accuracy (lines picked correctly / total lines), on-time shipment rate, dock-to-stock cycle time, inventory accuracy (from cycle count), and labor cost per unit shipped. For each metric, define the calculation, the target, and the data source.

Create a returns processing SOP for handling customer returns in a B2B distribution environment. Cover: return merchandise authorization (RMA) issuance criteria, receiving and inspection procedure, disposition decision tree (restock, refurbish, vendor return, scrap), credit memo issuance trigger, inventory system update, and quarterly returns analysis reporting to identify root causes (shipping damage, wrong item, quality defect).

Write a cross-docking procedure guide for a distribution center that receives full truckloads from a manufacturing plant and breaks them into zone-based deliveries for 15 retail stores. Include: inbound trailer assignment and dock door management, freight staging and sorting by store/zone, labeling requirements for sorted freight, driver dispatch sequence, and performance metrics (dock-to-door time, sort accuracy rate).

7. Reporting & Stakeholder Communication

Create a weekly supply chain performance report template for distribution to the operations leadership team. Include sections for: on-time delivery summary (vs. target), inbound and outbound shipment volume, inventory position highlights (days on hand by product category, any critical stock-outs or excess), top 3 open issues and their status, and the forward look for the coming week (expected shipments, potential risks, planned activities).

Draft an executive briefing (one page, bullet format) for the CFO summarizing the financial impact of Q3 supply chain disruptions. Include: total expedite freight spend above plan ($[AMOUNT]), customer chargebacks received due to late deliveries ($[AMOUNT]), estimated lost revenue from stockouts ($[AMOUNT]), and the total incremental cost. Close with three recommended investments to reduce exposure in Q4.

Write a root cause analysis and corrective action report for a shipment to [CUSTOMER NAME] that arrived 4 days late due to a carrier pickup failure, resulting in a $[AMOUNT] chargeback. Include: incident timeline, root cause (use 5-Why), immediate containment action, corrective action (carrier re-routing protocol update), preventive action (automated pickup confirmation alert in TMS), and the expected recurrence risk after corrective actions are implemented.

Create a supply chain quarterly business review (QBR) agenda for a 60-minute meeting with our top 3PL provider. Include: welcome and agenda review (5 min), scorecard review against contracted SLAs (15 min), top 3 issues from the quarter with resolution status (10 min), capacity planning for next quarter including peak season (10 min), continuous improvement initiatives update (10 min), and open discussion and action item capture (10 min).

Draft a change management communication email to the warehouse and procurement teams announcing the implementation of a new transportation management system (TMS) starting [DATE]. Cover: why the change is happening (visibility, cost savings, automation), what will change for each team (new booking process, carrier portal access, automated BOL generation), the training schedule, who to contact with questions, and a go-live support plan for the first two weeks.