Purchasing Procurement Analyses for Management Consultants

Purchasing Procurement Analyses for Management Consultants

What you’ll learn

How to conduct fast and efficiently analyses in Excel devoted to Purchasing
How to find ways to cut costs in Purchasing & Procurement
How to identify potential ways to improve your liquidity, especially quick wins n Purchasing & Procurement
Analyze investments in Capex
Conduct Make-or-buy analysis

Requirements

Basic or intermediate Excel
Basic or intermediate knowledge of finance & accounting

Description

What is the aim of this course?During Consulting Projects a lot of attention will be devoted to Purchasing & Procurement. Usually, this area generates big cost reductions and helps improve liquidity. Finding potential savings is not always easy and requires a well-organized approach to purchases done by companies. Luckily, there are a lot of techniques and frameworks that will help you in a structured way to look for savings and potential improvements in liquidity. In this course, I will teach you how to perform fast and efficiently different types of analyses in Purchasing & Procurement.In the course you will learn the following things:General information about Purchasing & Procurement.Useful frameworks for analyzing Purchasing & Procurement.How to find ways to cut costs in Purchasing & Procurement.How to identify potential ways to improve your liquidity, especially quick wins.How to estimate in Excel the potential impact of proposed changes.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 turnarounds in the biggest firms in the Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in 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 182 000 students including people working in EY, McKinsey, 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, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and 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 modifications, be applied by you or your team in your work.Why have I decided to create this course?Performance improvement projects devoted to Purchasing & Procurement are fast-paced and require you a lot of hard work. You have to also master fast the basic information about a specific industry to provide the customer with relevant advice. Most firms, don’t give you the full toolbox that you need. This may lead to huge frustration during consulting projects devoted to performance improvement in purchasing, procurement, and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need during consulting projects devoted to optimizing Purchasing & Procurement. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to Purchasing & Procurement. You will master how to analyze data and draw conclusions from the analyses.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of Purchasing & Procurement projects and analyses done during such projects. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business school. The course will help you become an expert in analyses of Purchasing & Procurement on the level of McKinsey, BCG, Bain, and other top consulting firms.In what way will you benefit from this course?The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand, and analyze the businesses. 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 learn:General information about Purchasing & Procurement.Useful frameworks for analyzing Purchasing & Procurement.How to find ways to cut costs in Purchasing & Procurement.How to identify potential ways to improve your liquidity, especially quick wins.How to estimate in Excel the potential impact of proposed changes.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 introduction to the course as well as some general info on how the course is organized.General Information on Purchasing. In this section, I will show you the goals, KPIs, and typical problems that you can come across in Purchasing.Useful Frameworks for Analyzing Purchasing. In this brief section, I will shed some light on standard frameworks that you can use during consulting projects to analyze Purchasing & Procurement.Quick wins. During consulting projects, you will be pressed for time. Therefore, you have to identify quick wins that will help you achieve a big impact fast. In this section, we will see how you can do that fast.Make-or-buy analysis. Make-or-buy analysis is an extremely important tool that will help you decide in a rational way what you should do in-house and what to buy. In this section, I will show you how to use this tool in practice.Reduce usage. You can achieve a lot by reducing how often you use something or changing its specification. In this section, we will discuss in this section this area of savings.Renegotiate prices. Prices have a huge impact on how much we spent on purchasing. Therefore, if you address these issues properly you can achieve huge savings. In this section, we will see how you can approach this topic.Specification overview. One of the ways to determine exact requirements before you buy something is to create the so-called specification where you describe what is needed. In this section, we will discuss this method in more detail.Revise Investment. Many firms spend millions on investments to scale their businesses. Therefore, it is crucial to analyze investments if cash is a challenge. In this section, we will look at some examples of such analyses.Increase Cash. Purchasing Department can immensely help in increasing the cash position of the firm by lowering inventory, reducing costs, and extending payables. In this section, we will do a few analyses that will show you how to do them in Excel.You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will be able to…How to conduct fast and efficiently analyses in Excel devoted to PurchasingHow to find ways to cut costs in Purchasing & Procurement.How to identify potential ways to improve your liquidity, especially quick winsAnalyze investments in CapexConduct make-or-buy analysisWho should take this course?Management Consultants and Business AnalystsManagers working in the Supply ChainAnalysts in the Supply Chain or Purchasing DepartmentFinancial ControllersInvestment AnalystsStartup FoundersProject ManagersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 A little bit about me

