臺灣博碩士論文加值系統

供應鏈管理中須先決定最佳供應商家數，當決定最佳供應商數量後，下一步驟將執行供應商評選，也就是要選擇合適的合作夥伴。在競爭激烈的半導體產業中，企業必須建立一套完整制度在供應商評選上，才能利用優勢的資訊力量來提昇企業的績效。當半導體產業專注於本業的製造，常將物流作業委外處裡，企業在委外處裡時必須確認與評估外部資源，而層級分析法是很適合應用在半導體產業來解決供應商選擇的課題。

本研究藉由訪談及問卷調查，建構出成本、品質、交期、技術和協同合作五個構面，及二十二個評估準則來評選供應商。本研究首先提出供應商選擇程序的決策經驗準則，再者利用層級分析法確認適當準則決策後，解決供應商選擇問題，並做個案探討。最後，本研究應用VBA來設計出一套供應商評選系統，作為企業建立供應商評選時之參考。

Decision-making systems are utilized to determine the optimal number of suppliers. After determining the optimal number of suppliers, the following step is to implement supply chain management; that is, to choose suitable partners. In the constantly fluctuating and extremely competitive semiconductor industry, a company cannot survive without comprehensive supplier identification and evaluation, an e-supply chain and ability to leverage informational advantages to enhance performance. Once a decision is reached for an outsourced product, a semiconductor industry must identify and frequently evaluate external sources. The AHP methodology is demonstrated by applying it to a semiconductor industry with a supplier selection problem.
In this study, By interviewing and surveying purchase managers of semiconductor industry, 22 criteria were identified for supplier selection and classified into five groups—cost, quality, delivery, technology and collaboration. First, this study provides empirical evidence for the criteria and the procedures for the supplier selection process. Second, this study identifies the suitability of the AHP to assist during decision making and resolve the supplier selection problem. Third, illustrate a case study with an semiconductor industry. Finally, this study applies visual basic applications (VBA) to design an AHP supplier selection program, and the system can assist managers in making supplier selection decisions rapidly.

TABLE OF CONTENTS
摘要 i
ABSTRACT ii
ACKNOWLEDGEMENTS iii
TABLE OF CONTENTS iv
LIST OF FIGURE vi
LIST OF TABLE vii
CHAPTER 1 INTRODUCTION 1
1.1 Research Background and Motivations 1
1.2 Research Objectives 2
1.3 Research Process 4
1.4 Research Scope 5
1.5 Organization of the Study 5
CHAPTER 2 LITERATURE REVIEW 6
2.1 Outsourcing 6
2.2 Single/multiple sources 7
2.3 Supplier Development 9
2.4 Supplier Selection 11
2.5 Analytic Hierarchy Process 19
CHAPTER 3 THE ANALYTIC HIERARCHY PROCESS 21
3.1 Measurement Approach 21
3.2 Calculation of Relative Weights 26
3.3 Questionnaire Design of Evaluation Criteria 28
3.4 AHP Questionnaire Design 29
3.5 Using AHP to Support Supplier Selection Decisions 31
CHAPTER 4 EMPIRICAL RESULTS OF CASE STUDY 32
4.1 Data Collection 32
4.2 Data Analysis 33
CHAPTER 5 APPLICATION OF VBA TO AHP SUPPLIER SELECTION 44
5.1 Important Features of the VBA 44
5.2 AHP Supplier Selection System 46
CHAPTER 6 CONCLUSIONS AND SUGGESTIONS FOR FUTURE RSEARCH 50
6.1 Conclusions 50
6.2 Suggestions for future research 50
REFERENCES 51
APPENDIX A 54
APPENDIX B 65

LIST OF FIGURES
Fig. 1.1 Research Process 4
Fig. 2.1 Impact of supplier selection criteria and supplier involvement on performance 15
Fig. 3.1 The AHP framework 23
Fig. 3.2 Creating reciprocal pairwise comparison matrix 24
Fig. 5.1 Visual Basic Editor 45
Fig. 5.2 Project Explorer Windows 45
Fig .5.3 AHP main system buttons 46
Fig. 5.4 Evaluation criteria pairwise comparison function 47
Fig. 5.5 Calculated weights for criterion dimensions 48
Fig. 5.6 Total scores for each alternative 48
Fig. 5.7 Total scores for alternative 49


LIST OF TABLES
Table 2.1 Comparing single versus multiple-sourcing 8
Table 2.2 Portfolio of Supplier Relationships 10
Table 2.3 Responsibility Matrix-Supplier Relations 13
Table 2.4 A Total Value Weighting Process 14
Table 2.5 Benefits of the Analytic Hierarchy Process 20
Table 3.1 Scale for coding responses 25
Table 3.2 Random index (RI) 27
Table 3.3 Questionnaire of evaluation criteria 28
Table 3.4 Comparison scale 29
Table 3.5 Filled example 29
Table 3.6 AHP questionnaire of level II 30
Table 4.1 Level 2 : Evaluation criteria 36
Table 4.2 Level 3 :Dimension criteria- Cost 36
Table 4.3 Level 3 :Dimension criteria- Quality 36
Table 4.4 Level 3 :Dimension criteria- Technology 37
Table 4.5 Level 3 :Dimension criteria- Delivery 37
Table 4.6 Level 3: Dimension criteria- Collaboration 38
Table 4.7 Level 4: Supplier alternatives- Price 38
Table 4.8 Level 4: Supplier alternatives- Transportation cost 38
Table 4.9 Level 4: Supplier alternatives- Process capability 39
Table 4.10 Level 4: Supplier alternatives- Delivery quality 39
Table 4.11 Level 4: Supplier alternatives- Service quality 39
Table 4.12 Level 4: Supplier alternatives- Customer service policy 39
Table 4.13 Level 4: Supplier alternatives- Employee training level 39
Table 4.14 Level 4: Supplier alternatives- Design ability 40
Table 4.15 Level 4: Supplier alternatives- Innovation ability 40
Table 4.16 Level 4: Supplier alternatives- Informational technology application 40
Table 4.17 Level 4: Supplier alternatives- Customer service process 40
Table 4.18 Level 4: Supplier alternatives- Timeliness 40
Table 4.19 Level 4: Supplier alternatives- Accuracy 41
Table 4.20 Level 4: Supplier alternatives- Emergency order service 41
Table 4.21 Level 4: Supplier alternatives- Flexibility 41
Table 4.22 Level 4: Supplier alternatives- Image and relationship 41
Table 4.23 Level 4: Supplier alternatives- Organization structure 41
Table 4.24 Level 4: Supplier alternatives- Management and control process 42
Table 4.25 Level 4: Supplier alternatives- Location 42
Table 4.26 Level 4: Supplier alternatives- Collaborative records 42
Table 4.27 Level 4: Supplier alternatives- Financial status 42
Table 4.28 Level 4: Supplier alternatives- Conditions of payment 42
Table 4.29 Total Scores for Alternatives 43

REFERENCES

