Question: Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.1 and 0.4 . Use the actual value in Period




Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.1 and 0.4 . Use the actual value in Period 1 as your starting forecast in Period 2. (Round all answers to two decimal places. Use these rounded answers when computing subsequent answers.) Compute a three-period moving average forecast given demand for shopping carts for the last five periods. (Round all your answers to two decimal points.) If actual demand in period 6 turns out to be 54 , the moving average forecast for period 7 would be 2 points \begin{tabular}{|c|} \hline eBook \\ \hline Print \\ \hline References \\ \hline \end{tabular} \begin{tabular}{|c|r|r|} \hline & \multicolumn{1}{|c|}{=0.1} & \multicolumn{1}{c|}{=0.4} \\ \hline Period & \multicolumn{1}{c|}{ Forecast } & \multicolumn{1}{c|}{ Forecast } \\ \hline 1 & & \\ \hline 2 & 41.00 & 41.00 \\ \hline 3 & 41.00 & 41.00 \\ \hline 4 & 41.10 & 41.40 \\ \hline 5 & 40.89 & 40.44 \\ \hline 6 & 40.70 & 39.86 \\ \hline 7 & 40.33 & 38.71 \\ \hline 8 & 39.79 & 37.22 \\ \hline 9 & 39.11 & 35.53 \\ \hline 10 & 38.29 & 33.71 \\ \hline 11 & 37.36 & 31.82 \\ \hline 12 & & \\ \hline \end{tabular} Given the following demand data, a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the next most recent, 0.2 for the next, and 0.1 for the next. (Round all your answers to two decimal points.) b. If the actual demand for period 6 is 56 , forecast demand for period 7 using the same weights as in part a
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
