Supply Chain For Management Consultants

A practical guide how to improve supply chain in a firm and analyze potential savings in Excel during consulting project

Last updated 2022-01-10 | 4.4

- Analyze supply chain
- Improve supply chain – make it faster
- cheaper and require less inventory
- Calculate in Excel the potential impact of proposed changes

What you'll learn

Analyze supply chain
Improve supply chain – make it faster
cheaper and require less inventory
Calculate in Excel the potential impact of proposed changes
Find strategic fit for the supply chain
Improve supply chain in Retail
FMCG
SMCG
commodity
Apply improvement techniques to other fields and industries

* Requirements

* Basic or intermediate Excel
* Basic knowledge of economics or finance

Description

What is the aim of this course?

This course will help you drastically improve your knowledge and skills in optimizing any company's supply chain through a series of practical cases. It is designed for people who want to become management consultants, business analysts or have to run and optimize supply chai on daily basis. In the course you will learn 3 things:   

  1. How to understand supply chain activities   

  2. How to optimize the supply chain to get more things done, cheaper at higher quality with fewer resources   

  3. Where to look for savings and improvements, how to calculate potential savings in Excel and implement them   

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. Based on 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 110 000 students including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modification, be applied by you or your team in your work.   

Why have I decided to create this course?   

Most consultants and business analysts are terrible at organizing operational issues. They treat the operations, especially the supply chain, as a black box and try to avoid it at any cost. Technical things overwhelm them and they shy away from them.  This approach is not the right one as you find elements of the supply chain in every business. To make matters worse supply chain efficiency and performance have a huge impact on the ability of any business to compete and grow. Everywhere you have some supply chain that you can optimize by using techniques that I will show in this course.  Supply chains influence heavily other areas especially sales and marketing as well as production. Therefore, it is a good idea to have at least a general knowledge of the supply chain. The funny thing is that you do not even have to be technical at all to be good at the supply chain. I have not finished any technical school and I am pretty good at finding significant improvements in the supply chain.     

To sum it up, I believe that if you want to build or to find improvements in any business you should master techniques related to optimizing the supply chain. That is why I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to owners, founders of businesses as well as supply chain managers, and directors.   

In what way will you benefit from this course?   

The course is a practical, step-by-step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you find and analyze the supply chain. There is little theory – mainly examples, a lot of tips from my own experience, and other notable examples worth mentioning. We intend that thanks to the course you will know:   

  1. How to understand supply chain   

  2. How to optimize it   

  3. Where to look for savings and improvements   

  4. How to calculate the impact of proposed changes in Excel   

  5. How to find the strategic fit when it comes to the supply chain   

You can also ask me any question either through the discussion field or by messaging me directly.   

How the course is organized?   

The course is divided currently into the following sections:   

  • Introduction. We begin with a little intro into the course as well as some general info on production   

  • General information on Supply Chain. In the second section, I will discuss the strategic part of the supply chain, how to find the strategic fit, what aspect you have to pay attention to.

  • Retail - Examples of business analyses of Supply Chain. This section will start a series of sections devoted to a specific type of business where are will show you detailed cases. In this section, I will show you an overview of the Retail Supply Chain, the main challenges, and a series of cases that will show you how to get the full potential of the supply chain.

  • FMCG - Examples of business analyses of Supply Chain. In the 4th section, I will show you an overview of the FMCG Supply Chain, the main challenges, and a series of cases that will show you how to get the full potential of the Supply Chain.

  • SMCG - Examples of business analyses of Supply Chain. In the 5th section, I will show you an overview of the SMCG Supply Chain, the main challenges, and a series of cases that will show you how to get the full potential of the Supply Chain.

  • Commodity - Examples of business analyses of Supply Chain. In this section, I will show you an overview of the Commodity Supply Chain, the main challenges, and a series of cases that will show you how to get the full potential of the Supply Chain.

  • Distribution model - general information. Distribution (logistics and warehousing) is the powerhouse of the supply chain moving physically the goods. In this section, I will show you: goals of the distribution model, basic laws of distribution, different types of distribution,  Where you can find savings, typical problems in Distribution.

  • Sales forecasting and customer service - general information. Sales forecasting gives the input data for the whole supply chain. Even small glitches in this part cause huge problems in the whole supply chain. In this section, I will show you: goals of sales forecasting, Sales forecasting and customer service value drivers, typical problems in sales forecasting and customer service.

  • Production planning - general information. Production planning is the brain of the supply chain. If you get this wrong the other things won’t matter.  In this section, I will show you: goals of production planning, production planning value drivers, typical problems in production planning.

  • Purchasing - general information. Purchasing has a big impact not only on cost but also the inventory levels. Wrong quality of products bought will lead to problems both in sales and in production. In this section, I will show you: goals of purchasing, purchasing value drivers, typical problems in purchasing.

