Designing and Building a Web-Based Sales and Customer Data Management System. Case Study: Ibu Epni's Bolu and Cake Making Business, Cisewu, Garut

Abstract

The competitiveness and growth of Micro, Small, and Medium Enterprises (MSMEs) are significantly influenced by their ability to manage business operations, particularly in the cake and pastry industry. Many MSMEs still manage customer data and sales processes manually, which often leads to data inaccuracies and difficulties in monitoring sales performance. This research aims to address these challenges by designing and developing a web-based sales and customer data management system, utilizing the First In First Out (FIFO) algorithm to support business mobility. A case study is conducted on Bu Epni's Cake and Pastry Business in Cisewu, Garut, which faces issues such as manual sales recording and non-digitalized management of supplier and customer data. The proposed system will enable the digitalization of records, sales monitoring, as well as supplier and customer data management, thereby improving operational efficiency and business decision-making. By using the waterfall method in system development, this research is expected to make a tangible contribution to supporting the growth and sustainability of MSMEs through the implementation of digital technology.

Keywords: MSMEs, POS, CRM, Management system