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

$\backslash$table$[[$Period$,$Demand$],[1,120],[2,148],[3,159],[4,153],[5,162],[6,166],[7,117],[8,142],[9,132],[10,131]]$

Click here for the Excel Data File

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

$\backslash$table$[[$Period$,$Demand,$\backslash$table$[[$Exponential$],[$Smooth$]],$Error,Absolute Error$],[1,120,0\mathrm{.}00,0\mathrm{.}00,0\mathrm{.}00],[2,148,120\mathrm{.}0,,],[3,159,,,],[4,153,,,],[5,162,,,],[6,166,,,],[7,117,,,],[8,142,,,],[9,132,,,],[10,131,,,],[11,,,,0\mathrm{.}0]]$

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

MAD

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

Period $11$ forecast

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