mgt613 gdb last date 8 nov 2010

[aftab]

Question: Given the weekly demand data, what are the exponential smoothing forecasts for periods 2-05 using a=0.10?

Week Demand 0.1
1 980
2 825
3 760
4 650
5
Note: Calculation along with the formula is required for each period's forecast. Students who give answers without calculation will be given low marks/no marks.

[Xpert]

hmmm. So who is gona start the discussion.

[muhammaddewan]

Question: Given the weekly demand data, what are the exponential smoothing forecasts for periods 2-05 using a=0.10?



Week
Demand
0.1

1
980


2
825


3
760


4
650


5





Note: Calculation along with the formula is required for each period's forecast. Students who give answers without calculation will be given low marks/no marks.

week demand 0.10
1 980 980
2 825 980
3 760 964.5
4 650 944.05
5 914.645

[Xpert]

hmmmzzz. good discussion

[Xpert]

[FONT=&quot]Week demand 0.1[/FONT]
[FONT=&quot]1 980 980 [/FONT]
[FONT=&quot]2 825 980[/FONT]
[FONT=&quot]3 760 964.5[/FONT]
[FONT=&quot]4 650 944.05[/FONT]
[FONT=&quot]5 914.645
[/FONT]
[FONT=&quot] Ft = Ft-1 + a (At-1 – Ft-1)[/FONT]
[FONT=&quot] F2= 980+0.1(980-980) = 980[/FONT]
[FONT=&quot] F3= 980+0.1(825-980) = 964.5[/FONT]
[FONT=&quot] F4= 964.5+0.1(760-964.5) = 944.05[/FONT]
[FONT=&quot] F5= 944.05+0.1(650-944.05) = 914.645[/FONT]