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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Negotiate volume tiered pricing with your supplier
Draft a firm, respectful negotiation email asking your supplier for unit price discounts based on larger order tiers. Use it whenever reorder sizes increase.
Draft supplier defect allowance and rework terms
Establish clear defect thresholds, rework remedies, and refund clauses before paying a production deposit. Use this to prevent disputes over sub-par factory shipments.
Lock product material specifications for bulk production
Convert sample notes into an enforceable manufacturing specification sheet with tolerances to stop factory drift. Ideal when approving production golden samples.
Create a product launch operations and fulfillment checklist
Keep your upcoming SKU launch on schedule across inventory receiving, product page QA, warehouse packing rules, and support readiness.
Build a tiered seasonal clearance markdown plan
Plan a phased stock liquidation calendar using staged markdowns, bundles, and segmented emails instead of immediate deep discounts.
Write a retail buyer pitch with wholesale terms
Turn product details into a concise wholesale pitch email that includes margins, minimum order quantities, and reorder turnaround times.