Net Revenue Management

Case Study: Net Revenue Management in Google Sheets

Carl Rosseel

Head of Business Intelligence Curriculum at Datacamp

Net Revenue Management (NRM)

  • More than 66% of growth for FMCG companies comes from NRM initiatives
  • Net Revenue Management unlocks new growth potential:
    • Maximize net sales
    • Maximize profit

Image about revenue and profit maximization

1 https://www.bcg.com/publications/2017/consumer-products-pricing-how-net-revenue-management-boosts-top-bottom-line
Case Study: Net Revenue Management in Google Sheets

Net sales and gross profit

Net Sales = total revenue - discounts.

Overview and example of profit calculation

Case Study: Net Revenue Management in Google Sheets

Net sales and gross profit

Net Sales = total revenue - discounts.

Overview and example of profit calculation

Case Study: Net Revenue Management in Google Sheets

Net sales and gross profit

Case Study: Net Revenue Management in Google Sheets

Net sales and gross profit

Net Sales = total revenue - discounts.

Overview and example of profit calculation

Case Study: Net Revenue Management in Google Sheets

Net sales and gross profit

Net Sales = total revenue - discounts.

Overview and example of profit calculation

Case Study: Net Revenue Management in Google Sheets

Business expansion

Questions about your cookies business

Case Study: Net Revenue Management in Google Sheets

Business expansion

Questions about your cookies business

Case Study: Net Revenue Management in Google Sheets

Business expansion

Questions about your cookies business

Case Study: Net Revenue Management in Google Sheets

The 5 pillars of Net Revenue Management

Overview of the 5 pillars of Net Revenue Management

1 https://www.bcg.com/publications/2017/consumer-products-pricing-how-net-revenue-management-boosts-top-bottom-line
Case Study: Net Revenue Management in Google Sheets

Brand Portfolio Pricing

Brand Portfolio Pricing

  • Normal price or premium price?
  • Willingness to pay
  • Pricing competitors
  • Different pricing in regions / channels
Case Study: Net Revenue Management in Google Sheets

Mix Management

Mix Management

Cookie profitability matrix

Case Study: Net Revenue Management in Google Sheets

Let's practice!

Case Study: Net Revenue Management in Google Sheets

Preparing Video For Download...