Vendor Rating 1
Vendor Rating 1
Vendor Rating 1
International Journal of Engineering Science and Innovative Technology (IJESIT) Volume 2, Issue 3, May 2013
I. INTRODUCTION Vendor evaluation is a system for recording and ranking the performance of a supplier in terms of a variety of issues, which may include delivery performance and the quality of the items. A process of vendor rating is essential to effective purchasing. Vendor selection is crucial because of its strategic importance especially when it comes to Government Supplies where money & quantities involved are generally very large. Usually, the most important measure of a supplier's service is his record of past performance. Vendor rating is the result of a formal vendor evaluation system. Vendors or suppliers are given standing, status, or title according to their attainment of some level of performance, such as delivery, lead time, quality, price, or some combination of variables.The ratings shall be used to; Assess and monitor supplier performance with a view to rewarding suppliers who meet expectations with on-going and future supply relationships. Provide accurate feedback to suppliers to highlight their strengths as well as their weaknesses (through the eyes of the customer) which can be used as an effective continuous improvement tool. Provide benchmark data, which will allow suppliers to establish where they are placed in relation to the best performers in their industry and hence improve overall competitiveness in the market. Helping minimize subjectivity in judgment and make it possible to consider all relevant criteria in assessing suppliers. Providing feedback from all areas in one package and hence specific action could be taken to correct identified performance weaknesses. Establishing continuous review standards for vendors, thus ensuring continuous improvement of vendor performance. To select vendors for further development. II. PROBLEM DEFINITION Purchase department of the company purchases capital goods, raw materials, equipments, spares, intermediary products, office items etc. for all its divisions and departments. The company had no system to evaluate and rate its vendors based on their performance in the purchase department.The objective of the present study is to develop a vendor evaluation and rating system that incorporates the companys evaluation and rating criterions. The study is limited to the evaluation of suppliers of valves, purchased through the Equipment spares and supplier section of the purchase department. III.METHODOLOGY The various steps involved in methodology are identifying methods to measure supplier performance, method selection, identifying the key supplier evaluation factors, data collection, data analysis and overall supplier evaluation and ranking. Supplier performance can be measured by the methods like Categorical Method, Cost ratio
447
448
If the CR value obtained is less than 0.10, inconsistency in human judgment is considered acceptable; otherwise it indicates that the judgment is highly inconsistent. The AHP approach as applied to supplier selection problem consists of the following five steps [3]. 1. Specify the set of criteria for evaluating the suppliers. 2. Obtain pair wise comparision of the relative importance of the criteria in achieving the goal and compute weights of the criteria based on this information. 3. Obtain measures that describe the extent to which each supplier achieves the criteria. 4. Using information in step 3, obtain the pair wise comparision of the relative importance of the suppliers with respect to the criteria and compute the corresponding weights. 5. Using the results of step 2 and 4 compute the priorities of each suppliers.
Hierarchical structure of the problem is shown in figure is given above. Level 0 is the goal of the analysis. Level 1 is multi criteria that consist of several factors. You can also add several other levels of sub criteria and sub-sub criteria. The last level is the alternatives. The lines between levels indicate relationship between factors, choices and goal. In level, 1 you will have one comparison matrix corresponds to pair-wise comparisons between 4 factors with respect to the goal. Thus, the comparison matrix of level 1 has size of 4 by 4. Because each choice is connected to each factor, and you have 3 choices and 4 factors, then in general you will have 4 comparison matrices at level 2. Each of these matrices has size 3 by 3.The scale of numbers that indicates how many times more important or dominant one element is over another element with respect to the criterion or property with respect to which they are compared is shown below . One compares a criteria indicated on the left with another indicated at the top and answers the question: How many times more, or how strongly more is that criteria than the one at the top? One then enters the number from the scale that is appropriate for the judgment: for example, enter 9 in the position meaning that this criterion is of extreme importance when compared with the other. It is automatic that 1/9 is what one needs to use in the transpose position. One always enters the whole number in its appropriate position and automatically enters its reciprocal in the transpose position.
449
C.IDENTIFYING THE KEY SUPPLIER EVALUATION FACTORS The purchasing function directly affects the competitive ability of a firm. Purchasing managers need to periodically evaluate supplier performance in order to retain those suppliers who meet their requirements. The importance of incorporating multiple attributes into vendor evaluation is well established. The factors that could be considered while evaluating the suppliers performance [4] are quality, delivery, service, price, information system capability, overall personal capabilities, environmental regulation compliance, financial capabilities, etc. After discussions with the purchase officials of the ESS section certain supplier evaluation factors were selected and they are quality, delivery, service (rediness to help in emergencies, rediness to replace rejected materials, providing support documents in time, promptness in reply) and environmental regulation compliance. The Hierarchical structure of vendor rating (valves) is shown in figure 3.3.1.In the figure,1 indicates rediness to help in emergencies, 2 indicates rediness to replace rejected materials,3 indicates providing support documents in time and 4 indicates promptness in reply.
D. DATA COLLECTION Service related data was collected through a questionnaire to the ESS section official in charge of the purchase of valves. Answers to the questionnaire were used as data to assess the service provided by respective organizations. Environmental regulation compliance data was collected by direct enquiry to the companies and from their respective websites. The data collected is from the respective organizations. Quality and delivery related data are collected for a period of 1 year.
Table 3: Evaluation factors data (Quality, Delivery, Environmental regulation compliance) Quality Data VENDOR No. of items rejected 25 21 17 12 36 No. of items purchased 131 89 99 76 128 Delivery Data No. of times delivery is not on time 4 4 2 4 3 No. of times items have been purchased 28 23 24 12 21 Environmental Compliance Data Certifications ISO 9001:2000, ISO 14001:2000 ISO 9001:2008 ISO 9001:2000 ISO 9001:2000, ISO 14001:2000 ISO 9001:2000 Regulation
450
The data that need to be collected for the various criterions for evaluation factors are listed in the below above. E. DATA ANALYSIS The Pair wise comparision of main criteria with respect to the Goal is shown in table given below.
Table 4 Pair wise comparision matrix of main criteria with respect to the Goal Quality Delivery Service Environmental Priority Factor Factor Factor Factor Quality Factor Delivery actor Service Factor Environmental Factor 1 1/8 2 1 1 1/7 2 1 1 1/7 8 7 7 1 0.446 0.2556 0.2556 0.0428
max = 4.0503 CI = 0.0168 CR = 0.0186 The above matrix indicates how important each criterion is with respect to each other. The priorities of each factor are a measure of their importance. The matrix has an acceptable CR value indicating consistency in judgment. 1 QUALITY The data collected is converted into parts per million by the following formula PPM= (No of items rejected/No of items purchased) 1000000 Here PPM means no of items rejected not meeting the specifications per one million items (Douglas C Montgomery, 2004).
VENDOR Company 1 Company 2 Company 3 Company 4 Company 5 Company 6 Company 7 Table 5.Data for Quality evaluation No of items No of items rejected purchased 25 131 21 89 17 99 12 76 36 128 49 122 23 110 PPM 190840 235955 171717 157895 281250 401639 209091
Depending on data from the above table pair wise comparision between the various vendors with respect to quality is made. The vendor with least PPM gets the best rating in the preceding table.
Table 6 Pair wise comparision matrix of vendors with respect to Quality Company Company Company Company Company Company Company 1 2 3 4 5 6 7 1 3 1/3 4 6 2 1/3 1 1/5 2 4 1/2 2 4 1 5 7 3 3 5 2 1 6 8 4 1/5 1/6 1 3 1/3 1/6 1/7 1/8 1/3 1 1/5 2 1/3 3 5 1 Priority 0.1594 0.0715 0.2374 0.3501 0.0488 0.0261 0.1067
max = 7.3397 CI = 0.0566 CR = 0.0429 .The matrix has an acceptable CR value indicating consistency in judgement. 2 DELIVERY The delivery data collected is shown in table given below.
VENDOR Company 1 Company 2 Company 3 Company 4 Table 7: Delivery related data No of times delivery is not No of times items have been on time purchased 4 28 4 23 2 24 4 13 PPM 142857.143 173913.043 83333.333 307692.308
451
The data collected is converted into parts per million by the following formula; PPM= (No of times delivery is not on time/No of times items have been purchased) 1000000 PPM means no of times delivery is not meeting the agreed delivery time per one million deliveries. 0-3 days early delivery is considered on time and all other deliveries as not on time. Depending on data from the above table pair wise comparision between the various vendors with respect to delivery is made. The vendor with least PPM gets the best rating in the preceeding table.
Table 8: Pair wise comparision matrix of vendors with respect to Delivery Company Company 1 Company 3 Company 4 Company 5 Company 6 2 1 2.5 1/3 7 1 6 1/2.5 1 1/5 6 1/2.5 5 3 5 1 2 3 7 1/7 1/6 1/8 1 1/7 1/3 1 2.5 1/3 7 1 6 1/6 1/5 1/7 3 1/6 1 1/2 2 6.5 1/2 5 Company 7 2 1/2 4 1/6.5 2 1/5 1 Priority 0.1759 0.0941 0.372 0.0234 0.1759 0.0371 0.1215
max = 7.5524 CI = 0.0921 CR = 0.0697 The matrix has an acceptable CR value indicating consistency in judgement. 3 SERVICE Service criterion is divided into four sub-criterions, and hence the importance of the sub-criterions with respect to each other is calculated and shown in the table below. The value of priorities indicates each sub-criterions importance, higher the priority value more important is the sub-criterion. In the current situation rediness to help in emergencies and rediness to replace rejected materials has higher importance than the other sub-criterions. The table given below shows pairwise comparision matrix of sub-criteria with respect to service
Table 9: Pairwise comparision matrix of sub-criterions of service Rediness to help in Rediness to replace Providing support Promptness in emergencies rejected materials documents in time reply Rediness to help in emergencies Rediness to replace rejected materials Providing support documents in time Promptness in reply 1 1 1/3 1/3 1 1 1/3 1/3 3 3 1 1 3 3 1 1 Priority 0.375 0.375 0.125 0.125
max = 4.0000 CI = 0.0000 CR = 0.0000 The matrix has an acceptable CR value indicating consistency in judgement. Pair wise comparison matrix of various vendors with respect to their rediness to help in emergencies The following matrix shows the various organizations willingness to help when there is an emergency. Higher the priority value better is the companys rediness to help in emergencies.
Table 10: Pair wise comparison matrix of vendors with respect to their rediness to help in emergencies Company Company 1 Company 3 Company 4 Company 5 Company 6 Company 7 Priority 2 Company 1 1 1/2 1/5 5 4 6 2 0.1484 Company 2 2 1 6 5 7 2 0.1954 Company 3 5 4 1 7 6 8 5 0.4163 Company 4 1/5 1/6 1/7 1 1/3 3 1/4 0.0404 Company 5 1/5 1/6 3 1 4 1/3 0.0645 Company 6 1/6 1/7 1/8 1.3 1/4 1 1/5 0.0248 Company 7 1/2 1/5 4 3 5 1 0.1104
max = 7.8512 CI = 0.1419 CR = 0.1075 The matrix has an acceptable CR value indicating consistency in judgement.
452
max = 7.5896 CI = 0.0983 CR = 0.0744 The matrix has an acceptable CR value indicating consistency in judgement. 3 Pair wise comparision matrix of various vendors with respect to providing support documents in time The following matrix shows the various organizations performance with respect to providing support documents in time.
Table 12: Pair wise comparision matrix of various vendors with respect to providing support documents in time Company Company Company Company Company Company Company Priority 1 2 3 4 5 6 7 Company 1 1 1 1 1 2 2 1 0.1667 Company 1 1 1 1 1 2 2 1 0.1667 Company 3 1 1 1 1 2 2 1 0.1667 Company 4 1 1 1 1 2 2 1 0.1667 Company 5 1/2 1/2 1/2 1 1 1/2 0.0833 Company 6 1/2 1/2 1/2 1 1 1/2 0.0833 Company 7 1 1 1 1 2 2 1 0.1667
max = 7.0000 CI = 0.0000 CR = 0.0000 The matrix has an acceptable CR value indicating consistency in judgement.Higher the priority value,better is the companys rediness to replace rejected materials. Providing of support documents in time is considered because unless and untill all documents are provided the purchase process cannot be completed. Hence this criterion is given consideration while evaluating the suppliers performance. 4 Pair wise comparision matrix of various vendors with respect to promptness in reply The following matrix shows the various organizations performance with respect to its promptness in reply. Higher the priority value better is the companys promptness.
Table 13 Pairwise comparision matrix of various vendors with respect to promptness in reply Company 1 Company 1 Company 2 Company 3 Company 4 Company 5 Company 6 Company 7 1 1 1 1/2 1/2 1/3 1/2 Company 2 1 1 1 1/2 1/2 1/3 1/2 Company 3 1 1 1 1/3 Company 4 2 2 2 1 1 1 Company 5 2 2 2 1 1 1/2 1 Company 6 3 3 3 2 2 1 2 Company 7 2 2 2 1 1 1/2 1 Priority 0.2057 0.2057 0.2057 0.1073 0.1073 0.061 0.1073
max = 7.0172 CI = 0.0029 CR = 0.0022 The matrix has an acceptable CR value indicating consistency in judgement. The final table combines the matrixes of all criterions and sub-criterions into one matrix. It is in this final matrix that all the weights are multiplied in order to get the overall supplier performance. The performance of suppliers (priorities) with respect to each criterion and sub-criterion of each vendor is multiplied with the individual weights
453
Individual Score 0.3913 0.0435 0.0435 0.3913 0.0435 0.0435 0.0435 0.1737 0.1032 0.2983 0.1948 0.0883 0.0333 0.1084
F. OVERALL SUPPLIER RANKING The Overall Supplier Ranking is shown in the table given below.
Table 15: Overall Supplier Ranking Rank 1 2 3 4 5 6 7 Vendor Name Company 3 Company 4 Company 1 Company 7 Company 2 Company 5 Company 6 Individual Score 0.2983 0.1948 0.1737 0.1084 0.1032 0.0883 0.0333 Idealised Score 1 0.653 0.5822 0.3632 0.3458 0.2959 0.1117
The above table shows the ranking of suppliers based on the various criterions and sub-criterions. An idealized score which shows how all the vendors perform with respect to the best vendor is also presented. IV. CONCLUSION Absence of a vendor evaluation and rating system in the organizations purchase department was taken as the study. A Vendor evaluation and rating system that incorporates the companys evaluation criterions was successfully developed using AHP technique. The ranking of suppliers based on the various criterions and sub-criterions was formed .An idealized score which shows how all the vendors perform with respect to the best vendor is also formulated. REFERENCES
[1] Satty, T.L.(2008) Decision making with the Analytic Hierarchy Process, Int. J. Services Sciences, Vol. 1, pp.83 -97. [2] Satty, T.L.(1990) How to make a decision: The Analytic Hierarchy Process, European Journal of Operational Research, Vol. 48, pp.9-26. [3] Nydick, R.L. and Hill, R.P.(1992) Using the Analytic Hierarchy Process to Structure the Supplier Selection Procedure, International Journal of Purchasing and Materials Management, Vol. 28, pp.31-36. [4] Weber, C.A., Current, J.R., Benton, W.C.(1991) Vendor Selection criteria and methods, European Journal of Operational Research, Vol. 50, pp.2-18.
454
455