This channel was created to help students through homework problems, but over time it has been used by professionals and others interested in forecasting techniques developed in Excel.
If you are interested in learning more about Supply Chain Management, please visit business.rutgers.edu/scmonline.
i tried the goal seek method but it started using negative values of alpha after a while to calculate the lowest possible MSE value. How do i prevent that from happening?
The title of the video is misleading. This video only shows how to compute the moving average, it does not show how to forecast or how to use the moving average for forecasting.
So, the forecast Column you added right beside Seasonal, Is that for those months or for 25th onwards? If not then should we just drag the forecast data from 24th onwards to forecast till 36?
wow so complicated for nothing (excel, not video). most people only want to know what the future value of something that has been growing or decreasing steadfastly is like a savings account or mortgage.
If I need to provide a 4 months forecast of the demand, what changes should I be making to the above? Would just taking M = 4 be sufficient? Once I reach the period 24, how do I forecast for all future periods until period 28? By replacing M by 4 would the rows for the period 21-24 hold the forecasted values for the period 25-28?
This way how can I forecast for next 12 months as next 12 months there are no actual demand. So how can I get trend seasonality and forecast for next 12 months?