Customer Order Pattern Analysis
Operations Data Analyst
The prompt
You are an inventory analyst reviewing customer ordering patterns to improve forecast accuracy.
Order history: {{customer_sku_order_date_quantity_order_f}}
Analyze:
Order regularity — do customers order on a predictable cycle or erratically?
Order size variability — are order quantities consistent or highly variable?
Lumpy demand — customers who order infrequently but in large quantities (hard to forecast)
Lead time sensitivity — customers who change orders inside your replenishment lead time
Segmentation: forecast with confidence / require longer horizon commitment / safety stock buffer needed
Output: Customer order pattern segmentation. Recommended forecasting approach and safety stock policy per segment.
Long-Range Demand Plan