You will be able also to download many additional resources   

  1. Excels with analyses shown in the course   

  2. Presentation of slides shown in the course   

  3. Links to additional presentations and movies   

  4. Links to books worth reading

  5. Additional Resources 

Who this course is for:

  • Consultants
  • Management Consultants
  • Business Analysts
  • Supply Chain Managers
  • Small and medium business owners
  • Startups founders
  • Controllers

Course content

11 sections • 106 lectures

Introduction Preview 02:43

Introduction. We begin with little intro into the course as well as some general info on supply chain

A little bit about me Preview 01:47

In this lecture I will share some info on who am I and what is my experience

What to do if a blurry image appears Preview 02:04

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

How to find additional resources Preview 01:05

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

How to find information and ask questions Preview 02:50

Introduction to general information on Supply Chain Preview 01:39

In the second section I will discuss the strategic part of the supply chain, how to find the strategic fit, what aspect you have to pay attention to

What is Supply Chain Preview 03:00

We can look at supply chain from 2 different perspectives: global perspective, internal perspective. In this lecture we will discuss both of them

Components of Supply Chain Preview 02:14

In  this lecture I will discuss the components of supply chain

Finding the strategic fit Preview 06:36

The successful supply chain strategy cannot be developed apart from overall strategy for the firm. There are 2 things that you have to decide on to achieve the strategic fit: implied uncertainty of the demand and responsiveness of the supply chain. I will discuss in this lecture how to combine them and pick the right supply chain

Comparison of efficient and responsive supply chain Preview 03:58

In this lecture I will show you the difference between efficient and responsive supply chain, what are the pros and cons and when to use them

Lost sales and stock level Preview 03:48

While analyzing stock-outs we should divide them into three groups to be able to estimate in a better way their influence on our profit and planning. In Supply Chain a lot of attention goes to stock level. It depends on the cost of lost sales and inventory cost. In this lecture I will show you how to combine those 2 information and pock the right inventory level to optimize profits.

How to tackle the uncertainty (buffering) Preview 02:35

Variability of demand means that you have to buffer with one of 3 things: buffering with time, inventory and capacity. Using examples I will show you which one when to use

KPIs for Supply Chain Preview 02:38

The primary goals of Supply Chain are: minimization of costs with assumed optimal service level and maximization of elasticity. We will discuss it in details what it means in practice

How much Supply Chain costs Preview 01:18

Supply chain cost may represent significant percentage of total costs in many industries. Here I will show some examples

Types of consulting projects done in Supply Chain Preview 02:17

There are 6 typical supply chain project that you will perform for your customers. I will discuss briefly in this lecture what you do during them

Introduction to Retail Supply Chain Preview 00:43

This section will start a series of sections devoted to specific type of business where are will show you detailed cases. In this section I will show you overview of the Retail Supply Chain, main challenges and series of cases that will show you how to get the full potential of the supply chain

Overview of Supply Chain in Retail Preview 02:22

Retail supply chain is not only long and involves many parties but also is fluctuating a lot. In this lecture I will show the typical flow that you may expect

Main challenges in Supply Chain in Retail Preview 04:08

There are number of challenges in the Supply Chain in Retail. I will discuss them briefly in this lecture

Introduction to cases for Retail Preview 01:03

I will show you in short here what cases we will do in this section

Groceries – warehouse optimization – Introduction Preview 02:55

In this case you will have to optimize the way central warehouse of grocery Retailer works. We will start with a short introduction

Groceries – warehouse optimization – Current Cost estimation Preview 05:11

I will start by showing you how to calculate the costs of current solution used in groceries

Groceries – warehouse optimization – Potential improvements Preview 02:21

Now we will have a look at what kind of improvements you can make in the current solutions

Groceries – warehouse optimization – Estimation of savings in Excel Preview 03:47

In this lecture I will show you calculate the impact of the proposed improvements

Measuring the capacity of Central Warehouse – Introduction Preview 02:33

We stay with our Fashion Retailer and now we will have a look at his operations in the central warehouse

Measuring the capacity of Central Warehouse – Tips Preview 03:13

In this lecture I will give you some tips that will help you to solve the case and understand the solution in Excel

Measuring the capacity of Central Warehouse – Capacity in Excel Preview 06:20

In this lecture we measure the capacity per stream and per stage to see all the limitations and what they are stemming from

Measuring the capacity of Central Warehouse – Cost in Excel Preview 03:09

We will use the same model to calculate the cost per streams and their commponents

Convenience stores - Analysis of tariffs – Introduction Preview 03:38

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

Convenience stores - Analysis of tariffs – Tips how to do it Preview 04: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

Convenience stores - Analysis of tariffs – Solution Preview 02: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

DIY - internal logistics optimization – Introduction Preview 00:45

Sometimes the supply chain activities are also performed in the stores as well. Here I will show you how you could optimize them. We will use as an example a DIY store

DIY - internal logistics optimization – Solution Preview 02:54

Here I will show you how we optimized the process of shelf replenishment in the store and what savings we managed to generate

DIY - internal logistics optimization – Solution in Excel Preview 02:23

Here I will show you how we optimized the process of shelf replenishment in the store and what savings we managed to generate

Retailer new & old stores – Case Introduction Preview 01:29

Let’s imagine that you have to forecast the sales of a retail chain. They have 10 old stores and plan to open another 5. Use the data from the previous year.

Retailer new & old stores – Drivers Preview 02:26

We will look at the drivers of sales for a retailer. For simplicity, let's assume that we will be estimating the sales of a chain consisting of 2 stores.

Retailer new & old stores – Data Available Preview 03:51

In this lecture, we will be solving the previously introduced case study.

Retailer new & old stores – New Stores Preview 03:20

In this lecture, we will be solving the previously introduced case study.

Retailer new & old stores – Old stores Preview 03:26

In this lecture, we will be solving the previously introduced case study.

Retailer new & old stores – Change Preview 02:31

In this lecture, we will be solving the previously introduced case study.

Introduction to FMCG Supply Chain Preview 00:46

In this section I will show you overview of the FMCG Supply Chain, main challenges and series of cases that will show you how to get the full potential of the supply Chain

Overview of Supply Chain in FMCG Preview 01:41

FMCG supply chain is pretty complicated on the outbound side – the distribution to end-customers. In this lecture I will show how typical supply chain in FMCG looks like

Main challenges in Supply Chain in FMCG Preview 04:40

There are number of challenges in the Supply Chain in FMCG. I will discuss them briefly in this lecture

Introduction to cases for FMCG Preview 01:39

I will show you in short here what cases we will do in this section

Chicken Producer - Top-down approach - Introduction Preview 06:25

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

Chicken Producer - Top-down approach - Tips how to do it Preview 11: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

Chicken Producer - Top-down approach - Solution Preview 05:28

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

Chicken Producer - Fuel usage - Introduction Preview 03:46

In this case we will analyze what is the fuel usage for different cars, what it depends on and how to optimize it

Chicken Producer - Fuel usage - Tips how to do it Preview 05:04

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

Chicken Producer - Fuel usage - Solution Preview 02:28

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

Chicken Producer - Overtime analysis - Introduction Preview 04:07

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

Chicken Producer - Overtime analysis - Tips how to do it Preview 04: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

Chicken Producer - Overtime analysis - Solution Preview 02:48

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

Juice Producer - Simulation - Introduction Preview 04:28

In this case, we will do the simulation of the whole logistics system and show you how to choose from many options.

Juice Producer - Simulation - Tips how to do it Preview 08:23

Here we will give you tips on how to calculate the cost of the whole system and how to prepare for the simulation

Juice Producer - Simulation - Solution Preview 08:33

We present here the final solution to the case. We show how to do the simulation of logistic costs for 8 different options in 5 minutes

Optimal production batch analysis - FMCG Preview 06:37

In this lecture you will learn how to calculate optimal batches and how to estimate savings when comparing to actuals batches. We will use his an example of juice producer

2-stage production planning Preview 05:32

2-stage production planning (planning for assembling and bundles). In many cases you have to first prepare the components and then on the basis of this produce the end product. This requires certain amount of additional planning, especially taking into account that the same component can be in different end-products. I will show you here on the basis of example of cosmetics producer how to create such a production plan, assuming optimal production batches for components and taking into account the inventories.

Introduction to SMCG Supply Chain Preview 00:35

In this section I will show you overview of the SMCG Supply Chain, main challenges and series of cases that will show you how to get the full potential of the Supply Chain

Overview of Supply Chain in SMCG Preview 02:11

SMCG supply chain is extremely complicated on the supplier side. In this lecture I will show you how typical supply chain looks like

Main challenges in Supply Chain in SMCG Preview 04:04

There are number of challenges in the Supply Chain in SMCG. I will discuss them briefly in this lecture

Introduction to cases for SMCG Preview 01:38

I will show you in short here what cases we will do in this section

Transportation mode vs value density – Introduction Preview 00:32

Let’s have a look at car producer that is wandering how to get a specific part to his factories in Europe. We will see what is the optimal transportation mode of moving it to  the customer

Transportation mode vs value density – Solution in Excel Preview 04:26

In this lecture we will calculate the solution in Excel and see how it will change depending on the parameters

Car Industry – Planning the flow of finished goods – Introduction Preview 00:33

Let’s have a look at car producer that is wandering which plant should supply to which country

Car Industry – Planning the flow of finished goods – Excel - First Option Preview 06:12

In this lecture, I will show you how to use the solver to find an optimal solution to the case of planning the flow of finished goods between factories and markets

Car Industry – Planning the flow of finished goods – Excel - Second Option Preview 03:02

In this lecture I will show you how to use solver to find optimal solution to the case of planning the flow of finished goods between factories and markets

Why production optimization is replaced by flow Preview 03:34

You may have the urge to plan all the operations on the production floor. Yet in SMCG due to the number of components and process it is much better to find ways for the process to speak to each other. In this lecture I will why implementing the flow in SMCG is much better than trying to plan everything

Kanban introduction Preview 03:36

Kanban is a way in which you can drastically limit work in progress. I will show you in this lecture what it is and how it looks like in practice

Kanban in Excel Preview 02:03

I will show you how to calculate the impact of Kanban in Excel

Continuous flow - introduction Preview 04:09

The ideal in production is the so called continuous flow -every go smoothly and fast. Products are being produced      fast and cheap. In this section I will tell you how to achieve it.

How not to make continuous flow – sandwich factory Preview 04:06

Using a sandwich factory I will show you the mistakes people do when they try to create a continuous flow

How to make continuous flow – sandwich factory no kanban Preview 03:11

I will continue our example of sandwich factory. I will show you how the continuous flow should look like

How to make continuous flow – sandwich factory with kanban Preview 02:43

I will continue our example of sandwich factory. We add the Kanban to the continuous flow

Continuous flow in services Preview 07:24

I show here example of continuous flow in services

Introduction to Commodity Supply Chain Preview 00:39

In this section I will show you overview of the Commodity Supply Chain, main challenges and series of cases that will show you how to get the full potential of the Supply Chain

Overview of Supply Chain in commodity Preview 01:35

Commodity is a basic good used in commerce that is interchangeable with other commodities of the same type. Commodity chain is based on gathering resources, transforming them into commodities and finally distributing them to consumers

Main challenges in Supply Chain in commodity Preview 03:20

There are number of challenges in the Supply Chain in commodity. I will discuss them briefly in this lecture

Introduction to cases for commodity Preview 00:46

