Sponsored Links
-->

Sunday, March 4, 2018

Sales Forecasting Definition, Methods, Examples, KPIs
src: 22xmcq37bnw82iclyj35wony-wpengine.netdna-ssl.com

Forecasting is the process of making predictions of the future based on past and present data and most commonly by analysis of trends. A commonplace example might be estimation of some variable of interest at some specified future date. Prediction is a similar, but more general term. Both might refer to formal statistical methods employing time series, cross-sectional or longitudinal data, or alternatively to less formal judgmental methods. Usage can differ between areas of application: for example, in hydrology the terms "forecast" and "forecasting" are sometimes reserved for estimates of values at certain specific future times, while the term "prediction" is used for more general estimates, such as the number of times floods will occur over a long period.

Risk and uncertainty are central to forecasting and prediction; it is generally considered good practice to indicate the degree of uncertainty attaching to forecasts. In any case, the data must be up to date in order for the forecast to be as accurate as possible. In some cases the data used to predict the independent variable is itself forecasted.


Video Forecasting



Categories of forecasting methods

Qualitative vs. quantitative methods

Qualitative forecasting techniques are subjective, based on the opinion and judgment of consumers, experts; they are appropriate when past data are not available. They are usually applied to intermediate- or long-range decisions. Examples of qualitative forecasting methods are informed opinion and judgment, the Delphi method, market research, and historical life-cycle analogy.

Quantitative forecasting models are used to forecast future data as a function of past data. They are appropriate to use when past numerical data is available and when it is reasonable to assume that some of the patterns in the data are expected to continue into the future. These methods are usually applied to short- or intermediate-range decisions. Examples of quantitative forecasting methods are last period demand, simple and weighted N-Period moving averages, simple exponential smoothing, poisson process model based forecasting and multiplicative seasonal indexes. Previous research shows that different methods may lead to different level of forecasting accuarcy. For example, GMDH neural network was found to have better forecasting performance than the classical forecasting algorithms such as Single Exponential Smooth, Double Exponential Smooth, ARIMA and back-propagation neural network.

Average approach

In this approach, the predictions of all future values are equal to the mean of the past data. This approach can be used with any sort of data where past data is available. In time series notation:

y ^ T + h | T = y ¯ = ( y 1 + . . . + y T ) / T {\displaystyle {\hat {y}}_{T+h|T}={\bar {y}}=(y_{1}+...+y_{T})/T}

where y 1 , . . . , y T {\displaystyle y_{1},...,y_{T}} is the past data.

Although the time series notation has been used here, the average approach can also be used for cross-sectional data (when we are predicting unobserved values; values that are not included in the data set). Then, the prediction for unobserved values is the average of the observed values.

Naïve approach

Naïve forecasts are the most cost-effective forecasting model, and provide a benchmark against which more sophisticated models can be compared. This forecasting method is only suitable for time series data. Using the naïve approach, forecasts are produced that are equal to the last observed value. This method works quite well for economic and financial time series, which often have patterns that are difficult to reliably and accurately predict. If the time series is believed to have seasonality, seasonal naïve approach may be more appropriate where the forecasts are equal to the value from last season. The naïve method may also use a drift, which will take the last observation plus the average change from the first observation to the last observation. In time series notation:

y ^ T + h | T = y T {\displaystyle {\hat {y}}_{T+h|T}=y_{T}}

Drift method

A variation on the naïve method is to allow the forecasts to increase or decrease over time, where the amount of change over time (called the drift) is set to be the average change seen in the historical data. So the forecast for time T + h {\displaystyle T+h} is given by

y ^ T + h | T = y T + h T - 1 ? t = 2 T ( y t - y t - 1 ) = y T + h ( y T - y 1 T - 1 ) . {\displaystyle {\hat {y}}_{T+h|T}=y_{T}+{\frac {h}{T-1}}\sum _{t=2}^{T}(y_{t}-y_{t-1})=y_{T}+h\left({\frac {y_{T}-y_{1}}{T-1}}\right).}

This is equivalent to drawing a line between the first and last observation, and extrapolating it into the future.

Seasonal naïve approach

The seasonal naïve method accounts for seasonality by setting each prediction to be equal to the last observed value of the same season. For example, the prediction value for all subsequent months of April will be equal to the previous value observed for April. The forecast for time T + h {\displaystyle T+h} is:

y ^ T + h | T = y T + h - k m {\displaystyle {\hat {y}}_{T+h|T}=y_{T+h-km}} where m {\displaystyle m} =seasonal period and k {\displaystyle k} is the smallest integer greater than ( h - 1 ) / m {\displaystyle (h-1)/m} .

The seasonal naïve method is particularly useful for data that has a very high level of seasonality.

Time series methods

