WCSE

Food Retail Company Web-Based POS with Inventory and Stock Management System

Abstract— Automation generates a lot of savings in that it eliminates errors, reduces the time to perform a certain task, and reduces the need for a large number of employees to perform the same function. The researchers have focused on this specific food retail company named True North Empanada which sells Empanadas which are Latin-American baked or fried pastries. This study aimed to address the problem of the company with its current inventory system which is not yet automated. Data processing is manual. The consolidation and preparation of their reports is time consuming and prone to errors which often results to a big discrepancy in the actual and recorded inventory. This often leads to problems particularly in estimating, ordering, and supplying of raw ingredients. The researchers intended to improve the food retail company’s inventory management by developing a Webbased system that automates the inventory management process. With the system, the preparation of inventory reports is made easy and fast making them readily available upon request. The automation facility allows the bill-of-materials to be computed in real-time per product sale. This helps a lot in determining immediately the status of the inventory of raw ingredients and in minimizing spoilage. The automated functions also minimize the possibility of human errors in data entry and computations. The functions and features included in the developed system were based from the actual reports used in the current inventory management process particularly the computation of the raw ingredients per product. The automated computation of bill-of-materials has minimized the discrepancy in the actual and recorded inventory. To analyze the current system, the researchers used a variety of methods and tools. The Usability Review Survey that was conducted was composed of four sections, and the average mean of each of these sections was calculated. The result showed a favorable response from the respondents. They perceived that the developed web-based system, with regards to its functionalities and features, has improved their inventory management process. They believe that the system will benefit them a lot.

Index Terms— NoSql, automation design, PSSUQ, Usability Review

Ethan Rafael B. Lorzano
School of Information Technology, Mapua University
Ian Gabriel S. Roda
School of Information Technology, Mapua University
Samuel Benjamin T. Paulo
School of Information Technology, Mapua University
Antonette D. Gabriel
School of Information Technology, Mapua University

[Download]

Cite: Ethan Raphael B. Lorzano, Ian Gabriel S. Roda, Samuel Benjamin T. Paulo, Antonette D. Gabriel, " Food Retail Company Web-Based POS with Inventory and Stock Management System, " WCSE 2022 Spring Event: 2022 9th International Conference on Industrial Engineering and Applications, pp. 371-385, Sanya, China, April 15-18, 2022.