9 Forecasting: Demand Characteristics

Sudhanshu Joshi

 

Learning Objectives:

 

The Learning objectives of the module are to address the following questions:

 

1.  Understand the role of forecasting for both an enterprise and a supply chain.

2.  To Identify the components of a demand forecast.

3.  Forecast demand in a supply chain given historical demand data using time-series methodologies.

4.  How to analyze demand forecasts to estimate forecast error.

 

Basic Approach of Learning: 

  • Understand the objective of forecasting.
  • Integrate demand planning and forecasting throughout the supply chain.
  • Identify the major factors that influence the demand forecast.
  • Forecast at the appropriate level of aggregation.
  • Establish performance and error measures for the forecast.

 

Introduction: 

 

Demand forecasts form the basis of operations across the organization. Demand/ Supply are based on the anticipation of customer demand. For Demand anticipation, operations manager must plan the level of activity (viz. production, inventory, logistics/transportation etc, but not the actual amount to be executed.

 

For a Burger paint store, orders the base paint / dyes anticipating possible orders from customers, although it performs final mixing of the paints in response to actual orders. The paint store uses a forecast of demand to determine the quantity of paint/ dyes to have at store/ site. The paint/ dyes factory that produces the base, also require to forecasts to determine its own production/ inventory levels. The Suppliers at end of paint factors also need forecasts. Therefore in every stage of supply, own separate forecast is needed to be maintained, these forecasts are often very different. The result may be a mismatch between supply and demand.

 

For more accuracy, all stages of supply chain need to produce a collaborative forecast so that customers can be served in an effective manner. Firms from FMCG to electronic manufactures have improved their supply-demand gap by moving towards collaborative forecasting.

 

2.  Characteristics of Forecasting 

 

Operation managers should be well-versed with the characteristics of forecasting, including:

 

a) Forecasts are inaccurate and include both the expected value of the forecast and a measure of forecast error.Example: To understand the importance of forecast error, consider two motorbike dealers. One of them expects sales to range between 100 and 1,900 units, whereas the other expects sales to range between 900 and 1,100 units. Even though both dealers anticipate average sales of 1,000, the sourcing policies for each dealer should be very different, given the difference in forecast accuracy. Thus, the forecast error (or demand uncertainty) is a key input into most supply chain decisions.

 

In practice, very less firms’ estimates forecast error.

 

b) Long-term forecasts are less accurate than short-term forecasts; that is, long-term forecasts have a larger standard deviation of error relative to the mean than short- term forecasts.Example: Tata Motors has improved its performance while focusing on short-term forecasts. The company has instituted a replenishment process that enables it to respond to an order within hours. For example, if a store manager places an order by 10 a.m., the order is delivered by 7 p.m. the same day. Therefore, the manager has to forecast what will sell that night only less than 12 hours before the actual sale. The short lead time allows a manager to take into account current information that could affect product sales, such as the weather. This forecast is likely to be more accurate than if the store manager had to forecast demand a week in advance.

 

c) Aggregate forecasts are more accurate than individual unit forecasts, as they tend to have a smaller standard deviation of error relative to the mean.Example: GDP of India for given year can be easily evaluated, with less than a 2 percent error. However, it is a bit difficult to forecast yearly revenue for a company with less than a 2 percent error, and it is even harder to forecast revenue for a given product with the same degree of accuracy.

 

3. Forecasting: Components and Methods 

 

An effective forecasting requires the knowledge of the following:

 

a)    Demand from recent past

b)    Lead time of product replenishment;

c)    Planned advertising or marketing efforts;

d)    Planned price discounts;

e)    Present State of the economy;

f)     Competitive positioning.

 

For example, historically a Gift items shop may have experienced low demand for Gift items during non-festival seasons and high demand in Festival seasons (Deepawali, Xmas, New Year etc.). If the firm decides to discount the product during the off-seasons, the situation is likely to change, with some of the future demand shifting during off-season times. The firm should make its forecast taking this factor into consideration.

 

3.1. Types of forecasting methods: 

 

Theoretically, Forecasting methods are classified according to the following four types:

 

a. Qualitative Forecasting methods: Appropriate when historical data are available.

 

b. Time series forecasting methods: Use historical demand to make a forecast. It is among most appropriate method, when the basic demand pattern does not vary significantly from one year to the next.

 

c. Casual Forecasting Methods: Forecasting methods assume that the demand forecast is highly correlated with certain factors in the environment (the state of the economy, interest rates, etc.).

 

d. Simulation Methods: Simulation forecasting methods focused on ascertaining demand based on various underlined factors including price, impact of competition etc.

 

Components  of  an  Observation  in  the  forecasting  methods  includes-  (a)  systematic component (expected  value  of  demand);  whereas,  expected  value  of  demand  could  be effected by  Level (current de-seasonalized demand), Trend (Growth or decline in demand) and seasonality (predictable seasonal fluctuation); (b) Random component (part of forecast that deviates from systematic component); (c). Forecast error (difference between forecast and actual demand).

 

4. Time series forecasting methods 

 

The equation for calculating the systematic component may take a variety of forms:

 

a) Multiplicative: Systematic component = level * trend * seasonal factor

 

b) Additive: Systematic component = level + trend + seasonal factor

 

c) Mixed: Systematic component = 1level + trend2 * seasonal factor

 

The specific form of the systematic component applicable to a given forecast depends on the nature of demand.

 

4.1 Static Methods 

 

A static method assumes that the estimates of level, trend, and seasonality within the systematic component do not vary as new demand is observed. In this case, we estimate each of these parameters based on historical data and then use the same values for all future forecasts. Systematic component of demand is mixed; that is,

 

Systematic component = 1level + trend2 * seasonal factor

 

St = estimate of seasonal factor for Period t

Dt = actual demand observed in Period t

