Forecast restock dates using sales velocity

Calculate precise reorder triggers and stockout dates based on current units, daily velocity, lead times, and seasonal growth.

You getInventory Forecast Table, critical Action Items and next Steps

Prompt

Prompt
Act as an e-commerce inventory planner. Analyze the stock numbers, daily sales velocity, supplier lead times, and projected quarterly growth rate provided below to calculate reorder schedules.

- Calculate days of inventory remaining from current stock and daily sales.
- Factor in a 14-day safety stock buffer to determine the exact Reorder Point in units.
- Adjust the run-rate using the expected seasonal surge percentage.
- Point out which SKU faces the highest stockout danger.

Output format:
- Inventory Forecast Table (Columns: SKU, Current Units, Adjusted Daily Sales, Days Until Stockout, Reorder Point, Target Reorder Date)
- Critical Action Items (bullet list of immediate POs required)
- Next Steps (3 items to confirm with your supplier)

Inventory data is below:

Example output

Example for: 3 SKUs, 20% seasonal bump, 30-day supplier lead time, starting date October 1st

Inventory Forecast Table

SKUCurrent UnitsAdjusted Daily SalesDays Until StockoutReorder PointTarget Reorder Date
SKU-A (Wool Beanie)45018 units/day25 days792 unitsImmediate (Oct 1)
SKU-B (Thermal Gloves)1,20024 units/day50 days1,056 unitsOctober 7
SKU-C (Fleece Gaiter)2,10012 units/day175 days528 unitsJanuary 15

Critical Action Items

  • SKU-A is in critical stockout danger: Current inventory will exhaust in 25 days, but supplier lead time is 30 days. Issue a purchase order immediately and evaluate air freight for an initial split batch to prevent a 5-day stockout.
  • SKU-B requires PO release within 6 days: Reorder Point is reached at 1,056 units. Draft the supplier purchase order this week to maintain the 14-day safety cushion.

Next Steps

  • Confirm your factory lead time has not increased ahead of the holiday production freeze.
  • Request freight quotes for an emergency partial air shipment for SKU-A.
  • Verify storage capacity and pallet space with your 3PL for the incoming restocks.
Written by AI from this prompt. Your results will vary.

Paste your inventory list with daily run-rates and supplier lead times into ChatGPT, Claude, or Gemini. As a follow-up, ask the model to recalculate with freight transit delays added.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in E-commerce