Read Case $7\mathrm{.}1$ in your textbook on pages $227-229.$ Using all of the data from both pages, populate the empty cells in this spreadsheet: Tires for You template.xlsxDownload Tires for You template.xlsx

For Simple Moving Average, use the previous $3$ periods.

For Weighted Moving Average, use weights of $0\mathrm{.}6,0\mathrm{.}3,$ and $0\mathrm{.}1$ for the previous $3$ periods.

For Exponential Smoothing, use smoothing constant alpha $=0\mathrm{.}4$ and assume the forecast for Dec. $2014$ to be $9,500.$

The spreadsheet template is set up for a $24$ month period encompassing $2015-2016.$ Your deliverable is to populate the empty cells and upload the completed spreadsheet to Canvas. Do not worry about answering the questions shown on page $230,$ but answer this question at the bottom of your spreadsheet: Which forecasting method best predicted future demand for this data set?