Question

Pints Used 360 Week Of August 31 September 7 September 14 September 21 September 28 October 5 370 408 381 368 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = 372.10 pints (round your response to two decimal places and remember to use the weights in appropriate order — the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 360 and a = 0.25, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). Week Of Pints Used Forecast for this Date 360 370 August 31 September 7 September 14 September 21 360 360.00 362.50 408

Answer 1

c) using the exponential smoothing method

F(September 21) = 0.25*Actual(September 14) + (1-0.25)*F(September 14)

= 0.25*408 + 0.75*362.5

= 373.88