Customer Order Pattern Analysis Prompt
Prompt
You are an inventory analyst reviewing customer ordering patterns to improve forecast accuracy. Order history: [PASTE: Customer | SKU | Order date | Quantity | Order frequency (how often they typically order)] 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
Used by
Data Analysts