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.