Forecasting Methods

vaibhavagarwal75436 25,974 views 40 slides May 30, 2018
Slide 1
Slide 1 of 40
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17
Slide 18
18
Slide 19
19
Slide 20
20
Slide 21
21
Slide 22
22
Slide 23
23
Slide 24
24
Slide 25
25
Slide 26
26
Slide 27
27
Slide 28
28
Slide 29
29
Slide 30
30
Slide 31
31
Slide 32
32
Slide 33
33
Slide 34
34
Slide 35
35
Slide 36
36
Slide 37
37
Slide 38
38
Slide 39
39
Slide 40
40

About This Presentation

Forecasting methods, concept, introduction, types, qualititaive, quantitattive


Slide Content

OPERATIONS MANAGEMENT
By-:
Er. Vaibhav Agarwal
Asst. Prof.
SOM, BBDU
Lucknow
FORECASTING

Forecasting Demand
•Forecasts are estimates of the occurrence, timing, or magnitude of uncertain future events.
•Forecasts are essential for the smooth operations of business organizations.
•They provide information that can assist managers in guiding future activities toward organizational goals.
•Managers also use forecasts to estimate raw material prices, plan for appropriate levels of personnel, help decide
how much inventory to carry, and a host of other activities.
•This results in better use of capacity, more responsive service to customers, and improved profitability.
•Types of Forecasting:
•Short Term Forecasting
•Long Term Forecasting
•Short Term forecasting is the forecasting that made for short term objectives covering less than one
year. Ex. Material Requirement Planning (MRP), scheduling, sequencing, budgeting etc.
•Long Term Forecasting is the forecasting that made for that made for long term objectives covering
more than five years. Ex. Product diversification, sales and advertisement.

Elements of Forecasting:
•Forecasting consists basically of analysis of the following elements.
•Internal factors
•External factors
•Controllable
•Non-Controllable (Organizing with national economy, governments, customers
and Competitors)

Forecasting methods
There are numerous methods to forecasting depending on the need of the decision-maker. These
can be categorized in two ways:
1. Opinion and Judgmental Methods or Qualitative Methods.
2. Time Series or Quantitative Forecasting Methods.

Forecasting Approaches
•Quantitative Forecasts uses one or more mathematical models that rely on historical data
and/or causal variable to forecast demand.
•Qualitative Forecasts uses such factors like decision makers intuition, emotions, personal
experiences, and value system.

QUALITATIVE Forecasting Approaches
•JURYOFEXECUTIVEOPINION:Theopinionsofagroupofhigh-levelexpertsormanagers,oftenin
combinationwithstatisticalmodels,arepooledtoarriveatanestimateofdemand.
•DELPHIMETHOD:Threedifferentkindsofparticipantsareincluded:
•Decisionmakers,
•Staffpersonnel
•Respondents
•Decisionmakersconsistsofagroupof5to10expertswhowillbemakingtheactual
forecast.
•Staffpersonnelassistdecisionmakersbypreparing,distributingcollectingandsummarizing
aseriesofquestionnairesandsurveyresults.
•Therespondentsareagroupofpeople,oftenlocatedindifferentplaces,whosejudgmentsare
valued.Theyprovideinputstothedecisionmakersbeforetheforecastismade.

QUALITATIVE Forecasting Approaches
•CONSUMER MARKETSURVEY:Thismethodusesinputfromcustomersor
potentialcustomersregardingfuturepurchasingplans.Itcanhelpnotonlyin
preparingaforecastbutalsoinimprovingproductdesignandplanningfornew
products.
•SALESFORCECOMPOSITE:Eachsalespersonestimateswhatsaleswillbeinhis
orherregion.Theforecastsarethenreviewedtoensurethattheyarerealistic.Then
theyarecombinedatdistrictandnationallevelstoreachanoverallforecast.

QUANTITATIVE Forecasting Approaches
Thevariousforecastingmethodsareforquantitativedataforecasting:
1.NaiveApproach
2.MovingAverages
3.ExponentialSmoothing
4.TrendProjection
5.LinearRegression
TIME SERIES MODELS
ASSOCIATIVE MODEL

