Logistics for Management Consultants - a practical guide
4.3 (213 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,541 students enrolled

Logistics for Management Consultants - a practical guide

Learn to analyze, optimize logistics as a management consultant during consulting project on the basis of cases provided
4.3 (213 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,541 students enrolled
Created by Asen Gyczew
Last updated 7/2020
English
English [Auto]
Current price: $62.99 Original price: $89.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 article
  • 28 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Requirements
  • Basic Excel
  • Some analytical skills
Description

The course is designed to turn you into 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 was consultant myself for 5 years and I had the pleasure to train consultants at top consulting firms (more than 100 consultants). Many of them are now at directors level at FMCG / SMCG companies, private equity funds and consulting companies. This course will show you how to successfully and 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 projects, 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 how to optimize their operations. Course is perfect also for business analyst outside the management consulting fields who want to significantly improve their skills. We recommend taking it also for people apply to consulting companies - it will give advantage at the interviews.

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 to draw insightful conclusions

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

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

After the completion of this training you wil:

  • 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 which may occur in logistics
  • Be able to prepare yourself for audit of 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 presentation 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
Course content
Expand all 34 lectures 02:35:00
+ Introduction
6 lectures 20:41

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

Preview 05:33

Here I will show you what to do if a blurry image appears

How to deal with Blurry image
02:04

Here I will show you how to find additional resources attached to the coruse like Excel files, presentations, links etc.

How to reach additional resources
01:05

I will try to show you how in reality management consulting project looks like

Preview 04:21

As the course is design in such a way to simulate real project 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 issue tree

Preview 07:38
Slides from preparation for the project
7 pages
+ Cases in logistics
16 lectures 56:53

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 - introduction
06:27

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 - tips how to do
11:21

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

Top-down approach - calculating the cost of logistics - Solution
05:29
Slides from Top down approach case
10 pages

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 - introduction
03:45

In this lecture we will give you some tips how to approach the case and show you the usage of the proper Excel functions

Fuel usage - tips how to do
05:04

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 - solution
02:31
Slides from Fuel Usage case
5 pages

Next case will show you how to analyze labour cost in logistics.

Overtime analysis - introduction
04:07

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 - tips how to do it
04:36

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 - solution
02:49
Slides from Overtime Analysis case
5 pages

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 - introduction
03:42

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 - tips how to do it
04:35

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 - solution
02:27
Slides form Tariff Analysis case
9 pages
+ Simulation of logistic system
3 lectures 21:14

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 - introduction
04:25

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 - tips how to do it
08:20

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

Logistics system simulation - solution
08:29
+ Distribution model - general information
7 lectures 17:22

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

Introduction to Distribution Model
01:05

In this lecture we will discuss the primary goals of distribution. We will also discuss OTIFEF metric decomposition, and cost per tonne decomposition 

Goals of Distribution Model
02:21

Let’s have a look at the basic laws of distribution

Basic laws of distribution
01:54

There is no ideal distribution scheme. Each and every has its pros and cons

Different types of distribution
02:08

There is no ideal distribution scheme. Each and every has its pros and cons

Different types of distribution - Pros and Cons
03:18

In distribution there are number of standard places where you can find savings. I will show you the most typical ones you can pursue 

Where you can find savings in distribution
02:51

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 

Typical problems in Distribution
03:45
+ Conclusion
2 lectures 02:50

Thanks for taking this course. Here I will discuss what other things you should learn

Preview 01:36

In this lecture I will discuss what else you can learn

Bonus Lecture
01:14