#reorder plan prompt

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.

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.