A B C D E F 1 Homework #4 Calculating Category Share/Item Share/Fair Share Index 2 3 4 % Chg 6 7 8 Running Shoes Asics Saucony New Balance Nike Reebok didas Brooks Hoka All Other Share and Volume - Dollars Abs Chg Category (000's) $ Share 136,047.0 2% 100.0 22,489.0 8% 16,897.0 3% 34,241.0 1% 21,897.0 10% -14,804.0 -5% 22,801.0 3% -9,597.0 4% 11.010.0 1% 31.113.0 5% $ Vol (000's) 2,247.773 262,400 226,982 327,464 318,006 140,089 189,713 177,308 157,829 447,982 9 10 11 12 13 14 15 16 Shr Pt Chg 0.0 0.3 0.1 0.0 0.3 -0.2 0.1 -0.2 0.0 0.1 Distribution Items Item Shr pt Chg 4 100.0 7 Fair Shr Index 100.0 0 0 - 1 17 Items 18 Running Shoes 225 19 Asics 33 20 Saucony 27 21 New Balance 26 22 Nike 28 23 Robok 13 24 Adidas 22 25 Brooks 15 26 Hoka 11 27 All Other 50 28 29 What is the category 5 share BY BRAND? 30 4 -2 -1 6 0 6 points 31 What is the ITEM SHARE by Brand? 6 points 32 33 What is the FAIR SHARE INDEX BY BRAND? 6 points 34 35 Based upon your Fair Share Index Values, which brand has Greatest NEEDLeast Need? 36 37 Please note: All calculations should be done using 1 decimal place 7 points 38 40 Sheet1 Select destination and press ENTED