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

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 | 137.5 | 137.5 | 137.5 | 137.5 | 148 | 148 | 148 | 148 | 184 | 201 | 335 | 222 | 343 | 187 | 289 | 580 | 616 | 727 | 1900 | 1858 | 1394 | 972 | 2523 | 1647 | 1554 | 1894 | 1635 | 1709 | 1096 | 2052 | 1329 | 1524 | 1473 | 1316 | 1485 | 1175 | 1849 | 1681 | 1320 | 1258 | 1176 | 1147 | 980 | 747 | 687 | 841 | 740 | 551 | 505 | 303 | 253 | 179 |  | 46437
 | 2016 | 262 | 119 | 108 | 159 | 108 | 137 | 127 | 754 | 338 | 428 | 509 | 483 | 494 | 624 | 707 | 819 | 762 | 1010 | 1537 | 762 | 1174 | 2586 | 1836 | 1884 | 1802 | 1976 | 2874 | 1745 | 2799 | 1766 | 1332 | 1515 | 1182 | 1218 | 1020 | 1519 | 1736 | 2006 | 2016 | 1848 | 1333 | 1221 | 1251 | 1070 | 973 | 873 | 675 | 780 | 651 | 872 | 610 | 265 |  | 54881
 | 2017 | 125 | 103 | 68 | 115 | 101 | 160 | 153 | 129 | 337 | 345 | 313 | 472 | 646 | 636 | 631 | 681 | 913 | 729 | 1056 | 1233 | 1939 | 2642 | 2456 | 2720 | 3096 | 2059 | 1638 | 1660 | 1624 | 3124 | 1892 | 2801 | 1565 | 1413 | 1232 | 1791 | 1484 | 1609 | 1719 | 1413 | 1206 | 1125 | 1135 | 285 |  |  |  |  |  |  |  |  |  | 52574
 | 2018 | 291.5866198710535 | 201.5328328057027 | 177.2063464893397 | 234.5183696741073 | 205.1216552449827 | 257.7573243368641 | 249.9046725256763 | 606.7939171865795 | 509.5659990271639 | 582.3232958014484 | 697.124131945766 | 714.6588860614221 | 907.3680607386058 | 892.0838607681479 | 1010.635873888097 | 1301.715452792243 | 1444.439339722638 | 1566.264353934562 | 2874.635666605569 | 2483.1146087713 | 2925.593458902524 | 4053.44600477221 | 4487.276049693686 | 4145.041679265094 | 4308.387855824872 | 3986.775402314867 | 4162.004680417808 | 3486.410640041259 | 3788.230395797845 | 4797.320813348756 | 3167.599176841524 | 4090.198224251561 | 2975.251446183401 | 2801.16761425992 | 2669.544061890123 | 3224.779252549439 | 3668.302520367984 | 3857.253077443904 | 3705.278424419986 | 3333.450490336418 | 2757.688052403649 | 2609.170411560532 | 2529.988876657147 | 1589.721920039347 | 1894.764606658627 | 1968.381049287038 | 1634.895103810368 | 1547.1439109317 | 1351.804827417133 | 1382.235405396827 | 1021.239487527639 | 528.5149542956297 |  | 111657.2111431001
 | Total | 524.5 | 359.5 | 313.5 | 411.5 | 357 | 445 | 428 | 1031 | 859 | 974 | 1157 | 1177 | 1483 | 1447 | 1627 | 2080 | 2291 | 2466 | 4493 | 3853 | 4507 | 6200 | 6815 | 6251 | 6452 | 5929 | 6147 | 5114 | 5519 | 6942 | 4553 | 5840 | 4220 | 3947 | 3737 | 4485 | 5069 | 5296 | 5055 | 4519 | 3715 | 3493 | 3366 | 2102 | 1660 | 1714 | 1415 | 1331 | 1156 | 1175 | 863 | 444 |  | 153892
 | Weekly Average | 174.8333333333333 | 119.8333333333333 | 104.5 | 137.1666666666667 | 119 | 148.3333333333333 | 142.6666666666667 | 343.6666666666667 | 286.3333333333333 | 324.6666666666667 | 385.6666666666667 | 392.3333333333333 | 494.3333333333333 | 482.3333333333333 | 542.3333333333334 | 693.3333333333334 | 763.6666666666666 | 822 | 1497.666666666667 | 1284.333333333333 | 1502.333333333333 | 2066.666666666667 | 2271.666666666667 | 2083.666666666667 | 2150.666666666667 | 1976.333333333333 | 2049 | 1704.666666666667 | 1839.666666666667 | 2314 | 1517.666666666667 | 1946.666666666667 | 1406.666666666667 | 1315.666666666667 | 1245.666666666667 | 1495 | 1689.666666666667 | 1765.333333333333 | 1685 | 1506.333333333333 | 1238.333333333333 | 1164.333333333333 | 1122 | 700.6666666666666 | 830 | 857 | 707.5 | 665.5 | 578 | 587.5 | 431.5 | 222 |  | 51297.33333333334
 | Seasonal Indices | 0.003408234346164843 | 0.002336053855950926 | 0.002037142931406441 | 0.002673953161957736 | 0.002319808697008291 | 0.002891638291789047 | 0.002781171210979128 | 0.006699503547942713 | 0.005581836612689418 | 0.006329113924050633 | 0.007518259558651522 | 0.007648220830192602 | 0.009636628284771137 | 0.009402697995997192 | 0.01057234943986692 | 0.0135159722402724 | 0.0148870636550308 | 0.01602422478101526 | 0.02919579965170379 | 0.0250370389623892 | 0.02928677254178255 | 0.04028799417773503 | 0.04428430327762326 | 0.04061939542016479 | 0.04192550619915265 | 0.03852701894835339 | 0.03994359680815117 | 0.03323109713305435 | 0.03586281288176123 | 0.04510955735190913 | 0.02958568346632703 | 0.03794869128999558 | 0.02742182829516804 | 0.02564785693863229 | 0.02428326358745094 | 0.02914381514308736 | 0.03293868427208692 | 0.03441374470407818 | 0.03284771138200816 | 0.0293647493047072 | 0.02414030618875575 | 0.02269773607464975 | 0.02187248200036389 | 0.01365892963896759 | 0.01618017830686455 | 0.01670652145660593 | 0.0137921399422972 | 0.01297338393158839 | 0.0112676422426117 | 0.01145283705455774 | 0.008411743300496452 | 0.004327710342317989
 | 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 | 40343.46997140133 | 58859.94436717664 | 67496.49122807018 | 51421.99270959903 | 63798.36414565827 | 51182.05842696629 | 53214.99065420561 | 22091.18913676043 | 32964.0605355064 | 31758 | 44558.18496110631 | 29026.35853865761 | 35593.36210384357 | 19887.90877677955 | 27335.45666871543 | 42912.19230769231 | 41378.20689655172 | 45368.8094079481 | 65077.85444024037 | 74210.05346483261 | 47598.28000887509 | 24126.29419354839 | 56972.78297872341 | 40547.13229883219 | 37065.74209547428 | 49160.30494181145 | 40932.71839921913 | 51427.7332811889 | 30560.9045116869 | 45489.25151253241 | 44920.37513727213 | 40159.48767123288 | 53716.3308056872 | 51310.32987078794 | 61153.22986352689 | 40317.30211817168 | 56134.60406391793 | 48846.76208459215 | 40185.44807121662 | 42840.48152246072 | 48715.2064602961 | 50533.67420555397 | 44805.15745692216 | 54689.49762131304 | 42459.35903614457 | 50339.62349280436 | 53653.74793875148 | 42471.57124968695 | 44818.60438292965 | 26456.32680851064 | 30076.99961375049 | 41361.36336336337
 | 2016 | 76872.64823641564 | 50940.6063977747 | 53015.42583732058 | 59462.52247873633 | 46555.56302521009 | 47377.98651685393 | 45664.21495327103 | 112545.6527643065 | 60553.54598370199 | 67624 | 67701.83923941228 | 63151.9422259983 | 51262.74308833446 | 66363.93089149965 | 66872.55316533496 | 60594.975 | 51185.37931034483 | 63029.57015409571 | 52644.55909192076 | 30434.90890215417 | 40086.35633459064 | 64187.85677419355 | 41459.38547322084 | 46381.78339465686 | 42980.99566026039 | 51288.68139652556 | 71951.45729624208 | 52511.05592491201 | 78047.41946004711 | 39149.13166234515 | 45021.77553261586 | 39922.32534246575 | 43104.34691943128 | 47489.34785913352 | 42004.23869413968 | 52120.83567447046 | 52703.98737423555 | 58290.66314199397 | 61374.13887240356 | 62932.59924762116 | 55218.85222072679 | 53793.91125107358 | 57195.1550802139 | 78337.03139866795 | 60135.30763052209 | 52255.04317386231 | 48940.9187279152 | 60123.09541697972 | 57776.06228373702 | 76138.33985815603 | 72517.6670529162 | 61233.3033033033
 | 2017 | 36675.88179218303 | 44091.44923504868 | 33380.08293460925 | 43007.48481166465 | 43538.07282913166 | 55331.95505617977 | 55012.79439252337 | 19255.15809893308 | 60374.39348079162 | 54510 | 41631.97579948141 | 61713.6992353441 | 67035.894807822 | 67640.1603317208 | 59683.9901659496 | 50384.8326923077 | 61328.41379310346 | 45493.62043795621 | 36169.58646783886 | 49247.03763301324 | 66207.36365653429 | 65577.84903225808 | 55459.83154805576 | 66963.08430651097 | 73845.26224426535 | 53443.01366166302 | 41007.8243045388 | 49953.2107938991 | 45283.67602826599 | 69253.61682512244 | 63949.84933011202 | 73810.18698630137 | 57071.32227488151 | 55092.32227007854 | 50734.53144233342 | 61453.86220735787 | 45053.40856184652 | 46754.5747734139 | 52332.41305637982 | 48118.91922991812 | 49957.94131897713 | 49564.41454337246 | 51891.68746286393 | 20865.47098001903 | 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) | 40343.46997140133 | 58859.94436717664 | 67496.49122807018 | 51421.99270959903 | 63798.36414565827 | 51182.05842696629 | 53214.99065420561 | 22091.18913676043 | 32964.0605355064 | 31758 | 44558.18496110631 | 29026.35853865761 | 35593.36210384357 | 19887.90877677955 | 27335.45666871543 | 42912.19230769231 | 41378.20689655172 | 45368.8094079481 | 65077.85444024037 | 74210.05346483261 | 47598.28000887509 | 24126.29419354839 | 56972.78297872341 | 40547.13229883219 | 37065.74209547428 | 49160.30494181145 | 40932.71839921913 | 51427.7332811889 | 30560.9045116869 | 45489.25151253241 | 44920.37513727213 | 40159.48767123288 | 53716.3308056872 | 51310.32987078794 | 61153.22986352689 | 40317.30211817168 | 56134.60406391793 | 48846.76208459215 | 40185.44807121662 | 42840.48152246072 | 48715.2064602961 | 50533.67420555397 | 44805.15745692216 | 54689.49762131304 | 42459.35903614457 | 50339.62349280436 | 53653.74793875148 | 42471.57124968695 | 44818.60438292965 | 26456.32680851064 | 30076.99961375049 | 41361.36336336337
 | 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 | 1627595569.333361 | 3464493050.907129 | 4555776328.100955 | 2644221334.226056 | 4070231267.662014 | 2619603104.821391 | 2831835230.327191 | 488020637.476122 | 1086629286.988531 | 1008570564 | 1985431847.02816 | 842529490.0147012 | 1266887425.855327 | 395528915.5135049 | 747227191.2872187 | 1841456248.652367 | 1712156005.973841 | 2058328867.09472 | 4235127138.545114 | 5507132035.253315 | 2265596259.803278 | 582078071.5136467 | 3245898000.340716 | 1644069937.659001 | 1373869237.088214 | 2416735581.971891 | 1675487435.549773 | 2644811750.441104 | 933968884.5724448 | 2069272003.170433 | 2017840102.473256 | 1612784450.015905 | 2885444195.226019 | 2632749951.449073 | 3739717522.741357 | 1625484850.087931 | 3151093773.412832 | 2386006166.148749 | 1614870236.684448 | 1835306857.076299 | 2373171340.469275 | 2553652228.713071 | 2007502134.739588 | 2990941150.071605 | 1802797169.760232 | 2534077693.3973 | 2878724667.875078 | 1803834364.417235 | 2008707298.83356 | 699937228.1987188 | 904625905.7655469 | 1710762379.276177
 | sum x*y | 40343.46997140133 | 117719.8887343533 | 202489.4736842106 | 205687.9708383961 | 318991.8207282913 | 307092.3505617977 | 372504.9345794393 | 176729.5130940834 | 296676.5448195576 | 317580 | 490140.0345721694 | 348316.3024638913 | 462713.7073499664 | 278430.7228749137 | 410031.8500307314 | 686595.076923077 | 703429.5172413794 | 816638.5693430658 | 1236479.234364567 | 1484201.069296652 | 999563.8801863769 | 530778.4722580645 | 1310374.008510638 | 973131.1751719726 | 926643.552386857 | 1278167.928487098 | 1105183.396778917 | 1439976.531873289 | 886266.2308389201 | 1364677.545375973 | 1392531.629255436 | 1285103.605479452 | 1772638.916587678 | 1744551.21560679 | 2140363.045223441 | 1451422.876254181 | 2076980.350364964 | 1856176.959214502 | 1567232.474777448 | 1713619.260898429 | 1997323.46487214 | 2122414.316633267 | 1926621.770647653 | 2406337.895337774 | 1910671.156626506 | 2315622.680669 | 2521726.15312132 | 2038635.419984974 | 2196111.614763553 | 1322816.340425532 | 1533926.980301275 | 2150790.894894895
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) | 76872.64823641564 | 50940.6063977747 | 53015.42583732058 | 59462.52247873633 | 46555.56302521009 | 47377.98651685393 | 45664.21495327103 | 112545.6527643065 | 60553.54598370199 | 67624 | 67701.83923941228 | 63151.9422259983 | 51262.74308833446 | 66363.93089149965 | 66872.55316533496 | 60594.975 | 51185.37931034483 | 63029.57015409571 | 52644.55909192076 | 30434.90890215417 | 40086.35633459064 | 64187.85677419355 | 41459.38547322084 | 46381.78339465686 | 42980.99566026039 | 51288.68139652556 | 71951.45729624208 | 52511.05592491201 | 78047.41946004711 | 39149.13166234515 | 45021.77553261586 | 39922.32534246575 | 43104.34691943128 | 47489.34785913352 | 42004.23869413968 | 52120.83567447046 | 52703.98737423555 | 58290.66314199397 | 61374.13887240356 | 62932.59924762116 | 55218.85222072679 | 53793.91125107358 | 57195.1550802139 | 78337.03139866795 | 60135.30763052209 | 52255.04317386231 | 48940.9187279152 | 60123.09541697972 | 57776.06228373702 | 76138.33985815603 | 72517.6670529162 | 61233.3033033033
 | 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 | 5909404046.879697 | 2594945380.173004 | 2810635376.712439 | 3535791579.534224 | 2167420448.594309 | 2244673606.391192 | 2085220527.298542 | 12666523956.14385 | 3666731931.200311 | 4573005376 | 4583539036.399224 | 3988167806.915828 | 2627868828.940583 | 4404171323.371741 | 4471938366.850551 | 3671750995.250625 | 2619943055.143877 | 3972726713.810072 | 2771449601.982737 | 926283679.8824232 | 1606915964.183775 | 4120080957.264385 | 1718880643.817115 | 2151269830.868866 | 1847365987.947323 | 2630528839.394307 | 5177012207.052947 | 2757410994.349237 | 6091399684.37254 | 1532654509.915636 | 2026960272.109248 | 1593792060.749683 | 1857984723.350685 | 2255238160.08579 | 1764356068.274261 | 2716581511.405152 | 2777710285.14358 | 3397801409.533414 | 3766784922.329077 | 3960512048.061687 | 3049121640.574464 | 2893784887.688381 | 3271285764.649718 | 6136690488.355889 | 3616255223.817528 | 2730589537.102214 | 2395213525.9324 | 3614786602.519248 | 3338073373.01426 | 5797046796.356071 | 5258812034.797606 | 3749517433.434335
 | sum x*y | 4074250.356530029 | 2750792.745479834 | 2915848.421052632 | 3329901.258809234 | 2653667.092436975 | 2747923.217977528 | 2694188.682242991 | 6752739.165858391 | 3693766.305005821 | 4192688 | 4265215.872082974 | 4041724.302463891 | 3332078.30074174 | 4380019.438838977 | 4480461.062077442 | 4120458.3 | 3531791.172413793 | 4412069.9107867 | 3737763.695526374 | 2191313.4409551 | 2926304.012425117 | 4749901.401290323 | 3109453.910491563 | 3525015.537993921 | 3309536.66584005 | 4000517.148928993 | 5684165.126403124 | 4200884.473992961 | 6321840.976263816 | 3210228.796312302 | 3736807.369207116 | 3353475.328767123 | 3663869.488151659 | 4084083.915885483 | 3654368.766390152 | 4586633.5393534 | 4690654.876306964 | 5246159.682779456 | 5585046.637388724 | 5789799.130781147 | 5135353.256527591 | 5056627.657600917 | 5433539.732620321 | 7520355.014272124 | 5833124.840160643 | 5120994.231038506 | 4845150.954063605 | 6012309.541697972 | 5835382.290657439 | 7766110.665531916 | 7469319.706450368 | 6368263.543543543
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) | 36675.88179218303 | 44091.44923504868 | 33380.08293460925 | 43007.48481166465 | 43538.07282913166 | 55331.95505617977 | 55012.79439252337 | 19255.15809893308 | 60374.39348079162 | 54510 | 41631.97579948141 | 61713.6992353441 | 67035.894807822 | 67640.1603317208 | 59683.9901659496 | 50384.8326923077 | 61328.41379310346 | 45493.62043795621 | 36169.58646783886 | 49247.03763301324 | 66207.36365653429 | 65577.84903225808 | 55459.83154805576 | 66963.08430651097 | 73845.26224426535 | 53443.01366166302 | 41007.8243045388 | 49953.2107938991 | 45283.67602826599 | 69253.61682512244 | 63949.84933011202 | 73810.18698630137 | 57071.32227488151 | 55092.32227007854 | 50734.53144233342 | 61453.86220735787 | 45053.40856184652 | 46754.5747734139 | 52332.41305637982 | 48118.91922991812 | 49957.94131897713 | 49564.41454337246 | 51891.68746286393 | 20865.47098001903 | 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 | 1345120305.234183 | 1944055895.646875 | 1114229936.721392 | 1849643749.825565 | 1895563785.674772 | 3061625250.339098 | 3026407546.874051 | 370761113.4149081 | 3645067388.173454 | 2971340100 | 1733221408.968606 | 3808580673.310511 | 4493811192.685376 | 4575191289.700897 | 3562178682.129168 | 2538631365.431839 | 3761174338.378122 | 2069669500.552827 | 1308238985.254472 | 2425270715.627422 | 4383415002.348577 | 4300454283.697632 | 3075792915.338721 | 4484054659.840896 | 5453122755.924322 | 2856155709.2407 | 1681641654.191923 | 2495323268.619718 | 2050611314.632952 | 4796063443.360883 | 4089583229.344028 | 5447943702.952772 | 3257135826.203386 | 3035163973.110192 | 2573992680.673119 | 3776577180.200927 | 2029809623.040665 | 2185990262.242752 | 2738681456.303553 | 2315430387.855384 | 2495795900.830362 | 2456631189.027272 | 2692747227.74355 | 435367879.2180164 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 3850967.588179219 | 4673693.61891516 | 3571668.87400319 | 4644808.359659782 | 4745649.93837535 | 6086515.056179775 | 6106420.177570094 | 2156577.707080504 | 6822306.463329453 | 6214140 | 4787677.216940363 | 7158789.111299916 | 7843199.692515174 | 7981538.919143056 | 7102394.829748002 | 6046179.923076924 | 7420738.068965518 | 5550221.693430657 | 4448859.13554418 | 6106632.666493642 | 8275920.457066786 | 8262808.978064517 | 7043398.606603082 | 8571274.791233404 | 9526038.82951023 | 6947591.776016193 | 5372024.983894583 | 6593823.824794682 | 6022728.911759377 | 9279984.654566407 | 8633229.659565123 | 10038185.43013699 | 7818771.151658767 | 7602740.473270839 | 7052099.870484346 | 8603540.709030101 | 6352530.607220359 | 6639149.617824774 | 7483535.067062314 | 6929124.369108209 | 7243901.491251684 | 7236404.52333238 | 7628078.057040999 | 3088089.705042817 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 7592005.333333334 |  | 717.0566128939024 | -27024.31700375896
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 416112479143.8164
 | sum x*y | 585219068.341668
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) | 85553.57122058372 | 86270.62783347763 | 86987.68444637152 | 87704.74105926543 | 88421.79767215933 | 89138.85428505322 | 89855.91089794713 | 90572.96751084103 | 91290.02412373494 | 92007.08073662884 | 92724.13734952275 | 93441.19396241664 | 94158.25057531055 | 94875.30718820445 | 95592.36380109836 | 96309.42041399225 | 97026.47702688616 | 97743.53363978006 | 98460.59025267397 | 99177.64686556786 | 99894.70347846177 | 100611.7600913557 | 101328.8167042496 | 102045.8733171435 | 102762.9299300374 | 103479.9865429313 | 104197.0431558252 | 104914.0997687191 | 105631.156381613 | 106348.2129945069 | 107065.2696074008 | 107782.3262202947 | 108499.3828331886 | 109216.4394460825 | 109933.4960589764 | 110650.5526718703 | 111367.6092847642 | 112084.6658976581 | 112801.722510552 | 113518.7791234459 | 114235.8357363398 | 114952.8923492337 | 115669.9489621276 | 116387.0055750215 | 117104.0621879154 | 117821.1188008093 | 118538.1754137032 | 119255.2320265971 | 119972.288639491 | 120689.3452523849 | 121406.4018652789 | 122123.4584781727
 | Seasonal Indices | 0.003408234346164843 | 0.002336053855950926 | 0.002037142931406441 | 0.002673953161957736 | 0.002319808697008291 | 0.002891638291789047 | 0.002781171210979128 | 0.006699503547942713 | 0.005581836612689418 | 0.006329113924050633 | 0.007518259558651522 | 0.007648220830192602 | 0.009636628284771137 | 0.009402697995997192 | 0.01057234943986692 | 0.0135159722402724 | 0.0148870636550308 | 0.01602422478101526 | 0.02919579965170379 | 0.0250370389623892 | 0.02928677254178255 | 0.04028799417773503 | 0.04428430327762326 | 0.04061939542016479 | 0.04192550619915265 | 0.03852701894835339 | 0.03994359680815117 | 0.03323109713305435 | 0.03586281288176123 | 0.04510955735190913 | 0.02958568346632703 | 0.03794869128999558 | 0.02742182829516804 | 0.02564785693863229 | 0.02428326358745094 | 0.02914381514308736 | 0.03293868427208692 | 0.03441374470407818 | 0.03284771138200816 | 0.0293647493047072 | 0.02414030618875575 | 0.02269773607464975 | 0.02187248200036389 | 0.01365892963896759 | 0.01618017830686455 | 0.01670652145660593 | 0.0137921399422972 | 0.01297338393158839 | 0.0112676422426117 | 0.01145283705455774 | 0.008411743300496452 | 0.004327710342317989
 | Forecast Sales | 291.5866198710535 | 201.5328328057027 | 177.2063464893397 | 234.5183696741073 | 205.1216552449827 | 257.7573243368641 | 249.9046725256763 | 606.7939171865795 | 509.5659990271639 | 582.3232958014484 | 697.124131945766 | 714.6588860614221 | 907.3680607386058 | 892.0838607681479 | 1010.635873888097 | 1301.715452792243 | 1444.439339722638 | 1566.264353934562 | 2874.635666605569 | 2483.1146087713 | 2925.593458902524 | 4053.44600477221 | 4487.276049693686 | 4145.041679265094 | 4308.387855824872 | 3986.775402314867 | 4162.004680417808 | 3486.410640041259 | 3788.230395797845 | 4797.320813348756 | 3167.599176841524 | 4090.198224251561 | 2975.251446183401 | 2801.16761425992 | 2669.544061890123 | 3224.779252549439 | 3668.302520367984 | 3857.253077443904 | 3705.278424419986 | 3333.450490336418 | 2757.688052403649 | 2609.170411560532 | 2529.988876657147 | 1589.721920039347 | 1894.764606658627 | 1968.381049287038 | 1634.895103810368 | 1547.1439109317 | 1351.804827417133 | 1382.235405396827 | 1021.239487527639 | 528.5149542956297