Headcount Workforce Optimization for Management Consultant

Headcount Workforce Optimization for Management Consultant

What you’ll learn

How to conduct fast and efficiently analyses in Excel related to Headcount & Workforce Optimization
How to estimate the required number of people for specific set of tasks, or projects
What kind of analyses you will be performing during Headcount Optimization Projects?
What frameworks you can use for Headcount Optimization
How to estimate in Excel the impact of potential improvements
How to optimize processes, to do the same job with fewer people?
How to analyze motivation/bonus system

Requirements

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

Description

What is the aim of this course?Consulting firms are hired very often to help in Headcount Optimization. Those projects are difficult as you have to find the right balance between reducing costs and maximizing the value of the business. You not only have to find ways to remove inefficiencies but also calculate in Excel the potential impact on the company and its value. In this course, I will teach how to perform fast and efficiently different types of analyses during projects dedicated to Headcount Optimization.In the course you will learn the following things:What kind of analyses you will be performing during Headcount Optimization Projects?What frameworks you can use for Headcount OptimizationHow to estimate in Excel the impact of potential improvementsHow to optimize processes, to do the same job with fewer people?How to analyze the motivation systemThis 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 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 181 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?Headcount Optimization Projects are fast-paced and require from you a lot of hard work. You have to not only understand the business and the process but also see how this impacts the headcount now and in the future. Most firms don’t give you the full toolbox that you need to analyze the headcount. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students do analyses related to the headcount, especially done during consulting projects devoted to performance improvement. 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 Headcount Optimization Projects. You will master how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to motivation systems.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 Headcount Optimization and analyses done during consulting projects devoted to that area. 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 Headcount Optimization 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 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:What kind of analyses you will be performing during Headcount Optimization Projects?What frameworks you can use for Headcount OptimizationHow to estimate in Excel the impact of potential improvementsHow to optimize processes, to do the same job with fewer people?How to analyze the motivation systemYou can also ask me any question either through the discussion field or by messaging me directly.How is the course 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 organizedEssential Analyses. There are several analyses that can be used for Headcount Optimization. In this section, we will discuss the most popular of them and show how to use them.Frameworks. It’s always a good idea to have standard frameworks that you can use during consulting projects to know what to do. Let’s look at frameworks that will be useful during Headcount Optimization.Case Studies. Now, we will have a look at different case studies where we will apply the things, we have learned in previous sections to optimize the headcount.Optimization of in-store processes – Case Study. In this section, we will optimize the processes in a chain of home improvement stores. This will show you how you can do the same work with fewer people.Motivation System Analysis. As a part of Headcount Optimization projects, you will also have to analyze the Motivation System System. Let’s have a look at some examples of such analyses.You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses presented 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 related to Headcount OptimizationHow to estimate the required number of people for a specific set of tasks, or projectsWhat kind of analyses you will be performing during Headcount Optimization Projects?What frameworks you can use for Headcount OptimizationHow to estimate in Excel the impact of potential improvementsHow to optimize processes, to do the same job with fewer people?How to analyze the motivation systemWho should take this course? Who should not?Management ConsultantsBusiness AnalystsManagersFinancial ControllersStartup 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 this course will be organized?

Lecture 4 How to deal with Blurry image

Lecture 5 How to reach additional resources

Section 2: Essential Analyses

Lecture 6 Essential Analyses – Introduction

Lecture 7 Benchmarks – external and internal

Lecture 8 How to use benchmarks for Headcount Optimization

Lecture 9 Overall Labor Efficiency – Introduction

Lecture 10 OEE and OLE

Lecture 11 What happens with Jorge time – Introduction

Lecture 12 What happens with Jorge time – Data for the case

Lecture 13 What happens with Jorge time – Analysis of data

Lecture 14 What happens with Jorge time – OLE & Improvements

Lecture 15 Workload Analysis

Lecture 16 Seasonality Analysis

Lecture 17 Organizational Chart – Introduction

Lecture 18 Organizational Chart – FMCG

Lecture 19 Organizational Chart – Consulting Firm

Lecture 20 Mapping the areas for improvements – Organizational Chart

Section 3: Frameworks

Lecture 21 Frameworks – Introduction

Lecture 22 The General Framework for Headcount Optimization

Lecture 23 Adjust to the Seasonality

Lecture 24 Adjusting Headcount in Retail – Case Introduction

Lecture 25 Adjusting Headcount in Retail – Data Available

Lecture 26 Adjusting Headcount in Retail – Solution

Lecture 27 Adjusting Headcount in Retail – Simulation

Lecture 28 Headcount for Stores – Case Introduction

