Overview
Fleet Capacity planning for road transportation., Optimization of carrier selection and offers management., Schedule daily truck deliveries with fuel economization in mind., Apply aggregate production planning with transportation included., Apply geographical mapping, clustering with orange tool for data mining., Apply large model optimization with open solver in excel., Apply Vehicle Multi-drop shipments with opensolver-Excel
Transport planners., Buyers who do regular tenders and request for quotations., Scheduling managers., Production planners.
Preferable knowledge of any forecasting technique (average , exponential smoothing, Linear regression)
Welcome :)
Whether you’re a logistics professional, operations analyst, or simply someone passionate about smarter transport planning, this course will help you turn complex supply chain challenges into powerful optimization models.
You’ll work directly with Excel Solver, OpenSolver, Orange for Data Mining, and Google Sheets to create and solve real-world problems.
Forget abstract theory — this course is all about practical models, decision-making, and optimization you can use today in your organization.
What Makes This Course Special
100% practical, tool-driven learning
Real industry use cases and hands-on exercises
2 practice quizzes and 2 real-world assignments
Over 7 hours of interactive learning
Learn optimization, data mining, and mapping — all in one place!
Course Curriculum
1- Fleet Capacity Planning for Road Transportation
Learn to model and optimize fleet size, capacity, and cost under operational constraints.
2-Optimization of Carrier Selection & Offers Management
Build multi-criteria optimization models to choose carriers and manage bids efficiently.
3- Schedule Daily Truck Deliveries with Fuel Economization
Apply optimization to minimize costs and emissions while maintaining delivery reliability.
4-Aggregate Production Planning with Transportation
Integrate production and logistics decisions to balance cost, service, and capacity.
5- Geographical Mapping & Clustering using Orange
Visualize and analyze transportation networks and customer clusters for better route planning.
6- Large-Scale Optimization using OpenSolver in Excel
Push Excel to its limits and solve big, complex models with OpenSolver and Google Sheets.
Who This Course Is For
Supply Chain & Logistics Professionals looking to sharpen their analytical and optimization skills.
Transportation Planners and Fleet Managers who want to make data-driven decisions.
Operations Researchers and Analysts seeking hands-on experience with Excel Solver and Orange.
Industry practitioners eager to move from theory to real-world transport optimization.
Keywords
Supply Chain • Transport Planning • Fleet Management • Optimization
Ready to Transform Your Logistics Strategy?
Join now and start building optimization models that make a real difference — from smarter fleet planning to advanced data-driven transport decisions.
Haytham Omar-Ph.D
"Never follow a book by its cover, In a world that changes every second, we must be resilient and proactive. " Consultant / Developer /Trainer
Consultant in Supply Chain Management & Business Intelligence
Founder - Keip – Bordeaux
• PhD in supply chain from the University of Bordeaux.
• Supply chain and data science consultant for several national and multinational clients in the UAE and France.
• Data Scientist, Master of Science in Global Supply Chain Management from Bordeaux Ecole de Management, Bordeaux, France
He is currently conducting workshops and seminars in Supply chain and data science as well as consultancy projects for Sephora, Sharaf group and aster pharmacy.
• Haytham conducted more than 70 workshops in UAE in the last three years in supply chain and data science.
Clients :
Sharaf Group
Aster Group
Sephora France
DNO
Qarar for financial analytics
Lamprell
Noble Prog
PWC training Academy
Higher College of Technology
Partners: Edusphere dubai- Limar Tech Saudi arabia – sl-tech Abu Dhabi
Projects :AHQ-SHARAF GROUP:
developing an algorithm for the replenishment of stocks to Sharaf group -adventure HQ . the algorithm is being used since November 2019 with notable results.
Developing and deploying an algorithm for revenue maximization based on elasticity techniques for adventure zones service provided by AHQ.
Projects: Sephora – France
Haytham is working with Kedge business school as part of the team CSIT for partnership
The collaboration of Omni-channel optimization with Sephora France. As a part of his Ph.D. project.
Development: Haytham developed the Inventorize package in R mainly used for supply chain analytics with more than 50000 Downloads so far.