Performance Improvement Projects For Management Consultants

How to conduct Performance Improvement Projects – Introduction Preview 01:39

In the second section I will show  you how such projects should be carried out to ensure that you deliver  value to the customer fast and efficiently

Aim of the Performance Improvement Projects Preview 03:05

To put it simply the aim of Performance improvement projects is to get higher profits from the business we have today. I will discuss in this lecture what exactly you have to do to achieve it

How to deliver Performance Improvement Projects Preview 04:47

Performance improvement consists of 3 stages. Consulting firm can participate in different form in each and one of them. In this lecture I will show you how to have to do on each and every stage of the project

Size of the team and duration of the project Preview 03:13

Size of the project will depend on the type of the project. Since we have 4 basic type of projects I will show you how the size of the team looks like for each and every type of projects

General framework for managing efficiently a consulting project Preview 04:02

Most consulting project are done in a bad manner. If you prepare properly you can shorten them, create more value and earn more. I will show you in this lecture how to do the project in the right order

Pricing of Performance Improvement Projects Preview 04:02

Companies use different pricing per position. Stronger brands are obviously more expensive. In this lecture I will show you how much the project can cost depending on the scope and the firm performing it

Case Study in Performance Improvement – Introduction Preview 01:59

In this section you will be asked to solve a case study in performance      improvement. I will also show you the solution and the analyses in Excel. This section will give you a flavor of how the Performance Improvement Projects look like

Case Study – General Information Preview 02:34

You were hired to support the new CEO of Canned Foods Incorporated in performance improvement project. In this section we will introduce the case study that you will have to solve during the next few lectures

Case Study – Solution – Main Problems of CFI Preview 04:04

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Inventory Reduction Preview 02:36

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Inventory Reduction – Excel Preview 02:56

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Stockouts Reduction Preview 03:47

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Stockouts Reduction – Excel Preview 02:20

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – math behind Fire Sale Preview 04:16

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Fire Sale Preview 02:04

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Fire Sale – Excel Preview 01:33

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Price Increase Preview 02:23

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Price Increase – Excel Preview 01:59

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Truck Reduction Preview 02:03

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Truck Reduction – Excel Preview 02:43

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Better Penetration Preview 02:07

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Better Penetration – Excel Preview 02:25

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – New Products Preview 02:13

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – New Products – Excel Preview 01:46

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Others Preview 02:54

Here I will show you part of the solution to the case study introduced in this section

Case Study – Solution – Summary Preview 02:03

Here I will show you part of the solution to the case study introduced in this section

Performance Improvement in Retail – Introduction Preview 01:52

In the 4th section I show you what kind of frameworks you should use during performance improvement projects in Retail. You will also go through a number of real life analyses from Performance Improvement Projects in Retail.   

Performance Improvement in Retail – Proposed project organization Preview 04:10

Here I will show you how I would recommend approaching the set-up for the Diagnostics phase of performance improvement

Introduction to the Retail Business Model Preview 04:14

We will start with a short introduction to retail business model

Main challenges in Retail Preview 03:02

I will start by showing main challenges in Retail

Business model of Retailer – main drivers Preview 02:12

I will show you in this lecture what KPI I the retail business model driven by. This will help you understand the modeling in Excel done in next lectures

Business model of Retailer in Excel – transaction version – 1 store Preview 03:58

Here I will show you how to model the Retailer business in Excel.

Business model of Retailer in Excel – transaction version – retail chain Preview 04:04

Here I will show you how to model the Retailer business in Excel.

Business model of Retailer in Excel – sq m version Preview 01:07

Here I will show you how to model the Retailer business in Excel.

Let's move to frameworks Preview 00:28

Here we will do a short intro into the next part of the section where we will discuss frameworks

Why you need frameworks Preview 01:35

Here I will show you useful fraemworks for performance improvement projects in retail

Issue tree – introduction Preview 01:44

Issue tree is a simple yet powerful concept used in consulting for structuring discussion and picking the right topics to concentrate on. In this lecture I will show you the principles of using it as well as a practical example

Issue tree example for a retailer Preview 03:47

In this lecture I will show you how the issue tree could look like for a retailer 

Increasing sales framework – Retail & B2C Services Preview 03:33

Here I will show you the general framework for increasing the sales in retail

