1 / 20

Deseasonalizing Forecasts

Deseasonalizing Forecasts. Agenda:. Seasonality defined & seasonal adjustment methods Brainstorming Exercise Nuts and Bolts How It Works Seasonal adjustment example Exercise Summary Appendix A: Solution to Exercise. Seasonality.

Samuel
Download Presentation

Deseasonalizing Forecasts

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. Deseasonalizing Forecasts

  2. Agenda: • Seasonality defined & seasonal adjustment methods • Brainstorming Exercise • Nuts and Bolts • How It Works • Seasonal adjustment example • Exercise • Summary • Appendix A: Solution to Exercise

  3. Seasonality • A repeated pattern of spikes or drops in the variable of interest associated with a period of time • Examples- • Consumer buying habits • Price of gasoline

  4. Seasonality • Causes of seasonal movement by class: 1. Weather (temperature, precipitation) 2. Calendar Events (religious or secular festivals) 3. Timing decisions (vacations, accounting periods)

  5. Seasonal Adjustment Methods • Seasonal index

  6. Nuts and Bolts Why make seasonal adjustments? • Reduces errors in time-series forecasting • Improves quality of judgmental forecasts • Gives good insight into the factors influencing demand The purpose of finding seasonal indexes is to remove the seasonal effects from the time series

  7. How It Works: Deseasonalizing Forecasts Four-step procedure for seasonal adjustments: 1. Calculate forecast for each demand values in the time series 2. For each demand value, calculate Demand/Forecast 3. Average the Demand/Forecast for months or quarters to get the seasonal index 4. Multiply the unadjusted forecast by the seasonal index to find adjusted forecast value

  8. Season Adjustment Example • Foster Company makes widgets. The quarterly demand for its widget is given in Exhibit 1 • Using linear regression forecasting, develop a seasonal index for each quarter and reforecast each quarter

  9. Seasonal Adjustments ExampleStep 1 Calculate forecast for each demand values in the time series • Use the unadjusted regression forecast model Y= a + bx

  10. Seasonal Adjustments Example – Step 1 • Forecasted demand Y=95.85+4.03*period • Year 1 Quarter 1: Y=95.85+4.03(1) =99.9

  11. Seasonal Adjustments Example – Step 2 • For each demand value, calculate Demand/Forecast • Year 1 Quarter 1: 72/99.9= 0.72

  12. Seasonal Adjustments Example - Step 3 • Average the Demand/Forecast for the quarters to get the seasonal index • Quarterly Seasonal Index for Quarter 1: (0.72+0.66+0.59+0.55)/4 = 0.63

  13. Seasonal Adjustments Example - Step 4 • Multiply the unadjusted forecast by the seasonal index to find the adjusted forecast values • Year 1 Quarter 1: 99.9 * 0.63 = 62.7 (adjusted forecast)

  14. Seasonal Adjustments Example - Step 4

  15. Seasonal Adjustments Example

  16. Exercise • Smith Company makes widgets. The quarterly demand for its widget is given in Exhibit A • You have been asked to develop a seasonal index for each quarter and reforecast each quarter

  17. Exercise Table

  18. Summary • Deseasonalizing forecasts is effective for • Short-term forecasting • Comparability • Detecting trend changes early • The Seasonal Index is the most simple method for making seasonal adjustments

  19. Appendix A: Solution to Exercise

  20. Appendix A: Solution to Exercise

More Related