Supply Chain for Management Consultants & Business Analysts
4.1 (787 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.
4,717 students enrolled

Supply Chain for Management Consultants & Business Analysts

Practical guide how to improve supply chain in a firm and analyze potential savings in Excel during consulting project
4.1 (787 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.
4,717 students enrolled
Created by Asen Gyczew
Last updated 4/2020
English
English [Auto]
Current price: $132.99 Original price: $189.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 1 article
  • 45 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
  • 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 supply chain of any company 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 bases. In the course you will learn 3 things:

  1. How to understand supply chain activities
  2. How to optimize supply chain in order to get more things done, cheaper at higher quality with less resources
  3. Where to look for savings and improvements, how to calculate potential savings in Excel and implement them

The course is based on my 14 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from Retail, FMCG, SMG, B2B sector that I worked for. On many occasions I had to optimize the whole supply chain side of the businesses I was responsible for.  On the basis of what you will find in this course I have trained over 100 consultants, business analysts and managers who now are Supply Chain Directors, Operational  Directors, COO, Investment Directors, Directors in Consulting Companies, Board Members etc. On top of that my courses on Udemy were already taken by more than 28 000 students.

I teach through cases so most of the lectures are case studies showing some business problems solved in Excel. There will be also overview of main components of supply chain as well as some suggestion where you should look for improvements and savings. To every lecture you will find attached  (in additional resources) the Excels shown in the lecture 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 in your work.

Why 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 supply chain in every business. To make matters worse supply chain efficiency and performance has 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 chain 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 in supply chain. The funny things is that to be good at supply chain you do not even have to be technical at all. I have not finished any technical school and I am pretty good in finding significant improvements in 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 supply chain. That is why I highly recommend this course not only to consultants or business analyst that have to advice their customer 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 supply chain. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is 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 in 10 sections and will be adding new section to address other important issues. Currently you will find the following sections:

  • Introduction. We begin with 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 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
  • FMCG - Examples of business analyses of Supply Chain. In 4###sup/sup### 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
  • SMCG - Examples of business analyses of Supply Chain. In 5###sup/sup### 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
  • Commodity - Examples of business analyses of Supply Chain. 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
  • Distribution model - general information. 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
  • 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 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 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

I will be adding new sections and lectures in the coming months

 

You will be able also to download many additional resources

  1. Excels with analyses shown in the course
  2. Presentation of slides show in the course
  3. Links to additional presentations and movies
  4. Links to books worth reading
Who this course is for:
  • Consultants
  • Management Consultants
  • Business Analysts
  • Supply Chain Managers
  • Small and medium business owners
  • Startups founders
  • Controllers
Course content
Expand all 99 lectures 05:05:24
+ Introduction
4 lectures 07:39

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

Preview 02:43

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

Preview 01:47

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

What to do if a blurry image appears
02:04

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

How to find additional resources
01:05
+ General information on Supply Chain
10 lectures 30:03

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

Preview 01:39

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

Preview 03:00

In  this lecture I will discuss the components of supply chain

Preview 02:14

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

Preview 06:36

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

Comparison of efficient and responsive supply chain
03:58

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.

Lost sales and stock level
03:48

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

How to tackle the uncertainty (buffering)
02:35

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

KPIs for Supply Chain
02:38

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

How much Supply Chain costs
01:18

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

Types of consulting projects done in Supply Chain
02:17
+ Retail - Examples of business analyses of Supply Chain
18 lectures 54:28

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

Preview 00:43

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

Preview 02:22

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

Main challenges in Supply Chain in Retail
04:08

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

Introduction to cases for Retail
01:03

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

Preview 02:55

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

Preview 05:11

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

Preview 02:21

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

Preview 03:47

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 – Introduction
02:33

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 – Tips
03:13

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 – Capacity in Excel
06:20

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

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

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 – Introduction
03:38

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 – 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

Convenience stores - Analysis of tariffs – Solution
02:27

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 – Introduction
00:45

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
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
02:23
+ FMCG - Examples of business analyses of Supply Chain
18 lectures 01:28:22

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

Introduction to FMCG Supply Chain
00:46

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

Overview of Supply Chain in FMCG
01:41

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

Preview 04:40

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

Preview 01:39

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 - Introduction
06:25

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 - Tips how to do it
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

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

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 - Introduction
03:46

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 - Tips how to do it
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

Chicken Producer - Fuel usage - Solution
02:28

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

Chicken Producer - 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

Chicken Producer - 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

Chicken Producer - Overtime analysis - Solution
02:48

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 - Introduction
04:28

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

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

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

Juice Producer - Simulation - Solution
08:33

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

Optimal production batch analysis - FMCG
06:37

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.

Preview 05:32
+ SMCG - Examples of business analyses of Supply Chain
17 lectures 53:59

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

Preview 00:35

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

Preview 02:11

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

Main challenges in Supply Chain in SMCG
04:04

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

Introduction to cases for SMCG
01:38

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 – Introduction
00:32

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

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

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

Preview 00:33

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

Preview 06:12

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

Preview 03:02

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

Why production optimization is replaced by flow
03:34

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

Preview 03:36

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

Kanban in Excel
02:03

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.

Continuous flow - introduction
04:09

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

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

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 no kanban
03:11

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

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

I show here example of continuous flow in services

Continuous flow in services
07:24
+ Commodity - Examples of business analyses of Supply Chain
12 lectures 31:16

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

Introduction to Commodity Supply Chain
00:39

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

Overview of Supply Chain in commodity
01:35

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

Main challenges in Supply Chain in commodity
03:20

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

Introduction to cases for commodity
00:46

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

Why you need to do capacity management?
02:07

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

How to manage capacity?
03:41

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

Preview 02:26

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

Customer catchment area
02:24

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

Preview 03:50

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 – Introduction
02:17

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

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

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

Finding the best spot for your factory – NPV for every project - Excel
04:17
+ 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

Preview 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

Preview 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

Preview 02:08

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

Preview 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

Preview 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

Preview 03:45
+ Sales forecasting and customer service - general information
4 lectures 07:47

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 

Introduction to Sales forecasting and customer service
01:49

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

Goals of sales forecasting and customer service
01:45

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

Sales forecasting and customer service value drivers
01:25

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

Typical problems in sales forecasting and customer service
02:48
+ Production Planning - general information
4 lectures 05:45

Production planning is the brain of 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

Introduction to Production Planning
00:45

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

Goals of Production Planning
00:45

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

Production Planning Value Drivers
01:37

There are a few typical problem that usually occur in production planning. 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

Typical problems in Production Planning
02:38
+ Purchasing - general information
4 lectures 07:57

Purchasing has 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

Introduction to Purchasing
00:40

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

Goals of Purchasing
01:26

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

Purchasing Value Drivers
02:21

There are a few typical problem that usually occur in Purchasing. 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

Typical problems in Purchasing
03:30