$2$ 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?

$\backslash$table$[[,,,,,],[$Provider$,$Factor A$,$Factor B$,,,],[$Alpha$,1,5,,,],[$Beta$,3,3,,,],[$Gamma$,4,1,,,],[$Phi$,3,1,,,],[$Omega$,3,5,,,]]$

Provider 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