BP Procurement and supplychain management case study

Create an ABC $/$ XYZ table for pipe consolidation. The Excel spreadsheet on blackboard should have the data you need to place each pipe size in a quadrant. Remember, there are multiple ways to set this up$.$ You can use volume or $ versus variability for example. You will not be able to include all parameters in the initial table. So$,$ select your primary parameters, complete the table, then use secondary parameters such as lead time or product equivalencies to help make final consolidation decisions. Please be ready to discuss your assumptions and recommendations. No presentations are needed, but be ready to share your analysis.

Create a Cause and Effect matrix for the relocation scorecard. I will post a blank version of a C&E Matrix on Blackboard for your use if you desire. You can also create your own. Location$/$vendor combinations should be on the left side $($X$\text{'}$s$)$ of the matrix. Parameters you wish to score $($y$\text{'}$s$)($capacity$,$ safety, costs, location, testing, etc.$)$ should be across the top. Not all of these parameters may be of equal weight in the decision making process so you can weight them across the top as well. Use only $1,3$ and $9$ as your scoring values. $1$ is not a fit, $3$ is a moderate fit, $9$ is an absolute fit. After you have completed the scoring, sort the table from highest to lowest score. Then create a Pareto chart to review the options and make a recommended relocation decision.