Tutorials > Behind The Wheels -Management of Logistics Road Transport

Behind The Wheels -Management of Logistics Road Transport

Date: 24 August 2026 | Posted by: voska89

Free Download Behind The Wheels -Management of Logistics Road Transport
Last updated 7/2026
Created by Haytham Omar-Ph.D
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All Levels | Genre: eLearning | Language: English + subtitle | Duration: 126 Lectures ( 9h 37m ) | Size: 7.6 GB

Build fleet, carrier & route models with Excel Solver, OpenSolver, Orange Data Mining, and AnyLogic Simulation.

What you'll learn

⚡ Design multi-criteria carrier selection models for tenders, RFQs, and contract awards
⚡ Apply data mining to uncover cost patterns and performance anomalies in transport data
⚡ Integrate production planning with transport to balance cost, capacity, and service levels
⚡ Map and cluster delivery zones geographically to reduce empty mileage and improve routing
⚡ Solve large-scale logistics models with OpenSolver — beyond Excel's built-in variable limits
⚡ Present model-backed transport decisions to management with clear, quantified justifications
⚡ Build an animated AnyLogic simulation of a road transport network and run scenario experiments
⚡ Create route plans with google sheets -InstaMaps

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 in the course.
❗ Basic familiarity with logistics or transport concepts is helpful but not required — every module opens with first-principles context before the modelling begins.
❗ Orange Data Mining and AnyLogic Personal Learning Edition are both free — step-by-step installation is provided at the start of each relevant module.

Description

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 withExcel Solver andOpenSolver 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; andAnyLogic 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
⭐ Procurement and tender managers
⭐ Supply chain and logistics analysts
⭐ Scheduling and planning managers
⭐ Operations researchers and analysts
⭐ Logistics students and career changers

Homepage

https://www.udemy.com/course/behind-the-wheels-management-of-logistics-road-transport

DOWNLOAD LINK

No Password - Links are Interchangeable

See full article