Historical demand for a product is
DEMAND
January
15
February
12
March
16
April
15
May
17
June
16
a.
Using a weighted moving average with weights of 0.60 (June),
0.20 (May), and 0.20 (April), find the July forecast.
(Round your answer to 1 decimal place.)
July
forecast
b.
Using a simple three-month moving average, find the July
forecast. (Round your answer to 1 decimal
place.)
July
forecast
c.
Using single exponential smoothing with α = 0.30 and a
June forecast = 11, find the July forecast. (Round your
answer to 1 decimal place.)
July
forecast
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.)
Y = + t
e.
Using the regression equation in d, calculate the
forecast for July. (Do not round intermediate calculations.
Round your answer to 1 decimal place.)
July
forecast