Analysis On Forecasting

Submitted By galaxy435
Words: 5226
Pages: 21

QUANTITATIVE ANALYSIS
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