1. What was the total sales overall and by category for each year to our non-buying group customers? (Hint: Buying Group Customers have a buying group ID) I also need sales broken down for each month. Be sure to include the dollar amount sold in your summary.

 

2. I will need a ranking of the categories for the past five months in total. Then, I need a breakdown for each of the past five months. After this analysis, I want your assessment of our overall top two categories. Be sure to include how you determined the top two.

 

3. I need a similar analysis for customers in the top two categories. I need a ranked list of the top five customers in the top categories for each of the last five months, use the dollar amount purchased per month to rank customers in each category. I also need to know which customers were in the top five for more than one month (how often and what rank). Specifically, I would like to know which customers, if any, were in the top 5 for all five months for either category.

 

4. Most importantly, since we do not know what else the committee may want to know, please make a flexible tool that can provide me the ability to look at customer and category sales information in other ways (you can assume that I am pretty proficient in using excel pivot tables and should include such a tool).