{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Vendor Evaluation Analysis"],"not_rendered":{"defined_names":32},"read":"whole","date_system":"1900"}

{"sheet":"Vendor Evaluation Analysis","index":0,"n_rows":123,"n_cols":8,"rows_kept":123,"merged":[[4,2,4,8],[6,3,8,7],[10,2,10,8],[24,5,25,7],[28,5,29,7],[31,5,32,7],[34,5,35,7],[126,2,126,8],[127,2,127,8]]}
[]
[]
[null,null,"Vendor Evaluation Analysis"]
[null,null,"For"]
[null,null,"Your Business, Inc."]
[]
[{"$nulls":3},"How can the small business owner objectively evaluate the various advantages and disadvantages of each vendor? One method is this form that evaluates each supplier on key purchasing variables."]
[]
[]
[{"$nulls":3},"Enter numbers in Blue in unshaded cells only."]
[]
[null,null,"Step 1 - Criteria."]
[{"$nulls":3},"Assign weights to each criteria to reflect its relative importance to your business."]
[]
[{"$nulls":4},"Criteria","Weight"]
[{"$nulls":4},"Quality =",{"v":35,"d":"35 "}]
[{"$nulls":4},"Price =",{"v":30,"d":"30 "}]
[{"$nulls":4},"Prompt Delivery =",{"v":20,"d":"20 "}]
[{"$nulls":4},"Service =",{"v":10,"d":"10 "}]
[{"$nulls":4}," Support =",{"v":5,"d":"5 "}]
[{"$nulls":4},"Total ",{"$f":"SUM(F16:F20)","v":{"v":100,"d":"100 "}}]
[]
[null,null,"Step 2 - Grading scale for each criteria"]
[]
[{"$nulls":3},"Quality",null,"Number of acceptable lots from vendor divided by total number of lots from vendor."]
[]
[{"$nulls":3},"Price",null,"Lowest quoted price of all vendors divided by vendor X."]
[]
[{"$nulls":3},"Prompt Delivery",null,"Number of ontime deliveries from vendor divided by total number of deliveries by vendor."]
[]
[]
[{"$nulls":3},"Service",null,"A subjective evaluation of the variety of services offered by each vendor."]
[]
[]
[{"$nulls":3},"Support",null,"A subjective evaluation of the advice and assistance provided by each vendor."]
[]
[]
[null,null,"Step 3 - Compute a weighted score for each vendor"]
[]
[{"$nulls":5},"VENDOR 1"]
[]
[{"$nulls":7},"Weighted Score"]
[{"$nulls":3},"Criteria","Weight","Grade",null,"(Weight X Grade)"]
[]
[{"$nulls":3},"Quality =",{"$f":"$F$16","v":{"v":35,"d":"35 "}},{"$f":"E46/E47","v":{"v":0.9,"d":"0.90"}},null,{"$f":"E45*F45","v":{"v":31.5,"d":"31.50"}}]
[{"$nulls":3},"Acceptable Lots =",{"v":9,"d":"9 "}]
[{"$nulls":3},"Total Lots =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Price =",{"$f":"$F$17","v":{"v":30,"d":"30 "}},{"$f":"E50/E51","v":{"v":1,"d":"1.00"}},null,{"$f":"E49*F49","v":{"v":30,"d":"30.00"}}]
[{"$nulls":3},"Lowest Quote =",{"v":12.5,"d":"12.50"}]
[{"$nulls":3},"Vendor 1 Quote = ",{"v":12.5,"d":"12.50"}]
[]
[{"$nulls":3},"Delivery =",{"$f":"$F$18","v":{"v":20,"d":"20 "}},{"$f":"E54/E55","v":{"v":1,"d":"1.00"}},null,{"$f":"E53*F53","v":{"v":20,"d":"20.00"}}]
[{"$nulls":3},"Ontime =",{"v":10,"d":"10 "}]
[{"$nulls":3},"Total =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Service =",{"$f":"$F$19","v":{"v":10,"d":"10 "}},{"$f":"E58/E59","v":{"v":0.8,"d":"0.80"}},null,{"$f":"E57*F57","v":{"v":8,"d":"8.00"}}]
[{"$nulls":3},"Satisfied =",{"v":8,"d":"8 "}]
[{"$nulls":3},"Total =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Support =",{"$f":"$F$20","v":{"v":5,"d":"5 "}},{"$f":"E62/E63","v":{"v":1,"d":"1.00"}},null,{"$f":"E61*F61","v":{"v":5,"d":"5.00"}}]
[{"$nulls":3},"Requests =",{"v":5,"d":"5 "}]
[{"$nulls":3},"Total =",{"v":5,"d":"5 "}]
[{"$nulls":7},{"$f":"SUM(H45:H61)","v":{"v":94.5,"d":"94.50"}}]
[]
[]
[{"$nulls":5},"VENDOR 2"]
[]
[{"$nulls":7},"Weighted Score"]
[{"$nulls":3},"Criteria","Weight","Grade",null,"(Weight X Grade)"]
[]
[{"$nulls":3},"Quality =",{"$f":"$F$16","v":{"v":35,"d":"35 "}},{"$f":"E73/E74","v":{"v":0.8,"d":"0.80"}},null,{"$f":"E72*F72","v":{"v":28,"d":"28.00"}}]
[{"$nulls":3},"Acceptable Lots =",{"v":8,"d":"8 "}]
[{"$nulls":3},"Total Lots =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Price =",{"$f":"$F$17","v":{"v":30,"d":"30 "}},{"$f":"E77/E78","v":{"v":0.9259259259259259,"d":"0.93"}},null,{"$f":"E76*F76","v":{"v":27.77777777777778,"d":"27.78"}}]
[{"$nulls":3},"Lowest Quote =",{"v":12.5,"d":"12.50"}]
[{"$nulls":3},"Vendor 1 Quote = ",{"v":13.5,"d":"13.50"}]
[]
[{"$nulls":3},"Delivery =",{"$f":"$F$18","v":{"v":20,"d":"20 "}},{"$f":"E81/E82","v":{"v":0.8,"d":"0.80"}},null,{"$f":"E80*F80","v":{"v":16,"d":"16.00"}}]
[{"$nulls":3},"Ontime =",{"v":8,"d":"8 "}]
[{"$nulls":3},"Total =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Service =",{"$f":"$F$19","v":{"v":10,"d":"10 "}},{"$f":"E85/E86","v":{"v":0.8,"d":"0.80"}},null,{"$f":"E84*F84","v":{"v":8,"d":"8.00"}}]
[{"$nulls":3},"Satisfied =",{"v":8,"d":"8 "}]
[{"$nulls":3},"Total =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Support =",{"$f":"$F$20","v":{"v":5,"d":"5 "}},{"$f":"E89/E90","v":{"v":0.8,"d":"0.80"}},null,{"$f":"E88*F88","v":{"v":4,"d":"4.00"}}]
[{"$nulls":3},"Requests =",{"v":4,"d":"4 "}]
[{"$nulls":3},"Total =",{"v":5,"d":"5 "}]
[{"$nulls":7},{"$f":"SUM(H72:H88)","v":{"v":83.77777777777777,"d":"83.78"}}]
[]
[]
[{"$nulls":5},"VENDOR 3"]
[]
[{"$nulls":7},"Weighted Score"]
[{"$nulls":3},"Criteria","Weight","Grade",null,"(Weight X Grade)"]
[]
[{"$nulls":3},"Quality =",{"$f":"$F$16","v":{"v":35,"d":"35 "}},{"$f":"E100/E101","v":{"v":0.7,"d":"0.70"}},null,{"$f":"E99*F99","v":{"v":24.5,"d":"24.50"}}]
[{"$nulls":3},"Acceptable Lots =",{"v":7,"d":"7 "}]
[{"$nulls":3},"Total Lots =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Price =",{"$f":"$F$17","v":{"v":30,"d":"30 "}},{"$f":"E104/E105","v":{"v":1,"d":"1.00"}},null,{"$f":"E103*F103","v":{"v":30,"d":"30.00"}}]
[{"$nulls":3},"Lowest Quote =",{"v":12.5,"d":"12.50"}]
[{"$nulls":3},"Vendor 1 Quote = ",{"v":12.5,"d":"12.50"}]
[]
[{"$nulls":3},"Delivery =",{"$f":"$F$18","v":{"v":20,"d":"20 "}},{"$f":"E108/E109","v":{"v":0.6,"d":"0.60"}},null,{"$f":"E107*F107","v":{"v":12,"d":"12.00"}}]
[{"$nulls":3},"Ontime =",{"v":6,"d":"6 "}]
[{"$nulls":3},"Total =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Service =",{"$f":"$F$19","v":{"v":10,"d":"10 "}},{"$f":"E112/E113","v":{"v":0.7,"d":"0.70"}},null,{"$f":"E111*F111","v":{"v":7,"d":"7.00"}}]
[{"$nulls":3},"Satisfied =",{"v":7,"d":"7 "}]
[{"$nulls":3},"Total =",{"v":10,"d":"10 "}]
[]
[{"$nulls":3},"Support =",{"$f":"$F$20","v":{"v":5,"d":"5 "}},{"$f":"E116/E117","v":{"v":0.2,"d":"0.20"}},null,{"$f":"E115*F115","v":{"v":1,"d":"1.00"}}]
[{"$nulls":3},"Requests =",{"v":1,"d":"1 "}]
[{"$nulls":3},"Total =",{"v":5,"d":"5 "}]
[{"$nulls":7},{"$f":"SUM(H99:H115)","v":{"v":74.5,"d":"74.50"}}]
[]
[]
[{"$nulls":3},"Based on this analysis you should purchase from the highest vendor rating. Which is ="]
[]
[{"$nulls":7},{"$f":"MAX(H42:H118)","v":{"v":94.5,"d":"94.50"}}]