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