SMCG for Management Consultants and Business Analysts

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

Ratings 4.57 / 5.00
SMCG for Management Consultants and Business Analysts

What You Will Learn!

  • How to model consumer good (SMCG) businesses in Excel
  • Analyze sales and marketing in SMCG businesses
  • Increase profits by optimizing sales and marketing in consumer goods business
  • Analyze supply chain in SMCG
  • Improve supply chain in consumer goods business
  • Master approach and tricks used by top consulting firms such as McKinsey, BCG, Bain
  • How to estimate the value of consumer base
  • Model SMCG as a service business

Description

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:

  1. How to model SMCG business in Excel

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

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

  4. 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, 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 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:

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

  2. How to understand and improve the supply chain in SMCG

  3. How to model SMCG business in Excel

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

Who Should Attend!

  • Management Consultants
  • Business Analysts
  • Students that want to get into Management Consulting, Private Equity (PE) or VC
  • Managers and Directors working in consumer goods especially in SMCG
  • Startups founders
  • Controllers

TAKE THIS COURSE

Tags

  • Business Fundamentals
  • Business Strategy
  • Management Skills

Subscribers

1410

Lectures

101

TAKE THIS COURSE



Related Courses