Factor Rating Method Homework Exercise$-1-1.$xlsx Download Factor Rating Method Homework Exercise$-1-1.$xlsxFactor Table

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?

Provider Factor A Factor B

Alpha $15$

Beta $33$

Gamma $41$

Phi $31$

Omega $35$

Provide chosen provider

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