You just learned about forecasting techniques in Operations management and wanted to see how well you are at determining the best forecast to use. The following information on the sale of HP Laptops is provided to you and you calculated a forecast using $(1)$ Exponential Smoothing $(2)3$ Month Moving Average and $(3)$ Weighted Moving Average. The forecasts are presented below.

$1.$ For all three methods above, calculate the CFE for months $6$ through $10.$ Type your solution below. Make sure to use Excel formulas for all calculations

$2.$ Using the MSE metric, compare only the $3$MMA forecast and the WMA forecast against sales for months $6$ through $10.$

$2.$a$.$ What is the MSE for the $3$MMA forecast?

$2.$b$.$ What is the MSE for the WMA forecast?

$2.$c Which is the preferred forecasting method between the $3$MMA and the WMA?

Why?