write my assignment 26747

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.09A2$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.51A 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. 75530, 712.63532, 418.89 532, 418. 89| 534, 125.14AS$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.57AG57 , 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. 65516, 772. 14| $19, 057. 27 515, 006. 65514,83.0. 10| 520, 479.56| $17, 3.01. 78AS51, 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.43514 , 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 1655511.65$524.90|5520.495453.14|$445.50|5463.14|5396.985410.215471975453.14Use 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 [email protected] )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 .

 
"Not answered?"
Get the Answer