$1.$ Develop a linear regression trendline for the data provided from $(20082015)$ to provide a regression equation. $2.$ Use the regression equation from question $1$ to obtain forecasted sales $($FT$)$ for Jan $2015-$Dec $2015($i$.$e$.$ months $85-96).$ Insert your forecasted sales in the "Regress Sale Forecast $($F$1)$ column in the Table $1$ below. Next, calculate the forecast errors for Jan $2015-$Dec $2015($i$.$e$.$ months $85-96).$ Insert your forecast error values in the "Forecast Error $($FET$)"$ column in Table below. For your submitted you can simply copy and paste the completed Table $1.$ Table $1.2015$ Gales Data and Reoression Forecast $3.$ Use the data obtained in Table $1$ to calculate the Mean Absolute Percentage Error $($MAPE$)$ for $2015$ when using the Regression method to forecast sales. $4.$ Use exponential smoothing with an alpha value of $\backslash$alpha $=0\mathrm{.}50$ to obtain forecasted sales $($Fi$)$ for Jan $2015-$Dec $2015($i$.$e$.$ months $85-96).$ Note that you will need the Actual Sales $($Ar$)$ from Dec $2014($i$.$e month $84)$ and a forecast from month $84($use the Naive Method$)$ to get the first exponential smoothing forecast. These values can be obtained from the data file provided. Insert your forecasted sales in the "Exponential $4.$ Use exponential smoothing with an alpha value of $\backslash$alpha $=0\mathrm{.}50$ to obtain forecasted sales $($FT$)$ for Jan $2015-$Dec $2015($i$.$e$.$ months $85-96).$ Note that you will need the Actual Sales $($A$)$ from Dec $2014($i$.$e month $84)$ and a forecast from month $84($use the Na$$ve Method$)$ to get the first exponential smoothing forecast. These values can be obtained from the data file provided. Insert your forecasted sales in the "Exponential $2$ MQM $227$: Operations Management Smoothing Sales Forecast $($FT$)$ column in the Table $2$ below. Next, calculate the forecast errors for Jan $2015-$Dec $2015($i$.$e$.$ months $85-96).$ Insert your forecast error values in the "Forecast Error $($FEr$)"$ column in Table below. For your submitted you can simply copy and paste the completed Table $2.$ Table $2$: $2015$ Sales Data and Exponential Smoothing Forecast $5.$ Use the data obtained in Table $2$ to calculate the Mean Absolute Percentage Error $($MAPE$)$ for $2015$ when using the Exponential Smoothing method to forecast sales. $6.$ Which method would you recommend for Napa Valley Winery to use to forecast their sales moving forward? Justify your answer with a detailed explanation.