Supply Chain For Management Consultants & Business Analysts

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

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:   How to understand supply chain activities   How to optimize the supply chain to get more things done, cheaper at higher quality with fewer resources   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:   How to understand supply chain   How to optimize it   Where to look for savings and improvements   How to calculate the impact of proposed changes in Excel   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   Excels with analyses shown in the course   Presentation of slides shown in the course   Links to additional presentations and movies    Links to books worth readingAdditional Resources 

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 A little bit about me

Lecture 3 What to do if a blurry image appears

Lecture 4 How to find additional resources

Lecture 5 How to find information and ask questions

Section 2: General information on Supply Chain

Lecture 6 Introduction to general information on Supply Chain

Lecture 7 What is Supply Chain

Lecture 8 Components of Supply Chain

Lecture 9 Finding the strategic fit

Lecture 10 Comparison of efficient and responsive supply chain

Lecture 11 Lost sales and stock level

Lecture 12 How to tackle the uncertainty (buffering)

Lecture 13 KPIs for Supply Chain

Lecture 14 How much Supply Chain costs

Lecture 15 Types of consulting projects done in Supply Chain

Section 3: Retail - Examples of business analyses of Supply Chain

Lecture 16 Introduction to Retail Supply Chain

Lecture 17 Overview of Supply Chain in Retail

Lecture 18 Main challenges in Supply Chain in Retail

Lecture 19 Introduction to cases for Retail

Lecture 20 Groceries – warehouse optimization – Introduction

Lecture 21 Groceries – warehouse optimization – Current Cost estimation

Lecture 22 Groceries – warehouse optimization – Potential improvements

Lecture 23 Groceries – warehouse optimization – Estimation of savings in Excel

Lecture 24 Measuring the capacity of Central Warehouse – Introduction

Lecture 25 Measuring the capacity of Central Warehouse – Tips

Lecture 26 Measuring the capacity of Central Warehouse – Capacity in Excel

Lecture 27 Measuring the capacity of Central Warehouse – Cost in Excel

Lecture 28 Convenience stores - Analysis of tariffs – Introduction

Lecture 29 Convenience stores - Analysis of tariffs – Tips how to do it

Lecture 30 Convenience stores - Analysis of tariffs – Solution

Lecture 31 How to find the minimal values faster

Lecture 32 DIY - internal logistics optimization – Introduction

Lecture 33 DIY - internal logistics optimization – Solution

Lecture 34 DIY - internal logistics optimization – Solution in Excel

Lecture 35 Retailer new & old stores – Case Introduction

Lecture 36 Retailer new & old stores – Drivers

Lecture 37 Retailer new & old stores – Data Available

Lecture 38 Retailer new & old stores – New Stores

Lecture 39 Retailer new & old stores – Old stores

Lecture 40 Retailer new & old stores – Change

Section 4: FMCG - Examples of business analyses of Supply Chain

Lecture 41 Introduction to FMCG Supply Chain

Lecture 42 Overview of Supply Chain in FMCG

Lecture 43 Main challenges in Supply Chain in FMCG

Lecture 44 Introduction to cases for FMCG

Lecture 45 Chicken Producer - Top-down approach - Introduction

Lecture 46 Chicken Producer - Top-down approach - Tips how to do it

Lecture 47 Chicken Producer - Top-down approach - Solution

Lecture 48 Chicken Producer - Fuel usage - Introduction

Lecture 49 Chicken Producer - Fuel usage - Tips how to do it

Lecture 50 Chicken Producer - Fuel usage - Solution

Lecture 51 Chicken Producer - Overtime analysis - Introduction

Lecture 52 Chicken Producer - Overtime analysis - Tips how to do it

Lecture 53 Chicken Producer - Overtime analysis - Solution

Lecture 54 Juice Producer - Simulation - Introduction

Lecture 55 Juice Producer - Simulation - Tips how to do it

Lecture 56 Juice Producer - Simulation - Solution

Lecture 57 Optimal production batch analysis - FMCG

Lecture 58 2-stage production planning

Lecture 59 Cheese Production – Case Introduction

Lecture 60 Cheese Production – Cost Calcuations

Lecture 61 Cheese Production – Simulations

Section 5: SMCG - Examples of business analyses of Supply Chain

Lecture 62 Introduction to SMCG Supply Chain

Lecture 63 Overview of Supply Chain in SMCG

Lecture 64 Main challenges in Supply Chain in SMCG

Lecture 65 Introduction to cases for SMCG

Lecture 66 Transportation mode vs value density – Introduction

Lecture 67 Transportation mode vs value density – Solution in Excel

Lecture 68 Car Industry – Planning the flow of finished goods – Introduction

Lecture 69 Car Industry – Planning the flow of finished goods – Excel - First Option

Lecture 70 Car Industry – Planning the flow of finished goods – Excel - Second Option

Lecture 71 Why production optimization is replaced by flow

Lecture 72 Kanban introduction

Lecture 73 Kanban in Excel

Lecture 74 Continuous flow - introduction

Lecture 75 How not to make continuous flow – sandwich factory

Lecture 76 How to make continuous flow – sandwich factory no kanban

Lecture 77 How to make continuous flow – sandwich factory with kanban

Lecture 78 Continuous flow in services

Section 6: Commodity - Examples of business analyses of Supply Chain

Lecture 79 Introduction to Commodity Supply Chain

Lecture 80 Overview of Supply Chain in commodity

Lecture 81 Main challenges in Supply Chain in commodity

Lecture 82 Introduction to cases for commodity

Lecture 83 Why you need to do capacity management?

Lecture 84 How to manage capacity?

Lecture 85 Supplier catchment area

Lecture 86 Customer catchment area

Lecture 87 Catchment area / reach analysis - B2B

Lecture 88 Finding the best spot for your factory – Introduction

Lecture 89 Finding the best spot for your factory – Cost comparison - Excel

Lecture 90 Finding the best spot for your factory – NPV for every project - Excel

Section 7: Distribution model - general information

Lecture 91 Introduction to Distribution Model

Lecture 92 Goals of Distribution Model

Lecture 93 Basic laws of distribution

Lecture 94 Different types of distribution

Lecture 95 Different types of distribution - Pros and Cons

Lecture 96 Where you can find savings in distribution

Lecture 97 Typical problems in Distribution

Section 8: Sales forecasting and customer service - general information

Lecture 98 Introduction to Sales forecasting and customer service

Lecture 99 Goals of sales forecasting and customer service

Lecture 100 Sales forecasting and customer service value drivers

Lecture 101 Typical problems in sales forecasting and customer service

Lecture 102 Additional Resources on Sales Forecasting

Section 9: Production Planning - general information

Lecture 103 Introduction to Production Planning

Lecture 104 Goals of Production Planning

Lecture 105 Production Planning Value Drivers

Lecture 106 Typical problems in Production Planning

Lecture 107 Additional Resources on Production Planning

Section 10: Purchasing - general information

Lecture 108 Introduction to Purchasing

Lecture 109 Goals of Purchasing

Lecture 110 Purchasing Value Drivers

Lecture 111 Typical problems in Purchasing

Lecture 112 Additional Resources on Purchasing

Section 11: Conclusions

Lecture 113 Bonus Lecture

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