I need help with this question and could you show me your work

4) Using the current and alternative supplier information that has been provided for FY2021, and the weights to be considered for each supplier characteristic, you are to develop a supplier scorecard using the following scale: 3 = best, 2 = second best, 1 = worst. As you first look over the information that has been provided, you will note that the values for the Quality Capability Index (Cpk) for the current and alternative suppliers are listed as TBD (to be determined). a) Using the Quality Performance Information that has been provided, calculate the values of Cpk for each of the current and alternative suppliers. Please show your work. Based on these values, which supplier would rate as best? Second best? Worst? b) Using the ratings from 1-3 for each of the supplier characteristics and also the weight to be applied to each supplier characteristic, which supplier would you recommend be used? Be sure to show your completed supplier scorecard and your calculations. c) What other factors do you feel might be helpful in making your decision? Supplier Information The table below provides information relating to important characteristics of the current supplier. In addition, the table includes the same types of information for two potential alternative suppliers in China ( A and B ) that have been contacted by Throx. The last column indicates the weights to be considered for each supplier characteristic. TBD= to be determined (calculated) by students 4) Using the current and alternative supplier information that has been provided for FY2021, and the weights to be considered for each supplier characteristic, you are to develop a supplier scorecard using the following scale: 3 = best, 2 = second best, 1 = worst. As you first look over the information that has been provided, you will note that the values for the Quality Capability Index (Cpk) for the current and alternative suppliers are listed as TBD (to be determined). a) Using the Quality Performance Information that has been provided, calculate the values of Cpk for each of the current and alternative suppliers. Please show your work. Based on these values, which supplier would rate as best? Second best? Worst? b) Using the ratings from 1-3 for each of the supplier characteristics and also the weight to be applied to each supplier characteristic, which supplier would you recommend be used? Be sure to show your completed supplier scorecard and your calculations. c) What other factors do you feel might be helpful in making your decision? Supplier Information The table below provides information relating to important characteristics of the current supplier. In addition, the table includes the same types of information for two potential alternative suppliers in China ( A and B ) that have been contacted by Throx. The last column indicates the weights to be considered for each supplier characteristic. TBD= to be determined (calculated) by students