Information System Technology Plan for Felcris Supermarket Inc.

Information System Technology Plan for Felcris Supermarket Inc.

Aljun A. Fajardo, Willace D. Candelario, Rosver M. Quimpan, Cjie C. Trabado, Stacey Nicole Marie G. Monta

Davao del Norte State College Faculty

DOI: https://dx.doi.org/10.47772/IJRISS.2025.90600065

Received: 27 May 2025; Accepted: 30 May 2025; Published: 30 June 2025

ABSTRACT

This study aims to demonstrate how the proposed system can enhance and optimize the current business operations of Felcris Supermarket Inc., Carmen Branch. According to the research, a well-designed information system can help with a number of current issues, such as poor consumer engagement, a Point of Sales (POS), and an inaccurate inventory management system.

The proposed solution aims to streamline daily operations, improve accuracy, and enhance responsiveness to customer needs. The business can significantly boost operational efficiency and strengthen customer relationships by integrating modern tools such as customer feedback portals, Point of Sales (POS), and a more efficient inventory system.

The researchers recommend this system to help the Carmen branch adapt to evolving customer expectations, digital trends, and internal performance goals. A strategic move to guarantee a more competitive and sustainable future for the company is to embrace ethical and creative technology solutions.

Keywords: Point of Sales (POS), Inventory Management System, Business Intelligence

INTRODUCTION

Background of the Company

Felcris Supermarket Inc., Carmen branch, was established in 2013 as part of the expanding network of Felcris Supermarket branches across Davao del Norte. Located in Carmen, this branch operates 24/7 as a mini-mall, offering convenience and accessibility to residents. The facility features a two-story layout, with the ground floor serving as a full-service supermarket and the second floor dedicated to clothing, school supplies, and general merchandise.

The branch sources its products from a trusted sister company, ensuring a steady supply of goods and much lower prices despite their discounted products and promos. The Supermarket has been experiencing low sales performance due to limited marketing efforts, particularly on Digital and online platforms. In addition, the Supermarket lacks an inventory management system that requires them to manually verify the products during restocking.

Current Routines and Business Processes

Current Routines

Carmen Branch operates 24/7, requiring a consistent and coordinated routine, including cleaning and maintaining the store, checking inventory stocks, and constantly shifting workers to ensure smooth business operations.

The establishment’s second floor, which is dedicated to clothing and school supplies, follows similar routines in terms of sales and inventory but operates with minimal system support. They close around 8 pm and open at 8 am.

Table 1: Event tables of Felcris Supermarket Inc.

Business Process

The business opens 24/7 since it has a convenience store on the first floor and a Department Store above, which closes at 8 pm and opens at 8 am. Since they have two departments, they have separate employees for each area. The convenience store has Day and Night employees who are constantly shifting between hours.

They have a sister company that directly offers them stock deliveries, making their products cheaper. They offer products at discounts and promos for their customers and a loyalty card that serves as a premium for customers. There is also the department store, which offers clothes and supplies at a low price.

Existing Technologies

Felcris Supermarket Inc. integrated an attendance monitoring system to monitor and track employees scheduled shifts and working hours.

Problems Found

Lacks an Inventory Management System

All stock monitoring is done manually, especially during deliveries. Employees have to visually check shelves for sold-out items, which is time-consuming and prone to human error.

Lack of IT Infrastructure

The business relies on traditional methods and outdated technologies that hinder operations, reduce productivity, increase costs, and pose potential security risks.

Goal and Objectives

General Objective

The researchers aim to propose a Retail Management System consisting of three key components, an Inventory Management System for accurate monitoring of stocks and deliveries, a Point-of-Sale System (POS) to track sales and items on shelves to ensure quality goods and fresh items are on display, and a Business Intelligence for customer analytics to further enhance customer relationship. These systems are designed to help businesses operate smoothly and automate their workloads.

Specific Objectives

The specific objective of this study is to enhance the business process and routines of the store. The researcher aims to

• To design and develop an improved inventory management system that ensures accurate stock monitoring, reduces manual checking, and minimizes discrepancies during restocking.
• To recommend an Information System organize customer information, track interactions and drives sales.

Organizational Structure

