1) CH3- Forecasting Flashcards

1
Q

What is forecasting

A

process of predicting a future event

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

what is forecasting used for

A

production, inventory.personnel, facilities

WE USE THE PAST TO PREDICT THE FUTURE ALWAYS

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

WHY IS forecasting important

A

because businesses must make decisions, use resources, spend money before they know what the future holds

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

EX: call centre staffing, needs to forecast what? what is the pllaning horizon?

A

of calls per hour

1 day- 1 month

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

3 types of forecasting time horizions

A

1) short range : <3mos, up to 1 year
purchasing, job scheduling, workforce levels, job assignments, production levels

2) medium range: 3mos-3 years
sales and production planning, budget

3) long range: 3+ years
new product planning, facility location, R&D

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

Types of forecasts

A

economic
technological
demand

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

economic forecasts

A

address busienss cycle,

ifnlation rate, money cupply, housig starts

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

technologicla forecasts

A

predict rate of tech processes

impact development of new products

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

demand forecasts (focus)

A

predict sales of exisitng products and services

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

why does HR care about forecasts

A

hiring, training, lay offf workers

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

seven steps of forecasting

A

1) determine the use of the forecast
2) select the items to be forecasted
3) determine the time horizon of the forecast
4) select the forecasting models
5) gather data
6) make the forecast
7) validate and implement results

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

qualitiative methods of forecasting

A

subjective, used when no data available

new products and new tech! involves experience and intuition

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

quantiative methods of forecasting

A

used when situation is stable and historical data exists!

involves math techniques

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

5 examples of qualitiative methods of forecasting

A

1) jury of exec opinion (experts)
2) delphi and nominal group techniques (group consensus that arrives through an iterative process)
3) sales force ocmposite (Aggregatted from individual sales persons)
4) consumer market survey (Ask customers such as disney)
5) product life cycle curve (forecast life cycle stage A) INTRODUCTION B)GROWTH C) MATURITY D)DECLINE))

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

4 stages of product life cycle

A

introdcution
growth
maturity
decline

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

quantiative methods of forecasting example

A

1) time series forecasting (intrinsic) WE FOCUS ON THIS

2) casual methods (extrinsic)

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

time series forecasting (intrinsic)

A

relies on past data to predict the future

focus of this course

THIS IS WHAT WE USE

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

casual methods (Extrinsic)

A

regression, leading indicators, econometric models

includes use of external factors:
-forecasts for GDP based on housing starts
- exchange rates
- interest rates

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

what is selection criteria

A

important factors when determining which forecasting method to use

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

what are the selection criteria

why do we have these?

A

forecast horizon (daily-annual)

required accuracy (how much who shortage/excess cost???)

data availability (new porduct vs established one)

resources avaialble to make forecasts (people (knowledge), time, money)

b) because there are many techniques and we need to pick one

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

characterisitcs fo a good forecast

QUALITY AND COST- analysis

A

quality :
A) ACCURACY: Size (Spread) of forecast errors
B) BIAS: were predicitons consistently high or low? skew?

cost:
A) COST: cost of gaining additional data, more complicated models, and the value of an incrementally better forecast
B) CONSEQUENCES: what is the cost of not forecasting well? (Stocking too little or too much product/ under or over staffing)

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

5 characteristics of a good forecast

A

quality
cost
responsiveness
timeliness
simplicity

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

responsiveness and timeliness analysis

A

responsiveness: the forecast should reflect changes in market conditions quickly; outliers should be addressed

timelinesS: forecasts should be available for when they are needed

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

simplicty characteristic analysis

A

output should be easy to understad and interpet

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

what is time series forecasting

A

set of observations on a quantitatiev variable collected over time

ex: daily weekly monthly quarterly figures on sales/costs/profits

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

what does time series forecasting assue

A

factors influencing past and present will continue in the future

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

5 trends for analysing forecasting patterns graphically

A

1) no trend (demand is stable)
2) linear trend (postive or negative)
3) cyclical/seasonal (yearly)
4)trend and cyclical
5) little or no historical data

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

