Get startedGet started for free

Price Pack Architecture

You see that the smallest shampoo size in your portfolio is 100ml. Research has shown that people that travel are looking for shampoo bottles of 50ml. You contact your colleagues in other countries that do have a 50ml shampoo bottle in their assortment. They told you the small format is very successful. Let's start by calculate the suggested retail price of a smaller shampoo bottle.

This exercise is part of the course

Case Study: Net Revenue Management in Google Sheets

View Course

Exercise instructions

  • Use the Retail Price to calculate the "Price per ml", with 3 decimals after the comma, in column M for all existing products.
  • Calculate the Price per ml for "Starbust Ultra Soft 50ml" price by using a 50% markup on the "Price per ml" of the 100 ml variant in cell M12.
  • Finally, calculate the recommended retail price for the new product in cell E12.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise