# OPERATIONS AND SUPPLY CHAIN MANAGEMENT Assignment 2

Operations and Supply Chain Management

MGMT 3306

Lecture 03

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper NowInstructor: Dr. Yan Qin

Outline – Demand Forecasting

What is Forecasting

Qualitative forecasting methods

Quantitative forecasting methods

Time-series models

Associative models

Linear regression

Trend and Seasonal factors

Trend-adjusted exponential smoothing method

Seasonal indices

Forecasting

Forecasting is the art and science of predicting future events.

Three major types of forecasts in planning future operations:

Economic forecasts: address the business cycle by predicting inflation rates, money supplies, and etc.;

Technological forecasts: predict rates of technological progress;

Demand forecasts: projections of demand for a company’s products or services. (What we’ll discuss in this lecture)

3

Seven Steps in Forecasting

Determine the use of the forecast

Select the items to be forecasted

Determine the time horizon of the forecast

Select the forecasting model(s)

Gather the data

Make the forecast

Validate and implement results

Demand Forecasts

There are two general approaches to forecasting:

Qualitative, which incorporate factors such as decision maker’s intuition, emotions, personal experience, and so on.

Quantitative, which uses a variety of models that rely on historical data to forecast demand.

Common types of Qualitative Methods

Jury of execution opinion: The opinions of a group of high-level experts or mangers are pooled together to arrive at a group estimate of demand.

This approach is used widely because it is relatively quick, inexpensive and uses the solid understanding of participants who are presumed to have relevant knowledge.

Consumer market survey: Collect information from current or potential customers about future purchasing plan.

6

Common types of Qualitative Methods

Delphi method: Surveys and questionnaires are distributed to a group of selected respondents. Then a group of 5-10 experts make the decision based on the responses.

The state of Alaska used Delphi method to develop its long-range economic forecast.

Sales force composite: Combine each sales person’s estimate of future demand.

Lexus dealers meet every quarter to talk about the sales, such as what is selling, in what colors, so the manufacturer has an idea what to build.

7

Common Quantitative Methods

Time series models predict on the assumption that the future is a function of the past.

Naïve approach

Moving averages

Exponential smoothing

Associative Models incorporate variables that might influence the quantity being forecast.

For example, an associative model for lawn mowers sales might use factors such as new housing starts, advertising budget and so on.

Linear regressions

8

Naïve Approach

Assume that demand in the next period will be equal to the most recent period.

For example, if the sales in Feb was 56 units, the forecast for March would be 56 under the naïve approach.

This approach takes a temporary change as a permanent change.

Bull-whip effect will be maximized under this forecasting method.

9

Moving averages

A moving-average forecast uses a number of historical actual data values to generate a forecast.

It is useful if we can assume that market demands will stay fairly steady over time.

An n-period moving-average model:

Usually the n is 3, 6, 9 periods.

n : # of periods to be averaged

: Forecast for period t

: Actual demand for period t-1

10

Example: 3-/6-month moving average

Month Actual Sales 3-Month 6-Month

Jan 10

Feb 12

March 13

April 16 (10+12+13)/3=11.7

May 19 (12+13+16)/3=13.7

June 23 (13+16+19)/3=16

July 26 (16+19+23)/3=19.3 (10+12+13+16+19+23)/6=15.5

Aug 30 (19+23+26)/3=22.7 (12+13+16+19+23+26)/6=18.2

Sep 28 (23+26+30)/3=26.3 (13+16+19+23+26+30)/6=21.2

Weighted moving averages

Weights can be used to place more emphasis on recent values or older values.

A n-period weighted moving average:

: Weight attached to the actual demand in period i

12

Example: Weighted moving average

Suppose we use the 3-period weighted moving average method to make demand forecasts. An importance weight of 0.6 is assigned to the most recent actual demand, 0.3 to the second most recent actual demand, and 0.1 to the oldest observation.

Then what are the 3-period forecasts for demands in April and May?

Month Actual Sales Forecasts

Jan 10

Feb 12

March 13

April 16 ?

May 19 ?

Example: Solution

We first calculate the forecast for April. Let t = 4. Then, period 1 is Jan. Period 2 is Feb. And period 3 is Mar in this case.

We now calculate the forecast for May. Let t = 5.

Limitations of moving averages

Increasing the size of n makes the method less sensitive to real changes in the data;

Moving averages cannot predict changes to either higher or lower levels. They lag the actual values.

Moving averages require extensive records of past data.

Exponential smoothing

Exponential smoothing is a sophisticated weighted-moving-average method.

Call a smoothing constant, valued between 0 an 1. Usually from 0.05 to 0.50 for business application.

That is, the forecast for period t is the sum of the forecast for period t -1 and the amount of adjustment determined by the forecast error in period t-1 and the smoothing constant.

Example: Exponential Smoothing

Let . Then what are the forecasts for the demands in Feb, Mar, and April using Exponential Smoothing?

Month Actual Sales Forecast

Jan 10 8

Feb 12 ?

March 13 ?

April 16 ?

May 19

Example: Solution

Let Jan be period 1, Feb be period 2, Mar be period 3, and so on.

Then the forecast for Feb can be computed as follows:

The forecast for March:

The forecast for April:

Impact of Smoothing Constant

225 –

200 –

175 –

150 –

| | | | | | | | |

1 2 3 4 5 6 7 8 9

Quarter

Demand

a = .1

Actual demand

a = .5

Chose high values of α when underlying average is likely to change

