Problem $3-13($Algo$)$

Historical demand for a product is as follows:

a$.$ Using a simple four$-$month moving average, calculate a forecast for October.

Note: Round your answer to $2$ decimal places.

Forecast for October

b$.$ Using single exponential smoothing with $\backslash (\backslash$alpha$=0\mathrm{.}30\backslash )$ and a September forecast $\backslash (=55\backslash ),$ calculate a forecast for October.

Note: Round your answer to $2$ decimal places.

Forecast for October

c$.$ Using simple linear regression, calculate the trend line for the historical data. Say the $\backslash ($ X $\backslash )$ axis is April $\backslash (=1,$ M a y$=2\backslash ),$ and so on$,$ while the $\backslash ($ Y $\backslash )$ axis is demand.

Note: Round your intercept value to the nearest whole number and slope value to $\backslash (\backslash$mathbf$\{2\}\backslash )$ decimal places.

d$.$ Calculate a forecast for October using your regression formula.

Note: Round your answer to $2$ decimal places.

Forecast for October