Philippine E-Journals

A PROBLEM ORIENTED APPROACH TO IMPLEMENTING AN INVENTORY AND POINT-OF-SALE SYSTEM FOR COMPANY KCP

Patricia Denisse T Sison | Karla P Oreiro | John Cedric Z Camalit | Giuseppe C Ng

 

Abstract:

In an observation concerning a school cafeteria operation, we discovered that the cafeteria was prone to human errors due to the inefficient Point-of-Sale system, lack of a refund feature in the system, lack of proper and informative inventory system, and the unfriendly main user interface for transactions. These main problems led to the occurrence of more problems like slow transaction time, product shortage, product overstocking leading to product spoilage, the loss of data integrity, data redundancy, and the occurrence of inaccurate information due to manual transactions to record the refunded items, and an overall inefficient and ineffective system. This paper proposes a software design for an automated point-of-sale and inventory management system that aims to reduce the amount of data redundancy and the loss of data integrity within the system in order to attain a better business process. The development of a prototype that encompasses solutions to solve the aforementioned problems was used to validate the design and initial results showed that the client supports the relevance of the design.