QUESTION: USE THE DATA TABLE BELOW:

You are a procurement manager, and you have been tasked with assessing your company's supplier base. You have one of your direct reports query data from your procurement system, and they provide you with the data needed in excel format (available in D2L). The data includes supplier code, supplier spend, and total manufacturing days (M-Days) late to deliver. Your employee pivots the pertinent data into a simple table, and you are to make a few inferences based upon what you are presented. *Provide your answers directly under the questions in this document*

1. Which supplier did you spend the most with in the year? Which did you spend the least with? Highlight both in the excel document.

2. Which supplier was the latest during the year? Which supplier was the most on-time? Highlight both in the excel document.

3. We are in the thick of the pandemic: it is understood there will be supply chain issues all around. However, you have been tasked with identifying the "trouble suppliers" and are expected to come up with a risk-mitigation plan (only using knowledge you've gained from your procurement class so far). Identify the top three "trouble suppliers" and explain the following: a. Supplier b. Rationale for identifying supplier as "trouble" c. Mitigation plan - couple of para graph s at most per supplier (brief and concise is always better) *There should be a mitigation plan for each supplier based on identification rationale.*

SUPPLIER CODE	SUM- TOTAL SPEND	Year End M Total Days Late
1 2 3 4 5 6 7 8	$150,329 $137,710 $235.052 $139,172 $172,939 $178,492 $138,846 $154,667	120 100 171 95 113 104 88 95
Total Result	$1,307,207	886