Lecture 29 Headcount for Stores – Data Available

Lecture 30 Headcount for Stores – Solution

Lecture 31 Increase Productivity & Automate

Lecture 32 Change Organizational Chart

Lecture 33 Simplify Org Chart in FMCG – Case Introduction

Lecture 34 Simplify Org Chart in FMCG – Data Available

Lecture 35 Simplify Org Chart in FMCG – Solution

Lecture 36 Mapping the areas for improvements – Organizational Chart

Lecture 37 Lower cost of 1 FTE

Lecture 38 Lower Labor Costs – Case Introduction

Lecture 39 Lower Labor Costs – Data Available

Lecture 40 Lower Labor Costs – Solution

Lecture 41 Adjust Motivation System

Lecture 42 Improve processes

Lecture 43 Efficiency of Support Team – Case Introduction

Lecture 44 Efficiency of Support Team – Data Available

Lecture 45 Efficiency of Support Team – Solution

Section 4: Case Studies

Lecture 46 Case Studies – Case Introduction

Lecture 47 Make the Process Scalable – General Approach

Lecture 48 Make the Process Scalable – Case Introduction

Lecture 49 Make the Process Scalable – Case – Current Situation

Lecture 50 Make the Process Scalable – Case – Future Situation & Comparison

Lecture 51 Cost reduction Investment – Ceramic Tiles – Introduction

Lecture 52 Cost reduction Investment – Ceramic Tiles – Current Costs

Lecture 53 Cost reduction Investment – Ceramic Tiles – Future Costs

Lecture 54 Cost reduction Investment – Ceramic Tiles – NPV

Lecture 55 Cost reduction Investment – Ceramic Tiles – Solution in Power Point

Lecture 56 Specialization in SaaS Sales Force – Case Introduction

Lecture 57 Specialization in SaaS Sales Force – Data Available

Lecture 58 Specialization in SaaS Sales Force – Current Situation

Lecture 59 Specialization in SaaS Sales Force – Future Situation

Lecture 60 Head Office expansion – Case Introduction

Lecture 61 Head Office expansion – Data Available

Lecture 62 Head Office expansion – Solution

Section 5: Optimization of in-store processes – case study

Lecture 63 Introduction to in-store process optimization case

Lecture 64 Workshop – Introduction

Lecture 65 Workshop – the scope of the project

Lecture 66 Workshop – Tools overview

Lecture 67 Lean manufacturing – introduction

Lecture 68 Theory of constraints – introduction

Lecture 69 Queing problem – introduction

Lecture 70 OEE introduction

Lecture 71 Workshop – Defining metrics and cost drivers

Lecture 72 Workshop – Optimizing 1 process

Lecture 73 Workshop – Optimizing 1 process – Excel file

Lecture 74 Workshop – Timeline of the project

Lecture 75 The store and the processes

Lecture 76 Price Change

Lecture 77 Price Change – Calculation in Excel

Lecture 78 Shelf replenishment

Lecture 79 Shelf replenishment – Calculation in Excel

Lecture 80 Advising customers – Introduction

Lecture 81 Advising customers – General solution

Lecture 82 Advising customers – Details and results

Lecture 83 Advising customers – calculation in Excel

Lecture 84 Cash till and info point

Lecture 85 Other potential improvements

Lecture 86 Process cost estimation by groups

Lecture 87 Summary of all costs and savings

Section 6: Motivation System Analysis

Lecture 88 Motivation System Analysis

Lecture 89 How to use KPIs to motivate – Introduction

Lecture 90 Where you should put KPIs to motivate people

Lecture 91 Overview of cases that we will discuss in this section

Lecture 92 How to analyze the motivation system of sales force – Introduction

Lecture 93 How to analyze the motivation system of sales force – Solution

Lecture 94 Juice producer – motivation system of sales force – Introduction

Lecture 95 Juice producer – motivation system of sales force – Solution – Area Manager

Lecture 96 Juice producer – motivation system of sales force – Solution – Sales Rep

Lecture 97 How bad KPIs in production can cause troubles – Problem

Lecture 98 How bad KPIs in production can cause troubles – Solution

Lecture 99 Board of directors motivation system – Problem

Lecture 100 Board of directors motivation system – General Solution

Lecture 101 Board of directors motivation system – Detailed Solution

Lecture 102 More Content on Motivation Systems

Section 7: Conclusions

Lecture 103 Bonus Lecture

Management Consultants,Business Analysts,Managers,Financial Controllers,Startup Founders,Project Managers

Course Information:

Udemy | English | 4h 46m | 1.19 GB
Created by: Asen Gyczew

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