Sorry, this page is no longer available
We may earn an affiliate commission when you visit our partners.
Course image
Asen Gyczew

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.

Read more

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

Enroll now

What's inside

Learning objectives

  • 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

Syllabus

Introduction

We begin with little intro into the course as well as some general info on what the course will be about

A little bit about me and my experience

Read more

Here I will show you what will be the structure of the course

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.

Here I will show you how to analyse sales and marketing issues in SMCG business model

In this lecture I will show you the main way in which you are selling products if you are SMCG company

In this lecture I will show main ways to market SMCG products

We will discuss here the main challenges that you have to have if you are working in SMCG business

I will go through the cases that we will discuss in this section and that will help you to analyze and improve sales and marketing in SMCG

You can also think about adding new products within existing categories. This is what we will discuss in this lecture

Here I will show you the solution to the previously introduced case in Excel

Let’s imagine that you have to decide which method to support sales reps that work for retailers will be the best one. Help you customer analyze which method is better. We will discuss what other methods are used by your competitors and what you should pay attention to in order to decide which methods is better

In this lecture I will show you the solution to previously introduced case study

Imagine that you are working for a smartphone producer that considers direct distribution. In this lecture we will start thte case study where your task will be to check whether it makes sense or not

I will show you in this lecture what KPI I the retail business model driven by. This will help you understand the modeling in Excel done in next lectures

Here I will show you how to model the Retailer business in Excel.

Imagine that you are working for a ceramic tiles producer that wants to change the frequency at which customers are remodeling its houses. Your task is to analyze and decide which way is the best

Imagine that you work for a car producer that wants to give certain discount for those who exchange their old car for a new one. Try to analyze and find out whether it makes sense or not and how much additional margin he can generate from this tactic

In some cases it makes sense to pay the customer for the older version of the product. We will discuss in this lecture under what conditions it makes economic sense

There are some standard ways to make people shorten the lifespan. In this lecture we will discuss them

We are returning to the case study where we try to model the SMCG business - smparthone producer that wants to set-up his own retail chain

In this section we will model SMCG businesses in Excel. We will use 2 different approaches. In this lecture I will show you what you can expect in this section

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

More and more SMCG businesses are considering switching from just selling the product and losing track of the customer to selling service which usually, helps you increase your link with your customer base and earn more at the same time

Here we will introduce the case study of a smartphone producer who wants to switch from selling the product to selling the service. We will try to estimate and compare both options and see what makes more sense.

Here I will discuss the main drviers for SMCG business model and how they are interlinked

In this lecture, I will show you the solution to previously introduced case study

Here I will show you what model we will build for commodity business model and what are the assumptions

In this lecture, I will show you the solution to a previously introduced case study

The customer base becomes more and more important for SMCG business. We will discuss in this lecture why

There are some ways in which you can increase the value of your customer. We will discuss them in this lecture

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

In this lecture I will show you how to estimate the Gross Margin using sales and production costs

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

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 lecture we will also add the estimation of Working capital which may be crucial in Cash Flow estimation

We will now try to model SMCG assuming that they are trying to switch from sale of the product to sale of services. We will see how the profit loss statement will change due to the change in the business model

Here I will introduce the case study of a smartphone producer that wants to shift from product sales to service sales. We will be solving the case study in the next few lectures

In this lecture, I will show you the solution to the previously introduced case study

We will use the case that we have discussed so far to see how we can use it and model the full profit and loss statement of SMCG business operating as a provider of services

In this lecture, I will show you how to model the head office costs

We will finally close with a full profit and loss statement

In this section I will show you overview of the SMCG Supply Chain, main challenges and series of cases that will show you how to get the full potential of the Supply Chain

SMCG supply chain is extremely complicated on the supplier side. In this lecture I will show you how typical supply chain looks like

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

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

Let’s have a look at car producer that is wandering how to get a specific part to his factories in Europe. We will see what is the optimal transportation mode of moving it to the customer

In this lecture we will calculate the solution in Excel and see how it will change depending on the parameters

Let’s have a look at car producer that is wandering which plant should supply to which country

In this lecture I will show you how to use solver to find optimal solution to the case of planning the flow of finished goods between factories and markets

You may have the urge to plan all the operations on the production floor. Yet in SMCG due to the number of components and process it is much better to find ways for the process to speak to each other. In this lecture I will why implementing the flow in SMCG is much better than trying to plan everything

