2. Use the forecast table below for the following questions.

a. Calculate the MSE for a 4-month SMA forecast. (keep two decimals points)

b. What is the error for the month of April using the exponential smoothing with = 0.15?

c. What is the sales forecast for August using the WMA (largest weight to the most current period)?

\begin{tabular}{|c|c|c|c|c|} \hline & & \multicolumn{2}{|c|}{ 4-month MOVING AVERAGE } & ExponentialSmoothing \\ \hline Month & Sales$(inmillions) & SMA & WMAweights(.10,20,30,.40) & =0.15 \\ \hline Jan & 1493 & & & \\ \hline Feb & 1875 & & & \\ \hline Mar & 1452 & & & \\ \hline Apr & 1192 & & & \\ \hline May & 1766 & & & \\ \hline Jun & 1852 & & & \\ \hline Jul & 1229 & & & \\ \hline Aug & & & & \\ \hline \end{tabular}