Connect Chapter 12 Homework Exercises 0 Saved 1 0.66 points References Exercise 12-1 Algo The owner of a convenience store near Salt Lake City in Utah has been tabulating weekly sales at the store, excluding gas. The accompanying table shows a portion of the sales for 30 weeks. Week Sales 1 5602 . 4800 2 5742.8800 30 5414.2400 EpictureCIick here for the Excel Data File 3. Use the 3-period moving average to forecast sales for the 31st week. (Do not round Intermediate calculations. Round final answer to 2 decimal places.) y: b. Use simple exponential smoothing with a = 0.3 to forecast sales for the 31st week. (Do not round intermediate calculatlons. Round final answer to 2 decimal places.) 9: c-1. Report the performance measures for the techniques in parts a and b. (Do not round intermediate calculations. Round final answers to 2 decimal places.) Technique "SE MAD MAPE (36) Moving average Exponential smoothing c-2. Which is the preferred technique for making the forecast? :imstmm LO Calibri (Body) 17 Paste BI UV v Mv Av F29 X v fx A B C D E F H Week Sales 2 5602.4800 3 5742.8800 A 3 5519.2800 5723.1200 5606.6400 5720.0000 5494.3200 9 8 5385.1200 10 9 5026.3200 11 10 5213.5200 12 11 5241.6000 13 12 5636.8000 14 13 5318.5600 15 14 5279.0400 16 15 5126.1600 17 16 5440.2400 18 17 5197.9200 19 18 5116.8000 20 19 5172.9600 21 20 5084.5600 22 21 5264.4800 23 22 4916.0800 24 23 5315.4400 25 24 5600.4000 26 25 5237.4400 27 26 5062.7200 28 27 5238.4800 29 28 5568.1600 30 29 5218.7200 31 30 5414.2400 32 33 34 35 36 37 38 39 40 41 42 43 44 Sheet1 + Ready