I will show you in short here what cases we will do in this section

Why you need to do capacity management? Preview 02:07

Apart from optimizing the production you have to think strategically and know when you have to add new capacity / factory. In this section I will show you how you can do that

How to manage capacity? Preview 03:41

Here I will show you how to manage capacity depending on your industry and demand forecast. 

Supplier catchment area Preview 02:26

Locations of some factories depends on the so called supplier catchment area. You are looking for area where you have sufficient amount of resources or suppliers. Here we will see how catchment area influences decision on capacities

Customer catchment area Preview 02:24

The customer catchment area is important in picking the right location for the factory. Both B2B as well as B2C. Here I will show you how to approach this subject

Catchment area / reach analysis - B2B Preview 03:50

In this lecture we show how you can measure and analyze what is the maximal reach of your B2B bussiness having in mind transportation costs and markups. We will provide you with fast way to identify potential customers and measure your targeted price on a specific foreign market

Finding the best spot for your factory – Introduction Preview 02:17

Let’s have a look at plywood producer that has 2 factories and is considering where to build the third one

Finding the best spot for your factory – Cost comparison - Excel Preview 03:54

In this lecture we will compare the cost for 3 different spots for the plywood factories

Finding the best spot for your factory – NPV for every project - Excel Preview 04:17

In this lecture we will calculate and compare the NPV for 3 different spots for the plywood factories

Introduction to Distribution Model Preview 01: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 Model Preview 02: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 distribution Preview 01:54

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

Different types of distribution Preview 02:08

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

Different types of distribution - Pros and Cons Preview 03:18

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

Where you can find savings in distribution Preview 02: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 Distribution Preview 03: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

Introduction to Sales forecasting and customer service Preview 01:49

Sales forecasting gives the input data for the whole supply chain. Even small glitches in this part cause huge problems in the whole supply chain.  In this section I will show you: goals of sales forecasting, Sales forecasting and customer service value drivers, typical problems in sales forecasting 

Goals of sales forecasting and customer service Preview 01:45

In this lecture we will discuss the goals of sales forecasting and customer experience and how there are linked to the overall goals of supply chain

Sales forecasting and customer service value drivers Preview 01:25

We have number of drivers through which sales forecasting can influence the EBITDA of the company. In this lecture I will show you the main ones

Typical problems in sales forecasting and customer service Preview 02:48

There are a few typical problem that usually occur in sales forecasting and customer service. I will go through the ones you should pay attention as well as I will show you  what analyses you should carry out to see whether they exist in your customer’s company

Introduction to Production Planning Preview 00:45

Production planning is the brain of the supply chain. If you get this wrong the other things won’t matter.  In this section, I will show you: goals of production planning, production planning value drivers, typical problems in production planning.

Goals of Production Planning Preview 00:45

The primary goal of Production Planning is to efficiently produce, with low inventory and provide at the same time on-time delivery. I will discuss what does it mean in practice.

Production Planning Value Drivers Preview 01:37

Several drivers related to production planning have impacts on value generation. In this lecture, I will go over them so you know when to look for potential improvements.

Typical problems in Production Planning Preview 02:38

There are a few typical problems that usually occur in production planning. I will go through the ones you should pay attention to well as I will show you what analyses you should carry out to see whether they exist in your customer’s company.

Introduction to Purchasing Preview 00:40

Purchasing has a big impact not only on cost but also the inventory levels. Wrong quality of products bought will lead to problems both in sales and in production.  In this section, I will show you: goals of purchasing, purchasing value drivers, typical problems in purchasing.

Goals of Purchasing Preview 01:26

The primary goals of Purchasing is to buy what is needed at lowest possible cost and keeping low inventory at the same time. I will discuss what does it mean in practice

Purchasing Value Drivers Preview 02:21

Several drivers related to purchasing have impacts on value generation.  In this lecture, I will go over them so you know when to look for potential improvements.

Typical problems in Purchasing Preview 03:30

There are a few typical problems that usually occur in Purchasing. I will go through the ones you should pay attention to. On top of that, I will show you what analyses you should carry out to see whether they exist in your customer’s company.