Demand Planning and Sales Forecasting

Loading...
  •  Demand Planning and Sales Forecasting Training
  •  2 days, 09:00–16:00
  •  Open to public: Virtual Classroom (Online)
  •  In-house: Closed Session (On-site)
  •  English
  •  Hands-on Forecasting Examples
  •  Certificate of Attendance
  •  500+ participants, 100+ companies
  •  Instructor: Dr. İlker Güçlü
PETROL OFISI logo
“We had a productive two-day training. As a company, we identified our shortcomings and found opportunities to improve.”
Yigit Doruk Turguter, Senior Engineer in Production and Demand Planning, Petrol Ofisi (2024)
PANASONIC logo
“I believe that reviewing the statistical forecasting infrastructure effectively, and gaining a holistic methodological perspective by involving all stakeholders, is a very valuable outcome that will drive continuous improvement.”
Mesut Tok, Demand Planning Manager, Panasonic (2023)
ANADOLU EFES logo
“It lets you look at the demand forecasting process from a higher level. Because examples from different sectors are given, you also get a chance to benchmark. It explains with examples how to make accurate and sensible forecasts using statistical methods. You also get to work through prepared Excel files together.”
Ender Erdogmus, Production Planning Manager, Anadolu Efes (2021)

  About the Training Program

  Demand planning focuses on producing accurate and reliable sales forecasts.

  Day 1 covers the forecasting process, core methods, accuracy and forecast bias.

  Day 2 covers advanced forecasting methods, data quality and process improvement.

  New products, promotions, intermittent demand and machine learning are discussed with exercises.

  The forecasting process is linked to S&OP/IBP.

  For in-house trainings, a maturity assessment and an action plan can be provided.

  Presentations and all printed training materials distributed to participants are in English.

  To learn more about demand planning, click here.

By the end of the training, participants will be able to:

  Design the demand planning process with horizons, levels and roles.

  Select and apply forecasting methods suited to the demand pattern.

  Improve the process by measuring accuracy, bias and FVA.

  Manage special cases such as new products, promotions and intermittent demand.

  •   Demand Management, Demand Planning
  •   Sales Management
  •   Marketing Management
  •   Sales Operations
  •   Supply Chain Management
  •   Production Planning
  •   Finance, Budgeting
  •   Logistics Management
  •   IT Management
  •   Those seeking a career in demand planning

  Training Content

    Day 1:

    Forecasting Processes,
    Basic Methods and Accuracy

  • Factors Affecting Demand
  • Who Produces and Uses Forecasts?
  • Horizons, Periods, Frequency, Pyramid
  • Institutionalizing the Forecasting Process
  • Level, Trend and Seasonal Demand
  • Moving Averages and Exponential Smoothing
  • Case Studies and Hands-On Exercises
  • Demand Planning in S&OP/IBP
  • Forecast Accuracy and Key Metrics
  • Forecast Bias and Tracking Signal
  • Forecast Value Added (FVA) Analysis
  • Collaboration, CPFR and Data Sharing
  • Roles in Demand Planning
  • Case Studies and Hands-On Exercises

    Day 2:

    Advanced Forecasting Methods
    and Process Improvement

  • Data Quality, Cleansing and Enrichment
  • Lost Sales and Event History
  • Seasonal Forecasting by Decomposition
  • Holt-Winters and Pegels Classification
  • Regression and ARIMA Models
  • Forecasting with Machine Learning
  • Case Studies and Hands-On Exercises
  • Demand Sensing and Short-Term Forecasting
  • Top-Down and Bottom-Up Forecasting
  • New Products and Product Life Cycles
  • Promotion Effects and Product Mix Effects
  • Forecasting Intermittent Demand
  • Measures Against Forecast Deviations
  • Case Studies and Hands-On Exercises

Our trainings are preferred by leading industrial companies in Türkiye.

Over 60+ sessions delivered with participants from 100+ companies totaling 500+ managers and employees.

This course has been delivered as In-house Training for the companies listed below.

