Excel Online Structured Activity: Exponential Smoothing Forecast Consider the demand for some product over the fast 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.400 . Use a smoothing constant ( 0 ) value of 0.4 . Questions 1. Calculate the forecast for the periods from 3 to 13 using the exponential smoothing method. Do not round intermediate calculations, Round your answers to the nearest whole number. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} A \\ 1 \\ 2 \end{tabular}} & \multirow{2}{*}{\multicolumn{3}{|c|}{ Exponential Smoothing Forecast }} & \multirow[t]{3}{*}{ D } & \multirow[t]{2}{*}{ E } & \multirow[t]{2}{*}{F} \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline 3 & Alpha ( ) & 0.4 & & & & \\ \hline 4 & & & & & & \\ \hline 5 & Period & Actual Demand & Forecast & Formulas & & \\ \hline 6 & 1 & 1,400 & & & & \\ \hline 7 & 2 & 2,400 & 1,400 & & & \\ \hline 8 & 3 & 2,200 & & V & \#N/A & \\ \hline 9 & 4 & 1,700 & & F & \#N/A & \\ \hline 10 & 5 & 2,700 & & & \#N/A & \\ \hline 11 & 6 & 3,600 & & F & \#N/A & \\ \hline 12 & 7 & 3,100 & & F & \#N/A & \\ \hline 13 & 8 & 3,000 & & F & #N/A & \\ \hline 14 & 9 & 4,200 & & V & #N/A & \\ \hline 15 & 10 & 4,900 & & F & \#N/A & \\ \hline 16 & 11 & 4,500 & & F & \#N/A & \\ \hline 17 & 12 & 4,600 & & F & \#N/A & \\ \hline 18 & 13 & & & F & \#N/A & \\ \hline 19 & & 36 & & & & \\ \hline 20 & & & & & & \\ \hline 21 & & & & & & \\ \hline \end{tabular}