Spreadsheet: 539661d1506324400-forecasting-seasonal-forecast-test-22092017
Sheet: CUSHION

Sales | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 |  | Total
 | 2015 | 333 | 333 | 333 | 333 | 323 | 323 | 323 | 323 | 370 | 553 | 662 | 483 | 721 | 328 | 404 | 1023 | 1253 | 1420 | 3101 | 3235 | 2782 | 1970 | 5149 | 3623 | 2957 | 3667 | 3336 | 3281 | 2049 | 3793 | 2387 | 2505 | 2753 | 2579 | 2811 | 2405 | 3274 | 3077 | 2526 | 2241 | 2304 | 2285 | 2065 | 1519 | 1332 | 1610 | 1570 | 1170 | 1004 | 582 | 387 | 295 |  | 88841
 | 2016 | 391 | 260 | 205 | 283 | 248 | 275 | 281 | 1216 | 584 | 603 | 1100 | 964 | 837 | 1059 | 1369 | 1645 | 1414 | 1443 | 2684 | 1414 | 2129 | 5038 | 3654 | 3593 | 3439 | 3472 | 5962 | 3539 | 5656 | 3420 | 2705 | 3267 | 2613 | 2649 | 2116 | 3110 | 3788 | 3920 | 4306 | 3944 | 2772 | 2712 | 2789 | 2454 | 2024 | 1857 | 1458 | 1793 | 1412 | 1784 | 1191 | 655 |  | 110337
 | 2017 | 284 | 231 | 157 | 223 | 144 | 308 | 347 | 182 | 638 | 666 | 525 | 933 | 1335 | 971 | 1171 | 1265 | 1746 | 1476 | 1904 | 228 | 3677 | 5247 | 4533 | 5174 | 5793 | 4059 | 3288 | 3499 | 3189 | 6202 | 3625 | 5836 | 2957 | 3059 | 2792 | 4063 | 3358 | 3995 | 3830 | 3432 | 2883 | 2178 | 2267 | 593 |  |  |  |  |  |  |  |  |  | 104263
 | 2018 | 559.7307534730252 | 461.4014652584913 | 392.4095261019191 | 477.6282790997419 | 410.3725343079355 | 524.222824490085 | 554.6965959861657 | 1011.848124044213 | 943.4299538892816 | 1088.228752415157 | 1376.628391782632 | 1443.710667621225 | 1768.392276127026 | 1452.364586147398 | 1827.033112971183 | 2459.148663046548 | 2779.859307455738 | 2753.485370590225 | 4915.228936708339 | 3140.395059617687 | 5570.041268738037 | 8005.566582764232 | 8773.938380691834 | 8209.348661012791 | 8133.029474169577 | 7524.027594564352 | 8515.34715269768 | 7029.692228213225 | 7472.222135457384 | 9263.960546974648 | 6060.338257912327 | 8124.403139443339 | 5864.066880159742 | 5877.359762990925 | 5510.526631057186 | 6882.32982773111 | 7535.961117683341 | 8000.918792870058 | 7810.452512920014 | 7089.798602669021 | 5904.622849600887 | 5356.458794964579 | 5349.363336699089 | 3451.322314283242 | 3828.554059351505 | 3979.443060383857 | 3496.743739603151 | 3442.414192187773 | 2823.814639941395 | 2781.930102278269 | 1866.445485964458 | 1130.299549190012 |  | 221004.956856303
 | Total | 1008 | 824 | 695 | 839 | 715 | 906 | 951 | 1721 | 1592 | 1822 | 2287 | 2380 | 2893 | 2358 | 2944 | 3933 | 4413 | 4339 | 7689 | 4877 | 8588 | 12255 | 13336 | 12390 | 12189 | 11198 | 12586 | 10319 | 10894 | 13415 | 8717 | 11608 | 8323 | 8287 | 7719 | 9578 | 10420 | 10992 | 10662 | 9617 | 7959 | 7175 | 7121 | 4566 | 3356 | 3467 | 3028 | 2963 | 2416 | 2366 | 1578 | 950 |  | 303441
 | Weekly Average | 336 | 274.6666666666667 | 231.6666666666667 | 279.6666666666667 | 238.3333333333333 | 302 | 317 | 573.6666666666666 | 530.6666666666666 | 607.3333333333334 | 762.3333333333334 | 793.3333333333334 | 964.3333333333334 | 786 | 981.3333333333334 | 1311 | 1471 | 1446.333333333333 | 2563 | 1625.666666666667 | 2862.666666666667 | 4085 | 4445.333333333333 | 4130 | 4063 | 3732.666666666667 | 4195.333333333333 | 3439.666666666667 | 3631.333333333333 | 4471.666666666667 | 2905.666666666667 | 3869.333333333333 | 2774.333333333333 | 2762.333333333333 | 2573 | 3192.666666666667 | 3473.333333333333 | 3664 | 3554 | 3205.666666666667 | 2653 | 2391.666666666667 | 2373.666666666667 | 1522 | 1678 | 1733.5 | 1514 | 1481.5 | 1208 | 1183 | 789 | 475 |  | 101147
 | Seasonal Indices | 0.003321897831868469 | 0.002715519656209939 | 0.002290395826536295 | 0.002764952659660363 | 0.002356306497803527 | 0.002985753408405588 | 0.003134052418756859 | 0.005671613262545272 | 0.005246489432871628 | 0.006004462152444792 | 0.007536885259407925 | 0.007843369880800552 | 0.00953397859880504 | 0.007770868142406596 | 0.00970205081053648 | 0.01296133350470108 | 0.01454318961511463 | 0.01429932013142588 | 0.02533935756868716 | 0.01607231718851441 | 0.02830204224214921 | 0.04038676381899611 | 0.04394923560098998 | 0.04083166085004993 | 0.04016925860381425 | 0.03690338484252292 | 0.04147758542846879 | 0.0340066108403281 | 0.03590154263926101 | 0.04420958275249555 | 0.02872716607182286 | 0.03825455360350118 | 0.0274287258478584 | 0.02731008663957738 | 0.02543822357558801 | 0.03156462046987717 | 0.03433945973022762 | 0.03622450492847044 | 0.03513697885256113 | 0.03169314627884828 | 0.02622915163079478 | 0.02364545331711931 | 0.02346749450469778 | 0.01504740625030896 | 0.01658971595796217 | 0.01713842229626188 | 0.01496831344478828 | 0.01464699892236052 | 0.01194301363362235 | 0.01169584861637023 | 0.007800527944476851 | 0.004696135327790246
 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | 2015 | 100243.9017857143 | 122628.4623786408 | 145389.7165467626 | 120436.0584028605 | 137078.9412587413 | 108180.4006622517 | 103061.4542586751 | 56950.28646135968 | 70523.34798994976 | 92098.17398463226 | 87834.69261040664 | 61580.67352941176 | 75624.25198755616 | 42208.9262086514 | 41640.68070652174 | 78927.06407322655 | 86157.16587355541 | 99305.42060382577 | 122378.7932110808 | 201277.759893377 | 98296.7934326968 | 48778.35740514076 | 117157.8965956809 | 88730.16489104116 | 73613.5070145213 | 99367.57876406502 | 80428.98267916734 | 96481.24052718288 | 57072.75647145217 | 85795.87871785313 | 83092.0806470116 | 65482.40049965541 | 100369.2266009852 | 94433.97357306625 | 110502.9992226972 | 76192.9009187722 | 95342.21055662188 | 84942.49972707423 | 71890.07371975238 | 70709.29406259749 | 87841.1941198643 | 96635.91428571429 | 87994.05490801854 | 100947.6300919842 | 80290.70560190704 | 93940.96913758293 | 104888.2364597094 | 79879.8447519406 | 84065.88410596027 | 49761.24598478445 | 49612.02661596958 | 62817.61052631579
 | 2016 | 117703.8005952381 | 95745.94660194175 | 89504.17985611511 | 102352.5661501788 | 105249.4657342657 | 92104.05629139073 | 89660.27444794953 | 214401.0784427659 | 111312.527638191 | 100425.3144895719 | 145948.8850021863 | 122906.3546218487 | 87791.26062910473 | 136278.2099236641 | 141104.1878396739 | 126915.9534706331 | 97227.63970088375 | 100913.8886840286 | 105922.1802575107 | 87977.3578019274 | 75224.25349324639 | 124743.8399020808 | 83141.37777444512 | 87995.44092009685 | 85612.73270982034 | 94083.51062689767 | 143740.2861910059 | 104068.0006783603 | 157541.9768680007 | 77358.79388743942 | 94161.74199839395 | 85401.5977773949 | 95265.08866995074 | 96997.1291178955 | 83181.90905557714 | 98528.03403633327 | 110310.4134357006 | 108214.03930131 | 122548.9538548115 | 124443.3091400645 | 105683.9366754617 | 114694.3542857143 | 118845.2392922342 | 163084.5847568988 | 122003.294398093 | 108353.0308624171 | 97405.76354029063 | 122414.1552480594 | 118228.1158940397 | 152532.7540152156 | 152681.9733840304 | 139476.3894736842
 | 2017 | 85493.29761904762 | 85066.59101941746 | 68547.1035971223 | 80652.37544696066 | 61112.593006993 | 103156.5430463576 | 110719.2712933754 | 32089.6350958745 | 121605.1243718593 | 110917.5115257958 | 69657.42238740707 | 118953.9718487395 | 140025.4873833391 | 124953.8638676845 | 120696.1314538043 | 97597.98245614035 | 120056.1944255609 | 103221.6907121457 | 75140.0265314085 | 14185.88230469551 | 129919.9530740568 | 129918.8026927785 | 103141.725629874 | 126715.394188862 | 144214.7602756584 | 109989.9106090373 | 79271.7311298268 | 102891.7587944568 | 88826.26666054707 | 140286.3273947074 | 126187.1773545945 | 152557.0017229497 | 107806.684729064 | 112009.8973090382 | 109756.0917217256 | 128720.0650448946 | 97788.37600767754 | 110284.4609716157 | 109001.9724254361 | 108288.396797338 | 109915.869204674 | 92110.73142857144 | 96601.70579974723 | 39408.78515111695 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2015 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Sales (Y) | 100243.9017857143 | 122628.4623786408 | 145389.7165467626 | 120436.0584028605 | 137078.9412587413 | 108180.4006622517 | 103061.4542586751 | 56950.28646135968 | 70523.34798994976 | 92098.17398463226 | 87834.69261040664 | 61580.67352941176 | 75624.25198755616 | 42208.9262086514 | 41640.68070652174 | 78927.06407322655 | 86157.16587355541 | 99305.42060382577 | 122378.7932110808 | 201277.759893377 | 98296.7934326968 | 48778.35740514076 | 117157.8965956809 | 88730.16489104116 | 73613.5070145213 | 99367.57876406502 | 80428.98267916734 | 96481.24052718288 | 57072.75647145217 | 85795.87871785313 | 83092.0806470116 | 65482.40049965541 | 100369.2266009852 | 94433.97357306625 | 110502.9992226972 | 76192.9009187722 | 95342.21055662188 | 84942.49972707423 | 71890.07371975238 | 70709.29406259749 | 87841.1941198643 | 96635.91428571429 | 87994.05490801854 | 100947.6300919842 | 80290.70560190704 | 93940.96913758293 | 104888.2364597094 | 79879.8447519406 | 84065.88410596027 | 49761.24598478445 | 49612.02661596958 | 62817.61052631579
 | sum x^2 | 1 | 4 | 9 | 16 | 25 | 36 | 49 | 64 | 81 | 100 | 121 | 144 | 169 | 196 | 225 | 256 | 289 | 324 | 361 | 400 | 441 | 484 | 529 | 576 | 625 | 676 | 729 | 784 | 841 | 900 | 961 | 1024 | 1089 | 1156 | 1225 | 1296 | 1369 | 1444 | 1521 | 1600 | 1681 | 1764 | 1849 | 1936 | 2025 | 2116 | 2209 | 2304 | 2401 | 2500 | 2601 | 2704
 | sum y^2 | 10048839845.22393 | 15037739785.34972 | 21138169677.54797 | 14504844163.61723 | 18790636136.61744 | 11702999087.4453 | 10621663353.91298 | 3243335128.030928 | 4973542611.711551 | 8482073651.303595 | 7714933225.964622 | 3792179352.335994 | 5719027488.677391 | 1781593451.687379 | 1733946289.702492 | 6229481443.219209 | 7423057231.36334 | 9861566561.302744 | 14976569027.80047 | 40512736627.69595 | 9662259599.150265 | 2379328151.143651 | 13725972734.72425 | 7873042161.591353 | 5418948414.976976 | 9873915709.432667 | 6468821254.8058 | 9308629773.664116 | 3257299531.249686 | 7360932804.968564 | 6904293866.249478 | 4287944775.197271 | 10073981648.47992 | 8917775364.798574 | 12210912837.21143 | 5805358150.417837 | 9090137113.823221 | 7215228259.884006 | 5168182699.431433 | 4999804266.830884 | 7716075384.403683 | 9338499929.835918 | 7742953699.155382 | 10190424021.18808 | 6446597406.052107 | 8824905682.508308 | 11001542147.62791 | 6380789597.594132 | 7067072870.516744 | 2476181601.958227 | 2461353184.943674 | 3946052192.2359
 | sum x*y | 100243.9017857143 | 245256.9247572816 | 436169.1496402877 | 481744.2336114421 | 685394.7062937063 | 649082.40397351 | 721430.1798107256 | 455602.2916908775 | 634710.1319095478 | 920981.7398463226 | 966181.618714473 | 738968.0823529412 | 983115.27583823 | 590924.9669211196 | 624610.210597826 | 1262833.025171625 | 1464671.819850442 | 1787497.570868864 | 2325197.071010535 | 4025555.197867541 | 2064232.662086633 | 1073123.862913097 | 2694631.62170066 | 2129523.957384988 | 1840337.675363032 | 2583557.047865691 | 2171582.532337518 | 2701474.734761121 | 1655109.937672113 | 2573876.361535594 | 2575854.500057359 | 2095436.815988973 | 3312184.477832512 | 3210755.101484253 | 3867604.972794403 | 2742944.433075799 | 3527661.790595009 | 3227814.989628821 | 2803712.875070343 | 2828371.7625039 | 3601488.958914436 | 4058708.4 | 3783744.361044798 | 4441695.724047306 | 3613081.752085817 | 4321284.580328815 | 4929747.113606341 | 3834232.548093149 | 4119228.321192053 | 2488062.299239222 | 2530213.357414449 | 3266515.747368421
