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

Period Demand

$1108$

$2136$

$3147$

$4141$

$5150$

$6154$

$7105$

$8130$

$9120$

$10119$

Required:

An older version of the Microsoft Excel logo$.$ Click here for the Excel Data File

Compute all possible forecasts using a smoothing coefficient $(\backslash$alpha $)$ of $0\mathrm{.}3.$

Note: Negative amounts should be indicated by a minus sign. Round all your answers to $1$ decimal place except "Absolute error" and "Absolute percent error" answers which should be rounded to $2$ decimal places.

Compute the MAD and MAPE.

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

What is the forecast demand for period $11?$

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

What is the error associated with period $11$s forecast?

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