Perform a three point moving average and forecast demand, in pounds, for salt for the first quarter of year $4.$ Please round to the nearest whole number.

Flag question: Question $2$

Question $23$ pts

Write down the MAD for the three point moving average. Please round to two decimal points.

Flag question: Question $3$

Question $34$ pts

Perform exponential smoothing $($alpha $=0\mathrm{.}2)$ and indicate your forecast for year $4.$ Please round to the nearest whole number.

Flag question: Question $4$

Question $43$ pts

Write down the MAD for exponential smoothing. Please round your answer to two decimal points.

Flag question: Question $5$

Question $55$ pts

Identify an optimal value for alpha round to $3$ decimal places.

Flag question: Question $6$

Question $63$ pts

Develop the trend projection equation $($simple linear regression$)$ slope. Please round to the nearest whole number.

Flag question: Question $7$

Question $73$ pts

Develop the trend projection equation $($simple linear regression$)$ intercept. Please round to the nearest whole number.

Flag question: Question $8$

Question $83$ pts

Question

Flag question: Question $9$

Question $94$ pts

What is the forecast for year $4$ with Trend Projection for the first quarter? Please round your answer to the nearest whole number.

Flag question: Question $10$

Question $104$ pts

What is the forecast for year $4$ with Trend Projection for the second quarter? Please round your answer to the nearest whole number.

Flag question: Question $11$

Question $114$ pts

What is the forecast for year $4$ with Trend Projection for the third quarter? Please round your answer to the nearest whole number.

Flag question: Question $12$

Question $124$ pts

What is the forecast for year $4$ with Trend Projection for the fourth quarter? Please round your answer to the nearest whole number.

Flag question: Question $13$

Question $134$ pts

Write down the MAD projection. Please round your answer to two decimal places.

Flag question: Question $14$

Question $144$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the first quarter. Please round your answer to three decimal places.

Flag question: Question $15$

Question $154$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the second quarter. Please round your answer to three decimal places.

Flag question: Question $16$

Question $164$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the third quarter. Please round your answer to three decimal places.

Flag question: Question $17$

Question $174$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the fourth quarter. Please round your answer to three decimal places.

Flag question: Question $18$

Question $182$ pts

When is the busiest period $($quarter$)?$

Flag question: Question $19$

Question $194$ pts

Develop the linear regression equation after de$-$seasonalizing the data. Please indicate the slope, rounding your answer to two decimal places.

Flag question: Question $20$

Question $202$ pts

Develop the linear regression equation after de$-$seasonalizing the data. Please indicate the intercept, rounding your answer to the nearest whole number

Flag question: Question $21$

Question $212$ pts

Question

Flag question: Question $22$

Question $222$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the first quarter? Please round your answer to the nearest whole number.

Flag question: Question $23$

Question $232$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the second quarter? Please round your answer to the nearest whole number.

Flag question: Question $24$

Question $242$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the third quarter? Please round your answer to the nearest whole number.

Flag question: Question $25$

Question $252$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the fourth quarter? Please round your answer to the nearest whole number.

Flag question: Question $26$

Question $262$ pts

Of all the forecasts, which do you prefer?

Group of answer choices

Trend Projection

Trend and Seasonal

Exponential Smoothing

Moving Average

Flag question: Question $27$

Question $272$ pts

Why do you prefer that forecast?

Group of answer choices

MAD is the lowest

MAD is the highest

the forecast is best

the forecast is worst

Flag question: Question $28$

Question $2815$ pts

Construct a scatter diagram showing the original data and the trend and seasonal forecast.

Summarize your findings and write a recommendation for the manager at Tahoe.

In your summary you should highlight $($a$)$ the forecasts using each method $($b$)$ the forecast errors using each method $($c$)$ the change in R$2$ from the linear trend model to the trend and seasonal model and the seasonal index values. Explain which is the best forecasting method and why you chose it$.$