Mgt613 GDB No. 1 solution

Total Marks 20

Starting Date : Tuesday, April 26, 2011

Closing Date : Friday, April 29, 2011

Status Open:

Question/Description 

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

860

2

730

3

690

4

610

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.

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Solution:

Exponential Smoothing Model
Ft = Ft-1 + a (At-1 - Ft-1)
Where
Ft = Forecast value for the coming time period
Ft-1 = Forecast value in 1 past time period
At-1 = Actual occurrence in the 1 past time period
a = Alpha smoothing constant

:::::::::::::::::::::::::