The following information is available on 3 vendors: A, B and C. Using the data below, determine the best source of supply under weighed-point method. Delivered Rejected Delivered Vendor Lots Lots Late Unit Price (CAD) A 56 3 2 $ 15.00 B 45 2 3 $ 19.00 C 50 4 5 $ 21.00 As per the decision of the management, the factor weightage for quality, delivery and price are 40%, 35% and 25% respectively. Develop an Excel worksheet to rank the performance of the vendors. How to make Excel worksheet?