💼 Business
Supply Chain Prompt: Reorder Plan and Supplier Risk Check
Paste your SKU stock, demand, lead times, and supplier record to get weeks of cover, a reorder list with the math, stockout dates, and a supplier email.
0Reviews
Prompt
Act as a supply chain planner for a small product business who turns a stock sheet and supplier history into this week's reorder decisions. You show every calculation, you use only the numbers I paste, and you flag stockout risk by week. Inputs: - SKU table: SKU, on hand, open purchase orders with arrival week, average weekly demand, lead time in weeks, MOQ, unit cost: [SKUTable] - Supplier record per SKU: on-time deliveries out of recent orders, typical delay, quality issues: [SupplierRecord] - Coverage goal: lead time plus how many weeks of safety stock: [CoverageGoal] - Known demand changes: promotions, seasonality, a big customer order, with weeks and size as I estimate them: [DemandEvents] - Limits: cash available for purchase orders now, storage space, case packs: [Constraints] Generate: 1. Coverage table: for each SKU, inventory position (on hand plus open orders), weeks of cover (position divided by weekly demand), required weeks (lead time plus safety), and status: order now, watch, or fine. 2. Week-by-week check for any SKU marked order now or watch: stock at the end of each week until the next delivery could arrive, including DemandEvents, and the first week it would hit zero. 3. Reorder list: quantity needed to cover the required weeks including DemandEvents, adjusted for MOQ and case packs, cost per line, and the total against the cash limit. Show the math. 4. Supplier risk: for each supplier, on-time rate from SupplierRecord and what a typical delay would do to the week-by-week check. 5. Actions this week, in order, with an owner role. 6. A short email to the riskiest supplier asking for the specific help the plan needs (date, partial shipment, confirmation). 7. Data gaps that would change the plan. Rules: - Never invent demand, prices, lead times, or supplier performance. - Round units up to whole units and money to cents.
Instructions
Paste the prompt into ChatGPT, fill the brackets with your own stock sheet and supplier history, and check the math lines against your spreadsheet before placing orders. The plan uses only the numbers you give it.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
SKUTable: BOT-24 insulated bottle 24 oz: on hand 1,800; no open PO; demand 300 per week; lead time 6 weeks; MOQ 1,000; unit cost $6.20 LID-STD spare lid: on hand 2,400; no open PO; demand 150 per week; lead time 4 weeks; MOQ 2,000; unit cost $0.90 KID-12 kids bottle 12 oz: on hand 600; open PO 1,000 arriving in week 3; demand 120 per week; lead time 8 weeks; MOQ 500; unit cost $4.10 SupplierRecord: BOT-24 from Harbor Metalworks, 11 of the last 12 orders on time; KID-12 from Bright Cup Co., 7 of the last 10 on time, late orders averaged 2 weeks late; LID-STD from Harbor Metalworks CoverageGoal: lead time plus 2 weeks of safety stock DemandEvents: holiday promo on BOT-24 in weeks 6 to 8, I expect demand of 450 per week in those weeks Constraints: $8,000 cash available for purchase orders this month; no case pack rules
Example Output
1. COVERAGE TABLE SKU | Position | Weeks of cover | Required | Status BOT-24 | 1,800 | 1,800 / 300 = 6.0 | 6 + 2 = 8 | ORDER NOW LID-STD | 2,400 | 2,400 / 150 = 16.0 | 4 + 2 = 6 | Fine KID-12 | 600 + 1,000 = 1,600 | 1,600 / 120 = 13.3 | 8 + 2 = 10 | Watch (supplier timing) 2. WEEK-BY-WEEK BOT-24 (no promo weeks 1 to 5 at 300, promo weeks 6 to 8 at 450): End of week 1: 1,500 | 2: 1,200 | 3: 900 | 4: 600 | 5: 300 | 6: 300 - 450 = -150 It runs out during week 6. An order placed today arrives at the end of week 6 at the earliest (6-week lead time), so about 150 units of promo demand are at risk even if you order now. KID-12: end of week 1: 480 | 2: 360 | 3: 240 + 1,000 = 1,240 if the PO is on time. If it is 2 weeks late (week 5): end of week 4: 120 | 5: 0 before the delivery lands. Zero buffer. 3. REORDER LIST BOT-24: demand weeks 1 to 8 = (5 x 300) + (3 x 450) = 1,500 + 1,350 = 2,850. Need 2,850 - 1,800 = 1,050. Above MOQ of 1,000, so order 1,050. Cost 1,050 x $6.20 = $6,510.00. LID-STD: no order. KID-12: no new order; protect the open PO instead. Total: $6,510.00 of $8,000.00 cash, leaving $1,490.00. 4. SUPPLIER RISK Harbor Metalworks: 11 of 12 on time = 91.7%. Low risk, but the BOT-24 gap in week 6 needs speed, not just reliability. Bright Cup Co.: 7 of 10 on time = 70.0%. A typical 2-week delay empties KID-12 in week 5. 5. ACTIONS THIS WEEK 1. Purchasing: place the BOT-24 order for 1,050 today and ask Harbor Metalworks for an earlier partial shipment. 2. Purchasing: get a firm ship date from Bright Cup Co. for the KID-12 PO. 3. Marketing: decide whether to cap promo volume or delay the promo start by a week if no partial shipment is possible. 6. EMAIL TO BRIGHT CUP CO. Subject: KID-12 PO arriving week 3: please confirm ship date Hi, our KID-12 order for 1,000 units is due in week 3, and our stock runs out in week 5. Could you confirm the ship date this week and tell us right away if it may slip? If a delay is likely, could you send part of the order early? Thank you. 7. DATA GAPS - Is demand of 300 per week for BOT-24 steady, or an average hiding a trend? - Can Harbor Metalworks split shipments, and at what cost? - Freight time is assumed to be inside the lead times.