Question: I am needing to learn this in excel. Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years

I am needing to learn this in excel.

I am needing to learn this in excel. Tom Simpson,

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 1 2 3 4 Number of Tourists 700 248 633 458 1410 1588 5 6 7 8 9 10 1629 1301 1455 1989 Tom is interested in implementing a forecasting system and is investigating the following four forecasting methods as possibilities: a) Simple moving average b) Weighted moving average (choose any four weights of your choice) c) Simple Exponential Smoothing (assume the forecast for year 9 was 1500, also choose any alpha value of your choice) d) Regression Choose any two of the above four methods and calculate the forecast for year 11. Explain why each of your chosen methods is appropriate for the data and time frame given

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!