Logistics for Management Consultants - a practical guide

Name: Logistics for Management Consultants - a practical guide
Rating: 4.5 (506 reviews)

Learn to analyze, optimize logistics as a management consultant during consulting project on the basis of cases provided

Highest Rated

Created byAsen Gyczew

Last updated 5/2026

English

What you'll learn

Perform analyses of logistics in Excel
Understand consulting concepts
Have in-depth knowledge on logistics
Create slides showing results of your analyses
Do a part of consulting project on your own
Be the fastest consultant on the team
Surprise your boss with the high level of your work

Course content

6 sections • 48 lectures • 2h 41m total length

Introduction to the course5:33
In this lecture I will present myself, present the aim of the course, who should be taking it and what you will learn by taking this course. As an attachement to this lecture you will find the deck of slides for the whole course and the suggested books to be read
How to deal with Blurry image2:04
Here I will show you what to do if a blurry image appears
How to reach additional resources1:06
Here I will show you how to find additional resources attached to the coruse like Excel files, presentations, links etc.
Introduction to Management Consulting4:21
I will try to show you how in reality management consulting project looks like
Preparation for the project7:38
As the course is designed in such a way to simulate real projects in this part we will talk about how you should prepare yourself once you know that you will participate in a project. This lecture will also introduce you to some consulting concepts which will make your life during the project much easier. Attached please find an example of an issue tree

We will start with some Excel functions0:25
Excel – Main Function you should master0:55
In the next few lectures, we will repeat the Excel functions that will be useful later when we will be solving case studies. We will discuss the following sections:
VLOOKUP
HLOOKUP
MATCH
IF
IFERROR
Pivot Tables
If you are familiar with that you can skip these lectures and move on to management consulting tools and techniques
Enjoy the content and if you have any questions please let me know!
VLOOKUP – Introduction3:46
In this lecture, I will show you how to use one of the most useful functions - the VLOOKUP
VLOOKUP with approximate match – Introduction2:33
We will also look at the so-called approximate match with vlookup
What you can use the VLOOKUP for?1:37
In this lecture, we show you what you can use the VLOOKUP function for. It is one of the most widely used functions that simplifies a lot of things
Basic VLOOKUP usage3:20
We start with basic VLOOKUP Usage just to show you the flavor and basic construction of VLOOKUP.
Some comments on basic VLOOKUP1:58
We start with basic VLOOKUP Usage just to show you the flavor and basic construction of VLOOKUP.
How to assign categories using VLOOKUP?2:58
VLOOKUP can be used to assign categories. This helps you easily by creating rules divide data into segments, cohorts and analyze them, draw conclusions
How to use HLOOKUP?1:37
HLOOKUP is a cousin of VLOOKUP. It is not that often used independently but has some serious application when combined with VLOOKUP
The logic of MATCH function2:32
Another useful function is the so-called MATCH. We will see what it gives you.
How to assign categories based on 2 criteria using VLOOKUP and MATCH function?3:52
In this lecture, I will show you how to assign categories using VLOOKUP and MATCH. You have the categories described in the matrix and you want to use them
How to assign categories based on 2 criteria using HLOOKUP and VLOOKUP function2:44
In this lecture, I will show you how to assign categories using VLOOKUP and HLOOKUP. MATCH can be used as an alternative to the HLOOKUP
Why NOT to use IF function1:56
IF function can be very problematic. I will show you in this lecture why is not always the best choice
How to use if function?1:42
We start with showing you how to use the IF function
How to use VLOOKUP instead of IF function?3:45
In many cases IF can be replaced successfully with VLOOKUP. I will show you how to do it and what are the benefits
How to use IFERROR function?2:11
In some cases, you need to use IFERROR. It can be used as a replacement for IF or independently
How to use MAX and MIN instead of IF function4:08
Sometimes make sense to use MIN and MAX instead of IF. I will show you how and when to do that

Top-down approach - calculating the cost of logistics - introduction6:27
During this lecture I will show you how on basis of small number of data create a model which will show you how logistics costs are created, on what stage and what is the biggest drivers. This in turn will enable you to apply 80/20 rule
Top-down approach - calculating the cost of logistics - tips how to do11:21
In this lecture we will give you some tips how to approach the case and show you the usage of the proper Excel functions
Top-down approach - calculating the cost of logistics - Solution5:29
In this lecture we solve the case with you, show you the outcome, interpret it and give you examples how the results can be presented in terms of Excel and slides
Fuel usage - introduction3:45
In this case we will analyze what is the fuel usage for different cars, what it depends on and how to optimize it
Fuel usage - tips how to do5:04
In this lecture, we will give you some tips on how to approach the case and show you the usage of the proper Excel functions
Fuel usage - solution2:31
In this lecture we solve the case with you, show you the outcome, interpret it and give you examples how the results can be presented in terms of Excel and slides
Overtime analysis - introduction4:07
Next case will show you how to analyze labour cost in logistics.
Overtime analysis - tips how to do it4:36
In this lecture we will give you some tips how to approach the case and show you the usage of the proper Excel functions
Overtime analysis - solution2:49
In this lecture we solve the case with you, show you the outcome, interpret it and give you examples how the results can be presented in terms of Excel and slides
Tariff analysis - introduction3:42
This case will show you how to compare the non-comparable. I will show you what to do in situation when you have different tariffs and straightforward comparison is virtual impossible
Tariff analysis - tips how to do it4:35
In this lecture we will give you some tips how to approach the case and show you the usage of the proper Excel functions
Tariff analysis - solution2:27
In this lecture we solve the case with you, show you the outcome, interpret it and give you examples how the results can be presented in terms of Excel and slides