QUANTITATIVE Forecasting Approaches
TIMESERIESMODELS:
•Atimeseriesisasetofobservationsofavariableatregularintervalsovertime.Indecompositionanalysis,thecomponentsofatime
seriesaregenerallyclassifiedastrendT,cyclicalC,seasonalS,andrandomorirregularR.
•Timeseriesaretabulatedorgraphedtoshowthenatureofthetimedependence.Theforecastvalue(Ye)iscommonlyexpressedasa
multiplicativeoradditivefunctionofitscomponents;examplesherewillbebaseduponthecommonlyusedmultiplicativemodel.
•Y
C
=T.S.C.R multiplicativemodel
•Y
C=T+S+C+R additivemodel
•WhereTisTrend,SisSeasonal,CisCyclical,andRisRandomcomponentsofaseries.
•Trendisagraduallong-termdirectionalmovementinthedata(growthordecline).
•Seasonaleffectsaresimilarvariationsoccurringduringcorrespondingperiods,e.g.,Decemberretailsales.Seasonalcanbequarterly,
monthly,weekly,daily,orevenhourlyindexes.
•Cyclicalfactorsarethelong-termswingsaboutthetrendline.Theyareoftenassociatedwithbusinesscyclesandmayextendoutto
severalyearsinlength.
•Randomcomponentaresporadic(unpredictable)effectsduetochanceandunusualoccurrences.Theyaretheresidualafterthetrend,
cyclical,andseasonalvariationsareremoved.

Components of a Time Series
•A time seriescan consist of five components.
•Horizontal or Stationary –Fluctuations around a
constant mean.
•Long -term trend (T).
•Cyclical effect (C).
•Seasonal effect (S).
•Random variation (R).
A trend is a long term relatively
smooth pattern or direction, that
persists usually for more than one year.
Quantity
Time

Acycle is a wavelike pattern describing
a long term behavior (for more than one
year).
Cycles are seldom regular, and often appear in
combination with other components.
6/90 6/93 6/96 6/99 6/02
6/97 12/97 6/98 12/98 6/99
The seasonal componentof the time series exhibits
a short term (less than one year) calendar repetitive
behavior.

Random variationcomprises the irregular unpredictable changes in
the time series.
It tends to hide the other (more predictable)
components.
Random or Irregular Variation –classifiedinto:

Episodic –unpredictable but identifiable

Residual –also called chance fluctuation and
unidentifiable

TIME-SERIES FORECASTING
•Associative Models: Models like linear regression, incorporate the variables or factors that might influence the
quantity being forecast. E.g. Advertising budget, competitors price etc.
•A time series is based on a sequence of evenly spaced (weekly, monthly, quarterly, an so on) data points.
•E.g. including weekly sales of Nike Air Jordans, quarterly earning reports of Microsoft stocks etc.
•Forecasting time-series data implies that future values are predicted only from pat values and that other variables.

TIME-SERIES FORECASTING
Naive Approach:
•It is simplest way to forecast.
•It is a technique that assumes demand in the next period is equal to demand in the most recent period.

TIME-SERIES FORECASTING
Moving Averages:
•It is a method which uses a number of historical data values to generate a forecast.
•Moving averages are useful if we assume that market demands are fairly steady over time.
•Mathematically:
•Moving Average =
??????��??????��??????�����??????�������??????���
�
•here n = no. of periods in moving average. E.g. 4 or 5 or 6 month moving average.
•Weighted Moving Averages =
(??????�??????�ℎ������??????���)(??????��??????��??????����??????���)
??????�??????�ℎ��
•Both weighted and simple moving averages are used to smoothen out sudden fluctuations in the demand pattern
to provide stable estimates.

Moving average method
•A quantitative method of forecasting or smoothing a
time series by averaging each successive group (no. of
observations) of data values.
•term MOVINGis used because it is obtained by summing
and averaging the values from a given no of periods,
each time deleting the oldest value and adding a new
value.

•For applying the method of moving averages the period of moving
averages has to be selected
•This period can be 3-yearly moving averages 5yr moving averages 4yr
moving averages etc.
•For ex:-3-yearly moving averages can be calculated from the data : a,
b, c, d, e, f can be computed as :

