eprintid: 17493
rev_number: 2
eprint_status: archive
userid: 1
dir: disk0/00/01/74/93
datestamp: 2023-12-19 03:23:52
lastmod: 2023-12-19 03:23:52
status_changed: 2023-12-19 03:08:09
type: article
metadata_visibility: show
creators_name: Fudzin, F.
creators_name: Mokhtar, A.A.
creators_name: Muhammad, M.
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
ispublished: pub
keywords: Automotive industry; Competition; Decision making; Hierarchical systems; Outsourcing; Supply chain management; Visual BASIC, 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, Analytic hierarchy process
note: cited By 0
abstract: 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.
date: 2022
publisher: Universiti Malaysia Pahang
official_url: 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
id_number: 10.15282/ijame.19.3.2022.03.0763
full_text_status: none
publication: International Journal of Automotive and Mechanical Engineering
volume: 19
number: 3
pagerange: 9909-9920
refereed: TRUE
issn: 22298649
citation:   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