Lecture 3 How to deal with Blurry image

Lecture 4 How to reach additional resources

Section 2: Purchasing – general information

Lecture 5 Introduction to Purchasing

Lecture 6 Goals of Purchasing

Lecture 7 Purchasing Value Drivers

Lecture 8 Typical problems in Purchasing

Lecture 9 Where is Purchasing Located in the organization

Section 3: Useful Frameworks for Analyzing Purchasing

Lecture 10 Useful Frameworks for Analyzing Purchasing – Introduction

Lecture 11 Cost reduction framework

Lecture 12 Cost reduction framework – Purchasing Impact

Lecture 13 General framework for Liquidity Improvement

Lecture 14 Liquidity Improvement Framework – Purchasing Impact

Section 4: Quick wins

Lecture 15 Quick wins – Introduction

Lecture 16 80/20 – productivity hacks

Lecture 17 Low-hanging fruits framework

Lecture 18 Quick wins for cost reduction

Lecture 19 Quick wins for cost reduction – Remarks on Pontetial Savings

Lecture 20 Quick wins in Drugstore – Case Introduction

Lecture 21 Quick wins in Drugstore – Cost Structure

Lecture 22 Quick wins in Drugstore – Cost Reduction

Lecture 23 Quick wins in Drugstore – Summary

Lecture 24 How to estimate the potential reduction in costs

Lecture 25 Quick wins for Purchasing

Lecture 26 Purchasing costs estimation – Case Introduction

Lecture 27 Purchasing costs estimation – Data Available

Lecture 28 Purchasing costs estimation – Cost Estimation

Lecture 29 Purchasing costs estimation – Cost Summary & Potential Savings

Section 5: Make-or-buy analysis

Lecture 30 Make-or-buy analysis – Introduction

Lecture 31 Total cost of ownership

Lecture 32 Car vs Uber – Introduction

Lecture 33 Car vs Uber – Cost of own car Basic

Lecture 34 Car vs Uber – Uber

Lecture 35 Car vs Uber – Comparison of costs

Lecture 36 Make-or-buy courses – Case Introduction

Lecture 37 Make-or-buy courses – Make Option

Lecture 38 Make-or-buy courses – Buy Option

Lecture 39 Make-or-buy courses – Comparison

Lecture 40 Make it or buy it – When to make even if it is more expensive

Lecture 41 Delegating some work to others – Case Introduction

Lecture 42 Delegating some work to others – Analysis of activities

Lecture 43 Delegating some work to others – Summary

Lecture 44 Capex vs Opex

Lecture 45 Construction work option analysis – Case Introduction

Lecture 46 Construction work option analysis – Data Available

Lecture 47 Construction work option analysis – Solution

Lecture 48 Choice of floor in a Retailer – Case Introduction

Lecture 49 Choice of floor in a Retailer – Data Available

Lecture 50 Choice of floor in a Retailer – Solution

Section 6: Reduce usage

Lecture 51 Reduce usage – Introduction

Lecture 52 Eliminate fully certain expenses – Consulting Firm – Case Introduction

Lecture 53 Eliminate fully certain expenses – Consulting Firm – Available Data

Lecture 54 Eliminate fully certain expenses – Consulting Firm – Solution

Lecture 55 Use less – Cosmetics Producer – Case Introduction

Lecture 56 Use less – Cosmetics Producer – Available Data

Lecture 57 Use less – Cosmetics Producer – Solution in Excel

Lecture 58 Use less – Cosmetics Producer – Impact on Inventory

Lecture 59 Use cheaper substiute – Drugstore chain – Case Introduction

Lecture 60 Use cheaper substiute – Drugstore chain – Available Data

Lecture 61 Use cheaper substiute – Drugstore chain – HQ Analyses

Lecture 62 Use cheaper substiute – Drugstore chain – Boxes & Summary

Section 7: Renegotiate prices – Introduction

Lecture 63 Renegotiate prices – Introduction

Lecture 64 How to gather data on prices

Lecture 65 Seasonality of prices

Lecture 66 Bread producer – Case Introduction

Lecture 67 Bread producer – Data Available

Lecture 68 Bread producer – Spot and Bulk Buying

Lecture 69 Bread producer – Mixed Buying

Lecture 70 Value Streaming Analysis

Lecture 71 Implied price of cardboard boxes – Case Introduction

Lecture 72 Implied price of cardboard boxes – Case Drivers

Lecture 73 Implied price of cardboard boxes – Data Available

Lecture 74 Implied price of cardboard boxes – Solution

Section 8: Specification overview

Lecture 75 Specification overview – Introduction

Lecture 76 Why you should create specifications?

Lecture 77 How to use specification to reduce costs – Framework

Lecture 78 Ask what is the purpose of the specific parameter

Lecture 79 Purchase of computers – Case Introduction

Lecture 80 Purchase of computers – Case Solution

Lecture 81 5 Why

Lecture 82 Remove things that you no longer need

Lecture 83 Remove things that bring only marginal improvement

Lecture 84 Introduce modularity

Lecture 85 Christmas packaging – Case Introduction

Lecture 86 Christmas packaging – Data Available

Lecture 87 Christmas packaging – Solution

Lecture 88 Standardize components for different products

Lecture 89 Standardize components for different products – Data Available

Lecture 90 Standardize components for different products – Solution

Lecture 91 Create Standard choices

Section 9: Revise Investment

Lecture 92 Revise Investment – Introduction

Lecture 93 General framework for Revising Investment

Lecture 94 Investments – General thoughts

Lecture 95 Investment in bottleneck removal – Introduction

Lecture 96 Investment in bottleneck removal – Costs

Lecture 97 Investment in bottleneck removal – Benefits

Lecture 98 Investment in bottleneck removal – NPV

Lecture 99 Investment in bottleneck removal – Solution in Power Point

Lecture 100 Cost reduction Investment – Retail – Introduction

Lecture 101 Cost reduction Investment – Retail – Current Costs

Lecture 102 Cost reduction Investment – Retail – Future Costs

Lecture 103 Cost reduction Investment – Retail – Future Costs

Lecture 104 Cost reduction Investment – Retail – Solution in PowerPoint

Section 10: Increase Cash

Lecture 105 Increase Cash – Introduction

Lecture 106 Components of Inventory

Lecture 107 General framework for Inventory Reduction

Lecture 108 Unify packaging & materials – Introduction

Lecture 109 General framework for Payables Improvement

Lecture 110 Payables Improvement – Case Introduction

Lecture 111 Reduce Cash Gap – Medium Increase of Payables

Lecture 112 Reduce Cash Gap – Big Increase of Payables

Lecture 113 Reduce Cash Gap – Small Increase of Prices

Lecture 114 Reduce Cash Gap – Big Increase of Prices

Lecture 115 Reduce Cash Gap – Summary

Section 11: Conclusions

Lecture 116 Bonus Lecture

Management Consultants and Business Analysts,Managers working in the Supply Chain,Analysts in the Supply Chain or Purchasing Department,Financial Controllers,Financial Controllers,Financial Controllers

Course Information:

Udemy | English | 5h 6m | 1.25 GB
Created by: Asen Gyczew

You Can See More Courses in the Business >> Greetings from CourseDown.com