1.Berger, P. D., Gerstenfeld, A., Zeng, A. Z. (2004). “How many suppliers are best? A decision-analysis approach,” OMEGA: The International Journal of Management Science, Vol. 32, No. 1, pp.9-15.
2.Burton, T. T. (1988). “JIT/Repetitive Sourcing Strategies: Tying the Kont’ with Your Supplier,” Production and Inventory Management Journal, Vol.29, No.4, pp.31-37.
3.Bozarth and Handfield (2006). Introduction to Operations and Supply Chain Management, Pearson Prentice Hall.
4.Barbarosoglu, G. and T. Yazgac. (1997). “An Application of the Analytic Hierarchy Process to the Supplier Selection Problem,” Production and Inventory Management Journal, Vol. 38, No. 1, pp.14-21.
5.Campbell, N. C. G. (1985). “An Interaction Approach to Organizational Buying Behavior,” Journal of Business Research, Vol. 13, No.1, pp.35-48.
6.Craig R. C, R. J. Auskalnis, and C. L. Ketchum (1999). “Purchasing from Minority Business Enterprises Key Success Factors,” The Journal of Supply Chain Management, Vol.35, No.4, pp.28-32.
7.Collins and Bechler (1999). “Outsourcing in the Chemical and Automotive Industries: Choice or Competitive Imperative?” The Journal of Supply Chain Management, Vol.35, No.4, pp.4-11.
8.Cheng, E. WL. and Li, H. (2002). “Analytic hierarchy process: a decision-making method for construction management,” Proceeding of First International Conference on Construction in the 21st Century, Challenges and Opportunities in Management and Technology, pp.25-26.
9.Degraeve, Z. and F. Roodhooft. (1999). “Effectively Selecting Supplier Using Total Cost of Ownership,” The Journal of Supply Chain Management, Vol. 35, No. 1, pp.5-10.
10.Ford, I. (2003). “Partners in Progress,” Supply Management, Vol.8, No.13, pp.30-31.
11.Fearon, H. E. and M.R. Leenders (1995). Leenders, Purchasing’s Organizational Roles and Responsibilities (Tempe, AZ: Center for Advanced Purchasing Studies), pp.25- 44.
12.Fawcett, S. E. and S. A. Fawcett (1995). “The Firm as a Value-Added System: Integrating Logistics, Operations and Purchasing,” International Journal of Physical Distribution & Logistics Management, Vol. 25, No.5, pp.24-42.
13.Gregory, Robert E., (1986). “Source Selection: A Matrix Approach,” Journal of Purchasing and Materials Management, Vol. 22, No.2, pp.24-29.
14.Gary W. Dickson (1966). “An analysis of vendor selection systems and decisions,” Journal of Purchasing, Vol. 2, No.1, pp.5-17.
15.Handfield, R. B., G. L. Ragatz, K. J. Petersen, and R. M. Monczka. (1999). “Involving Suppliers in New Product Development,” California Management Review, Vol. 42, No.1, pp.59-82.
16.Hirakubo, N. and M. Kublin. (1998). “The Relative Importance of Supplier Selection Criteria: The Case of Electronic Components Procurement in Japan,” International Journal of Purchasing and Materials Management, Vol. 34, No.2, pp.19-24.
17.Howard, A. (1998). “Valued Judgements,” Supply Management, Vol.3, No.25, pp.37-38.
18.Jayaraman, V., R. Srivastava, and W. C. Benton.(1999). “Supplier Selection and Order Quantity Allocation: A Comprehensive Model,” The Journal of Supply Chain Management, Vol. 35, No.2, pp.50-58.
19.Juran J. M. and F. M. Gryna (1993). Quality Planning and Analysis, 3rd edition, McGRAW-HILL.
20.Laios, L. and S. Moschuris (1999). “An Empirical Investigation of Outsourcing Decisions,” The Journal of Supply Chain Management, Vol.35, No.1, pp.33-41.
21.Macbeth, D. K. (2002). Managing a Portfolio of Supplier Relationships. Gower Handbook of Purchasing Management, 3rd edition, Gower Publishing.
22.Mason, T., (1996). “Getting Your Suppliers on the Team,” Logistics Focus, Vol. 4, No.1, pp.10-12.
23.Morgan, J., (1996b). “Good May not be Good Enough,” Purchasing, Vol. 120, No.7, pp.38-41.
24.Narasimhan, R. (1983). “An Analytical Approach to Supplier Selection,” Journal of Purchasing and Materials Management, Vol. 19, No.4, pp.27-32.
25.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, No.2, pp.31-36.
26.Saaty T. L. (1990). “How to make a decision: the analytic hierarchy process,” European Journal of Operational Research, Vol. 48, No.1, pp.9-26.
27.Saaty T. L. (2001). Decision making for leaders. 3rd edition, RWS Publications.
28.Saaty, T. L. (1994). “How to make a decision: the analytic hierarchy process,” Interfaces, Vol. 24, No. 6, pp.19-43.
29.Saaty, T. L. (1980). The analytic hierarchy process, McGraw-Hill, New York.
30.Soukup, W. R.,(1987). “Supplier Selection Strategies,” Journal of Purchasing and Materials Management, Vol. 23, No.2, pp.77-82.
31.Sarkis, J. and S. Talluri. (2002). “A model for Strategic Supplier Selection,” The Journal of Supply Chain Management, Vol.38, No.1, pp.18-28.
32.Swift, C. O. (1995). “Preferences for single sourcing and supplier selection criteria,” Journal of Business Research, Vol.32, No.2, pp.105-111.
33.Krause, D. R., (1997). “Supplier Development: Current Practices and Outcomes,” International Journal of Purchasing and Materials Management, Vol. 33, No.2, pp.12-19
34.Kraljic, P. (1983). “Purchasing Must Become Supply Management,” Harvard Business Review, Vol. 83, No.5, pp.109-117.
35.Poirier, C. C. (2004). Using Models to Improve the Supply Chain, St. Lucie Press.
36.Vonderembe, M. A. and M. Tracey (1999). “The Impact of Supplier Selection Criteria and Supplier Involvement on Manufacturing Performance,” The Journal of Supply Chain Management, Vol. 35, No.3, pp.33-39.
37.Weber, C. A. and J. R. Current (1991). “Vendor Selection Criteria and Methods,” European Journal of Operational Research, Vol. 50, No.1, pp.2-18.
38.Wisner J. D. and K. Leong and K. C. Tan (2005). Principles of Supply Chain Management- A Balanced Approach, THOMSON.
39.Wind, Y. and T. L. Saaty (1980). “Marking Application of the Analytic Hierarchic Process,” Management Science, Vol.26, No.7, pp.641-658.