Problem $18-15($Algo$)$

Historical demand for a product is

$$DEMAND

January$20$

February$19$

March$23$

April$20$

May$24$J

une$23$

Using a weighted moving average with weights of $0\mathrm{.}40($June$),0\mathrm{.}40($May$),$ and $0\mathrm{.}20($April$),$ find the July forecast.

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

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

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

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

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

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

Note: Do not round intermediate calculations. Round your intercept value to $1$ decimal place and slope value to $2$ decimal places.

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

Note: Do not round intermediate calculations. Round your answer to $1$ decimal place.