Solve the question provided in the Excel file. Please show the work so I can better understand. See the data below.

1. Is this data stationary or non-stationary?
2. Forecast the sale amount for the first quarter of 2012 using a moving average model.
3. Forecast the sale amount for the first quarter of 2012 using a weighted moving average model.
4. Forecast the sales amount for the first quarter of 2012 using the trend analysis.
5. Which model would you recommend using to forecast the sales amount for the first quarter of 2012? Why?
6. If you were asked to forecast the sales for the fourth quarter of 2012, which model would you use?
   1. What is the forecasted sales amount for the fourth quarter of 2012?

\begin{tabular}{c|c|c} Year & Quarter & Sales \\ \hline 2006 & 1$474,000.00 \\ \hline 2006 & 2 & $528,000.00 \\ 2006 & 3$443,000.00 \\ \hline 2006 & 4$502,000.00 \\ \hline 2007 & 1$411,000.00 \\ \hline 2007 & 2 & $452,000.00 \\ \hline 2007 & 3$441,000.00 \\ \hline 2007 & 4$487,000.00 \\ \hline 2008 & 1$530,000.00 \\ \hline 2008 & 2$507,000.00 \\ \hline 2008 & 3$514,000.00 \\ \hline 2008 & 4$466,000.00 \\ \hline 2009 & 1$452,000.00 \\ \hline 2009 & 2$486,000.00 \\ \hline 2009 & 3$463,000.00 \\ \hline 2009 & 4$425,000.00 \\ \hline 2010 & 1$494,000.00 \\ \hline 2010 & 2$458,000.00 \\ \hline 2010 & 3$578,000.00 \\ \hline 2010 & 4$416,000.00 \\ \hline 2011 & 1$550,000.00 \\ \hline 2011 & 2$433,000.00 \\ \hline 2011 & 3$446,000.00 \\ \hline 2011 & 4$553,000.00 \\ \hline \end{tabular}