FSeriesSales-20102018-worksheet

YEAR Month SALES VALIDATION M1 SALEShat M2 SALEShat M3 SALEShat 2010 JAN 27630 0 43020.245275 28115.455431 2010 FEB 32895 0 43380.948883 34596.417105 2010 MAR 42514 0 43741.652491 47887.003778 2010 APR 40946 0 44102.3561 41183.340452 2010 MAY 49858 0 44463.059708 45320.677126 2010 JUN 46502 0 44823.763316 44479.7638 2010 JUL 50449 0 45184.466924 43271.350474 2010 AUG 47652 0 45545.170533 47805.187147 2010 SEP 47433 0 45905.874141 46420.898821 2010 OCT 49041 0 46266.577749 45965.735495 2010 NOV 38541 0 46627.281357 44213.697169 2010 DEC 54888 0 46987.984966 60077.408843 2011 JAN 35806 0 47348.688574 33838.598214 32525.247594 2011 FEB 37549 0 47709.392182 40280.927981 41334.423053 2011 MAR 53272 0 48070.09579 53532.882748 53799.447058 2011 APR 45435 0 48430.799399 46790.587515 46635.488946 2011 MAY 42399 0 48791.503007 50889.292282 49617.011147 2011 JUN 49618 0 49152.206615 50009.747049 47210.515269 2011 JUL 49104 0 49512.910223 48762.701816 47381.254553 2011 AUG 48795 0 49873.613832 53257.906583 53825.305669 2011 SEP 54410 0 50234.31744 51834.98635 50264.239223 2011 OCT 52511 0 50595.021048 51341.191117 51649.336641 2011 NOV 47740 0 50955.724656 49550.520884 51334.525075 2011 DEC 68278 0 51316.428265 65375.600651 65725.020064 2012 JAN 38493 0 51677.131873 39098.158115 40116.352679 2012 FEB 47273 0 52037.835481 45501.855975 45772.626274 2012 MAR 58061 0 52398.539089 58715.178835 60018.798171 2012 APR 47453 0 52759.242698 51934.251696 51684.796978 2012 MAY 54836 0 53119.946306 55994.324556 54539.652362 2012 JUN 55025 0 53480.649914 55076.147416 54685.135499 2012 JUL 49314 0 53841.353522 53790.470276 52913.437151 2012 AUG 58201 0 54202.057131 58247.043136 57541.270249 2012 SEP 55077 0 54562.760739 56785.490997 56454.702402 2012 OCT 56497 0 54923.464347 56253.063857 55300.836178 2012 NOV 56299 0 55284.167955 54423.761717 55627.270197 2012 DEC 68787 0 55644.871564 70210.209577 71150.704416 2013 JAN 46841 0 56005.575172 43894.135135 43682.37366 2013 FEB 54489 0 56366.27878 50259.201088 51310.785623 2013 MAR 67513 0 56726.982388 63433.892042 65491.648247 2013 APR 59030 0 57087.685997 56614.332995 58007.407876 2013 MAY 71604 0 57448.389605 60635.773948 60827.541442 2013 JUN 69009 0 57809.093213 59678.964902 63022.334523 2013 JUL 60449 0 58169.796821 58354.655855 60684.984395 2013 AUG 71115 0 58530.50043 62772.596809 63799.585109

