Please solve these questions using Excel and segment the answer here ..

Refer to the company's sales time series data as follow:.

Year	Quarter	Sales
1	1	128
	2	132
	3	115
	4	137
2	1	122
	2	130
	3	141
	4	128
3	1	118
	2	123
	3	139
	4	133
4	1	137
	2	125
	3	109
	4	?

1. Compute a three-quarter weighted moving average for the time series and Compute all mean errors. Weights are (6-4-2) What is the forecast for quarter 4 in year 4? (1.5 Mark)

2. Develop a four-Quarter moving average for this time series. Compute all mean errors that we learned? then what is the forecast for quarter 4 in year 4? (1.5 Mark)

3. Use = 0.3 to compute the exponential smoothing values for the time series (hint F1=118). Compute all mean errors that we learned? Then compare it with = 0.8 which one is better? (2 Mark)

4. Compare between the methods forecast in (A-B-C), which one appears to provide the better forecast based on MAD? Explain (0.5 Mark)

5. Which kind of forecast is the best when we compare the MSE? (0.5 Mark)

6. Which kind of forecast is the best when we compare the MAPE? (0.5 Mark)