Using excel application is necessary.

AU.S. manufacturing company would like to outsource a machined casting that is currently manufactured in-house. The company would like to reduce risk of this strategy by adopting a second supplier. Three potential suppliers have been identified. Supplier A is from Mexico, supplier B is from Brazil, and supplier C is from the U.S. These suppliers have been rated on four criteria by the manufacturer's strategic sourcing team, with data in the table below. Suppliers are approved if rated 6.5 or higher, provisional approved if rated 5 or higher, and disqualified if rated below 5. a. Identify status of each potential supplier. A provisional approved ( approved) B disqualified C approved b. Which supplier would you select as backup. Justify your answer. Supplier A, beacuse it is higher than 5 and it is provisional approved. It will be my backeup choose. c. What is the sensitivity of the evaluation to the delivery measurement? (Note: evaluate the score, not the weight) AU.S. manufacturing company would like to outsource a machined casting that is currently manufactured in-house. The company would like to reduce risk of this strategy by adopting a second supplier. Three potential suppliers have been identified. Supplier A is from Mexico, supplier B is from Brazil, and supplier C is from the U.S. These suppliers have been rated on four criteria by the manufacturer's strategic sourcing team, with data in the table below. Suppliers are approved if rated 6.5 or higher, provisional approved if rated 5 or higher, and disqualified if rated below 5. a. Identify status of each potential supplier. A provisional approved ( approved) B disqualified C approved b. Which supplier would you select as backup. Justify your answer. Supplier A, beacuse it is higher than 5 and it is provisional approved. It will be my backeup choose. c. What is the sensitivity of the evaluation to the delivery measurement? (Note: evaluate the score, not the weight)