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

$\backslash$begin$\{$tabular$\}\{|$cc$|\}$

$\backslash$hline Period & Demand $\backslash \backslash$

$\backslash$hline $1$ & $114\backslash \backslash$

$2$ & $142\backslash \backslash$

$3$ & $153\backslash \backslash$

$4$ & $147\backslash \backslash$

$5$ & $156\backslash \backslash$

$6$ & $160\backslash \backslash$

$7$ & $111\backslash \backslash$

$8$ & $136\backslash \backslash$

$9$ & $126\backslash \backslash$

$10$ & $125\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Required:

Click here for the Excel Data File

b$.$ Compute all possible forecasts using a smoothing coefficient $(\backslash (\backslash$alpha $\backslash ))$ 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 $\backslash (\backslash$mathbf$\{2\}\backslash )$ decimal places.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Period & Demand & Exponential Smooth & Error & Absolute Error & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Absolute Percent Error$\}\backslash \backslash$

$\backslash$hline $1$ & $114$ & & & & & $\backslash \backslash$

$\backslash$hline $2$ & $142$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $3$ & $153$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $4$ & $147$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $5$ & $156$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $6$ & $160$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $7$ & $111$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $8$ & $136$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $9$ & $126$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $10$ & $125$ & & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $11$ & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ c$.$ Compute the MAD and MAPE.

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

d$.$ What is the forecast demand for period $11?$

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

Period $11$ forecast

e$.$ What is the error associated with period $11\text{'}$s forecast?

Note: Round your answer to $\backslash (\backslash$mathbf$\{2\}\backslash )$ decimal places.

Error associated with the period $11\text{'}$s forecast