Question: For the data given below, forecast period 1 7 using following methods and suggest the best forecasting model 1 . Simple Moving Average ( Three

For the data given below, forecast period 17 using following methods and suggest the best forecasting model
1. Simple Moving Average (Three Period)
2. Weighted Average (50% on t-1,30% on t-2,20% on t-3)
3. Exponential Smoothing (\alpha =.1), F1= y intercept from regression)
4. Exponential Smoothing (\alpha =.3), F1= y intercept from regression)
5. Exponential Smoothing with trend (\alpha =.3) and (\delta =.3), F1= y intercept from regression)**
6. Exponential Smoothing with trend (\alpha =.1) and (\delta =.3), F1= y intercept from regression)**
7. Regression analysis
8. Plot a single graph representing actual sales and all of the above forecastined sales.
9. Calculate MAD, MSE and MAPE. Suggest which of the above method is most accurate.
Add more columns to the below template as needed.

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!