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 E 30 ? t = Sales 5764.0900 5908.5400 B 5570.4200 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.) Click here for the Excel Data File t= 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.)

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. 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.) Week Sales \begin{tabular}{r|r|} \hline 1 & 5764.0900 \\ \hline 2 & 5908.5400 \\ \hline 3 & 5678.4900 \\ \hline 4 & 5888.2100 \\ \hline 5 & 5768.3700 \\ \hline 6 & 5885.0000 \\ \hline 7 & 5652.8100 \\ \hline 8 & 5540.4600 \\ \hline 9 & 5171.3100 \\ \hline 10 & 5363.9100 \\ \hline 11 & 5392.8000 \\ \hline 12 & 5799.4000 \\ \hline 13 & 5471.9800 \\ \hline 14 & 5431.3200 \\ \hline 15 & 5274.0300 \\ \hline 16 & 5597.1700 \\ \hline 17 & 5347.8600 \\ \hline 18 & 5264.4000 \\ \hline 19 & 5322.1800 \\ \hline 20 & 5231.2300 \\ \hline 21 & 5416.3400 \\ \hline 22 & 5057.8900 \\ \hline 23 & 5468.7700 \\ \hline 24 & 5761.9500 \\ \hline 25 & 5388.5200 \\ \hline 26 & 5208.7600 \\ \hline 27 & 5389.5900 \\ \hline 28 & 5728.7800 \\ \hline 29 & 5369.2600 \\ \hline 30 & 5570.4200 \\ \hline \end{tabular}