Tento seminář je pořádán v angličtině 
.
Advanced Executive Education Series
Building a Demand-Driven Supply Chain through
Integrated Business Management
– from Execution to Optimisation
From Basic Demand and Supply Balancing to Strategic Management Excellence
Workshop details:
- May 22nd-23rd, 2023 from 9AM to 6PM CET (UTC+2)
- Venue: Prague International Business School (PIBS), José Martího 2/407, 162 00 Prague 6 – Veleslavín, CZ, map details
- Hotel available at venue: Hotel Krystal
- Workshop is held in English
- Detailed program of the workshop is below
- Please register here. The number of seats is limited to ensure the quality of the workshop.
Practical and comprehensive workshop for management and practitioners – from data collection, segmentation and presentation to sophisticated forecasting techniques that will improve your bottom line and increase your competitive position in the market.
- Why should you attend?
- How will you benefit?
- How this program can help companies in tough times like this?
- Who should attend?
- Program content
- Registration
- Client’s Testimonials
Why should you attend?
- Designed by professionals with combined 50+ years of practical business forecasting / demand planning experience.
- Layered hands-on Excel exercises that foster stronger understanding and retention of materials covered during the workshop.
- Practical understanding of leading forecasting software and systems including SAP APO, JDA MANUGISTICS, JDA i2, Forecast PRO. FuturMaster and other to facilitate the discussion pertaining to software selection / use and program content applicability to individual systems.
- Workshop aligned with Institute of Business Forecasting and Planning (IBF) Advanced Certified Professional Forecaster (ACPF) designation.
- 60 days post–workshop support via phone/email on workshop covered materials / topics
- Web forum for workshop participants to enable them to consult with their peers and/or escalate the questions directly to Jaguar-APS.
How will you benefit?
- Establish a process for effective forecasting.
- Select the forecasting and analytical techniques most appropriate for any given forecasting problem.
- Learn how to analyse historical data fast and accurately to improve statistical forecast quality and accuracy.
- Understand how to evaluate performance of a statistical model.
- Learn how to interpret ‘residuals’ and model diagnostics to support effective model-building effort.
- Benefit from understanding techniques of combining various forecasts to improve forecast accuracy and stability.
- Gain solid understanding of data and the processes generating data and forecasts, thus increasing the ability to manage your staff’s time required to produce more accurate forecasts and decreasing dependence on software logic.
- Understand the exception driven forecast process and how to implement it in your organization.
- Learn the ways to incorporate market data into statistical forecasting.
- Explore various techniques used to transform data to improve the quality of statistical forecast.
- Understand various trends and how they impact your forecasts.
The course
The workshop is specifically designed to address key issues in the minds of those with management and executive responsibilities and those who work alongside them. The objective of this course it to provide business professionals with a set of data and forecasting procedures and to demonstrate with illustrative examples how such procedures are used in data preparation and model building and forecasting. The course focuses on conceptual framework of models, and thus providing a clear vision of what each model represents, it’s underlying assumptions and what its model statistics imply. Such understanding helps forecasters and business professionals not only in evaluating models but also in selecting the right one for preparing forecasts. The limitations of each of the models are pointed out throughout the course as well. The main goal is to show the application of models in forecasting and the importance of quality of the data used to generate the forecasts. The most important thing for practicing forecasters and their management is to understand the concept, how a model works, how to evaluate it, and how to go about to improve upon it. The requirements of mathematics are kept to a minimum, as most of the forecasting software systems do this on their own.
There are many software packages in the market which have a built in expert system that automatically selects the ‘best’ model (aka ‘best fit’) and then provides the resulting forecasts. However, with the expert system comes the danger of ‘black box’ forecasting. The model selected by software may or may not be the best one. To avoid black box model building, it is important for forecasters to understand what goes behind each model, as well as how and why a given model is chosen. On this account, we will discuss in detail what goes behind each model. We will use real data examples throughout the course to give the live experience from variety of industry sectors. Our goal is to discuss those topics, which have a real application in business and are easy to apply.
This course provides a combination of best practices in data management, segmentation and cleansing approaches required for sound statistical forecasting and forecast presentation … blending years of experience as first-line practitioners and managers with years of management consulting practice as well.
Special segment of the workshop is dealing with application of different forecasting methods to make better business forecasts during times of high uncertainty, pandemics (SARS, COVID-19), trade wars and increased tariffs.
IMPORTANT:
To translate and expedite classroom learning to real-life applications, participants are HIGHLY ENCOURAGED bringing their own laptops. BRING YOUR OWN DATA: we have allocated time to work with individuals on their specific need. |
How this program can help companies in tough times like this?
In the face of fast-paced globalization of economies and increasingly intensified competition, rarely a day goes by without an announcement of a new product launch, an existing one discontinued or modified, a set of new features added to make products more effective, convenient and innovative. At the same time, when customers are demanding faster delivery and quicker service, organizations often lack the resources and the expertise in order to effectively manage a leaner supply chain required to meet these challenges. As the economic uncertainties unfold many executives with supply chain and logistics responsibilities are either working in “survival mode” or moving forward and beginning to make their supply chains more responsive, flexible, and efficient.
Making improvements in Demand Management is one of the most critical factors to be able to attain a lean Supply Chain, since a clear correlation exists between High Forecast Error and Missing Market Share, Lost Sales, Dissatisfied Customers, Obsolescence or Wasted Expenditures.
Industry leaders and decision makers need to re-examine the way businesses think about the future. Leadership in Demand Chain Management results in increased customer satisfaction, increased revenue, and increased profit levels on the bottom line. This sets your company apart from the competition.
This workshop also makes specific recommendations for those striving to move up the demand forecasting maturity curve by providing you with new tools that speed up the validation of your data used for forecasting, increasing effectiveness of use of the software you have invested in and significantly increasing productivity of your forecasting staff.
Who should attend?
EDs, Directors, Managers, Analysts, of:
|
|
Note: The detailed content of the workshop may be adjusted without prior notice to better reflect singed-up participants needs.
Program Content
Module 1:
Approaching Forecasting
- Forecasting Where?
- Goal definition
- Forecast Horizon and Updating
- Forecast Use
- Level of Automation
Data
- Collection
- Time Series Components
- Visualizing Time Series
- Interactive Visualization
- Data Quality
- Pre-processing & Cleansing
Case study and Exercise: Outlier recognition and treatment – Hands-On – Laptop required
|
Performance evaluation
- Data cleansing
Module 2:
Forecasting Methods Overview
- How much data to use for different statistical models?
- Choosing best model for forecasting based on different data patterns and properties
- What are the model selection criteria?
- Consideration of decisions for which model is developed
- Exploring the essential elements of Time Series Models:
- Inherent assumptions
- When Time Series work and when it doesn’t work
- Level, Trend, Seasonality, Cyclicality, and Randomness
Group Exercise: Exponential Smoothing and Averages – Hands-On – Laptop required
Delegates will explore simple forecasting models by building them in MS Excel. These models are common to all forecasting systems in the market. Many forecasters create higher forecast error by simply not understanding the impact of changing the models or their statistical parameters. By building these models in excel, delegates will solidify their knowledge of these critical base concepts. |
Group Exercise and Discussion: Seasonal Decomposition – Hands-On – Laptop required
Delegates will analyze sales data to find patterns in past sales that they can use to predict future sales. As they find a pattern, delegates strip it away from the data, changing the shape of the data that remains. Then delegates will look for new patterns and strip them away. Delegates continue to strip away patterns until only unexplained fluctuations remain. Understanding this technique is fundamental to successful statistical forecasting using ANY commercially available software and system. |
Group Exercise and Discussion: Triple Exponential Smoothing – Hands-On – Laptop required
Delegates will explore hands-on the most widely used statistical forecasting model. Understanding this model is fundamental to successful statistical forecasting using ANY commercially available software and system. |
Cause and Effect Models
- Exposing to key assumptions of Regression Models
- When to utilize Regression Models for best forecasting result?
- Steps in developing regression model for high accuracy forecasting
- Taking in consideration of effects of holidays and promotional season on causal model forecasting
Case Study and Group Exercise – Hands-On – Laptop required
Advertising Expenditure vs. Market Share: Delegates will explore application of regression analysis as a ‘What-If?’ tool that can be used during their demand review meetings. Inkjet Photo Paper Inc.: Delegates will develop regression model incorporating external data (sales of inkjet printers) into their forecasting model. Case Study and Group Exercise: Forecasting in times of pandemics (SARS, COVID-19), trade wars and new import tariffs: Delegates will develop several forecasting models to predict future based on changing business rules and decide on which method is best to use. |
Module 3:
Forecasting of promotions
- Understanding factors in developing promotions forecasts and sources of dad information for promotions forecasting
- Developing promotional forecasting model that combines statistical time series forecasting with historical sales data and promotional information
- Managing the process for unplanned and abnormal demand in market
- Differentiating between seasonal profiles and promotional impacts
- Separating promotional effects from forecasting baseline
- Disclosing promotions forecast error
Group Exercise: Incorporating promotions into Statistical Forecast – Hands-On – Laptop required
Delegates will use dummy variables – a multiple regression forecasting technique – to incorporate impact of irregular promotional activity and other one-of-a-kind events that simple forecasting methods cannot capture. |
Group Exercise: Regression for Promotional Planning – Hands-On – Laptop required
Delegates will use sales and price data along with dummy variables to develop “what-if’ forecasting model that will aid management in making decisions about the best pricing strategy for upcoming promotions. |
Module 4:
New product forecasting
- What are issues to consider when developing new product forecasts?
- Understanding quantitative and qualitative methods for new product forecasting:
- Customer survey
- Consumer Panel
- Test Marketing
- Scanner Panel Data
- Maximizing new product forecasting success rate and minimizing error rates through specifying new product success and failure factors
- Early monitoring market response to new product introductions to minimise forecasting errors and potential inventory excess
Case study and Group Exercise: New Product Forecast Template – Hands-On – Laptop required
|
Module 5:
Forecast error metrics
- Detecting biased forecast as early as possible through determining forecasting error metrics and sources of error
- Spotting forecasting problems and processing error remediation to take initial correction
- Managing demand control processes to formally manage short term fluctuations
- Measuring accuracy of the forecast, other vital demand information and controlling inbuilt levels of agreed inaccuracy
- Discovering Forecast Value Add Analysis (FVA) to identify waste and factors that diminish accuracy
- Monitoring accuracy of forecasting through exception reports in action
- Leveraging on Error Measures to calculate safety stock level
Case study and Exercise – Hands-On – Laptop required
|
Module 6:
Communication and Maintenance
- Future Forecast
- Sales and Operations Planning process
- Consensus Forecast process
Module 7:
Taking it Home
- Group discussion and closing of workshop.
Registration
Please fill in the form to register. The number of seats is limited to ensure the quality of the workshop.
- Early bird discount of 10% is applicable for registrations before April 24, 2023.
- Additional discount of 10% is applicable when signing up for 2 workshops or when at least 2 colleagues from the same company sing up for any workshop.
Client’s Testimonials
“Charles is a fully committed and highly skilled professional. During the project we handled together, his help and strong knowledge about both organizations and supply chain have been definitely key success factors. I hope working again with him, without any doubt.”
DIRECTOR OF SALES AND OPERATIONS, FUTURMASTER FRANCE
“The trainer is an indisputable expert in his field. He can manage the technical details and yet never lose sight of the broad business perspectives.”
FINANCE DIRECTOR, J&J
“The course was an eye-opener for me and had revealed new ideas and processes that I did not imagine before. I had a misconception of IBP/ES&OP as a difficult and impractical process. Through the course, I had learned that it was not a set of rules and KPI’s, but rather a means for collaboration and consensus-based decisions. We were able to set-up a practical IBP/ES&OP process within the company that allowed us to focus on common objectives, and a process that was accepted across the different functions, and with the full support of the general manager.”
SUPPLY CHAIN DIRECTORY, SANOFI – AVENTIS SINGAPORE
“The trainer has a lot of real life examples to relate to training materials – fantastic.”
Merchandising Manager, COURTS MAMMOTH SB
“The trainer helped direct the company to better forecasts, IBP/ES&OP process improvements and better systems and tools. He managed complex projects very successfully.”
SENIOR MANAGER, SUPPLY CHAIN MANAGEMENT, WARNER LAMBERT
“Good. Can relate to real issues”.
SENIOR OPERATING OFFICER, PADIBERAS NASIONAL BHD (BERNAS)
“The most valuable outcome of the workshop was that the team got believed on the importance of working in integrated environment and understand the importance of having a process such as the IBP/ES&OP where all company must working toward one objective, and having a transparency across the entire IBP/ES&OP process.“
VICE PRESIDENT – SUPPLY CHAIN, AL-NAHDI MEDICAL COMPANY, SAUDI ARABIA
“The workshop matches my expectations. I aimed to understand forecasting theory, industry environment, and gain experience on existing tools. The workshop was practical with series of hands on activities. Although I am not responsible for hands on, it provided condense environment for me to experience execution.”
SENIOR DIRECTOR SUPPLY CHAIN & QA, McDONALD’S (China) Co., Ltd.
“Charles is a very experienced speaker and the whole training has been going on smoothly and served the purpose. Clear and precise presentation. Good references examples of each topic discussed.”
MARKETING PLANNING MANAGER, CONTINENTAL SIME TYRE, MALAYSIA
“Charles has a wealth of experience of demand/supply planning & IBP/ES&OP from a range of clients. This comes across from the use of examples in industry. I left knowing considerably more about IBP/ES&OP and one-number forecasting than at the start of the day.”
PhD Candidate in Management Science, Lancaster Research Centre for Forecasting, Department of Management Science, United Kingdom
“The most valuable outcome were the hands-on activities that gave the participants first-hand experience in dealing with IBP/ES&OP issues such as: different views of forecast, different interest of different department in the business and the advantages of establishing a single view of demand and supply.”
VP BUSINESS DEVELOPMENT, ISCS