Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Service Businesses for Management Consultants – B2C Segment

Name: Service Businesses for Management Consultants – B2C Segment
Rating: 4.4 (2 reviews)

A practical guide on how to do analyses during consulting projects

New

Created byAsen Gyczew

Last updated 5/2026

English

What you'll learn

How to model a B2C Service Business in Excel
Improve sales in a B2C Service Business
Improve operations in a B2C Service Business
Estimate potential improvements in Excel
Increase profits
Analyze in Excel sales and operations
Scale B2C Service Businesses

Course content

4 sections • 35 lectures • 1h 44m total length

Introduction2:39
We begin with a little intro to the course as well as some general info on how the course is organized.
A little bit about me1:47
A few words about your humble teacher
How to deal with Blurry image2:04
Here, I will show you what to do if a blurry image appears
How to reach additional resources1:06
Here, I will show you how to find additional resources attached to the course, like Excel files, presentations, links, etc.

Introduction to the B2C Services Business Model1:17
We can be talking about 3 different models in B2C services
Services performed at a specialized place, no production involved
Services are performed at a specialized place with some production
Services performed at the customer's place
I will discuss the differences between them in this lecture.
Things that matter in hairderssers, beauty salons etc.5:30
I will shortly go through things that matter in the case of B2C Services performed at specialized places, no production involved, such as hairdressers, beauty salons, and others.
Things that matter in other B2C Services Business Model1:57
I will shortly go through things that are important in other B2C Services, such as restaurant chains, services performed at the customer's place, etc.
Introduction to modeling B2C Services in Excel1:00
In the next lecture, I will show you the main drivers of the B2C model, and on the basis of this, we will create a business model in Excel. I will concentrate on the example of a restaurant chain
Business model of a restaurant in Excel – Basic model8:32
Excel gives you great opportunities to calculate whether your idea makes sense or not. For this, you will use the knowledge you have gathered in the previous lectures on your concept, location, and your customers. Excel is obviously less emotional than you, and the model you will create here can be used as a cornerstone of your business plans. It also shows banks and potential investors what your cash flow is. We start with a simple model so you can understand it and learn how to use it.
Business model of a restaurant in Excel – Advanced model8:21
In this lecture, we make a more advanced model. We introduce the traffic parameter and show how it is converted first into people who are engaged (stop and enter your restaurant) and later into customers (they buy something from you). Here we will be operating on 2 customer groups: the first eats at the restaurant, and the second comes for takeaways. For both customer groups, we calculate separate conversion rates and Average ticket (ATV). We still show you a business model for a 1-restaurant
Restaurant chain – how to model it in Excel?5:52
Finally, we show you how to model a restaurant chain in Excel.
Streaming Business – Case Introduction & Drivers2:10
Now let’s see how we can model a video streaming service firm that will be producing a lot of its own content and will be concentrated on Europe.
Streaming Business – Data Available5:21
In this lecture, we will solve the previously introduced case study.
Streaming Business – Customers2:48
In this lecture, we will solve the previously introduced case study.
Streaming Business – Sales & Margin2:26
In this lecture, we will solve the previously introduced case study.
Streaming Business – Capex4:03
In this lecture, we will solve the previously introduced case study.
Streaming Business – Head Office Costs2:05
In this lecture, we will solve the previously introduced case study.
Streaming Business – P&L2:36
In this lecture, we will solve the previously introduced case study.
Streaming Business – Working Capital & Debt2:26
In this lecture, we will solve the previously introduced case study.
Streaming Business – CF2:22
In this lecture, we will solve the previously introduced case study.

Sales Analyses in B2C Services – Introduction0:44
In this section, I will share with you examples of sales analysis that you may have to do during consulting projects.
Overview of Sales in B2C Services1:19
In terms of sales and marketing, B2C services are similar to Retail. We will briefly discuss the sales in B2C Services.
Main challenges in sales and marketing in B2C Services – Part 13:32
There are a number of challenges in the Sales and Marketing of B2C Services. We will discuss them in this lecture briefly to give you a taste of what you can expect during a consulting project. In this part, I will discuss services performed at a specialized place.
Main challenges in sales and marketing in B2C Services – Part 22:18
There are a number of challenges in the Sales and Marketing of B2C Services. We will discuss them in this lecture briefly to give you a taste of what you can expect during a consulting project. In this part, I will discuss services performed at a specialized place.
Main challenges in sales and marketing in B2C Services – Part 32:38
There are a number of challenges in the Sales and Marketing of B2C Services. We will discuss them in this lecture briefly to give you a taste of what you can expect during a consulting project. In this part, I will discuss services performed at a specialized place.
What will be the effect of the price increase – Introduction2:09
The impact of the price change on your profit will depend on a few factors. I will discuss in this lecture what you should take into account and how to calculate it.
What will be the effect of the price increase – Solution – Impact on coffee only4:01
In this lecture, I will show you how to solve the case shown in the previous lectures.
What will be the effect of the price increase – Solution – Full Impact2:34
In this lecture, I will show you how to solve the case shown in the previous lectures.
Does it make sense to introduce new services or product – Introduction2:33
Not always does the introduction of a new product make sense. I will show you here how to check whether you are making the right decision. We will be using, in this case, a fast-food salad that has just introduced 2 new products, and you want to check whether it makes sense.
Does it make sense to introduce new services or product – The imact of Coffees3:43
In this lecture, I will show you how to solve the case shown in the previous lectures.
Does it make sense to introduce new services or product – The impact of Soups2:14
In this lecture, I will show you how to solve the case shown in the previous lectures.
How to increase the net profit by 10% – Introduction1:22
There are plenty of alternative ways on the sales side to boost profits. Here, I will show you how to analyze it and what the way forward should be.
How to increase the net profit by 10% – Solution – Current Level of costs3:44
In this lecture, I will show the solution to the case study introduced in the previous lectures.
How to increase the net profit by 10% – Solution – Analysis of different options3:57
In this lecture, I will show the solution to the case study introduced in the previous lectures.

