Cover Image

Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh

The automotive industries in Malaysia have grown well and developed many suppliers in their supply chain including Small Medium Enterprise (SME). The order handling process at a supplier's factory has become one of the most critical areas in the supply chain. Adaptation to technology such as Io...

Full description

Saved in:
Bibliographic Details
Main Authors: Hassan, Mohamad Khairi, Mohd Rusli, Mohd Hazri, Mohd Salleh, Noor Azlina
Format: Article
Language:English
Published: Faculty of Mechanical Engineering Universiti Teknologi MARA (UiTM) 2023
Subjects:
Economics
QA Mathematics
Online Access:https://ir.uitm.edu.my/id/eprint/84053/1/84053.pdf
https://ir.uitm.edu.my/id/eprint/84053/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.uitm.ir.84053
record_format eprints
spelling my.uitm.ir.840532023-09-18T02:51:20Z https://ir.uitm.edu.my/id/eprint/84053/ Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh jmeche Hassan, Mohamad Khairi Mohd Rusli, Mohd Hazri Mohd Salleh, Noor Azlina Economics QA Mathematics The automotive industries in Malaysia have grown well and developed many suppliers in their supply chain including Small Medium Enterprise (SME). The order handling process at a supplier's factory has become one of the most critical areas in the supply chain. Adaptation to technology such as IoT enables the automotive supplier to better manage their customer orders and avoid mistakes that affect the supply chain. In order to improve the order processing activities, a study has focused on developing a mobile device application using Google Appsheet and Google Sheets as a cost-effective system for managing supply orders. A study was conducted in one of Malaysian SME automotive companies, which manages the orders manually by using a log book with a lot of recording and redundant work. By using Google Sheets, all the information and data involved in order processing activities is imported and digitized. Then, a mobile application is created using Appsheet so that the ordering activities and processing can be completed on a mobile device. All information gathered by the mobile app (Google Appsheet) is immediately saved in Google Sheets on an Excel-based database, allowing for further data analysis. The research conducted has managed to integrate these two applications into a system for Malaysia's SME factory to manage the ordering activities in the automotive supply chain. This system enables the user to shorten their order processing time since data is captured in real time and mistakes due to manual error can be avoided. Faculty of Mechanical Engineering Universiti Teknologi MARA (UiTM) 2023-09 Article PeerReviewed text en https://ir.uitm.edu.my/id/eprint/84053/1/84053.pdf Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh. (2023) Journal of Mechanical Engineering (JMechE) <https://ir.uitm.edu.my/view/publication/Journal_of_Mechanical_Engineering_=28JMechE=29/>, 20 (3): 4. pp. 63-81. ISSN 1823-5514 ; 2550-164X
institution Universiti Teknologi Mara
building Tun Abdul Razak Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Mara
content_source UiTM Institutional Repository
url_provider http://ir.uitm.edu.my/
language English
topic Economics
QA Mathematics
spellingShingle Economics
QA Mathematics
Hassan, Mohamad Khairi
Mohd Rusli, Mohd Hazri
Mohd Salleh, Noor Azlina
Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh
description The automotive industries in Malaysia have grown well and developed many suppliers in their supply chain including Small Medium Enterprise (SME). The order handling process at a supplier's factory has become one of the most critical areas in the supply chain. Adaptation to technology such as IoT enables the automotive supplier to better manage their customer orders and avoid mistakes that affect the supply chain. In order to improve the order processing activities, a study has focused on developing a mobile device application using Google Appsheet and Google Sheets as a cost-effective system for managing supply orders. A study was conducted in one of Malaysian SME automotive companies, which manages the orders manually by using a log book with a lot of recording and redundant work. By using Google Sheets, all the information and data involved in order processing activities is imported and digitized. Then, a mobile application is created using Appsheet so that the ordering activities and processing can be completed on a mobile device. All information gathered by the mobile app (Google Appsheet) is immediately saved in Google Sheets on an Excel-based database, allowing for further data analysis. The research conducted has managed to integrate these two applications into a system for Malaysia's SME factory to manage the ordering activities in the automotive supply chain. This system enables the user to shorten their order processing time since data is captured in real time and mistakes due to manual error can be avoided.
format Article
author Hassan, Mohamad Khairi
Mohd Rusli, Mohd Hazri
Mohd Salleh, Noor Azlina
author_facet Hassan, Mohamad Khairi
Mohd Rusli, Mohd Hazri
Mohd Salleh, Noor Azlina
author_sort Hassan, Mohamad Khairi
title Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh
title_short Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh
title_full Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh
title_fullStr Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh
title_full_unstemmed Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse / Mohamad Khairi Hassan, Mohd Hazri Mohd Rusli and Noor Azlina Mohd Salleh
title_sort development of an order processing system using google sheets and appsheet for a malaysian automotive sme factory warehouse / mohamad khairi hassan, mohd hazri mohd rusli and noor azlina mohd salleh
publisher Faculty of Mechanical Engineering Universiti Teknologi MARA (UiTM)
publishDate 2023
url https://ir.uitm.edu.my/id/eprint/84053/1/84053.pdf
https://ir.uitm.edu.my/id/eprint/84053/
_version_ 1778165989823741952
score 13.211869

Similar Items