Question

Outlet All Sales All LAVaZSales Cheerios Stocked Fruit Loops Stocked Store 1 $150,000 $14,000 36 oz...


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)

Homework Answers

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!

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT