Chapter 8: Forecasting Flashcards
Basic time series patterns
Horizontal
Trend
Seasonal
Cyclical
Random
Horizontal time series
Fluctuation of data around a constant mean
time series
The repeated observations of demand for a service or product in their order of occurrence
Trend time series
Systematic increase or decrease in the mean of the series over time
(moving in one direction)
Seasonal time series
A repeatable pattern of increases or decreases in demand, depending on the day, week, month or season
Cyclical time series
Less predictable gradual increases or decreases in demand over longer periods of time (years or decades)
Arises from two influences:
- business cycle
- service or product life cycle
Random time series
Unforecastable variation in demand
Service (product) life cycle
Stages of demand from development through decline
Demand management options
Processes to influence demand
Complementary products
Promotional pricing
Prescheduled appointments
Reservations
Revenue management
Backlogs
Backorders and stockouts
Forecasting
Complementary products
Services or products that have similar resource requirements but different demand cycles (use existing resources)
Prescheduled appointments
Ensures that demand does not exceed supply capacity
Revenue management
Aka yield management
Varying price at the right time for different customer segments to maximize revenue yielded by existing supply capacity
Mix of promotional pricing and reservations, works best when customer population can be segmented and prices varied by segment
Backlog
An accumulation of customer orders that a manufacturer has promised for delivery at a future date (grows during periods of high demand and shrinks during period of inactivity)
Use if planned lead times
Stockouts
An order that cannot be satisfied resulting in loss of the sale
With backorders: last resort demand management. Setting of lower standards
Aggregation
The act of clustering several similar services or products so that forecasts can be made for whole families (forecast for groups first and then break down to individual SKUs)
Types of forecasting techniques
- Judgement methods (opinions and estimates -> quantitative estimates)
- causal methods (use of historical data on independent variables)
- time series analysis (statistical analysis of historical demand to estimate future demand)
- trend projection with regression (combines causal and time series)
Forecasting error
The difference found by subtracting the forecast from the actual demand for a given period
Five basic measures of forecast error
Cumulative sum of errors
Mean squared error
Standard deviation of errors
Mean absolute deviation
Mean absolute percent error
Cumulative sum of forecast errora
CFE = sum total of all errors for a given set of periods
Also called bias error: assesses bias in the forecast (consistently below (CFE gets larger each period) or consistently above demand)
Mean bias
Aka average forecast error
= CFE / number of periods
Mean squared error
MSE
= (Sum of all (Error squared))/number of periods
Measurement of dispersion of forecast errors
Because error is squared the MSE gives more weight to large errors
Standard deviation of errors
σ
= (sum of all ((total forecast error - average forecast error) squared))/ (n-1)
Measurement of the dispersion of forecast errors
Because error is squared standard deviation gives more weight to large errors
Mean absolute deviation
MAD
= (Sum of all absolute values of errors) / number of periods
Measurement of the dispersion of forecast errors
Most widely used, does not differentiate between underestimate and overestimate
could also be calculated using an exponential smoothing method
= alpha * absolute value of error + (1-alpha) * MAD of previous period
Interpreting measures of dispersion errors
If small then the forecast is typically close to actual demand. Large = potential for large forecast errors
essentially shows how uncertain demand is
Mean absolute percent error
MAPE
Relates forecast error to level of demand. Useful for perspectives on forecasting performance
= (Sum of all (absolute value of error for the period / actual demand for the period)) * 100/ number of periods
The percentage error based on total demand
History file
Collection of past data used to determine if forecasting method has merit
Salesforce estimates
Forecasts that are compiled from estimates of future demands made periodically by members of a company’s salesforce
May need to be adjusted to account for individual bias
Executive opinion
Forecasting method in which the opinions, experience, and technical knowledge of one or more managers are summarized to arrive at a single forecast
Technological forecasting
An application of executive opinion to keep abreast of the latest advanced in technology
Market research
A systematic approach to determine external consumer interest in a service or product by creating and testing hypotheses through data-gathering surveys
Delphi methid
A process of gaining consensus from a group of experts while maintaining their anonymity
Used when no historical data is available/ managers lack applicable experience
Causal methods of quantitative forecasting
Used when:
- historical data is available
- relationships between the factor being forecasted and other internal or external factors can be identified
Linear regression
Linear regression
A casual method in which one variable (dependent) is related to one or more independent variables by a linear equation
Dependant variable is the one that is being forecast
Linear regression equation
Y= a + bX
Where:
a = Y intercept (X= 0)
b = slope of the line
Goal of linear regression to find values of a and b such that the sum of squared deviations from the actual data to the line is minimized
Linear regression measures of forecast accuracy
Sample correlation coefficient
Sample coefficient of determination
Standard error of the estimate
Sample correlation coefficient
r
Measures the direction and strength of the relationship between the dependent and independent variables
Range from -1 (x and y move in diametrically opposite directions) to 1 (x and y move in the same direction)
0 = no linear relationship
The Stronger the relationship the closet the value to +/- 1