CH 4
CH 4
CH 4
CHAPTER FOUR
DEMAND AND DEMAND FORECASTING
E-mail: [email protected]
1 AAU , 2024
4.1. Introduction
2
Unless and until knowing the demand for a product how can we
think of producing that product.
Therefore, demand analysis is something which is necessary for
the production function to happen.
Demand analysis helps in analyzing the various types of demand
which enables the manager to arrive at reasonable estimates of
demand for product of his company.
Managers not only assess the current demand but he has to take
into account the future demand also.
4.3. Demand Forecasting
4
method.
Cont…..
6
ILLUSTRATION:
Suppose a manufacturer of transistors in Addis Ababa decides to
forecast the sales of his products during the next year by trend
projection method. He collects data on his sales for the past five
years as follows;
Cont…
Year
= = ,
1989 50 1 -12 -2 24 4 and
1990 60 2 -2 -1 2 1
= =
1991 55 3 -7 0 0 0
1992 70 4 8 1 8 1
1993 75 5 13 2 26 4
Sum 310 15 0 0 60 10
∑( − )( − ) ∑
= == = =
∑( − ) ∑
= − ∴ = − ( )=
Therefore, the fitted regression equation (i.e., OLS regression line) is:
= +
By: Teklebirhan A. 13
Cont…..
14
Using the equation, we can find out trend values for the previous
years and estimate the sales for 1994.
Y 1989 = 44 + 6 x (1) = 44 + 6 = 50
Y 1990 = 44 + 6 x (2) = 44 +12 = 56
Y 1991 = 44 + 6 x (3) = 44 + 18 =62
Y 1992 = 44 + 6 x (4) = 44 + 24 = 68
Y 1993 = 44 + 6 x (5) = 44 + 30 = 74
Y 1994 = 44 + 6 x (6) = 44 + 36 = 80
Thus, forecast sales for 1994 would be 80 thousand based on trend
projection equation.
B) Averaging Methods
15
Simple average =
Example: Demand of an item in a firm has been 180, 160, 170 and
190 items in each of the last four quarters. Forecast the demand of
this item for the current quarter based on simple average method?
Solution: Forecast for current quarter based on simple average
would be;
700
= =
4
Cont…..
17
‘ ’
S =
Solution:
A three-month weighted moving average forecast for July;
= ( ) + ( ) + ( )
= (0.5 500) + (0.3 450) + (0.2 400)
= 250 + 135 + 80
=
C) Exponential Smoothing
22
The forecast can be based on the old calculated forecast and the
new data.
The weight given to latest actual demand is called a smoothing
constant and is represented by the Greek letter alpha (α).
It is always expressed as a decimal from 0 to 1.
In general, the formula for calculating the new forecast is:
= ( )( ) + ( − )( )
Cont…..
23
Example: The old forecast for May was 220, and the actual
demand for May was 190. If alpha is 0.15, calculate the forecast for
June. If June demand turns out to be 218, calculate the forecast for
July.
Solutions:
= ( . )( ) + ( − . )( ) = .
= ( . )( ) + ( . )( . ) = .
Cont…..
24
As an alternate formula you can use the previous forecast plus a
percentage of the difference between that forecast and the actual
value of the series at that point.
Cont…..
25