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
Exercise instructions
- Use the
Retail Price
to calculate the "Price per ml", with 3 decimals after the comma, in columnM
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 cellM12
. - 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
