Input your sales data parameters and get a demand forecasting framework with reorder points, safety stock calculations, and seasonal adjustment methods.
Paste into any LLM with your inventory parameters. Use the output to prevent stockouts and reduce overstock waste.
You are an inventory planning expert who has managed $100M+ in inventory across multi-SKU e-commerce operations without stockouts or excessive dead stock. Product count: [NUMBER OF SKUS] Sales channel: [SINGLE STORE/MULTI-CHANNEL/WHOLESALE + DTC] Lead time from supplier: [DAYS OR WEEKS] Sales velocity: [UNITS PER DAY OR WEEK] Seasonality: [HIGHLY SEASONAL/MODERATE/STEADY] Build a complete inventory planning system: **1. Demand Forecasting Model** - Historical sales analysis approach (moving average, weighted, exponential smoothing) - Trend identification (growing, stable, declining) - Seasonality factors (monthly coefficients) - New product launch forecasting (without history) - Promotional demand modeling (how sales spike during promotions) - External factor adjustments (market trends, competitor moves) **2. Reorder Point Calculation** - Formula: Reorder Point = (Daily Sales Rate x Lead Time) + Safety Stock - Daily sales rate calculation method - Lead time variability buffer - Safety stock formula and factors - Service level targets (95%, 97%, 99% and what each means) **3. Order Quantity Optimization** - Economic Order Quantity (EOQ) formula and application - MOQ constraints from suppliers - Cash flow considerations - Storage capacity limitations - Quantity discount breakpoints **4. Inventory Classification** - ABC analysis: A (top 20% SKUs, 80% revenue), B (next 30%), C (bottom 50%) - XYZ analysis: demand variability (predictable vs erratic) - Combined ABC-XYZ matrix for inventory policy per segment - Dead stock identification criteria - Hero product vs long tail strategy **5. Seasonal Planning** - Season prep timeline (when to order for each season) - Holiday inventory calendar (Black Friday, Christmas, Valentine's, etc.) - End-of-season markdown strategy - Carryover inventory management - Pre-season vs in-season buying split **6. Multi-Channel Inventory** - Allocation strategy across channels - Safety stock per channel vs pooled - Fulfillment priority when stock is low - Channel-specific lead time differences - Inventory sync and oversell prevention **7. Reporting and Dashboards** - Daily: stock level alerts, stockout risk, incoming orders - Weekly: sell-through rate, weeks of supply, reorder queue - Monthly: inventory turnover, dead stock %, margin analysis - Key metrics: GMROI, inventory turnover ratio, fill rate, stockout rate **8. Spreadsheet/Tool Setup** - Inventory tracking spreadsheet template (columns, formulas) - Reorder alert automation - Supplier PO template - Receiving and counting process - Shrinkage tracking Provide actual formulas and calculation examples with sample numbers.
The effectiveness of "Inventory Forecasting and Demand Planning" comes from its in-depth structure. By incorporating sequential task breakdown and output formatting and negative constraints, it channels the AI's capabilities toward producing exactly what you need. The end result is conversion-tested product content optimized for your specific platform and buyer journey stage, delivered on the first try rather than after multiple failed attempts.
These e-commerce tips will help you get stronger results when using "Inventory Forecasting and Demand Planning" and similar prompts in this category.
"Inventory Forecasting and Demand Planning" is particularly useful in these situations. If any of these scenarios sound familiar, this prompt will save you significant time.
When you use "Inventory Forecasting and Demand Planning" with ChatGPT, Claude, or Gemini, here is what to expect in the AI output.
Adapt "Inventory Forecasting and Demand Planning" to your specific situation by modifying these key areas. The more context you add, the better the results.