Question

Outlet	All Sales	All LAVaZSales	Cheerios Stocked	Fruit Loops Stocked
Store 1	$150,000	$14,000	36 oz	16 oz , 36 oz
Store 2	$ 120,000	$ 10,300	16	16 oz , 36 oz
Store 3	$ 90,000	$8,900	16 oz , 36 oz	non
Store 4	$76,000	$7,650	non	36 oz
Store 5	$58,000	$3,360	16 oz , 36 oz	non

a) What is the numeric distribution for Fruit Loops 36oz SKU?

b) What is the ACV% for Fruit Loop 16 oz SKU? (2.5 Marks)

c) What is the PCV% for Cheerios 36 oz SKU? (2.5 Marks)

Answer 1

a:

      Numeric Distribution (%) = 100 x Number of outlets carrying brand ÷ Total number of outlets => For Fruit Loops 36oz SKU = 3/5 = 60%

b:

All Commodity Volume (ACV) Distribution (%) =
100 x Total Sales of Stores Carrying Brand ($) ÷ Total Sales of All Outlets ($) =>

ACV% for Fruit Loop 16 oz SKU = 100* 270000 / 494000 = 54.66%

c:

      Product Category Volume (PCV) Distribution (%) = 100 x Total Category Sales of Outlets Carrying Brand ($) ÷ Total Category Sales of All Outlets ($) =>

PCV% for Cheerios 36 oz SKU = 100* 26260 / 44210 = 59.40%

Thanks

Thumbs up if this helps!