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$ & $130\backslash \backslash$

$2$ & $122\backslash \backslash$

$3$ & $121\backslash \backslash$

$4$ & $112\backslash \backslash$

$5$ & $141\backslash \backslash$

$6$ & $105\backslash \backslash$

$7$ & $116\backslash \backslash$

$8$ & $118\backslash \backslash$

$9$ & $142\backslash \backslash$

$10$ & $125\backslash \backslash$

$\backslash$hline

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

Click here for the Excel Data File

Required:

a$.$ Compute all possible forecasts using a smoothing coefficient $($d$)$ of $0\mathrm{.}8.$

Note: Negatlve amounts should be Indleated by a minus slgn$.$ Round your answers to $\backslash (\backslash$mathbf$\{2\}\backslash )$ deelmal 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$ & $130$ & $0\mathrm{.}0$ & $0\mathrm{.}0$ & $0\mathrm{.}0$ & $0\mathrm{.}0$ & $\backslash \backslash$

$\backslash$hline $2$ & $122$ & $130\mathrm{.}0$ & $(8\mathrm{.}0)$ & $8\mathrm{.}0$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $3$ & $121$ & $123\mathrm{.}6$ & $(2\mathrm{.}6)$ & $2\mathrm{.}6$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $4$ & $112$ & $121\mathrm{.}3$ & $(9\mathrm{.}5)$ & $9\mathrm{.}5$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $5$ & $141$ & $113\mathrm{.}9$ & $27\mathrm{.}1$ & $27\mathrm{.}1$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $6$ & $105$ & $135\mathrm{.}6$ & $(30\mathrm{.}6)$ & $30\mathrm{.}6$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $7$ & $116$ & $111\mathrm{.}1$ & $4\mathrm{.}9$ & $4\mathrm{.}9$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $8$ & $118$ & $115\mathrm{.}0$ & $3\mathrm{.}0$ & $3\mathrm{.}0$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $9$ & $142$ & $117\mathrm{.}2$ & $24\mathrm{.}6$ & $24\mathrm{.}6$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $10$ & $125$ & $137\mathrm{.}1$ & $(12\mathrm{.}1)$ & $12\mathrm{.}1$ & & $\backslash \%\backslash \backslash$

$\backslash$hline $11$ & & $127\mathrm{.}4$ & $0\mathrm{.}0$ & $0\mathrm{.}0$ & $0\mathrm{.}0$ & $\backslash \backslash$

$\backslash$hline

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

b$.$ Based on the MAD, what is the error associated with period $11\text{'}$s forecast?

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

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

c$.$ Based on the MAPE, what is the percent error associated with period $11\text{'}$s forecast?

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

Percent error associated with period $11\text{'}$s forecast

$6$