Procurement and Sourcing Individual Course Work (09.01.2017) 1. You have been provided with a spreadsheet of two year material usage (2009 & 2010) of a manufacturing company that has operations in several locations. o Undertake ABC analysis (1000 items per student) for the years 2009 and 2010 respectively. Please see below for the rows that you have to choose. You have to undertake ABC analysis of 900 items.  Discuss the logic you applied while undertaking the ABC analysis. o Does a 'Category A' item in 2009 remain the same in 2010? If not, what reasons you think might have caused the discrepancy? o What do you think will happen if the ABC analysis is not undertaken properly? Student Number Rows in the excel sheet M00500639 2 to 900 M00050956 901 to 1800 M00473110 1801 to 2700 M00602807 2701 to 3600 M00525412 3601 to 4500 M00509779 4501 to 5400 M00602810 5401 to 6300 M00576314 6301 to 7200 M00599690 7200 to 8100 M00599430 8101 to 9000 (40%) 2. Given the wide variety of products, different inventory management techniques should be used. By analysing the annual usage and value of the item, o Identify 50 items which will be suitable for Just in Time purchasing, support your finding with appropriate reason (30%) 3. Which costs are minimised by adopting Just in Time purchasing? IF you were to adopt JIT purchasing, what processes will you implement to ensure smooth running of operations (20%) Logical Structure, Layout, Formatting, Presentation & Referencing – 10% Additional Information Ordering cost >$100,000 $5000 $50,000 to $100,000 %2000 Category C Product $40 Holding Cost Holding Cost for items with annual usage more than 1000 items per year 8% of annual consumption value Holding costs for items with annual usage between 500 and 1000 10% of value Holding costs of items with annul usage between 50 and 100 12% of value Holding costs of items with annual usage between 1 & 50 1% of value  Due to the analytical nature of the assignment, there is no maximum word count, but I expect at least 1500 words  Your report can be structured question wise, you have to support your discussion with appropriate references where possible  You should also submit the spreadsheet along with the