2013 SEP 60456 0 58891.204038 61272.412762 63804.169106 2013 OCT 63803 0 59251.907646 60701.353715 60048.550533 2013 NOV 65501 0 59612.611254 58833.419669 60654.883993 2013 DEC 74592 0 59973.314863 74581.235622 77261.714384 2014 JAN 46536 0 60334.018471 48226.529273 48196.000133 2014 FEB 55882 0 60694.722079 54552.96332 53955.55352 2014 MAR 70940 0 61055.425687 67689.022366 68495.173336 2014 APR 63387 0 61416.129296 60830.831413 61482.038552 2014 MAY 68520 0 61776.832904 64813.640459 64230.109992 2014 JUN 60560 0 62137.536512 63818.199506 64245.750165 2014 JUL 63240 0 62498.24012 62455.258553 60383.404973 2014 AUG 68109 0 62858.943729 66834.567599 66873.688221 2014 SEP 59863 0 63219.647337 65295.751646 65519.90601 2014 OCT 63410 0 63580.350945 64686.060692 62366.808934 2014 NOV 59049 0 63941.054553 62779.494739 62884.797547 2014 DEC 74355 0 64301.758162 78488.678786 77784.653311 2015 JAN 54370 0 64662.46177 52095.34053 51029.582474 2015 FEB 55236 0 65023.165378 58383.142669 59177.861171 2015 MAR 67706 0 65383.868986 71480.569809 70902.643242 2015 APR 62827 0 65744.572595 64583.746949 62990.506581 2015 MAY 61870 0 66105.276203 68527.924089 67026.323379 2015 JUN 55171 0 66465.979811 67493.851229 65452.066251 2015 JUL 66288 0 66826.683419 66092.278368 61231.600636 2015 AUG 71332 0 67187.387027 70432.955508 70708.044349 2015 SEP 69651 0 67548.090636 68855.507648 69224.783776 2015 OCT 65500 0 67908.794244 68207.184788 68085.40627 2015 NOV 65192 0 68269.497852 66261.986928 66554.761366 2015 DEC 85211 0 68630.20146 81932.539067 82294.359975 2016 JAN 51540 0 68990.905069 55500.568905 56466.102217 2016 FEB 60697 0 69351.608677 61749.739138 60846.943634 2016 MAR 73884 0 69712.312285 74808.534371 75305.444242 2016 APR 70774 0 70073.015893 67873.079604 67416.708623 2016 MAY 67412 0 70433.719502 71778.624837 72369.891765 2016 JUN 70937 0 70794.42311 70705.92007 69932.604063 2016 JUL 65657 0 71155.126718 69265.715303 68340.800169 2016 AUG 66946 0 71515.830326 73567.760536 72643.45057 2016 SEP 67809 0 71876.533935 71951.680769 69532.795033 2016 OCT 65542 0 72237.237543 71264.726002 69657.01799 2016 NOV 72089 0 72597.941151 69280.896235 68426.309335 2016 DEC 87512 0 72958.644759 84912.816468 85979.685239 2017 JAN 57995 0 73319.348368 58442.214398 59565.341243 2017 FEB 65956 0 73680.051976 64652.752724 64683.806725 2017 MAR 81330 0 74040.755584 77672.916051 78692.845703 2017 APR 70657 0 74401.459192 70698.829377 71346.052445 2017 MAY 76027 0 74762.162801 74565.742703 74057.469914

