Barns Hardware is one of the hardware stores in Rodriguez Racial that offers good quality of construction supplies for home and other infrastructures. Its satisfactory services in terms of delivering of products also add to the continuous improvement of the store. Thus, Barns hardware now has seven other branches serving Barongs San Sister and San Jose.
In San Sister, there are four branches particularly in Anemia, Southfield B, and Harridan. The fourth branch located in Double L has a different name Zen Store but is still a part of Barns Hardware. While in San Jose there are three branches, two in Glaswegian Village and one in Sub-urban. Its main outlet is located in Centerline Subdivision, San Sister. The propose system for the Barns Hardware enables the store to transact different areas of business easily. It gives the hardware store a more convenient and well organized inventory of items.
The propose system also has added features such as Point of Sales, Accounting, and Product Finder which contribute to the improved nationalities of the entire system. The propose system will include the following subsystems: Point of Sales This subsystem will be used by the cashier who is in-charge in payment transactions. Unlike the manual issuing of receipts, the cashier can do it in the system by typing the product’s name or by looking first for its information stored in the database and add it to the list.
All the items in the list will be computed its total price as well as the change if ever the customer pays the amount more than the total price. The system can also print a receipt and store the information in the database n case there are other transactions that will happen such as the returning of items. In this part, the cashier will search for the receipt number. If the receipt number is found, all its information about the transactions including the quantity of items bought, the date and time purchased, and the total price of the items will be displayed.
Accounting The entire information about the monetary transactions in all the items are gathered and processed in this subsystem. This includes the transactions being done in Point of Sales, the purchasing and returning of the items, the discounts, taxes, credits, debts, etc. The financial details of the items sold and recorded in the Point of Sales will go to this system to be collected and computed for the total sales in a day. It also includes a report module that provides intimation regarding this subject.
Product Finder This added feature is provided for the customers in which its main function is to display the item’s information. Once the customer enters the product’s name in the search area and the system finds all the related products needed by the customer, it will display the item’s price, product code, its availability and other necessary information. The customer can also print out the item’s details by adding the chosen products to list and clicking the print button. The print out information contains the customer’s name, contact number and address, and the products details.
Reasons for the choice of the project: Although Barns Hardware uses computerized transactions, these don’t meet the required standards for its business needs due to lack of functions that can be performed by its system. Some of the reasons why the proponents have to develop a system are stated below: 1. To ensure that the security in accessing the system will be more efficient. . The recording of product sales and other financial transactions should be well organized and much easier. 3.
To avoid redundancy of information that usually happens in manual procedures. 4. The customer should see all the available products in the system instead of verbal inquiries through the Product Finder. 5. To make the maintenance easy by monitoring the available items. Importance of the study: The proponents decide to propose a Sales and Inventory System of Barns Hardware due to the fact that it could help a lot in the business especially for the administrator, employees, and customers.
Compared to its manual business operation, the propose system will overcome this problem by providing useful and powerful features with a user-friendly environment. For the administrator, the propose system will be beneficial in terms of managing the whole business. The employees will also be able to reduce time and efforts especially in the aspects of managing sales and inventory. The propose system extends its functionalities to the customer’s need because it gives the accurate information about the products.
Target Users/Beneficiaries: The propose Sales and Inventory System of Barns Hardware will give the company an improved processing of business transactions. The administrator and the employees can manage the sales and inventory efficiently. The user will also benefit the system through Product Finder when looking for the products needed. Similarities with any previous studies: The propose Sales and Inventory System to Barns Hardware is similar wit n the other inventory systems when it comes to its functionalities.
It also has the capability to monitor available items, store records of purchased and sold products, print reports for the analysis of the management, perform computations of financial transactions, and display product information whenever the customer needs it. Software Development Tools to be used: The proponents will use Visual Basic 6. 0 as the system’s front-end software because of its easy-to-use environment and familiarities of the tools used. Camp will be used as a web server solution stack package in which one of its contents is Myself, an open source relational database that is free, fast, and reliable.