Kanban is a way in which you can drastically limit work in progress. I will show you in this lecture what it is and how it looks like in practice

I will show you how to calculate the impact of Kanban in Excel

The ideal in production is the so called continuous flow -every go smoothly and fast. Products are being produced fast and cheap. In this section I will tell you how to achieve it.

Using a sandwich factory I will show you the mistakes people do when they try to create a continuous flow

I will continue our example of sandwich factory. I will show you how the continuous flow should look like

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Uses case studies and examples to illustrate key concepts, which is helpful for consultants and analysts who need to quickly apply their knowledge to real-world situations
Provides Excel templates and analyses that can be adapted for use in consulting projects, which saves time and effort for consultants and business analysts
Covers the shift from selling products to selling services, which is a relevant trend for consultants and analysts working with SMCG businesses
Requires basic knowledge of economics or finance, which may exclude some learners without a formal background in these areas
Focuses on improving sales and marketing, as well as the supply chain, which are critical areas for consultants and analysts working with SMCG businesses
Teaches how to model SMCG businesses in Excel, which is a valuable skill for consultants and analysts who need to create financial models and analyze data

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical smcg analysis with excel cases

According to learners, this course provides highly practical, case-based training focused specifically on Slow Moving Consumer Goods (SMCG) businesses. Taught by an instructor with extensive real-world experience in consulting and industry, the course emphasizes learning through detailed Excel modeling exercises. It covers core areas like sales, marketing, and supply chain analysis for SMCG. Students appreciate the step-by-step approach and the provision of ready-made Excel files and resources. While strong on practical application and case studies, it is explicitly light on abstract theory, making it best suited for those seeking hands-on analytical skills for this specific industry vertical.
More hands-on examples, less abstract.
"The course is very hands-on and practical, with less emphasis on academic theory."
"Better suited for practical application than for a deep theoretical dive into concepts."
"I preferred the focus on doing and analyzing real cases rather than abstract explanations."
Concentrates specifically on SMCG.
"This course is perfect if you work specifically within the Slow Moving Consumer Goods sector."
"Its narrow focus on SMCG means it's highly relevant for that niche."
"Might be too specific if you need broader consulting analysis skills across industries."
Helpful supplementary files included.
"Having access to the Excel files used in the lectures was a big plus."
"The additional resources, like slides and links, were quite useful."
"Appreciated getting the ready-made analysis templates."
Insights from a seasoned professional.
"The instructor's extensive real-world experience in consulting shines through in the lectures."
"Appreciated the valuable insights shared from years in the industry."
"The course felt authentic because it was taught by an experienced practitioner."
Teaches business modeling techniques in Excel.
"Learning how to model the business in Excel was a key takeaway for me."
"The provided Excel files were incredibly useful for practicing and applying techniques."
"Gained valuable skills in building financial and operational models."
Uses real-life business examples extensively.
"I found the case studies presented in the course highly relevant to real business problems."
"The focus on applying concepts through practical cases was extremely helpful for understanding."
"Great to see how analysis is done on real-world examples."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SMCG for Management Consultants and Business Analysts with these activities:
Review Basic Excel Skills
Strengthen your Excel foundation to better understand the course's modeling aspects.
Browse courses on Excel Formulas
Show steps
  • Complete an online Excel tutorial.
  • Practice using common formulas.
  • Familiarize yourself with Excel shortcuts.
Read 'Competitive Strategy' by Michael Porter
Understand the fundamentals of competitive strategy to analyze SMCG businesses effectively.
Show steps
  • Read the book's key chapters.
  • Summarize Porter's Five Forces.
  • Apply the concepts to an SMCG company.
Model a Local SMCG Business in Excel
Apply the course's Excel modeling techniques to a real-world SMCG business.
Show steps
  • Choose a local SMCG business to model.
  • Gather relevant financial data.
  • Create an Excel model based on course examples.
  • Analyze the model and identify areas for improvement.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a Presentation on SMCG Supply Chain Challenges
Deepen your understanding of supply chain issues by creating a presentation.
Show steps
  • Research common supply chain challenges in SMCG.
  • Develop a presentation outline.
  • Create slides with visuals and key information.
  • Practice delivering the presentation.