Migros logo
“It was an enjoyable training with comprehensive, well-prepared content. I believe that it will contribute greatly to our business and processes. Thank you very much...”
Mustafa Berk, Supply Chain Planning - Group Manager, Migros (Demand Planning, 2021)
Akkim logo
“We were able to exercise with theoretical knowledge and practical applications. A training that offers the opportunity to examine and learn demand planning methods in detail”
F**** A****, Customer Service Manager, Akkim (Demand Planning, 2023)
Sika Türkiye logo
“It is an extremely useful training for the evaluation of the current situation and sheds light on the future. Thanks.”
Elif Saka Karanfil, Planning Specialist, Sika Türkiye (Demand Planning, 2016)
Deva Holding logo
“It is an training that can be added more value with known knowledge. In a process, there is information that is unknown, or rather unobtrusive, but affects very important points.”
Burcu Özdemir, Production Planning Specialist, Deva Holding (Demand Planning, 2017)
Flormar logo
“Hello, it was a visionary training in a fluent language without overwhelming the essence and essence of the subject without going into unnecessary details. It was an effective and efficient training that enabled us to improve the existing systems in our company and how we have tried so far, and how to contribute to our processes.”
Hasan Basri Kara, Demand Planning Manager, Flormar (Demand Planning, 2017)
Panasonic Electric Works logo
“I think that effectively reviewing the statistical forecasting infrastructure and acquiring a holistic methodological approach perspective by taking the contributions of all relevant parties is a very valuable achievement that will ensure continuous development.”
Mesut Tok, Demand Planning Manager, Panasonic Electric Works (Demand Planning, 2023)
EssilorLuxottica logo
“I can say that it is a training that includes all the details that can fit into two days. I recommend it if you want to have knowledge about S&OP processes and increase your awareness of what you can do in practice, from sales forecasting to production planning and stock management. Although it is statistic-oriented from time to time in terms of content, Mr. İlker's explanation and the intervening managerial process designs allow you to refocus on the subject. Shared excel files are useful examples for you to prepare your own work.”
Cahit Atabek, Country Operations and LTC Manager, EssilorLuxottica (Demand Planning, 2022)
Kastamonu Entegre logo
“Although it has a long history, the recognition and use of S&OP processes in Turkey is not very old. Especially the awareness of domestic corporate companies on this issue is increasing. In the face of such a need, Mr. İlker touches on the process at all points with the S&OP training he organized and gave. Within two days, he makes a presentation that all participants who have no idea or experience about this process can enjoy.”
Barış Çelik, Supply Chain Planning Manager, Kastamonu Entegre (Demand Planning, 2017)
Haribo logo
“It had a very useful, full interior. Good luck to your effort. Thanks.”
Havva Tezcan, Planning Manager, Haribo (Demand Planning, 2017)
Zorluteks logo
“We have learned many methods that we can easily apply in Demand Planning and Stock Management. Thanks for the efficient training....”
Mine Ersöz, Sales Planning Manager, Zorluteks (Demand Planning, 2023)
Soda Industry logo
“I think that it is an training in which every institution can create a certain systematic, observe the mistakes made and have knowledge and vision about the improvements that can be made.”
Sema Demiray Kırmızı, Demand Planning Engineer, Soda Industry (Demand Planning, 2014)
Foxconn TR logo
“As mentioned in the content of the training, one of the most basic indicators of the size of a company today and the phenomenon at the top of the pyramid is directly proportional to the demand planning made by that company. In this context, the training provided provided sufficient information about making a demand plan closest to the truth.”
Erkan Güzel, Supply Chain Chief, Foxconn TR (Demand Planning, 2017)
LCWaikiki logo
“I would like to point out that the training covers all topics in Demand Planning, and although it lasts for 1 day, it can teach all the important points. I believe it is a useful training.”
Hafure Özer Demirci, Domestic Supply Chain Manager, LCWaikiki (Demand Planning, 2012)
Civil Retail logo
“It is definitely a must-take training for future forecasts and demands. It will take it one step further personally and institutionally.”
Ali Ekinci, Product Planning Executive, Civil Retail (Demand Planning, 2019)
Honda Turkey logo
“I think it is a very correct training for the functioning, correct planning, implementation and control of company processes. I was proud that my own company was already doing many of the processes. It was very helpful in identifying areas that could be improved. Thanks!”
Ferit Arda Kurtkale, Automobile Planning Specialist, Honda Turkey (Demand Planning, 2016)
Otokar logo
“As the beginning of the planning processes, the more effective the Demand Planning is, the more accurate the planning of the ongoing processes is. I think that the training on demand planning, which enables you to see further and take action much earlier, will make significant contributions to the customer satisfaction and efficiency of companies...”
Şefik Sucu, Production Planning and Control Unit Manager, Otokar (Demand Planning, 2015)
Pasabahce logo
“A training that focuses on the essence and important points of the subject without going into unnecessary details. I found it very useful to reinforce it with practical examples...”
Ayşe Selen Özkan, Product Supply Supervisor, Pasabahce (Demand Planning, 2015)
Kaleseramik logo
“If you are looking for an environment where you can easily discuss our daily problems that do not remain in theory, you are in the right institution.”
Onur Özdemir, Planning and Logistics Manager, Kaleseramik (Demand Planning, 2015)
Archromaturkey logo
“Since it starts as simple and understandable and then elaborates, it is presented in a catchy and easy-to-learn way. At the same time, the participant's participation in the subject is skillfully ensured. I was able to follow it without getting bored in terms of visuality and content. It contributed a lot to me in terms of the details of statistical calculations. My goal before coming to the program was to gain the ability to do my current job faster and more accurately. I think this happened after the training. I would like to thank Mr. İlker for everything...”
Elif Tersakan, Demand & Inventory Planner, Archromaturkey (Demand Planning, 2015)
Barilla Food logo
“I believe that our in-house practices will improve considerably with the detailed training we have received on Demand Planning and S&OP processes. The scope of training was very productive. In addition, the instructor competence and presentation were very enjoyable. Thank you.”
Buket Yıldırım, Contact Center Manager, Barilla Food (Demand Planning, 2015)
Pasabahce logo
“I believe that it would be beneficial to give Demand Planning and Sales Forecasting training, which is the starting point of all operational processes, to all supply chain members in order to raise awareness...”
Özer Özgüven, Warehouse Operations Manager, Pasabahce (Demand Planning, 2015)
Chicco logo
“I would like to thank Optimum Planning for this extremely simple and eye-opening training. It will increase both my personal development and my performance.”
Burak Şentürk, Purchasing and Demand Planning Manager, Chicco (Demand Planning, 2012)
Tupras logo
“I would like to thank İlker Güçlü for a training that can be explained in such a beautiful and simple language how important it is to plan the demands in every sector where competition is increasing day by day and that there are many techniques that can be used for this.”
Ali Cem Çatak, Coordinator, Tupras (Demand Planning, 2012)
Dalan Chemicals logo
“I think that the Demand Planning & Sales Forecasting Techniques training is useful for getting basic information on the subject and approaching the subject from a broader perspective. I think it will be useful when taken institutionally or individually...”
Gizem Halil, Material Planning Officer, Dalan Chemicals (Demand Planning, 2015)
Hascelik logo
“It was a very useful training where we learned Demand Planning methods that can be applied immediately in practice and opened our horizons about where the later stages of the subject can go. Thank you.”
Ömer Faruk Mızraklı, Export Officer, Hascelik (Demand Planning, 2015)

Click here to view all comments related to this training.

Back to top

  Participants will receive a Certificate of Attendance indicating each day attended.

The training modules are delivered by Dr. İlker Guclu, the program's designer and developer.

İlker completed his BSc, MSc and PhD at Bosphorus University, Department of Industrial Engineering.

Since 2003, he has worked in industry-focused training and consulting services, with the last 15+ years focused on supply chain management and optimization.

İlker is married and a father of two.

For the instructor's CV, see here.

Who should attend?

Demand planners, sales, marketing, supply chain, production and finance professionals.

Duration?

2 days; sessions typically 09:00–16:00.

Is a certificate of attendance issued at the end of the training?

Yes, a Certificate of Attendance showing the days attended is issued at the end of the training.

How to register?

Use the Request Quote or registration form on the site.

What methods are covered?

Moving averages, exponential smoothing, regression, ARIMA, seasonal decomposition and judgmental forecasting.

  Upcoming session dates:  Loading...
  Sessions run from 9:00–16:00, including breaks.
  To keep training effective, seats are limited.
  To join a public session or request an in-house course, please submit a request.