How To Calculate Seasonal Variation
Now you isolate the seasonal component by comparing the actual data to the trend you just calculated.
| Month | Seasonal Index | | --- | --- | | Jan | 93.53 | | Feb | 81.19 | | Mar | 103.2 | | Apr | 96.36 | | May | 112.87 | | Jun | 121.14 | | Jul | 104.59 | | Aug | 96.36 | | Sep | 88.06 | | Oct | 104.59 | | Nov | 112.87 | | Dec | 128.01 | how to calculate seasonal variation
Her profit margin increased by 18% not because she sold more ice cream, but because she stopped buying for summer in winter. Now you isolate the seasonal component by comparing