I am doing one project which Spend Analysis and sourcing Strategy. In my project I have completed most of the thing, such as finding commodity basket, top vendors for each commodity. Most of the things are done but I am not able to answer some of the question. The questions are mentioned below.
I will be sending you the dataset and my spreadsheet that i have done all the work through we transfer as the files are big. I will also upload whole project requirement you don’t have to do all as those thing will help you to understand the project. I will also send a video which help you to understand the project.
Please answer the questions mentioned below, if you have to create any other chart to help you answer those question you can do it in the worksheet that i will send. Before doing anything in the worksheet you need to filter out modenumber which is present in dataset it should be 0 for all transaction.
1. Market Research: Find industry costs/prices, new suppliers not found in the spend data, trends, new technology, market size, competitiveness, contract durations, contract types, offshoring, low-cost regions, national/regional/local contracts, etc. Use the sample market report as a guide. Market research shows a clear link to and is consistent with the chosen sourcing strategies.
2.Strategic sourcing matrix. Type of spend properly identified per criticality (value) and supply difficulty (risk). Which you see in the ppt examples.
3. Sourcing strategies identified (e.g., increasing competition, e-RA, aggregating spend, backward integration+directed sources, supply base reduction, sourcing/ordering/contracting efficiency, product/service standardization/commonality, demand management/reduction, supplier development, supplier performance evaluation, etc.), including justifications that they will be effective. Strategies correspond to the type of spend. Strategies correspond to the market research. [3 slides minimum]
4.Duration of proposed contracts & why
5. Projected savings (justified by information/data that is cited)
Also please provide references at the end of the ppt.