YEAR Month VALIDATION SALES M1 SALEShat M2 SALEShat 2010 JAN 0 27630 43020.245275 15390.245275 0.5570121345 28115.455431 2010 FEB 0 32895 43380.948883 10485.948883 0.3187702959 34596.417105 2010 MAR 0 42514 43741.652491 1227.6524914 0.0288764287 47887.003778 2010 APR 0 40946 44102.3561 3156.3560997 0.0770858228 41183.340452 2010 MAY 0 49858 44463.059708 5394.9402921 0.1082061112 45320.677126 2010 JUN 0 46502 44823.763316 1678.2366838 0.0360895592 44479.7638 2010 JUL 0 50449 45184.466924 5264.5330756 0.1043535665 43271.350474 2010 AUG 0 47652 45545.170533 2106.8294674 0.0442128235 47805.187147 2010 SEP 0 47433 45905.874141 1527.1258591 0.0321954306 46420.898821 2010 OCT 0 49041 46266.577749 2774.4222509 0.0565735252 45965.735495 2010 NOV 0 38541 46627.281357 8086.2813574 0.2098098481 44213.697169 2010 DEC 0 54888 46987.984966 7900.0150344 0.1439297303 60077.408843 2011 JAN 0 35806 47348.688574 11542.688574 0.3223674405 33838.598214 2011 FEB 0 37549 47709.392182 10160.392182 0.2705902203 40280.927981 2011 MAR 0 53272 48070.09579 5201.9042096 0.0976479991 53532.882748 2011 APR 0 45435 48430.799399 2995.7993986 0.0659359392 46790.587515 2011 MAY 0 42399 48791.503007 6392.5030069 0.1507701363 50889.292282 2011 JUN 0 49618 49152.206615 465.79338488 0.0093875889 50009.747049 2011 JUL 0 49104 49512.910223 408.91022337 0.008327432 48762.701816 2011 AUG 0 48795 49873.613832 1078.6138316 0.0221050073 53257.906583 2011 SEP 0 54410 50234.31744 4175.6825601 0.0767447631 51834.98635 2011 OCT 0 52511 50595.021048 1915.9789519 0.0364871922 51341.191117 2011 NOV 0 47740 50955.724656 3215.7246564 0.0673591256 49550.520884 2011 DEC 0 68278 51316.428265 16961.571735 0.248419282 65375.600651 2012 JAN 0 38493 51677.131873 13184.131873 0.3425072578 39098.158115 2012 FEB 0 47273 52037.835481 4764.8354811 0.1007940152 45501.855975 2012 MAR 0 58061 52398.539089 5662.4609107 0.0975260659 58715.178835 2012 APR 0 47453 52759.242698 5306.2426976 0.1118210165 51934.251696 2012 MAY 0 54836 53119.946306 1716.0536942 0.0312942901 55994.324556 2012 JUN 0 55025 53480.649914 1544.3500859 0.028066335 55076.147416 2012 JUL 0 49314 53841.353522 4527.3535223 0.0918066578 53790.470276 2012 AUG 0 58201 54202.057131 3998.9428694 0.068709178 58247.043136 2012 SEP 0 55077 54562.760739 514.23926117 0.0093367333 56785.490997 2012 OCT 0 56497 54923.464347 1573.5356529 0.0278516674 56253.063857 2012 NOV 0 56299 55284.167955 1014.8320447 0.0180257561 54423.761717 2012 DEC 0 68787 55644.871564 13142.128436 0.1910554093 70210.209577 2013 JAN 0 46841 56005.575172 9164.5751718 0.1956528505 43894.135135 2013 FEB 0 54489 56366.27878 1877.2787801 0.0344524359 50259.201088 2013 MAR 0 67513 56726.982388 10786.017612 0.1597620845 63433.892042 2013 APR 0 59030 57087.685997 1942.3140034 0.0329038456 56614.332995 2013 MAY 0 71604 57448.389605 14155.610395 0.1976930115 60635.773948 2013 JUN 0 69009 57809.093213 11199.906787 0.1622963206 59678.964902 M1 Absolute Deviation M1 Absolute Percentage Error