•If the moving average is an odd no of values e.g., 3
years, there is no problem of centring it. Because the
moving total for 3 years average will be centred besides
the 2nd year and for 5 years average be centred besides
3rd year.
•But if the moving average is an even no, e.g., 4 years
moving average, then the average of 1st 4 figures will
be placed between 2nd and 3rd year.
•This process is called centeringof the averages. In case
of even period of moving averages, the trend values
are obtained after centeringthe averages a second
time.

Goals : –
•Smooth out the short-term fluctuations.
•Identify the long-term trend.

MERITS Of Moving average method
•simple method.
•flexible method.
OBJECTIVE :-
•If the period of moving averages coincides with the period
of cyclic fluctuations in the data , such fluctuations are
automatically eliminated
•This method is used for determining seasonal, cyclic and
irregular variations beside the trend values.

LIMITATIONS OF MOVING AVERAGE METHOD
•No trend values for some year.
•M.A is not represented by mathematical function -not helpful in
forecasting and predicting.
•The selection of the period of moving average is a difficult task.
•In case of non-linear trend the values obtained by this method are
biased in one or the other direction.

Moving Average Example
YearUnitsMoving
1994 2
1995 5 3
1996 2 3
1997 2 3.67
1998 7 5
1999 6
John is a building contractor with a record of a total
of 24 single family homes constructed over a 6-year
period. Provide John with a 3-year moving average
graph.
Avg.

year Sales,(millions of
rupees)
3-yearly totals 3-yearly moving
averages(trends)
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
3
4
8
6
7
1 1
9
1 0
1 4
1 2
1 5
1 8
2 1
2 4
2 7
3 0
3 3
3 6
5=(15/3)
6=(18/3)
7=(21/3)
8=(24/3)
9=(27/3)
1 0=(30/3)
1 1=(33/3)
1 2=(36/3)

In Figure, 3-yrs MA plotted on graph fall on a straight line, and the cyclic
f luctuation have been smoothed out. The straight Line is the required trend
line.
1980198119821983198419851986198719881989
1
2
3
years
sales
4
6
8
10
12
Actual line

TIME-SERIES FORECASTING
Exponential Smoothing:
•It is more advanced method than moving average.
•It uses a very little record of past data
•New Forecast = last period forecast + α(last period’s actual demand –last period’s forecast)
•αis the smoothing constant. It has values between 0 and 1.
•F
t= F
t-1+ α(A
t-1–F
t-1)
•Where F
t=New Forecast
F
t-1= previous period forecast
α= smoothing constant ( 0 ≤ α≤ 1)
A
t-1= previous period’s actual demand

Q1. The unloading of large quantities of grains from the ship is under record by the port operation manager. He wants to
test the use of exponential smoothing to see how well the technique works in predicting tonnage unloaded. He guesses that
the forecast of grain unloaded in the first quarter was 175 tons. Two values of αare to be examined : α= 0.10 and α= 0.50.
QUARTER ACTUAL TONNAGE
UNLOADED
FORECAST WITH α= 0.10 FORECAST
WITH α= 0.50
1 180 175 175.00
2 168 175.00 +0.10(180-175.00 )= 175.50 177.50
3 159 175.50+ 0.10(168-175.50) = 174.75 172.75
4 175 174.75 + 0.10(159-174.75) = 173.18 165.88
5 190 173.18 + 0.10(175-173.18) = 173.36 170.44
6 205 173.36 + 0.10(190-173.36) = 175.02 180.22
7 180 175.02 + 0.10(205-175.02)= 178.02 192.61
8 182 178.02 + 0.10(180-178.02) = 178.22 186.30
9 ? 178.22+ 0.10(182-178.22) = 178.59 184.15

QUA
RTER
ACTUAL
TONNAGE
UNLOADED
FORECAST
WITH α=
0.10
ABSOLUTE
DEVIATION FOR
α= 0.10
FORECASTWITH α=
0.50
ABSOLUTE DEVIATION
FOR α= 0.50
1 180 175 5.00 175.00 5.00
2 168 175.50 7.50 177.50 9.50
3 159 174.75 15.75 172.75 13.75
4 175 173.18 1.82 165.88 9.12
5 190 173.36 16.64 170.44 19.56
6 205 175.02 29.98 180.22 24.78
7 180 178.02 1.98 192.61 12.61
8 182 178.22 3.78 186.30 4.30
TOTAL = 82.45 TOTAL = 98.62
MAD =
���????????????�??????���
�
= 10.31 12.33

