Problem $10-7($Algo$)$

Your company has used competitive bidding to select a supplier for janitorial services. Three suppliers returned acceptable bids within the allotted time frame.

$\backslash$table$[[$Category$,$Weight,$\backslash$table$[[$Supplier A$],[$Rating$]],\backslash$table$[[$Supplier B$],[$Rating$]],\backslash$table$[[$Supplier C$],[$Rating$]]],[$Quality systems,$38\%,1,3,4],[$Financial stability,$28\%,2,4,2],[$Management experience,$20\%,2,1,3],[$Price$,14\%,3,4,4]]$

Dicture Click here for the Excel Data File

All scores are based on a five$-$point scale, with $1$ equals poor and $5$ equals excellent.

a$.$ Calculate the total weighted score for each supplier.

b$.$ Based on these ratings from the supplier assessment, which supplier appears to be the best?

Required $A$

Required B

Calculate the total weighted score for each supplier.

Note: Round your answers to $2$ decimal places.

$\backslash$table$[[,\backslash$table$[[$Total Weighted$],[$Score$]]],[$Supplier A$,],[$Supplier B$,],[$Supplier C$,]]$