Slide1 l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 74

Basic principles and demand forecasting PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on
  • Presentation posted in: General

Lecture 3. Basic principles and demand forecasting. Inventory Control. February, 15th 2010 Hessel Visser www.hesselvisser.nl. Who is Hessel Visser?. ‘s-Gravendeel. Dordrecht. ‘s-Gravendeel. Noordhoff. CoLogic. Hogeschool Rotterdam. Enraf-Nonius. Fokker. Kluwer.

Download Presentation

Basic principles and demand forecasting

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


Slide1 l.jpg

Lecture 3

Basic principles and demand forecasting

Inventory Control

February, 15th 2010 Hessel Visser

www.hesselvisser.nl


Who is hessel visser l.jpg

Who is Hessel Visser?

‘s-Gravendeel

Dordrecht

‘s-Gravendeel

Noordhoff

CoLogic

Hogeschool Rotterdam

Enraf-Nonius

Fokker

Kluwer

2 x HTS en TU

Basic education

1950

1960

1970

1980

1990

2000

2010


What did i do l.jpg

What did I do?


Slide5 l.jpg

Logistics Tools for Management

DuPont chart

ABC-analysis

Relative Contribution

Forecasting

Qualitative forecasting

Quantitative Methods

Conclusions

Basic principles and demand forecasting


1 dupont chart l.jpg

Definition

DuPont Chart calculates the key components of any business for easy evaluation of performance.

www.businessplans.org/DuPontChart.html

1 DuPont Chart


Slide7 l.jpg

Page 167 WML 174


Slide8 l.jpg

Page 170 WML 177


2 abc analysis l.jpg

Definition

Analysis of a range of items, from inventory levels to customers and sales territories, into three groups: A = very important; B = important; C = marginal significance. The goal is to categorize items which would be prioritized, managed, or controlled in different ways. ABC analysis is also called 'usage-value analysis'.

2 ABC-analysis


Slide10 l.jpg

Page 173 WML 179


3 relative contribution l.jpg

Definition

Average contribution margin that is weighted to reflect the relative contribution of each operating department of a multi-department firm to its ability to pay fixed costs and to generate income.

3 Relative Contribution


Slide12 l.jpg

Page 175 WML 182


Slide13 l.jpg

Page 176 WML 183


4 forecasting l.jpg

Definition

Forecasting is the process of estimation in unknown situations. Prediction is a similar, but more general term, and usually refers to estimation of time series, cross-sectional or longitudinal data.

4 Forecasting


Types of forecasts l.jpg

Economic forecasts

Address business cycle, e.g., inflation rate, money supply etc.

Technological forecasts

Predict rate of technological progress

Predict acceptance of new product

Demand forecasts

Predict sales of existing product

Types of Forecasts


Demand patterns l.jpg

Dependent versus independent

Only independent demand needs to be forecasted

Dependent demand should never be forecasted

Demand Patterns

Seat

Handlebars

Wheels


What should be forecasted l.jpg

What Should Be Forecasted?

Level

Forecast

Time Frame

Business plan

Market direction

2 to 10 years

Sales and operations

planning

Product lines and

families

1 to 3 years

Master production

End items and

options

6 to 18

Months

schedule


Seven steps in forecasting l.jpg

Determine the use of the forecast

Select the items to be forecasted

Determine the time horizon of the forecast

Select the forecasting model(s)

Gather the data

Make the forecast

Validate and implement results

Seven Steps in Forecasting


Product demand charted over 4 years with trend and seasonality l.jpg

Seasonal peaks

Trend component

Actual demand line

Demand for product or service

Average demand over four years

Random variation

Year

2

Year

3

Year

4

Year

1

Product Demand Charted over 4 Years with Trend and Seasonality


Actual demand moving average weighted moving average l.jpg

Actual Demand, Moving Average, Weighted Moving Average

Weighted moving average

Actual sales

Moving average


Realities of forecasting l.jpg

Forecasts are seldom perfect

Most forecasting methods assume that there is some underlying stability in the system

Both product family and aggregated product forecasts are more accurate than individual product forecasts

Realities of Forecasting


Forecasting approaches l.jpg

Forecasting Approaches

Qualitative Methods

Quantitative Methods

  • Used when situation is vague & little data exist

    • New products

    • New technology

  • Involves intuition, experience

    • e.g., forecasting sales on Internet

  • Used when situation is ‘stable’ & historical data exist

    • Existing products

    • Current technology

  • Involves mathematical techniques

    • e.g., forecasting sales of color televisions


5 qualitative forecasting l.jpg

Definition

Qualitative forecasting methods are based on educated opinions of appropriate persons

5 Qualitative forecasting


Overview of qualitative methods l.jpg

Jury of executive opinion

Pool opinions of high-level executives, sometimes augment by statistical models

Delphi method

Panel of experts, queried iteratively

Sales force composite

Estimates from individual salespersons are reviewed for reasonableness, then aggregated

Consumer Market Survey

Ask the customer

Overview of Qualitative Methods


Jury of executive opinion l.jpg

Jury of Executive Opinion

  • Involves small group of high-level managers

    • Group estimates demand by working together

  • Combines managerial experience with statistical models

  • Relatively quick

  • ‘Group-think’disadvantage


Sales force composite l.jpg

Sales Force Composite

  • Each salesperson projects his or her sales

  • Combined at district & national levels

  • Sales reps know customers’ wants

  • Tends to be overly optimistic


Delphi method l.jpg

Iterative group process

3 types of people

Decision makers

Staff

Respondents

Reduces ‘group-think’

Delphi Method

Decision Makers

(Sales?)

(Sales will be 50!)

Staff

(What will sales be? survey)

Respondents

(Sales will be 45, 50, 55)


Consumer market survey l.jpg

Consumer Market Survey

  • Ask customers about purchasing plans

  • What consumers say, and what they actually do are often different

  • Sometimes difficult to answer

http://blogs.zdnet.com/emergingtech/?m=200701&paged=1


6 quantitative methods l.jpg

Definition

Time series forecasting methods are based on analysis of historical data (time series: a set of observations measured at successive times or over successive periods). They make the assumption that past patterns in data can be used to forecast future data points.

6 Quantitative Methods


Quantitative forecasting methods non naive l.jpg

Quantitative Forecasting Methods(Non-Naive)

Quantitative

Forecasting

Associative

Time Series

Models

Models

Linear

Moving

Exponential

Trend

Average

Smoothing

Regression

Projection


What is a time series l.jpg

Set of evenly spaced numerical data

Obtained by observing response variable at regular time periods

Forecast based only on past values

Assumes that factors influencing past and present will continue influence in future

Example

Year:20032004200520062007

Sales:78.763.589.793.292.1

What is a Time Series?


Time series components l.jpg

Trend

Cyclical

Seasonal

Random

Time Series Components


Slide35 l.jpg

Page 180 WML 187


Forecast errors l.jpg

Forecast errors


Slide37 l.jpg

Page 181 WML 188


Slide38 l.jpg

Page 182 WML 189


Slide39 l.jpg

Tracking the Forecast

Forecasts are rarely 100% correct over time.

Why track the forecast?

  • To plan around the error in the future

  • To measure actual demand versus forecasts

  • To improve our forecasting methods


Conclusions about logistic tools for management l.jpg

Start with Simple Tools

Collect Data in an Early Stage

Integrate Tools as much as possible

Conclusions about Logistic Tools for management.


Slide41 l.jpg

It’s all about inventory

Inventory Definitions and Goals

Inventory Turnover

Inventory Management

Inventory Costs

Conclusions

Inventory Control


1 inventory goals l.jpg

1 Inventory Goals


What is inventory l.jpg

What is Inventory?

Inventory is a list for goods and materials, or those goods and materials themselves, held available in stock by a business. Inventory are held in order to manage and hide from the customer the fact that manufacture/supply delay is longer than delivery delay, and also to ease the effect of imperfections in the manufacturing process that lower production efficiencies if production capacity stands idle for lack of materials.


Why inventory control l.jpg

Why Inventory Control?

Stock is the insurance premium for the fear of getting non-sales.


2 inventory turnover l.jpg

2 Inventory Turnover


3 inventory management l.jpg

3 Inventory Management

Inventory Management Involves a retailer or any other piece of the supply chain seeking to acquire and maintain a proper merchandise assortment while ordering, shipping, handling, and related costs are kept in check.


4 inventory costs l.jpg

4 Inventory Costs


5 order points l.jpg

5 Order points

1. That point at which time a stock replenishment requisition would be submitted to maintain the predetermined or calculated stockage objective.

2. The sum of the safety level of supply plus the level for order and shipping time equals the reorder point. See also level of supply.


6 safety stock l.jpg

6 Safety Stock

Safety stock: Quantity of inventory used in inventory management systems to allow for deviations in demand or supply.


Try to get rid of stock l.jpg

Try to get rid of stock


Inventory management l.jpg

Inventory Management

Although stock is an expensive part of our business, we can’t get it back to zero. Somewhere in the chain we have to have a point where we have to keep a safe quantity of goods available to the customers wishes.


  • Login