DISTRIBUTION ANALYTICS 02. Taterville is served by four store chains that sell s
ID: 3354393 • Letter: D
Question
DISTRIBUTION ANALYTICS 02. Taterville is served by four store chains that sell snack chips. Spud Wilson has collected the following sales information for the chains and the various chip brands that are stocked. Sam's Frank's Kate Modern Chain Store Discount Kauhaus Superstore Number of Stores Sales All Goods Idaho Fried Chips Lei's Chips $100,000 $169,000 $50,000 $500,000 $1,000 $2,000 $300 $5,500 $6000 $900 $1000 $1,000 $500 $700 Private Label Chips Stock-Keeping-Units (SKUs) Carried All Goods Idaho Fried Chips Lei's Chips 12,000 8,000 5,000 54,000 0 0 Private Label Chips a) what is the ACV6 for Frank's Discount? (20.6%) b) what is Idaho Eried's ACV% distribution? (100%) c) What is Lei's numeric distribution? (80%) d) what is Lei's ACV% distribution? (87.8%) e) what is Lei's PCV% distribution? (91.3%) f) What is DooRightOS dollar market share? (8.2%) g) What is DoorBightoS ACVX Distribution? (73.3%)Explanation / Answer
Product Category Volume (PCV) Distribution (%) =
100 x [ Total Category Sales of Outlets Carrying Brand ($) ÷ Total Category Sales of All Outlets ($) ]
----
All Commodity Volume (ACV) Distribution (%) =
100 x [ Total Sales of Stores Carrying Brand ($) ÷ Total Sales of All Outlets ($) ]
----
Numeric Distribution (%) =
100 x [ Number of Outlets Carrying Brand (#) ÷ Total Number of Outlets (#) ]
----
Revenue market share (%) = 100 * [ Sales Revenue ($) / Total Market Sales Revenue($) ]
----
a) ACV% for Frank's discount = 100 * [ Sales of Frank's discount / Total Sales of All stores] = 169000/819000 = 20.6%
b) ACV% for Idaho's fried = 100 * [ Total Sales of stores carrying Idaho's fried / Total Sales of All stores] = 819000/819000 = 100%
c) Numeric distribution for Lei = 100 * [ Number of stores carrying brand / Total number of stores] = 4/5 = 80%
d) ACV% for Lei = 100 * [ Total Sales of stores carrying Lei / Total Sales of All stores] = 719000/819000 = 87.78%
e) PCV% for Lei = 100 x [ Total category sales of stores carrying Lei / Total category sales of all stores] = 17800/19500 = 91.28%
f) Dollar market share of DoorRightos = 100 * [ Sales revenue / Total market sales revenue] = 1600/19500 = 8.2%
g) ACV% for DoorRightos = 100 * [ Total Sales of stores carrying DoorRightos / Total Sales of All stores] = 600000/819000 = 73.26%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.