FMCG for Management Consultants and Business Analysts
4.3 (107 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,556 students enrolled

FMCG for Management Consultants and Business Analysts

Practical guide how to analyze in Excel and improve consumer goods business during consulting project
4.3 (107 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,556 students enrolled
Created by Asen Gyczew
Last updated 5/2020
English
English [Auto]
Current price: $89.99 Original price: $149.99 Discount: 40% off
9 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 article
  • 34 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Model consumer goods (FMCG) business in Excel
  • Analyze sales and marketing in FMCG
  • Increase profits by optimizing sales and marketing in consumer goods business
  • Analyze supply chain in FMCG
  • Improve supply chain in consumer goods business
  • Reduce costs and improve results in consumer goods business especially in FMCG
Requirements
  • Basic or intermediate Excel
  • Basic knowledge of economics or finance
Description

What is the aim of this course?  

Consulting projects especially when it comes to consumer goods business are very demanding. The two most complicated areas are sales and marketing and supply chain. During consulting projects I have seen business analysts and management consultants struggling with understanding 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 Fast Moving Consumer Goods businesses (FMCG). It is designed for people who want to become management consultants, business analysts or have to run and optimize FMCG businesses on daily bases. In the course you will learn 3 things:  

  1. How to model FMCG business in Excel  

  2. How to improve sales and marketing in order to increase margin and profit  

  3. How to improve supply chain in order to increase margin and profit  

The course is based on my 14 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from Retail, FMCG, SMG, B2B and services sector that I worked for. On many occasions I had to optimize also sales and marketing of the businesses I was responsible for.  On the basis of what you will find in this course I have trained over 100 consultants, business analysts and managers who now are Sales and Marketing Directors, Operational  Directors, COO, Investment Directors, Directors in Consulting Companies, Supply Chain Directors, Board Members etc. On top of that my courses on Udemy were already taken by more than 42 000 students.

I teach through cases, so most of the lectures are case studies showing some business problems solved in Excel. There will be also overview of main challenges in sales and marketing as well as supply chain typical for FMCG. 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 modification, be applied by you in your work.  

Why I decided to create this course?  

Consulting projects especially when it comes to consumer goods business are very demanding. The two most complicated areas are sales and marketing and supply chain. During consulting projects I have seen business analysts and management consultants struggling with understanding 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 in a FMCG company. I will show you also how to model FMCG business in Excel.  

To sum it up, I believe that if you want to build or to find improvements in FMCG business you should master techniques related to analyzing and optimizing sales and marketing as well as supply chain. That is why, I highly recommend this course not only to consultants or business analyst that have to advice their customer 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 tones of analyses, tricks, hints that will significantly improve the speed with which you find and analyze FMCG business. 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:   

  1. How to understand and improve sales and marketing in FMCG   

  2. How to understand and improve supply chain in FMCG   

  3. How to model FMCG business in Excel   

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 in 5 sections and I will be adding new sections to address other important issues. Currently you will find the following sections:  

  • Introduction. We begin with little intro into the course      as well as some general info on production  

  • Modeling FMCG business in Excel. In the second section I will show you how      to model in Excel FMCG business. You will also get as a part of it Excel      files to play with. I will use an example cosmetics business  

  • Sales and Marketing in FMCG. In this section I will show you examples      of analysis of sales and marketing in FMCG business. This will give you a      good idea on what to concentrate during a consulting project  

  • FMCG - Examples of business analyses of      Supply Chain. In the section 4 I will show you examples of analysis of supply chain in FMCG      business. This will give you a good idea on what to concentrate during a      consulting project   

I will be adding new sections and lectures in the coming months  

   

You will be able also to download many additional resources  

  1. Excels with analyses shown in the course  

  2. Presentation of slides show in the course  

  3. Links to additional presentations and movies   Links to books worth reading

Who this course is for:
  • Management Consultants
  • Business Analysts
  • Directors
  • Startups founders
  • Controllers
Course content
Expand all 61 lectures 03:14:27
+ Introduction
5 lectures 09:09

We begin with little intro into the course as well as some general information what you can expect in the course

Preview 02:33

A little bit about me and my experience

Preview 01:47

Here I will show you how to course is organized

Preview 01:40

Here I will show you what to do if a blurry image appears

What to do if a blurry image appears
02:04

Here I will show you how to find additional resources attached to the coruse like Excel files, presentations, links etc.

How to find additional resources
01:05
+ Modeling FMCG Business Model in Excel
11 lectures 22:11

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.

Preview 00:51

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

Preview 03:01

I will show you how we will approach modeling FMCG business model in Excel

Introduction to modeling FMCG in Excel
00:32

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

Preview 01:52

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

Preview 02:26

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

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

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

FMCG business model in Excel - Gross Margin
02:17

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

FMCG business model in Excel - Cost of sales and marketing and Net Margin
02: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 - Net Margin
01:44

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

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

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

FMCG business model in Excel - P&L
02:23
+ Sales and Marketing in FMCG
26 lectures 01:13:30

In this section I will show you examples of analysis of sales and marketing in FMCG business. This will give you a good idea on what to concentrate during a consulting project

Preview 01:03

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 Sales in FMCG
01:35

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

Overview of Marketing in FMCG
04:16

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

Main challenges in sales and marketing in FMCG
03:11

The next few lectures will be cases that will give you insight and practical tips. Here I will show you what you can expect in next lectures.

Introduction to cases for FMCG
01:21

Most producers / brand owners operate using many sales channels: wholesalers, own shops, e-commerce, marketplace etc. It makes sense to check how profitability looks across channels and what can e done to improve overall situation. I will show you how it cane be done with a simple Excel analysis and a pivot table. I will go also try to demonstrate what kind of conclusions can you draw and what should be your next steps, on the basis of the results you are getting form the analyses

Sales channel analysis - case in FMCG
03:06

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 – Introduction
02:38

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

How to expand the brand – Solution – Part 1
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
02:57

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 – Introduction
02:18

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

Sales force efficiency analysis – Solution – Unit Cost
02:16

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

Sales force efficiency analysis – Solution – ABC analysis of Current Solution
03:01

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

Sales force efficiency analysis – Solution – more on Current Solution
02:33

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

Sales force efficiency analysis – Solution – Margin Maximazation
02:48

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

Sales force efficiency analysis – Solution – Specialization
03:50

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

Sales force efficiency analysis – Solution – Summary
02:21

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

Sales force efficiency analysis – Practical Tips
03:27

Let’s have a cosmetics producer and see where is the potential for development. We will analyze the sales by regions and try to find how much more we can sell in each and every region.

Preview 01:02

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

Preview 04:04

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

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
02:07

Motivation plan for sales people can be pretty complicated. I will show you some examples that we will analyze in the next lecture

How to analyze the motivation system of sales force – Introduction
03:42

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

How to analyze the motivation system of sales force – Solution
03:39

We will now have a look at a company selling branded juice in Romania that has 2 type of sales force. I will show you how to analyze and calculate their motivation systems

Juice producer – motivation system of sales force – Introduction
02:32

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

Juice producer – motivation system of sales force – Solution - Area Manager
04:30

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

Juice producer – motivation system of sales force – Solution - Sales Rep
02:12
+ Examples of business analyses of Supply Chain in FMCG
18 lectures 01:28:23
  • I will show you examples of analysis of supply chain in FMCG business. This will give you a good idea on what to concentrate during a consulting project
Preview 00:46

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

Overview of Supply Chain in FMCG
01:41

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

Main challenges in Supply Chain in FMCG
04:40

I will show you in short here what cases we will do in this section

Preview 01:39

During this lecture I will show you how on basis of small number of data create a model which will show you how logistics costs are created, on what stage and what is the biggest drivers. This in turn will enable you to apply 80/20 rule

Preview 06:24

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 - Top-down approach - Tips how to do it
11:21

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

Chicken Producer - Top-down approach - Solution
05:28

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 - Introduction
03:46

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

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

Chicken Producer - Fuel usage - Solution
02:31

Next case will show you how to analyze labour cost in logistics.

Chicken Producer - Overtime analysis - Introduction
04:06

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

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

Chicken Producer - Overtime analysis - Solution
02:48

In this case we will do the simulation of the whole logistics system and show you how to choose from many options

Preview 04:28

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

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

Juice Producer - Simulation - Solution
08:33

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

Optimal production batch analysis - FMCG
06:37

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.

2-stage production planning
05:32
+ Conclusions
1 lecture 01:14
Bonus Lecture: up to 90% discounts for all my courses
01:14