Fmcg For Management Consultants And Business Analysts

A practical guide on how to analyze in Excel and improve consumer goods business during consulting projects

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 the 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 basis. In the course you will learn 3 things:   How to model FMCG 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   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 or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of 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 124 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, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, 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?   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 to an 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 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 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:   How to understand and improve sales and marketing in FMCG   How to understand and improve the supply chain in FMCG   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 into the following sections:    Introduction. We begin with a little intro to the course.    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 the Supply Chain. In this section, I will show you examples of analysis of supply chain in FMCG      business. This will give you a good idea on what to concentrate on 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   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

Overview

Section 1: Introduction

Lecture 1 What the course will be about

Lecture 2 A little bit about me

Lecture 3 How this course will be organized?

Lecture 4 What to do if a blurry image appears

Lecture 5 How to find additional resources

Section 2: Modeling FMCG Business Model in Excel

Lecture 6 Introduction to the FMCG Business Model

Lecture 7 Things that matter in FMCG Business Model

Lecture 8 Introduction to modeling FMCG in Excel

Lecture 9 Drivers for FMCG business model

Lecture 10 FMCG business model in Excel - Basic assumptions and Sales

Lecture 11 FMCG business model in Excel - Fixed and Variable Production Costs

Lecture 12 FMCG business model in Excel - Gross Margin

Lecture 13 FMCG business model in Excel - Cost of sales and marketing and Net Margin

Lecture 14 FMCG business model in Excel - Net Margin

Lecture 15 FMCG business model in Excel - Head Office costs

Lecture 16 FMCG business model in Excel - P&L

Section 3: Sales and Marketing in FMCG

Lecture 17 Introduction to sales and marketing in FMCG

Lecture 18 Overview of Sales in FMCG

Lecture 19 Overview of Marketing in FMCG

Lecture 20 Main challenges in sales and marketing in FMCG

Lecture 21 Introduction to cases for FMCG

Lecture 22 Sales channel analysis - case in FMCG

Lecture 23 How to expand the brand – Introduction

Lecture 24 How to expand the brand – Solution – Part 1

Lecture 25 How to expand the brand – Solution – Part 2

Lecture 26 Sales force efficiency analysis – Introduction

Lecture 27 Sales force efficiency analysis – Solution – Unit Cost

Lecture 28 Sales force efficiency analysis – Solution – ABC analysis of Current Solution

Lecture 29 Sales force efficiency analysis – Solution – more on Current Solution

Lecture 30 Sales force efficiency analysis – Solution – Margin Maximazation

Lecture 31 Sales force efficiency analysis – Solution – Specialization

Lecture 32 Sales force efficiency analysis – Solution – Summary

Lecture 33 Sales force efficiency analysis – Practical Tips

Lecture 34 How to find the white spaces untouched by your brand – Introduction

Lecture 35 How to find the white spaces untouched by your brand – Solution – Per capita

Lecture 36 How to find the white spaces untouched by your brand – Solution – Local shares

Lecture 37 How to find the white spaces untouched by your brand – Solution – Presentation

Lecture 38 How to analyze the motivation system of sales force – Introduction

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

Lecture 40 Juice producer – motivation system of sales force – Introduction

Lecture 41 Juice producer – motivation system of sales force – Solution - Area Manager

Lecture 42 Juice producer – motivation system of sales force – Solution - Sales Rep

Section 4: Examples of business analyses of Supply Chain in FMCG

Lecture 43 Introduction to FMCG Supply Chain

Lecture 44 Overview of Supply Chain in FMCG

Lecture 45 Main challenges in Supply Chain in FMCG

Lecture 46 Introduction to cases for FMCG

Lecture 47 Chicken Producer - Top-down approach - Introduction

Lecture 48 Chicken Producer - Top-down approach - Tips how to do it

Lecture 49 Chicken Producer - Top-down approach - Solution

Lecture 50 Chicken Producer - Fuel usage - Introduction

Lecture 51 Chicken Producer - Fuel usage - Tips how to do it

Lecture 52 Chicken Producer - Fuel usage - Solution

Lecture 53 Chicken Producer - Overtime analysis - Introduction

Lecture 54 Chicken Producer - Overtime analysis - Tips how to do it

Lecture 55 Chicken Producer - Overtime analysis - Solution

Lecture 56 Juice Producer - Simulation - Introduction

Lecture 57 Juice Producer - Simulation - Tips how to do it

Lecture 58 Juice Producer - Simulation - Solution

Lecture 59 Optimal production batch analysis - FMCG

Lecture 60 2-stage production planning

Lecture 61 More on Supply Chain

Section 5: Conclusions

Lecture 62 Bonus Lecture

Management Consultants,Business Analysts,Directors,Startups founders,Controllers