A Research Proposal of Inventory and POS System for Bida Mart in the City of San Jose Del Monte, Bulacan

Authors

  • Lorelyn Ercilla Bestlink College of the Philippines
  • Arnel Delos Santos Bestlink College of the Philippines
  • Jeremy Garcia Bestlink College of the Philippines
  • Angeline Gonzales Bestlink College of the Philippines
  • Kathrina Relano Bestlink College of the Philippines
  • Maria Edna Portugal Bestlink College of the Philippines

Keywords:

Inventory management, POS system, real-time data, software development, Java Script, SQL programming languages, survey, data analysis, stock levels, notification alert, sales reports

Abstract

This study presents a comprehensive analysis of the proposed Inventory and POS System for Bida Mart, which aims to enhance inventory management and decision-making processes, streamline operations, and reduce manual record-keeping time. The manual tracking and record-keeping system is time- consuming, and the lack of real-time product data makes it difficult for Bida Mart to optimize inventory levels. This study also offers an in-depth discussion of the software and programming languages used to develop the system. A survey was conducted among the personnel of Bida Mart to collect data on their perceptions of the proposed Inventory and POS System. The survey included questions on the system's functionality, usability, and impact on inventory management and decision-making processes. The collected data were analyzed using descriptive statistics to determine the percentage of respondents who agreed with the effectiveness of the proposed system. The proposed system was developed following established software and accounting standards, using JavaScript and SQL programming languages. The survey results showed that the proposed Inventory and POS System for Bida Mart could provide real-time data visibility, making it easy to check stock levels and identify slow- moving products. The system's features enable users to quickly identify and remove unprofitable products and develop strategies to avoid losses. The system's notifications inform users about stock statuses and alert them when products need replenishment. The generated sales reports could help to forecast high-demand products during specific seasons, allowing users to optimize inventory levels for seasonal products, reducing overstocking and understocking. It can help management make wise decisions and view their sales quickly. The system is also user-friendly and easy to navigate, reducing the workload and making tasks more efficient without manual labor. The findings indicate that the proposed system for Bida Mart can impact business operations, contributing to the company's progressive financial performance and operational efficiency. The researchers conclude that JavaScript and SQL programming languages are effective for developing the proposed Inventory and POS System for Bida Mart. Future research studies can address system operability and portability challenges and add new features like integrating a prototype barcode scanner with the system.

Published

2023-10-23