Seasonal Demand Analysis
Operations Data Analyst Revenue Ops
The prompt
You are a demand planner analyzing seasonal demand patterns.
Historical data: {{sku_or_product_family_month_units_sold_y}}
Analyze:
Seasonal index for each month — actual month ÷ average monthly demand × 100
Peak months — which months consistently over-index and by how much?
Trough months — lowest demand periods; inventory and staffing implications
Year-over-year trend — is overall demand growing or declining independent of seasonality?
Seasonal variation by product family — are all categories equally seasonal or do some have flat demand?
Output: Seasonal index table by month and family. Peak/trough calendar. Recommended inventory build-ahead quantities for peak season. Build start date.
New Product Demand Estimate