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

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 an efficient and fast business consultantIf 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 directors 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 or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of 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 124 000 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 to draw insightful conclusionsAs 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 easinessBe very efficient during the project deliver great results and be able to sleepHave good knowledge about problems which may occur in logisticsBe able to prepare yourself for an audit of the supply chain systemBe able to perform simulationsYou will be able also to download many additional resourcesExcels with calculations showing you how you can solve the presented cases in logisticsPresentation of results which are perfect examples of how you can communicate your findings and convince the customerLinks to must-read books for every consultantLinks to free presentations and movies worth reading and watching

Overview

Section 1: Introduction

Lecture 1 Introduction to the course

Lecture 2 How to deal with Blurry image

Lecture 3 How to reach additional resources

Lecture 4 Introduction to Management Consulting

Lecture 5 Preparation for the project

Section 2: Essential Excel Functions

Lecture 6 We will start with some Excel functions

Lecture 7 Excel – Main Function you should master

Lecture 8 VLOOKUP – Introduction

Lecture 9 VLOOKUP with approximate match – Introduction

Lecture 10 What you can use the VLOOKUP for?

Lecture 11 Basic VLOOKUP usage

Lecture 12 Some comments on basic VLOOKUP

Lecture 13 How to assign categories using VLOOKUP?

Lecture 14 How to use HLOOKUP?

Lecture 15 The logic of MATCH function

Lecture 16 How to assign categories based on 2 criteria using VLOOKUP and MATCH function?

Lecture 17 How to assign categories based on 2 criteria using HLOOKUP and VLOOKUP function

Lecture 18 Why NOT to use IF function

Lecture 19 How to use if function?

Lecture 20 How to use VLOOKUP instead of IF function?

Lecture 21 How to use IFERROR function?

Lecture 22 How to use MAX and MIN instead of IF function

Section 3: Cases in logistics

Lecture 23 Top-down approach - calculating the cost of logistics - introduction

Lecture 24 Top-down approach - calculating the cost of logistics - tips how to do

Lecture 25 Top-down approach - calculating the cost of logistics - Solution

Lecture 26 Fuel usage - introduction

Lecture 27 Fuel usage - tips how to do

Lecture 28 Fuel usage - solution

Lecture 29 Overtime analysis - introduction

Lecture 30 Overtime analysis - tips how to do it

Lecture 31 Overtime analysis - solution

Lecture 32 Tariff analysis - introduction

Lecture 33 Tariff analysis - tips how to do it

Lecture 34 Tariff analysis - solution

Section 4: Simulation of logistic system

Lecture 35 Logistics system simulation - introduction

Lecture 36 Logistics system simulation - tips how to do it

Lecture 37 Logistics system simulation - solution

Section 5: Distribution model - general information

Lecture 38 Why it's worth understanding the distribution system?

Lecture 39 Introduction to Distribution Model

Lecture 40 Goals of Distribution Model

Lecture 41 Basic laws of distribution

Lecture 42 Different types of distribution

Lecture 43 Different types of distribution - Pros and Cons

Lecture 44 Where you can find savings in distribution

Lecture 45 Typical problems in Distribution

Lecture 46 Logistics vs Supply Chain

Section 6: Conclusion

Lecture 47 Summary of the course and conclusion

Lecture 48 Bonus Lecture

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