Case Study: Net Revenue Management in Google Sheets

You will use Net Revenue Management techniques in Google Sheets for a Fast Moving Consumer Goods company.

3 Stunden6 Videos27 Übungen

Kostenloses Konto erstellen

oder

Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.

Trainierst du 2 oder mehr?

Versuchen DataCamp for Business

Beliebt bei Lernenden in Tausenden Unternehmen

Kursbeschreibung

Fast Moving Consumer Goods

The world of Fast Moving Consumer Goods (FMCG) is a dynamic world that plays a significant role in our daily lives. Have you ever wondered how well-known brands like Coca-Cola, Nivea, and Lay's are being managed? This case study will help you get a better understanding of this industry.

Net Revenue Management

You will start by analyzing a big dataset and by performing your own market analysis. You will go from calculating market share to creating clear visuals to reveal actionable insights. Next, you will use the principles of Net Revenue Management (NRM), which will help you to identify new growth opportunities for your company. You will have to use a variety of Google Sheets tools and functions to calculate the true potential of these growth buckets. You will not only master everything which relates to PivotTables, VLOOKUP, and forecasting but also have a better understanding of what is happening behind the scenes of your favorite FMCG brands. Are you ready to use your Google Sheets skills to build a complete business case?

Für Unternehmen

Trainierst du 2 oder mehr?

Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.

1
Fast Moving Consumer Goods (FMCG)
Kostenlos
In the first chapter, you will be working as a category manager for Healthmax, a FMCG company active in the shampoo business. You will calculate Key Performance Indicators (KPIs) such as market share and value growth on various time dimensions such as year-to-date (YTD) and moving annual (MAT) total.
Kapitel Jetzt Abspielen
Introduction to the FMCG industry
50 xp
FMCG Products
50 xp
How do FMCG companies measure their performance?
50 xp
Investigating the dataset
100 xp
Year-over-Year Growth
100 xp
Calculating year-to-date Numbers
50 xp
Year-to-Date
100 xp
Moving Annual Total
100 xp
Market Share
100 xp
FMCG Products Market Share
50 xp
2
Net Revenue Management (NRM)
In this chapter, you will learn about the concept of Net Revenue Management (NRM) and will focus on two of its pillars: Brand Portfolio Pricing and Mix Management.

You’ll calculate important KPIs such as net sales contribution and gross margin. You’ll also use brand Portfolio Pricing to identify the correct price for your consumers. Consecutively you’ll use Mix Management techniques to help Healthmax launch a new product and expand into a new subcategory.
Kapitel Jetzt Abspielen
Net Revenue Management: Pillar 1 & 3
50 xp
Profit Growth
50 xp
Net Sales
100 xp
Gross Profit and Gross Margin
100 xp
Net Sales and Gross Profit contribution
100 xp
New Category Opportunity
100 xp
Fastest growing category
100 xp
New product launch
100 xp
3
Optimizing Net Revenue
In the last chapter, you will focus on the three remaining pillars of Net Revenue Management (NRM). Trade Terms Management will help you to decide in which customers and products you should be investing to grow your business.

You’ll combine that information with Pack Price Architecture to develop a new pricing strategy for a small shampoo bottle and use a Promotion Management technique to identify the most successful promotion. Finally, you’ll wrap it up by forecasting next year's growth by combining organic growth with the additional revenue of your NRM activities.
Kapitel Jetzt Abspielen
Net Revenue Management: Pillar 2, 4 & 5
50 xp
Price Pack Architecture
100 xp
Sales Estimation
100 xp
Promotion Management
100 xp
Yearly Sales
100 xp
Forecasting Sales
100 xp
Net Value Sales Forecast
100 xp
Waterfall chart
100 xp
Congratulations!
50 xp