Comece agoraComece grátis

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.

Este exercicio faz parte do curso

Estudo de Caso: Net Revenue Management no Google Sheets

Ver curso

Instruções do exercicio

  • 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.

exercicio interativo prático

Transforme teoria em prática com um dos nossos exercicio interativos

Iniciar exercicio