Forecasting To Accompany Russell and Taylor Operations Management

  • Slides: 104
Download presentation
Forecasting To Accompany Russell and Taylor, Operations Management, 4 th Edition, 2003 Prentice-Hall, Inc.

Forecasting To Accompany Russell and Taylor, Operations Management, 4 th Edition, 2003 Prentice-Hall, Inc. All rights reserved.

Forecasting ü Predicting future events ü Usually demand behavior over a time frame

Forecasting ü Predicting future events ü Usually demand behavior over a time frame

Forecast: • A statement about the future value of a variable of interest such

Forecast: • A statement about the future value of a variable of interest such as demand. • Forecasts affect decisions and activities throughout an organization – Accounting, finance – Human resources – Marketing – MIS – Operations – Product / service design

Uses of Forecasts Accounting Cost/profit estimates Finance Cash flow and funding Human Resources Hiring/recruiting/training

Uses of Forecasts Accounting Cost/profit estimates Finance Cash flow and funding Human Resources Hiring/recruiting/training Marketing Pricing, promotion, strategy MIS IT/IS systems, services Operations Schedules, MRP, workloads Product/service design New products and services

Uses of Forecasts Ø To help managers plan the system Ø To help managers

Uses of Forecasts Ø To help managers plan the system Ø To help managers plan the use of the system.

Features Common to All Forecasts • Assumes causal system past ==> future • Forecasts

Features Common to All Forecasts • Assumes causal system past ==> future • Forecasts rarely perfect because of randomness • Forecasts more accurate for groups vs. individuals • Forecast accuracy decreases as time horizon increases I see that you will get an A this semester.

Elements of a Good Forecast Timely Reliable M e ul f ng i an

Elements of a Good Forecast Timely Reliable M e ul f ng i an Accurate Written y s Ea to e s u

Time Frame in Forecasting ü Short-range to medium-range ü Daily, weekly monthly forecasts of

Time Frame in Forecasting ü Short-range to medium-range ü Daily, weekly monthly forecasts of sales data ü Up to 2 years into the future ü Long-range ü Strategic planning of goals, products, markets ü Planning beyond 2 years into the future

Steps in the Forecasting Process “The forecast” Step 6 Monitor the forecast Step 5

Steps in the Forecasting Process “The forecast” Step 6 Monitor the forecast Step 5 Prepare the forecast Step 4 Gather and analyze data Step 3 Select a forecasting technique Step 2 Establish a time horizon Step 1 Determine purpose of forecast

Forecasting Process 1. Identify the purpose of forecast 2. Collect historical data 3. Plot

Forecasting Process 1. Identify the purpose of forecast 2. Collect historical data 3. Plot data and identify patterns 6. Check forecast accuracy with one or more measures 5. Develop/compute forecast for period of historical data 4. Select a forecast model that seems appropriate for data 7. Is accuracy of forecast acceptable? 8 a. Forecast over planning horizon 8 b. Select new forecast model or adjust parameters of existing model 9. Adjust forecast based on additional qualitative information and insight 10. Monitor results and measure forecast accuracy

Approaches to Forecasting • Qualitative methods – Based on subjective methods • Quantitative methods

Approaches to Forecasting • Qualitative methods – Based on subjective methods • Quantitative methods – Based on mathematical formulas

Approaches to Forecasting • Judgmental (Qualitative)- uses subjective inputs • Time series - uses

Approaches to Forecasting • Judgmental (Qualitative)- uses subjective inputs • Time series - uses historical data assuming the future will be like the past • Associative models - uses explanatory variables to predict the future

Judgmental Forecasts • Executive opinions • Sales force opinions • Consumer surveys • Outside

Judgmental Forecasts • Executive opinions • Sales force opinions • Consumer surveys • Outside opinion • Delphi method – Opinions of managers and staff – Achieves a consensus forecast

Time Series A time series is a time-ordered sequence of observations taken at regular

Time Series A time series is a time-ordered sequence of observations taken at regular intervals (eg. Hourly, daily, weekly, monthly, quarterly, annually)

Demand Behavior ü Trend ü gradual, long-term up or down movement ü Cycle ü

Demand Behavior ü Trend ü gradual, long-term up or down movement ü Cycle ü up & down movement repeating over long time frame; wavelike variations of more than one year’s duration ü Seasonal pattern ü periodic oscillation in demand which repeats; short-term regular variations in data ü Irregular variations caused by unusual circumstances ü Random movements follow no pattern; caused by chance

Demand Forms of Forecast Movement Random movement Time (b) Cycle Demand Time (a) Trend

Demand Forms of Forecast Movement Random movement Time (b) Cycle Demand Time (a) Trend Time (c) Seasonal pattern Time (d) Trend with seasonal pattern

Forms of Forecast Movement Irregular variation Trend Cycles 90 89 88 Seasonal variations

Forms of Forecast Movement Irregular variation Trend Cycles 90 89 88 Seasonal variations