Increasing margins framework – Retail & B2C Services Preview 03:14

Here I will show you the general framework for increasing the margin in retail

Cost reduction framework Preview 03:01

Here I will show you the general framework for decreasing the costs in retail

Cost reduction framework – Stores Preview 04:02

Here I will show you the general framework for decreasing the costs of stores in retail

Cost reduction framework – Head Office Preview 01:58

Here I will show you the general framework for decreasing the costs in the head office in retail

Let's move to case studies Preview 00:39

Here we will do a short intro into the next part of the section where we will show you examples of analyses done during consulting projects

Overview of analyses and case studies Preview 01:55

Here I will do an overview of cases and analyses I will show you in this section

How to increase the profitability of a retail chain – Problem Preview 01:36

Imagine that you are working for a fashion discounter that operates a retail chain in Easter Europe. You have to find ways to increase the profitability for this firm

How to increase the profitability of a retail chain – Solution – Sales Increase Preview 03:17

Here I will show you part of the solution to the case study introduced in this section

How to increase the profitability of a retail chain – Solution – Cost Reduction Preview 04:09

Imagine that you are working for a fashion discounter that operates a retail chain in Easter Europe. You have to find ways to increase the profitability for this firm

Product range analysis – Introduction Preview 01:51

In Retail you have space that you divide among different product groups. For every group you should calculate the total margin using sales density, % Gross Margin and space allocated to specific group. You have to analyze their performance and decide how to split the space. In this lecture I will show you the general concept

Product range analysis – Example Preview 03:30

Here I show an example of a product range analysis

Inventory analysis – Introduction Preview 03:10

We will continue with the example from previous lecture. In this  example of single store when we look at the sales and inventory level it is clear that there is too much stock. Let’s see what we can do about it

Inventory analysis – Excel Preview 03:12

We will continue with the example from previous lecture. In this  example of single store when we look at the sales and inventory level it is clear that there is too much stock. Let’s see what we can do about it

Saturating existing markets – Introduction Preview 01:11

If you are present on specific market you want to know when you will reach a saturation market – the maximal number of shops that will not cause much cannibalization. I will show you how to approach this subject

Saturating existing markets – Data for the case study Preview 03:12

We will now try to check in practice how to find saturation point for a retailer. In this lecture I will introduce the case that we will work with for the next few lectures. You will be asked to find the saturation for grocery store operating in Poland

Saturating existing markets – Number of Stores Preview 03:09

In this lecture we solve previously introduced case.

Saturating existing markets – Stores by concepts Preview 03:04

In this lecture we solve previously introduced case.

Saturating existing markets – Concept & Space Preview 03:46

In this lecture we solve previously introduced case.

Saturating existing markets – Solution in Power Point Preview 01:57

In this lecture we solve previously introduced case.

Expansion strategy into other countries – Introduction Preview 02:48

Creating an expansion strategy requires you to do a number of things. I will show you in this lecture how to approach this subject

Expansion strategy into other countries – Case Introduction Preview 02:17

In this lecture I will start the case study that we will be solving for the next few lectures. Imagine that you are a Spanish fashion retailer and you want to figure out which countries you should enter. Therefore, you prepare a ranking of countrires that show attractivness and the size of each and every market.

Expansion strategy into other countries – Data for the case study Preview 03:44

In this lecture we solve previously introduced case.

Expansion strategy into other countries – Which function to use Preview 04:53

In this lecture we solve previously introduced case.

Expansion strategy into other countries – Solution in Excel Preview 03:32

In this lecture we solve previously introduced case.

Expansion strategy into other countries – Solution in Power Point Preview 02:30

Expansion strategy into other countries – Solution in Power Point

Convenience stores – Analysis of tariffs – Introduction Preview 03:38

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 – Tips how to do it Preview 04:36

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 – Solution Preview 02:27

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

Groceries – warehouse optimization – Introduction Preview 02:55

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

Groceries – warehouse optimization – Current Cost estimation Preview 05:11

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

Groceries – warehouse optimization – Potential improvements Preview 02:21

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

Groceries – warehouse optimization – Estimation of savings in Excel Preview 03:47

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

DIY – internal logistics optimization – Introduction Preview 00:45

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 – Solution Preview 02:55

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 Preview 02:23

Here I will show you how we optimized the process of shelf replenishment in the store and what savings we managed to generate

Introduction to e–commerce Preview 20:57

In this lecture you will get insight into the business model of different e-commerce companies. E-commerce businesses group is very diversified so we will try to show the similarities and the differences between concepts.. You will learn here the definition of this business model, see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect.

Drivers for e–commerce Preview 03:17

Here I will show you main KPIs for e-commerce

Modeling of e–commerce in Excel Preview 09:11

Here I will show you the main KPIs that drive the e-commerce busines smodel

Let's move to discussion on the main challenges Preview 00:45

Here we will do a short intro into the next part of the section where we will discuss the mian challenges in Retail in sales and marketing as well as supply chain.

Overview of Sales in Retail Preview 01:24

Retail sell through its own stores. Yet they also have their online presence and try to sell via marketplaces

Overview of Marketing in Retail Preview 03:01

In this lecture I will show you what matters the most in marketing in this business model 

Main challenges in sales and marketing in Retail Preview 03:32

There are number of challenges in the Sales and Marketing in Retail. We will discuss them in this lecture briefly to give you a taste of what you can expect during a consulting project 

Overview of Supply Chain in Retail Preview 02:22

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 

Main challenges in Supply Chain in Retail Preview 04:08

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

Performance Improvement in Retail – techniques you should master Preview 02:36

Here I will show you main techqniues you should master to be great at the performance improvement in Retail

Performance Improvement in FMCG – Introduction Preview 01:39

I will show you what kind of frameworks you should use during performance improvement projects in FMCG. You will also go through a number of real life analyses from Performance Improvement Projects

Performance Improvement in FMCG – Proposed project organization Preview 03:15

In this lecture I will talk about how you can organize a performance improvement project in FMCG

Introduction to the FMCG Business Model Preview 00:51

In this section we will move to products. The first one to be discussed are FMCG products. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. As an example I will show you how to model in Excel Cosmetics business.

Things that matter in FMCG Business Model Preview 03:01

I will shortly go through things that are important in other FMCG.

Drivers for FMG business model Preview 01:52

I will show you in this lecture what KPIs, drivers are important for the FMCG model and how do they generated the end results – operating profti

FMCG business model in Excel - Introduction Preview 00:32

In the next few lectures I will show you how to model in Excle FMCG businesses

FMCG business model in Excel - Basic assumptions and Sales Preview 02:26

In this lecture I will go briefly through the main assumptions for the model that we will work on in Excel. I will also go through the first sheet in which I generate the sales

FMCG business model in Excel - Fixed and Variable Production Costs Preview 03:25

In this lecture I will show you how we will estimate the fixed and variable costs in production

FMCG business model in Excel - Gross Margin Preview 02:17

Here I will show you how to model Gross Margin for FMCG firms

FMCG business model in Excel - Cost of sales and marketing and Net Margin Preview 02:44

Now it is time to estimate the cost of sales by channels and cost of marketing

FMCG business model in Excel - Net Margin Preview 01:44

In this lecture I will show you how to estimate the Net Margin using Gross Margin and the cost of sales and marketing

FMCG business model in Excel - Head Office costs Preview 00:56

We have also take care of head office costs to get to profit and loss account

FMCG business model in Excel - P&L Preview 02:23

Finally we estimate the profit and loss account and we can try to draw conclusion on the business

Let's move to frameworks Preview 00:24

Here we will do a short intro into the next part of the section where we will discuss frameworks

Why you need frameworks and issue trees Preview 00:48

Frameworks help you decide where to dig for potential performance improvements. Here I will show you what kind of frameworks are useful when it comes to perfromance improvement in FMCG

Issue tree – introduction Preview 01:44

Issue tree is a simple yet powerful concept used in consulting for structuring discussion and picking the right topics to concentrate on. In this lecture I will show you the principles of using it as well as a practical example

Issue tree example for a FMCG firm Preview 04:41

Here I will show you ana example of Isse tree in FMCG

Increasing sales framework – Consumer Goods Preview 04:15

In this lecture I will show you the general framework for sales increase during perfromance improvement projects

Cost reduction framework Preview 03:01

In this lecture I will show you the general framework for cost reduction during perfromance improvement projects

