Demand Planning Process
Operations Finance Ops Data Analyst
The prompt
Design a demand planning process.
Business type: {{e_commerce_manufacturer_distributor}}
Product complexity: {{skus_seasonal_variation_lead_times}}
Current forecasting: {{gut_feel_spreadsheet_dedicated_tool}}
Biggest inventory problems: {{stockouts_overstock_both}}
Systems: {{erp_inventory_tool_e_commerce_platform}}
Please design:
1. Data inputs: historical data and forward-looking signals
2. Forecasting method for our complexity level
3. Demand review cadence: how often to update and who's involved
4. Safety stock calculation by product category
5. Reorder triggers: rules that flag a purchase order
6. Exception management: sudden spikes or supplier delays