Preview

Thesis

Powerful Essays
Open Document
Open Document
597 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Thesis
SUMMARY, CONCLUSION AND RECOMMENDATION

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.

You May Also Find These Documents Helpful

  • Powerful Essays

    Fredrick, J. (2002, 21 October 2002). AIMing to match supply and demand - Distribution - CVS is using a new data-driven inventory management system. Retrieved 8 October 2005, http://www.findarticles.com/p/articles/mi_m3374/is_14_24/ai_93371107…

    • 2171 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    SQL vs. Oracle

    • 954 Words
    • 3 Pages

    Same to Oracle, Structured Query Language (SQL) is a special purpose designated programming language intended for utilization in managing data contained in relational databases. Despite the similarities, the two programming languages are different in a number of ways, which encompasses technical and application aspects. A conspicuous dissimilarity between the two programming languages is conceivable from their choices of operating system (OS) platforms. In regards to this statement, SQL is restricted to run on Microsoft Windows OSs unlike Oracle, which runs on nearly all types of OSs, Microsoft Windows OS included (Sanjay and Alan 98). Bearing in mind that Microsoft Windows OSS are prone to crashes, it follows that SQL is less advantageous for enterprise applications than Oracle. This is mainly informed by the truth that Oracle is significantly stable where any variant of Unix or Linux operating systems.…

    • 954 Words
    • 3 Pages
    Better Essays
  • Better Essays

    Oracle Database 11 G

    • 1761 Words
    • 8 Pages

    Coronel, C., Morris, S. & Rob, P. (2010). Database Systems: Design, Implementation and Management (9th ed.).…

    • 1761 Words
    • 8 Pages
    Better Essays
  • Powerful Essays

    this

    • 2464 Words
    • 11 Pages

    Today, computer has become a part of life. It is evident that most of the country’s institutions still do not use the high technology. Particularly in auto supplies, daily transactions, inventories and record of sales are still done on paper. People know that modern auto supplies are now operating at great pace striving to serve as many customers as possible with the best of their abilities. But as the years goes by, the number of customers has grown and various cases arise that the manual method of managing customers’ transactions, inventories and updating sales, is no longer practical. In this study, researchers hope to develop a system that will minimize all works of manual methods, therefore allowing owners ease in updating inventory - a system that is fully automated, user-friendly, time effective and…

    • 2464 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    Our proposed system will enable their one personal computer to be used not just P.O.S but also as inventory. The proposed system Point of Sales with Inventory System…

    • 335 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Ch2 Draft

    • 422 Words
    • 2 Pages

    Under the Korean Red Ginseng Enterprise Sales and Inventory System, the researcher came up with a computerized inventory system. The proponents used database for easy access of files and for easier and faster processing of the inventory. The system also helped the user to know the availability of the products. It also helped the manager to monitor the stocks and to get immediate notice for acquisition of additional products.…

    • 422 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Recently, database management systems (DBMSs) have become a main component of various kinds of dynamic web and applications. In these DBMSs, there might be stored some significant, sensitive and classified data. The developments of theory and technology in databases have become urgent needs for achieving database system security. Currently there are many DBMSs for users to choose. Therefore it becomes an important issue for people to decide how to choose a suitable database system. This thesis researches some mainstream database systems to compare their security performances, structures, security strategies.…

    • 12325 Words
    • 50 Pages
    Powerful Essays
  • Satisfactory Essays

    Specific Objectives

    • 546 Words
    • 3 Pages

    We’ve decided to provide a LAN-Based Sales and Inventory System to improve their transaction procedures faster and easier, and to monitor their inventory and sales regularly, These include valuing the inventory, measuring the change in inventory and planning for future inventory levels. It also includes monitoring of critical levels to avoid either having too much or too little inventory on hand. It will also monitor returned goods by the customer. Measuring the change in inventory allows the company to determine the cost of inventory sold during the period. The system will also include updating of supplier, inventory, and sales records, like adding, deleting, and editing. It will automatically compute and record the daily, weekly, monthly and the annual…

    • 546 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Wink has already disposed numerous printers to various corporate and individual customers. Wink PS has also serviced the printers of various individuals and businesses from inkjets to multi-functions.…

    • 912 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    inventory system

    • 2396 Words
    • 12 Pages

    The main objectives of the study are to create an inventory system that could help the company increase their sales. Project aims to develop a web where the stock and sales record of company is stored. This system will help the company to record and…

    • 2396 Words
    • 12 Pages
    Better Essays
  • Good Essays

    Documentation

    • 556 Words
    • 3 Pages

    Every year, the demand for the computer based systems for the businesses just keeps on growing. Manual Inventory and Payroll System involves all concerns within its transactions, on how the staff would be able to maintain the current status of their inventory, whether adding, deleting, and ordering a stock and how the management can monitor the performance of their employee’s, the manual process consumes too much time for the staff and rigid time to process a transaction. Companies have improved their old system…

    • 556 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The review of the literature for this study focuses on creating computerize inventory system and order system from Cavite State University Marketing Main Campus. Review of related literature is one of the requirements need In order to create the proposed system; we need to find some helpful resources fort the study.…

    • 545 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    The Sales and Inventory System is concern with the processing of the transactions of the customers and owner and saving the sales records at the same time. These saved records area filed and stored for future use. This computerized system is important to a company because through it, the owner can easily assist the customers and store data safely. And also the monitoring of stocks is the most important part of this system.…

    • 947 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Sales and Inventory systems maintain information about activities within firms that ensure the delivery of products to customers. The subsystems that perform these functions include sales, manufacturing, warehousing, ordering, and receiving. In different firms the activities associated with each of these areas may not be strictly contained within separate subsystems, but these functions must be performed in sequence in order to have…

    • 2018 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    The purpose of this project is to check and track inventory sales, orders and deliveries. The researchers aim to help in improving the Penshoppe’s Inventory system by fitting solutions to the problems…

    • 856 Words
    • 3 Pages
    Good Essays