Cost reduction framework – Sales & Marketing in FMCG Preview 02:30

Here I will into a little bit more detail on how to do  reduce costs in Sales and Marketing

Cost reduction framework – Head Office in FMCG Preview 01:58

In this lecture, I will show you the general framework for cost reduction in Headoffice costs during performance improvement projects

Let's move to case studies Preview 00:42

Here we will do a short intro into the next part of the section where we discuss examples of analyses from consulting projects

Cases and analysis examples – FMCG Preview 01:12

Here I will show you what cases  studies and analyses I will show you in this section

Sales force efficiency analysis – Introduction Preview 02:18

Let’s have a look at the sales force efficiency in Poland of a cosmetics producers. We will analyze the efficiency of sales force and look for ways to improve the margin

Sales force efficiency analysis – Solution – Part 1 – Unit Cost Preview 02:16

In this lecture I will show you how to solve the case shown in the previous lectures.

Sales force efficiency analysis – Solution – Part 2 – ABC analysis of Current si Preview 03:01

In this lecture I will show you how to solve the case shown in the previous lectures.

Sales force efficiency analysis – Solution – Part 3 – more on ABC analysis of Cu Preview 02:33

In this lecture I will show you how to solve the case shown in the previous lectures.

Sales force efficiency analysis – Solution – Part 4 – Margin Maximazation Preview 02:48

In this lecture I will show you how to solve the case shown in the previous lectures.

Sales force efficiency analysis – Solution – Part 5 – Specialization Preview 03:50

In this lecture I will show you how to solve the case shown in the previous lectures.

Sales force efficiency analysis – Solution – Part 6 – Summary Preview 02:22

In this lecture I will show you how to solve the case shown in the previous lectures.

Sales force efficiency analysis – Practical Tips Preview 03:27

In this lecture I will show you how to solve the case shown in the previous lectures.

How to expand the brand – Introduction Preview 02:38

Let’s have a look at milk producer that wants to expand its product range. In this case you will be asked to analyze and find the best candidates for brand expansions. 

How to expand the brand – Solution – Part 1 Preview 03:29

In this lecture I will show you how to solve the case shown in the previous lectures.

How to expand the brand – Solution – Part 2 Preview 02:58

In this lecture I will show you how to solve the case shown in the previous lectures.

How to find the white spaces untouched by your brand – Introduction Preview 01:03

I will show you in this lecture how to fidn the potential to grow on some local markets by finding white spots - places where you have lower than average shares

How to find the white spaces untouched by your brand – Solution – Per capita Preview 04:05

In this lecture I will show you how to solve the case shown in the previous lectures.

How to find the white spaces untouched by your brand – Solution – Local shares Preview 03:32

In this lecture I will show you how to solve the case shown in the previous lectures.

How to find the white spaces untouched by your brand – Solution – Presentation Preview 02:07

In this lecture I will show you how to solve the case shown in the previous lectures.

Chicken Producer – Fuel usage – Introduction Preview 03:46

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 – Tips how to do it Preview 05:04

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 – Solution Preview 02:28

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

Juice Producer – Simulation – Introduction Preview 04:28

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 – Tips how to do it Preview 08:23

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 – Solution Preview 08:33

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

Optimal production batch analysis – FMCG Preview 06:37

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

2–stage production planning Preview 05:32

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.

Performance Improvement in FMCG – techniques you should master Preview 03:32

Here I will show you which techniques, tools would be greate for you to master

Let's move to discussion on the main challenges Preview 00:25

Here we will do a short intro into the next part of the section where we will discussthe main challenges in sales and marketing as well as supply chain

Overview of Sales in FMCG Preview 01:35

FMCG sells mainly through retailers. Some go into independent distribution via own website and own stores. We will discuss all the options in this section

Overview of Marketing in FMCG Preview 04:16

In this lecture I will show you what matters the most in marketing in this business model

Main challenges in sales and marketing in FMCG Preview 03:11

There are number of challenges in the Sales and Marketing of FMCG. We will discuss them in this lecture briefly to give you a taste of what you can expect during a consulting project

Overview of Supply Chain in FMCG Preview 01:41

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

Main challenges in Supply Chain in FMCG Preview 04:40

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

Bonus Lecture Preview 01:14