Time Series Methods ü Naive forecasts Forecast = data from past period Demand? ü

Time Series Methods ü Naive forecasts Forecast = data from past period Demand? ü Statistical methods using historical data ü Moving average ü Exponential smoothing ü Linear trend line ü Assume patterns will repeat

Naive Forecasts Uh, give me a minute. . We sold 250 wheels last week.

Naive Forecasts Uh, give me a minute. . We sold 250 wheels last week. . Now, next week we should sell. . The forecast for any period equals the previous period’s actual value.

Naïve Forecasts • • Simple to use Virtually no cost Quick and easy to

Naïve Forecasts • • Simple to use Virtually no cost Quick and easy to prepare Data analysis is nonexistent Easily understandable Cannot provide high accuracy Can be a standard for accuracy

Uses for Naïve Forecasts • Stable time series data – F(t) = A(t-1) •

Uses for Naïve Forecasts • Stable time series data – F(t) = A(t-1) • Seasonal variations – F(t) = A(t-n) • Data with trends – F(t) = A(t-1) + (A(t-1) – A(t-2))

Techniques for Averaging • Moving Average • Weighted Moving Average • Exponential Smoothing Averaging

Techniques for Averaging • Moving Average • Weighted Moving Average • Exponential Smoothing Averaging techniques smooth fluctuations in a time series.

Moving Average ü Average several periods of data ü Dampen, smooth out changes ü

Moving Average ü Average several periods of data ü Dampen, smooth out changes ü Use when demand is stable with no trend or seasonal pattern n MAn = At-i i=1 n where n = number of periods in the moving average At-i= actual demand in period t-i

Moving Averages • Moving average – A technique that averages a number of recent

Moving Averages • Moving average – A technique that averages a number of recent actual values, updated as new values become available. Ft = MAn= At-n + … At-2 + At-1 n Ft = Forecast for time period t MAn= n period moving average

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct ORDERS PER MONTH 120 90 100 75 110 50 75 130 110 90 F 11 =MA 3 90 + 110 + 130 = 3 = 110 orders for Nov

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct Nov ORDERS THREE-MONTH PER MONTH MOVING AVERAGE 120 90 100 75 110 50 75 130 110 90 – – 103. 3 88. 3 95. 0 78. 3 85. 0 105. 0 110. 0

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct Nov ORDERS THREE-MONTH PER MONTH MOVING AVERAGE 120 90 100 75 110 50 75 130 110 90 – – 103. 3 88. 3 95. 0 78. 3 85. 0 105. 0 110. 0 F 11 MA 5 = 90 + 110 + 130 + 75 + 50 5 = 91 orders for Nov

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct

Simple Moving Average MONTH Jan Feb Mar Apr May June July Aug Sept Oct Nov ORDERS THREE-MONTH PER MONTH MOVING AVERAGE 120 90 100 75 110 50 75 130 110 90 – – 103. 3 88. 3 95. 0 78. 3 85. 0 105. 0 110. 0 FIVE-MONTH MOVING AVERAGE – – – 99. 0 85. 0 82. 0 88. 0 95. 0 91. 0

Smoothing Effects 150 – 125 – Orders 100 – 75 – 50 – Actual

Smoothing Effects 150 – 125 – Orders 100 – 75 – 50 – Actual 25 – 0– | Jan | Feb | Mar | | Apr May June July Month | | Aug Sept | Oct | Nov

Smoothing Effects 150 – 125 – Orders 100 – 75 – 3 -month 50

Smoothing Effects 150 – 125 – Orders 100 – 75 – 3 -month 50 – Actual 25 – 0– | Jan | Feb | Mar | | Apr May June July Month | | Aug Sept | Oct | Nov

Smoothing Effects 150 – 5 -month 125 – Orders 100 – 75 – 3

Smoothing Effects 150 – 5 -month 125 – Orders 100 – 75 – 3 -month 50 – Actual 25 – 0– | Jan | Feb | Mar | | Apr May June July Month | | Aug Sept | Oct | Nov

Weighted Moving Average n WMAn = Wi At-i ü Adjusts i=1 moving where average

Weighted Moving Average n WMAn = Wi At-i ü Adjusts i=1 moving where average Wi = the weight for period i, method to between 0 and 100 more closely percent reflect data fluctuations W = 1. 00 i

Weighted Moving Averages • Weighted moving average – More recent values in a series

Weighted Moving Averages • Weighted moving average – More recent values in a series are given more weight in computing the forecast. Ft = WMAn= wn. At-n + … wn-1 At-2 + w 1 At-1 n

Weighted Moving Average Example MONTH August September October WEIGHT DATA 17% 33% 50% 130

Weighted Moving Average Example MONTH August September October WEIGHT DATA 17% 33% 50% 130 110 90 3 November forecast WMA 3 = W i Ai i=1 = (0. 50)(90) + (0. 33)(110) + (0. 17)(130) = 103. 4 orders

