Help 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 1 2 Sales 5602.4800 5742.8800 30 5414.2400 Click here for the Excel Data File a. Use the 3-perlod moving average to forecast sales for the 31st week. (Do not round Intermediate calculations. Round final answer to 2 decimal places.) 9,- b. Use simple exponential smoothing with a = 0.3 to forecast sales for the 31st week. (Do not round intermediate calculations. Round final answer to 2 decimal places.) 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.) MSE MAD Technique Moving average Exponential smoothing MAPE (6) c-2. Which is the preferred technique for making the forecast? because it has the out of performances 1 Week 1 N 2 3 2. 3 4 5 6 7 4 5 un 6 8 7 9 8 9 10 11 12 13 10 11 12 13 14 15 16 17 18 19 20 14 Sales 5602.4800 5742.8800 5519.2800 5723.1200 5606.6400 5720.0000 5494.3200 5385.1200 5026.3200 5213.5200 5241.6000 5636.8000 5318.5600 5279.0400 5126.1600 5440.2400 5197.9200 5116.8000 5172.9600 5084.5600 5264.4800 4916.0800 5315.4400 5600.4000 5237.4400 5062.7200 5238.4800 5568.1600 5218.7200 5414.2400 1 15 16 17 OR 18 19 20 21 21 22 23 22 NNNN m NNNNNNNN N00 23 24 24 25 26 27 28 29 30 31 VU WN N N 25 26 27 28 2 29 30 32 33 34 Recover Unsaved Workbooks. We were able to save changes to one Ax v fx XV E4 B D E G 1 2 Week 1 2 3 3 4 5 4 ch 6 5 5 6 7 8 9 7 9 00 10 11 9 10 11 12 13 14 12 13 14 15 16 17 18 19 20 21 22 23 Sales 5602.4800 5742.8800 5519.2800 5723.1200 5606.6400 5720.0000 5494.3200 5385.1200 5026.3200 5213.5200 5241.6000 5636.8000 5318.5600 5279.0400 5126.1600 5440.2400 5197.9200 5116.8000 5172.9600 5084.5600 5264.4800 4916.0800 5315.4400 5600.4000 5237.4400 5062.7200 5238.4800 5568.1600 5218.7200 5414.2400 BOO NNNN 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 25 26 27 28 29 30 31 32 33 mm 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 5602.4800 5742.8800 2 30 5414.2400 Click here for the Excel Data File a. 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.) b. Use simple exponential smoothing with a = 0.3 to forecast sales for the 31st week. (Do not round intermediate calculations. Round final answer to 2 decimal places.) 6-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.) MSE MAD MAPE (%) Technique Moving averago Exponential smoothing 12 c-2. Which is the preferred technique for making the forecast? because it has the out of 3 performance measures Help 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 1 2 Sales 5602.4800 5742.8800 30 5414.2400 Click here for the Excel Data File a. Use the 3-perlod moving average to forecast sales for the 31st week. (Do not round Intermediate calculations. Round final answer to 2 decimal places.) 9,- b. Use simple exponential smoothing with a = 0.3 to forecast sales for the 31st week. (Do not round intermediate calculations. Round final answer to 2 decimal places.) 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.) MSE MAD Technique Moving average Exponential smoothing MAPE (6) c-2. Which is the preferred technique for making the forecast? because it has the out of performances 1 Week 1 N 2 3 2. 3 4 5 6 7 4 5 un 6 8 7 9 8 9 10 11 12 13 10 11 12 13 14 15 16 17 18 19 20 14 Sales 5602.4800 5742.8800 5519.2800 5723.1200 5606.6400 5720.0000 5494.3200 5385.1200 5026.3200 5213.5200 5241.6000 5636.8000 5318.5600 5279.0400 5126.1600 5440.2400 5197.9200 5116.8000 5172.9600 5084.5600 5264.4800 4916.0800 5315.4400 5600.4000 5237.4400 5062.7200 5238.4800 5568.1600 5218.7200 5414.2400 1 15 16 17 OR 18 19 20 21 21 22 23 22 NNNN m NNNNNNNN N00 23 24 24 25 26 27 28 29 30 31 VU WN N N 25 26 27 28 2 29 30 32 33 34 Recover Unsaved Workbooks. We were able to save changes to one Ax v fx XV E4 B D E G 1 2 Week 1 2 3 3 4 5 4 ch 6 5 5 6 7 8 9 7 9 00 10 11 9 10 11 12 13 14 12 13 14 15 16 17 18 19 20 21 22 23 Sales 5602.4800 5742.8800 5519.2800 5723.1200 5606.6400 5720.0000 5494.3200 5385.1200 5026.3200 5213.5200 5241.6000 5636.8000 5318.5600 5279.0400 5126.1600 5440.2400 5197.9200 5116.8000 5172.9600 5084.5600 5264.4800 4916.0800 5315.4400 5600.4000 5237.4400 5062.7200 5238.4800 5568.1600 5218.7200 5414.2400 BOO NNNN 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 25 26 27 28 29 30 31 32 33 mm 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 5602.4800 5742.8800 2 30 5414.2400 Click here for the Excel Data File a. 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.) b. Use simple exponential smoothing with a = 0.3 to forecast sales for the 31st week. (Do not round intermediate calculations. Round final answer to 2 decimal places.) 6-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.) MSE MAD MAPE (%) Technique Moving averago Exponential smoothing 12 c-2. Which is the preferred technique for making the forecast? because it has the out of 3 performance measures