Develop a forecasting model using the data below. Leverage the excel functions at your disposal to tackle this big dataset. Use correct usage (keep it short and sweet) formulas in the file. Also provide a chart that plots actual demand and forecasted demands from the models in the worksheet and identify which model is the best and why?

Time Period (months) 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 Cars sold by Toyota (in millions) 16.919 39.384 14.114 8.588 20.397 18.78 1.38 19.747 9.231 17.527 91.561 39.35 27.851 83.257 63.729 15.943 6.536 11.185 14.785 145.519 135.126 24.629 42.593 26.402 17.947 32.299 21.855 107.995 7.854 32.775 31.148 32.306 13.462 53.48 30.696 76.034 4.734 71.186 88.028 0.916 227.061 16.767 31.038 111.313 101.323 181.749 70.227 113.369 35.068 245.815 6 period SMA 19.697 17.10716666 13.83433333 13.0205 14.51033333 26.371 29.79933333 34.211166666 44.79616666 53.87916666 53.61516666 39.44433333 34.75016666 32.5725 42.9495 54.849 56.29666666 62.30616666 64.84233333 65.36933333 46.49933333 27.62083333 41.51516666 35.72533333 36.7875 38.98766666 38.98883333 37.59 28.50416666 32.311166666 39.521 35.11866666 41.59866666 54.02633333 45.26566666 77.99316666 68.11533333 72.49933333 79.18716666 81.403 111.54183333 85.40283333 101.5031666 102.1748333 8 Period WMA(20% to 1st 4 periods and 5% to the remaining) FIT (alpha= 0.3, = 0.3, consider any initial FIT valual Trend F FIT (alpha=0.9, = 0.3, consider any initial FIT value) 8 16 8 Trend F 16 8 8 25.07523 8.24813 16.8271 50.0646209 12.111497 37.953123 24.35841 8.08271 16.2757 28.866087 38.3011001 9.4350131 38.303144161 7.258174091 31.04497007 20.113892347 2.4048302 17.709062 33.97241202921 4.58381111651 29.3886009127 9.03342855801 -0.707160 9.7405892 33.26181245432 3.362024033881 29.89978842044 21.6216464684483 2.3610036 19.260642 30.97592963102 2.058660912991 28.91726871802 20.6579237130111 1.5937590 19.064164 21.49217798791 -0.60497275380 22.09715074171 -0.3034879650456 -3.611280 3.3077923 18.8162 20.20658581882 -0.76203877271:20.96862459154 19.544302617711 1.8023514 17.741951 18.9535 15.16406857677 -1.74984149640 16.91391007317 9.28008996920469 -0.982240 10.262330 14.77005 14.33577033542-1.53717766831 15.87294800374 17.9467344126688 1.2444254 16.702308 16.7323 42.91643223629 5.413093001495 37.50333923479 105.319850565595 21.120277 84.199573 19.94425 46.93861666563 5.092114100228 41.84650256540 49.2554025281767 3.3084174 45.946985 18.64205 44.58656026626 3.374228600321 41.21233166594 27.5206690418272-2.470771 29.991440 21.67795 63.04226036274 6.854568176358 56.18769218638 90.2614050518988 12.578038 77.683366 38.32255 70.16465699763 6.916374743711 63.24828225392 71.7965292888933 5.4142887 66.382240 41.0728 55.93458551226 2.036425613924 53.89815989834 11.8621888045915 -9.666164 21.528352 43.73105 38.70556277640 -2.4094470821741.11500985858 -4.0356162210783 -11.10423 7.0686188 53.27345 25.56309621142 -4.88629773205 30.44939394348 2.66826965604583 -6.994668 9.6629383 45.25985 16.47334095691-5.85632639108 22.329667348 9.85017543662589 -3.723151 13.573326 47.05725 60.94482159263 5.757782922792 55.18703866984 164.859548646795 32.907431 131.95211 49.22375 95.63326409429 12.43408897945 83.19917511484 162.978727833177 24.879372 138.09935 35.48155 80.37569007697 6.043705210968 74.33198486600 25.9889192368575-12.47505 38.463972 27.08315 71.68414615792 2.643263104040 69.04088305388 32.9406401832741-7.991951 40.932591 47.0425 56.66737226037 -1.43213005017: 58.09950231054 17.2984794284317 -9.757384 27.055864 66.90155 40.13429702865 -4.91696355360 45.05126058226 8.29986390727093 -9.582284 17.882147 69.97385 32.16156763387 -5.62214028618: 37.78370792005 26.7965691001917-3.102517 29.899086 74.49855 22.51986597047 -6.54973137323 29.06959734371 17.912415962432 -4.436740 22.349156 54.7548 49.30543686875 1.143030689422 48.16240617933 118.872298338799 19.885556 98.986741 30.81435 34.28240717936 -2.58759862876 36.87000580813 8.8664460249604 -10.08938 18.955829 32.37215 31.10691975064 -2.72326527490 33.83018502555 26.7500703668372-3.634074 30.384144 28.6892 28.39967577298 -2.71956805246 31.11924382545 28.2615738019788 -2.446633 30.708207 41.22335 27.20357416905 -2.36799887203 29.57157304109 30.5469192189588 -1.354638 31.901557 39.48515 19.47636137108 -3.60474054725 23.08110191833 9.20292557153789 -5.967566 15.170491 40.6156 29.13303988911 -0.544413070641 29.67745295976 55.0395363024806 5.9872437 49.052292 42.4516 29.19818126171 -0.40374666066 29.60192792237 32.5448425739051 -0.585511 33.130353 29.5002 47.06040390897 3.811477025777 43.24892688319 82.8416457060931 11.156561 71.685084 30.1854 34.36458341025 0.002100673969 34.36248273628 2.61226167866676-9.932502 12.544764 35.2117 48.72703655422 3.316028167047 45.41100838717 72.9110326226841 8.5824064 64.328626 37.9879 67.37044046512 6.853114877166 60.51732558795 99.1802909089611 12.663987 86.516303 42.9776 48.30632356089 0.872215235305 47.43410832558 -3.1249418078307 -13.86737 10.742429 52.34835 118.8928626074 16.96013611482 101.9327264926 252.325239208605 48.282833 204.04240 53.1686 96.02391230537 7.768808480155 88.25510382521 25.0049327239247-15.31789 40.322823 61.7855 78.44821498643 1.920076372671 76.52813861375 16.745730239997 -13.68896 30.434693 52.28175 93.18555751439 4.877907023892 88.30765049050 113.700472826805 11.844199 101.85627 90.46025 101.2370671076 5.610276847597 95.62679026007 111.063029422248 8.5022821 102.56074 87.82555 138.2469977832 12.85635080790 125.3906469753 202.267897137786 27.587494 174.68040 78.387 124.5755494557 6.734551007411 117.8409984482 75.3675416821374 -8.063548 83.431089 100.5692 126.9395461753 5.725961556397 121.2135846189 111.765699882396 2.1968457 109.56885 72.10885 96.83560472338 -2.54247759938 99.37808232277 24.2262367341744-18.51153 42.737769 51 52 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 175.67 63.403 276.747 155.787 125.338 220.65 540.561 199.685 230.902 73.203 12.855 76.029 41.184 66.692 29.45 23.713 15.467 55.557 80.556 157.04 24.072 12.698 3.334 6.375 9.126 51.238 13.798 48.911 22.925 26.232 42.541 55.616 5.711 0.11 11.337 39.348 14.351 26.529 67.956 81.174 27.609 20.38 18.392 27.602 16.774 3.311 7.998 1.526 11.592 124.5918333 136.983 117.2586666 151.6786666 158.7483333 173.7933333 169.5991666 230.4143333 253.128 245.4871666 231.7231666 212.976 188.8725 105.643 83.4775 49.90216666 41.65383333 42.08916666 38.67716666 45.23916666 60.29716666 59.40083333 57.565 55.54283333 47.34583333 35.44083333 17.80716666 16.09483333 22.13033333 25.3955 28.705 34.27416666 35.00383333 33.656 25.5225 23.59116666 25.77716666 21.07883333 16.231 26.60516666 40.115833333 42.82783333 39.6665 40.34 40.51883333 31.9885 19.011333333 15.74283333 12.6005 108.30855 152.3950912818 10.86566797550 141.5294233063 264.973556501125 41.317432 223.65612 121.4185 172.3379736574 12.96040976013 159.3775638973 201.805828222516 17.205472 184.60035 119.3314 142.8137436911 3.156262130967 139.6574815602 57.079991774576 -20.16329 77.243282 118.16435 198.2039757825 15.21025519876 182.9937205838 293.927100350647 39.146801254.78029 126.47615 196.8716104261 11.39272737832 185.4788830478 171.449984113579 1.8489740 169.60101 145.04815 180.3662297382 4.954702439975 175.4115272982 119.347936779206 -10.60126 129.94919 142.9173 201.0316025803 8.580241763530 192.4513608167 227.270089115384 16.750295 210.51979 204.4438 342.0283093375 39.13788753130 302.8904218062 610.570750287847 101.33884 509.23190 188.6331 325.6523062271 26.32698969092 299.3253165362 231.173263827375 -9.600311 240.77357 183.8449 315.0266764895 17.79946213047 297.2272143590 221.255573947936 -9.673552 230.92912 207.92195 238.5149047890-3.96466875357 242.4795735426 38.3605099940499-49.64774 88.008257 234.29945 146.5428731677-24.2740601845 170.8169333523-41.128684099732 -56.53423 15.405550 236.89625 94.76840244773 -30.6203087696 125.3887112174 39.4115711978173 -24.90166 64.313231 248.52315 43.25017672342 -35.4429049899 78.69308171341 16.5836525041615 -24.42310 41.006757 218.7082 16.94958281129 -33.3331408950 50.28272370639 50.7873144586724 -10.89385 61.681165 113.99675 -11.5083953802 -32.2081033481 20.69970796790 14.9288057502818 -16.65492 31.583731 86.64975 -29.9801545300 -29.0381777638 -0.94197676614 8.5513873268667 -14.28319 22.834580 47.4203-41.2939420272 -24.9479338561-16.3460081710 2.3594609062712 -12.41597 14.775438 45.56135 -28.4700084927 -16.2313490737 -12.2386594190 52.1846038195184 1.9473577 50.237246 51.43565 -2.18121425435 -6.41900830939 4.237794055040 87.3264950795731 9.6076346 77.718860 47.6388 53.49605099545 7.910900973500 45.58515002195 178.498930534094 28.430281 150.06864 42.92565 49.93157208072 5.262736383909 44.66883569681 26.2497028353405 -13.26499 39.514693 38.5557 40.67321535315 1.911714896643 38.76150045650 -2.8707797000768 -16.92394 14.053170 44.9158 28.02263626206 -1.44881448513 29.47145074720-12.535137434597-15.24865 2.7135220 64.04795 18.13124363472 -3.39710174872 21.52834538344 -5.6589361007084 -10.14292 4.4839862 65.02165 11.22209686845 -4.20757367585 15.42967054430 1.49651677987174 -6.150989 7.6475063 58.37685 22.62072541390-0.606142394011 23.22686780791 53.5430625373644 7.2792108 46.263851 43.45565 18.57372010847 -1.40018768126: 19.97390778973 14.3205502280252 -3.451956 17.772506 15.44945 29.00507158490 1.330167508974 27.67490407592 51.3394204355245 5.8874654 45.451955 13.1502 27.96401117576 0.782961066333 27.18105010943 23.9820139386828-1.784428 25.766442 19.6079 28.07148788355 0.627080060514 27.44440782303 24.8300695255543 -1.176931 26.007001 23.13785 34.34167766947 1.929336150994 32.41234151848 44.3749263123418 3.6050193 40.769906 31.9803 44.56799952937 3.844025160741 40.72397436863 61.1320018866883 6.6401092 54.491892 33.8794 33.25779487366 0.346895203097 32.91089967056 2.92953893471704 -8.323561 11.253100 27.5721 20.67705007603 -2.63640633553; 23.31345641156 -8.6928828728536 -9.084836 0.3919538 31.7605 14.39802421084 -3.477010842374 17.87503505322 5.65724332205976 -3.676768 9.3340117 32.2881 20.65150392624-1.23151302135 21.88301694759 41.398660244595 5.4197359 35.978924 29.2773 16.96279437365 -1.79855837471: 18.76135274836 15.1726336708079 -1.883132 17.055766 25.37385 18.89505619321 -0.93759986834 19.83265606155 26.576449922311 1.1830865 25.393363 21.964 37.09122440952 3.477885074268 33.61333933525 76.1736100684373 12.355565 63.818044 20.8017 57.76139196407 7.445334877411 50.31605708666 94.3796313645718 13.705670 80.673961 23.1926 53.44729397549 4.731619600644 48.71567437485 29.9636630257509 -4.322400 34.286063 28.16895 45.28266892569 1.755563142849 43.52710578284 14.4283771749161-6.909989 21.338366 37.01455 36.55087118752 -0.66459706046: 37.21546824798 12.1558267526052 -5.839810 17.995637 42.70115 32.39621436392 -1.469995467340 33.86620983126 24.3880384871707-1.669344 26.057382 44.811 24.83355529465 -2.87599476009: 27.70955005474 13.8102692690912 -3.725134 17.535403 42.72775 13.56376396964 -4.81302473661: 18.37678870625 -2.1990103553713 -6.559937 4.3609269 32.29525 6.580091284871-5.31394349388 11.89403477875 3.17155447813265 -3.806744 6.9782989 20.27705 -0.70494781010 -5.76881170951$ 5.063863899409-2.5604887476127 -4.251044 1.6905554