Using simple exponentlal smoothing and the following time serles data, respond to each of the items.

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

$\backslash$hline Period & Defand $\backslash \backslash$

$\backslash$hline $1$ & $198\backslash \backslash$

$2$ & $136\backslash \backslash$

$3$ & $147\backslash \backslash$

$4$ & $141\backslash \backslash$

$5$ & $150\backslash \backslash$

$6$ & $154\backslash \backslash$

$7$ & $195\backslash \backslash$

$8$ & $130\backslash \backslash$

$9$ & $120\backslash \backslash$

$10$ & $119\backslash \backslash$

$\backslash$hline

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

Required:

Click here for the Excel Data File

b$.$ Compute all possible forecasts using a smoothing coefficient $($d$)$ 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$|\}$

$\backslash$hline Period & Demand & Exponential Smooth & Error & Absolute Error & Absolute Percent Error $\backslash \backslash$

$\backslash$hline $1$ & $108$ & & & & $\backslash \backslash$

$\backslash$hline $2$ & $138$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $3$ & $147$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $4$ & $141$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $5$ & $150$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $6$ & $154$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $7$ & $105$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $8$ & $130$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $9$ & $120$ & & & & $\backslash \%\backslash \backslash$

$\backslash$hline $10$ & $119$ & & & & $\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 perlod $11?$

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

Period $11$ forecast

e$.$ What is the error assoclated with perlod $11\text{'}$s forecast? Note: Round your answer to $2$ decimal places.

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