forecast?
Features Forecasting
Why Common to all Forecasts
Conditions in the past will continue in the future
Rarely perfect
Forecasts for groups tend to be more accurate than forecasts for individuals
Forecast accuracy declines as time horizon increases
Elements of a Good Forecast
Timely
Accurate
Reliable (should work consistently)
Forecast expressed in meaningful units
Communicated in writing
Simple to understand and use
Steps in Forecasting Process
Determine purpose of the forecast
Establish a time horizon
Select forecasting technique
Gather and analyze the appropriate data
Prepare the forecast
Monitor the forecast
Types of Forecasts
Qualitative
o Judgment and opinion
o Sales force
o Consumer surveys
o Delphi technique
Quantitative
o Regression and Correlation (associative)
o Time series
Forecasts Based on Time Series Data
What is Time Series?
Components (behavior) of Time Series data
o Trend
o Cycle
o Seasonal
o Irregular
o Random variations
Nave Methods
Nave Forecast uses a single previous value of a time series as the basis of a
forecast.
Techniques for Averaging
What is the purpose of averaging?
Common Averaging Techniques
o Moving Averages
o Exponential smoothing
Moving Average
Exponential Smoothing
Techniques for Trend
Linear Trend Equation
Curvilinear Trend Equation
Techniques for Seasonality
What is seasonality?
What are seasonal relatives or indexes?
How seasonal indexes are used:
o Deseasonalizing data
o Seasonalizing data
How indexes are computed (see Example 7 on page 109)
Accuracy and Control of Forecasts
Measures of Accuracy
o Mean Absolute Deviation (MAD)
o Mean Squared Error (MSE)
o Mean Absolute Percentage Error (MAPE)
Forecast Control Measure
o Tracking Signal
Mean Absolute Deviation (MAD)
Mean Squared Error (or Deviation) (MSE)
Mean Square Percentage Error (MAPE)
Tracking Signal
Problems:
2 Plot, Linear, MA, exponential Smoothing
5 Applying a linear trend to forecast
15 Computing seasonal relatives
17 Using indexes to deseasonalize values
26 Using MAD, MSE to measure forecast accuracy
Problem 2 (118)
National Mixer Inc., sells can openers. Monthly sales for a seven-month period were as follows:
Month
Feb
March
April
May
June
July
August
Sales
(000 units)
19
18
15
20
18
22
20
(a) Plot the monthly data on a sheet of graph paper.
(b) Forecast September sales volume using each of the following:
(1) A linear trend equation
(2) A five-month moving average
(3) Exponential smoothing with a smoothing constant equal to 0.20, assuming March
(4)
(5)
forecast of 19(000)
The Nave Approach
A weighted average using 0.60 for August, 0.30 for July, and 0.10 for June
(c) Which method seems least appropriate? Why?
(d) What does use of the term sales rather than demand presume?
EXCEL SOLUTION
Plot of the monthly data
Click INSERT tab, click LINE option
Right Click on the time series data on the graph
Select Add Trendline
(1) Five-month moving average
(2) Exponential Smoothing with a smoothing constant of 0.20, March assuming forecast of
19(000)
Enter the smoothing factor in D1
Enter 19 in D5 as forecast for March
Create the exponential smoothing formula in D6, then copy it onto D7 to D11
(3) The Nave Approach
(4) A weighted average using 0.60 for August, 0.30 for July, and 0.10 for June
Problem 5 (118)
A cosmetics manufacturers marketing department has developed a linear trend equation that can be
used to predict annual sales of its popular Hand & Foot Cream.
Ft =80 + 15 t
where: Ft = Annual sales (000 bottles)
t0 = 1990
(a) Are the annual sales increasing or decreasing? By how much?
(b) Predict annual sales for the year 2010 using the equation
Problem 15 (120)
Obtain estimates of daily relatives for the number of customers at a restaurant for the evening meal, given
the following data. (Hint: Use a seven-day moving average)
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Number
Served
80
75
78
95
130
136
40
82
77
80
94
125
135
42
Day
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Number
Served
84
77
83
96
135
140
37
87
82
98
103
144
144
48
Excel Solution
Type a 7-day average formula in E6 ( =average(C3:c9) )
In F6, type the formula =C6/E6
Copy the formulas in E6 and F6 onto cells E7 to E27
Compute the average ratio for Day 1 (see formula in E12)
Copy and paste the formula in E12 onto E13 to E18 to complete the indexes for Days 2 to 7
Problem 17 (121)
Using indexes to deseasonalize values
New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table,
along with monthly (seasonal) relatives, which are supplied to the dealer by the regional distributor.
Month
Jan
Feb
Mar
April
May
Jun
Units
Sold
640
648
630
761
735
850
Index
0.80
0.80
0.70
0.94
0.89
1.00
Month
Jul
Aug
Sept
Oct
Nov
Dec
Units
Sold
765
805
840
828
840
800
Index
0.90
1.15
1.20
1.20
1.25
1.25
(a) Plot the data. Does there seem to be a trend?
(b) Deseasonalize car sales
(c) Plot the deseasonalized data on the same graph as the original data. Comment on the two
graphs.
Excel Solution
(a) Plot of original data (seasonalized car sales)
(b) Deseasonalized Car Sales
(c) Graph of seasonalized car sales versus deseasonalized car sales
Problem 22 (123) Using MAD, MSE, and MAPE to measure forecast accuracy
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled
water. Actual demand and the two sets of forecasts are as follows:
Period
1
2
3
4
5
6
7
8
Demand
68
75
70
74
69
72
80
78
Predicted Demand
F1
F2
66
66
68
68
72
70
71
72
72
74
70
76
71
78
74
80
(a) Compute MAD for each set of forecasts. Given your results, which forecast appears to be the
most accurate? Explain.
(b) Compute MSE for each set of forecasts. Given your results, which forecast appears to be the
most accurate? Explain.
(c) In practice, either MAD or MSE would be employed to compute forecast errors. What factors
might lead you to choose one rather than the other?
(d) Compute MAPE for each data set. Which forecast appears to be more accurate?
Excel Solution