Requirements

Basic or intermediate Excel
Basic knowledge of economics
Basic or intermediate knowledge of finance & accounting

Description

This course contains the use of artificial intelligence.

What is the aim of this course?

Consulting firms are hired very often to help improve Service Businesses that operate in the B2C segment. Those projects are extremely interesting, yet pretty difficult. Quite often, you not only have to increase profits or scale, but also to improve the customer service. Therefore, in this course, I will teach you how to perform, fast and efficiently, different types of analyses devoted to Service Businesses operating in the B2C segment.

In the course, you will learn the following things:

How to model B2C Services Businesses in Excel
How to find potential improvements in B2C Services
How to analyze Sales in Excel
How to analyze Operations in Excel
How to scale B2C Services

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 the 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 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 are now 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 340 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 and tools that we use. To every lecture, you will find attached (in additional resources) the Excel files as well as additional presentations and 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 modifications, be applied by you or your team in your work.

Why have I decided to create this course?

As the Service Businesses become bigger, they are more likely to hire consultants to help them develop their business. Unfortunately, not that many consulting firms have experience in Service Businesses. Many Service businesses are a mix of consumer goods, retail, and production businesses. Most firms don’t give you the full toolbox that you need. This may lead to huge frustration during such projects.

Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need during consulting projects devoted to B2C Service Businesses. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to B2C Service Businesses. You will master how to analyze data and draw conclusions from the analyses. On top of that, you will also master the general frameworks for improving profitability and scaling.

To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst, you have to have a pretty decent understanding of B2C Service Businesses. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those that did come across similar businesses during their work. The course will help you become an expert in analyzing and improving B2C Service Businesses at the level of McKinsey, BCG, Bain, and other top consulting firms.

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 understand and analyze businesses. 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 model B2C Services Businesses in Excel
How to find potential improvements in B2C Services
How to analyze Sales in Excel
How to analyze Operations in Excel
How to scale B2C Services

You can also ask me any questions either through the discussion field or by messaging me directly.

How is the course organized?

The course is currently divided into the following sections:

Introduction. We begin with a little introduction to the course, as well as some general info on how the course is organized
Modeling B2C Services in Excel. We will start by looking at how you can model such businesses in Excel. We will look at 2 businesses. First, we will see how you can model a restaurant chain. We will also explore a totally different business – a streaming business.
Sales Analyses in B2C Services. In this section, I will share with you examples of sales analysis that you may have to do during consulting projects.
Profitability in B2C Services. In this section, we will concentrate on profitability. I will share with you the general frameworks that you can use to increase sales, increase margins, and cut costs.
Optimization of in-store processes – Case study. In the fourth section, I will show you how to optimize processes in stores and locations where you provide the services. As an example, we will use a Retailer. The same techniques and approaches can also be easily used in B2C Services.
Sales Analyses in B2C Services. In this section, I will share with you examples of operational analysis that you may have to do during consulting projects.
Process of scaling. In this section, you will learn the process that you can apply to scale a business successfully.
Scaling Operations in B2C Services. In the last section, we will see how to scale operations, as well as recruitment and training.

You will be able also to download many additional resources

1. Useful frameworks and techniques

2. Analyses shown in the course

3. Additional resources

4. Links to additional presentations, articles, and movies

5. Links to books worth reading

At the end of my course, students will be able to…

How to model a B2C Service Business in Excel
Improve sales in a B2C Service Business
Improve operations in a B2C Service Business
Estimate potential improvements in Excel
Increase profits
Analyze in Excel sales and operations
Scale B2C Service Businesses

Who should take this course? Who should not?

Management Consultants
Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers

What will students need to know or do before starting this course?

Basic or intermediate Excel
Basic knowledge of economics
Basic or intermediate knowledge of finance & accounting

Who this course is for:

Management Consultants
Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers

Service Businesses for Management Consultants – B2C Segment

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 8min

Modeling B2C Services in Excel16 lectures • 59min

Sales Analyses in B2C Services14 lectures • 37min

Conclusions1 lecture • 2min

Requirements

Description

Who this course is for: