What is the aim of this course?
Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and the supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. This course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier.
What is the aim of this course?
Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and the supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. This course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier.
This course will help you drastically improve your knowledge and skills in analyzing and improving Slow Moving Consumer Goods businesses (SMCG) such as furniture, smartphones, cars, etc. It is designed for people who want to become management consultants, and business analysts or have to run and optimize SMCG businesses on daily basis. In the course, you will learn 4 things:
How to model SMCG business in Excel
How to improve sales and marketing in order to increase margin and profit
How to improve the supply chain in order to increase margin and profit
How the move from selling a product to selling a service will impact the business
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 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 On top of that my courses on Udemy were already taken by more than 224 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 cases, so most of the lectures are case studies showing some business problems solved in Excel. There will be also an overview of the main challenges in sales and marketing as well as the supply chain typical for SMCG. To every lecture, you will find attached (in additional resources) the Excels shown in the lecture 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 in your work.
Why have I decided to create this course?
Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and the supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier. Thanks to this course, you will know what and how to do during a consulting project devoted to an SMCG company. I will show you also how to model the SMCG business in Excel.
To sum it up, I believe that if you want to build or to find improvements in SMCG business you should master techniques related to analyzing and optimizing sales and marketing as well as the supply chain. That is why, I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to owners, founders of businesses as well as directors.
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 find and analyze SMCG business. There is little theory – mainly examples, and case studies with 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:
How to understand and improve sales and marketing in SMCG
How to understand and improve the supply chain in SMCG
How to model SMCG business in Excel
How to model for relatively new things in SMCG like customer base and switching from selling a product to selling a service
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 into the following sections:
Introduction. We begin with a little intro to the course. I will show you here what you can expect from this course and how it is organized
Modeling SMCG business in Excel. In the second section, I will show you how to model in Excel SMCG businesses. You will also get as a part of it Excel files to play with. I will use here 2 examples. We will model the SMCG in the traditional way (selling a product) and in an alternative way (selling services). We will here use the case study of smartphones and vacuum cleaner producers
Sales and Marketing in SMCG. In this section, I will show you examples of analyses of sales and marketing in the SMCG business. This will give you a good idea of what to concentrate on during a consulting project
Examples of business analyses of Supply Chain in SMCG. In the 4th section, I will show you examples of analyses of the supply chain in the SMCG business. This will give you a good idea of what to concentrate on during a consulting project.
You will be able also to download many additional resources
Excels with analyses shown in the course
Presentation of slides shown in the course
Links to additional presentations and movies
Links to books worth reading
At the end of my course, students will be able to…
How to model consumer goods (SMCG) business in Excel
Analyze sales and marketing in SMCG
Increase profits by optimizing sales and marketing in the consumer goods business
Analyze the supply chain in SMCG
Improve supply chain in consumer goods business
How to estimate the value of the consumer base
Model SMCG as a service business
Who should take this course? Who should not?
Management Consultants
Business Analysts
Directors
Startups founders
Controllers
What will students need to know or do before starting this course?
Basic or intermediate Excel
Basic knowledge of economics or finance
We begin with little intro into the course as well as some general info on what the course will be about
A little bit about me and my experience
Here I will show you what will be the structure of 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 coruse like Excel files, presentations, links etc.
Here I will show you how to analyse sales and marketing issues in SMCG business model
In this lecture I will show you the main way in which you are selling products if you are SMCG company
In this lecture I will show main ways to market SMCG products
We will discuss here the main challenges that you have to have if you are working in SMCG business
I will go through the cases that we will discuss in this section and that will help you to analyze and improve sales and marketing in SMCG
You can also think about adding new products within existing categories. This is what we will discuss in this lecture
Here I will show you the solution to the previously introduced case in Excel
Let’s imagine that you have to decide which method to support sales reps that work for retailers will be the best one. Help you customer analyze which method is better. We will discuss what other methods are used by your competitors and what you should pay attention to in order to decide which methods is better
In this lecture I will show you the solution to previously introduced case study
Imagine that you are working for a smartphone producer that considers direct distribution. In this lecture we will start thte case study where your task will be to check whether it makes sense or not
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
Here I will show you how to model the Retailer business in Excel.
Imagine that you are working for a ceramic tiles producer that wants to change the frequency at which customers are remodeling its houses. Your task is to analyze and decide which way is the best
Imagine that you work for a car producer that wants to give certain discount for those who exchange their old car for a new one. Try to analyze and find out whether it makes sense or not and how much additional margin he can generate from this tactic
In some cases it makes sense to pay the customer for the older version of the product. We will discuss in this lecture under what conditions it makes economic sense
There are some standard ways to make people shorten the lifespan. In this lecture we will discuss them
We are returning to the case study where we try to model the SMCG business - smparthone producer that wants to set-up his own retail chain
In this section we will model SMCG businesses in Excel. We will use 2 different approaches. In this lecture I will show you what you can expect in this section
I will shortly go through things that are important in other SMCG.
More and more SMCG businesses are considering switching from just selling the product and losing track of the customer to selling service which usually, helps you increase your link with your customer base and earn more at the same time
Here we will introduce the case study of a smartphone producer who wants to switch from selling the product to selling the service. We will try to estimate and compare both options and see what makes more sense.
Here I will discuss the main drviers for SMCG business model and how they are interlinked
In this lecture, I will show you the solution to previously introduced case study
Here I will show you what model we will build for commodity business model and what are the assumptions
In this lecture, I will show you the solution to a previously introduced case study
The customer base becomes more and more important for SMCG business. We will discuss in this lecture why
There are some ways in which you can increase the value of your customer. We will discuss them in this lecture
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
In this lecture I will show you how we will estimate the fixed and variable costs in production
In this lecture I will show you how to estimate the Gross Margin using sales and production costs
Now it is time to estimate the cost of sales by channels and cost of marketing
In this lecture I will show you how to estimate the Net Margin using Gross Margin and the cost of sales and marketing
We have also take care of head office costs to get to profit and loss account
Finally we estimate the profit and loss account and we can try to draw conclusion on the business
In this lecture we will also add the estimation of Working capital which may be crucial in Cash Flow estimation
We will now try to model SMCG assuming that they are trying to switch from sale of the product to sale of services. We will see how the profit loss statement will change due to the change in the business model
Here I will introduce the case study of a smartphone producer that wants to shift from product sales to service sales. We will be solving the case study in the next few lectures
In this lecture, I will show you the solution to the previously introduced case study
We will use the case that we have discussed so far to see how we can use it and model the full profit and loss statement of SMCG business operating as a provider of services
In this lecture, I will show you how to model the head office costs
We will finally close with a full profit and loss statement
In this section I will show you overview of the SMCG Supply Chain, main challenges and series of cases that will show you how to get the full potential of the Supply Chain
SMCG supply chain is extremely complicated on the supplier side. In this lecture I will show you how typical supply chain looks like
There are number of challenges in the Supply Chain in SMCG. I will discuss them briefly in this lecture
I will show you in short here what cases we will do in this section
Let’s have a look at car producer that is wandering how to get a specific part to his factories in Europe. We will see what is the optimal transportation mode of moving it to the customer
In this lecture we will calculate the solution in Excel and see how it will change depending on the parameters
Let’s have a look at car producer that is wandering which plant should supply to which country
In this lecture I will show you how to use solver to find optimal solution to the case of planning the flow of finished goods between factories and markets
You may have the urge to plan all the operations on the production floor. Yet in SMCG due to the number of components and process it is much better to find ways for the process to speak to each other. In this lecture I will why implementing the flow in SMCG is much better than trying to plan everything
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 -every go 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 sandwich factory. I will show you how the continuous flow should look like
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.