Time series methods use historical data as the basis of estimating future outcomes.

  • Moving average
  • Weighted moving average
  • Kalman filtering
  • Exponential smoothing
  • Autoregressive moving average (ARMA)
  • Autoregressive integrated moving average (ARIMA)
e.g. Box-Jenkins
Seasonal ARIMA or SARIMA or ARIMARCH ,
  • Extrapolation
  • Linear prediction
  • Trend estimation
  • Growth curve (statistics)

Causal / econometric forecasting methods

Some forecasting methods try to identify the underlying factors that might influence the variable that is being forecast. For example, including information about climate patterns might improve the ability of a model to predict umbrella sales. Forecasting models often take account of regular seasonal variations. In addition to climate, such variations can also be due to holidays and customs: for example, one might predict that sales of college football apparel will be higher during the football season than during the off season.

Several informal methods used in causal forecasting do not employ strict algorithms , but instead use the judgment of the forecaster. Some forecasts take account of past relationships between variables: if one variable has, for example, been approximately linearly related to another for a long period of time, it may be appropriate to extrapolate such a relationship into the future, without necessarily understanding the reasons for the relationship.

Causal methods include:

  • Regression analysis includes a large group of methods for predicting future values of a variable using information about other variables. These methods include both parametric (linear or non-linear) and non-parametric techniques.
  • Autoregressive moving average with exogenous inputs (ARMAX)

Quantitative forecasting models are often judged against each other by comparing their in-sample or out-of-sample mean square error, although some researchers have advised against this. Different forecasting approach has different level of accuracy. For example, it was found that GMDH has higher forecasting accuracy than traditional ARIMA

Judgmental methods

Judgmental forecasting methods incorporate intuitive judgement, opinions and subjective probability estimates. Judgmental forecasting is used in cases where there is lack of historical data or during completely new and unique market conditions.

Judgmental methods include:

  • Composite forecasts
  • Cooke's method
  • Delphi method
  • Forecast by analogy
  • Scenario building
  • Statistical surveys
  • Technology forecasting

Artificial intelligence methods

  • Artificial neural networks
  • Group method of data handling
  • Support vector machines

Often these are done today by specialized programs loosely labeled

  • Data mining
  • Machine Learning
  • Pattern Recognition

Other methods

  • Simulation
  • Prediction market
  • Probabilistic forecasting and Ensemble forecasting

Maps Forecasting



Forecasting accuracy

The forecast error (also known as a residual) is the difference between the actual value and the forecast value for the corresponding period.

  E t = Y t - F t {\displaystyle \ E_{t}=Y_{t}-F_{t}}

where E is the forecast error at period t, Y is the actual value at period t, and F is the forecast for period t.

A good forecasting method will yield residuals that are uncorrelated and have zero mean. If there are correlations between residual values, then there is information left in the residuals which should be used in computing forecasts. If the residuals have a mean other than zero, then the forecasts are biased.

Measures of aggregate error:

Business forecasters and practitioners sometimes use different terminology in the industry. They refer to the PMAD as the MAPE, although they compute this as a volume weighted MAPE. For more information see Calculating demand forecast accuracy.

When comparing the accuracy of different forecasting methods on a specific data set, the measures of aggregate error are compared with each other and the method that yields the lowest error is preferred.

Training and test sets

It is important to evaluate forecast accuracy using genuine forecasts. That is, it is invalid to look at how well a model fits the historical data; the accuracy of forecasts can only be determined by considering how well a model performs on new data that were not used when fitting the model. When choosing models, it is common to use a portion of the available data for fitting, and use the rest of the data for testing the model, as was done in the above examples.

Cross Validation

A more sophisticated version of training/test set.

for cross sectional data, cross-validation works as follows:

  1. Select observation i for the test set, and use the remaining observations in the training set. Compute the error on the test observation.
  2. Repeat the above step for i = 1,2,..., N where N is the total number of observations.
  3. Compute the forecast accuracy measures based on the errors obtained.

This is a much more efficient use of the available data, as you only omit one observation at each step

for time series data, the training set can only include observations prior to the test set. therefore no future observations can be used in constructing the forecast. Suppose k observations are needed to produce a reliable forecast then the process works as:

  1. Select the observation k + i for test set, and use the observations at times 1, 2, ..., k+i-1 to estimate the forecasting model. Compute the error on the forecast for k+i.
  2. Repeat the above step for i = 1,2,...,T-k where T is the total number of observations.
  3. Compute the forecast accuracy over all errors

This procedure is sometimes known as a "rolling forecasting origin" because the "origin" (k+i -1) at which the forecast is based rolls forward in time

Limitations of Errors

The two most popular measures of accuracy that incorporate the forecast error are the Mean Absolute Error (MAE) and the Root Mean Squared Error (RMSE). Thus these measures are considered to be scale-dependent, that is, they are on the same scale as the original data. Consequently, these cannot be used to compare models of differing scales.

