Summary
Because Lots A Pizza Bayan, Dasmariñas City is having difficulty using the manual process of their inventory and sales the researchers used this opportunity to develop a LAN-based inventory and sales management system for them. It minimized the manual task and maximized the employees’ time on doing their work because it lessens the time on generating sales and inventory summaries and reports. The researchers used NetBeans 7.1.1 Java SE as programming language and MySQL 5.1 command line client as database server. They started the development of the system on November 2011 and finished on January 2013.
Conclusion
The new system minimizes the time needed in managing and monitoring of inventory and sales of the business and it lessens the time and difficulty in generating reports. Based on the evaluation , the system got a mean 4.40 that proved to be very satisfactory and the system helps the employees to manage inventories and notify them that if there are critical stocks in the inventory. The system minimizes the effort in monitoring of sales performance and checking of inventory status. Delivery transactions are being organized and queued according to their date of transaction with the aid of the system. Advance delivery orders are accommodated by the system in proper queue and the system notify the user if there are advance orders. The system provides reports for sales performance. The system proved to be very satisfactory to the user based on the evaluation; therefore the system meet all the objectives and minimized the manual work of Lots a Pizza Dasmariñas, Bayan.
Recommendation
The system can be more productive if the following will be included: 1. improve the user interface design of the system. by using different buttons and pictures or animation; and 2. make the system compatible to all operating systems such as Windows, Mac and Linux; and 3. make the system capable of
Cited: Bulusu, L. (2008). ORACLE PL/SQL: Expert techniques for developers and database administrators. CengageLearning Technologies Publishing, United States of America. Coleman, M. and Constantinescu R. (2009). The Model: life cycle process model. Retrieved on November 20, 2012 from books.google.com./books/ V_model_engineering_process.html Dela Cruz, V Domingo, A. S. Mercado N. M. P. and Nati, K. X. N. (2002). SJI Mart sales and inventory system. Unpublished Special Problem. DLSU-Dasmariñas. Genesis, M. F. and Gloria,A. L. (2000). Sales and Inventory System for Jolington Seattle Enterprise (JSE), Unpublished Special Problem. De La Salle University Dasmariñas, Cavite. Malik, D. S. (2006). JAVA programming from problem analysis, course technology. Megria, V. G. Naria, J. B.and Villalobos,J. L. (2002). The development of an automated sales and inventory system for Iglesia Shell Service Station. Unpublished Special Problem. De La Salle University-Dasmariñas City, Cavite. Natividad, B. S. M. and Sarao, S. P. (2000). Inventory system of oskies garments. Savitch, J. (2004). Java programming introduction. Prentice Hall Ltd, Upper Saddle River New Jersey. Silberschatz, A. and Forth H. F. (2006). Database systems design and concepts. McGraw Hill Companies Inc., United States of America. Tucker, R. B. and Noona, A. B. (2007). Programming languages principles and paradigms. Manning Publications Inc. United States of America. Watson, R. T. (2006). Data management, database and organizations. John, Wiley & Sons Inc, United States of America.