2013 JUL 0 60449 58169.796821 2279.2031787 0.0377045638 58354.655855 2013 AUG 0 71115 58530.50043 12584.49957 0.1769598477 62772.596809 2013 SEP 0 60456 58891.204038 1564.7959622 0.0258832202 61272.412762 2013 OCT 0 63803 59251.907646 4551.092354 0.0713303819 60701.353715 2013 NOV 0 65501 59612.611254 5888.3887457 0.0898976923 58833.419669 2013 DEC 0 74592 59973.314863 14618.685137 0.1959819436 74581.235622 2014 JAN 0 46536 60334.018471 13798.018471 0.2965020301 48226.529273 2014 FEB 0 55882 60694.722079 4812.722079 0.086122939 54552.96332 2014 MAR 0 70940 61055.425687 9884.5743127 0.1393371062 67689.022366 2014 APR 0 63387 61416.129296 1970.8707045 0.0310926642 60830.831413 2014 MAY 0 68520 61776.832904 6743.1670962 0.0984116622 64813.640459 2014 JUN 0 60560 62137.536512 1577.536512 0.0260491498 63818.199506 2014 JUL 0 63240 62498.24012 741.75987973 0.0117292834 62455.258553 2014 AUG 0 68109 62858.943729 5250.0562715 0.0770831501 66834.567599 2014 SEP 0 59863 63219.647337 3356.6473368 0.0560721537 65295.751646 2014 OCT 0 63410 63580.350945 170.35094502 0.0026864997 64686.060692 2014 NOV 0 59049 63941.054553 4892.0545533 0.0828473734 62779.494739 2014 DEC 0 74355 64301.758162 10053.241838 0.1352059961 78488.678786 2015 JAN 0 54370 64662.46177 10292.46177 0.1893040605 52095.34053 2015 FEB 0 55236 65023.165378 9787.165378 0.1771881631 58383.142669 2015 MAR 0 67706 65383.868986 2322.1310137 0.0342972708 71480.569809 2015 APR 0 62827 65744.572595 2917.5725945 0.0464381969 64583.746949 2015 MAY 0 61870 66105.276203 4235.2762027 0.06845444 68527.924089 2015 JUN 0 55171 66465.979811 11294.979811 0.2047267552 67493.851229 2015 JUL 0 66288 66826.683419 538.68341924 0.0081264093 66092.278368 2015 AUG 0 71332 67187.387027 4144.6129725 0.0581031371 70432.955508 2015 SEP 0 69651 67548.090636 2102.9093643 0.0301920915 68855.507648 2015 OCT 0 65500 67908.794244 2408.794244 0.0367754846 68207.184788 2015 NOV 0 65192 68269.497852 3077.4978522 0.0472066795 66261.986928 2015 DEC 0 85211 68630.20146 16580.79854 0.194585189 81932.539067 2016 JAN 0 51540 68990.905069 17450.905069 0.3385895434 55500.568905 2016 FEB 0 60697 69351.608677 8654.608677 0.1425870912 61749.739138 2016 MAR 0 73884 69712.312285 4171.6877148 0.0564626674 74808.534371 2016 APR 0 70774 70073.015893 700.98410653 0.0099045427 67873.079604 2016 MAY 0 67412 70433.719502 3021.7195017 0.0448246529 71778.624837 2016 JUN 0 70937 70794.42311 142.57689003 0.0020099087 70705.92007 2016 JUL 0 65657 71155.126718 5498.1267182 0.0837401453 69265.715303 2016 AUG 0 66946 71515.830326 4569.8303265 0.0682614395 73567.760536 2016 SEP 0 67809 71876.533935 4067.5339347 0.0599851632 71951.680769 2016 OCT 0 65542 72237.237543 6695.237543 0.1021518651 71264.726002 2016 NOV 0 72089 72597.941151 508.9411512 0.0070599003 69280.896235 2016 DEC 0 87512 72958.644759 14553.355241 0.1663012529 84912.816468 2017 JAN 0 57995 73319.348368 15324.348368 0.2642356818 58442.214398 2017 FEB 0 65956 73680.051976 7724.0519759 0.1171091633 64652.752724 2017 MAR 0 81330 74040.755584 7289.2444158 0.0896255307 77672.916051