Felcris Supermarket Inc. has a general manager who runs and organizes the firm, followed by the Head Supervisor, who aids the general manager and manages the Supermarket’s personnel.

Fig 1: Organizational Structure of Felcris Supermarket Inc.

Stakeholders

Employees, consumers, investors, suppliers, the government, the environment, and communities can all be important Felcris Supermarket stakeholders.

Fig 2: Stakeholders of Felcris Supermarket Inc.                           

Proposed Information Systems

The researchers proposed a Retail Management System. Implementing an integrated system combining inventory management, Point-of-Sale (POS), and Business Intelligence (BI) is crucial to running a successful business. Many small businesses rely on traditional methods and manual labor for payments, stocking, and inventory tracking, leading to inaccurate sales and poor inventory management.

Review of the Related Study

Related Literature

Running a small retail store in the retail industry, which includes establishments like pharmacies, hardware stores, supermarkets, shopping centers, bookstores, and many more, requires a basic information system.

The inventory management system is a critical function within any organization that deals with physical goods, whether in manufacturing, retail, or distribution. Inventory management ensures that the correct quantity of products is available at the right time, minimizing excess inventory and stockouts [1]. Effective inventory management depends on reducing expenses, improving customer satisfaction, and preserving operational efficiency.

Inventory management nowadays is no longer confined to the manual process. Computerizing processes in today’s offices are already a mandate for every organization. In the Philippine setting, using Information Technology products and applications is sought after by government institutions as early as the year 2000 when former President Joseph Ejercito Estrada addressed his keynote speech on the Knowledge Economy Conference that he would especially want to see the broader, effective, widespread and extensive use of information and communications technology in all sectors of government specifically in making sure that citizen has open use of information and an immediate and the government’s effective giving out of service to the people [2].

Customers walk into a store expecting to have the products available and of good quality. Retail stores that lack a system that monitors sold-out products, or expired goods will likely have low customer sales and loyalty.

Retailers lacking POS, such as small retail stores, can experience a slow transaction process due to manual operations [3]. A POS can help solve this problem and improve the business process.

Business Intelligence refers to the processes, technologies, and equipment used to gather, analyze, and convert data into meaningful information for better strategic planning for a business. The acceptability of integrating Business Intelligence with mobile commerce in a local business. It improved customer engagement, use efficiency, user satisfaction, and reliability [4]. This allows businesses to anticipate sales trends and customer demands.

Business Intelligence significantly impacts Small and Medium Enterprises (SMEs). It facilitates and processes accurate data, allowing them to generate informed decisions. This allows a business to meet customer needs and boost employees’ performance.

A study shows that implementing Business Intelligence can improve productivity and decision-making. Although large enterprises have long engaged in business intelligence, local businesses have shown interest in and beneficial outcomes from applying business intelligence [5]. These three systems can be integrated into one system. A Retail Management System.

Related System

A Retail Management System (RMS) is a platform that unifies the management of every retail industry aspect, including accounting software, staff management, and inventory flow. By integrating various modules into a single system, departments can work together more effectively, and, more importantly, internal processes can be better controlled, boosting overall corporate efficiency [6].

The Retail Management System aims to provide an application for Retail System staff and owners to control business processes in retail chains and online stores. The RMS system integrates business processes from cataloging and tracking inventory, managing sales in stores and online stores, and storing clients’ and personnel’s info.

Small retail management systems owned by small retailers are essential. This helps the retailers minimize the loss of their retail outlets. As a developing country, it must move forward with technology [7]. Accordingly, even small retail stores at the village level should be developed by introducing technological improvements. This can be done by introducing some technology to small retail stores.

Name of Information System

A retail management system is a piece of software designed to make different parts of retail operations more efficient. Retail accounting, inventory control, customer relationship management (CRM), and point-of-sale (POS) systems are all integrated into one platform to assist small business in running their businesses.

System Functionality

• Stock Monitoring
• Sales Transaction Processing

Customer Feedback System

• Sales Reports

System Architecture

Figure 3. System Architecture of Felcris Supermarket Inc.

Cost Structure

Table 2. Cost Structure

Proposed It Infrastructure And Peopleware

Proposed Computer Hardware

