AI Prompts for Supply Chain

for the period of July 1, 2026, to September 30, 2026. The key performance indicators (KPIs) we track are: - On-Time Pickup (OTP): Target is >=98% - On-Time Delivery (OTD): Target is >=95% - Tender Acceptance Rate: Target is >=95% - Cost per Shipment vs. Benchmark: Target is <=105% of benchmark - Damage/Loss Rate: Target is <=0.5% of total shipments **DATA:** The CSV has the following columns:

summarizing the key discussion points and agreed-upon action items from our QBR today. **CONTEXT:** We just concluded our Q3 2026 QBR. The key outcomes were: - **Acknowledged Strengths:** OTP performance was strong at 99%. Tender acceptance remains excellent. - **Areas for Improvement:** OTD performance was 93.2%, below our 95% target. The primary cause was identified as delays at the

lane using the provided data. **DATA:** - **Carrier A Data (

. **ACTION:** 1. For each SKU, calculate the Absolute Error (

[[Product Category, e.g., 'Seasonal Decor']]

(8 days from now) **ACTION:** 1. Calculate the "Days of Supply" remaining (

RFP. **CONTEXT:** We need a structured, objective way to compare bids. The evaluation criteria, in order of importance, are: 1. Cost (Price per shipment/mile). 2. Service Level (Guaranteed transit time, OTD commitment). 3. Technology & Visibility (API integration capabilities, real-time tracking platform). 4. Carrier Stability & Experience (Years in business, references, financial health). 5. Sustainability Initiatives (Fleet emissions reporting, EV/alt-fuel options). **ACTION:** 1. Create a markdown table to serve as the evaluation scorecard. 2. Assign a weight to each of the 5 criteria. The weights must sum to 100%. (e.g., Cost: 40%, Service: 25%, Tech: 20%, Stability: 10%, Sustainability: 5%). 3. For each criterion, define a 1-5 scoring rubric. For example: - **Cost (40%):** 5 = >10% below benchmark; 4 = 5-10% below; 3 = at benchmark; 2 = 5-10% above; 1 = >10% above. - **Technology (20%):** 5 = Full API integration & real-time portal; 3 = Portal only; 1 = Manual updates. 4. Include columns for

) and summarize its key points against our evaluation scorecard criteria. **CONTEXT:** You are using the scorecard created in the previous prompt. You need to extract the relevant information from the vendor's 50-page PDF and map it to our 5 evaluation criteria. **ACTION:** For each of the 5 criteria (Cost, Service, Tech, Stability, Sustainability), perform the following: 1. Find the relevant section in the vendor's proposal. 2. Extract the vendor's specific claims or data points. 3. Present the findings in a structured list. **Example Output Format:** * **Cost (Weight: 40%):** * Proposed price:

and have selected another provider. We want to maintain a good relationship with the unsuccessful bidder for future opportunities. **ACTION:** Write an email to

. **CONTEXT:** We are considering a new supplier,

days. This port is a critical hub for our inbound components from Asia. **ACTION:** Write a concise, factual alert for internal distribution to the S&OP team, procurement, and customer service leads. The alert must include: 1. **Subject Line:** "ALERT: Potential Disruption at

[Paste news article text about a factory fire, a new trade tariff, a regional conflict, etc.]

- **Route Plan (from optimization software):** - Total Stops:

- **Planned Data:** - Planned Start Time: 08:00 - Planned End Time: 14:27 - Planned Miles: 85 - Planned Stops: 18 - **Actual Data (from telematics):** - Actual Start Time: 08:15 - Actual End Time: 15:30 - Actual Miles: 92 - Actual Stops Completed: 18 - Telematics Log Notes: "Unusual traffic on I-5 from 10:15-10:45 AM due to accident. Stop 7, customer not ready, 20 min delay." **ACTION:** 1. Calculate the variance for duration, miles, and start time. 2. Present a comparison in a markdown table:

[[e.g., 'Dynamic Replenishment Optimizer v2.1']]