M3 SALEShat 485.45543085 0.0175698672 1701.4171046 0.0517226662 5373.0037784 0.1263819866 237.34045222 0.0057964258 4537.322874 0.0910049114 2022.2362002 0.0434870801 7177.6495264 0.1422753578 153.1871474 0.0032147055 1012.1011788 0.0213374903 3075.264505 0.0627080301 5672.6971688 0.14718604 5189.4088426 0.0945454169 1967.4017862 0.0549461483 32525.247594 3280.7524059 0.0916257724 2731.9279808 0.0727563445 41334.423053 3785.4230528 0.1008128859 260.88274775 0.0048971833 53799.447058 527.44705777 0.0099010185 1355.5875147 0.0298357547 46635.488946 1200.4889457 0.0264221183 8490.2922817 0.2002474653 49617.011147 7218.0111474 0.1702401271 391.74704873 0.0078952608 47210.515269 2407.4847307 0.0485203904 341.29818427 0.0069505169 47381.254553 1722.7454468 0.0350836072 4462.9065827 0.0914623749 53825.305669 5030.3056686 0.1030905968 2575.0136503 0.0473261101 50264.239223 4145.7607769 0.0761948314 1169.8088833 0.0222774063 51649.336641 861.663359 0.0164091973 1810.5208837 0.03792461 51334.525075 3594.525075 0.0752937804 2902.3993493 0.0425085584 65725.020064 2552.979936 0.0373909595 605.15811509 0.015721251 40116.352679 1623.3526791 0.0421726724 1771.1440247 0.0374662921 45772.626274 1500.3737263 0.0317384919 654.17883548 0.0112670956 60018.798171 1957.7981713 0.0337196771 4481.2516957 0.0944355825 51684.796978 4231.7969778 0.0891787027 1158.3245559 0.0211234327 54539.652362 296.34763828 0.0054042534 51.147416075 0.0009295305 54685.135499 339.86450062 0.006176547 4476.4702763 0.0907748363 52913.437151 3599.4371508 0.0729901681 46.043136469 0.0007911056 57541.270249 659.72975093 0.011335368 1708.4909967 0.0310200446 56454.702402 1377.7024017 0.0250141148 243.93614314 0.0043176831 55300.836178 1196.1638217 0.0211721653 1875.2382829 0.033308554 55627.270197 671.72980287 0.0119314695 1423.2095773 0.0206900952 71150.704416 2363.7044157 0.0343626618 2946.8648652 0.0629120827 43682.37366 3158.6263396 0.0674329399 4229.7989118 0.077626657 51310.785623 3178.214377 0.0583276327 4079.1079584 0.0604195926 65491.648247 2021.3517527 0.0299401856 2415.667005 0.0409227004 58007.407876 1022.5921237 0.0173232615 10968.226052 0.1531789572 60827.541442 10776.458558 0.1505007899 9330.0350982 0.1352002652 63022.334523 5986.6654765 0.0867519523 M2 Absolute Deviation M2 Absolute Percentage Error M3 Absolute Deviation M3 Absolute Percentage Error