2016 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104
 | Sales (Y) | 117703.8005952381 | 95745.94660194175 | 89504.17985611511 | 102352.5661501788 | 105249.4657342657 | 92104.05629139073 | 89660.27444794953 | 214401.0784427659 | 111312.527638191 | 100425.3144895719 | 145948.8850021863 | 122906.3546218487 | 87791.26062910473 | 136278.2099236641 | 141104.1878396739 | 126915.9534706331 | 97227.63970088375 | 100913.8886840286 | 105922.1802575107 | 87977.3578019274 | 75224.25349324639 | 124743.8399020808 | 83141.37777444512 | 87995.44092009685 | 85612.73270982034 | 94083.51062689767 | 143740.2861910059 | 104068.0006783603 | 157541.9768680007 | 77358.79388743942 | 94161.74199839395 | 85401.5977773949 | 95265.08866995074 | 96997.1291178955 | 83181.90905557714 | 98528.03403633327 | 110310.4134357006 | 108214.03930131 | 122548.9538548115 | 124443.3091400645 | 105683.9366754617 | 114694.3542857143 | 118845.2392922342 | 163084.5847568988 | 122003.294398093 | 108353.0308624171 | 97405.76354029063 | 122414.1552480594 | 118228.1158940397 | 152532.7540152156 | 152681.9733840304 | 139476.3894736842
 | sum x^2 | 2809 | 2916 | 3025 | 3136 | 3249 | 3364 | 3481 | 3600 | 3721 | 3844 | 3969 | 4096 | 4225 | 4356 | 4489 | 4624 | 4761 | 4900 | 5041 | 5184 | 5329 | 5476 | 5625 | 5776 | 5929 | 6084 | 6241 | 6400 | 6561 | 6724 | 6889 | 7056 | 7225 | 7396 | 7569 | 7744 | 7921 | 8100 | 8281 | 8464 | 8649 | 8836 | 9025 | 9216 | 9409 | 9604 | 9801 | 10000 | 10201 | 10404 | 10609 | 10816
 | sum y^2 | 13854184674.56357 | 9167286290.70188 | 8010998211.715801 | 10476047797.52672 | 11077450037.34838 | 8483157185.327673 | 8038964814.081632 | 45967822437.42104 | 12390478809.20303 | 10085243790.32942 | 21301077033.38139 | 15105972006.43164 | 7707305442.847394 | 18571750499.99827 | 19910391825.89398 | 16107659245.35991 | 9453213921.804867 | 10183612929.33251 | 11219508270.50459 | 7740015485.808355 | 5658688313.616192 | 15561025593.51596 | 6912488698.232997 | 7743197622.722256 | 7329540002.043141 | 8851706971.881567 | 20661269874.27228 | 10830148765.1912 | 24819474475.47768 | 5984382991.719334 | 8866433656.172106 | 7293432902.931941 | 9075437119.293577 | 9408443057.113691 | 6919229994.130306 | 9707773491.064846 | 12168387312.35519 | 11710278301.90547 | 15018246090.90871 | 15486137189.72965 | 11169094471.22301 | 13154794905.01695 | 14124190902.42842 | 26596581785.33011 | 14884803843.98774 | 11740379297.07191 | 9487882770.867012 | 14985225405.09599 | 13977887387.85449 | 23266241047.46626 | 23311784996.44178 | 19453663220.61485
 | sum x*y | 6238301.431547619 | 5170281.116504855 | 4922729.892086331 | 5731743.704410011 | 5999219.546853147 | 5342035.264900663 | 5289956.192429022 | 12864064.70656595 | 6790064.185929649 | 6226369.498353457 | 9194779.755137734 | 7866006.695798319 | 5706431.940891807 | 8994361.854961833 | 9453980.585258152 | 8630284.83600305 | 6708707.139360979 | 7063972.207882001 | 7520474.798283262 | 6334369.761738773 | 5491370.505006987 | 9231044.152753979 | 6235603.333083384 | 6687653.50992736 | 6592180.418656166 | 7338513.828898018 | 11355482.60908947 | 8325440.054268826 | 12760900.12630806 | 6343421.098770032 | 7815424.585866698 | 7173734.213301172 | 8097532.536945812 | 8341753.104139013 | 7236826.087835211 | 8670466.995197328 | 9817626.79577735 | 9739263.537117904 | 11151954.80078784 | 11448784.44088593 | 9828606.11081794 | 10781269.30285714 | 11290297.73276225 | 15656120.13666229 | 11834319.55661502 | 10618597.02451687 | 9643170.590488773 | 12241415.52480594 | 11941039.70529801 | 15558340.90955199 | 15726243.25855513 | 14505544.50526316
