demand forecasting Flashcards

1
Q

forecasting

A

consistent, systematic and appropriate forecasting process positively impact performance through decreased operations costs, improved customer service, increased sales, and reductions in inventory. these improvements have positively affected return

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what is forecasting?

A

a method for translating past experience and present events into predictions of the future

observed measurement = systematic part + random part

  • forecasting tries to isolate the systematic part
  • the random part determines the forecast accuracy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

why do we forecast

A

-to make better decisions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

forecasting is important because:

A
  • it is a starting point for business planning
  • all business decisions will follow the result of forecasting
  • “bad “ forecast can lead to a significant increase in cost
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Forecasting is vital to every functional area:

A
  • finance
  • marketing
  • HR
  • production and operations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

forecasting error

A

forecasts are rarely perfect; actual results differ from predicted values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

forecasting techniques generally assume that:

A

the same underlying causal system that existed in the past will continue to exist in the future

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Forecasts for ______ items tend to be more accurate than forecast for ______ items

A
  1. group of
  2. individual
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

_________ forecasts tend to be more _________ accurate than forecasts

A
  1. Short-term
  2. long-term
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

forecasting methods

A
  1. judgmental methods
  2. time series analysis
  3. causal relationship
  4. simulation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

judgmental methods:

A
  • sales force estimate
  • executive opinion
  • market research
  • historical analogies
  • Delphi method
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Delphi method:

A

Group of experts respond to questionnaire.

A moderator compiles results and formulates a new questionnaire that is submitted to the group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

time series:

A

a time ordered sequence of observations taken at regular intervals of time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

assumptions

A

(i) record of past demand is available and (ii) past demand is a predictor of future demand

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

the following 5 patterns could be identified in a time series:

A
  • trend
  • seasonality
  • cycles
  • irregular variations
  • random variations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

trend

A

long term movement in data (up or down)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

seasonality

A

short-term fairly regular variations in data generally related to factors such as the calendar or time of the day

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

cycles

A

wavelike variations of more than one year’s duration. These are often related to a variety of economic, political and agriculture conditions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

irregular variations

A

-caused by unusual circumstances such as severe weather

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

random variations

A

-caused by chance that will remain after all other behaviours have been accounted for

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

fundamental difference between cycles and seasonality is the …

A

duration of repeating patterns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

linear regression

A

Is a way to model the relationship between two variables. …

The equation has the form Y=a+bt,

  • where Y is the dependent variable (that’s the variable that goes on the Y axis),
  • t is the independent variable (i.e. it is plotted on the X axis),
  • b is the slope of the line and a is the y-intercept
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Naïve Method

A

the Naïve forecasts are simply set to be the value of the last observation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Naïve Method -9 facts

A
  1. Simple to use
  2. This method works remarkably well for many time series.
  3. Very low cost
  4. Data analysis is nonexistent
  5. Easily understandable
  6. Can serve as a standard for comparison
  7. Low accuracy (not suitable when the random variation is high)
  8. Short-term
  9. Providing a starting point for other forecasting method
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Uses for naive forecasts

A
  • with a stable time series data
  • with seasonal variations
  • for data with trend
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

with a stable time series data

A

the last point becomes the forecast for the next period. if the actual demand for a product last week was 20 cases, the forecast for this week is 20 cases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

formula + example

With a stable time series data

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

with seasonal variations

A

the forecast for this “season” is equal to the value of the series last “season”. for example, the forecast for demand for energy this summer is equal to the demand for energy last summer

29
Q

formula + example

With seasonal variations

A
30
Q

for data with trend

A

the forecast is equal to the last value of the series plus the difference between last two values of the series. for example, suppose the last two values were 50 and 53

31
Q

formula + example

fot data with trend

A
32
Q

techniques for averaging

A
  • moving average
  • weighted moving average
  • exponential smoothing
33
Q

moving average

A

-averages a number of the recent actual data values which updated as new values become available

34
Q

weighted moving average

A

assigns large weight to the most recent values in a time series

35
Q

exponential smoothing

A

is sophisticated weighted averaging where a new forecast is based on the previous forecast plus a percentage of the difference between that forecast and the previous actual value

36
Q

simple (moving) average

A
  • relies on the recent past data
  • smooth out random variations
  • useful for stable demand
37
Q

simple (moving) average formula

A

N= total number of periods used in calcuation

  • sensitivity to random variation depends on N
  • N is subjective
38
Q

Compute a three period-moving average forecast for period 6, given for the demand below.

A
39
Q

the number of periods (N) to include in simple moving average

A
  • Arbitrary
  • The fewer, the more sensitive (responsive) to most recent data.
    • If responsiveness is important, using relative few data. Keep in mind, it also cause the forecast to be responsive even to random variations.
