0% found this document useful (0 votes)
46 views9 pages

Seasonal Index

This document contains monthly sales data from January 2015 to December 2019. It includes columns for sales dollars, 12 month moving averages, and a centered moving average. The bottom section normalizes the sales data to adjust for seasonality and calculates deseasonalized sales values.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
46 views9 pages

Seasonal Index

This document contains monthly sales data from January 2015 to December 2019. It includes columns for sales dollars, 12 month moving averages, and a centered moving average. The bottom section normalizes the sales data to adjust for seasonality and calculates deseasonalized sales values.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Centered Moving

Month of Year Date Sales Dollars MA12 5 Up MA12 6 Up Average


1 Jan-15 40,504
2 Feb-15 44,155
3 Mar-15 32,519
4 Apr-15 22,735
5 May-15 28,346
6 Jun-15 26,602
7 Jul-15 40,745
8 Aug-15 22,436
9 Sep-15 51,947
10 Oct-15 69,099
11 Nov-15 38,902
12 Dec-15 36,312
1 Jan-16 54,342
2 Feb-16 60,929
3 Mar-16 53,082
4 Apr-16 32,340
5 May-16 63,366
6 Jun-16 34,489
7 Jul-16 40,094
8 Aug-16 31,277
9 Sep-16 47,272
10 Oct-16 68,320
11 Nov-16 48,696
12 Dec-16 57,873
1 Jan-17 57,102
2 Feb-17 60,449
3 Mar-17 49,101
4 Apr-17 49,150
5 May-17 56,241
6 Jun-17 55,848
7 Jul-17 47,111
8 Aug-17 68,015
9 Sep-17 66,832
10 Oct-17 76,579
11 Nov-17 58,981
12 Dec-17 49,390
1 Jan-18 66,647
2 Feb-18 74,192
3 Mar-18 54,757
4 Apr-18 45,885
5 May-18 66,580
6 Jun-18 47,985
7 Jul-18 51,957
8 Aug-18 47,998
9 Sep-18 75,928
10 Oct-18 79,857
11 Nov-18 67,521
12 Dec-18 66,823
1 Jan-19 67,603
2 Feb-19 61,578
3 Mar-19 84,970
4 Apr-19 58,430
5 May-19 61,597
6 Jun-19 59,079
7 Jul-19 56,316
8 Aug-19 72,000
9 Sep-19 77,440
10 Oct-19 82,055
11 Nov-19 72,055
12 Dec-19 69,281
Initial Seasonal Normalized Deseasonalized Sales
Estimate Seasonality Dollars
Centered Moving
Month of Year Date Sales Dollars MA12 5 Up MA12 6 Up Average
1 Jan-15 40,504
2 Feb-15 44,155
3 Mar-15 32,519
4 Apr-15 22,735
5 May-15 28,346
6 Jun-15 26,602 $39,012 $37,859 $38,435
7 Jul-15 40,745 $40,410 $39,012 $39,711
8 Aug-15 22,436 $42,123 $40,410 $41,266
9 Sep-15 51,947 $42,924 $42,123 $42,523
10 Oct-15 69,099 $45,842 $42,924 $44,383
11 Nov-15 38,902 $46,499 $45,842 $46,170
12 Dec-15 36,312 $46,445 $46,499 $46,472
1 Jan-16 54,342 $47,182 $46,445 $46,813
2 Feb-16 60,929 $46,792 $47,182 $46,987
3 Mar-16 53,082 $46,727 $46,792 $46,760
4 Apr-16 32,340 $47,543 $46,727 $47,135
5 May-16 63,366 $49,340 $47,543 $48,442
6 Jun-16 34,489 $49,570 $49,340 $49,455
7 Jul-16 40,094 $49,530 $49,570 $49,550
8 Aug-16 31,277 $49,198 $49,530 $49,364
9 Sep-16 47,272 $50,599 $49,198 $49,899
10 Oct-16 68,320 $50,005 $50,599 $50,302
11 Nov-16 48,696 $51,785 $50,005 $50,895
12 Dec-16 57,873 $52,370 $51,785 $52,078
1 Jan-17 57,102 $55,432 $52,370 $53,901
2 Feb-17 60,449 $57,062 $55,432 $56,247
3 Mar-17 49,101 $57,750 $57,062 $57,406
4 Apr-17 49,150 $58,607 $57,750 $58,178
5 May-17 56,241 $57,900 $58,607 $58,253
6 Jun-17 55,848 $58,695 $57,900 $58,298
7 Jul-17 47,111 $59,841 $58,695 $59,268
8 Aug-17 68,015 $60,312 $59,841 $60,076
9 Sep-17 66,832 $60,040 $60,312 $60,176
10 Oct-17 76,579 $60,901 $60,040 $60,471
11 Nov-17 58,981 $60,246 $60,901 $60,574
12 Dec-17 49,390 $60,650 $60,246 $60,448
1 Jan-18 66,647 $58,982 $60,650 $59,816
2 Feb-18 74,192 $59,740 $58,982 $59,361
3 Mar-18 54,757 $60,013 $59,740 $59,877
4 Apr-18 45,885 $60,725 $60,013 $60,369
5 May-18 66,580 $62,178 $60,725 $61,451
6 Jun-18 47,985 $62,257 $62,178 $62,217
7 Jul-18 51,957 $61,206 $62,257 $61,732
8 Aug-18 47,998 $63,724 $61,206 $62,465
9 Sep-18 75,928 $64,769 $63,724 $64,246
10 Oct-18 79,857 $64,354 $64,769 $64,562
11 Nov-18 67,521 $65,278 $64,354 $64,816
12 Dec-18 66,823 $65,642 $65,278 $65,460
1 Jan-19 67,603 $67,642 $65,642 $66,642
2 Feb-19 61,578 $67,768 $67,642 $67,705
3 Mar-19 84,970 $67,951 $67,768 $67,859
4 Apr-19 58,430 $68,329 $67,951 $68,140
5 May-19 61,597 $68,534 $68,329 $68,431
6 Jun-19 59,079
7 Jul-19 56,316
8 Aug-19 72,000
9 Sep-19 77,440
10 Oct-19 82,055
11 Nov-19 72,055
12 Dec-19 69,281

