Case Study: Net Revenue Management in Excel
Analyze an FMCG market dataset in Excel, apply the five pillars of net revenue management and forecast next year’s revenue growth.
You take the role of a category manager at Healthmax, a fictional shampoo maker, and work in Excel to find where the business can grow. A large market dataset yields KPIs such as market share, value growth and gross margin. The five pillars of net revenue management then guide decisions on pricing, product mix, trade terms, pack sizes and promotions, and the case closes with a forecast of next year’s revenue.
What You Will Achieve
- Calculate year-to-date and moving annual total figures to track market share and value growth over time
- Work out net sales contribution and gross margin, and use trade terms management to decide which customers and products to invest in
- Set a pricing strategy for a small shampoo bottle and compare promotions to pick the most successful one
- Forecast next year’s revenue by combining organic growth with the additional revenue of net revenue management activities
Program Overview
FMCG Market Performance KPIs
As Healthmax’s category manager, you investigate the dataset and measure how the business performs across several time dimensions.
- How FMCG companies measure performance
- Year-over-year growth and year-to-date figures
- Moving annual total and market share
- Putting a new strategy in place
Net Revenue Management: Pricing and Mix
The NRM framework is introduced through brand portfolio pricing and mix management, applied to a new product in a new subcategory.
- Profit growth, net sales and gross margin
- Profitability matrix
- Brand portfolio pricing
- New category opportunity and product launch
Optimizing Net Revenue with Trade Terms, Packs and Promotions
The three remaining pillars shape investment, pack pricing and promotion choices before a final revenue forecast brings the case together.
- Trade terms management
- Price pack architecture
- Promotion management
- Forecasting with a waterfall
Certificate Awarded (Paid)
Job Outlook
The case mirrors the work of a category manager at a consumer goods company: tracking market KPIs, setting prices and pack sizes, planning promotions and forecasting revenue in spreadsheets.
Good for: Excel users who want to apply PivotTables, VLOOKUP and forecasting to a complete pricing and revenue case in the consumer goods industry.
Keep in mind: The whole course follows one fictional shampoo company and one dataset, so every KPI and pricing method is shown in that single market.
Bottom line: A worked Excel business case that applies all five net revenue management pillars to one company and ends with a revenue forecast.
Frequently Asked Questions
What are the five pillars of net revenue management?
They are brand portfolio pricing, mix management, trade terms management, pack price architecture and promotion management. The second chapter works through the first two pillars, and the final chapter applies the remaining three before the forecast.
Which Excel features does the case study rely on?
The exercises lean on PivotTables, VLOOKUP and Excel's forecasting tools. You use them to calculate KPIs such as market share, value growth, net sales contribution and gross margin, and to build the closing revenue waterfall.
Is Healthmax a real company?
No. Healthmax is a fictional FMCG company in the shampoo business, created for the case study. You act as its category manager and make its pricing, investment, launch and promotion decisions using the course dataset.


There are no reviews yet.