
We begin with a little intro to the course as well as some general info on how the course is organized.
A few words about your humble teacher
A few words about how we have organized the course
Here I will show you what to do if a blurry image appears
Here I will show you how to find additional resources attached to the course like Excel files, presentations, links, etc.
· In the second section, we will look at some essential concepts that we will need to do the production planning. We will devote a lot of attention to removing bottlenecks.
In production planning, we use many terms, which are not always clear. In this part, we will discuss briefly the most commonly used terms.
To select the optimal option you have to take into consideration the following parameters
Loss of juice in liters
Set-up time
Price of juice
Shifts
Lack of inventory of some type of juice
Speed of the machine for different types of juice
In the next few lectures, I will concentrate on bottlenecks and capacity estimation
In every company, you have bottlenecks that limit your ability to go forward and deliver more goods and services. Here I will show you how to estimate what is the impact for the whole system and how you can remove improve them. I will use a simple production example to show you the effect on the whole system. You will see how the bottleneck can shift from 1 shift to another. You will also learn how to prioritize where it makes sense to invest to get the best results.
Before doing this lecture I strongly encourage you first to take the OEE lecture – we use the OEE concept here so if you are not familiar with it please start with the OEE lecture as a warm-up.
Your friend Ivan works in a content marketing agency and wants to improve the work of his team. Help him using the bottleneck framework
In every company, you have bottlenecks that limit your ability to go forward and deliver more goods and services. Here I will show you how to estimate what is the impact for the whole system and how you can remove improve them.
Now imagine that you were asked to increase the production capacity of a factory. Try also to calculate the financial impact of the proposed scenarios. Before we look at specific scenarios we have to discuss 2 issues
What the production capacity depends on?
How to calculate the monthly production capacity
First, let’s see what the production depends on assuming there is just 1 production stage
We have said that the production generally speaking depends on 3 drivers. Now let’s see how it looks like for the whole month
Here we will discuss the scenarios that we will analyze later.
Here we will discuss the scenarios that we will analyze later.
Here we will discuss the available data that we will use to solve the case study
In every company, you have bottlenecks that limit your ability to go forward and deliver more goods and services. Here I will show you how to estimate what is the impact for the whole system and how you can remove improve them. I will use a simple production example to show you the effect on the whole system. You will see how the bottleneck can shift from 1 shift to another. You will also learn how to prioritize where it makes sense to invest to get the best results.
Before doing this lecture I strongly encourage you first to take the OEE lecture – we use the OEE concept here so if you are not familiar with it please start with the OEE lecture as a warm-up.
In this lecture, we will see how you can present the result of the analysis in a form of graphs
One of the biggest problems for efficiency is the so-called Parkinson’s Law – Work expand so as to fill the time available for its completion. People when asked to evaluate the time certain things will take build-in buffers. One of the ways to deal with it is the so-called Critical chain. Here I will show you what it is
Production Planning impacts a lot of areas. Let’s see how it is linked to Sales Forecasting and Purchasing Planning.
The role of production planning will depend greatly on the production system used. Let’s discuss this briefly.
In many cases, Production Planning is a part of the Production Department. However, it may also be a part of the Supply Chain, Sales, or other departments.
In this brief section, I will show the main methods used in production planning.
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 example of juice producer
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 a 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 the example of a cosmetics producer how to create such a production plan, assuming optimal production batches for components and taking into account the inventories.
The future is pretty difficult to figure out. You don’t know what will happen. In those cases, it is a good idea to consider a few different scenarios. One of the ways to face it is via scenario analysis. I will show you how to use it in practice
Price formula in B2B services can drastically impact the margins and net profit. In this lecture, we will go through a case that will show you how to approach the analysis of the price formula with uncertainty on the scenario that will happen
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
Let’s imagine that a local bakery would like you to estimate the optimal production batch for muffins. You will use that scenario analysis.
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
In production planning, you have to decide how to organize production so that it is optimal not only from the point of view of production but the whole supply chain
The primary goal of Production Planning is to efficiently produce, with low inventory and provide at the same time on-time delivery. I will discuss what does it mean in practice.
Several drivers related to production planning have impacts on value generation. In this lecture, I will go over them so you know when to look for potential improvements.
There are a few typical problems that usually occur in production planning. I will go through the ones you should pay attention to well as I will show you what analyses you should carry out to see whether they exist in your customer’s company.
Now let’s have a look at more advanced methods of finding optimal production batches. They can be very useful in more complicated case studies.
In this lecture, I will discuss further more advanced techniques such as: simulation analysis, decomposition analysis, feasibility analysis, and sensitivity analysis
The future is pretty difficult to figure out. You can use scenario analysis or you check ALL the potential options and see which is optimal. I will talk about this technique in this lecture and when to apply it. The impact of the price change on your profit will depend on a few factors. I will discuss in this lecture what you should take into account and how to calculate it.
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
In this case, we will do the simulation of the whole logistics system and show you how to choose from many options.
Here we will give you tips on how to calculate the cost of the whole system and how to prepare for the simulation
We present here the final solution to the case. We show how to do the simulation of logistic costs for 8 different options in 5 minutes
Let’s imagine that you are working for a cheese producer. Your task is to find the optimal production batch. Use for this the simulation method.
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
The role of the production planning will be different if you have implemented continuous flow with kanbans. We will discuss in this section what is continuous flow.
Kanban is a way in which you can drastically limit work in progress. I will show you in this lecture what it is and how it looks like in practice
I will show you how to calculate the impact of Kanban in Excel
The ideal in production is the so-called continuous flow - everything goes smoothly and fast. Products are being produced fast and cheap. In this section, I will tell you how to achieve it.
Using a sandwich factory I will show you the mistakes people do when they try to create a continuous flow.
I will continue our example of a sandwich factory. I will show you how the continuous flow should look like.
I will continue our example of a sandwich factory. We add the Kanban to the continuous flow
I show here an example of continuous flow in services
Production planning will look differently if you have implemented continuous flow and Kanban. In this section, I will show you how to calculate optimal production batch and Kanban size.
Let’s imagine that you have to define the Kanban for French fries in a chain of burgers.
Let's solve the previously introduced case study.
Let's solve the previously introduced case study.
Let’s imagine that you have to calculate the size of the Kanban for legs in a furniture factory.
Let's solve the previously introduced case study.
Let's solve the previously introduced case study.
Let’s continue our case study with the chair producer. This time we will have 2 types of legs.
Let's solve the previously introduced case study.
Let's solve the previously introduced case study.
Let's solve the previously introduced case study.
Let's solve the previously introduced case study.
Let's solve the previously introduced case study.
Apart from optimizing the production you have to think strategically and know when you have to add a new capacity/factory. In this section, I will show you how you can do that
Here I will show you how to manage capacity depending on your industry and demand forecast.
Locations of some factories depend on the so-called supplier catchment area. You are looking for an area where you have a sufficient amount of resources or suppliers. Here we will see how catchment area influences the decision on capacities
The customer catchment area is important in picking the right location for the factory. Both B2B as well as B2C. Here I will show you how to approach this subject
In this lecture, we show how you can measure and analyze what is the maximal reach of your B2B business having in mind transportation costs and markups. We will provide you with a fast way to identify potential customers and measure your targeted price on a specific foreign market
Quite often you have to make important decisions faced with uncertainty. In those situations, it is very useful to apply the so-called decision tree. In this lecture, I will show you how to use this technique.
Quite often you have to make important decisions faced with uncertainty. In those situations, it is very useful to apply the so-called decision tree. In this lecture, I will show you how to use this technique.
What is the aim of this course?
Consulting firms are hired very often to help with Supply Chain and Production. During such projects, you will quite often have to look at the production planning and optimize it. Optimizing production planning will require a good understanding of what drives production capacity, as well as how production can impact the costs in the whole supply chain. In this course, I will teach how to perform fast and efficiently different types of analyses related to production planning.
In the course you will learn the following things:
What does the production capacity depend on and how to estimate it
How to find optimal production batches for different products in Excel that will minimize costs in the whole supply chain
How to plan production capacity for the future
How and when to use different methods for production planning
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 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 300 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, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, resources, 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 modification, be applied by you or your team in your work.
Why have I decided to create this course?
Production planning is very difficult for most management consultants. You not only have to master more advanced techniques, but you also have to have a good understanding of the production processes. Most firms, don’t give you the full toolbox that you may need. 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 understand or refresh the main skills and tools that they need during consulting projects devoted to production planning, supply chain, or production 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 consulting projects. You will learn how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to production and supply chain.
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 production planning and analyses done during projects devoted to production optimization. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that want to concentrate on operations, production, or supply chain. The course will help you become an expert in production planning 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 one analyzes 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 does the production capacity depend on and how to estimate it
How to find optimal production batches for different products in Excel that will minimize costs in the whole supply chain
How to plan production capacity for the future
How and when to use different methods for production planning
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 to the course as well as some general info on how the course is organized.
What does Production Planning do in practice? In the second section, we will look at some essential concepts that we will need to do the production planning. We will devote a lot of attention to removing bottlenecks.
Essential Methods for Production Planning. In this brief section, I will show the main methods used in production planning.
KPIs and goals for Production Planning. In production planning, you have to decide how to organize production so that it is optimal not only from the point of view of production but also from the whole supply chain. That is why, in this section, we will look at KPIs and goals that Production planning concentrates on.
Advanced Methods for Production Planning. In this section, we will look at more advanced methods of finding optimal production batches. They can be very useful in more complicated case studies.
Kanban & Continuous Flow. Production planning roles will differ if you are using Kanban and continuous flow. That is why in this section we will look at those two concepts.
Production Planning in Continuous-Flow. In this section, I will show you how to define the size of kanbans you will be using in the firm.
Capacity management. In the last section, we will discuss how to manage the medium-term and long-term capacity available in your production facilities.
You will be able also to download many additional resources
Useful frameworks and techniques
Analyses shown in the course
Additional resources
Links to additional presentations, articles, and movies
Links to books worth reading
At the end of my course, students will be able to…
Analyze the production plans in Excel
Calculate the optimal production batches in Excel
Do simulations in Excel
Do scenario analysis in Excel
Understand the role of Production Planning
Who should take this course? Who should not?
Management Consultants
Business Analysts
Financial Controllers
Analysts working in Supply Chain Departments
Analysts working in Production Departments
Analysts working in Production Planning Units