Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
store Jan Feb Mar Apr May Jun Jul AUB Sep Oct NOV A1 $10, 7 6 4. 54| 512, 809.80| 511, 302. 77| 512, 948.64\ 512, 087. 48\ 58, 8: 92| 512, 163.93\...
i am needing some help figuring the correct equations to use in excel. I thought I had been doing it correctly but the numbers turn out at error or just #####. I am not sure what I am typing in wrong?
storeJanFebMarAprMayJunJulAUBSepOctNOVA1$10, 7 6 4. 54| 512, 809.80| 511, 302. 77| 512, 948.64\ 512, 087. 48\ 58, 8:26. 92| 512, 163.93\ 58, 8:26. 92\ 511, 840 95\ 511.948.54\ 59, 58.8.09\A2$1, 097.40| 51, 374.90 | 51, 311.84| 51, 248.77\ 51, 349. 68\ 51, 021. 72| 51, 450.59\ 51, 349. 68\ 51, 122.53\ 51, 412.75\ 51, 286.51\A 3AA528, 679.56\ 520, 003. 39\ 520, 726.40| 521, 449.42| $23, 859.47\ 525, 064.49| 521, 449.42| $24, 58.2. 48\ 522, 554,A4| $25, 3.05.49\ 524, 582. 48\$25, 025. 11\ 533, 556.39\ 532, 703. 25| 533, 556.39\ 525, 309.48| 526 , 731.36\ 529, 290. 75\530, 712.63\532, 418.89\ 532, 418. 89| 534, 125.14\AS$18, 441.43\ 516, 581.79| 514, 257. 24| $18, 286.46| $18, 131. 49| $15, 032.09\ 512, 707. 54| 515, 551. 97\ 515, 805 94\ 515, 497.00| 512, 552.57\AG57 , 474.53\ 55, 791.08 | $5, 723. 74\ 57 , 541.87\ 56, 531. 8.0 | 57, 003. 16\ 57, 3:39.85\ 57, 609. 21\ 57,070.50| $5, 397. 12| 56, 801. 15\$16, 948. 68| $19, 420.37\ 516, 242.49\ 517 , 125. 23| $15, 006. 65\516, 772. 14| $19, 057. 27\ 515, 006. 65\514,83.0. 10| 520, 479.56| $17, 3.01. 78\AS51, 673.75\ 52, 143.91\ 51, 711.36| 52, 031. 07\ 52 , 087.49\ 51, 598.53| 51 , 861.81\ 51, 955. 84\ 51, 654.95\ 52, 256. 74\ 51,899.43\514 , 694. 65\ 519, 535. 25\ 514, 003. 14| 520, 399.64| 516, 942. 07\ 515, 040.41| 520, 225. 76\ 517, 979. 34| 518, 570. 85| $15, 559 05\ 519, 708. 13|A10551 165\5511.65\$524.90|5520.49\5453.14|$445.50|5463.14|5396.985410.21547197\5453.14\Use data in worksheet " Time Series " . Plot the data for each store .Develop a sales forecast for each of the 10 stores for the month of December , using ."2 )A three month moving averageb ) A 2 - month weighted moving average , with weights of 0. 7 on the most recent month and 0.3 on theolder month .C )d )Exponential smoothing with an alpha value of 0. 25 . Assume February forecast is January's actual .Compute measures of forecast accuracy to recommend the best forecasting technique to use for thedata .@ )Rank the 10 stores based on the forecasts you made with the technique that you determined ( in theabove step ) to be the best forecasting method .f )You may use up to 8 pages for the body of report , plus a cover page , and any appendixes .