An inventory system is a method that businesses use to track and manage their available goods and materials. Manual counting at the end of each day allows for monitoring incoming goods and sold items, but this approach is only suitable for small businesses with limited stock. Larger businesses usually need computerized systems like transaction processing systems to efficiently operate and manage their inventory.
The advent of computers has transformed manual transactions into digital ones, including inventory management. Manual inventory systems were found to be inefficient and prone to errors, leading to issues such as stock shortages and slow calculations of product prices. The ability to effectively control merchandise inventory has a significant impact on the success of a business. With the constant advancements and enhancements in computer technology, managing business transactions has become more efficient and convenient.
Presently, businesses rely on computers for managing and monitoring different aspects of their operations. This transition from manual data processing is essential because of the growing number of transactions. The investigation centers around Lagamayo Telecoms, a retail company that specializes in telecom and media trading. Mary Guillan B. Lagamayo established this firm almost ten years ago after recognizing the increasing popularity of cell phones among Filipinos in the late 1990s when mobile phone service was still in its early stages within the Philippines.
Customers were queuing at cell phone kiosks to acquire the latest handsets. It was during this time that she became aware of the telecom trading business’s emergence as the “next big thing” in the industry. With this realization, Lagamayo Telecoms was established in February of 2001 as a single-proprietorship firm under her name. The first store, which had a kiosk-type setup, opened on the ground floor of Alabang Metropolis in Muntinlupa. Since then, the business has witnessed significant expansion, with 13 stores and a workforce of 50 individuals spread across the Bicol Region and Cavite.
The company’s main issue with its current manual system is the difficulty in monitoring stocks from each branch due to slow transaction processes. Daily reports are not precise because of the manual processing of a large volume of data, which is time-consuming and labor-intensive. This study aims to address these problems by implementing an Inventory System with Point of Sale. This system will reduce the time and effort required for retrieving information and will also enable the monitoring of stocks and the reordering of products to prevent stockouts.
The point of sale system is convenient for businesses as it minimizes transaction processing time with automatic price computation. It generates accurate reports quickly for decision making. With the evolution of computers, I. T. innovation has transformed every aspect of human life development. Many businesses have thrived and expanded using sophisticated computer applications. Communications have become more convenient, fast, and in real time. The proponents will be utilizing a barcode reader.
The scanner is connected to a computer with software that records the transactions. The proponents will use Visual Basic.Net as the programming language to develop the software and MySQL for the database. The decision to develop this system was based on the numerous benefits it would provide, making the company more effective in their business operations. This system allows for easy monitoring and maintenance of stocks, speeding up and accurately recording store transactions, thus easing the work of employees. Additionally, it reduces errors and simplifies price updates.
Additionally, the system will generate comprehensive reports on current and past transactions, facilitating informed decision-making. This study aims to assist Lagamayo Telecoms in staying technologically advanced and globally competitive. The objectives of the study are divided into two categories: general and specific objectives. The general objective is to create an Inventory System with Point of Sale for Lagamayo Telecoms, enhancing the efficiency and accuracy of their operations.
The study aims to achieve the following specific objectives: 1. Analyzing the stock monitoring, transaction processing, and data inventory recording of the manual system. 2. Identifying issues faced by the manual inventory system. 3. Creating a computerized inventory system with a point of sale to address the identified problems. 4. Assessing the technological, economic, and operational feasibility of implementing the inventory system with a point of sale.
The proponents assume that Lagamayo Telecoms currently operates manually by manually counting and checking the entry and purchase of stocks during inventory. Another assumption is that the problems encountered with this manual process are time-consuming, error-prone, and sometimes result in lost records and inaccurate data recording. Lastly, it is assumed that the proposed system will be quicker and more accurate in performing these tasks and will provide organized summary reports to fulfill the growing needs of the business.
And finally, it is affirmed that the suggested system is viable for implementation from a technical, operational, and economic standpoint. The scope of the study outlines what will be covered, while the delimitation indicates the limitations of the system. The proposed system is a management software that can present and print the company’s stocks, sales invoices, and sales reports. One notable feature of the system is its inclusion of a barcode reader, which aids in automatic data input by scanning item barcodes.
Updating of records, such as adding and editing, is permitted. However, the proposed system does not replace the manual process of receiving stocks and counter checking. To maintain security and integrity, a certain level of access control is implemented for qualified personnel. The study is significant due to the time-consuming and error-prone nature of manual record keeping in inventory tasks. In contrast, computers are well-suited for this task.
The proponents propose computerizing the manual inventory of Lagamayo Telecoms. This will benefit all those involved in the business as it will make transaction and operational processes faster, easier, and more accurate. The system will provide information about product availability, facilitate storage and retrieval of data, and enable quick and accurate financial computations. The owner/proprietor will particularly benefit from this study as it will help the company produce a more reliable and accurate sales inventory to support its operations.
This system aims to assist the owner in monitoring losses, theft, and anomalies within the company. Such monitoring will benefit both employees and proponents. Employees will experience a decrease in their workload as updating and counting the company’s inventory becomes easier for them. Furthermore, proponents can apply the knowledge acquired during their course, thereby improving their writing and programming skills.
This study will serve as a valuable resource for future researchers conducting similar studies, offering insights on what to include or exclude from prior research to enhance the usefulness of their own work. The “Definition of Terms” section provides an overview and comprehension of the discussion by explaining key terminologies. For example, a barcode is defined as a sequence of numbers and vertical lines used to identify an item and often its price when scanned with a barcode scanner.
Barcode Reader is an optical scanner used for scanning barcodes. Inventory is a comprehensive list of current goods, materials, or properties. Manpower represents the number of people working or available for work or service. Merchandise refers to the goods intended for purchase and sale. Password is a combination of characters that grants access to a computer system. Point of Sale (POS) System is a computerized network managed by a main computer and linked to multiple checkout terminals. Lastly, Sales Invoice typically denotes the document that documents a sales transaction.
The document is a record of the sale of goods or services from a vendor to a customer. Conversely, software encompasses different programs that operate computers and related devices. A system refers to a collection of hardware units or programs, or both, specifically dedicated to one application. In basic terms, a transaction is an agreement between a buyer and seller to exchange an asset for payment. Finally, a username serves as identification when logging onto a computer, in chat rooms, or as part of an email address.
