Production Planning for Management Consultants & Analysts (Udemy.com)
A practical guide on how to do analyses during consulting projects
Created by: Asen Gyczew
Last updated September 2026
What you will learn
- Analyze the production plans in Excel
- Calculate the optimal production batches in Excel
- How to do simulations in Excel
- How to do scenario analysis in Excel
- Understand the role of Production Planning
- Optimize the Production Planning during Management Consulting Projects
How it compares
Against the other 1,210 rated Udemy courses in Business on CourseDuck:
- Rating4.6 out of 5higher than 74% of them
- Reviews1,019#452 of 1,211 by number of reviews
- Length4.2 hourslonger than 65% of them
- Last updatedSeptember 2026more recently than 90% of them
Course Description
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.
Instructor Details
- 4.6 Rating
1,019 Reviews
Asen Gyczew
Expert in performance improvement, scaling businesses, and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 500 million) and startups. I have trained in person over 100 consultants, business analysts, and managers who now are Investment Directors, CEO, Partners in PE and VC funds, Sales and Marketing Directors, Operational Directors, COO, Directors in Consulting Companies, Supply Chain Directors, Board Members, etc.
Functional experience: performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence, turn-arounds, PMO;
Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending, fashion, toys), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing), foodtech, marketplaces
Countries: Poland, Serbia, Russia, Ukraine
More courses by Asen Gyczew
Excel Pivot Tables for Management Consultants & Analysts (2026)
4.6 (14,848 Reviews)
Provider: Udemy
Time: 2.6h
$11.99
Strategy for Management Consultants & Business Analysts (2026)
4.5 (14,615 Reviews)
Provider: Udemy
Time: 6.3h
$84.99
Retail for Business Analysts and Management Consultants (2026)
4.6 (14,138 Reviews)
Provider: Udemy
Time: 6.2h
$69.99
Management Consulting Approach to Problem Solving (2026)
4.5 (8,990 Reviews)
Provider: Udemy
Time: 7.2h
$14.99
Essential Lean Manufacturing for Management Consultants (2026)
4.7 (4,606 Reviews)
Provider: Udemy
Time: 4.7h
$64.99
Supply Chain for Management Consultants & Business Analysts (2026)
4.6 (4,479 Reviews)
Provider: Udemy
Time: 5.7h
$11.99
More Business courses
Hiring and Interview Skills to Recruit Top Talent as Manager (2026)
5.0 (267 Reviews)
Provider: Udemy
Time: 5.9h
$10.99
Directing the Actor: A USC course with Nina Foch (2016)
4.9 (1,379 Reviews)
Provider: Udemy
Time: 4h
$13.99
Lean Management: Just-In-Time JIT Certification (Accredited) (2026)
4.9 (1,219 Reviews)
Provider: Udemy
Time: 2.2h
$13.99
LinkedIn Marketing And Personal Branding Masterclass (2026)
4.9 (137 Reviews)
Provider: Udemy
Time: 1.4h
$19.99
Personal Branding Mastery: Elevate Your Career and Business (2026)
4.9 (134 Reviews)
Provider: Udemy
Time: 3.9h
$19.99
Reviews
By Emilyn Alves on 3/6/2026
Gostei do exemplo da sala de cinema, estava com pensamento muito voltado para fábricas e agora vejo planning em outros setores... Calculus de capacidade, excelente!
By Juliett on 1/19/2026
A brilliant and highly practical course :) The explanations were clear, and the examples made complex topics easy to understand. It’s incredibly useful for anyone involved in consulting or analytical work!
By Przemyslaw Franczak on 11/4/2025
A very interesting and brilliant course. It really attracts your attention which makes you to come back again making studies fun and videos are the best part of it.
By Aleksandra Tasic on 8/10/2025
Asen is versatile, multitalented person and it is easy to connect the bigger picture with his linked tutorials. This is my second course and I plan to revisit them with pleasure and confidence
By Ugochi Vivian Anyanwu on 4/22/2025
I have a much better understanding of what production planning is, implementing the knowledge acquired here to real life production will boost sales and company growth
By Jakub Adamski on 7/30/2024
This course should be at least twice as long. The course is rushed through (on top of the very fast pace of talking). There is little theory and explanation of key concepts. However, the Excel files pose the most problems. There is little explanation for why things are calculated the way they are. There are quite a few inconsistencies, mistakes and even additional elements that appear in solutions and haven't been there in empty files. Due to a lack of explanation, one may give up quite quickly on trying to do the cases by himself. Just to be clear, I'm not talking about formulas and functions - these aren't difficult, it is the explanation of logic that's lacking.
By Jaebong on 2/26/2024
This lecture is excellent. I heard it when I drove my car in the morning. There is one thing that you should consider. Some videos don't provide English subtitles. It will be good to improve this.
By Goutham Ramaraj on 4/7/2023
Enjoyed the course. Very good examples that gives a high level overview of different production planning scenarios.
By Anonymized User on 11/28/2022
the course goes well with my daily work i have learned how to extinguish short term bottleneck and long term bottleneck in production , also how to determine capacity estimation .
By Anonymized User on 6/21/2022
I liked the explanation of main concepts regarding production planning in a practice point of view. I like the practice with scenarios and Excel.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












