FOR
MANAGEMENT
Forecasting
Barry Render / Ralph M. Stir, JR.
Summarized by - NOPPOL BEOKHAIMOOK
Learning Objectives (1)
Students will be able to:
– Understand and know when to use various families of forecasting models
– Compare moving averages, exponential smoothing, and trend time-series models
– Seasonally adjust data.
– Understand Delphi and other qualitative decision-making approaches
1
Learning Objectives (2)
Students will be able to:
– Identify independent and dependent variables and use them in a linear regression model.
– Compute a variety of error measures. 2
Topics (1)
•
Importance of Forecasting
• Steps of Forecasting
• Types of Forecasting
• Scatter Diagrams
• Time-Series Models
• Moving Averages
• Exponential Smoothing
• Trend Projections
3
Topics (2)
•
Seasonal Variations
• Cyclical Variations
• Causal Forecasting Methods
• Regression Analysis
• Monitoring and Controlling Forecasts
• Using the Computer to Forecast
• Key Equations
• Summary
4
Schedule
• #1 - Friday, 22/04/2011 : 18.00 -21.00
• #2 – Saturday, 23/04/2011 : 9.00 -12.00
• #3 - Saturday, 23/04/2011 : 13.00 -16.00
• #4 - Friday, 29/04/2011 : 18.00 -21.00
• #5 - Friday, 06/05/2011 : 18.00 -21.00
(Work-shop)
• #6 - Friday, 20/05/2011 : 18.00 -21.00
4.1
Corporate Planning (1)
• Determine organization : 5W1H
- WHY it should do ?
- WHERE it should be ?
- WHAT it should do ?
- WHEN it should do to be done ?
- WHO should do ?
- HOW it should do ?
5
Corporate Planning (2)
• A deliberate and conscious attempt to anticipate and “Forward Look” the environment.
• Looking ahead systematically.
6
Planning Steps (1)
• ASSESS - Internal and Environment
Factors (SWOT)
• FORMULATE - Corporate Objectives,
Strategies and Action Plans
• CASCADE - Corporate Objectives,
Strategies, Action Plans down to Lower
Levels (One Layer at a time)
7
Planning Steps (2)
• QUANTIFY - Action Plans &
Strategies into Budgets starting with lowest Operating Unit.
• CONSOLIDATE - Budgets upwards until the corporate level is reached.
• IMPLEMENT - Plans
• MONITOR - Feedback and Control
8
Desirable Attributes of Good Objective
• ADAPTABLE - Changeable and Flexible.
• MEASURABLE - The results can be readily quantified and evaluated. • COMMITMENT - Capable of inspiring Commitment
9
Objectives Perspective
• FINANCIAL PERSPECTIVE
• CUSTOMER PERSPECTIVE
• INTERNAL PROCESS
PERSPECTIVE
• LEARNING AND GROWTH
PERSPECTIVE
10
Importance of Forecasting
Business Planning
(Demands for products, Return on Investment,
Sales Volume, Expense, etc.)
Analytical Tools
Mathematical Techniques
Forecasting
11
Steps of Forecasting (1)
1. Determine the forecast objective
2. Select the items or quantities to be forecasted
3. Determined time horizon of forecast
- Short term / Medium term / Long term
4. Select Forecasting MODEL (S)
5. Gather data needed to make the forecast
6. Validate forecasting model
7. Make the forecast
8. Implement the results
12
Steps of Forecasting (2)
•
Initiating, designing, implementing forecasting system ==> Systematic way and Automatically
• Computer System
==> Input (Files / Records)
Processing (Software / Program)
Output (Files / Reports)
• No Single method is superior, whatever
(quantitative, subjective, mixed) works best should be used
13
Types of Forecasting (1)
Figure 5.1 - Forecasting Models Discussed
Forecasting
Techniques
Qualitative Models
Time Series Methods
Causal Methods
Delphi Methods
Moving Average
Simple Regression
Jury of Executive
Opinion
Exponential Smoothing
Multiple Regression
Sales Force Composite
Consumer Market
Survey
Trend Projections
Decomposition (T*S*C*I)
14
Types of Forecasting (2)
•
Time-Series Models
– Use past data to make a forecast over
a period of time
– Three techniques of time-series models
1. Moving Average
2. Exponential Smoothing
3. Trend Projections
15
Types of Forecasting (3)
• Causal Models
– Incorporate the variables that might influence the quantity being