You have just been hired by ABC Corporation, a global leader of industrial distribution products. You were hired as their new Global Supply Chain Manager. On your first day, you met with the CEO of the company, Ms. Robinson. Ms. Robinson indicated to you that ABC Corporation has a very robust global footprint of suppliers and customer, but she believes their purchasing practices are not optimum. She handed you the last 18 months of purchasing transactions data from the company and asked you to evaluate the file and provide no less that 20 changes that, based on the data provided, could yield savings for the company.

Your role is to evaluate these data and provide recommendations. Please note that this will require EXTENSIVE "data cleansing" (which means correcting errors) errors so that the results are accurate.

For this assignment you will need to use Pivot Tables to analyze the data. Remember that the data provided is for 18 months. Assumptions have to be made when you report the findings. Also, think creatively in regard to the INCOTERMS.