Last updated 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.55 GB | Duration: 5h 36m
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
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
