1 / 22

Averaging Methods of Forecasting

Averaging Methods of Forecasting. Dr. Ron Lembke. All-Time Average. To forecast next period, take the average of all previous periods Advantages: Simple to use Disadvantages: Ends up with a lot of data Gives equal importance to very old data. 4/7/2009 Opening day. 2010 Farm Angels :

nasnan
Download Presentation

Averaging Methods of Forecasting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Averaging Methods of Forecasting Dr. Ron Lembke

  2. All-Time Average To forecast next period, take the average of all previous periods Advantages: Simple to use Disadvantages: Ends up with a lot of data Gives equal importance to very old data

  3. 4/7/2009 Opening day 2010 Farm Angels: Ty 1.000 (first 6 at-bats)

  4. MLB-Long-Run More Representative Best season-ending (or to date) averages, active MLB players MLB nothing changes over time. We want increasing sales 2010 Farm Angels: Noah 0.823, Ty 0.767, Aidan 0.531

  5. Moving Average Compute forecast using n most recent periods Jan Feb Mar Apr May Jun Jul 3 month Moving Avg: June forecast: FJun = (AMar + AApr+ AMay)/3 If no seasonality, freedom to choose n If seasonality is N periods, must use N, 2N, 3N etc. number of periods

  6. Moving Average Advantages: • Ignores data that is “too” old • Requires less data than simple average • More responsive than simple average Disadvantages: • Still lacks behind trend like simple average, (though not as badly) • The larger n is, more smoothing, but the more it will lag • The smaller n is, the more over-reaction

  7. Simple and Moving Averages

  8. Centered MA • CMA smoothes out variability • Plot the average of 5 periods: 2 previous, the current, and the next two • Obviously, this is only in hindsight • FRB Dalls graphs

  9. Centered Moving Average • Take average of n periods, • Plot the average in the middle period • Not useful for forecasting • More stable than actuals • If seasonality, n = season length (4wks, 12 mo, etc.)

  10. CMA - # Periods to Average • What if data has 12-month cycle? Ja F M Ap My Jn Jl Au S O N D Ja F M Avg of Jan-Dec gives average of month 6.5: (1+2+3+4+5+6+7+8+9+10+11+12)/12=6.5 Avg of Feb-Jan gives average of month 6.5: (2+3+4+5+6+7+8+9+10+11+12+13)/12=7.5 How get a July average? Average of other two averages

  11. Stability vs. Responsiveness • Responsive • Real-time accuracy • Market conditions • Stable • Forecasts being used throughout the company • Long-term decisions based on forecasts • Don’t whipsaw those folks

  12. Old Data Comparison of simple, moving averages clearly shows that getting rid of old data makes forecast respond to trends faster Moving average still lags the trend, but it suggests to us we give newer data more weight, older data less weight.

  13. Weighted Moving Average FJun = (AMar+ AApr+ AMay)/3 = (3AMar + 3AApr + 3AMay)/9 Why not consider: FJun = (2AMar + 3AApr + 4AMay)/9 FJun = 2/9 AMar + 3/9 AApr+ 4/9 AMay Ft = w1At-3 + w2At-2 + w3At-1 Complicated: • Have to decide number of periods, and weights for each • Weights have to add up to 1.0 • Most recent probably most relevant, gets most weight • Carry around n periods of data to make new forecast

  14. Weighted Moving Average Wts = 0.5, 0.3, 0.2 F4= 0.5*14+ 0.3*12+ 0.2*10 = 12.6

  15. Setting Parameters • Weighted Moving Average • Number of Periods • Individual weights • Trial and Error • Evaluate performance of forecast based on some metric

  16. Exponential Smoothing At-1 Actual demand in period t-1 Ft-1 Forecast for period t-1  Smoothing constant >0, <1 Forecast is old forecast plus a portion of the error of the last forecast. Formulas are equivalent, give same answer F10 = F9 + 0.2 (A9-F9) F10 = 0.8 F9 + 0.2 (A9-F9)

  17. Exponential Smoothing • Smoothing Constant between 0.1-0.3 • Easier to compute than moving average • Most widely used forecasting method, because of its easy use • F1 = 1,050,  = 0.05, A1 = 1,000 • F2 = F1 + (A1 - F1) • = 1,050 + 0.05(1,000 – 1,050) • = 1,050 + 0.05(-50) = 1,047.5 units • BTW, we have to make a starting forecast to get started. Often, use actual A1

  18. Exponential Smoothing Alpha = 0.3

  19. Exponential Smoothing Alpha = 0.5

  20. Exponential Smoothing We substitute the formula for F11 into F12, etc. Older demands get exponentially less weight

  21. Choosing  • Low : if demand is stable, we don’t want to get thrown into a wild-goose chase, over-reacting to “trends” that are really just short-term variation •  = 0 F10= F9= F8 – F never changes • High : If demand really is changing rapidly, we want to react as quickly as possible •  = 1 F10= A9 – F is just the naïve – very responsive

  22. Summary • All-Time average – too stable • Moving average – more responsive, still lags the trend • Centered Moving average – just FYI • Weighted Moving average • How many periods to use? Weights to be set • Exponential Smoothing – most popular • Easy to implement, one parameter to set

More Related