Ch 3 forecasting techniques and routes l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Ch 3: Forecasting: Techniques and Routes PowerPoint PPT Presentation


  • 187 Views
  • Updated On :
  • Presentation posted in: General

Ch 3: Forecasting: Techniques and Routes. Introduction. Forecasting is the establishment of future expectations by the analysis of past data, or the formation of opinions. Forecasting is an essential element of capital budgeting.

Download Presentation

Ch 3: Forecasting: Techniques and Routes

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Ch 3 forecasting techniques and routes l.jpg

Ch 3: Forecasting:Techniques and Routes

Introduction

Forecasting is the establishment of future expectations by the analysis of past data, or the formation of opinions.

Forecasting is an essential element of capital budgeting.

Capital budgeting requires the commitment of significant funds today in the hope of long term benefits. The role of forecasting is the estimation of these benefits.


Forecasting techniques and routes l.jpg

Techniques

Routes

Top-down route

Bottom-up route

Qualitative

Quantitative

Delphi method

Nominal group technique

Jury of executive opinion

Scenario projection

Simple regressions

Multiple regressions

Time trends

Moving averages

Forecasting Techniques and Routes


Quantitative forecasting l.jpg

Quantitative Forecasting

Data set of ‘Sales’ as related to both time and the number of households.

Quantitative: Regression with related variable


Quantitative forecasting4 l.jpg

Quantitative Forecasting

Quantitative:Sales plotted related to households.


Quantitative forecasting5 l.jpg

Quantitative Forecasting

Quantitative:Sales regressed on households.

Edited output from the Excel regression.


Quantitative forecasting6 l.jpg

Quantitative Forecasting

Quantitative:Sales regressed on households.

Predicting with the regression output.

Regression equation is:

Sales(for year) = -348.218 + ( 3.316 x households).

Assuming that a separate data set forecasts the number of households at 1795 for the year 2006, then:

Sales(year 2006) = -348.218 + ( 3.316 x 1795)

= 5,604 units.


Quantitative forecasting7 l.jpg

Quantitative Forecasting

Sales as a function of both time and

the number of households.

Quantitative: Multiple Regression


Quantitative forecasting multiple regression line information l.jpg

Quantitative Forecasting:Multiple Regression Line Information

From the Excel spreadsheet.


Quantitative forecasting using multiple regression l.jpg

Quantitative Forecasting:Using Multiple Regression

Multiple regression equation is:

Sales in year = -382643.91 +(193.33 x Year) + (0.1368 x Households)

Forecast of sales for the year 2005 is:

Sales in year 2005 = -382643.91 + (193.33 x 2005)

+ (0.1368 x 1586) = 5200 Units

(Note: the sales forecast relies upon a separate forecast of the number of households, given as 1 586, for 2005.)


Quantitative forecasting10 l.jpg

Quantitative Forecasting

Quantitative: Time Series Regression

Sales plotted as a function of time.


Quantitative forecasting fitted regression line l.jpg

Quantitative Forecasting: Fitted Regression Line


Quantitative forecasting regression line information l.jpg

Quantitative Forecasting: Regression Line Information

From the Excel spreadsheet.


Quantitative forecasting regression line use l.jpg

Quantitative Forecasting: Regression Line Use

Equation for the regression line is:

Sales in year = -395541.56 + (199.87 x Year)

Forecast of sales for the year 2005 is:

Sales in 2005 = -395541.56 + (199.87 x 2005)

= 5198 Units

(Note: the large negative Y axis intercept results from using the actual calendar years as the X axis scale.)


Quantitative forecasting regression auto forecast by excel l.jpg

Quantitative Forecasting:Regression: Auto Forecast by Excel.


Quantitative forecasting moving average auto plot l.jpg

Quantitative Forecasting:Moving Average- Auto Plot


Quantitative forecasting notes on excel auto plot l.jpg

Quantitative Forecasting:Notes on Excel Auto Plot.

Excel will plot, and automatically forecast, a data series which has a functional relationship. For example, a regression trend line.

The auto plot is driven through the ‘Chart’ menu as ‘Add Trendline’. A particular forecast is specified via the dialog box.

Future point data values cannot be read from the automated trendline.

Non-functional relationships, such as a

moving average, can be plotted, but cannot be automatically forecast.


Forecasting routes l.jpg

Forecasting Routes

Top-Down

where international and national events affect the future behaviour of local variables.


Forecasting routes18 l.jpg

Forecasting Routes

Where local events affect the future behaviour of local variables.

Bottom-Up


Forecasting summary l.jpg

Forecasting: Summary

  • Sophisticated forecasting is essential for capital budgeting decisions

  • Quantitative forecasting uses historical data to establish relationships and trends which can be projected into the future

  • Qualitative forecasting uses experience and judgment to establish future behaviours

  • Forecasts can be made by either the‘top down’ or ‘bottom up’ routes.

Back to the Future!


  • Login