Choosing Smoothing Constant

The objective is to obtain the most accurate forecast no matter the technique

We generally do this by selecting the model that gives us the lowest forecast error

Forecast error = Actual demand – Forecast value

= At – Ft

Common Measures of Error

Mean Absolute Deviation (MAD): Average of the absolute values of the individual forecast errors.

Mean Squared Error (MSE): The average of the squared forecast errors.

Example: Measures of Error

Rounded Absolute Rounded Absolute

Actual Forecast Forecast error Forecast Forecast error

Tonnage with for with for

Quarter Unloaded a = .10 a = .10 a = .50 a = .50

1 180 175 5.00 175 5.00

2 168 175.5 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

82.45 98.62

Sum

Sum

Example: MAD

For α = 0.1,

For α = 0.5,

Lower overall forecast error based on MAD when

Example: MSE

For α = 0.1, 190.82

For α = 0.5, 195.24

Lower overall forecast error based on MSE when

Associative Model – Linear Regression

Regression is used to predict one variable given the other variable(s). The relationship is usually developed from observed data.

Linear regression is a special class of regression where the relationship between variables is linear.

a: Intercept; b: Slope

Y: dependent variable we are tying to make forecast for

X: independent variable whose value has a linear impact on the value of Y.

25

Least squares method

It is a method to estimate the a and b values based on historic data.

The objective is to minimize the sum of the squares of the differences between forecasts and actual observations.

Let denote the y value of the observation and be the corresponding forecast using a certain set of a and b values. Suppose there are n data points.

Forecast error of observation 1

Forecast error of observation 2

Forecast error of observation n

Figure: Least squares method

We want to find a straight line that minimizes the sum of the squared forecast errors.

Least squares method (Cont.)

Using the least squares method,

where is the x value of observation i;

is the y value of observation i;

is the mean of all x values;

is the mean of all y values;

n is the number of observations in the data set

Least squares method (Cont.)

Standard error of estimates (How well the estimated line fits the data)

where is the forecast for the y value of observation i.

Example: Least squares

Consider a situation where the sales of a product is time-dependent. What is the forecast for the demand in month 6 using the least squares Linear Regression method?

Month () Actual Sales ()

1 10

2 12

3 13

4 16

5 19

Example: Solution

We first calculate the squares and products required in the calculation of a and b.

Month () Actual Sales ()

1 10 10 1

2 12 24 4

3 13 39 9

4 16 64 16

5 19 95 25

14

Example: Solution

The linear regression function is:

Y = 7.4 + 2.2X

Then the forecast for the demand in month 6

= 7.4 + 2.26

= 20.6

Note that

Decomposition of a time series

A time series can have 4 components:

Trend: the gradual upward or downward movement of the data over time. (Can be estimated using Least squares Linear Regression method)

Seasonality: a data pattern that repeats itself after a period of days, weeks, months, or quarters.

Cycle: patterns in the data that occur every several years.

Random variations: “blips” in the data caused by chance and unusual situations.

33

Figure: 4 major components

Exponential smoothing with Trend adjustment

Adjust exponential smoothing forecasts for positive or negative lag in trends. (requires two smoothing constants: )

Steps to take:

Step 1: Compute , the exponential smoothing forecast for period t.

Step 2: Compute the trend estimate for period t,

Step 3: Calculate the forecast for period t including trend

35

Example: Trend adjustment

Let the smoothing constants and . The company assumes that the initial forecast for Jan was 10 and the trend over that period was 2 units. What are the trend-adjusted forecasts for Feb in this case?

Month Actual Sales Forecast t Trend t

Jan 10 9 2

Feb 12 ? ?

Example: Solution

For Feb,

10.8

=12.72

Seasonal index

A seasonal index is the amount of correction needed in a time series to adjust for the season of the year.

Example 1: Assume that in past years, a firm sold an average of 1,000 units of a product each year. On average, 200 units were sold in the spring, 350 units in the summer, 300 units in the fall, and 150 units in the winter.

Then the seasonal index is the ratio of the amount sold during each season divided by the average for all seasons.

Example: Seasonal index

Question 1: For the previous example, what are the four seasonal indices?

Seasonal average = 1,000 / 4 = 250

Seasonal index = average sales in a season / seasonal average

Seasonal index for spring = 200/250 = 0.8

Seasonal index for summer = 350/250=1.4

Seasonal index for fall = 300/250 = 1.2

Seasonal index for winter = 150/250 = 0.6

Example: Seasonal index (Cont.)

Question 2: Now suppose the expected demand for next year is 1,100 units. What are the forecasts for each season next year?

Forecast for a season = seasonal average for next year * seasonal index for that season

Seasonal average for next year = 1100 / 4 = 275

Forecast for spring =275*0.8 = 220

Forecast for summer =275*1.4 = 385

Forecast for fall = 275*1.2 = 330

Forecast for winter = 275*0.6 = 165

Example 2: Seasonal index

What if we have more than one year of data?

Answer: Divide the average for each season by the general seasonal average for all years. (Assuming constant seasonal indices for each year or additive seasonal effect)

Year 1 Actual Sales Year 2 Actual Sales

Spring 300 Spring 520

Summer 200 Summer 420

Fall 220 Fall 400

Winter 530 Winter 700

The general average is 411.25 (Average of the 8 numbers)

Seasonal index for Spring = ((300+520)/2)/411.25 = 0.99

212

128.728205

2

)(

2

1

n

Yy

S

i

n

i

i

xy

= 269.85