Seasonal index and trend
Seasonal index and trend: the index shows how many times a period is usually above or below the average, the trend the overall rise or fall. Together they separate season from business growth and support a forecast.
Formula
Index = average sales of the same periods ÷ overall average
How to read
Suppose December is on average 1.4 times the monthly average and average sales are RUB 5 million: we expect RUB 7 million plus trend. Reliable indices need at least two years of history; a common error is an index from a single year with a promotion.
Where it is discussed
Topics
- Stock and turnover
- Replenishment and stock cover
- Forecast and budget
- Order size and break-even
- Promotions: planning and evaluation
- Range: width, depth and price tiers
Calculations
- Average stock for the year and turnover
- Reorder from early sales
- Sales forecast: method, horizon, error
- Sales plan by store
- Annual budget by month
- Post-promotion dip and pull-forward demand
- Forecast of a new item from analogs
Documents
- Sales plan
- Kids: height sizing, back-to-school, TR CU 007/2011 and 10% VAT
- Niches: sport and outdoor, underwear, outerwear, knitwear, bridal, school uniform, workwear
- Demand forecasting: smoothing, seasonal indices, analogs and error control
- Holt-Winters, seasonal decomposition and Croston: forecasting with trend, season and intermittent demand
- Sports and technical clothing: fabrics, finishing, tests, the season and the price of a functional fabric