SMCG for Management Consultants and Business Analysts

SMCG for Management Consultants and Business Analysts, available at $59.99, has an average rating of 4.6, with 101 lectures, based on 45 reviews, and has 1456 subscribers.

You will learn about 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 This course is ideal for individuals who are Management Consultants or Business Analysts or Students that want to get into Management Consulting, Private Equity (PE) or VC or Managers and Directors working in consumer goods especially in SMCG or Startups founders or Controllers It is particularly useful for Management Consultants or Business Analysts or Students that want to get into Management Consulting, Private Equity (PE) or VC or Managers and Directors working in consumer goods especially in SMCG or Startups founders or Controllers.

Enroll now: SMCG for Management Consultants and Business Analysts

Summary

Title: SMCG for Management Consultants and Business Analysts

Price: $59.99

Average Rating: 4.6

Number of Lectures: 101

Number of Published Lectures: 101

Number of Curriculum Items: 101

Number of Published Curriculum Objects: 101

Original Price: $189.99

Quality Status: approved

Status: Live

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

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

Target Audiences

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

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 marketingin order to increase margin and profit
How to improve the supply chainin order to increase margin and profit
How themove from selling a product to selling a servicewill 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:

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 fromselling a productto 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

Course Curriculum

Chapter 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

Chapter 2: Sales and Marketing – examples of sales analyses

Lecture 1: Introduction to sales and marketing in SMCG

Lecture 2: Overview of Sales in SMCG

Lecture 3: Overview of Marketing in SMCG

Lecture 4: Main challanges in sales and marketing in SMCG

Lecture 5: Overview of cases in Sales & Marketing

Lecture 6: New products within old categories – Case Introduction

Lecture 7: New products within old categories – Case Solution – Vaccum Cleaners estimation

Lecture 8: New products within old categories – the rest of estimation in Excel

Lecture 9: New products within old categories – Case Solution – Power Point

Lecture 10: How to motivate not yours sales reps – Case Introduction

Lecture 11: How to motivate not yours sales reps – Trainings

Lecture 12: How to motivate not yours sales reps – Contests

Lecture 13: How to motivate not yours sales reps – Incentive trips

Lecture 14: How to motivate not yours sales reps – Loyalty program

Lecture 15: How to motivate not yours sales reps – Summary and Comparison in Excel

Lecture 16: How to motivate not yours sales reps – Solution in Power Point

Lecture 17: How much should you give for the old product – Case Introduction

Lecture 18: When it makes sense to pay your customer for older version of the product?

Lecture 19: How much should you give for the old product – Costs

Lecture 20: How much should you give for the old product – Benefits

Lecture 21: How much should you give for the old product – Summary

Lecture 22: How much should you give for the old product – Solution in Power Point

Lecture 23: Direct Distribution – Case Introduction

Lecture 24: Business model of Retailer – main drivers

Lecture 25: Business model of Retailer in Excel – transaction version – 1 store

Lecture 26: Business model of Retailer in Excel – transaction version – retail chain

Lecture 27: Business model of Retailer in Excel – sq m version

Lecture 28: Direct Distribution – Back to the case study

Lecture 29: Direct Distribution – Current Net Margin

Lecture 30: Direct Distribution – Modeling 1 store

Lecture 31: Direct Distribution – Future Net Margin

Lecture 32: Direct Distribution – Comparison

Lecture 33: Direct Distribution – Solution in Power Point

Lecture 34: From SMCG to service – Introduction – Part 1

Lecture 35: From SMCG to service – Introduction – Part 2

Lecture 36: From SMCG to service – Case Introduction

Lecture 37: From SMCG to service – If sold as a product

Lecture 38: From SMCG to service – If sold as a service – Part 1

Lecture 39: From SMCG to service – If sold as a service – Part 2

Lecture 40: From SMCG to service – Comparison

Lecture 41: From SMCG to service – Solution in Power Point

Lecture 42: How to shorten the lifespan of a product – Case Introduction

Lecture 43: How to shorten the lifespan of a product – General rules

Lecture 44: How to shorten the lifespan of a product – Current Situation

Lecture 45: How to shorten the lifespan of a product – Fad

Lecture 46: How to shorten the lifespan of a product – Lower Costs

Lecture 47: How to shorten the lifespan of a product – Simplify Exchange

Lecture 48: How to shorten the lifespan of a product – Parameters

Lecture 49: How to shorten the lifespan of a product – Comparison

Lecture 50: How to shorten the lifespan of a product – Solution in Power Point

Lecture 51: Why you care about the customer base?

Lecture 52: How to increase the value of the customer base

Chapter 3: Modeling SMCG Business Model in Excel

Lecture 1: Introduction to the SMCG Business Model

Lecture 2: Things that matter in SMCG Business Model

Lecture 3: Drivers for SMCG business model

Lecture 4: SMCG business model in Excel – Basic assumptions

Lecture 5: SMCG business model in Excel – Sales

Lecture 6: SMCG business model in Excel – Fixed and Variable Production Costs

Lecture 7: SMCG business model in Excel – Gross Margin

Lecture 8: SMCG business model in Excel – Cost of sales and marketing

Lecture 9: SMCG business model in Excel – Net Margin

Lecture 10: SMCG business model in Excel – Head Office costs

Lecture 11: SMCG business model in Excel – P&L

Lecture 12: SMCG business model in Excel – Working Capital

Lecture 13: Modeling SMCG business model as a service business – Introduction

Lecture 14: From SMCG to service – Introduction – Part 1

Lecture 15: From SMCG to service – Introduction – Part 2

Lecture 16: From SMCG to service – Case Introduction

Lecture 17: From SMCG to service – If sold as a product

Lecture 18: From SMCG to service – If sold as a service – Part 1

Lecture 19: From SMCG to service – If sold as a service – Part 2

Lecture 20: From SMCG to service – Comparison

Lecture 21: From SMCG to service – Solution in Power Point

Lecture 22: Modeling SMCG business model as a service business – General Remarks

Lecture 23: Modeling SMCG business model as a service business – Head Office costs

Lecture 24: Modeling SMCG business model as a service business – Profit & Loss

Chapter 4: Examples of business analyses of Supply Chain in SMCG

Lecture 1: Introduction to SMCG Supply Chain

Lecture 2: Overview of Supply Chain in SMCG

Lecture 3: Main challenges in Supply Chain in SMCG

Lecture 4: Introduction to cases for SMCG

Lecture 5: Transportation mode vs value density – Introduction

Lecture 6: Transportation mode vs value density – Solution in Excel

Lecture 7: Car Industry – Planning the flow of finished goods – Introduction

Lecture 8: Car Industry – Planning the flow of finished goods – Excel – First Option

Lecture 9: Car Industry – Planning the flow of finished goods – Excel – Second Option

Lecture 10: Why production optimization is replaced by flow

Lecture 11: Kanban introduction

Lecture 12: Kanban in Excel

Lecture 13: Continuous flow – introduction

Lecture 14: How not to make continuous flow – sandwich factory

Lecture 15: How to make continuous flow – sandwich factory no kanban

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 1 votes
4 stars: 13 votes
5 stars: 29 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu