Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate revenue (Dollars) market share for the four largest Brands (Not individual Chocolate bars). Rank them in order from Largest to smallest. What Percentage do

  1. Calculate revenue (Dollars) market share for the four largest Brands (Not individual Chocolate bars). Rank them in order from Largest to smallest. What Percentage do four Brands Own of the total Market (total % for all four brands)

  1. Calculate unit market share (Tons) for the four largest Brands (Not individual Chocolate bars). Rank them in order from Largest to smallest.

  1. By individual Chocolate bar what are the Top 3 Biggest Winners and Losers compare to the period before. Which Bars had the largest Positive (growth) and Negative (decline) revenue change.

  1. Calculate Relative market share for brands 2, 3, 4,

Penetration questions

    • Metro Vancouver Population 2.45 million
    • Metro Vancouver Population that ate Chocolate bar in August 1.885 million
    • Metro Vancouver Population that ate a chocolate bar by brand in August.
      • Nestle = 721,000
      • Cadbury = 682,000
      • Mars = 511,000
      • Hershey = 789,000
  1. What is the Market Penetration percentage for Chocolate Bars

  1. Brand Penetration percentage for each of the four Company brands

  1. Penetration Share percentage for each of the four Company brands

image text in transcribed

King Bar Rankings 7% $ Vol NESTLE COFFEE CRISP KING SIZE LARGE 75 GM MARS TWIX KING LARGE 95 GM NESTLE KIT KAT KING SIZE LARGE 75 GM HERSHEY REESES P BTR CPS KING 68 GM NESTLE AERO KING SIZE LARGE 63 GM NESTLE SMARTIES KING SIZE LARGE 84 GM HERSHEY OH HENRY KING 85 GM MARS MARS BAR KING LARGE 100 GM MARS SNICKERS KINGLARGE 105 GM MARS MARS BAR 2 PIECE KING SIZE LARGE 95GM MARS SNICKERS TWO PIECE KING SIZE 95GM NESTLE KIT KAT CHUNKY MAX KING LARGE 72GM HERSHEY EATMORE KING SIZE LARGE 75 GM NESTLE CRUNCH KING SIZE LARGE 78 GM HERSHEY GLOSETTE RAISINS KING 68 GM MARS SNICKERS BIG ONE KING LARGE 20% MORE 123GM MARS MARS MEGA KING LARGE 20% MORE 114GM CADBURY MR BIG KING SIZE LARGE 67 GM WHOPPERS KING LARGE 96 GM HERSHEY OH HENRY KINGSIZE LARGE 24 X 85 GM CADBURY MR BIG KING LARGE 90 GM MARS TWIX KING 24 X LARGE 2.28 KG NESTLE KIT KAT KING SIZE LARGE 24 X 75 GM HERSHEY EATMORE KING SIZE LARGE 24 X 75 GM NESTLE KIT KAT KING SIZE LARGE 80 GM NESTLE COFFEE CRISP*KING SIZE*24 X LRG 75GM TOT 1.8 HERHSEY REESES P BTR CUPS KING 79GM HERSHEY GLOSETTE RAISINS KING LARGE 24 X 68 GM HERSHEY REESES P BTR CPS KING LARGE 24 X 68 GM CADBURY CRISPY CRUNCH KING SIZE LARGE 80 GM MARS SNICKERS TWO PIECE KING SIZE 24 X 95GM NESTLE SMARTIES KING 59 GM MARS MARS BAR 2 PC KING SIZE LARGE 24X95 GM LOWNEY CHERRY BLOSSOM KINGSIZE LARGE90 GM HERSHEY GLOSETTE PEANUTS KING 61 GM HERSHEY OH HENRY KING 100 GM CADBURY CRUNCHIE KING SIZE LARGE 67 GM NESTLE BUTTERFINGER KING SIZE LARGE 104GM $ Vol Vol % CH $ Shr Tonn Vol Tonn Vol Tonn Vol % Tonn Shr 1 3,329,275 -2% 0.9 1 156,452 -6% 1.2 2 3,255,996 8% 0.9 2 153,992 1.2 3 3,101,093 -7% 0.9 3 146,201 -10% 1.1 4 2,769,572 19% 0.8 4 134,245 15% 1 5 2,635,873 9% 0.7 5 125,215 4% 0.9 6 2,490,971 4% 0.7 7 118,938 -9% 0.9 7 2,487,954 9% 0.7 6 119,310 3% 0.9 8 2,210,123 44% 0.6 8 104,185 46% 0.8 9 2,036,366 -38% 0.6 9 95,319 40% 0.7 10 1,868,023 13662% 0.5 10 86,100 14491% 0.7 11 1,513,393 NA 0.4 12 69,887 NA 0.5 12 1,036,670 NA 0.3 11 72,334 NA 0.5 13 1,016,786 35% 0.3 13 49,323 31% 0.4 14 786,686 10% 0.2 14 36,998 4% 0.3 15 616,690 11% 0.2 15 30,778 8% 0.2 16 383,587 -72% 0.1 16 17,695 -73% 0.1 17 374,969 -72% 0.1 17 17,232 -73% 0.1 18 232,284 28% 0.1 18 11,523 16% 0.1 19 107,970 64% 0 20 5,856 59% 0 20 106,275 -38% 0 19 8,790 -39% 0.1 21 41,124 176% 0 24 1,837 212% 0 22 34,413 -12% 0 21 2,636 -14% 0 23 32,568 -54% 0 22 2,499 -56% 0 24 25,377 -77% 0 23 1,969 -79% 0 25 19,765 -66% 0 26 1,074 -64% 0 26 17,681 -93% 0 25 1,351 -93% 0 27 13,685 NA 0 28 781 NA 0 28 11,108 440% 0 27 872 422% 0 29 8,189 -34% 0 29 638 -36% 0 30 6,369 -96% 0 32 303 -96% 0 31 5,302 NA 0 30 512 NA 0 32 4,818 -53% 0 34 106 -63% 0 33 4,617 NA 0 31 353 NA 0 34 2,438 -99% 0 33 252 -98% 0 35 1,412 -94% 0 35 85 -93% 0 36 1,243 -87% 0 38 66 -85% 0 37 1,035 -98% 0 36 72 -97% 0 38 733 3390% 0 37 70 6264% 0 King Bar Rankings 7% $ Vol NESTLE COFFEE CRISP KING SIZE LARGE 75 GM MARS TWIX KING LARGE 95 GM NESTLE KIT KAT KING SIZE LARGE 75 GM HERSHEY REESES P BTR CPS KING 68 GM NESTLE AERO KING SIZE LARGE 63 GM NESTLE SMARTIES KING SIZE LARGE 84 GM HERSHEY OH HENRY KING 85 GM MARS MARS BAR KING LARGE 100 GM MARS SNICKERS KINGLARGE 105 GM MARS MARS BAR 2 PIECE KING SIZE LARGE 95GM MARS SNICKERS TWO PIECE KING SIZE 95GM NESTLE KIT KAT CHUNKY MAX KING LARGE 72GM HERSHEY EATMORE KING SIZE LARGE 75 GM NESTLE CRUNCH KING SIZE LARGE 78 GM HERSHEY GLOSETTE RAISINS KING 68 GM MARS SNICKERS BIG ONE KING LARGE 20% MORE 123GM MARS MARS MEGA KING LARGE 20% MORE 114GM CADBURY MR BIG KING SIZE LARGE 67 GM WHOPPERS KING LARGE 96 GM HERSHEY OH HENRY KINGSIZE LARGE 24 X 85 GM CADBURY MR BIG KING LARGE 90 GM MARS TWIX KING 24 X LARGE 2.28 KG NESTLE KIT KAT KING SIZE LARGE 24 X 75 GM HERSHEY EATMORE KING SIZE LARGE 24 X 75 GM NESTLE KIT KAT KING SIZE LARGE 80 GM NESTLE COFFEE CRISP*KING SIZE*24 X LRG 75GM TOT 1.8 HERHSEY REESES P BTR CUPS KING 79GM HERSHEY GLOSETTE RAISINS KING LARGE 24 X 68 GM HERSHEY REESES P BTR CPS KING LARGE 24 X 68 GM CADBURY CRISPY CRUNCH KING SIZE LARGE 80 GM MARS SNICKERS TWO PIECE KING SIZE 24 X 95GM NESTLE SMARTIES KING 59 GM MARS MARS BAR 2 PC KING SIZE LARGE 24X95 GM LOWNEY CHERRY BLOSSOM KINGSIZE LARGE90 GM HERSHEY GLOSETTE PEANUTS KING 61 GM HERSHEY OH HENRY KING 100 GM CADBURY CRUNCHIE KING SIZE LARGE 67 GM NESTLE BUTTERFINGER KING SIZE LARGE 104GM $ Vol Vol % CH $ Shr Tonn Vol Tonn Vol Tonn Vol % Tonn Shr 1 3,329,275 -2% 0.9 1 156,452 -6% 1.2 2 3,255,996 8% 0.9 2 153,992 1.2 3 3,101,093 -7% 0.9 3 146,201 -10% 1.1 4 2,769,572 19% 0.8 4 134,245 15% 1 5 2,635,873 9% 0.7 5 125,215 4% 0.9 6 2,490,971 4% 0.7 7 118,938 -9% 0.9 7 2,487,954 9% 0.7 6 119,310 3% 0.9 8 2,210,123 44% 0.6 8 104,185 46% 0.8 9 2,036,366 -38% 0.6 9 95,319 40% 0.7 10 1,868,023 13662% 0.5 10 86,100 14491% 0.7 11 1,513,393 NA 0.4 12 69,887 NA 0.5 12 1,036,670 NA 0.3 11 72,334 NA 0.5 13 1,016,786 35% 0.3 13 49,323 31% 0.4 14 786,686 10% 0.2 14 36,998 4% 0.3 15 616,690 11% 0.2 15 30,778 8% 0.2 16 383,587 -72% 0.1 16 17,695 -73% 0.1 17 374,969 -72% 0.1 17 17,232 -73% 0.1 18 232,284 28% 0.1 18 11,523 16% 0.1 19 107,970 64% 0 20 5,856 59% 0 20 106,275 -38% 0 19 8,790 -39% 0.1 21 41,124 176% 0 24 1,837 212% 0 22 34,413 -12% 0 21 2,636 -14% 0 23 32,568 -54% 0 22 2,499 -56% 0 24 25,377 -77% 0 23 1,969 -79% 0 25 19,765 -66% 0 26 1,074 -64% 0 26 17,681 -93% 0 25 1,351 -93% 0 27 13,685 NA 0 28 781 NA 0 28 11,108 440% 0 27 872 422% 0 29 8,189 -34% 0 29 638 -36% 0 30 6,369 -96% 0 32 303 -96% 0 31 5,302 NA 0 30 512 NA 0 32 4,818 -53% 0 34 106 -63% 0 33 4,617 NA 0 31 353 NA 0 34 2,438 -99% 0 33 252 -98% 0 35 1,412 -94% 0 35 85 -93% 0 36 1,243 -87% 0 38 66 -85% 0 37 1,035 -98% 0 36 72 -97% 0 38 733 3390% 0 37 70 6264% 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions