Lecture 7-9
Lecture 7-9
Lecture 7-9
Forecasting
• Can the demand prediction of one set of products be better than others?
What all may go wrong … if we use the same method for all of
them
Certain Characteristics of Forecast
• Forecasts are always inaccurate and should thus include both the
expected value of the forecast and the measure of forecast error
• Long term forecasts are less accurate than short term forecasts
• Companies must identify the factors that influence future demand and then
ascertain the relationship between these factors and future demand
• Past demand (and not past sales)
• Lead time of product replenishment
• Planned advertising or marketing efforts
• Planned price discounts
• State of the economy
• Actions that competitors have taken
3. Causal 4. Simulation
• Relationship between • Imitate consumer
demand and some choices that give rise to
other factor demand
Lets have a look at some data patterns…
Or Dissimilarity
1. Trend: This refers to the general long-term direction of the data, indicating whether it's
consistently increasing, decreasing, or remaining stable. Imagine a sales chart rising
steadily over several years - that's an upward trend.
2. Seasonal: These patterns occur repeatedly within a specific timeframe, often tied to
natural cycles or human behavior. For example, ice cream sales typically soar in
summer and dip in winter, exhibiting a seasonal pattern.
3. Cyclic: Similar to seasonal patterns, cyclic patterns repeat over time, but their
timeframes are typically longer and less predictable. Economic recessions, for instance,
might follow a cyclical pattern, but their exact timing can be difficult to pinpoint.
Lets have a look at some data patterns…
A static method assumes that the estimate of level, trend, and seasonality within the
systematic component do not vary as a new demand is observed.
Forecast
Model Description
Naïve Uses last period’s actual value as a forecast
Trend Projection
Seasonal Indexes
Moving Average
(Dt + Dt -1 + … + Dt – N +1 )
Lt =
N
Ft +1 = Lt and Ft + n = Lt
(Dt +1 + Dt + … + Dt -N + 2 )
Lt +1 = , Ft + 2 = Lt +1
N
Naïve
Naïve Method
Method
Moving Average
Example
(SIMPLE AVERAGE) METHOD
SIMPLE MOVING AVERAGE METHOD
WEIGHTED MOVING AVERAGE METHOD
EXPONENTIAL SMOOTHING METHOD
An attractive feature of this method is that forecasts made with this model will include a portion of every piece of historical
demand. Furthermore, there will be different weights placed on these historical demand values, with older data receiving
lower weights. At first glance this may not be obvious, however, this property is illustrated on the following page.
EXPONENTIAL SMOOTHING METHOD
EXPONENTIAL SMOOTHING METHOD