Candy Com
Average of Initial Normalized 160%
Month of Year Month Seasonal Estimate Seasonality
140%
1 January 1.08721073124482 110%
2 February 1.1326986285553 114% 120%
3 March 1.03929824464424 105% 100%
4 April 0.78712641423541 79%
80%
5 May 1.06428426142296 107%
6 June 0.779684582868424 79% 60%
7 July 0.867938180140368 88% 40%
8 August 0.769457621909542 78%
20%
9 September 1.11535198312679 113%
10 October 1.35459469021036 137% 0%
ry ry ch ril
11 November 0.953699273683684 96% nua rua ar Ap
J a eb M
12 December 0.932635958830847 94% F

11.8839805708727 1200%

12

Actual Sales VS Desasonalized


100,000

90,000

80,000

70,000

60,000
Actual Sales VS Desasonalized
100,000

90,000

80,000

70,000

60,000

50,000

40,000

30,000

20,000

10,000

-
Jan-15 Mar-15May-15 Jul-15 Sep-15 Nov-15 Jan-16 Mar-16May-16 Jul-16 Sep-16 Nov-16 Jan-17 Mar-17May-17 Jul-17 Sep-17 Nov-17

Sales Dollars Deseasonalized Sales Dol

Candy Company
Month Seasonal Index
January 110%
February 114%
March 105%
April 79%
May 107%
June 79%
July 88%
August 78%
September 113%
October 137%
November 96%
December 94%
Initial Seasonal Normalized Deseasonalized
Estimate Seasonality Sales Dollars
110% $36,895
114% $38,605
105% $30,987
79% $28,604
107% $26,376
0.69212806875663 79% $33,789
1.02604889124855 88% $46,491
0.54368830088319 78% $28,876
1.22161286118686 113% $46,124
1.55689157929522 137% $50,518
0.84257339875516 96% $40,396
0.78137443099647 94% $38,558
1.16082622692848 110% $49,500
1.29672611895364 114% $53,271
1.13521215366917 105% $50,581
0.6861119263395 79% $40,689
1.30808989169955 107% $58,963
0.69738145789101 79% $43,807
0.80916246215944 88% $45,748
0.63359777976415 78% $40,255
0.94735998289868 113% $41,973
1.35819086802849 137% $49,948
0.95678791505763 96% $50,566
1.11128339666027 94% $61,453
1.0593915669077 110% $52,014
1.07471576009174 114% $52,851
0.85533429868589 105% $46,788
0.84481683102016 79% $61,839
0.965454791246 107% $52,333
0.95798070676121 79% $70,936
0.79488143888878 88% $53,754
1.13214456628035 78% $87,539
1.11061118762295 113% $59,341
1.26638347131355 137% $55,986
0.97370493702241 96% $61,247
0.81706478148604 94% $52,445
1.11420099012039 110% $60,708
1.24984592836757 114% $64,867
0.9144990104632 105% $52,177
0.76007658466623 79% $57,731
1.08346267053695 107% $61,954
0.77124809806485 79% $60,949
0.84165992826471 88% $59,284
0.76839984071048 78% $61,776
1.18182390079868 113% $67,417
1.23691284220418 137% $58,383
1.04173084389954 96% $70,115
1.0208212261806 94% $70,957
1.01442414102271 110% $61,579
0.90950670680823 114% $53,838
1.25214751575868 105% $80,967
0.85750031491576 79% $73,514
0.90012969220933 107% $57,317
79% $75,040
88% $64,257
78% $92,668
113% $68,760
137% $59,990
96% $74,823
94% $73,567

Candy Company Seasonality Index

ry ry ch ril ay ne Ju
ly st be
r er be
r
be
r
rua ar Ap M Ju ugu m tob m m
eb M A te Oc ve ce
F
S ep No De

S Desasonalized Sales
S Desasonalized Sales

7 May-17 Jul-17 Sep-17 Nov-17 Jan-18 Mar-18 May-18 Jul-18 Sep-18 Nov-18 Jan-19 Mar-19May-19 Jul-19 Sep-19 Nov-19

Deseasonalized Sales Dollars

You might also like