Historical demand for a product is
demand
january 15
february 13
march 17
april 15
may 18
june 17
a. using a weighted moving average with weights of 0.40 (june), 0.30 (may), and 0.30 (april), find the july forecast. (round your answer to 1 decimal place.)
b. using a simple three-month moving average, find the july forecast. (round your answer to 1 decimal place.)
c. using single exponential smoothing with α = 0.10 and a june forecast = 13, find the july forecast. (round your answer to 1 decimal place.)
d. using simple linear regression analysis, calculate the regression equation for the preceding demand data. (do not round intermediate calculations. round your intercept value to 1 decimal place and slope value to 2 decimal places.)
e. using the regression equation in d, calculate the forecast for july. (do not round intermediate calculations. round your answer to 1 decimal place.)