Excel 2013 for Marketing IN CHICAGO AND SAN ANTONIO VASS sales data has been collected regarding Vlassic Pickles: All Condiment Commodity Volume ACV Pickle Category Volume CV Vlassic Volume BV Nationally$ 39,050,000,000 $ 1,095,000,000 $386,000,000 Chicago San Antonio 487,000,000 11,982,000 5,452,000 893,000,000 24,327,000 2,423,000 al al 1. For Chicago and San Antonio: a. b. c. d. e. Calculate the All Commodity Sales Percentage Calculate the Category Sales Percentage. Calculate the Brand Sales Percentage. Calculate the Category Development Index. Calculate the Brand Development Index. ne 2. In which of these markets would you suggest research be conducted on pickles? 3. In which of these markets would you suggest research be conducted on Vlassic? CHOCOLATE INDEX ales are in Chicago, 8% are in St. Louis and 3% are in Atlanta, Atlanta accounts for 1% of cocoa whereas St. Louis has 4% and Chicago has 15%. 1. Calculate the BDI's for each of these three markets 2. Explain what th e index number means for each market to Hershey's cocoa marketers