2094.3441448 0.0346464647 60684.984395 235.98439472 0.0039038594 8342.4031914 0.1173086296 63799.585109 7315.4148912 0.1028673963 816.41276204 0.0135042471 63804.169106 3348.1691061 0.0553819159 3101.6462846 0.0486128597 60048.550533 3754.4494667 0.0588444033 6667.5803312 0.1017935655 60654.883993 4846.116007 0.0739853744 10.764377763 0.0001443101 77261.714384 2669.7143841 0.0357908943 1690.529273 0.0363273438 48196.000133 1660.0001329 0.0356713111 1329.0366804 0.0237829119 53955.55352 1926.4464799 0.0344734705 3250.9776338 0.0458271445 68495.173336 2444.8266635 0.0344633023 2556.1685872 0.0403263853 61482.038552 1904.9614484 0.0300528728 3706.3595406 0.0540916454 64230.109992 4289.8900085 0.0626078518 3258.199506 0.0538011807 64245.750165 3685.750165 0.0608611322 784.74144736 0.0124089413 60383.404973 2856.5950266 0.0451706993 1274.4324008 0.0187116593 66873.688221 1235.3117785 0.0181372767 5432.7516458 0.0907530803 65519.90601 5656.90601 0.0944975362 1276.0606924 0.0201239661 62366.808934 1043.191066 0.0164515229 3730.494739 0.063176256 62884.797547 3835.7975471 0.0649595683 4133.6787856 0.055593824 77784.653311 3429.6533106 0.0461253892 2274.6594704 0.0418366649 51029.582474 3340.4175265 0.0614386155 3147.1426694 0.0569762957 59177.861171 3941.8611714 0.0713639867 3774.5698092 0.0557494138 70902.643242 3196.6432421 0.0472135888 1756.746949 0.0279616558 62990.506581 163.50658083 0.0026024891 6657.9240888 0.1076115094 67026.323379 5156.3233791 0.0833412539 12322.851229 0.2233574021 65452.066251 10281.066251 0.186349101 195.72163154 0.0029525952 61231.600636 5056.3993636 0.0762792566 899.04449174 0.012603663 70708.044349 623.95565057 0.0087472053 795.49235194 0.0114211189 69224.783776 426.21622447 0.0061193123 2707.1847879 0.0413310655 68085.40627 2585.4062704 0.0394718515 1069.9869277 0.0164128563 66554.761366 1362.7613659 0.0209038128 3278.4609325 0.038474621 82294.359975 2916.6400253 0.034228445 3960.5689047 0.0768445655 56466.102217 4926.1022167 0.0955782347 1052.7391377 0.0173441708 60846.943634 149.94363443 0.0024703632 924.53437068 0.0125133232 75305.444242 1421.4442422 0.0192388642 2900.9203963 0.0409885042 67416.708623 3357.2913769 0.04743679 4366.6248367 0.064775186 72369.891765 4957.8917646 0.0735461307 231.07993031 0.0032575374 69932.604063 1004.395937 0.0141589853 3608.7153027 0.0549631464 68340.800169 2683.800169 0.0408760706 6621.7605357 0.0989119669 72643.45057 5697.4505699 0.0851051679 4142.6807687 0.0610933765 69532.795033 1723.7950325 0.025421331 5722.7260017 0.0873138751 69657.01799 4115.0179902 0.0627844434 2808.1037653 0.0389532906 68426.309335 3662.6906653 0.0508078995 2599.1835323 0.0297008814 85979.685239 1532.3147612 0.0175097674 447.21439812 0.0077112578 59565.341243 1570.3412434 0.0270771833 1303.2472757 0.0197593437 64683.806725 1272.1932754 0.0192885147 3657.0839495 0.0449659898 78692.845703 2637.1542972 0.0324253572

YEAR Month VALIDATION SALES M1 SALEShat 2010 JAN 0 27630 43020 =ABS($D2-E2) =ABS(($D2-E2)/$D2) 2010 FEB 0 32895 43381 10486 31.9% Training set 2010 MAR 0 42514 43742 1228 2.9% Validation set 2010 APR 0 40946 44102 3156 7.7% 2010 MAY 0 49858 44463 5395 10.8% 2010 JUN 0 46502 44824 1678 3.6% 2010 JUL 0 50449 45184 5265 10.4% Pe 2010 AUG 0 47652 45545 2107 4.4% 2010 SEP 0 47433 45906 1527 3.2% Training set 2010 OCT 0 49041 46267 2774 5.7% Validation set 2010 NOV 0 38541 46627 8086 21.0% 2010 DEC 0 54888 46988 7900 14.4% 2011 JAN 0 35806 47349 11543 32.2% 2011 FEB 0 37549 47709 10160 27.1% 2011 MAR 0 53272 48070 5202 9.8% 2011 APR 0 45435 48431 2996 6.6% 2011 MAY 0 42399 48792 6393 15.1% 2011 JUN 0 49618 49152 466 0.9% 2011 JUL 0 49104 49513 409 0.8% 2011 AUG 0 48795 49874 1079 2.2% 2011 SEP 0 54410 50234 4176 7.7% 2011 OCT 0 52511 50595 1916 3.6% 2011 NOV 0 47740 50956 3216 6.7% 2011 DEC 0 68278 51316 16962 24.8% 2012 JAN 0 38493 51677 13184 34.3% 2012 FEB 0 47273 52038 4765 10.1% 2012 MAR 0 58061 52399 5662 9.8% 2012 APR 0 47453 52759 5306 11.2% 2012 MAY 0 54836 53120 1716 3.1% 2012 JUN 0 55025 53481 1544 2.8% 2012 JUL 0 49314 53841 4527 9.2% 2012 AUG 0 58201 54202 3999 6.9% 2012 SEP 0 55077 54563 514 0.9% 2012 OCT 0 56497 54923 1574 2.8% 2012 NOV 0 56299 55284 1015 1.8% 2012 DEC 0 68787 55645 13142 19.1% 2013 JAN 0 46841 56006 9165 19.6% 2013 FEB 0 54489 56366 1877 3.4% 2013 MAR 0 67513 56727 10786 16.0% 2013 APR 0 59030 57088 1942 3.3% 2013 MAY 0 71604 57448 14156 19.8% 2013 JUN 0 69009 57809 11200 16.2% 2013 JUL 0 60449 58170 2279 3.8% Absolute Deviation Absolute Percentage Error

