Spreadsheet: 539677d1506331666-forecasting-seasonal-forecast-test-25092017
Sheet: BAR

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 | 6 | 6 | 6 | 6 | 3 | 3 | 3 | 3 | 0 | 2 | 0 | 35 | 26 | 0 | 0 | 15 | 24 | 32 | 88 | 44 | 30 | 37 | 77 | 27 | 32 | 17 | 5 | 26 | 7 | 44 | 53 | 33 | 74 | 42 | 55 | 37 | 79 | 65 | 52 | 58 | 42 | 37 | 43 | 0 | 26 | 67 | 29 | 36 | 18 | 22 | 17 | 0 |  | 1453
 | 2016 | 14 | 21 | 16 | 0 | 0 | 7 | 0 | 29 | 6 | 39 | 0 | 15 | 1 | 0 | 32 | 58 | 23 | 44 | 5 | 23 | 48 | 69 | 46 | 44 | 32 | 8 | 34 | 47 | 66 | 12 | 51 | 50 | 21 | 22 | 19 | 29 | 14 | 22 | 42 | 10 | 0 | 16 | 12 | 17 | 26 | 16 | 23 | 28 | 10 | 11 | 24 | 9 |  | 1124
 | 2017 | 0 | 4 | 0 | 4 | 0 | 5 | 0 | 0 | 0 | 25 | 5 | 12 | 34 | 29 | 24 | 6 | 20 | 15 | 57 | 54 | 69 | 91 | 82 | 96 | 79 | 59 | 78 | 61 | 65 | 123 | 96 | 67 | 76 | 43 | 44 | 68 | 39 | 37 | 50 | 45 | 24 | 39 | 32 | 23 |  |  |  |  |  |  |  |  |  | 1780
 | 2018 | 11.1421015037895 | 17.41440158167457 | 12.46090349401481 | 5.710545188153631 | 1.727113000071977 | 8.705312218489325 | 1.755011887323753 | 18.86892086346284 | 3.565821549151058 | 39.53092480043117 | 3.018016103045507 | 37.71168817936597 | 37.38707383127463 | 17.90902726281469 | 34.84333881150931 | 49.52133117219424 | 42.31064122667877 | 57.88982493865841 | 96.12026054172036 | 78.09963772989856 | 95.56490080622297 | 128.985982572426 | 135.1772039980938 | 110.8964852123208 | 95.62418926011067 | 56.56143685403742 | 79.32602963381889 | 91.4751090882104 | 94.84738376629112 | 123.858995746244 | 139.3199022896707 | 105.1873988985474 | 120.7087530310197 | 76.02873819294383 | 84.39345481471209 | 96.45971027719433 | 95.63378862841707 | 90.4143784420194 | 105.6669160009039 | 83.44460618283993 | 49.04444535328666 | 68.7927673697147 | 65.45856387781573 | 30.2818840197547 | 59.41235937279475 | 95.4101678324352 | 60.13773044134092 | 74.46205043152494 | 32.77243927455459 | 38.85482639340935 | 48.56014184068776 | 10.72231582719917 |  | 3219.176951614285
 | Total | 20 | 31 | 22 | 10 | 3 | 15 | 3 | 32 | 6 | 66 | 5 | 62 | 61 | 29 | 56 | 79 | 67 | 91 | 150 | 121 | 147 | 197 | 205 | 167 | 143 | 84 | 117 | 134 | 138 | 179 | 200 | 150 | 171 | 107 | 118 | 134 | 132 | 124 | 144 | 113 | 66 | 92 | 87 | 40 | 52 | 83 | 52 | 64 | 28 | 33 | 41 | 9 |  | 4357
 | Weekly Average | 6.666666666666667 | 10.33333333333333 | 7.333333333333333 | 3.333333333333333 | 1 | 5 | 1 | 10.66666666666667 | 2 | 22 | 1.666666666666667 | 20.66666666666667 | 20.33333333333333 | 9.666666666666666 | 18.66666666666667 | 26.33333333333333 | 22.33333333333333 | 30.33333333333333 | 50 | 40.33333333333334 | 49 | 65.66666666666667 | 68.33333333333333 | 55.66666666666666 | 47.66666666666666 | 28 | 39 | 44.66666666666666 | 46 | 59.66666666666666 | 66.66666666666667 | 50 | 57 | 35.66666666666666 | 39.33333333333334 | 44.66666666666666 | 44 | 41.33333333333334 | 48 | 37.66666666666666 | 22 | 30.66666666666667 | 29 | 13.33333333333333 | 26 | 41.5 | 26 | 32 | 14 | 16.5 | 20.5 | 4.5 |  | 1452.333333333333
 | Seasonal Indices | 0.004590314436538903 | 0.0071149873766353 | 0.005049345880192793 | 0.002295157218269451 | 0.0006885471654808355 | 0.003442735827404177 | 0.0006885471654808355 | 0.007344503098462245 | 0.001377094330961671 | 0.01514803764057838 | 0.001147578609134726 | 0.0142299747532706 | 0.01400045903144365 | 0.006655955932981409 | 0.01285288042230893 | 0.01813174202432867 | 0.01537755336240532 | 0.02088593068625201 | 0.03442735827404177 | 0.02777140234106036 | 0.03373881110856094 | 0.0452145971999082 | 0.04705072297452376 | 0.03832912554509984 | 0.03282074822125316 | 0.01927932063346339 | 0.02685333945375258 | 0.03075510672481065 | 0.03167316961211843 | 0.04108331420702318 | 0.04590314436538903 | 0.03442735827404177 | 0.03924718843240762 | 0.02455818223548313 | 0.02708285517557953 | 0.03075510672481065 | 0.03029607528115676 | 0.0284599495065412 | 0.0330502639430801 | 0.0259352765664448 | 0.01514803764057838 | 0.02111544640807896 | 0.01996786779894423 | 0.009180628873077806 | 0.01790222630250172 | 0.02857470736745467 | 0.01790222630250172 | 0.02203350929538674 | 0.009639660316731696 | 0.01136102823043379 | 0.01411521689235713 | 0.003098462244663759
 | 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 | 1307.1 | 843.2903225806451 | 1188.272727272727 | 2614.2 | 4357 | 871.4 | 4357 | 408.46875 | 0 | 132.030303030303 | 0 | 2459.596774193548 | 1857.081967213115 | 0 | 0 | 827.2784810126582 | 1560.716417910448 | 1532.131868131868 | 2556.106666666667 | 1584.363636363636 | 889.1836734693877 | 818.3197969543147 | 1636.531707317073 | 704.4251497005988 | 974.9930069930069 | 881.7738095238095 | 186.1965811965812 | 845.3880597014926 | 221.0072463768116 | 1070.994413407821 | 1154.605 | 958.54 | 1885.485380116959 | 1710.224299065421 | 2030.805084745763 | 1203.05223880597 | 2607.598484848485 | 2283.91129032258 | 1573.361111111111 | 2236.336283185841 | 2772.636363636364 | 1752.271739130435 | 2153.459770114943 | 0 | 1452.333333333333 | 2344.730923694779 | 1619.910256410256 | 1633.875 | 1867.285714285714 | 1936.444444444444 | 1204.373983739837 | 0
 | 2016 | 3049.9 | 2951.516129032258 | 3168.727272727273 | 0 | 0 | 2033.266666666666 | 0 | 3948.53125 | 4357 | 2574.590909090909 | 0 | 1054.112903225806 | 71.42622950819673 | 0 | 2489.714285714285 | 3198.810126582278 | 1495.686567164179 | 2106.681318681319 | 145.2333333333333 | 828.1900826446281 | 1422.69387755102 | 1526.055837563452 | 977.6682926829268 | 1147.952095808383 | 974.9930069930069 | 414.952380952381 | 1266.136752136752 | 1528.201492537313 | 2083.782608695652 | 292.0893854748604 | 1111.035 | 1452.333333333333 | 535.0701754385965 | 895.8317757009346 | 701.550847457627 | 942.9328358208955 | 462.1060606060606 | 773.016129032258 | 1270.791666666667 | 385.5752212389381 | 0 | 757.7391304347825 | 600.9655172413793 | 1851.725 | 1452.333333333333 | 559.9357429718875 | 1284.75641025641 | 1270.791666666667 | 1037.380952380952 | 968.2222222222222 | 1700.292682926829 | 2904.666666666667
 | 2017 | 0 | 562.1935483870967 | 0 | 1742.8 | 0 | 1452.333333333333 | 0 | 0 | 0 | 1650.378787878788 | 4357 | 843.2903225806451 | 2428.491803278689 | 4357 | 1867.285714285714 | 330.9113924050633 | 1300.597014925373 | 718.1868131868132 | 1655.66 | 1944.446280991735 | 2045.122448979592 | 2012.624365482233 | 1742.8 | 2504.622754491018 | 2407.013986013986 | 3060.27380952381 | 2904.666666666667 | 1983.410447761194 | 2052.210144927536 | 2993.916201117318 | 2091.36 | 1946.126666666667 | 1936.444444444445 | 1750.943925233645 | 1624.64406779661 | 2211.014925373134 | 1287.295454545455 | 1300.072580645161 | 1512.847222222222 | 1735.088495575221 | 1584.363636363636 | 1846.989130434783 | 1602.574712643678 | 2505.275 | 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) | 1307.1 | 843.2903225806451 | 1188.272727272727 | 2614.2 | 4357 | 871.4 | 4357 | 408.46875 | 0 | 132.030303030303 | 0 | 2459.596774193548 | 1857.081967213115 | 0 | 0 | 827.2784810126582 | 1560.716417910448 | 1532.131868131868 | 2556.106666666667 | 1584.363636363636 | 889.1836734693877 | 818.3197969543147 | 1636.531707317073 | 704.4251497005988 | 974.9930069930069 | 881.7738095238095 | 186.1965811965812 | 845.3880597014926 | 221.0072463768116 | 1070.994413407821 | 1154.605 | 958.54 | 1885.485380116959 | 1710.224299065421 | 2030.805084745763 | 1203.05223880597 | 2607.598484848485 | 2283.91129032258 | 1573.361111111111 | 2236.336283185841 | 2772.636363636364 | 1752.271739130435 | 2153.459770114943 | 0 | 1452.333333333333 | 2344.730923694779 | 1619.910256410256 | 1633.875 | 1867.285714285714 | 1936.444444444444 | 1204.373983739837 | 0
 | 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 | 1708510.41 | 711138.5681581685 | 1411992.074380165 | 6834041.639999999 | 18983449 | 759337.96 | 18983449 | 166846.7197265625 | 0 | 17432.00091827365 | 0 | 6049616.291623308 | 3448753.432948133 | 0 | 0 | 684389.6851466111 | 2435835.737135219 | 2347428.061345248 | 6533681.291377777 | 2510208.132231405 | 790647.6051645147 | 669647.2900873509 | 2678236.029054134 | 496214.7915307111 | 950611.3636852656 | 777525.0511621315 | 34669.16684929505 | 714680.9714858544 | 48844.20295106069 | 1147029.033550763 | 1333112.706025 | 918798.9315999999 | 3555055.118634793 | 2924867.153113809 | 4124169.292229244 | 1447334.689296057 | 6799569.858184115 | 5216250.782062954 | 2475465.18595679 | 5001199.971493461 | 7687512.404958677 | 3070456.247755198 | 4637388.981503502 | 0 | 2109272.111111111 | 5497763.104530572 | 2624109.238823142 | 2669547.515624999 | 3486755.93877551 | 3749817.086419753 | 1450516.692709366 | 0
 | sum x*y | 1307.1 | 1686.58064516129 | 3564.818181818182 | 10456.8 | 21785 | 5228.4 | 30499 | 3267.75 | 0 | 1320.30303030303 | 0 | 29515.16129032258 | 24142.06557377049 | 0 | 0 | 13236.45569620253 | 26532.17910447761 | 27578.37362637363 | 48566.02666666666 | 31687.27272727272 | 18672.85714285714 | 18003.03553299492 | 37640.22926829269 | 16906.20359281437 | 24374.82517482517 | 22926.11904761905 | 5027.307692307691 | 23670.86567164179 | 6409.210144927535 | 32129.83240223464 | 35792.755 | 30673.28 | 62221.01754385965 | 58147.6261682243 | 71078.17796610169 | 43309.88059701493 | 96481.14393939395 | 86788.62903225806 | 61361.08333333334 | 89453.45132743364 | 113678.0909090909 | 73595.41304347826 | 92598.77011494254 | 0 | 65355 | 107857.6224899598 | 76135.78205128205 | 78425.99999999999 | 91497 | 96822.22222222222 | 61423.0731707317 | 0
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) | 3049.9 | 2951.516129032258 | 3168.727272727273 | 0 | 0 | 2033.266666666666 | 0 | 3948.53125 | 4357 | 2574.590909090909 | 0 | 1054.112903225806 | 71.42622950819673 | 0 | 2489.714285714285 | 3198.810126582278 | 1495.686567164179 | 2106.681318681319 | 145.2333333333333 | 828.1900826446281 | 1422.69387755102 | 1526.055837563452 | 977.6682926829268 | 1147.952095808383 | 974.9930069930069 | 414.952380952381 | 1266.136752136752 | 1528.201492537313 | 2083.782608695652 | 292.0893854748604 | 1111.035 | 1452.333333333333 | 535.0701754385965 | 895.8317757009346 | 701.550847457627 | 942.9328358208955 | 462.1060606060606 | 773.016129032258 | 1270.791666666667 | 385.5752212389381 | 0 | 757.7391304347825 | 600.9655172413793 | 1851.725 | 1452.333333333333 | 559.9357429718875 | 1284.75641025641 | 1270.791666666667 | 1037.380952380952 | 968.2222222222222 | 1700.292682926829 | 2904.666666666667
 | 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 | 9301890.01 | 8711447.459937565 | 10040832.52892562 | 0 | 0 | 4134173.337777777 | 0 | 15590899.03222656 | 18983449 | 6628518.349173553 | 0 | 1111154.012747138 | 5101.706261757593 | 0 | 6198677.224489794 | 10232386.22592533 | 2237078.307195366 | 4438106.17848086 | 21092.72111111111 | 685898.812990916 | 2024057.869221157 | 2328846.419361488 | 955835.290517549 | 1317794.01427086 | 950611.3636852656 | 172185.4784580499 | 1603102.275111403 | 2335399.801793273 | 4342149.960302457 | 85316.20910708157 | 1234398.771225 | 2109272.111111111 | 286300.0926438904 | 802514.5703554896 | 492173.5915685146 | 889122.332869236 | 213542.0112488522 | 597553.9357440167 | 1614911.460069444 | 148668.251233456 | 0 | 574168.5897920603 | 361159.5529131985 | 3428885.475624999 | 2109272.111111111 | 313528.0362574797 | 1650599.033694937 | 1614911.460069444 | 1076159.240362812 | 937454.2716049382 | 2890995.207614515 | 8437088.444444444
 | sum x*y | 161644.7 | 159381.8709677419 | 174280 | 0 | 0 | 117929.4666666666 | 0 | 236911.875 | 265777 | 159624.6363636364 | 0 | 67463.2258064516 | 4642.704918032788 | 0 | 166810.8571428571 | 217519.0886075949 | 103202.3731343283 | 147467.6923076923 | 10311.56666666667 | 59629.68595041322 | 103856.6530612245 | 112928.1319796954 | 73325.12195121951 | 87244.35928143714 | 75074.46153846153 | 32366.28571428571 | 100024.8034188034 | 122256.1194029851 | 168786.3913043478 | 23951.32960893855 | 92215.90499999998 | 121996 | 45480.9649122807 | 77041.53271028037 | 61034.92372881355 | 82978.0895522388 | 41127.43939393939 | 69571.45161290323 | 115642.0416666667 | 35472.9203539823 | 0 | 71227.47826086955 | 57091.72413793104 | 177765.6 | 140876.3333333333 | 54873.70281124498 | 127190.8846153846 | 127079.1666666667 | 104775.4761904762 | 98758.66666666666 | 175130.1463414634 | 302085.3333333333
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) | 0 | 562.1935483870967 | 0 | 1742.8 | 0 | 1452.333333333333 | 0 | 0 | 0 | 1650.378787878788 | 4357 | 843.2903225806451 | 2428.491803278689 | 4357 | 1867.285714285714 | 330.9113924050633 | 1300.597014925373 | 718.1868131868132 | 1655.66 | 1944.446280991735 | 2045.122448979592 | 2012.624365482233 | 1742.8 | 2504.622754491018 | 2407.013986013986 | 3060.27380952381 | 2904.666666666667 | 1983.410447761194 | 2052.210144927536 | 2993.916201117318 | 2091.36 | 1946.126666666667 | 1936.444444444445 | 1750.943925233645 | 1624.64406779661 | 2211.014925373134 | 1287.295454545455 | 1300.072580645161 | 1512.847222222222 | 1735.088495575221 | 1584.363636363636 | 1846.989130434783 | 1602.574712643678 | 2505.275 | 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 | 0 | 316061.5858480749 | 0 | 3037351.84 | 0 | 2109272.111111111 | 0 | 0 | 0 | 2723750.143480257 | 18983449 | 711138.5681581685 | 5897572.438591776 | 18983449 | 3486755.938775509 | 109502.3496234578 | 1691552.595232791 | 515792.2986354305 | 2741210.0356 | 3780871.339662591 | 4182525.831320283 | 4050656.836532762 | 3037351.84 | 6273135.142314174 | 5793716.328866935 | 9365275.78925737 | 8437088.444444444 | 3933917.00428826 | 4211566.478943499 | 8963534.219312755 | 4373786.649599998 | 3787409.002711111 | 3749817.086419754 | 3065804.629312604 | 2639468.347026716 | 4888587.000222767 | 1657129.587293388 | 1690188.714945369 | 2288706.717785493 | 3010532.087477485 | 2510208.132231405 | 3411368.847944234 | 2568245.709604967 | 6276402.825625001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 0 | 59592.51612903225 | 0 | 188222.4 | 0 | 159756.6666666667 | 0 | 0 | 0 | 188143.1818181818 | 501055 | 97821.67741935483 | 284133.5409836066 | 514126 | 222207 | 39709.36708860759 | 157372.2388059701 | 87618.79120879121 | 203646.18 | 241111.3388429752 | 255640.306122449 | 253590.6700507614 | 221335.6 | 320591.7125748503 | 310504.8041958042 | 397835.5952380953 | 380511.3333333333 | 261810.1791044776 | 272943.9492753623 | 401184.7709497207 | 282333.6 | 264673.2266666666 | 265292.8888888889 | 241630.261682243 | 225825.5254237288 | 309542.0895522388 | 181508.6590909091 | 184610.3064516129 | 216337.1527777778 | 249852.7433628319 | 229732.7272727273 | 269660.4130434783 | 235578.4827586207 | 370780.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 214945.3333333333 |  | 20.25924195933109 | -753.3941750144375
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 468146013.1601506
 | sum x*y | 16658479.56998393
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) | 2427.306812600544 | 2447.566054559875 | 2467.825296519206 | 2488.084538478537 | 2508.343780437868 | 2528.603022397199 | 2548.86226435653 | 2569.121506315862 | 2589.380748275193 | 2609.639990234524 | 2629.899232193855 | 2650.158474153186 | 2670.417716112517 | 2690.676958071848 | 2710.936200031179 | 2731.195441990511 | 2751.454683949842 | 2771.713925909173 | 2791.973167868504 | 2812.232409827835 | 2832.491651787166 | 2852.750893746497 | 2873.010135705828 | 2893.269377665159 | 2913.528619624491 | 2933.787861583822 | 2954.047103543153 | 2974.306345502483 | 2994.565587461814 | 3014.824829421145 | 3035.084071380476 | 3055.343313339808 | 3075.602555299139 | 3095.86179725847 | 3116.121039217801 | 3136.380281177132 | 3156.639523136463 | 3176.898765095794 | 3197.158007055125 | 3217.417249014457 | 3237.676490973788 | 3257.935732933119 | 3278.19497489245 | 3298.454216851781 | 3318.713458811112 | 3338.972700770443 | 3359.231942729774 | 3379.491184689105 | 3399.750426648437 | 3420.009668607768 | 3440.268910567099 | 3460.52815252643
 | Seasonal Indices | 0.004590314436538903 | 0.0071149873766353 | 0.005049345880192793 | 0.002295157218269451 | 0.0006885471654808355 | 0.003442735827404177 | 0.0006885471654808355 | 0.007344503098462245 | 0.001377094330961671 | 0.01514803764057838 | 0.001147578609134726 | 0.0142299747532706 | 0.01400045903144365 | 0.006655955932981409 | 0.01285288042230893 | 0.01813174202432867 | 0.01537755336240532 | 0.02088593068625201 | 0.03442735827404177 | 0.02777140234106036 | 0.03373881110856094 | 0.0452145971999082 | 0.04705072297452376 | 0.03832912554509984 | 0.03282074822125316 | 0.01927932063346339 | 0.02685333945375258 | 0.03075510672481065 | 0.03167316961211843 | 0.04108331420702318 | 0.04590314436538903 | 0.03442735827404177 | 0.03924718843240762 | 0.02455818223548313 | 0.02708285517557953 | 0.03075510672481065 | 0.03029607528115676 | 0.0284599495065412 | 0.0330502639430801 | 0.0259352765664448 | 0.01514803764057838 | 0.02111544640807896 | 0.01996786779894423 | 0.009180628873077806 | 0.01790222630250172 | 0.02857470736745467 | 0.01790222630250172 | 0.02203350929538674 | 0.009639660316731696 | 0.01136102823043379 | 0.01411521689235713 | 0.003098462244663759
 | Forecast Sales | 11.1421015037895 | 17.41440158167457 | 12.46090349401481 | 5.710545188153631 | 1.727113000071977 | 8.705312218489325 | 1.755011887323753 | 18.86892086346284 | 3.565821549151058 | 39.53092480043117 | 3.018016103045507 | 37.71168817936597 | 37.38707383127463 | 17.90902726281469 | 34.84333881150931 | 49.52133117219424 | 42.31064122667877 | 57.88982493865841 | 96.12026054172036 | 78.09963772989856 | 95.56490080622297 | 128.985982572426 | 135.1772039980938 | 110.8964852123208 | 95.62418926011067 | 56.56143685403742 | 79.32602963381889 | 91.4751090882104 | 94.84738376629112 | 123.858995746244 | 139.3199022896707 | 105.1873988985474 | 120.7087530310197 | 76.02873819294383 | 84.39345481471209 | 96.45971027719433 | 95.63378862841707 | 90.4143784420194 | 105.6669160009039 | 83.44460618283993 | 49.04444535328666 | 68.7927673697147 | 65.45856387781573 | 30.2818840197547 | 59.41235937279475 | 95.4101678324352 | 60.13773044134092 | 74.46205043152494 | 32.77243927455459 | 38.85482639340935 | 48.56014184068776 | 10.72231582719917