how do you forecast if no historical data (3 methods)

A

intutition/qualiitative methods

lok at similar products

do a market survey

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

statiionary time series forecasting

A

no discernible pattern in data

inspect the data plotted over time and try to find a pattern

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

forecasting using time series analysis- if data is stable/showing no patterns what can you use

A

smoothing methods
1) simple moving average
2) weighted moving average
3) exmplonential smoothing

31
Q

forecastin gusin gtime serizes analysis- for data with patterns

A

trends (upward/downard)

cyclical seasonal

cyclaical/seasonal with trend (combo)

32
Q

cyclical vs seasonal

A

they are similar (Seasonal is actually a cyclical pattern)

seasonal is related to season, cyclcilat related to something else

33
Q

Naiive Approach
- is this a good forecasting technique

A

assume demand in next period is the same as demand in most recent period

if jan sales were 68 then feb is 68

NO!! NOT REALLY FORECASTING BRUH

34
Q

why is naiive approach good? bad?

A

cost effective and efficienct

can be a good starting point

35
Q

what is the “last period” tecnique?

A

naiive approach

36
Q

forecasting notation, Ft At et

A

Ft= forecast of unkown value for some
period t in future (prediction)

At= actual observen known value for some period t in future

et= error between actual and forecasted value

et= At-Ft

37
Q

3 forecasting smoothing methods

A

1) simple moving average (Average of several periods of data is the forecast [add up n prior period and divide by n for average])

2) weighted moving average (Allocate weights to prior periods)

3) exponential smoothing (choose alpha value for automativ weightings of a declining weighted moving average)

38
Q

WEIGHTED MOVING AVG LOGIC

hwo to calcualte weighted moving average

A

Most recent data is most accurate (weighted more)

1) assign weights to the different months
2) multiply weight by data
3) add up all products

39
Q

Simple exponential smoothing

A

basically you assign more weights to the recent data, less weight to the less recent data

our predicaiton for this month+alpha*error for this month

REARRANGE TO:
alphaActualT - (1-alpha)PredictedT

40
Q

notes about exponential smoothing method

A

-you are not going to use any ‘n’ value

  • to make prediction for march, you have to use the actual value from february and the prediction value from february as well
41
Q

simple exponential smootghin formula

A

prediction for future month= alphaactual value + 1-alphapredicted value

all the values on the RHS come from the current month (come from march if you are predicting for april)

42
Q

when do we use low values of alpha?

WHAT DOES IT MEAN IF ALPHA IS=0

A

when underlying average is fairly stablewh

alphaactual + (1-alpha)predicted
-> if alpha 0= we care about only the predicted, and ACTUAL demand is ignored

43
Q

when do we use high alpha value

WHAT DEOS IT MEAN WHEN ALPHA=1

A

when underlying average is likely change

alphaactual + (1-alpha)predicted
-> if alpha 1= we care about only the last actual demand of the last month- > “LAST PERIOD TECHNIQUE”

44
Q

how do you see if your forecasting method is good or not?

A

use the model on the past data to predict known data to see if it is useful ! how much error is there

45
Q

what should a good forecast look like

A

scattered around zero!!! (This means the error is 0)

46
Q

how do you select the model?

A

the one with least error

47
Q

how to choose the forecasting method

A

use all of the models on past data

see if iti s accurate-> use them in the future

graph the error values-> close to zero then good!

48
Q

Ex of annual, seasonal, monthly, weekly, daily product

A

christmas product, pumpking

plant ertilizer, posicles

banking, moving companies (end of month)

restaurants (depends on weekly promotions; wings on wednesday), bars, movies

traffice, fast food restaurants

49
Q

Forecast formula

A

base*cyclical index

50
Q

how do you forecast a cylical pattern? (3 steps)

A

1) use historical data, determine avg demand (set cyclical index=1.00)
CALCULATING THE BASE FOR THE FORECAST