Logistics system simulation - introduction4:25
In this case we will do the simulation of the whole logistics system and show you how to choose from many options
Logistics system simulation - tips how to do it8:20
Here we will give you tips how to calculate the cost of the whole system and how to prepare for the simulation
Logistics system simulation - solution8:29
We present here final solution to the case. We show how to do the simulation of logistic costs for 8 different options in 5 minutes

Why it's worth understanding the distribution system?0:24
Introduction to Distribution Model1:05
Distribution (logistics and warehousing) is the powerhouse of supply chain moving physically the goods. In this section I will show you: goals of distribution model, basic laws of distribution, different types of distribution, Where you can find savings in, typical problems in Distribution
Goals of Distribution Model2:21
In this lecture we will discuss the primary goals of distribution. We will also discuss OTIFEF metric decomposition, and cost per tonne decomposition
Basic laws of distribution1:54
Let’s have a look at the basic laws of distribution
Different types of distribution2:08
There is no ideal distribution scheme. Each and every has its pros and cons
Different types of distribution - Pros and Cons3:18
There is no ideal distribution scheme. Each and every has its pros and cons
Where you can find savings in distribution2:51
In distribution there are number of standard places where you can find savings. I will show you the most typical ones you can pursue
Typical problems in Distribution3:45
There are a few typical problem usually occur in logistics and warehousing. I will go through the ones you should pay attention as well as ways to analyze them
Logistics vs Supply Chain0:24

Requirements

Basic Excel
Some analytical skills

Description

The course is designed to turn you into an efficient and fast business consultant

If you are a business/management consultant you probably have already noticed that it is very important to be efficient during projects, especially if you have to work 10-15 hours a day, 7 days a week. I know exactly the pain as I have been a consultant myself for 15 years and I had the pleasure to train consultants at top consulting firms (more than 100 consultants). Many of them are now at the director's level at FMCG / SMCG companies, private equity funds, and consulting companies.

This course will show you how to successfully conduct fast a performance improvement or turnaround project of the logistics/supply chain operation of the company. The principles presented here can be actually implemented in any consulting project, especially supply chain and production projects, but we wanted to concentrate on one topic to show you from simple to complicated analysis how you should approach the subject.

The course is also very useful for people involved on a daily basis in logistics and provides a framework on how to optimize their operations. The course is perfect also for business analysts outside the management consulting fields who want to significantly improve their skills. We recommend taking it also for people applying to consulting companies - it will give an advantage at the interviews.

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 224 b000 students including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

This course is a practical guide.

There is little theory and we concentrate on showing you in practice how to analyze, present problems and solutions, and how to draw the right conclusions from the data. During the course, you will get to understand how to approach the project to maximize effects in the shortest possible time. You will also learn, through real-life case studies, how to analyze fast in Excel logistics and draw insightful conclusions

As attachments to the course, you will get the Excel files along with the solution so you can practice on your own analyzing the data. You can also use the files for future projects.

Please, follow instructions so that you maximize the learning experience from the course – first try to do it on your own, then go to a partial solution and try to finish it on your own. Only after you try the latter one you should go to the final solution and check the Excel with the final solution.

After the completion of this training, you will:

Be able to handle supply chain-related analysis in Excel with easiness
Be very efficient during the project deliver great results and be able to sleep
Have good knowledge about problems that may occur in logistics
Be able to prepare yourself for an audit of the supply chain system
Be able to perform simulations

You will be able also to download many additional resources

Excels with calculations showing you how you can solve the presented cases in logistics
Presentation of results which are perfect examples of how you can communicate your findings and convince the customer
Links to must-read books for every consultant
Links to free presentations and movies worth reading and watching

Who this course is for:

Students who think about or are working for Operational Consulting companies
Students who think about or are working for Management Consulting companies
Students who want to work in Logistics, Supply Chain, Production
Students who think about or are working for Business Consulting companies

Logistics for Management Consultants - a practical guide

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 21min

Essential Excel Functions17 lectures • 42min

Cases in logistics12 lectures • 57min

Simulation of logistic system3 lectures • 21min

Distribution model - general information9 lectures • 18min

Conclusion2 lectures • 3min

Requirements

Description

Who this course is for: