2 historical demand for a product is demand months january 12 february

Question

2. Historical demand for a product is
Demand
Months
January
12
February 11
March
15
April
12
May
June
16
15
a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.
b. Using a simple three-month moving average, find the July forecast.
c. Using single exponential smoothing with Alpha=0.2 and a June forecast = 13, find the July
forecast. Make whatever assumptions you wish.
d. Using simple linear regression analysis, calculate the regression equation for the preceding
demand data.
e. Using the regression equation in d, calculate the forecast for July.