1. You have been given spend data sorted by descending dollar. Sort by Commodity.

2. From the commodity sort, find the total spend by Commodity (hint: the subtotal or pivot table functions in Excel can help). Calculate the total spend by Commodity.

3. Make a chart of the top ten commodities by descending $ Spend. Print the chart and include with your case write-up.

4. From the commodity sort, find the number of suppliers by Commodity (hint: the pivot table function in Excel can help). Perform a descending sort of number of suppliers by commodity.

5. Make a chart of the top ten commodities by descending number of suppliers.  Print the chart and include with your case write-up.

6. From the commodity sort, find the average spend per supplier by Commodity. Perform an ascending sort of average spend per supplier. Print the chart and include with your case write-up.

Spend Analysis Questions

1. Applying the concept of Pareto analysis to the chart of top ten commodities by descending $ spend, write a ½ - 1 page executive summary of your recommendation for cost savings opportunities.

2. Applying the concept of Pareto analysis, write a ½ - 1 page executive summary of your recommendation for supplier consolidation.  Also discuss which chart(s) you used to make the recommendation and why.

Attachment:- Assignment Data.rar