relation: https://khub.utp.edu.my/scholars/17493/
title: Supply Chain Management of Outsourcing Module Components Decision-Making using Analytical Hierarchy Process and Visual Basic Application in Automotive Body-in-White Welding Assembly Line
creator: Fudzin, F.
creator: Mokhtar, A.A.
creator: Muhammad, M.
description: Supply Chain Management (SCM) has gained the attention of business organizations as it affects corporate efficiency and competitive advantage. Component outsourcing is an important element of SCM practices and is considered to be a multi-criteria decision-making problem (MCDM) in vendor selection processes. However, decision-making on the selection of vendors is crucial, as the outsourcing program is influenced by multiple technical and commercial criteria of vendors. Developing an Excel-based Analytic Hierarchy Process (AHP) model for vendor selection therefore helps to simplify selection processes. In this paper, a Visual Basic Application (VBA) Excel-based AHP model was developed, which multiple criteria, sub-criteria and vendors and simultaneously compared with multiple main criteria, sub-criteria and alternatives for vendor selection. The model was validated with a case study of selecting a vendor for module components of body-in-white (BIW) in automotive industry as industrial application. As a result, vendor A is the best vendor since it has the highest overall score of 0.35206. Whereas vendor B is 0.239, vendor C is 0.126, vendor D is 0.146 and vendor E 0.135. In addition, the model is capable of resolving other MCDM problems. This paper provides resources such as AHP methodology, validating method and VBA code programming to readers in developing their own VBA Excel-based model. © The Authors 2022. Published by University Malaysia Pahang Publishing. This is an open access article under the CC BY license.
publisher: Universiti Malaysia Pahang
date: 2022
type: Article
type: PeerReviewed
identifier:   Fudzin, F. and Mokhtar, A.A. and Muhammad, M.  (2022) Supply Chain Management of Outsourcing Module Components Decision-Making using Analytical Hierarchy Process and Visual Basic Application in Automotive Body-in-White Welding Assembly Line.  International Journal of Automotive and Mechanical Engineering, 19 (3).  pp. 9909-9920.  ISSN 22298649     
relation: https://www.scopus.com/inward/record.uri?eid=2-s2.0-85140028892&doi=10.15282%2fijame.19.3.2022.03.0763&partnerID=40&md5=4a6d805f6a282e479ef8dd5f2413e1f4
relation: 10.15282/ijame.19.3.2022.03.0763
identifier: 10.15282/ijame.19.3.2022.03.0763