A Mobile Application Development with MIT App Inventor for an Efficiency Improvement of Receiving, Order Picking, and Put Away Processes in the Inventory Spare Parts Case Study
Keywords:
Mobile Application, Inventory Spare Parts, MIT App InventorAbstract
This research is intended to improve the efficiency of receiving, order picking, and put-away processes in the case study of the inventory spare parts. Data were collected during August to September 2022 by observation and in-depth interviews. Analyzing factors of failure using why-why analysis technique showed a lack of appropriate equipment to record data causing of work delays, sunk costs, inability to find parts, and mismatch in spare parts’ types and quantities. MIT App Inventor was used as the tools to develop the mobile application. Then, the mobile application’s performance was compared to the warehouse management indicators and showed the user satisfaction. Three major functions of the mobile applications consist of 1) record data with database table in Google Sheets, 2) determine inventory level to avoid stock shortage, and 3) generate, read, and record QR codes of inventory spare parts for all three processes. The result revealed that the mobile application can effectively reduce lead time and improve service levels of all three processes. Moreover, results also showed great satisfaction ratings in all four aspects: function, reliability, performance, and usability by an inventory clerk and ten users. The clerks’ scores were 4.6, 4.75, 4.83, and 4, and the users’ scores were 4.72, 4.58, 4.62, and 4.53, respectively. Thus, the findings have implications that the use of mobile application with MIT App Inventor help to improve all three processes in the inventory spare parts and the ability to meet the users’ needs effectively.
References
D. Plinere and A. Borisov, “Case Study on Inventory Management Improvement,” Information Technology and Management Science, vol. 18, no. 1, pp. 91–96, 2015, doi: 10.1515/itms-2015-0014.
C. Bonkhwan, “The Application of Information Technology to manage Inventory,” M.S. Thesis, Information Technology Dept., Mahanakorn University of Technology, Bangkok, Thailand, 2011.
H. K. Chow, K. L. Choy, W. B. Lee, and K. C. Lau., “Design of a RFID Case-based Resource Management System for Warehouse Operations,” Expert Systems with Applications, vol. 30, no. 4, pp. 561–576, 2006, doi: 10.1016/j.eswa.2005.07.023.
D. Airinei and D. Homocianu, “Cloud Computing Based Web Applications. Examples and Considerations on Google Apps Script,” SSRN Journal, 2017, pp. 64–69, doi: 10.2139/ssrn.2964756.
J. Wattanapattraporn, “Application of Management Information System for Coordination in Pipeline Construction Project,” M.E. Thesis, Dept. Ind., Silpakorn University, Bangkok, Thailand, 2019.
K. Teerapabolarn, “Types of Inventory,” in Basic Inventory Analysis, Chonburi, Thailand: Burapha University, 1998, ch. 6, sec. 3, pp. 150–151.
D. Hong-Mo Yeh, “Inventory Management,” in Operations Planning and Control In ERP, Toronto, Canada: Rotman School of Management University of Toronto, Copy Right 2003, ch. 7, sec. 2, pp. 7-2–7-4. [Online]. Available:http://www.lancer.com.tw/attachments/367_ErpBook(7).pdf. [Accessed: Jan. 1, 2023].
N. Sakulpradit, “Inventory Management for Producing and Distributing Factory of Frozen Products,” M.E.Thesis, Dept. Ind., Thammasat University, Bangkok, Thailand, 2017.
W. Ritdetkhachon, “A Development of Racha Prathong’s Web Application for Online Sale and Inventory Management,” M.S. Thesis, Dept. Creative Design and Entertainment Technology, Dhurakij Pundit University, Bangkok, Thailand, 2019.
K. Krajungduang, P. Singhdong, and P. Weerapong, “Improving Warehouse Operations with Mobile Applications and ECRS Concepts Case Study of Yusen Logistics (Thailand) Co., Ltd.” Journal of Learning Innovation and Technology (JLIT), vol. 1, no. 2, pp. 62–69, 2021.
N. V. Khoa, “Warehouse Management Application for Android,” Bachelor´s thesis, Dept. IT., Oulu University of Applied Sciences, Oulu, Finland, 2017.
C. Louklex, “iStock: An Application of Inventory Control and Management for SME Business,” M.S. Thematic Paper, Dept. Web Engineering, Dhurakij Pundit University, Bangkok, Thailand, 2013.
C. K. M. Lee, Y. Lv, K. K. H. Ng, W. Ho and K. L. Choy, “Design and application of Internet of things-based warehouse management system for smart logistics,” International Journal of Production Research, vol. 56, no. 8, pp. 2753–2768, 2018, doi: 10.1080/00207543.2017.1394592.
T. Nimanong and S. Munkhong, “The Development of Program to Reduce The Recording Time of Inventory Data Case Study: Communication & System Solution Public Company Limited,” B.E. Thesis, Dept. Logistics Engineering, King Mongkut’s University of Technology North Bangkok, Bangkok, Thailand, 2019.
T. Lueng-aramphanich and P. Sirisut, “Mobile Application Development for Exchanging and Returning Goods Process Improvement Case Study: Government Pharmaceutical Organization (GPO),” B.E. Thesis, Dept. Logistics Engineering, King Mongkut’s University of Technology North Bangkok, Bangkok, Thailand, 2019.
T. Chuangchai, P. Choochat, K. Buarung and K. Chaimongkon, “Stock Management Application and Check Repair Status of wind turbines by QR Code,” Journal of Industrial Education, vol. 14, no. 2, pp. 10–23, 2020.
P. Kruepet and M. Rattanasiriwongwut, “An Office’s Material Information Management System using RFID and QR Code,” in Proc. ACTIS 14th, Bangkok, Thailand, Jul. 23, 2018, pp. 76–81.
T. Uttraporn1 and Y. Kaoien, “Efficiency of QR Code System: A Case Study of Mahidol University International College,” Journal of Professional Routine to Research, vol. 2, pp. 1–8, 2015.
K. Tawong and P. Wongkrajang, “The Application of QR CODE and Barcode on Drug Labeling,” B.E. Project, Dept. Electr. Eng., Burapha University, Chonburi, Thailand, 2017.
N. Utakrit, “Warehouse Management Vs Inventory Management.” mis.itd.kmutnb.ac.th. [Online]. Available: https://mis.itd.kmutnb.ac.th/logistics-ep3/.(Accessed Mar. 15, 2023).
S. Boonyarit and T. Laosirihongthong, “Dimensions of warehouse management performance indicators,” Research and Development Journal, vol. 24, no. 2, pp. 45–55, 2013.
Gwynne Richards, “Performance management,” in Warehouse Management, 2nd ed, London, United Kingdom: Kogan Page Limited, 2014, ch. 13, sec. 3, pp. 294-295.
N. Natip and K. Apornpisarn, “Shop Management System: A Case Study of Yiw Sport Shop,” presented at the 2nd UTCC National Conference, Bangkok, Thailand, Jun. 8, 2018, pp. 1783–1795.
W. Inkeaw, “Development of information technology systems to manage inventory of banthungleab credit union co-operative LTD.,” Songkhla Rajabhat University, Songkhla, Thailand, Final Rep., 2014.
E. Bamrungsi and T. Keitkongkeeree, “Web Application of Product and Sales Management System of Kim & Jew Minimart,”in the 5th KRU National Academic Conference, Kanchanaburi, Thailand, Sep. 4, 2020, pp. 478–487.
P. Comejina, “Information System with Internet of Things for collecting the amount of smog in Muangkaen Pattana Municipality Area Chiangmai,” Chiang Mai Rajabhat University, Chiang Mai, Thailand, Final Rep., 2019.
P. Kaewsai, “Stock Locator System,” in Warehouse Management, 7th ed., Bangkok, Thailand: Ramkhamhaeng University Press, 2000, ch. 13, sec. 3, pp. 198–200.
K. Boonprasit and O. Pinngern, “Point of Sales (POS): A Case Stude of KPR MART,” in the 9th STOU National Research Conference, Nonthaburi Thailand, Nov. 29, 2019, pp. 2072–2085.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Faculty of Engineering, King Mongkut’s Institute of Technology Ladkrabang
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
The published articles are copyrighted by the School of Engineering, King Mongkut's Institute of Technology Ladkrabang.
The statements contained in each article in this academic journal are the personal opinions of each author and are not related to King Mongkut's Institute of Technology Ladkrabang and other faculty members in the institute.
Responsibility for all elements of each article belongs to each author; If there are any mistakes, each author is solely responsible for his own articles.
