An operations manager is performing a factor$-$rating analysis to help him choose an outsourcing provider.

He is focusing on two factors: A and $B,$ using a weight of $75\%$ for factor A and $25\%$ for factor $B.$

He has scored five different potential providers on both factors, using a scale of $1-5,$ with $1$ representing the BEST score.

Based on the scores provided in the table below, which provider should be chosen?

Using excel, provide the matrix and formulae that you would use to calculate the weighted score

of Factors A and B to determine which would be the best option. Indicate which provider should be chosen.

hint: use the shaded cells for the solution and Excel's absolute reference