2017 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156
 | Sales (Y) | 85493.29761904762 | 85066.59101941746 | 68547.1035971223 | 80652.37544696066 | 61112.593006993 | 103156.5430463576 | 110719.2712933754 | 32089.6350958745 | 121605.1243718593 | 110917.5115257958 | 69657.42238740707 | 118953.9718487395 | 140025.4873833391 | 124953.8638676845 | 120696.1314538043 | 97597.98245614035 | 120056.1944255609 | 103221.6907121457 | 75140.0265314085 | 14185.88230469551 | 129919.9530740568 | 129918.8026927785 | 103141.725629874 | 126715.394188862 | 144214.7602756584 | 109989.9106090373 | 79271.7311298268 | 102891.7587944568 | 88826.26666054707 | 140286.3273947074 | 126187.1773545945 | 152557.0017229497 | 107806.684729064 | 112009.8973090382 | 109756.0917217256 | 128720.0650448946 | 97788.37600767754 | 110284.4609716157 | 109001.9724254361 | 108288.396797338 | 109915.869204674 | 92110.73142857144 | 96601.70579974723 | 39408.78515111695 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x^2 | 11025 | 11236 | 11449 | 11664 | 11881 | 12100 | 12321 | 12544 | 12769 | 12996 | 13225 | 13456 | 13689 | 13924 | 14161 | 14400 | 14641 | 14884 | 15129 | 15376 | 15625 | 15876 | 16129 | 16384 | 16641 | 16900 | 17161 | 17424 | 17689 | 17956 | 18225 | 18496 | 18769 | 19044 | 19321 | 19600 | 19881 | 20164 | 20449 | 20736 | 21025 | 21316 | 21609 | 21904 | 22201 | 22500 | 22801 | 23104 | 23409 | 23716 | 24025 | 24336
 | sum y^2 | 7309103937.779053 | 7236324907.664836 | 4698705411.554617 | 6504805665.237503 | 3734749024.03837 | 10641272373.27503 | 12258757035.73606 | 1029744680.58638 | 14787806273.49537 | 12302694363.07505 | 4852156493.65764 | 14150047418.59071 | 19607137116.94165 | 15613468095.46383 | 14567556147.91402 | 9525366179.509079 | 14413489819.94807 | 10654717433.47386 | 5646023587.140773 | 201239256.7626731 | 16879194206.76513 | 16878895293.1251 | 10638215565.90821 | 16056791124.43868 | 20797897081.36562 | 12097780435.78403 | 6284007356.319551 | 10586714027.81669 | 7890105648.850616 | 19680253653.89503 | 15923203728.71988 | 23273638774.69607 | 11622281272.27181 | 12546217095.18129 | 12046399670.02784 | 16568855145.16188 | 9562566482.218924 | 12162662331.79983 | 11881429992.63554 | 11726376880.93773 | 12081498303.01899 | 8484386844.306418 | 9331889563.420918 | 1553052347.086896 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 8976796.25 | 9017058.64805825 | 7334540.084892087 | 8710456.548271751 | 6661272.637762237 | 11347219.73509934 | 12289839.11356467 | 3594039.130737944 | 13741379.0540201 | 12644596.31394072 | 8010603.574551813 | 13798660.73445378 | 16382982.02385067 | 14744555.93638677 | 14362839.64300272 | 11711757.89473684 | 14526799.52549286 | 12593046.26688177 | 9242223.263363246 | 1759049.405782243 | 16239994.1342571 | 16369769.13929009 | 13098999.154994 | 16219570.45617433 | 18603704.07555993 | 14298688.37917485 | 10384596.77800731 | 13581712.1608683 | 11813893.46585276 | 18798367.87089079 | 17035268.94287026 | 20747752.23432115 | 14769515.80788177 | 15457365.82864728 | 15256096.74931986 | 18020809.10628524 | 13788161.01708253 | 15660393.45796943 | 15587282.05683737 | 15593529.13881668 | 15937801.03467772 | 13448166.78857143 | 14200450.75256284 | 5832500.202365309 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 14969756.00000001 |  | 1415.488127047547 | -53734.35463236941
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 1639184022191.418
 | sum x*y | 1150490146.504336
