Please see the attached file(s).
Step by step method for testing the hypothesis under 5 step approach is discussed here. Excel template for each problem is also included. This template can be used to obtain the answers of similar problems. Time series analysis, Seasonal index, Trend, forecasting, exponential smoothing are also discussed here.