Problem $3-15($Static$)$

Historical demand for a product is

a$.$ Using a weighted moving average with weights of $0\mathrm{.}60($June$),0\mathrm{.}30($May$),$ and $0\mathrm{.}10($April$),$ find the July forecas

Note: Round your answer to $1$ decimal place.

July forecast

b$.$ Using a simple three$-$month moving average, find the July forecast.

Note: Round your answer to $1$ declmal place.

July forecast

c$.$ Using single exponential smoothing with $=0\mathrm{.}2$ and a June forecast $=13,$ find the July forecast.

Note: Round your answer to $1$ declmal place.

July forecast

d$.$ Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

Note: Round your Intercept value to $1$ decimal place and slope value to $2$ decimal places.

$Y=$

$$

e$.$ Using the regression equation in $d,$ calculate the forecast for July.