Assume that your stock of sales merchandise is maintained based on the forecast
ID: 368459 • Letter: A
Question
Assume that your stock of sales merchandise is maintained based on the forecast demand. ir the dstrioutors sates personnel caltl on the tirst day or each month compute your tovecast sales by each of the three methods requested here 152 192 June August 222 a. Using a smple three-month movng average, what s the forecas: tor September (Round your answer to 2 decimal places Forecast for September the forecast for September with weights of O 20·0.30, and 50 tr June, Juty, and August, espectivey? not rouind innmediare caiculations. Round your answer to 2 decimal places ) Forecast tor september c. Using single exponential smoothing and assuming mat the torecast tor June nad been 140, forer ast saes for Sept decimai places.) ember with a smoothing constant a of o 30 (Round your answer to2 Forecast for September 1910Explanation / Answer
Weight
Actual
3 month moving avg
Weighted Average
Expo Smoothening
0.2
June
152
140
0.3
July
192
155.6
0.5
August
222
175.52
September
188.67
199.00
122.86
=AVERAGE(C2:C4)
=A2*C2+A3*C3+A4*C4
=C5*0.3+F4*(1-0.3)
Weight
Actual
3 month moving avg
Weighted Average
Expo Smoothening
0.2
June
152
140
0.3
July
192
155.6
0.5
August
222
175.52
September
188.67
199.00
122.86
=AVERAGE(C2:C4)
=A2*C2+A3*C3+A4*C4
=C5*0.3+F4*(1-0.3)