Chapter 6

2. Forecasting supply chain requirements Chapter 6

3. Introduction Forecasting in general Types of forecasting Long-term and short-term forecasting The forecasting process Appropriate forecasting models Validating forecasting models Stationary data Data with trend Forecasting seasonality Conclusion Contents

4. Demand forecasting refers to the process of determining the amount of product and related information that consumers will require, either in the short or long term. The responsibility for preparing demand forecasting usually lies in the marketing and sales departments. Introduction

5. It is difficult to forecast accurately. Forecasts for groups of items are often more accurate than forecasting demand for a single item. Forecasts for a shorter time period are usually more accurate than forecasting for a longer time horizon. What happened in the past can be used as an important guideline when making forecasts. Forecasting in general: features of forecasting

6. Types of forecasting A time series is a time-ordered sequence of observations taken at regular intervals, e.g. daily, weekly, monthly, quarterly or annually. Explanatory models, also called regression models, rely on the identification of related variables that can be used to predict values of the variable of interest. A mathematical relationship is developed between demand, for example, and some other factors that cause demand behaviour.

7. Types of forecasting:qualitative forecasting techniques • Qualitative forecasting techniques are appropriate when little or no quantitativeinformation is available, but sufficient qualitative knowledge exists. It is usually a product of judgement and accumulated knowledge. • Four techniques: • The Delphi method • Jury of executive option • Sales force composite • Consumer market survey

8. Short-term forecasting is crucial for day-to-day planning, such as determining safety stock levels and production plans. Medium-term forecasts are usually needed for budget purposes, including forecasts of sales, prices and costs for the entire company and different divisions. Long-term forecasting is primarily needed for capital expansion plans, selecting research and development projects, launching new projects, formulating long-term goals and strategies and adapting to environmental changes. Long-term and short-term forecasting

9. Specify the objectives clearly. Determine what to forecast. Determine the time horizon of the forecast. Gather the data needed to make the forecast. Do the model selection. Validate the forecasting models. Make the forecasts. Implement the results. Track the results. Stopped for FT on 10/09/15 The forecasting process

10. a. Level or horizontal pattern b. Trend pattern c. Seasonal pattern d. Cycle Appropriate forecasting models: types of data patterns

11. Appropriate forecasting models: selecting an appropriate forecasting model

12. These measures evaluate how well each forecasting method explains past behaviour of the time series variable. Three of the most common quantitative measures of accuracy are as follows: Measures of accuracy

13. Step 1: Divide time series into an initialisation set and a test set. Step 2: Choose an appropriate forecasting method. Step 3: Use the initialisation set to estimate the trend and seasonal components. Establish fit accuracy. Evaluate forecasting technique

14. Step 4: Apply the method to the test set and establish forecast accuracy. Step 5: Repeat steps 2 to 4 for several forecasting techniques, and select the forecasting method which performs best with regard to forecast accuracy and which is also appropriate depending on the data pattern. Step 6: Use the complete data set and apply the selected technique to do the forecast. Evaluate forecasting technique (continued)

15. The naïve method assumes that the next period’s forecast is equal to the current period’s actual value. The forecast is as follows: Ft+1 = At, where Ft+1 is the forecast for the next period t+1 A t is the actual value for the current period t and T is the current time period. Stationary data: naïve forecasting Note that F6= A5and F7= F6, etc.

16. The simple moving average uses an average of n of the most recent observations to create a forecast for the next period. The following formula is used: where Ft+1 is the forecast for the next period t+1; A t is the actual value for the current period t; t is the current time period, and n is the number of periods included in the moving average. Stationary data: moving averages

17. Stationary data: moving averages(continued)

18. Stationary data: simple exponential smoothing

19. Data with trend: Holt’s method

20. Data with trend: linear regression

21. Multiplicative seasonality: seasonality is expressed as a percentage of the average. Step 1: Calculate the forecast demand for the known observations using linear regression or Holt’s method. Step 2: Calculate the actual sales as a percentage of the trend by dividing the actual sales by the forecast sales for each time period. Step 3: Calculate the average seasonal index for each season by adding up the values calculated in Step 2 for that season and dividing by the number of time periods. Step 4: Multiply the forecast by the average seasonal index for the corresponding season. This will produce a forecast adjusted for seasons. Forecasting seasonality

22. Forecast demand using linear regression. Divide actual sales by linear forecast to get actual as % of trend. Calculate average seasonal index for each quarter. 4. Calculate the seasonal forecast by multiplying the linear forecast with the appropriate seasonal index. Forecasting seasonality: example

23. This chapter presented several methods for forecasting future demand or sales. Different methods for stationary time series data and non-stationary time series data were presented. A practical method for addressing seasonality was also suggested. In each case, the goal was to fit models to the past behaviour of a time series, then to first test the models on test data, and then to fit the appropriate model to project future values. More advanced techniques were discussed in the appendix of the chapter. This chapter is only an introduction to forecasting and the techniques should be seen as such. Conclusion