Using the data in the table, use the exponential smoothing method with alpha=0.5 and a February forecast of 500 to forecast
sales for May

Month Demand
January 480
February 520
March 535
April 550
May 590
June 630
​

Respuesta :

Answer:

Step-by-step explanation:

The formula to calculate the forecast could be determine by using the exponential smoothing method :

[tex]Ft = F(t-1) + \alpha [A(t-1) - F(t-1)][/tex]

Where ,Ft is the Forecast for period t

F(t-1) is the Forecast for the period previous to t

A(t-1) is the Actual demand for the period previous to t

[tex]\alpha[/tex] = Smoothing constant

To get the forecast for may and june   the above formula with [tex]\alpha =0.5[/tex] and april forecast of 500 will be used

For march

[tex]=500+0.5(520-500)\\\\=500+0.5\times20\\\\=500+10\\\\=510[/tex]

For April

[tex]=510+0.5(535-510)\\\\=510+0.5\times25\\\\=510+12.5\\\\=522.5[/tex]

For May

[tex]=522.5+0.5(550-5225)\\\\=522.5+0.5\times27.5\\\\=522.5+13.75\\\\=536.25[/tex]

So forecast for May = 536.25