Percentage errors are simply forecast errors converted into percentages and are given by P t = 100 E t / Y t {\displaystyle P_{t}=100E_{t}/Y_{t}} . A common accuracy measure that utilizes this is the Mean Absolute Percentage Error (MAPE). This allows for comparison between data on different scales. However, percentage errors are not quite meaningful when Y t {\displaystyle Y_{t}} is close to or equal to zero, which results in extreme values or simply being undefined. Scaled errors are a helpful alternative to percentage errors when comparing between different scales. They do not have the shortfall of giving unhelpful values if Y t {\displaystyle Y_{t}} is close to or equal to zero.

See also

  • Calculating demand forecast accuracy
  • Consensus forecasts
  • Forecast error
  • Predictability
  • Prediction intervals, similar to confidence intervals
  • Reference class forecasting

The Importance of Business Forecasting | RMP Capital
src: rmpcapital.com


Seasonality and cyclic behaviour

Seasonality

Seasonality is a characteristic of a time series in which the data experiences regular and predictable changes which recur every calendar year. Any predictable change or pattern in a time series that recurs or repeats over a one-year period can be said to be seasonal. It is common in many situations - such as grocery store or even in a Medical Examiner's office--that the demand depends on the day of the week. In such situations, the forecasting procedure calculates the seasonal index of the "season" - seven seasons, one for each day - which is the ratio of the average demand of that season (which is calculated by Moving Average or Exponential Smoothing using historical data corresponding only to that season) to the average demand across all seasons. An index higher than 1 indicates that demand is higher than average; an index less than 1 indicates that the demand is less than the average.

Cyclic behaviour

The cyclic behaviour of data takes place when there are regular fluctuations in the data which usually last for an interval of at least two years, and when the length of the current cycle cannot be predetermined. Cyclic behavior is not to be confused with seasonal behavior. Seasonal fluctuations follow a consistent pattern each year so the period is always known. As an example, during the Christmas period, inventories of stores tend to increase in order to prepare for Christmas shoppers. As an example of cyclic behaviour, the population of a particular natural ecosystem will exhibit cyclic behaviour when the population increases as its natural food source decreases, and once the population is low, the food source will recover and the population will start to increase again. Cyclic data cannot be accounted for using ordinary seasonal adjustment since it is not of fixed period.


Webinar - Forecasting and Territory Management within Salesforce ...
src: i.ytimg.com


Applications

Forecasting has applications in a wide range of fields where estimates of future conditions are useful. Not everything can be forecasted reliably, if the factors that relate to what is being forecast are known and well understood and there is a significant amount of data that can be used very reliable forecasts can often be obtained. If this is not the case or if the actual outcome is effected by the forecasts, the reliability of the forecasts can be significantly lower.

Climate change and increasing energy prices have led to the use of Egain Forecasting for buildings. This attempts to reduce the energy needed to heat the building, thus reducing the emission of greenhouse gases. Forecasting is used in Customer Demand Planning in everyday business for manufacturing and distribution companies.

While the veracity of predictions for actual stock returns are disputed through reference to the Efficient-market hypothesis, forecasting of broad economic trends is common. Such analysis is provided by both non-profit groups as well as by for-profit private institutions (including brokerage houses and consulting companies).

Forecasting foreign exchange movements is typically achieved through a combination of chart and fundamental analysis. An essential difference between chart analysis and fundamental economic analysis is that chartists study only the price action of a market, whereas fundamentalists attempt to look to the reasons behind the action. Financial institutions assimilate the evidence provided by their fundamental and chartist researchers into one note to provide a final projection on the currency in question.

Forecasting has also been used to predict the development of conflict situations. Forecasters perform research that uses empirical results to gauge the effectiveness of certain forecasting models. However research has shown that there is little difference between the accuracy of the forecasts of experts knowledgeable in the conflict situation and those by individuals who knew much less.

Similarly, experts in some studies argue that role thinking does not contribute to the accuracy of the forecast. The discipline of demand planning, also sometimes referred to as supply chain forecasting, embraces both statistical forecasting and a consensus process. An important, albeit often ignored aspect of forecasting, is the relationship it holds with planning. Forecasting can be described as predicting what the future will look like, whereas planning predicts what the future should look like. There is no single right forecasting method to use. Selection of a method should be based on your objectives and your conditions (data etc.). A good place to find a method, is by visiting a selection tree. An example of a selection tree can be found here. Forecasting has application in many situations:

  • Supply chain management - Forecasting can be used in supply chain management to ensure that the right product is at the right place at the right time. Accurate forecasting will help retailers reduce excess inventory and thus increase profit margin. Studies have shown that extrapolations are the least accurate, while company earnings forecasts are the most reliable. Accurate forecasting will also help them meet consumer demand.
  • Economic forecasting
  • Earthquake prediction
  • Egain forecasting
  • Finance against risk of default via credit ratings and credit scores
  • Land use forecasting
  • Player and team performance in sports
  • Political forecasting
  • Product forecasting
  • Sales forecasting
  • Technology forecasting
  • Telecommunications forecasting
  • Transport planning and Transportation forecasting
  • Weather forecasting, Flood forecasting and Meteorology