Ft = forecast of demand for Period t

 

In a static forecasting method, the forecast in Period t for demand in Period t + l is a product of the level in Period t + l and the seasonal factor for Period t + l. The level in Period t + l is the sum of the level in Period 0 (L) and (t + l) times the trend T. The forecast in Period t for demand in Period t + l is thus given as

 

Ft + l = 3L + 1t + l2T4St + l (7.1)

 

We now describe one method for estimating the three parameters L, T, and S.

 

Let’s take an example of salt producing firm called Tata Salt, Quarterly retail demand data for the past three years are shown in Table I  and Figure 1-1 as follows:

Year Quart er Period, t Demand, Dt
1 2 1 8,000
1 3 2 13,000
1 4 3 23,000
2 1 4 34,000
2 2 5 10,000
2 3 6 18,000
2 4 7 23,000
3 1 8 38,000
3 2 9 12,000
3 3 10 13,000
3 4 11 32,000
4 1 12 41,000

Figure 1-1 : Quarterly demand of Tata Salt

 

Estimate Level and Trend

A linear relationship exists between the deseasonalized demand and time based on the change in demand over time

 

Dt  = L + Tt

 

Estimating Seasonal Factors

 

S1  = (S1 + S5 + S9 ) / 3 = (0.42 + 0.47 + 0.52) / 3 = 0.47

S2  = (S2 + S6 + S10 ) / 3 = (0.67 + 0.83 + 0.55) / 3 = 0.68

S3  = (S3 + S7  + S11 ) / 3 = (1.15 +1.04 +1.32) / 3 = 1.17

S4  = (S4 + S8 + S12 ) / 3 = (1.66 +1.68 +1.66) / 3 = 1.67

 

 

 

 

 

F13  = (L +13T )S13  = (18,439 +13´ 524)0.47 = 11,868

F14 = (L +14T )S14 = (18,439 +14 ´ 524)0.68 = 17,527

F15 = (L +15T )S15 = (18,439 +15´ 524)1.17 = 30,770

F16  = (L +16T )S16  = (18,439 +16 ´ 524)1.67 = 44,794

 

4.2 Adaptive Forecasting

 

In adaptive forecasting, the estimates of level, trend, and seasonality are updated after each demand observation. The main advantage of adaptive forecasting is that estimates incorporate all new data that are observed. We now discuss a basic framework and several methods that can be used for this type of forecast. The framework is provided in the most general setting, when the systematic component of demand data has the mixed form and contains a level, a trend, and a seasonal factor. It can easily be modified for the other two cases, however. The framework can also be specialized for the case in which the systematic component contains no seasonality or trend. We assume that we have a set of historical data for n periods and that demand is seasonal, with periodicity p. Given quarterly data, wherein the pattern repeats itself every year, we have a periodicity of p = 4.

 

We begin by defining a few terms:

 

Lt = estimate of level at the end of Period t

Tt = estimate of trend at the end of Period t

St = estimate of seasonal factor for Period t

Ft = forecast of demand for Period t (made in Period t − 1 or earlier)

Dt = actual demand observed in Period t

Et = Ft − Dt = forecast error in Period t

 

Discussion

 

The overall demand characteristics of Forecasting that can help firm to achieve business excellence includes

  1. Understand the role of forecasting for both an enterprise and a supply chain. Forecasting is a key driver of virtually every design and planning decision made in both an enterprise and a supply chain. Enterprises have always forecast demand and used it to make decisions. A relatively recent phenomenon, however, is to create collaborative forecasts for an entire supply chain and use these as the basis for decisions. Collaborative forecasting greatly increases the accuracy of forecasts and allows the supply chain to maximize its performance. Without collaboration, supply chain stages farther from demand will likely have poor forecasts that will lead to supply chain inefficiencies and a lack of responsiveness.
  2. Identify the components of fdema 3.
  3. Identify the components of a demand forecast. Demand consists of a systematic and a random component. The systematic component measures the expected value of demand. The random component measures fluctuations in demand from the expected value. The systematic component consists of level, trend, and seasonality. Level measures the current deseasonalized demand. Trend measures the current rate of growth or decline in demand. Seasonality indicates predictable seasonal fluctuations in demand.
  4. Forecast demand in a supply chain given historical demand data using time-series methodologies. Time-series methods for forecasting are categorized as static or adaptive. In static methods, the estimates of parameters and demand patterns are not updated as new demand is observed. Static methods include regression. In adaptive methods, the estimates are updated each time a new demand is observed. Adaptive methods include moving averages, simple exponential smoothing, Holt’s model, and Winter’s model. Moving averages and simple exponential smoothing are best used when demand displays neither trend nor seasonality. Holt’s model is best when demand displays a trend but no seasonality. Winter’s model is appropriate when demand displays both trend and seasonality.
  5. Analyze demand forecasts to estimate forecast error. Forecast error measures the random component of demand. This measure is important because it reveals how inaccurate a forecast is likely to be and what contingencies a firm may have to plan for. The MSE, MAD, and MAPE are used to estimate the size of the forecast error. The bias and TS are used to estimate if the forecast consistently over- or underforecasts or if demand has deviated significantly from historical norms.

 

Suggested Readings:

 

a) Moon(2013): Demand and Supply Integration: The Key to World-Class Demand Forecasting. FT Press Operations Management.

b) Anderson (2013): Operations Management For Dummies. For Dummies.

c) Makridakis (1998): Forecasting: Methods and Applications. John Wiley & Sons.

d) Munson (2011): The Supply Chain Management Casebook: Comprehensive Coverage and Best Practices in SCM. FT Press Operations Management.

e) Drake (2015): Advances in Business, Operations, and Product Analytics: Cutting Edge Cases from Finance to Manufacturing to Healthcare. Pearson FT Press.