Hi, I have 3 years worth of data and I want to forecast the next 3 years based on what I have. Aside from using the Forecast sheet, is there any other way to help me forecast please? I appreciate forecasting isn't an exact science but I'm really struggling with how best to do it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Forecasting
- Thread starter brandon16
- Start date
You might want to start with a line graph of your data to see if you have a linear, nonlinear trend or a seasonal or cyclical component.
This link may be of help or do a google search on forecasting methods.
pressbooks.senecacollege.ca
This link may be of help or do a google search on forecasting methods.
Forecasting – Introduction to Operations Management
pressbooks.senecacollege.ca
Upvote
0