Exponential Smoothing Ft = Ft-1 + (At-1 - Ft-1) • Premise--The most recent observations

Exponential Smoothing Ft = Ft-1 + (At-1 - Ft-1) • Premise--The most recent observations might have the highest predictive value. – Therefore, we should give more weight to the more recent time periods when forecasting.

Exponential Smoothing Ft = Ft-1 + (At-1 - Ft-1) • Weighted averaging method based

Exponential Smoothing Ft = Ft-1 + (At-1 - Ft-1) • Weighted averaging method based on previous forecast plus a percentage of the forecast error • A-F is the error term, is the % feedback or a percentage of forecast error Ft =forecast for the next period At -1 =actual demand for the present period Ft -1 =previously determined forecast for the present period α = weighting factor, smoothing constant

Exponential Smoothing Ft = (1 - α) Ft-1 + α At-1

Exponential Smoothing Ft = (1 - α) Ft-1 + α At-1

Exponential Smoothing ü Averaging method ü Weights most recent data more strongly ü Reacts

Exponential Smoothing ü Averaging method ü Weights most recent data more strongly ü Reacts more to recent changes ü Widely used, accurate method

Effect of Smoothing Constant 0. 0 1. 0 If = 0. 20, then Ft

Effect of Smoothing Constant 0. 0 1. 0 If = 0. 20, then Ft +1 = 0. 20 At + 0. 80 Ft If = 0, then Ft +1 = 0 At + 1 Ft 0 = Ft Forecast does not reflect recent data If = 1, then Ft +1 = 1 At + 0 Ft = At Forecast based only on most recent data

Exponential Smoothing. Example 1 PERIOD MONTH DEMAND 1 2 3 4 5 6 7

Exponential Smoothing. Example 1 PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9 10 11 12 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 37 40 41 37 45 50 43 47 56 52 55 54

Exponential Smoothing PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9

Exponential Smoothing PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9 10 11 12 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 37 40 41 37 45 50 43 47 56 52 55 54 F 2 = A 1 + (1 - )F 1 = (0. 30)(37) + (0. 70)(37) = 37 F 3 = A 2 + (1 - )F 2 = (0. 30)(40) + (0. 70)(37) = 37. 9 F 13 = A 12 + (1 - )F 12 = (0. 30)(54) + (0. 70)(50. 84) = 51. 79

Exponential Smoothing PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9

Exponential Smoothing PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9 10 11 12 13 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan 37 40 41 37 45 50 43 47 56 52 55 54 – FORECAST, Ft + 1 ( = 0. 3) – 37. 00 37. 90 38. 83 38. 28 40. 29 43. 20 43. 14 44. 30 47. 81 49. 06 50. 84 51. 79

Exponential Smoothing PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9

Exponential Smoothing PERIOD MONTH DEMAND 1 2 3 4 5 6 7 8 9 10 11 12 13 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan 37 40 41 37 45 50 43 47 56 52 55 54 – FORECAST, Ft + 1 ( = 0. 3) ( = 0. 5) – 37. 00 37. 90 38. 83 38. 28 40. 29 43. 20 43. 14 44. 30 47. 81 49. 06 50. 84 51. 79 – 37. 00 38. 50 39. 75 38. 37 41. 68 45. 84 44. 42 45. 71 50. 85 51. 42 53. 21 53. 61

Exponential Smoothing Forecasts 70 – Actual 60 – Orders 50 – 40 – 30

Exponential Smoothing Forecasts 70 – Actual 60 – Orders 50 – 40 – 30 – 20 – 10 – 0– | 1 | 2 | 3 | 4 | 5 | 6 Month | 7 | 8 | 9 | 10 | 11 | 12 | 13

Exponential Smoothing Forecasts 70 – Actual 60 – Orders 50 – 40 – =

Exponential Smoothing Forecasts 70 – Actual 60 – Orders 50 – 40 – = 0. 30 30 – 20 – 10 – 0– | 1 | 2 | 3 | 4 | 5 | 6 Month | 7 | 8 | 9 | 10 | 11 | 12 | 13

Exponential Smoothing Forecasts 70 – = 0. 50 Actual 60 – Orders 50 –

Exponential Smoothing Forecasts 70 – = 0. 50 Actual 60 – Orders 50 – 40 – = 0. 30 30 – 20 – 10 – 0– | 1 | 2 | 3 | 4 | 5 | 6 Month | 7 | 8 | 9 | 10 | 11 | 12 | 13

Exponential Smoothing-Example 2

Exponential Smoothing-Example 2

Picking a Smoothing Constant Actual . 4 . 1

Picking a Smoothing Constant Actual . 4 . 1

Linear Trend Line y = a + bx where a b x y =

Linear Trend Line y = a + bx where a b x y = intercept (at period 0) = slope of the line = the time period = forecast for demand for period x

Linear Trend Line y = a xy + bx - nxy b = x

Linear Trend Line y = a xy + bx - nxy b = x 2 - nx 2 where a b x y = intercept 0) a = (at y - period bx = slope of the line = where the time period n =for number of periods = forecast demand for period x x x = n = mean of the x values y y = n = mean of the y values

Calculating a and b n (ty) - t y b = 2 2 n

Calculating a and b n (ty) - t y b = 2 2 n t - ( t) y - b t a = n

Linear Trend Calculation Example x(PERIOD) y(DEMAND) 1 2 3 4 5 6 7 8

Linear Trend Calculation Example x(PERIOD) y(DEMAND) 1 2 3 4 5 6 7 8 9 10 11 12 73 40 41 37 45 50 43 47 56 52 55 54 78 557

Linear Trend Calculation Example x(PERIOD) y(DEMAND) xy x 2 1 2 3 4 5

Linear Trend Calculation Example x(PERIOD) y(DEMAND) xy x 2 1 2 3 4 5 6 7 8 9 10 11 12 73 40 41 37 45 50 43 47 56 52 55 54 37 80 123 148 225 300 301 376 504 520 605 648 1 4 9 16 25 36 49 64 81 100 121 144 78 557 3867 650

78 Linear Trend Calculation Example x = = 6. 5 x(PERIOD) y(DEMAND) 1 2

78 Linear Trend Calculation Example x = = 6. 5 x(PERIOD) y(DEMAND) 1 2 3 4 5 6 7 8 9 10 11 12 73 40 41 37 45 50 43 47 56 52 55 54 78 557 12 557 x 2 xyy = = 46. 42 12 37 1 xy 4 - nxy 80 b = x 2 9 - nx 2 123 148 225 300 301 376 a 504 520 605 648 386716 - (12)(6. 5)(46. 42) 25 = 650 - 12(6. 5)2 36 = = 49 1. 7264 y - bx 81 10046. 42 121 35. 2 144 650 (1. 72)(6. 5)

78 Linear Trend Calculation Example x = = 6. 5 x(PERIOD) 1 2 3

78 Linear Trend Calculation Example x = = 6. 5 x(PERIOD) 1 2 3 4 5 6 7 8 9 10 11 12 78 Linear trend line 12 557 x 2 y(DEMAND) xy = = 46. 42 y y= 35. 2 12+ 1. 72 x 73 37 1 xy 4 - nxy 40 80 b = x 2 9 - nx 2 41 123 37 45 50 43 47 56 52 55 54 148 225 300 301 376 a 504 520 605 648 557 386716 - (12)(6. 5)(46. 42) 25 = 650 - 12(6. 5)2 36 = = 49 1. 7264 y - bx 81 10046. 42 121 35. 2 144 650 (1. 72)(6. 5)

78 Least Squares x =Example = 6. 5 12 x(PERIOD) 1 2 3 4

78 Least Squares x =Example = 6. 5 12 x(PERIOD) 1 2 3 4 5 6 7 8 9 10 11 12 78 Linear trend line 557 x 2 y(DEMAND) xy = = 46. 42 y y= 35. 2 12+ 1. 72 x 73 37 1 xy 13 - nxy Forecast for period 40 80 4 b = x 2 9 - nx 2 41 123 y 148 = 35. 2 + 1. 72(13) 37 386716 - (12)(6. 5)(46. 42) 45 225 y = =57. 56 25 units 650 - 12(6. 5)2 50 300 36 43 47 56 52 55 54 301 376 a 504 520 605 648 557 3867 = = 49 1. 7264 y - bx 81 10046. 42 121 35. 2 144 650 (1. 72)(6. 5)

Linear Trend Line 70 – 60 – Demand 50 – 40 – 30 –

Linear Trend Line 70 – 60 – Demand 50 – 40 – 30 – 20 – 10 – 0– | 1 | 2 | 3 | 4 | 5 | | 6 7 Period | 8 | 9 | 10 | 11 | 12 | 13

Linear Trend Line 70 – 60 – Actual Demand 50 – 40 – 30

Linear Trend Line 70 – 60 – Actual Demand 50 – 40 – 30 – 20 – 10 – 0– | 1 | 2 | 3 | 4 | 5 | | 6 7 Period | 8 | 9 | 10 | 11 | 12 | 13

Linear Trend Line 70 – 60 – Actual Demand 50 – 40 – Linear

Linear Trend Line 70 – 60 – Actual Demand 50 – 40 – Linear trend line 30 – 20 – 10 – 0– | 1 | 2 | 3 | 4 | 5 | | 6 7 Period | 8 | 9 | 10 | 11 | 12 | 13

Trend-Adjusted Exponential Smoothing A variation of simple exponential smoothing can be used when a

Trend-Adjusted Exponential Smoothing A variation of simple exponential smoothing can be used when a time series exhibits trend and it is called trend-adjusted exponential smoothing or double smoothing If a series exhibits trend, and simple smoothing is used on it the forecasts will all lag the trend: if the data are increasing, each forecast will be too low; if the data are decreasing, each forecast will be too high.

Trend-Adjusted Exponential Smoothing TAFt+1 = St + Tt Where St = Smoothed forecast Tt

Trend-Adjusted Exponential Smoothing TAFt+1 = St + Tt Where St = Smoothed forecast Tt = Current trend estimate and St =TAFt + α (At – TAFt ) Tt= Tt-1 + β (TAFt – TAFt-1 – Tt-1 ) α and β are smoothing constants

Seasonal Adjustments Repetitive increase/ decrease in demand Models of seasonality: ØAdditive (seasonality is expressed

Seasonal Adjustments Repetitive increase/ decrease in demand Models of seasonality: ØAdditive (seasonality is expressed as a quantity that is added to or subtracted from the series average) ØMultiplicative (seasonality is expressed as a percentage of the average (or trend)amount)

Seasonal Adjustments ü The seasonal percentages in the multiplicative model are referred to as

Seasonal Adjustments ü The seasonal percentages in the multiplicative model are referred to as seasonal relatives or seasonal indexes

Seasonal Adjustments ü Use seasonal factor to adjust forecast Di Seasonal factor = Si

Seasonal Adjustments ü Use seasonal factor to adjust forecast Di Seasonal factor = Si = D

Seasonal Adjustment YEAR 1999 2000 2001 Total DEMAND (1000’S PER QUARTER) 1 2 3

Seasonal Adjustment YEAR 1999 2000 2001 Total DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 12. 6 14. 1 15. 3 42. 0 8. 6 10. 3 10. 6 29. 5 6. 3 7. 5 8. 1 21. 9 17. 5 18. 2 19. 6 55. 3 45. 0 50. 1 53. 6 148. 7

Seasonal Adjustment YEAR 1999 2000 2001 Total DEMAND (1000’S PER QUARTER) 1 2 3

Seasonal Adjustment YEAR 1999 2000 2001 Total DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 12. 6 14. 1 15. 3 42. 0 8. 6 10. 3 10. 6 29. 5 6. 3 7. 5 8. 1 21. 9 17. 5 18. 2 19. 6 55. 3 45. 0 50. 1 53. 6 148. 7 D 1 42. 0 S 1 = = = 0. 28 D 148. 7 D 3 21. 9 S 3 = = = 0. 15 D 148. 7 D 2 29. 5 S 2 = = = 0. 20 D 148. 7 D 4 55. 3 S 4 = = = 0. 37 D 148. 7

Seasonal Adjustment YEAR DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 1999 2000

Seasonal Adjustment YEAR DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 1999 2000 2001 Total 12. 6 14. 1 15. 3 42. 0 8. 6 10. 3 10. 6 29. 5 6. 3 7. 5 8. 1 21. 9 17. 5 18. 2 19. 6 55. 3 Si 0. 28 0. 20 0. 15 0. 37 45. 0 50. 1 53. 6 148. 7

Seasonal Adjustment YEAR DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 1999 2000

Seasonal Adjustment YEAR DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 1999 2000 2001 Total 12. 6 14. 1 15. 3 42. 0 8. 6 10. 3 10. 6 29. 5 6. 3 7. 5 8. 1 21. 9 17. 5 18. 2 19. 6 55. 3 Si 0. 28 0. 20 0. 15 0. 37 45. 0 50. 1 53. 6 148. 7 For 2002 y = 40. 97 + 4. 30 x = 40. 97 + 4. 30(4) = 58. 17

Seasonal Adjustment YEAR DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 1999 2000

Seasonal Adjustment YEAR DEMAND (1000’S PER QUARTER) 1 2 3 4 Total 1999 2000 2001 Total 12. 6 14. 1 15. 3 42. 0 8. 6 10. 3 10. 6 29. 5 6. 3 7. 5 8. 1 21. 9 17. 5 18. 2 19. 6 55. 3 Si 0. 28 0. 20 0. 15 0. 37 45. 0 50. 1 53. 6 148. 7 For 2002 y = 40. 97 + 4. 30 x = 40. 97 + 4. 30(4) = 58. 17 SF 1 = (S 1) (F 5) = (0. 28)(58. 17) = 16. 28 SF 3 = (S 3) (F 5) = (0. 15)(58. 17) = 8. 73 SF 2 = (S 2) (F 5) = (0. 20)(58. 17) = 11. 63 SF 4 = (S 4) (F 5) = (0. 37)(58. 17) = 21. 53

Centered Moving Average Ø A commonly used method for representing the trend portion of

Centered Moving Average Ø A commonly used method for representing the trend portion of a time series involves a centered moving average. Ø By virtue of its centered position it looks forward and looks backward, so it is able to closely follow data movements whether they involve trends, cycles, or random variability alone.

Computing Seasonal Relatives by Using Centered Moving Averages Ø The ratio of demand at

Computing Seasonal Relatives by Using Centered Moving Averages Ø The ratio of demand at period i to the centered average at period i is an estimate of the seasonal relative at that point.

Associative Forecasting Predictor variables - used to predict values of variable interest Regression -

Associative Forecasting Predictor variables - used to predict values of variable interest Regression - technique for fitting a line to a set of points Least squares line - minimizes sum of squared deviations around the line

Causal Modeling with Linear Regression ü Study relationship between two or more variables ü

Causal Modeling with Linear Regression ü Study relationship between two or more variables ü Dependent variable y depends on independent variable x y = a + bx

Linear Model Seems Reasonable Computed relationship A straight line is fitted to a set

Linear Model Seems Reasonable Computed relationship A straight line is fitted to a set of sample points.

Linear Regression Formulas a = y-bx xy - nxy b = x 2 -

Linear Regression Formulas a = y-bx xy - nxy b = x 2 - nx 2 where a = intercept (at period 0) b = slope of the line x x = = mean of the x data n y y = n = mean of the y data

Linear Regression Example x (WINS) y (ATTENDANCE) xy x 2 4 6 6 8

Linear Regression Example x (WINS) y (ATTENDANCE) xy x 2 4 6 6 8 6 7 5 7 36. 3 40. 1 41. 2 53. 0 44. 0 45. 6 39. 0 47. 5 145. 2 240. 6 247. 2 424. 0 264. 0 319. 2 195. 0 332. 5 16 36 36 64 36 49 25 49 49 346. 7 2167. 7 311

Linear Regression Example x (WINS) 4 6 6 8 6 7 5 7 49

Linear Regression Example x (WINS) 4 6 6 8 6 7 5 7 49 49 = 6. 125 8 y (ATTENDANCE) xy x 2 346. 9 y= = 43. 36 8 36. 3 145. 2 16 40. 1 - nxy 2 240. 6 36 xy b = 41. 2 247. 2 36 2 2 x - nx 53. 0 424. 0 64 (2, 167. 7) - (8)(6. 125)(43. 36) 44. 0 264. 0 36 = 2 45. 6(311) - (8)(6. 125) 319. 2 49 39. 0 195. 0 25 = 4. 06 47. 5 332. 5 49 a = y 346. 7 - bx 2167. 7 311 = 43. 36 - (4. 06)(6. 125) = 18. 46 x=

Linear Regression Example x (WINS) 4 6 6 8 6 7 5 7 49

Linear Regression Example x (WINS) 4 6 6 8 6 7 5 7 49 49 = 6. 125 8 y (ATTENDANCE) xy x 2 346. 9 Regression equation y= = 43. 36 8 36. 3 145. 2+ 4. 06 x 16 y = 18. 46 40. 1 - nxy 2 240. 6 36 xy Attendance forecast for 367 wins b = 41. 2 247. 2 2 - nx 2 x y = 18. 46 53. 0 424. 0+ 4. 06(7) 64 (2, 167. 7) - (8)(6. 125)(43. 36) 44. 0 264. 0 or 46, 880 36 = 46. 88, = 2 45. 6(311) - (8)(6. 125) 319. 2 49 39. 0 195. 0 25 = 4. 06 47. 5 332. 5 49 a = y 346. 7 - bx 2167. 7 311 = 43. 36 - (4. 06)(6. 125) = 18. 46 x=

Linear Regression Line 60, 000 – Attendance, y 50, 000 – 40, 000 –

Linear Regression Line 60, 000 – Attendance, y 50, 000 – 40, 000 – 30, 000 – 20, 000 – 10, 000 – | 0 | 1 | 2 | 3 | 4 | | 5 6 Wins, x | 7 | 8 | 9 | 10

Linear Regression Line 60, 000 – Attendance, y 50, 000 – 40, 000 –

Linear Regression Line 60, 000 – Attendance, y 50, 000 – 40, 000 – 30, 000 – Linear regression line, y = 18. 46 + 4. 06 x 20, 000 – 10, 000 – | 0 | 1 | 2 | 3 | 4 | | 5 6 Wins, x | 7 | 8 | 9 | 10

Correlation and Coefficient of Determination ü Correlation, r ü Measure of strength and direction

Correlation and Coefficient of Determination ü Correlation, r ü Measure of strength and direction of relationship between two variables ü Varies between -1. 00 and +1. 00 ü Coefficient of determination, r 2 ü Percentage of variation in dependent variable resulting from changes in the independent variable. Percentage of variability in the values of the dependent variable that is explained by the independent variable.

Computing Correlation r= r= n xy - x y [n x 2 - (

Computing Correlation r= r= n xy - x y [n x 2 - ( x)2] [n y 2 - ( y)2] (8)(2, 167. 7) - (49)(346. 9) [(8)(311) - (49)2] [(8)(15, 224. 7) - (346. 9)2] r = 0. 947 Coefficient of determination r 2 = (0. 947)2 = 0. 897

Multiple Regression Study the relationship of demand to two or more independent variables y

Multiple Regression Study the relationship of demand to two or more independent variables y = 0 + 1 x 1 + 2 x 2 … + kxk where 0 = the intercept 1, … , k = parameters for the independent variables x 1, … , xk = independent variables

Important Points in Using Regression Ø Always plot the data to verify that a

Important Points in Using Regression Ø Always plot the data to verify that a linear relationship is appropriate Ø Check whether the data is timedependent. If so use time series instead of regression Ø A small correlation may imply that other variables are important

Forecast Accuracy ü Error = Actual - Forecast ü Find a method which minimizes

Forecast Accuracy ü Error = Actual - Forecast ü Find a method which minimizes error ü Mean Absolute Deviation (MAD) ü Mean Squared Error (MSE) ü Mean Absolute Percent Deviation (MAPE)

Mean Absolute Deviation (MAD) S At - F t MAD = n where t

Mean Absolute Deviation (MAD) S At - F t MAD = n where t = the period number At = actual demand in period t Ft = the forecast for period t n = the total number of periods = the absolute value

MAD Example PERIOD 1 2 3 4 5 6 7 8 9 10 11

MAD Example PERIOD 1 2 3 4 5 6 7 8 9 10 11 12 DEMAND, At Ft ( =0. 3) 37 40 41 37 45 50 43 47 56 52 55 54 37. 00 37. 90 38. 83 38. 28 40. 29 43. 20 43. 14 44. 30 47. 81 49. 06 50. 84 557

MAD Example PERIOD 1 2 3 4 5 6 7 8 9 10 11

MAD Example PERIOD 1 2 3 4 5 6 7 8 9 10 11 12 DEMAND, At Ft ( =0. 3) (At - Ft) |At - Ft| 37 40 41 37 45 50 43 47 56 52 55 54 37. 00 37. 90 38. 83 38. 28 40. 29 43. 20 43. 14 44. 30 47. 81 49. 06 50. 84 – 3. 00 3. 10 -1. 83 6. 72 9. 69 -0. 20 3. 86 11. 70 4. 19 5. 94 3. 15 – 3. 00 3. 10 1. 83 6. 72 9. 69 0. 20 3. 86 11. 70 4. 19 5. 94 3. 15 49. 31 53. 39 557

MAD Example PERIOD 1 2 3 4 5 6 7 8 9 10 11

MAD Example PERIOD 1 2 3 4 5 6 7 8 9 10 11 12 DEMAND, Dt 37 40 41 37 MAD 45 50 43 47 56 52 55 54 557 = = = Ft ( =0. 3) (Dt - Ft) |Dt - Ft| 37. 00 – 37. 00 3. 00 S 37. 90 At - Ft 3. 10 38. 83 -1. 83 n 38. 28 6. 72 40. 29 9. 69 53. 39 43. 20 -0. 20 11 43. 14 3. 86 44. 30 11. 70 47. 81 4. 19 4. 85 49. 06 5. 94 50. 84 3. 15 – 3. 00 3. 10 1. 83 6. 72 9. 69 0. 20 3. 86 11. 70 4. 19 5. 94 3. 15 49. 31 53. 39

MAD, MSE, and MAPE MSE = ( Actual forecast) 2 n -1 MAPE =

MAD, MSE, and MAPE MSE = ( Actual forecast) 2 n -1 MAPE = ( Actual forecast / Actual*100) n

Example 10

Example 10

Forecast Control ü Reasons for out-of-control forecasts (sources of forecast errors) ü Change in

Forecast Control ü Reasons for out-of-control forecasts (sources of forecast errors) ü Change in trend ü Appearance of cycle ü Inadequate forecasts ü Irregular variations ü Incorrect use of forecasting technique

Controlling the Forecast A forecast is deemed to perform adequately when the errors exhibit

Controlling the Forecast A forecast is deemed to perform adequately when the errors exhibit only random variations • Control chart – A visual tool for monitoring forecast errors – Used to detect non-randomness in errors • Forecasting errors are in control if – All errors are within the control limits – No patterns, such as trends or cycles, are present

Tracking Signal ü Compute each period ü Compare to control limits ü Forecast is

Tracking Signal ü Compute each period ü Compare to control limits ü Forecast is in control if within limits (A t - F t ) E Tracking signal = = MAD Use control limits of +/- 2 to +/- 5 MAD Bias: persistent tendency forecasts to be greater or less than actual values

Tracking Signal Values PERIOD DEMAND Dt FORECAST, Ft 1 2 3 4 5 6

Tracking Signal Values PERIOD DEMAND Dt FORECAST, Ft 1 2 3 4 5 6 7 8 9 10 11 12 37 40 41 37 45 50 43 47 56 52 55 54 37. 00 37. 90 38. 83 38. 28 40. 29 43. 20 43. 14 44. 30 47. 81 49. 06 50. 84 ERROR At - F t – 3. 00 3. 10 -1. 83 6. 72 9. 69 -0. 20 3. 86 11. 70 4. 19 5. 94 3. 15 E = (At - Ft) MAD – 3. 00 6. 10 4. 27 10. 99 20. 68 20. 48 24. 34 36. 04 40. 23 46. 17 49. 32 – 3. 00 3. 05 2. 64 3. 66 4. 87 4. 09 4. 06 5. 01 4. 92 5. 02 4. 85

Tracking Signal Values PERIOD DEMAND At 1 2 3 4 5 6 7 8

Tracking Signal Values PERIOD DEMAND At 1 2 3 4 5 6 7 8 9 10 11 12 37 40 41 37 45 50 43 47 56 52 55 54 FORECAST, Ft ERROR At - F t E = (At - Ft) 37. 00 – – 37. 00 37. 90 3. 10 6. 10 38. 83 -1. 83 4. 27 38. 28 6. 72 for period 10. 99 3 Tracking signal 40. 29 9. 69 20. 68 43. 20 -0. 20 6. 10 20. 48 43. 14 TS 3 = 3. 86 =24. 34 2. 00 3. 05 36. 04 44. 30 11. 70 47. 81 4. 19 40. 23 49. 06 5. 94 46. 17 50. 84 3. 15 49. 32 MAD – 3. 00 3. 05 2. 64 3. 66 4. 87 4. 09 4. 06 5. 01 4. 92 5. 02 4. 85

Tracking Signal Values PERIOD DEMAND At FORECAST, Ft 1 2 3 4 5 6

Tracking Signal Values PERIOD DEMAND At FORECAST, Ft 1 2 3 4 5 6 7 8 9 10 11 12 37 40 41 37 45 50 43 47 56 52 55 54 37. 00 37. 90 38. 83 38. 28 40. 29 43. 20 43. 14 44. 30 47. 81 49. 06 50. 84 ERROR At - F t – 3. 00 3. 10 -1. 83 6. 72 9. 69 -0. 20 3. 86 11. 70 4. 19 5. 94 3. 15 E = (At - Ft) MAD – 3. 00 6. 10 4. 27 10. 99 20. 68 20. 48 24. 34 36. 04 40. 23 46. 17 49. 32 – 3. 00 3. 05 2. 64 3. 66 4. 87 4. 09 4. 06 5. 01 4. 92 5. 02 4. 85 TRACKING SIGNAL – 1. 00 2. 00 1. 62 3. 00 4. 25 5. 01 6. 00 7. 19 8. 18 9. 20 10. 17

Tracking Signal Plot Tracking signal (MAD) 3 – 2 – 1 – 0 –

Tracking Signal Plot Tracking signal (MAD) 3 – 2 – 1 – 0 – -1 – -2 – -3 – | 0 | 1 | 2 | 3 | 4 | 5 | 6 Period | 7 | 8 | 9 | 10 | 11 | 12

Tracking Signal Plot Tracking signal (MAD) 3 – 2 – Exponential smoothing ( =

Tracking Signal Plot Tracking signal (MAD) 3 – 2 – Exponential smoothing ( = 0. 30) 1 – 0 – -1 – -2 – -3 – | 0 | 1 | 2 | 3 | 4 | 5 | 6 Period | 7 | 8 | 9 | 10 | 11 | 12

Tracking Signal Plot Tracking signal (MAD) 3 – 2 – Exponential smoothing ( =

Tracking Signal Plot Tracking signal (MAD) 3 – 2 – Exponential smoothing ( = 0. 30) 1 – 0 – -1 – -2 – Linear trend line -3 – | 0 | 1 | 2 | 3 | 4 | 5 | 6 Period | 7 | 8 | 9 | 10 | 11 | 12

Statistical Control Charts = (A t - F t )2 n-1 ü Using we

Statistical Control Charts = (A t - F t )2 n-1 ü Using we can calculate statistical control limits for the forecast error ü Control limits are typically set at 3

Statistical Control Charts 18. 39 – 12. 24 – Errors 6. 12 – 0–

Statistical Control Charts 18. 39 – 12. 24 – Errors 6. 12 – 0– -6. 12 – -12. 24 – -18. 39 – | 0 | 1 | 2 | 3 | 4 | 5 | 6 Period | 7 | 8 | 9 | 10 | 11 | 12

Statistical Control Charts 18. 39 – UCL = +3 12. 24 – Errors 6.

Statistical Control Charts 18. 39 – UCL = +3 12. 24 – Errors 6. 12 – 0– -6. 12 – -12. 24 – -18. 39 – | 0 LCL = -3 | 1 | 2 | 3 | 4 | 5 | 6 Period | 7 | 8 | 9 | 10 | 11 | 12

Choosing a Forecasting Technique • No single technique works in every situation • Two

Choosing a Forecasting Technique • No single technique works in every situation • Two most important factors – Cost – Accuracy • Other factors include the availability of: – Historical data – Computers – Time needed to gather and analyze the data – Forecast horizon