FMCG for Management Consultants and Business Analysts

A little bit about me and my experience

Here I will show you how to course is organized

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.

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

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

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

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

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

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

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 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 sells mainly through retailers. Some go into independent distribution via own website and own stores. We will discuss all the options in this section

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

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

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.

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

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. 

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

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

Let's look how to build direct-to-consumer business

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

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.

Let's look at the subscription business model.

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

• 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

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

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

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

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

In this lecture we will give you some tips how to approach the case and show you the usage of the proper Excel functions

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

In this case we will analyze what is the fuel usage for different cars, what it depends on and how to optimize it

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

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 how to calculate the cost of the whole system and how to prepare for the simulation

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

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 (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.