Please answer a) to f). Thank you.

(a) Using a four-quarter weighted moving average with weights of 0.5 for the most recent quarter and then 0.25 for the next recent quarter and then 0.15 and 0.1 respectively, what would have been the forecast for quarter 2 of year 2 ? ( 2 marks) (b) Compute the seasonal indexes for quarters 3 and 4 . If the number of books sold in year 4 is estimated to be 8150 , provide the forecast for quarters 3 and 4 of year 4 . ( 8 marks) (c) Suppose we want to use Trend Projection Method to make forecast for each season. After observing first year's sales, what would have been the projected sales for the first and second quarter of year 2 ? Solve using the formulas. ( 6 marks). (d) Suppose the forecasted sales for years 1, 2 and 3 was 7500,8000,8300. Compute the MAD, MSE and MAPE for 3 years. (2+2+2=6 marks ) (e) Suppose we want predict quarterly sales using Holt's Method using the previous one year data. What is the forecast sales for year 4 quarter 1 ? Use =0.35,=0.25. Suppose the actual sales for year 4 quarter 1 turns out to be 1750 . What is the forecast for quarter 2?(5+5=10 marks) (f) Suppose we want to use Trend Projection Method to make forecast for each season. Using the entire 3 year data, determine the forecast for quarter 1 and quarter 2 of year 4 . Use Excel Regression Tool to solve this problem. Make a printout of your Excel Output to include with the assignment. ( 5 marks)