$1$

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

$\backslash$table$[[$Period$,$Demand$],[1,118],[2,146],[3,157],[4,151],[5,160],[6,164],[7,115],[8,140],[9,130],[10,129]]$

Print

References

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 si Round your answers to $1$ decimal place.$)$

$\backslash$table$[[$Period$,$Demand,$\backslash$table$[[$Exponential$],[$Smooth$]],$Error,Absolute Error$],[1,118,,,],[2,146,,,],[3,157,,,],[4,151,,,],[5,160,,,],[6,164,,,],[7,115,,,]]$

$33$

$\backslash$table$[[8,140,,,],[9,130,,,],[10,129,,,],[11,,,,]]$

points

eBook

Print

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

References

$$

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.$)$

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