2013 AUG 0 71115 58531 12584 17.7% 2013 SEP 0 60456 58891 1565 2.6% 2013 OCT 0 63803 59252 4551 7.1% 2013 NOV 0 65501 59613 5888 9.0% 2013 DEC 0 74592 59973 14619 19.6% 2014 JAN 0 46536 60334 13798 29.7% 2014 FEB 0 55882 60695 4813 8.6% 2014 MAR 0 70940 61055 9885 13.9% 2014 APR 0 63387 61416 1971 3.1% 2014 MAY 0 68520 61777 6743 9.8% 2014 JUN 0 60560 62138 1578 2.6% 2014 JUL 0 63240 62498 742 1.2% 2014 AUG 0 68109 62859 5250 7.7% 2014 SEP 0 59863 63220 3357 5.6% 2014 OCT 0 63410 63580 170 0.3% 2014 NOV 0 59049 63941 4892 8.3% 2014 DEC 0 74355 64302 10053 13.5% 2015 JAN 0 54370 64662 10292 18.9% 2015 FEB 0 55236 65023 9787 17.7% 2015 MAR 0 67706 65384 2322 3.4% 2015 APR 0 62827 65745 2918 4.6% 2015 MAY 0 61870 66105 4235 6.8% 2015 JUN 0 55171 66466 11295 20.5% 2015 JUL 0 66288 66827 539 0.8% 2015 AUG 0 71332 67187 4145 5.8% 2015 SEP 0 69651 67548 2103 3.0% 2015 OCT 0 65500 67909 2409 3.7% 2015 NOV 0 65192 68269 3077 4.7% 2015 DEC 0 85211 68630 16581 19.5% 2016 JAN 0 51540 68991 17451 33.9% 2016 FEB 0 60697 69352 8655 14.3% 2016 MAR 0 73884 69712 4172 5.6% 2016 APR 0 70774 70073 701 1.0% 2016 MAY 0 67412 70434 3022 4.5% 2016 JUN 0 70937 70794 143 0.2% 2016 JUL 0 65657 71155 5498 8.4% 2016 AUG 0 66946 71516 4570 6.8% 2016 SEP 0 67809 71877 4068 6.0% 2016 OCT 0 65542 72237 6695 10.2% 2016 NOV 0 72089 72598 509 0.7% 2016 DEC 0 87512 72959 14553 16.6% 2017 JAN 0 57995 73319 15324 26.4% 2017 FEB 0 65956 73680 7724 11.7% 2017 MAR 0 81330 74041 7289 9.0% 2017 APR 0 70657 74401 3744 5.3%

5711.5 =AVERAGEIF(C2:C109,"=0",F2:F109) 7523.0 =AVERAGEIF(C2:C109,"=1",F2:F109) Mean Absolute ercentage Error (MAPE) 10.2% =AVERAGEIF(C2:C109,"=0",G2:G109) 10.6% =AVERAGEIF(C2:C109,"=1",G2:G109) Mean Absolute Deviation (MAD)