Forecast inventory demand for Indian e-commerce sellers using historical sales data, seasonal patterns, and festive season planning to prevent stockouts and overstock.
Act as an e-commerce supply chain analyst for Indian sellers. Forecast inventory for [SELLER_NAME], products [PRODUCT_CATEGORIES], period [FORECAST_PERIOD]. Analyze: (1) Historical sales trend — monthly/weekly sales patterns, growth trajectory, seasonality decomposition, (2) Indian festive calendar impact — Diwali (300-500% spike), Raksha Bandhan, Dussehra, Eid, Christmas, regional festivals, (3) Sale event planning — Big Billion Days (Sep-Oct), Great Indian Festival, Republic Day, Independence Day sale stocking, (4) Lead time calculation — supplier production time, shipping duration, quality check, warehouse inbound processing, (5) Safety stock computation — based on demand variability and lead time variability, service level target (95-99%), (6) Reorder point and quantity — EOQ model adjusted for Indian logistics constraints, MOQ from suppliers, (7) Dead stock identification — slow-moving inventory aging beyond 90 days, liquidation strategies (clearance, bundling, B2B), (8) Cash flow optimization — inventory investment vs working capital, just-in-time vs bulk buying cost analysis. Generate 90-day rolling forecast with weekly granularity.
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash.
Provide seller name, product categories, and forecast period for inventory demand forecasting.
Initial release
Sign in and download this prompt to leave a review.