2018 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208
 | Sales (Y) | 168497.2813140955 | 169912.769441143 | 171328.2575681906 | 172743.7456952381 | 174159.2338222857 | 175574.7219493332 | 176990.2100763808 | 178405.6982034283 | 179821.1863304758 | 181236.6744575234 | 182652.1625845709 | 184067.6507116185 | 185483.1388386661 | 186898.6269657136 | 188314.1150927611 | 189729.6032198087 | 191145.0913468562 | 192560.5794739038 | 193976.0676009513 | 195391.5557279989 | 196807.0438550464 | 198222.531982094 | 199638.0201091415 | 201053.5082361891 | 202468.9963632366 | 203884.4844902841 | 205299.9726173317 | 206715.4607443793 | 208130.9488714268 | 209546.4369984744 | 210961.9251255219 | 212377.4132525694 | 213792.901379617 | 215208.3895066645 | 216623.8776337121 | 218039.3657607596 | 219454.8538878072 | 220870.3420148547 | 222285.8301419023 | 223701.3182689498 | 225116.8063959974 | 226532.2945230449 | 227947.7826500924 | 229363.27077714 | 230778.7589041875 | 232194.2470312351 | 233609.7351582826 | 235025.2232853302 | 236440.7114123777 | 237856.1995394253 | 239271.6876664728 | 240687.1757935203
 | Seasonal Indices | 0.003321897831868469 | 0.002715519656209939 | 0.002290395826536295 | 0.002764952659660363 | 0.002356306497803527 | 0.002985753408405588 | 0.003134052418756859 | 0.005671613262545272 | 0.005246489432871628 | 0.006004462152444792 | 0.007536885259407925 | 0.007843369880800552 | 0.00953397859880504 | 0.007770868142406596 | 0.00970205081053648 | 0.01296133350470108 | 0.01454318961511463 | 0.01429932013142588 | 0.02533935756868716 | 0.01607231718851441 | 0.02830204224214921 | 0.04038676381899611 | 0.04394923560098998 | 0.04083166085004993 | 0.04016925860381425 | 0.03690338484252292 | 0.04147758542846879 | 0.0340066108403281 | 0.03590154263926101 | 0.04420958275249555 | 0.02872716607182286 | 0.03825455360350118 | 0.0274287258478584 | 0.02731008663957738 | 0.02543822357558801 | 0.03156462046987717 | 0.03433945973022762 | 0.03622450492847044 | 0.03513697885256113 | 0.03169314627884828 | 0.02622915163079478 | 0.02364545331711931 | 0.02346749450469778 | 0.01504740625030896 | 0.01658971595796217 | 0.01713842229626188 | 0.01496831344478828 | 0.01464699892236052 | 0.01194301363362235 | 0.01169584861637023 | 0.007800527944476851 | 0.004696135327790246
 | Forecast Sales | 559.7307534730252 | 461.4014652584913 | 392.4095261019191 | 477.6282790997419 | 410.3725343079355 | 524.222824490085 | 554.6965959861657 | 1011.848124044213 | 943.4299538892816 | 1088.228752415157 | 1376.628391782632 | 1443.710667621225 | 1768.392276127026 | 1452.364586147398 | 1827.033112971183 | 2459.148663046548 | 2779.859307455738 | 2753.485370590225 | 4915.228936708339 | 3140.395059617687 | 5570.041268738037 | 8005.566582764232 | 8773.938380691834 | 8209.348661012791 | 8133.029474169577 | 7524.027594564352 | 8515.34715269768 | 7029.692228213225 | 7472.222135457384 | 9263.960546974648 | 6060.338257912327 | 8124.403139443339 | 5864.066880159742 | 5877.359762990925 | 5510.526631057186 | 6882.32982773111 | 7535.961117683341 | 8000.918792870058 | 7810.452512920014 | 7089.798602669021 | 5904.622849600887 | 5356.458794964579 | 5349.363336699089 | 3451.322314283242 | 3828.554059351505 | 3979.443060383857 | 3496.743739603151 | 3442.414192187773 | 2823.814639941395 | 2781.930102278269 | 1866.445485964458 | 1130.299549190012