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 forecastfor alpha values of 0.1 and 0.4 . Use the actual valuein Period 1 as your starting forecast in Period 2. (Round allanswers to two decimal places. Use these rounded answers when computing subsequent

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!