$5-22$ Exponential Smoothing

Sales of Cool$-$Man air conditioners have grown steadily during the past $5$ years:

The sales manager had predicted, before the business started, that year $1\text{'}$s sales would be $410$ air conditioners.

Using exponential smoothing with a weight of $=0\mathrm{.}3,$ develop forecasts for years $2$ through $6.$

$5-25$ Moving Averages

Using a $3-$year moving average forecasting model to forecast the sales of Cool$-$man air conditioners.

$=$

$5-26$ Trend Line

Using the trend projection method, develop a forecasting model for the sales of Cool$-$Man air conditioners.

MAPE $=$

$5-27$ Would you use exponential smoothing with a smoothing constant of $0\mathrm{.}3,$ a $3-$year moving average, or a trend line to predict the sales of Cool$-$Man air conditioners?

$**$Needs to be in excel format$**$