2) use histroical data, caluclate cyclical endex for each period

3)Apply each periods cyclical index to forecast the demands

51
Q

How do you forecast a cyclical trend
[Simple steps]

A

1) how much data points do you have (dont count average or any summative value) BE VERY CAREFUL!!!

2) calculate the base (Average for every period)
>average annual demand/12
=average monthly demand

3)calculate the cyclical index
(Average for period / Average of EVERY period)
> If below 1.0 it is below average
> if greater than 1 it is above average

4) Add all the indexes up and when you add them, you should get this to be equal to the number of periods!!!!! (THIS IS HOW U KNOW U DID IT WELL)

52
Q

WHY IS forecasting so critical to a business

A

because businesses have toallocate resources before they know what demand is

53
Q

how to calculate simple moviing average

A

1) Add up previous FORECASTED n period values
2) divide by n

54
Q

what is a stationary time series

A

data that has no discernible pattern or trend

55
Q

Exponential smoothing carries along (implicitly) all historic demand data but weights recent demand more heavily similar to an “exponential” WMA.

A

Exponential smoothing carries along (implicitly) all historic demand data but weights recent demand more heavily similar to an “exponential” WMA.

56
Q

We call it simple eexponential smoothing because?

A

the alpha declines at an exponential rate

like a L shape

57
Q

plotting error meaning

A

et=At-Ft

if it is close to zero then it is a good forecast

if positive= actual demand higher than predicted
if negative= actual demand less than presicted

if 0= no error

58
Q

How do we measure how good a forecast is (3 ways)

A

1) Bias
2) MAD
3) Rise

59
Q

Performance Measures: Bias

A

average error= sum of all errors/n

60
Q

Performance Measures: MAD

A

mean absolute deviation=

sum of abs errors/n

61
Q

Performance Measures: RMSE

A

RMSE= sqrt((sum of error values squared)/n)

62
Q

another way to calculate RMSE?

A

Root of MSE

63
Q

What does MAPE mean

A

mean absolute percent error (for comparng datasets)

64
Q

how to compare and select forecasting models

A

1) identiy the forecasting methods and parameters
2) apply historical data and determine the errorcs (BIAS, MAD, RMSE)
3) select the best forecasting method (the one w lowest errors)

65
Q

for BIAS MAD RMSE what are the values we want (no error?)

A

lowest values (2/3 is good hard to have lowest error in all 3)

66
Q

what are non stationary models

A

models that have patterns

1) trend
2) seasonal
3) trends and seasonal combined

67
Q

Forecasting w Patterns: Trend

A

upward or downard movement in a time series

use a base+trend model

68
Q

Forecasting w Patterns: Seasonal

A

cyclical or repeating pattern in the data

use a “base* cyclical index “ tool
- avg demand=1
-above avg demand= >1
-below avg demand= <1

69
Q

Forecasting w Patterns: Trens and seasonal

A

combine the “base +trend” and the “base*cyclical index”

70
Q

what does trend mean?

how do you forecast trend?

A

it is persistent (positive or negative)

holts approach: Base+K(trend)

71
Q

How to calculate cyclical pattern

A

**FIRST: COUNT HOW MANY PERIODS YOU HAVE!!

1) calc average demand for a year
avg demand monthly= [average annual demand/12]
(set this as your 1.00 since 1.00 is the avg in cyclical index)

2) use hisotircal data, calculate cyclical index for each period
cyclical index= [average of period/average demand monthly]
(if <1 lower than avg, if >1 higher than avg)

3) applly each periods cyclical index to future demand
-> find next years average monthly demand
-> use the previous years corresponding month to caclulate average monthly demand
(cyclical index*average monthly demand)

72
Q

COMBO TIME! trend and cyclical index combo

A

Forecast= [Base + k(Trend)]*Cylical Index

BASE= avg quarterly attendance
Trend= given to you
Cyclicla INdex= calculated earlier

73
Q

How to deal with outliers in data

A

keep if relevant to your period

74
Q
A