Assignment:
Q: Historical Demand data for a product, find the forecast for July
|
Period
|
Demand
|
|
January
|
120
|
|
February
|
110
|
|
March
|
150
|
|
April
|
120
|
|
May
|
160
|
|
June
|
150
|
|
July
|
?
|
Using the 3-period moving average, find the July forecast.
Using the 3-period weighted moving average with weights of 0.60 (most recent), 0.30, and 0.10, find the July forecast.
Using single (simple) exponential smoothing with a = 0.2 and a January forecast 120, find the July forecast.
Using the simple linear regression analysis, calculate the forecast for the July.