Excel Online Structured Activity: Exponential Smoothing Forecast

Consider the demand for some product over the last $12$ periods. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the exponential smoothing forecast and answer the following questions. Assume the forecast for period $2$ is $1,700.$ Use a smoothing constant $($a$)$ value of $0\mathrm{.}2.$

Exponential Smoothing Forecast

Alpha $()$

$0\mathrm{.}2$

$\backslash$table$[[$Period$,$Actual Demand,Forecast,Formulas,$],[1,1,700,,,],[2,2,100,1,700,,],[3,1,900,,7,$#N$/$A$],[4,1,500,,1,$#N$/$A$],[5,2,400,,7,$#N$/$A$],[6,3,700,,7,$#N$/$A$],[7,3,400,,7,$#N$/$A$],[8,3,300,,7,$#N$/$A$],[9,4,300,,$Z$,$#N$/$A$],[10,4,800,,$V$,$#N$/$A$],[11,4,400,,7,$#N$/$A$],[12,4,400,,$E$,$#N$/$A$],[13,,,r,$#N$/$A$]]$