Many people use computers in their daily lives. Some use it for transactions, some use it for educational purposes and others use it for data storage. Though it might sound unnecessary but in some cases when storing a file for such a big company, can you manage it properly? Organizing, finding a file, etc. With computers, it can help you simplify the process of storing and managing the files you need for future use and make finding files easier than the manual process. Computerized Sales and Inventory System is a product of human knowledge with a use of technology so why not use technology as an advantage and benefit ourselves. This proposed system aims to lighten works and solve the problems involving strict and complex recording and calculations. Anthony’s General Merchandise & Construction Supply is still under the manual method since the business started back in April 2000. The business is located first at Riverside then they transferred to Road BHS near Quezon City Polytechnic University. It is a family owned business by Mrs. Herminia Baguino. They have 1 cashier, 3 sales persons, 2 drivers, 4 delivery men, 1 staff that is in charge of the warehouse. The cashier is the person who keeps the money in their money box, the sales person are those who talks to the customers and responsible in providing the customers’ needs. The driver and delivery men are those workers who are responsible for the delivery of the items to the customers.
1.1 Statement of the Problem
How to Design and Develop a Computerized Sales and Inventory System for Anthony’s General Merchandise and Construction Supply that will improve their business operation? Anthony’s General Merchandise and Construction Supply is working under manual method which sometimes causes customer dissatisfaction because of the slow process on how they transact to their customers and the occurrence of some errors that are not expected. With this manual method, the person in charge of inventory is having a hard time because he needs to check the items repeatedly and they don’t even monitor the expiration of the items and they also experienced loss of important records. Specific Problem:
* How to design and develop a module that will monitor the items accurately in re-order and critical level?
Anthony’s General Merchandise & Construction Supply encountered difficulties in monitoring items that are in re-order level and critical level, items that need to be replenished. This sometimes results in some items to be out of stocks. In their current system they don’t have critical level and re-order level because they just do it by looking at their display shelves to estimate the number of items that needs to be purchased from their suppliers.
* How to design and develop a module that will generate a purchase order? Anthony’s General Merchandise & Construction Supply encountered difficulties in making a purchase list because they made their purchase order through estimations. That there are some instances where some items are doubled, and important items that is needed to be purchased are not included, then the manager will write it on a piece of paper. This affects the operation of their business because of the erroneous estimation of their inventory. * How to design and develop a module that will enhance the manual computation of the amount purchased and then issues an official receipt? Anthony’s General Merchandise & Construction Supply use calculator, pen and paper to compute the total amount of items that the customer purchased. In processing the sales transaction they need to calculate twice to recheck if the total is accurate and everything has to be written resulting to a long queue. Because of their current written process, it may result in difficulty in calculating the sales transaction undertakes in their business. The waiting time for a customer is too long which may also result in less...