Please show all calculations. Using the current and alternative supplier information that has been provided in the table and the weights to be considered for each 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?