Forecasting and Planning Software - Neural Computing - S&OP
src: www.demandforesight.com


Limitations

Limitations pose barriers beyond which forecasting methods cannot reliably predict. There are many events and values that cannot be forecast reliably. Events such as the roll of a die or the results of the lottery cannot be forecast because they are random events and there is no significant relationship in the data. When the factors that lead to what is being forecast are not known or well understood such as in stock and foreign exchange markets forecasts are often inaccurate or wrong as there is not enough data about everything that affects these markets for the forecasts to be reliable, in addition the outcomes of the forecasts of these markets change the behavior of those involved in the market further reducing forecast accuracy.

Performance limits of fluid dynamics equations

As proposed by Edward Lorenz in 1963, long range weather forecasts, those made at a range of two weeks or more, are impossible to definitively predict the state of the atmosphere, owing to the chaotic nature of the fluid dynamics equations involved. Extremely small errors in the initial input, such as temperatures and winds, within numerical models double every five days.


Forecasting - YouTube
src: i.ytimg.com


See also


Loss Forecasting & Programme Design - Alesco Risk Management Services
src: www.alescorms.com


References

  • Armstrong, J. Scott, ed. (2001). Principles of Forecasting: A Handbook for Researchers and Practitioners. Norwell, Massachusetts: Kluwer Academic Publishers. ISBN 0-7923-7930-6. 
  • Ellis, Kimberly (2010). Production Planning and Inventory Control. McGraw-Hill. ISBN 0-412-03471-9. 
  • Geisser, Seymour (June 1993). Predictive Inference: An Introduction. Chapman & Hall, CRC Press. ISBN 0-390-87106-0. 
  • Gilchrist, Warren (1976). Statistical Forecasting. London: John Wiley & Sons. ISBN 0-471-99403-0. 
  • Hyndman, Rob J.; Koehler, Anne B. (October-December 2006). "Another look at measures of forecast accuracy" (PDF). International Journal of Forecasting. 22 (4): 679-688. doi:10.1016/j.ijforecast.2006.03.001. 
  • Makridakis, Spyros; Wheelwrigt, Steven; Hyndman, Rob J. (1998). Forecasting: Methods and Applications. John Wiley & Sons. ISBN 0-471-53233-9. 
  • Malakooti, Behnam (February 2014). Operations and Production Systems with Multiple Objectives. John Wiley & Sons. ISBN 978-0-470-03732-4. 
  • Kaligasidis, Angela Sasic; Taesler, Roger; Andersson, Cari; Nord, Margitta (August 2006). "Upgraded weather forecast control of building heating systems". In Fazio, Paul. Research in Building Physics and Building Engineering. Taylor & Francis, CRC Press. pp. 951-958. ISBN 0-415-41675-2. 
  • Kress, George J.; Snyder, John (May 1994). Forecasting and Market Analysis Techniques: A Practical Approach. Quorum Books. ISBN 0-89930-835-X. 
  • Rescher, Nicholas (1998). Predicting the Future: An Introduction to the Theory of Forecasting. State University of New York Press. ISBN 0-7914-3553-9. 
  • Taesler, Roger (1991). "Climate and Building Energy Management". Energy and Buildings. 15 (1-2): 599-608. doi:10.1016/0378-7788(91)90028-2. 
  • Turchin, Peter (2007). "Scientific Prediction in Historical Sociology: Ibn Khaldun meets Al Saud". History & Mathematics: Historical Dynamics and Development of Complex Societies. Moscow: KomKniga. pp. 9-38. ISBN 978-5-484-01002-8. 
  • US patent 6098893, Berglund, Ulf Stefan & Lundberg, Bjorn Henry, "Comfort control system incorporating weather forecast data and a method for operating such a system", issued August 8, 2000 .

Trend Forecasting: How Does It Really Work? | Highsnobiety
src: static.highsnobiety.com


External links

  • Forecasting Principles: "Evidence-based forecasting"
  • International Institute of Forecasters
  • Introduction to Time series Analysis (Engineering Statistics Handbook) - A practical guide to Time series analysis and forecasting
  • Time Series Analysis
  • Global Forecasting with IFs
  • Earthquake Electromagnetic Precursor Research
  • Forecasting Science and Theory of Forecasting

Source of article : Wikipedia