The researchers suggest improving both efficiency and speed in working.

Desktop computer

A computer device designed to fit on top of a desk can store
essential transactions and secure data.

Table 3. Computer Hardware

Proposed Operating System Platforms

The researchers proposed an operating system that is fundamentally fast, familiar, safer, more secure, and can support software applications.

Windows 10 Home

A Microsoft operating system that supports software applications and offers built-in security features include anti-virus, firewall, and internet protections.

Table 5. Operating System

Proposed Enterprise Software Applications

Enterprise software helps the business’s growth and is a tool used for running a business effectively; it helps and manages the entire business process efficiently.

Business Intelligence (BI) helps businesses make more intelligent decisions by turning raw data, like sales, inventory, or customer habits, into clear and valuable insights. Instead of guessing what works, you can see trends, spot problems early, and find growth opportunities. It is like having an intelligent assistant that helps you understand your business better daily.

Customer Relationship Management (CRM) software keeps track of every interaction with its customers, whether a quick chat on social media, a phone call, or an email. It stores notes and details, so you always know where things left off, making building strong relationships easier and ensuring no loyal customer is forgotten.

Table 6. Enterprise Software Applications

Proposed Data Management

Data is critical to the business. It contains information that can be used to determine the best course of action. However, if not well-organized, it can be overwhelming. It may go to waste without yielding any benefits.

Table 7. Data Management

Proposed Network & Telecommunications

Since the proposed devices require constant operation, the researchers include a network infrastructure with a router and switch to ensure smooth connectivity among all devices.

Table 8. Network & Telecommunications

Proposed Internet Platforms

The business is a convenience store, so local delivery is a viable option. The ideal platform to think about is Facebook Marketplace. Social media users of every age have increased their willingness to transact online. Products can also be advertised with promos and discounts, attracting potential customers.

Table 9. Internet Platform

Proposed IT Manpower

Maintaining the IT infrastructure is essential to ensure the system fulfills its function for the company. They require a specialist to make recommendations and spread knowledge about the technology. Having firsthand knowledge of problems helps keep the system’s effectiveness from declining throughout the business process.

Table 10. IT Manpower

CONCLUSION AND RECOMMENDATION

Conclusions

The researchers learned how retail organizations handle day-to-day operations and consumer interactions from their study.   These business operations, such as an accurate and effective inventory system, improved customer interactions, and an increase in sales through business intelligence, would be greatly enhanced by a basic retail management system.

Recommendations

The following are the recommendations of the researchers to further improve business operations for Felcris Supermarket Inc.

• Integrating a Retail Management System will improve the overall workflow of business operations such as inventory tracking, transaction processing, and sales reporting. It will help streamline tasks, reduce manual errors, and enhance customer service.
• Understand buying patterns, preferences, and customer loyalty through data dashboards and reports.
• Using Social Media Platforms to promote products, engage customers, and increase sales.
• Improve technologies used if the business wants to expand their scalability.

REFERENCES

1. M. Tapado and Ma. E. T. Delluza, “Equipment Inventory System EIMS,” https://ijhss.net/index.php/ijhss/article/view/176.
2. Ayomide, D. Oladunni Abosede, and A. Kolawole Gabriel, “A Review of Existing Inventory Management Systems,” 2024. [Online]. Available: www.ijres.org
3. Ng et al., “A Problem Oriented Approach to Implementing an Inventory and Point-Of-Sale System for Company Kcp”, doi: 10.5281/zenodo.4484959.
4. Gauzelin and H. Bentz, “An examination of the impact of business intelligence systems on organizational decision making and performance: The case of France.” [Online]. Available: https://ojs.hh.se/
5. V Menor, “Integrating Business Intelligence and Mobile Commerce,” Asian Journal of Business and Technology, vol. 2, no. 1, 2019.
6. “System Design of Retail Management System,” https://iq.opengenus.org/system-design-of-retail-management-system/#retailmanagementsystem.
7. Khare, “Culture, small retail stores, and Indian consumer preferences: A moderating role of demographics,” International Review of Retail, Distribution and Consumer Research, vol. 23, pp. 87–109, Feb. 2016, doi: 10.1080/09593969.2012.734256.