Application of Green Logistics and Database Design in Developing a Real-Time Inventory Management System Using AppSheet

Alexis  Garcia; Kannikar  Vichaikul; Phitphisut  Thitart

Alexis Garcia Suan Sunandha Rajabhat University, Thailand
Kannikar Vichaikul Suan Sunandha Rajabhat University, Thailand
Phitphisut Thitart Suan Sunandha Rajabhat University, Thailand

Keywords: Inventory Management, Green Logistics, Database Design, Low-Code/No-Code, Application Development

Abstract

This project plans to develop a real-time inventory management system software on the user friendly AppSheet platform and also develop a database which is eco-friendly with regards to paper usage. The goal is to eliminate the usage of paper based processes in inventory control. There is probability to achieve this by removing unneeded activities and enabling sellers and managers to have access to current inventory data. A Desktop and Mobile cross platform application was created based on user views and selection of certain database. After the language application was deployed document processing time was reduced to 15.43 seconds and this enhanced the application’s efficiency by 71.64% from the previous 54.40 seconds. This also resulted in only 2 - 4 sheets of paper being consumed monthly when the average consumption 50.5 sheets. Thus they efficiently saved 1.2 reams of paper and 151.5 baht per year. Warehouse staff rated the software technology at overall 4 of 5 score for its ease of use and so it was well received. Studies show that companies should slash time and cost by using the inventory management.