Question

Week Of Pints Used September 14 410 September 28 October 5 371 378 The forecasted demand for the week of October 12 using a 3-week movingrage 377.33 pints (round your response to two b)Using a 3-week weighted moving average. with weights of 0.10,025, and 065,using 0 65 for the most c) it the forecasted demand for the week of August 31 is 345 and 025 exponential to two decimal places). recent week, the forecasted demand for the week of October 12 -376.75 pints (round your response to wo remember to use the weights in approprisate orderthe largest weight applies to most recent peniod and smallest weight applies to oldest period,) using exponentisl smoothing develop te forecast for each of the weeks with the known demand and the forecast for the wook of October 12 (round your responses to two decimal places). August 31 September 14 September 21 345.00 356.00 410 3 Clear A 30 1 6 1 0 Ul

Answer 1

The formula for exponential smoothing is

Forecast for period (t) = alpha * actual for period (t-1) + (1-alpha) * forecast for period (t-1)

Using this we have

Forecast for (sept 21) = 0.25 * 410 + 0.75 * 356 = 369.5