Transport Operations Planning with Excel and anylogic.
ROAD TRANSPORT · LOGISTICS OPTIMIZATION · SIMULATION .EXCEL . OPEN SOLVER . ANYLOGIC . ORANGE
★ Highest Rated on Udemy — Designed for Supply Chain Professionals, Not Students
This course carries Udemy’s Highest Rated badge — earned not by marketing spend, but by practitioners who enrolled, completed the course, and came back to recommend it. Built to the standard of real professional development, it is the only road transport optimisation and simulation course on any online learning platform that covers both analytical modelling and AnyLogic simulation in a single, hands-on program.
★ Battle-Tested in Barcelona and Mexico City — 60 Participants from 15 Countries
Before this course existed online, its content was delivered as a three-day in-person training program for one of the world’s largest building materials companies — a global leader operating across more than 70 countries. The program ran twice: once in Barcelona, once in Mexico City, with 60 logistics and supply chain professionals from 15 different countries attending each session. Every model, dataset, and scenario in this course comes from that engagement. It has been tested, challenged, and refined by practitioners from global operations — not built in a classroom.
★ One of a Kind — The Only Course That Combines Optimisation and Simulation for Road Transport
Search any online learning platform. You will find courses on Excel Solver, or courses on AnyLogic, or general supply chain theory. You will not find another course that combines fleet optimisation, carrier selection, route modelling, transport data mining, and full AnyLogic simulation of a live road transport network — in one program, without a single line of code. This course fills a gap that no other course does.
Most transport decisions are made on instinct, habit, and rules inherited from whoever had the job before. This course replaces instinct with models. You will learn to turn real road logistics problems — “How many trucks do we actually need?”, “Which carrier should we award this contract to?”, “What happens to our network if a key route is disrupted?” — into structured optimisation and simulation models you can solve, explain, and reuse.
Working hands-on with Excel Solver and OpenSolver for fleet sizing, carrier selection, and route optimisation; Orange Data Mining for discovering patterns in transport cost and performance data; Google Sheets for large-scale cloud-hosted models; and AnyLogic for animated simulation of your entire transport network — every module is built around a realistic logistics scenario. No toy examples. No abstract theory. No coding required.
By the end of this course, you will have seven working models you can adapt and deploy in your own organisation — from an Excel fleet sizing spreadsheet to a fully animated AnyLogic simulation of your road transport network. Each model comes with real data and a practical scenario. Each one is yours to keep, modify, and run on your own problems from day one.
TOOLS COVERED IN THIS COURSE
Excel + Solver | OpenSolver | Orange Data Mining | Google Sheets | AnyLogic Simulation
WHAT MAKES THIS COURSE DIFFERENT?
[ OPT→SIM ]
Optimise and simulate — in the same course
Most courses teach either optimisation or simulation. This one teaches both — and shows you how they work together to support better transport decisions.
[ NO CODE ]
Five tools, zero programming
Excel Solver, OpenSolver, Orange, Google Sheets, and AnyLogic are all used without writing a single line of code. Every tool has a free version covered in the course.
[ REAL ]
Built from live consulting projects
Every model, dataset, and scenario in this course comes from real transport and logistics client engagements — not textbook examples or synthetic data.
WHAT YOU WILL LEARN
✓ Build a fleet capacity model in Excel that minimises cost under real operational constraints
✓ Design multi-criteria carrier selection models for tenders, RFQs, and contract awards
✓ Formulate and solve the transshipment problem for multi-node logistics networks
✓ Apply data mining with Orange to uncover cost drivers and performance anomalies in transport data
✓ Integrate production planning with transport to balance cost, capacity, and service levels
✓ Optimise vehicle multi-drop delivery schedules using OpenSolver in Excel
✓ Map and cluster customer delivery zones geographically to reduce empty mileage and improve routing
✓ Solve large-scale logistics models with OpenSolver — pushing beyond Excel Solver’s variable limits
✓ Build an animated, data-driven AnyLogic simulation of a road transport network with vehicles, routes, and demand
✓ Run scenario experiments in AnyLogic to stress-test transport decisions before committing resources
✓ Present model-backed transport decisions to management with clear, quantified justifications
COURSE CONTENT — 7 MODULES
MODULE 1
Fleet capacity planning for road transportation
How many trucks do you really need — and at what cost? Model fleet size, vehicle utilisation, and operational costs under real capacity constraints. You will build a solver-ready spreadsheet from scratch, solve facility allocation and transshipment problems, and test multiple fleet scenarios to find the optimal composition. Includes a practice exam with a detailed solution.
Excel Solver
MODULE 2
Carrier selection and offers management
Stop awarding contracts on price alone. Build a multi-criteria optimisation model to evaluate carrier bids fairly across lanes, volumes, service levels, fixed costs, and conditional tonnage — and produce a defensible, auditable contract award decision. Directly applicable to any road transport tender or RFQ process. Excel Solver Google Sheets
MODULE 3
Transport cost analysis and data mining
Your transport data holds answers you haven’t found yet. Use Orange’s visual, no-code interface to discover hidden cost drivers, carrier performance trends, and billing anomalies in your shipment history — and turn raw operational data into decisions you can act on immediately. Orange Data Mining
MODULE 4
Aggregate production planning with transportation
Logistics does not operate in isolation from production. Build integrated models that jointly optimise production scheduling and transport decisions across your supply chain — balancing cost, expected service level, and capacity, and making strategic factory allocation decisions. Excel Solver
MODULE 5
Geographical mapping and customer clustering
Visualise your entire transport network on a real map. Cluster customers and delivery points into logical zones to design smarter distribution areas, cut empty mileage, and plan new routes backed by geographic data — not intuition or historical habit.
Orange Data Mining Google Sheets
MODULE 6
Large-scale optimisation with OpenSolver
Excel Solver has a variable limit. OpenSolver does not. Tackle large, real-world logistics problems — big fleets, complex multi-stop networks, multi-drop vehicle routing, national carrier pools — using OpenSolver’s advanced engine and Google Sheets for models too large for standard Excel. Includes a scheduling practice exam. OpenSolver Google Sheets
MODULE 7
Simulation modelling of road transport with AnyLogic
Optimisation finds the best plan under known conditions. Simulation tests what happens when reality doesn’t follow the plan. Build an animated, data-driven AnyLogic model of your road transport system — with vehicles, routes, demand variability, and disruptions — and run experiments to stress-test your decisions before committing resources to them. AnyLogic
THIS COURSE IS NOT FOR YOU IF...
✗ You are looking for a transport management software (TMS) tutorial — this course builds analytical decision models, not software configuration guides
✗ You want a general supply chain overview — this course focuses specifically on road transport optimisation and simulation, not all logistics modes
✗ You need a programming course — no code is written at any point; all tools are used through their graphical interfaces
✗ You are looking for a pure data science course — the analytical methods here are applied to transport operations decisions, not generic machine learning
WHAT STUDENTS AND CLIENTS SAY
“It’s incredible to see what is possible with Python in terms of supply chain planning and optimization. Haytham is doing a great job as a trainer — starting with explanation of basics and ending with presentation of advanced techniques supply chain managers can apply in real life.”
Larsen Block — Director, Supply Chain Management — Freudenberg Home & Cleaning Solutions
“Haytham mentored me in my role of Head of Supply Chain Efficiency. He is extremely knowledgeable about supply chain concepts, latest trends, and benchmarks in the supply chain world. His analytics-driven approach was very helpful to recommend and implement significant changes to our supply chain.”
Senior Leader — Head of Supply Chain Efficiency — Aster Group
“I attended this course with high expectations. And I was not disappointed. It is incredible to see what is possible with Python in terms of supply chain planning and optimization. Haytham is doing a great job as a trainer — starting with an explanation of basics and ending with presentation of advanced techniques supply chain managers can apply in real life.”
Verified student — Udemy platform
WHO THIS COURSE IS FOR:
Transport and fleet managers
You run daily operations but need structured models to justify fleet size, routing choices, and carrier contracts to finance and leadership — with numbers, not guesses.
Supply chain and logistics analysts
You work with data every day but want hands-on optimisation tools — not just dashboards — to actually solve transport problems at their root cause.
Procurement and tender managers
You manage carrier bids, RFQs, and annual tenders and want a systematic, model-driven way to evaluate offers and negotiate rates with full confidence and an audit trail.
Scheduling and planning managers
You are responsible for delivery planning and want to replace manual, time-consuming scheduling with repeatable optimisation models you run every planning cycle.
Operations researchers and analysts
You understand optimisation theory but need practical, no-code tools you can deploy in your organisation immediately — without waiting for a developer or IT budget approval.
Logistics students and career changers
You want a portfolio of real, working models — not just theory certificates — to stand out in transport, logistics, and supply chain job applications.
REQUIREMENTS
● Comfortable using Microsoft Excel — basic formulas and functions. No programming or coding experience is required at any point in this course.
● A computer with Microsoft Excel installed. Students without a licence are fully supported — Google Sheets and OpenSolver alternatives are covered throughout.
● Basic familiarity with logistics or transport concepts is helpful but not required — every module opens with first-principles context before the modelling begins.
● A working knowledge of a basic forecasting technique (moving average, exponential smoothing, or linear regression) is preferable for Module 4 — but not essential.
● Orange Data Mining and AnyLogic Personal Learning Edition are both free — step-by-step installation is provided at the start of each relevant module.
WHAT IS INCLUDED
● 7 modules covering the full road transport optimisation and simulation workflow
● Downloadable Excel workbooks, OpenSolver models, Orange workflows, and AnyLogic project files for every module
● Two practice exams with detailed solutions — one for fleet optimisation (Module 1) and one for scheduling (Module 6)
● Real transport datasets used in live consulting projects — not synthetic or textbook data
● Lifetime access to all content and any future updates to the curriculum
● 30-day money-back guarantee — no questions asked
● Certificate of completion upon finishing the course
YOUR INSTRUCTOR
Haytham Omar, Ph.D.
Supply Chain & Business Intelligence Consultant · Developer · Trainer — UAE & France
Haytham is a practising supply chain and data science consultant working with national and multinational clients across the UAE and France. He has trained over 70,000 supply chain professionals across 70+ workshops in the UAE. Every model, dataset, and scenario in this course comes from real client engagements — problems that actually land on logistics managers’ desks.
He holds a Ph.D. and a Master of Science in Global Supply Chain Management from Bordeaux École de Management. Active consulting clients include Sephora France (omni-channel optimisation), Sharaf Group Adventure HQ (replenishment algorithm deployed since 2019), and Aster Pharmacy group.
The AnyLogic simulation module in particular reflects live simulation projects delivered for clients in the transport and distribution sector. The methods in this course work in operations, not just in textbooks.
Stop managing by instinct. Start optimising by model.
7 modules · 5 tools · Real datasets · No coding required · Optimisation + Simulation · Lifetime access
Khám phá thêm các khoá học cùng chủ đề
Kyle Pew • 2,000,000+ Students
365 Careers
Start-Tech Academy
Maven Analytics • 1,500,000 Learners
Maven Analytics • 1,500,000 Learners
Chris Haroun | 1.5 Million Students | #1 Best Selling Business & Finance Prof.
365 Careers
Todd McLeod
Bibhatsu Kuiri
Abdelrahman Emad Hamdy
Nabil Mahmoud
Vakilian Zand
Sahar Rouzbahani
John Mandic
Adarsh Amal
Adarsh Amal
Operational Excellence Training
Yasin Bin Abdul Quader
Laurence Gartside