Read 'The Goal' by Eliyahu M. Goldratt
Learn about the Theory of Constraints to improve supply chain efficiency in SMCG businesses.
Show steps
  • Read the book and identify the main concepts.
  • Relate the concepts to SMCG supply chains.
  • Discuss how to apply the Theory of Constraints.
Develop a Sales Forecasting Model
Solidify your understanding of sales and marketing by building a forecasting model.
Show steps
  • Research sales forecasting techniques.
  • Gather historical sales data for an SMCG product.
  • Build a forecasting model in Excel.
  • Evaluate the model's accuracy.
Tutor Other Students in Excel Modeling
Reinforce your knowledge by helping other students with Excel modeling concepts.
Show steps
  • Offer tutoring sessions to classmates.
  • Answer questions in online forums.
  • Explain complex concepts in simple terms.

Career center

Learners who complete SMCG for Management Consultants and Business Analysts will develop knowledge and skills that may be useful to these careers:
Management Consultant
A Management Consultant helps organizations improve their performance by analyzing existing problems and developing plans for improvement. This course directly prepares you to excel as a Management Consultant, particularly within the slow moving consumer goods sector. The course provides insights into real-life case studies, which is invaluable for quickly understanding business challenges and delivering value to clients. By mastering the techniques to analyze and optimize sales and marketing and the supply chain, the Management Consultant becomes adept at identifying areas for improvement and driving tangible results. The Excel modeling skills taught in the course allows the Management Consultant to create financial models and simulations to evaluate different strategies and make informed decisions. The course can assist a management consultant in the consumer goods business.
Business Analyst
A Business Analyst identifies business needs and determines solutions to business problems. This course is highly beneficial for aspiring and current Business Analysts, particularly those focusing on slow moving consumer goods. The course emphasizes the development of skills in analyzing and improving sales and marketing, as well as the supply chain, which are critical for identifying inefficiencies and opportunities for optimization. The practical, step-by-step guide loaded with analyses, tricks, and hints will significantly improve the speed with which the Business Analyst finds and analyzes SMCG businesses. Thanks to this course, a Business Analyst will know what and how to do during a consulting project devoted to an SMCG company.
Supply Chain Analyst
A Supply Chain Analyst optimizes the flow of goods and services, from raw materials to finished products. This course is especially useful for those looking to specialize as a Supply Chain Analyst in the slow moving consumer goods sector. The course provides a detailed overview of supply chain challenges and techniques for improvement, which is critical for identifying bottlenecks and optimizing efficiency. By learning to model the supply chain in Excel, the Supply Chain Analyst can create simulations to evaluate different strategies and make data-driven decisions. The Supply Chain Analyst can also benefit from this course.
Marketing Analyst
A Marketing Analyst analyzes market trends and consumer behavior to optimize marketing campaigns and strategies. This course is particularly relevant for those aiming to become Marketing Analysts in the slow moving consumer goods industry. The course teaches you how to analyze sales and marketing data, identify key performance indicators, and develop strategies to increase margin and profit. With the knowledge and skills gained, a Marketing Analyst can make data-driven decisions about marketing investments and improve the effectiveness of campaigns. The Marketing Analyst will gain a deeper understanding of consumer behavior and market dynamics.
Operations Manager
An Operations Manager oversees the day-to-day activities of an organization to ensure efficiency and effectiveness. This course provides valuable insights for Operations Managers, especially those working with slow moving consumer goods. The course covers key topics such as improving sales and marketing, optimizing the supply chain, and modeling the business in Excel. By mastering these skills, the Operations Manager is equipped to identify areas for improvement and implement strategies to streamline operations and increase profitability. The Operations Manager can benefit from the comprehensive approach presented in the course.
Sales Manager
A Sales Manager leads a team of sales representatives and develops strategies to achieve sales targets. This course can be a valuable resource for Sales Managers, particularly those in the slow moving consumer goods sector. The course focuses on improving sales and marketing performance, which includes analyzing sales data, identifying key trends, and developing targeted strategies to increase sales. The Sales Manager can gain a deeper understanding of the factors that drive sales performance and learn how to optimize sales processes. The Sales Manager can leverage the course's insights to drive revenue growth and improve sales team effectiveness.
Category Manager
A Category Manager is responsible for the performance of a specific category of products within a retail organization. This course may be highly relevant for Category Managers, particularly those dealing with slow moving consumer goods. The course teaches how to analyze sales data, optimize pricing and promotions, and improve the overall performance of the category. The Category Manager can benefit from the course's focus on modeling the business and improving sales and the supply chain. Ultimately, the Category Manager can make informed decisions about assortment, pricing, and promotions.
Product Manager
A Product Manager guides the development and launch of new products or features. This course may be useful for Product Managers, especially those working in the slow moving consumer goods sector. The course emphasizes the importance of understanding the customer base and switching from selling a product to selling a service, which are key considerations when developing new products. The Product Manager can then leverage these skills to create products that meet customer needs and drive revenue growth. A product manager who is also an owner or founder can benefit from this course.
Financial Analyst
A Financial Analyst analyzes financial data, prepares reports, and provides recommendations to management. This course may be beneficial for Financial Analysts, especially those who support decision-making in the slow moving consumer goods industry. The course covers topics such as modeling the business in Excel and estimating the value of the consumer base, which are essential skills for financial analysis. The Financial Analyst can use these skills to create financial models, analyze financial performance, and provide insights to inform strategic decisions. A financial analyst who works as a controller can also benefit from this course.
Market Research Analyst
A Market Research Analyst studies market conditions to examine potential sales of a product or service. This course may be helpful for Market Research Analysts, particularly those focusing on slow moving consumer goods. The course touches on the importance of understanding consumer behavior and market trends, which is crucial for conducting market research. The Market Research Analyst may find the course's insights helpful in conducting surveys, analyzing data, and providing recommendations to management. A market research analyst with a background in economics can benefit from this course.
Project Manager
A Project Manager plans, executes, and closes projects to meet specific goals. This course may be useful for Project Managers who need to understand the business context of projects in the slow moving consumer goods sector. The course provides a broad overview of the key challenges and opportunities, which can help a Project Manager to better manage project scope, timelines, and budgets. The Project Manager can then use the course to gain insights into how to effectively manage projects that support sales, marketing, or supply chain initiatives. Those who also work as IT project managers can benefit from this course.
Retail Manager
A Retail Manager oversees the operations of a retail store, ensuring customer satisfaction and profitability. This course may be relevant for Retail Managers, especially those dealing with slow moving consumer goods. The course touches on key aspects of retail management, such as optimizing sales and marketing and managing the supply chain. The Retail Manager can leverage these insights to improve store performance, increase sales, and enhance the customer experience. The Retail Manager can also use the insights to drive revenue growth
Logistics Coordinator
A Logistics Coordinator manages the transportation and storage of goods. This course may be beneficial for Logistics Coordinators, especially those working with slow moving consumer goods. The course covers key aspects of the supply chain, such as optimizing transportation routes and managing inventory levels. The Logistics Coordinator can use these skills to improve the efficiency and effectiveness of logistics operations and reduce costs. The Logistics Coordinator can then leverage these skills to improve operations.
Purchasing Manager
A Purchasing Manager is responsible for procuring goods and services for an organization. This course may be relevant for Purchasing Managers, particularly those in the slow moving consumer goods sector. The course touches on key aspects of the supply chain, such as sourcing materials and negotiating contracts. The Purchasing Manager can use these insights to improve the efficiency and effectiveness of the purchasing process and reduce costs. This purchasing manager will learn about supply chains.
Data Scientist
A Data Scientist analyzes large datasets to extract meaningful insights and develop data-driven solutions. This course may be useful for Data Scientists, particularly those working in the slow moving consumer goods sector. The course covers modeling the business which is essential for data analysis. The Data Scientist can then use these skills to create data visualizations, identify trends, and provide recommendations to management. Any data scientist requires basic or intermediate Excel skills.

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in SMCG for Management Consultants and Business Analysts.
Introduces the Theory of Constraints, a methodology for identifying and eliminating bottlenecks in production processes. It is highly relevant to the supply chain optimization aspects of the course. The book is written as a novel, making it an accessible and engaging way to learn complex concepts. It is commonly used in operations management courses.
Provides a foundational understanding of competitive forces and strategic positioning. It is useful for understanding how SMCG businesses can achieve a sustainable competitive advantage. While not directly focused on SMCG, the principles are broadly applicable. It commonly used textbook in business strategy courses.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser