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.

Who this course is for:

• Transport planners.
• Buyers who do regular tenders and request for quotations.
• Scheduling managers.
• Production planners.