Busters is a grocery store chain in Hortonville. There are four locations in the city, denoted by their location. Lori, the owner of Busters, has compiled some data about sales of certain products and given you the data to perform some analysis on it. The file contains the following variables for each product:

• The year and month for the sales for the product
• The store the sales are for (denoted by their location in Hortonville)
• The group the product is in
• The product
• How many units were sold
• The sales revenue (Total, not per unit)

1. What is the total sales revenue of Cheerios for all locations together? Answer to 0 decimal places. Include the Pivot Table you used to find this answer. (5 pts)

2. What was the total sales (units) of the ice cream group in the east location? Answer to 0 decimal places. Include the Pivot Table you used to find this answer. (5 pts)

3. What was the sales revenue per unit of chocolate in the south location in 2011? Answer to 2 decimal places. Include the Pivot Table you used to find this answer. (5 pts)

4. In 2013, what percent of fruit group units were sold at each of the locations? Answer to 2 decimal places. Include the Pivot Table you used to find this answer. (5 pts)

5. Create a 2-D column pivot chart to show total sales revenue by month for each location. Month should be on the horizontal axis, and sales revenue on the vertical axis. Format the chart to include (5 pts):

• A chart title, centered above the chart
• A horizontal and vertical axis title
• A legend and data table on the bottom (below the chart).
• Only January, March, May, July, September and November (with each month being shown only once on the horizontal)

6. If you look at trends for the product groups (fruit cereal, etc) for all locations combined by year, which group(s) are showing increasing yearly sales revenue and which group(s) are showing decreasing yearly sales revenue. Be sure to include data tables, pivot charts, pivot tables or other evidence to support your answer.(5 points)

7. Which one of the locations do you think is doing best for 2013, and why do you think so? Be sure to include data tables, pivot charts, pivot tables or other evidence to support your answer. (5 points)

Sorry Chegg wont allow me to upload the whole attachment. So do what you can thanks.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A Year 2011 2012 2013 2013 2013 2011 2011 2013 2012 2011 2012 2011 2012 2012 2013 2013 2013 2011 2012 2012 2013 2011 2011 2012 2011 2011 2012 2011 2012 2012 2011 B Month March March March January October December January July November February April July May March January February January August September December April September September January March June July July September September May c Store west east west west south east south west east south east north east south west west west east south east north south west east south west south north north west east D E Group Product ice cream Edies cereal Cheerios ice cream Breyers fruit grapes milk skim milk skim fruit grapes ice cream Ben and Jerry's ice cream Breyers fruit cherries fruit grapes ice cream Breyers ice cream Breyers ice cream Edies ice cream Ben and Jerry's milk skim cereal Raisin Bran ice cream Breyers fruit plums skim low fat ice cream Ben and Jerry's fruit cereal Raisin Bran cereal Cheerios cereal Raisin Bran ice cream Breyers fruit cherries ice cream Ben and Jerry's ice cream Edies ice cream Edies F G Units Revenue 538 $ 2,800.31 847 $ 944.38 790 $ 1,342.20 650 $ 1,911.70 924 $ 2,228.45 512 $ 2,182.40 626 $ 1,037.36 689 $ 804.80 763 $ 1,262.06 957 $ 3,092.16 841 $ 2,022.32 438 $ 1,920.56 907 $ 1,722.64 881 $ 2,777.89 1088 $ 1,209.00 586 $ 3,188.10 660 $ 3,327.80 709 $ 1,865.60 777 $ 2,494.81 510 $ 2,889.24 864 $ 2,979.84 748 $ 3,018.95 790 $ 2,800.90 570 $ 2,244.84 794 $ 1,276.90 496 $ 1,680.00 528 $ 2,656.80 729 $ 1,573.48 939 $ 2,732.92 823 $ 1,602.28 721 $ 1,547.30 19 20 21 milk milk 22 23 24 grapes 25 26 27 28 29 30 31 32 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A Year 2011 2012 2013 2013 2013 2011 2011 2013 2012 2011 2012 2011 2012 2012 2013 2013 2013 2011 2012 2012 2013 2011 2011 2012 2011 2011 2012 2011 2012 2012 2011 B Month March March March January October December January July November February April July May March January February January August September December April September September January March June July July September September May c Store west east west west south east south west east south east north east south west west west east south east north south west east south west south north north west east D E Group Product ice cream Edies cereal Cheerios ice cream Breyers fruit grapes milk skim milk skim fruit grapes ice cream Ben and Jerry's ice cream Breyers fruit cherries fruit grapes ice cream Breyers ice cream Breyers ice cream Edies ice cream Ben and Jerry's milk skim cereal Raisin Bran ice cream Breyers fruit plums skim low fat ice cream Ben and Jerry's fruit cereal Raisin Bran cereal Cheerios cereal Raisin Bran ice cream Breyers fruit cherries ice cream Ben and Jerry's ice cream Edies ice cream Edies F G Units Revenue 538 $ 2,800.31 847 $ 944.38 790 $ 1,342.20 650 $ 1,911.70 924 $ 2,228.45 512 $ 2,182.40 626 $ 1,037.36 689 $ 804.80 763 $ 1,262.06 957 $ 3,092.16 841 $ 2,022.32 438 $ 1,920.56 907 $ 1,722.64 881 $ 2,777.89 1088 $ 1,209.00 586 $ 3,188.10 660 $ 3,327.80 709 $ 1,865.60 777 $ 2,494.81 510 $ 2,889.24 864 $ 2,979.84 748 $ 3,018.95 790 $ 2,800.90 570 $ 2,244.84 794 $ 1,276.90 496 $ 1,680.00 528 $ 2,656.80 729 $ 1,573.48 939 $ 2,732.92 823 $ 1,602.28 721 $ 1,547.30 19 20 21 milk milk 22 23 24 grapes 25 26 27 28 29 30 31 32