Demand Planning.Net
demand planning, forecasting, and exception management

Demand Planning and Forecasting Workshop - Dallas, TX

Improve Forecasting with better Models and Diagnostics!

Feb 27 (Wed) & 28 (Thur), 2013 - 2 Day Interactive Workshop in Dallas, TX at
The Double Tree Dallas-Campbell Center

view and print seminar brochure (PDF)

Register Now! $995 Group Discount of 10% for three or more participants from same company & one payment. 

Interested in our SAP APO 3rd Day? CLICK HERE

In this specialized two-day course, we will explain the modeling methodology and process behind accurate demand forecasts and how to effectively use promotional information to arrive at a consensus forecast. The focus will be on demand modeling using statistical techniques, the methodology to perform model diagnostics, forecast accuracy measurement and the process to incorporate market intelligence.

If you are a new demand planner looking to enhance your knowledge of business forecasting, you cannot afford to miss this opportunity!

Get skills you can use at work

We will explain and demonstrate best practices in model selection, illustrate how to improve model quality, and teach you how to leverage forecast measurement process.

 
Learn from industry experience

We will bring practical examples from our consulting experience

 
Network with peers

You will have the opportunity to meet, interact, and learn from other demand planning professionals with team challenges and networking exercises.

 
Add to your credentials - This is a pre-requisite for our Certification

Upon completion, you will be awarded a certificate of completion from Demand Planning LLC, attesting to your newly-acquired skills in Demand Planning and Forecasting.

Detailed Outline of the Workshop:

Day 1

8:30AM to 5:00PM

Day 2

8:30AM to 4:30PM

  • 8:30 to 10:00am Why SIOP – Round Table Discussion
  • 8:30 AM Welcome
  • 9:00 AM Demand Planning Overview
    • Why Forecast and Plan?
    • The Service – Cost – Balance Model
    • Introduction to Demand Planning- What, Why and How?
    • Distinction between Business Forecasting and Demand Planning
    • Beyond Statistical Forecasting
    • Key Components of a Demand Plan
    • Key Terminology – Forecast Horizon, Buckets & Periodicity
    • Constrained vs. Unconstrained forecasts
    • Constrained vs. Unconstrained forecasts
  • 10:30 AM Coffee Break
  • 10:45 AM Data Cleaning and Adjustments for Demand Forecasting
    • What do we know about data?
    • The Forecast Problem and Data collection
    • What is Demand – shipments vs. orders
    • Gross Demand vs. Net Demand
    • Data cleaning challenges
    • Data cleaning challenges
    • Data filtering
    • Outliers
    • Process to Identify Outliers
    • Methodology for outlier correction
  • 12:30 PM Lunch Break
  • 1:30 PM Data Analysis and SKU Segmentation
    • Simple Model of Demand
    • Demand Volatility
    • What is the approach to data analysis?
    • Impact of Data volatility on Forecasting
    • Measuring volatility
    • Impact of multiple Extreme Observations on Volatility
    • SKU Segmentation for Forecast Modeling
    • Volume Volatility a 2x2 Grid
    • Modeling by Exception
  • 2:30M Coffee Break & Networking Exercise
  • 3:00 PM Demand components & Graphical Decomposition
    • Predictable and Unpredictable Volatility
    • Illustration of Demand components
    • Key Components of Demand
    • Understanding the components
      • Trend
      • Seasonality
      • Cyclicality
    • Graphical Decomposition
  • 4:30 PM Assignment of Forecasting exercises to participants
  • 8:30 AM Forecast Errors and Model Diagnostic
    • Definition of Demand Forecast Errors
    • Errors Over Time vs. Error Across Products
    • Model Errors defined
    • Definition of MPE, MAPE, WAPE and RMSE
    • Model Diagnostics through Forecast Error
  • 9:30 AM Modeling by Decomposition
    • Forecast Model
    • Uni-variate time series Models
    • Forecasting by Decomposition using Excel
    • Calculating Trend using Regression Model
    • De-Trending the Series
    • Building A Seasonal Index
    • Adding Trend and Seasonality back
    • Create the Forecasts
  • 10:30 AM Morning Break
  • 10:45 AM Statistical Modeling
    • Introduction to Forecast Modeling
    • Qualities of a good Statistical Forecast
    • Balancing between Model Fit vs. Model Robustness
    • Time Series vs. Multi-Variate Methods
    • First Order Exponential Smoothing or Constant Models
    • Holt Models to accommodate Trend
    • Holt Winters Models
    • Exponential Trend and Dampening
    • Additive vs. Multiplicative Seasonality in Models
    • Multiple Linear Regression Models in Excel
    • Event Modeling
  • 12:30 PM Lunch Break
  • 1:30 PM Discussion and answers assigned exercises
  • 2:45 PM Planning for Intermittent Demand
    • Intermittent Demand
    • Stat modeling of intermittent demand
    • What is intermittent demand?
    • What causes intermittency?
    • Strategies to handle intermittent demand
      • Supply Chain Strategy
      • Sales and Marketing Intelligence
      • Segmentation
      • Stat Modeling
    • Application of Croston’s model
    • Discrete Distribution
  • 3:30 PM Measuring forecast performance and S&OP
    • Forecast errors and actionability
    • Sources of Forecast Error
    • Definition of Demand Planning Metrics – WAPE and Bias
    • Types of Bias
    • SKU Mix Error
    • Error Analysis for continuous improvement
    • Brief Introduction to S&OP
    • Demand Supply Balancing
    • Process Flow for S&OP
    • S&OP Monthly Planning Cycle

Register Now!

Pricing

An additional 10% discount applies to group registrations of three or more using one payment method.

©2004-2009 by Demand Planning, LLC. All rights reserved. Privacy policy | Refund and Exchange policy | Terms of Service | FAQ
Demand Planning, LLC can be reached at 10G Roessler Road, Woburn, MA 01801 | Phone: (781) 995-0685 | info @demandplanning.net

Consulting

 Diagnostic |  DP Design |  Exception Management |  S&OP |  Solutions

Training

 Demand Planning |  S&OP |  Retail Forecasting |  Supply Chain Analysis:  » Value Chain Metrics  » Inventory Optimization |  Supply Chain Collaboration

Industry

 CPG/FMCG |  Food and Beverage |  Retail |  Pharma |  High Tech |  Other

Knowledge Base

 Planning:  » Budgeting » S&OP |  Metrics: » Demand Metrics » Inventory  » Customer Service |  Collaboration:  » VMI & CMI » Account Based Forecasting
Forecasting:  » Causal Modeling  » Market Modeling  » Ship to Share |  For Students