Question

Using ? = 0.5 and the following data, compute exponential smoothing forecasts for periods 2 through 8. (Round your intermediate calculations and final answers to 2 decimal places.) Period: 1 2 3 4 5 6 7 Forecast: 10 Actual demand: 12 15 11 13 11 11 10

Answer 1

Forecast Period/Time = T

Forecast = F

Smoothing Constant = ?

Actual demand value to be forecasted = A

Formula to calculate Forecasted Value = F_t = F_t-1 + ? ( A_t-1 - F_t-1 )

Answer forcast for 8 period = 10.69 = Find the calculation below

Period	Actual Demand	Forecast	Forecast
1	12	10	10
2	15	B2*0.5+(1-0-5)*C2	11
3	11	B3*0.5+(1-0-5)*C3	13
4	13	B4*0.5+(1-0-5)*C4	12
5	11	B5*0.5+(1-0-5)*C5	12.5
6	11	B6*0.5+(1-0-5)*C6	11.75
7	10	B7*0.5+(1-0-5)*C7	11.38
8		B8*0.5+(1-0-5)*C8	10.69