formulas needed

MGMT 3213 Part 1 Forecasting (30 pts) All analysis and calculations and report must be done in a single (ONE) Excel file. Put your name at the top of the worksheet. Make Excel do all of the calculations. (Instructor must be able to see your cell-reference formulas.) Include report/answers below the forecasting calculations. o Make sure answers are clear, complete and easy to find. o Your report must include: a. Presentation of forecasts b. Explanation of why you chose each of the methods Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 633 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 Tom is interested in implementing a forecasting system and is investigating the following forecasting | methods as possibilities: Simple moving average, Weighted moving average, Simple Exponential Smoothing. Regression. Choose two of the above methods and calculate forecasts for Year 11 . If you use Exponential Smoothing, begin with the assumption the Forecast for Year 9 was 1500 (choose your own alpha) Present your forecast results Explain why each of your chosen methods is appropriate for the data and time frame given