Given the factors and sub-factors, weights, and scores in the Factor rating worksheet of MT 491.xlex, calculate the total weighted score for each supplier (out of 100%), and then choose the better supplier. Show all your work in the MT 491.xlsx.Supplier A Supplier B Factors Weight Score Weighted score |Score Weighted score B TECHNICAL 40%% Knowledge of problem 10%% Approach 20% Production facilities 5%% H Operators 3%% Maintenance 2% 10 DELIVERY 20%% Requested date 10%% 10 Lead time 10% 10 c) PRICE 20% Cost structure available 10%% Value analysis efforts 10% H 10 d) MANAGERIAL CAPABILITY 10% Labour relations 5%% 10 Financial strength 5%% e) QUALITY 10% Quality control processes 5% 9 Acceptable defect rate 9 TOTAL SCORE: 100.0% Score: 1 (does not meet expectations), 10 (exceeds expectations)