TY  - JOUR
PB  - Universiti Malaysia Pahang
SN  - 22298649
EP  - 9920
AV  - none
N1  - cited By 0
TI  - 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
SP  - 9909
Y1  - 2022///
A1  - Fudzin, F.
A1  - Mokhtar, A.A.
A1  - Muhammad, M.
JF  - International Journal of Automotive and Mechanical Engineering
UR  - 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
VL  - 19
N2  - 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.
IS  - 3
ID  - scholars17493
KW  - Automotive industry; Competition; Decision making; Hierarchical systems; Outsourcing; Supply chain management; Visual BASIC
KW  -  Analytical Hierarchy Process; Body in whites; Body in-white; Decisions makings; Excel; Multi-criteria decision making problems; Outsourcing module; Process-models; Vendor Selection; Visual basic application
KW  -  Analytic hierarchy process
ER  -