TIME-SERIES FORECASTING
Mean Squared Error: The mean squared error (MSE) is the average of the
second differences between the forecasted and observed values
MEAN ABSOLUTE DEVIATION: The first measure of the overall forecast error for a model is the mean
absolute deviation (MAD).
MAE =
���??????����������
2
�

TIME-SERIES FORECASTING
Measuring the forecasting Error:
•Comparing forecasted values with the actual or observed values.
•It uses a very little record of past data
•Forecast Error = Actual Demand –Forecast Values
•F
e= A
t-F
t
•Where F
t= Forecast demand for period t
A
t= Actual Demand
MEAN ABSOLUTE DEVIATION: The first measure of the overall forecast error for a model is the mean
absolute deviation (MAD).
MAD =
??????���????????????−�����??????��
�

EXPONENTIAL SMOOTHING WITH TREND ANALYSIS
•Exponential Smoothing is also used with trend adjustments.
•Compute the exponentially smoothened average of data and then adjust for positive or negative lag in
trend.
•Forecast including trend (FIT
t) = Exponentially smoothed forecast (F
t) + Exponentially smoothed
trend (T
t)
F
t= α(A
t-1) + (1-α) (F
t-1+T
t-1)
F
t = α(Actual Demand Last Period) + (1-α)(Forecast last period +Trend estimate last period)
Or
T
t= β(F
t–F
t-1) + (1-β)T
t-1
Tt= β(Forecast this period –Forecast last Period) + (1-β) (Trend estimate last Period)
•F
t= exponentially smoothed forecast of the data series in the period t.
•T
t= exponentially smoothed trend in the period.
•A
t= Actual demand in the period t
•α = Smoothing constant for the average (0≤α ≤1)
•β= smoothing constant for the trend (0≤ β≤1)

TREND PROJECTIONS
•This technique fits a trend line to a series of historical data points and then projects the line into the future for medium to
long-range forecasts.
•A least square method is used to develop a trend line.
•It has a y-intercept and a slope.
•It can be expressed in a equation
• �= a +bx
•Where �= computed value of the variable to be predicted (called the dependent variable)
•a = y-axis intercept.
•b = slope of the regression line (or the rate of change in y for given changes in x)
•x = the independent variable (which in this case is time).
•Now we have to calculate the value of ‘a’ and ‘b’ constants.
•b =
��−� � �
�
??????
−� �
??????
•a = �−� �

ASSOCIATIVE FORECASTING METHODS:
REGRESSION ANALYSIS
•Regression model considers the several variables that are related to the quantity being predicted.
•It consists of a dependent variable and an independent variable.
•It may express the relation between sales volume and revenue generated.
•A least square method is used to develop a trend line.
•It has a y-intercept and a slope.
•It can be expressed in a equation
• �= a +bx
•Where �= computed value of the variable to be predicted (called the dependent variable)
•a = y-axis intercept.
•b = slope of the regression line (or the rate of change in y for given changes in x)
•x = the independent variable (which in this case is time).
•Now we have to calculate the value of ‘a’ and ‘b’ constants.
•b =
��−� � �
�
??????
−� �
??????
•a = �−� �

Note:
1.Solve the numerical questions on the topic of Exponential Smoothing,
Moving Averages, Trend Projection and Regression analysis from the text
book.
2.This topic is numerical based topic and numerical portion is very very
important. So practice well for the numerical portion.

THANKYOU
References:
1.Kumar, S. Anil; Suresh, N., ‘Operations Management’, New Age International Publishers, 2e.
2.Heizer, Jay; Render, Barry; Rajashekhar, Jagadeesh, ‘Operations Management’, Pearson, 9e.
3.Chary, S N, ‘Production & Operations Management’, McGraw-Hill Companies, 4e.
4.Ashwathappa, K.; Bhat, K. Shridhara, ‘Productions and Operations Management’, Himalaya
Publishing House, 2e.