Exercise $18-9($Algo$)($LO$18-3,$ LO$18-4)$

Using simple exponential smoothing and the following time series data, respond to each of the items.

Period Demand

$1124$

$2152$

$3163$

$4157$

$5166$

$6170$

$7121$

$8146$

$9136$

$10135$

Click here for the Excel Data File

b$.$ Compute all possible forecasts using a smoothing coefficient $(\backslash$alpha $)$ of $0\mathrm{.}3.($Negative amounts should be indicated by a minus sign. Round your answers to $1$ decimal place.$)$

c$.$ Compute the MAD. $($Round your answer to $2$ decimal places.$)$

d$.$ What is the forecast demand for period $11?($Round your answer to $1$ decimal place.$)$

e$.$ What is the error associated with period $11$s forecast? $($Round your answer to $2$ decimal places.$)$