40
Q

advantage of simple moving average

A
  • easy to compute
  • easy to understand
41
Q

disadvantage of simple moving average

A
  • values in the average are weighted equally
  • can not pick up trends very well
  • may require extensive records of past data
42
Q

weighted moving average

A
  • weights represent the amount of influences of past demand on forecast
  • weights reflect fluctuations in the demand data
43
Q

weighted moving average formula

A
  • Wt-1 = weight applied to period t-1’s demand
    • weights are non-negative and sum to one
    • most common: most current demand has larger weight
    • weights and N are subjective
44
Q

weighted moving average problem

  1. calculate a weighted average forecast using a weight of 0.40 for the most recent period, 0.30 for the next most recent, 0.20 for the next and 0.10 for the next
  2. If the actual demand for period 6 is 39, forecast the demand for the period 7 using the same weights as in part 1.
A
  1. ) F6 = 0.40(41)+0.30(40)+0.20(43)+0.10(40) = 41.0
  2. ) F7 = 0.40(39)+0.30(41)+0.20(40)+0.10(43) = 40.2
45
Q

exponential smoothing - facts

A
  • is is a special case of the weighted averages method in which we select only one weight-the weight for the most recent observation
  • the weights for the other data values are automatically computed and get smaller as the observations move farther into the past
  • requires minimal amount of data
46
Q

exponential smoothing formula

A
47
Q

exponential smoothing example

A
48
Q

exponential smoothing example 2

  1. use alpha = 0.1 find the forecast for period 6
  2. use alpha = 0.4 find the forecast for period 8
A
49
Q

picking a smoothing constant – criteria

A
  • selecting a smoothing constant is basically a matter of judgement of trail and error . the goal is to select alpha that balances the benefits of random variations
  • commonly used values of alpha range from 0.01 to 0.5
  • if the real demand is stable we would like small alpha to lessen the effects of short term or random changes
  • if the real demand is rapidly increasing or decreasing we would likea large alpha to try to keep the changes
50
Q

the most used of all forecasting techniques

A

exponential smoothing

51
Q

exponentially models are surprisingly _______

A

accurate

52
Q

___________ exponential model is relatively ________.

A
  1. formulating
  2. easy
53
Q

with exponential smoothing, the user can ___________ how the model ________

A
  1. understand
  2. works
54
Q

with exponential models, little ___________ is required by to use the model.

A

computation

55
Q

with exponential smoothing, __________________ requirements are small because of the limited use of ______________ data.

A
  1. computer storage
  2. historical
56
Q

with exponential smoothing, _______ of _______ as to how well the model is performing are _____ to compute

A
  1. tests of accuracy
  2. easy
57
Q

in exponential smoothing method, only three peices of ata are needed to forecast the future:

A
  1. the most recent forecast
  2. the actual demand that accrued for that forecast period
  3. smoothing constant alpha
58
Q

linear trend equation - Summary

A
  • fits a trend line to a series of historical data
  • if we want to use a precise statistical method we can use least square method to find the equation of the line (called the least squares line)
59
Q

linear trend equations

A

the coefficients of the line, a and b can be calculated from data using these two equations

n= total number of periods

y=value of the demand time series

60
Q

linear trend example

the manager of Hi-tech company wants to develop a forecat model for annual sales of laptops. the following data have been collected for five different periods. Develop a linear trend equation for these data, then forecast sale for week 10.

A
61
Q

forecasts are rarely perfect :

A
  • internal factors or external factors
  • more product choices, faster introduction of new products
  • lack of data, lack of expertise, time or money constraint
62
Q

forecasting objective: to minimize forecasting error

A

forecasting error = (actual demand) - (forecast)

63
Q

to minimize error :

A
  • select the best possible model
  • select the best possible value for a parameter (N in Moving Average, alpha in Exponential Smoothing)
64
Q

Minimize forecast error measures:

A
  • MAD
  • MSE
  • MAPE
65
Q

MAD
Mean Absolute Deviation

A
  • advantage- based on absolute values, the errors of opposite signs do not cancel each other out when they are added
  • measures general variation
  • smaller the better
66
Q

MSE

Mean Squared Error

A
  • Advantage- Due to the squaring of the error team, large errors tend to be magnified
  • reveals large errors
  • smaller the better
67
Q

MAPE

Mean Absolute Percent Error

A
  • advantage - weights error relative to actual values
  • smaller the better
68
Q

Monitoring forecast errors

tracking signal formula

A
69
Q

When tracking signal values exceeds 4 in absolute value, the analyst will study the model and make changes. the model may be in adequate due to :

A
  1. the omission of an important variable
  2. a change or shift in the variable that the model cannot deal with

As long as the tracking signal is between -4 and 4, assume the model is working correctly