Spreadsheet: 539661d1506324400-forecasting-seasonal-forecast-test-22092017
Sheet: PROTECTION COVER

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 | 24.75 | 24.75 | 24.75 | 24.75 | 15.5 | 15.5 | 15.5 | 15.5 | 10 | 16 | 31 | 19 | 26 | 19 | 15 | 16 | 44 | 44 | 153 | 160 | 93 | 84 | 201 | 217 | 147 | 182 | 156 | 164 | 97 | 176 | 162 | 199 | 158 | 177 | 333 | 166 | 195 | 139 | 156 | 149 | 73 | 74 | 54 | 67 | 43 | 53 | 57 | 48 | 23 | 21 | 39 | 34 |  | 4490
 | 2016 | 35 | 25 | 19 | 27 | 17 | 17 | 16 | 44 | 37 | 26 | 46 | 51 | 42 | 50 | 52 | 82 | 68 | 123 | 190 | 68 | 158 | 305 | 249 | 250 | 231 | 262 | 506 | 359 | 373 | 243 | 244 | 330 | 204 | 169 | 142 | 203 | 244 | 410 | 294 | 191 | 160 | 188 | 200 | 164 | 107 | 137 | 98 | 98 | 98 | 128 | 122 | 83 |  | 7785
 | 2017 | 52 | 46 | 33 | 28 | 26 | 27 | 23 | 21 | 26 | 39 | 51 | 64 | 88 | 64 | 64 | 67 | 96 | 80 | 106 | 149 | 222 | 379 | 259 | 330 | 319 | 224 | 201 | 195 | 300 | 779 | 471 | 477 | 331 | 419 | 229 | 319 | 261 | 296 | 274 | 232 | 196 | 144 | 176 | 31 |  |  |  |  |  |  |  |  |  | 8214
 | 2018 | 64.50193875933431 | 55.69612286912702 | 44.98831215444753 | 47.10442696733023 | 34.81541564005236 | 35.6773601503571 | 32.92365091775401 | 48.99132392166226 | 44.75426060208221 | 50.02205635377609 | 79.62117625857925 | 83.95430011972138 | 98.43737529570032 | 84.52056956352673 | 83.83701221435696 | 106.3361278179703 | 134.9806783424186 | 161.3971500266463 | 295.403361498907 | 249.7240963939023 | 315.4353382633319 | 515.6094797942453 | 479.1781451568943 | 542.2269046414682 | 477.3188951813577 | 460.4545797538819 | 598.7385705095078 | 501.3590372202652 | 541.1219874225599 | 847.2735392404436 | 624.1821271706041 | 720.5056428936294 | 499.4399584787127 | 554.7602282974905 | 513.6813139077252 | 505.0918601000479 | 517.0405336132541 | 627.9309260664957 | 541.2607421928715 | 430.1908459134644 | 324.566851189614 | 308.9864116207847 | 329.1798191618123 | 201.744886668364 | 174.2631389201101 | 222.0113029469109 | 182.1570577485654 | 172.56223355524 | 143.8277860570435 | 178.1124650176852 | 193.5400245325107 | 141.4340736092534 |  | 15222.8734227138
 | Total | 111.75 | 95.75 | 76.75 | 79.75 | 58.5 | 59.5 | 54.5 | 80.5 | 73 | 81 | 128 | 134 | 156 | 133 | 131 | 165 | 208 | 247 | 449 | 377 | 473 | 768 | 709 | 797 | 697 | 668 | 863 | 718 | 770 | 1198 | 877 | 1006 | 693 | 765 | 704 | 688 | 700 | 845 | 724 | 572 | 429 | 406 | 430 | 262 | 150 | 190 | 155 | 146 | 121 | 149 | 161 | 117 |  | 20489
 | Weekly Average | 37.25 | 31.91666666666667 | 25.58333333333333 | 26.58333333333333 | 19.5 | 19.83333333333333 | 18.16666666666667 | 26.83333333333333 | 24.33333333333333 | 27 | 42.66666666666666 | 44.66666666666666 | 52 | 44.33333333333334 | 43.66666666666666 | 55 | 69.33333333333333 | 82.33333333333333 | 149.6666666666667 | 125.6666666666667 | 157.6666666666667 | 256 | 236.3333333333333 | 265.6666666666667 | 232.3333333333333 | 222.6666666666667 | 287.6666666666667 | 239.3333333333333 | 256.6666666666667 | 399.3333333333333 | 292.3333333333333 | 335.3333333333333 | 231 | 255 | 234.6666666666667 | 229.3333333333333 | 233.3333333333333 | 281.6666666666667 | 241.3333333333333 | 190.6666666666667 | 143 | 135.3333333333333 | 143.3333333333333 | 87.33333333333333 | 75 | 95 | 77.5 | 73 | 60.5 | 74.5 | 80.5 | 58.5 |  | 6829.666666666667
 | Seasonal Indices | 0.005454146127190199 | 0.004673239299136122 | 0.003745912440821904 | 0.003892332471082044 | 0.002855190590072722 | 0.002903997266826101 | 0.002659963883059203 | 0.003928937478647079 | 0.00356288740299673 | 0.003953340817023769 | 0.006247254624432622 | 0.006540094684952901 | 0.007613841573527258 | 0.006491288008199521 | 0.006393674654692761 | 0.008053101664307677 | 0.01015178876470301 | 0.01205524915808483 | 0.02191419786226756 | 0.01840011713602421 | 0.02308555810434867 | 0.03748352774659573 | 0.03460393381814632 | 0.03889892137244375 | 0.03401825369710577 | 0.03260286007125775 | 0.04212016203816682 | 0.03504319390892674 | 0.03758114110010249 | 0.05847039875054907 | 0.04280345551271413 | 0.04909951681390014 | 0.03382302699009224 | 0.0373371077163356 | 0.03435990043437942 | 0.03357899360632535 | 0.0341646737273659 | 0.04124164185660598 | 0.03533603396944702 | 0.02791741910293328 | 0.02093806432719996 | 0.01981551076187222 | 0.02098687100395334 | 0.01278734930938552 | 0.01098150226951047 | 0.01390990287471326 | 0.01134755234516082 | 0.01068866220899019 | 0.008858411830738445 | 0.0109082922543804 | 0.01178681243594124 | 0.008565571770218166
 | 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 | 4537.832214765101 | 5296.11227154047 | 6607.201954397395 | 6358.655172413793 | 5428.709401709402 | 5337.470588235295 | 5827.146788990825 | 3945.086956521739 | 2806.712328767123 | 4047.20987654321 | 4962.179687500001 | 2905.156716417911 | 3414.833333333333 | 2927 | 2346.068702290077 | 1986.812121212121 | 4334.211538461539 | 3649.862348178138 | 6981.775055679288 | 8695.596816976129 | 4028.492600422834 | 2240.984375 | 5808.588152327221 | 5578.560853199498 | 4321.209469153515 | 5582.332335329342 | 3703.689455388181 | 4679.938718662953 | 2581.081818181818 | 3010.070116861436 | 3784.741163055873 | 4052.993041749503 | 4671.373737373738 | 4740.592156862745 | 9691.529829545456 | 4943.566860465116 | 5707.65 | 3370.379881656805 | 4414.756906077349 | 5337.169580419581 | 3486.473193473194 | 3734.448275862069 | 2573.037209302326 | 5239.553435114504 | 3915.675555555556 | 3810.235087719298 | 5023.109677419356 | 4490.739726027397 | 2596.402203856749 | 1925.140939597316 | 3308.782608695652 | 3969.378917378917
 | 2016 | 6417.136465324385 | 5349.608355091384 | 5072.195439739414 | 6936.714733542321 | 5954.068376068377 | 5854.000000000001 | 6015.119266055046 | 11198.95652173913 | 10384.83561643836 | 6576.716049382717 | 7363.234375000001 | 7798.052238805972 | 5516.26923076923 | 7702.631578947369 | 8133.038167938932 | 10182.41212121212 | 6698.326923076925 | 10203.02429149798 | 8670.178173719378 | 3695.628647214854 | 6844.105708245244 | 8136.907552083334 | 7195.713681241185 | 6426.913425345044 | 6790.472022955523 | 8036.104790419162 | 12013.24913093859 | 10244.5 | 9925.190909090908 | 4155.949081803005 | 5700.474344355759 | 6721.043737574553 | 6031.39393939394 | 4526.328104575163 | 4132.724431818182 | 6045.446220930233 | 7141.88 | 9941.40828402367 | 8320.118784530387 | 6841.606643356644 | 7641.585081585082 | 9487.517241379312 | 9529.767441860464 | 12825.17557251909 | 9743.657777777778 | 9849.098245614035 | 8636.22365591398 | 9168.593607305937 | 11062.93112947658 | 11734.19239373602 | 10350.55072463768 | 9689.954415954415
 | 2017 | 9534.031319910515 | 9843.279373368145 | 8809.602605863192 | 7193.630094043888 | 9106.222222222223 | 9297.529411764708 | 8646.733944954129 | 5344.95652173913 | 7297.452054794521 | 9865.074074074075 | 8163.585937500001 | 9785.79104477612 | 11557.89743589744 | 9859.368421052632 | 10009.89312977099 | 8319.775757575759 | 9456.46153846154 | 6636.113360323887 | 4837.046770601337 | 8097.77453580902 | 9616.401691331925 | 10111.10807291667 | 7484.698166431594 | 8483.525721455457 | 9377.318507890961 | 6870.562874251497 | 4772.061413673233 | 5564.561281337047 | 7982.727272727273 | 13322.98080133556 | 11003.78449258837 | 9714.963220675945 | 9786.232323232323 | 11222.07973856209 | 6664.745738636364 | 9499.98691860465 | 7639.47 | 7177.211834319527 | 7754.124309392266 | 8310.223776223776 | 9360.941724941726 | 7267.034482758621 | 8386.19534883721 | 2424.270992366412 | 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) | 4537.832214765101 | 5296.11227154047 | 6607.201954397395 | 6358.655172413793 | 5428.709401709402 | 5337.470588235295 | 5827.146788990825 | 3945.086956521739 | 2806.712328767123 | 4047.20987654321 | 4962.179687500001 | 2905.156716417911 | 3414.833333333333 | 2927 | 2346.068702290077 | 1986.812121212121 | 4334.211538461539 | 3649.862348178138 | 6981.775055679288 | 8695.596816976129 | 4028.492600422834 | 2240.984375 | 5808.588152327221 | 5578.560853199498 | 4321.209469153515 | 5582.332335329342 | 3703.689455388181 | 4679.938718662953 | 2581.081818181818 | 3010.070116861436 | 3784.741163055873 | 4052.993041749503 | 4671.373737373738 | 4740.592156862745 | 9691.529829545456 | 4943.566860465116 | 5707.65 | 3370.379881656805 | 4414.756906077349 | 5337.169580419581 | 3486.473193473194 | 3734.448275862069 | 2573.037209302326 | 5239.553435114504 | 3915.675555555556 | 3810.235087719298 | 5023.109677419356 | 4490.739726027397 | 2596.402203856749 | 1925.140939597316 | 3308.782608695652 | 3969.378917378917
 | 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 | 20591921.20935994 | 28048805.19276156 | 43655117.66619276 | 40432495.60166469 | 29470885.76820806 | 28488592.28027682 | 33955639.70044608 | 15563711.09451796 | 7877634.096453369 | 16379907.78478891 | 24623227.25103761 | 8439935.546948098 | 11661086.69444445 | 8567329 | 5504038.355865044 | 3947422.404995409 | 18785389.66013314 | 13321495.16064843 | 48745182.92810553 | 75613404.00340539 | 16228752.63166152 | 5022010.968994141 | 33739696.32335616 | 31120341.19284991 | 18672851.276302 | 31162434.30206354 | 13717315.5819536 | 21901826.41044064 | 6661983.35214876 | 9060522.108422218 | 14324265.67132952 | 16426752.59646989 | 21821732.59422508 | 22473213.99770857 | 93925750.43696937 | 24438853.30388893 | 32577268.5225 | 11359460.54667694 | 19490078.53975764 | 28485379.13015612 | 12155495.32880717 | 13946103.92508918 | 6620520.4804543 | 27452920.1994202 | 15332515.05637531 | 14517891.42368729 | 25231630.83138398 | 20166743.28692063 | 6741304.404192184 | 3706167.637313635 | 10948042.3516068 | 15755968.98973223
 | sum x*y | 4537.832214765101 | 10592.22454308094 | 19821.60586319218 | 25434.62068965517 | 27143.54700854701 | 32024.82352941177 | 40790.02752293578 | 31560.69565217391 | 25260.41095890411 | 40472.0987654321 | 54583.97656250001 | 34861.88059701493 | 44392.83333333334 | 40978 | 35191.03053435115 | 31788.99393939394 | 73681.59615384616 | 65697.52226720648 | 132653.7260579065 | 173911.9363395226 | 84598.3446088795 | 49301.65625 | 133597.5275035261 | 133885.4604767879 | 108030.2367288379 | 145140.6407185629 | 99999.61529548088 | 131038.2841225627 | 74851.37272727273 | 90302.10350584309 | 117326.9760547321 | 129695.7773359841 | 154155.3333333333 | 161180.1333333333 | 339203.5440340909 | 177968.4069767442 | 211183.05 | 128074.4355029586 | 172175.5193370166 | 213486.7832167832 | 142945.4009324009 | 156846.8275862069 | 110640.6 | 230540.3511450382 | 176205.4 | 175270.8140350877 | 236086.1548387097 | 215555.5068493151 | 127223.7079889807 | 96257.04697986577 | 168747.9130434782 | 206407.7037037037
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) | 6417.136465324385 | 5349.608355091384 | 5072.195439739414 | 6936.714733542321 | 5954.068376068377 | 5854.000000000001 | 6015.119266055046 | 11198.95652173913 | 10384.83561643836 | 6576.716049382717 | 7363.234375000001 | 7798.052238805972 | 5516.26923076923 | 7702.631578947369 | 8133.038167938932 | 10182.41212121212 | 6698.326923076925 | 10203.02429149798 | 8670.178173719378 | 3695.628647214854 | 6844.105708245244 | 8136.907552083334 | 7195.713681241185 | 6426.913425345044 | 6790.472022955523 | 8036.104790419162 | 12013.24913093859 | 10244.5 | 9925.190909090908 | 4155.949081803005 | 5700.474344355759 | 6721.043737574553 | 6031.39393939394 | 4526.328104575163 | 4132.724431818182 | 6045.446220930233 | 7141.88 | 9941.40828402367 | 8320.118784530387 | 6841.606643356644 | 7641.585081585082 | 9487.517241379312 | 9529.767441860464 | 12825.17557251909 | 9743.657777777778 | 9849.098245614035 | 8636.22365591398 | 9168.593607305937 | 11062.93112947658 | 11734.19239373602 | 10350.55072463768 | 9689.954415954415
 | 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 | 41179640.41459595 | 28618309.55286354 | 25727166.5789133 | 48118011.29454311 | 35450930.22689752 | 34269316.00000001 | 36181659.78486659 | 125416627.1758034 | 107844810.7804466 | 43253193.99420821 | 54217220.46118166 | 60809618.71914683 | 30429226.22633136 | 59330533.24099724 | 66146309.84115146 | 103681516.6062076 | 44867583.56841718 | 104101704.6928978 | 75171989.56403989 | 13657671.0981151 | 46841782.94563514 | 66209264.51115079 | 51778295.38240156 | 41305216.17688037 | 46110510.29454168 | 64578980.2025978 | 144318154.6819967 | 104949780.25 | 98509414.58190082 | 17271912.77053924 | 32495407.75065822 | 45172428.92239012 | 36377712.85215795 | 20487646.11026699 | 17079411.22934692 | 36547420.01015963 | 51006449.9344 | 98831598.66965444 | 69224376.58869539 | 46807581.46242176 | 58393822.55910368 | 90012983.4054697 | 90816467.49594373 | 164485128.4659402 | 94938866.89044939 | 97004736.25175747 | 74584359.03496823 | 84063108.73593129 | 122388445.175542 | 137691271.1332122 | 107133900.3032976 | 93895216.58327447
 | sum x*y | 340108.2326621924 | 288878.8511749347 | 278970.7491856678 | 388456.0250783699 | 339381.8974358975 | 339532.0000000001 | 354892.0366972477 | 671937.3913043478 | 633474.9726027398 | 407756.3950617284 | 463883.7656250001 | 499075.3432835822 | 358557.5 | 508373.6842105263 | 544913.5572519085 | 692404.0242424243 | 462184.5576923078 | 714211.7004048584 | 615582.6503340758 | 266085.2625994695 | 499619.7167019029 | 602131.1588541667 | 539678.5260930888 | 488445.4203262233 | 522866.3457675753 | 626816.1736526947 | 949046.6813441482 | 819560 | 803940.4636363636 | 340787.8247078464 | 473139.370581528 | 564567.6739562624 | 512668.4848484849 | 389264.216993464 | 359547.0255681818 | 531999.2674418605 | 635627.3200000001 | 894726.7455621302 | 757130.8093922652 | 629427.8111888112 | 710667.4125874126 | 891826.6206896553 | 905327.9069767441 | 1231216.854961832 | 945134.8044444445 | 965211.6280701755 | 854986.141935484 | 916859.3607305937 | 1117356.044077135 | 1196887.624161074 | 1066106.724637681 | 1007755.259259259
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) | 9534.031319910515 | 9843.279373368145 | 8809.602605863192 | 7193.630094043888 | 9106.222222222223 | 9297.529411764708 | 8646.733944954129 | 5344.95652173913 | 7297.452054794521 | 9865.074074074075 | 8163.585937500001 | 9785.79104477612 | 11557.89743589744 | 9859.368421052632 | 10009.89312977099 | 8319.775757575759 | 9456.46153846154 | 6636.113360323887 | 4837.046770601337 | 8097.77453580902 | 9616.401691331925 | 10111.10807291667 | 7484.698166431594 | 8483.525721455457 | 9377.318507890961 | 6870.562874251497 | 4772.061413673233 | 5564.561281337047 | 7982.727272727273 | 13322.98080133556 | 11003.78449258837 | 9714.963220675945 | 9786.232323232323 | 11222.07973856209 | 6664.745738636364 | 9499.98691860465 | 7639.47 | 7177.211834319527 | 7754.124309392266 | 8310.223776223776 | 9360.941724941726 | 7267.034482758621 | 8386.19534883721 | 2424.270992366412 | 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 | 90897753.20903464 | 96890148.82217477 | 77609098.07323155 | 51748313.92993388 | 82923283.16049384 | 86444053.1626298 | 74766007.91482198 | 28568560.21928166 | 53252806.49202478 | 97319686.48696846 | 66644135.35894777 | 95761706.37202051 | 133584993.1387245 | 97207145.66204986 | 100197960.4694365 | 69218668.6563453 | 89424664.82840241 | 44038000.53106919 | 23397021.46098482 | 65573952.43279698 | 92475181.4890515 | 102234506.4622006 | 56020706.64258446 | 71970208.66659632 | 87934102.39843436 | 47204634.209043 | 22772570.13586897 | 30964342.2537554 | 63723934.71074381 | 177501817.4327559 | 121083273.1593283 | 94380510.37908633 | 95770343.08427712 | 125935073.6586458 | 44418835.76067157 | 90249751.45365949 | 58361501.8809 | 51512369.71469627 | 60126443.80550808 | 69059819.21091497 | 87627229.97775497 | 52809790.17360286 | 70328272.42885885 | 5877089.84442923 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 1001073.288590604 | 1043387.613577023 | 942627.4788273616 | 776912.0501567399 | 992578.2222222222 | 1022728.235294118 | 959787.4678899082 | 598635.1304347826 | 824612.0821917809 | 1124618.444444444 | 938812.3828125001 | 1135151.76119403 | 1352274 | 1163405.473684211 | 1191177.282442748 | 998373.090909091 | 1144231.846153846 | 809605.8299595142 | 594956.7527839644 | 1004124.042440318 | 1202050.211416491 | 1273999.6171875 | 950556.6671368123 | 1085891.292346298 | 1209674.087517934 | 893173.1736526947 | 625140.0451911935 | 734522.0891364902 | 1061702.727272727 | 1785279.427378965 | 1485510.90649943 | 1321234.998011929 | 1340713.828282828 | 1548647.003921569 | 926399.6576704546 | 1329998.168604651 | 1077165.27 | 1019164.080473373 | 1108839.776243094 | 1196672.223776224 | 1357336.55011655 | 1060987.034482759 | 1232770.71627907 | 358792.1068702291 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 1010790.666666667 |  | 91.87653282813775 | -2598.39441697064
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 7924453975.302161
 | sum x*y | 85567584.16217296
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) | 11826.22123704699 | 11918.09776987513 | 12009.97430270326 | 12101.8508355314 | 12193.72736835954 | 12285.60390118767 | 12377.48043401582 | 12469.35696684395 | 12561.23349967209 | 12653.11003250023 | 12744.98656532836 | 12836.8630981565 | 12928.73963098464 | 13020.61616381278 | 13112.49269664091 | 13204.36922946906 | 13296.24576229719 | 13388.12229512533 | 13479.99882795347 | 13571.8753607816 | 13663.75189360974 | 13755.62842643788 | 13847.50495926602 | 13939.38149209415 | 14031.25802492229 | 14123.13455775043 | 14215.01109057857 | 14306.88762340671 | 14398.76415623484 | 14490.64068906298 | 14582.51722189112 | 14674.39375471926 | 14766.2702875474 | 14858.14682037553 | 14950.02335320367 | 15041.89988603181 | 15133.77641885995 | 15225.65295168808 | 15317.52948451622 | 15409.40601734436 | 15501.2825501725 | 15593.15908300064 | 15685.03561582877 | 15776.91214865691 | 15868.78868148505 | 15960.66521431319 | 16052.54174714132 | 16144.41827996946 | 16236.2948127976 | 16328.17134562573 | 16420.04787845388 | 16511.92441128201
 | Seasonal Indices | 0.005454146127190199 | 0.004673239299136122 | 0.003745912440821904 | 0.003892332471082044 | 0.002855190590072722 | 0.002903997266826101 | 0.002659963883059203 | 0.003928937478647079 | 0.00356288740299673 | 0.003953340817023769 | 0.006247254624432622 | 0.006540094684952901 | 0.007613841573527258 | 0.006491288008199521 | 0.006393674654692761 | 0.008053101664307677 | 0.01015178876470301 | 0.01205524915808483 | 0.02191419786226756 | 0.01840011713602421 | 0.02308555810434867 | 0.03748352774659573 | 0.03460393381814632 | 0.03889892137244375 | 0.03401825369710577 | 0.03260286007125775 | 0.04212016203816682 | 0.03504319390892674 | 0.03758114110010249 | 0.05847039875054907 | 0.04280345551271413 | 0.04909951681390014 | 0.03382302699009224 | 0.0373371077163356 | 0.03435990043437942 | 0.03357899360632535 | 0.0341646737273659 | 0.04124164185660598 | 0.03533603396944702 | 0.02791741910293328 | 0.02093806432719996 | 0.01981551076187222 | 0.02098687100395334 | 0.01278734930938552 | 0.01098150226951047 | 0.01390990287471326 | 0.01134755234516082 | 0.01068866220899019 | 0.008858411830738445 | 0.0109082922543804 | 0.01178681243594124 | 0.008565571770218166
 | Forecast Sales | 64.50193875933431 | 55.69612286912702 | 44.98831215444753 | 47.10442696733023 | 34.81541564005236 | 35.6773601503571 | 32.92365091775401 | 48.99132392166226 | 44.75426060208221 | 50.02205635377609 | 79.62117625857925 | 83.95430011972138 | 98.43737529570032 | 84.52056956352673 | 83.83701221435696 | 106.3361278179703 | 134.9806783424186 | 161.3971500266463 | 295.403361498907 | 249.7240963939023 | 315.4353382633319 | 515.6094797942453 | 479.1781451568943 | 542.2269046414682 | 477.3188951813577 | 460.4545797538819 | 598.7385705095078 | 501.3590372202652 | 541.1219874225599 | 847.2735392404436 | 624.1821271706041 | 720.5056428936294 | 499.4399584787127 | 554.7602282974905 | 513.6813139077252 | 505.0918601000479 | 517.0405336132541 | 627.9309260664957 | 541.2607421928715 | 430.1908459134644 | 324.566851189614 | 308.9864116207847 | 329.1798191618123 | 201.744886668364 | 174.2631389201101 | 222.0113029469109 | 182.1570577485654 | 172.56223355524 | 143.8277860570435 | 178.1124650176852 | 193.5400245325107 | 141.4340736092534