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 and shared some assumptions so you can build your business case. Let's calculate the potential of a smaller shampoo bottle.
You can complete this exercise either on DataCamp in the in-browser Excel environment or locally on your own computer if you have Excel and Copilot.
If you lost progress, close any open reports and load 3_1_price_pack_architecture.xlsx from the Workbooks folder.
This exercise is part of the course
Case Study: Net Revenue Management in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise