Mulai sekarangMulai gratis

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.

Latihan ini merupakan bagian dari kursus

Case Study: Net Revenue Management in Google Sheets

Lihat Kursus

Instruksi latihan

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

Latihan interaktif langsung

Ubah teori menjadi aksi dengan salah satu latihan interaktif kami

Mulai latihan