Forecasting To Accompany Russell and Taylor Operations Management
- Slides: 104
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
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 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 plan the use of the system.
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 Accurate Written y s Ea to e s u
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 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 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 – Based on mathematical formulas
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 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 intervals (eg. Hourly, daily, weekly, monthly, quarterly, annually)
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 Time (c) Seasonal pattern Time (d) Trend with seasonal pattern
Forms of Forecast Movement Irregular variation Trend Cycles 90 89 88 Seasonal variations
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. . 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 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) • 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 smooth fluctuations in a time series.
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 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 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 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 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 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 25 – 0– | Jan | Feb | Mar | | Apr May June July Month | | Aug Sept | Oct | Nov
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 -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 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 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 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 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 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 ü 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 +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 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 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 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 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 – 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 – = 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 – 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
Picking a Smoothing Constant Actual . 4 . 1
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 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 t - ( t) y - b t a = n
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 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 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 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 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 – 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 – 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 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 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 = 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 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 relatives or seasonal indexes
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 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 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 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 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 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 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 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 - 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 ü 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 of sample points.
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 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 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 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 – 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 – 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 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 - ( 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 = 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 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 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 = 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 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 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 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 = ( Actual forecast / Actual*100) n
Example 10
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 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 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 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 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 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 – -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 ( = 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 ( = 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 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– -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. 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 most important factors – Cost – Accuracy • Other factors include the availability of: – Historical data – Computers – Time needed to gather and analyze the data – Forecast horizon
- Russell and taylor operations management
- Operations management chapter 4 forecasting solutions
- What is forecasting in operations management
- Forecasting in operations management ppt
- Demand forecasting operations management
- Forecasting
- Demand forecasting in operations management
- Things that accompany salvation
- Accompany chapter 1
- Median cubital vein
- Inkjet printers are considered legacy technology
- Incremental validity definition
- Russell taylor manufacturing
- Knight taylor brace
- Forecasting and management of technology
- Operations and quality management
- Chapter 12 inventory management
- What is tqm
- Strategic assessment in software project management
- Types of forecasting in front office
- Compare and contrast analog and digital forecasts.
- Compare and contrast analog and digital forecasting
- Contribution of f w taylor
- One best way
- Father of scientific management.
- Mse operations management
- Maintenance function
- Design of goods and services in operations management
- Maintenance and reliability in operations management
- Human resources and job design in operations management
- Logistics management introduction
- Gartner infrastructure and operations summit
- Chapter 7 strategic management
- Strategic management chapter 7
- Implementing strategies: management and operations issues
- Bucket check in hotel
- Product selection in operations management
- Chapter 2 competitiveness strategy and productivity
- Retail management and operations
- Food and beverage operations management
- Location planning in operations management
- Mpr erp
- Transportation systems management and operations
- Product and service design
- Mrp table
- Examples of operation management
- Retail management strategy
- Productivity and competitiveness in operations management
- Productivity and competitiveness in operations management
- Hotel classifications
- Fixed position layout
- Introduction to operations and supply chain management
- Food and beverage service' 9 th edition
- Degree of vertical integration
- Mrp and erp operations management
- Mrp is generally practiced on items with dependent demand.
- Importance of transformation process
- Strategic business unit structure
- Transportation systems management and operations
- Maintenance and reliability in operations management
- Design capacity definition
- Ch 7
- Scsi unit fbi
- James russell odom
- Copleston and russell debate summary
- Russel and norvig
- Russell and atwell guardian
- Russell quarterly economic and market review
- Copleston and russell debate summary
- Russell quarterly economic and market review
- Types of demand forecasting in managerial economics
- Demand estimation and forecasting
- Associative forecasting
- Barometric methods are used to forecast
- Forecasting and demand measurement in marketing
- Demand measurement in marketing
- Collaborative planning forecasting and replenishment ppt
- Financial planning and forecasting
- Financial planning and forecasting
- Strategic planning and forecasting
- Demand measurement in marketing
- Forecasting and demand measurement in marketing
- What is demand forecasting and estimation
- Planning budgeting and forecasting
- Collecting information and forecasting demand
- Short term financial planning process
- Financial planning and forecasting problems with solutions
- Market potential and forecasting
- Difference between prediction and forecasting
- Financial analysis planning and forecasting
- Ninety types of demand measurement
- Exchange rate determination and forecasting
- Conducting marketing research and forecasting demand
- Conducting marketing research and forecasting demand
- Short-term financial management
- Marketing research and forecasting demand
- Demand measurement in marketing
- How to measure productivity in operations management
- Planned capacity
- Practical operations
- Service operations management ppt
- Leading demand with incremental expansion
- Outsourcing operations management
- Ecommerce operation management
- Aoa operations management