Abstract The purpose of this study is to apply a MySQL database-equipped inventory system to a sample cellphone retail store where it would manage the store’s product inventory and improve the physical-writing of daily/monthly inventory reports for them to examine. It will be a process integration where we will install a computer system to help them generate an inventory report that they’ll just have to input certain data and the system would provide them of a formatted document.
We haven’t actually produced any results yet since we are starting to process the system’s requirements and interface of a cellphone store and thus, this section of the abstract would be improve until the important data for this report is already obtained. II. Acknowledgements We would like to acknowledge the help of our Software Engineering course professor, Mr. Rolando Fajardo, for motivating us to strive hard and gave us the necessary sample materials to complete and further understand the completion of this documentation of our project.
We would also like to acknowledge the help and support that we got from our fellow colleagues here at Far Eastern University – Makati for the guidance and certain help they gave us while conducting and making this documentation III. Dedication We dedicate this documentation for all our batch mates and our fellow Information Technology students here at Far Eastern University – Makati as this documentation may inspire them to strive hard and further improve their skills as the future’s next leading programmers, designers and all other types of workers in the field of Information Technology.
The Essay on Sales and inventory documentation
Background of the study Computers have become a requirement in the business industry it easily completes duties that are tedious and timely foe humans. The business uses of computer are extensive. Although many of the computer duties are not irreplaceable, business has become dependent on their accuracy and timeliness. Many businesses use accounting software to ensure the accuracy of their ...
Introduction
While it is somehow proven that physically-written reports are mostly fool-proof evidence of a legitimate or official document in certain businesses, it really takes too much time and effort for people to actually write these kinds of reports for their business. With a generation that mostly relies on technology nowadays, we do not consider anymore this kind of process of making it and now depending on computer to make one for us with just simply placing data in a certain program that would generate a well-designed report to be examined by people. Background of the Study
In our technology-dependent generation right now, it is easy to say that written documents are already out of style right now since some computer applications or software are now integrated to analyse, formulate and produce documents that are well-formatted and well-designed by these programs. Our MySQL database-equipped cellphone inventory system would integrate the usual paper-recording of product inventory in certain store in which, we will apply this for a cellphone inventory store that usually updates their inventory for their stock availability, products sold and stock left in their store.
We will integrate their system of updating it through a software inventory system that’s powered by a MySQL database to ease the burden of writing/recording and making an inventory report for daily or monthly sales report for their store. Research Paradigm Input Process Output New Product/Item (Details) Adding of New Item in Inventory (w/ Details) Report that a new item was added New Stock for Products Updating Inventory for new stock (Stock column) Report that stock column has been updated with new stock quantity Edit details of product Editing Inventory for details of a product Report that product details has been edited
Delete product from Inventory Removal of Item/Product from Inventory Report that product has been removed from inventory Daily Sales Data Processing of store’s transactions Written/Formatted Report of Daily Sales Monthly Sales Data Processing of store’s transactions (w/in the whole month) Written/Formatted Report of store’s Monthly Sales Statement of the Problem The focus of this study is whether an inventory system equipped with a MySQL database would work for a cellphone store storing, updating, and deleting their products and its details for easy-completion of their store inventory.
The Research paper on Wal Mart Internet Inventory Store
WAL-MART. COM: A Case Study in Managing Technical Transitions Managing Technical Transitions Prof. Michael Lawless February 24, 2001 Prepared by: Andrew Bender Ann Howell Amy Lavin David TorgersonFounded in 1962 by Sam Walton, Wal-Mart followed an amazing pattern of success and growth, eclipsing all other U. S. department store retailers by the early 1990's. In early spring 2001, Wal-Mart enjoyed ...
Significance of the Study We are motivated to pursue this study because of the application of an inventory system equipped with MySQL database for a cellphone store to integrate their store’s inventory system and to ease the paperwork usually needed to record the all of the products that go to their inventory Scope and Delimitation The scope of this study covers the adding, updating/editing, removing and other necessary tasks that a cellphone retail store does for their inventory management.
This system integrates the written documents that were usually used before in writing an inventory report of their products and additional details that is necessary for it. The delimitation of this system is that it only covers the basic inventory process that these stores need for their inventory management. Additional features would be optional since our system would only be focusing on the main inventory process of the business. Added features are expected not to work efficiently or perfectly as of this moment since we are just integrating the basic functions of their inventory process. Definition of Terms
Inventory – an itemized list of current assets: as a catalogue of the property of an individual or estate or a list of goods on hand Inventory Management – is vitally important for any business that sells a physical product. Cellular phone/Cellphone – portable phone: a portable telephone operated through a cellular radio network Database – collection of data on computer: a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated MySQL – MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).
The Term Paper on Sales and Inventory Monitoring system
... -the performance or management of business operations REVIEW OF RELATED LITERATURE AND STUDIES A sales and inventory monitoring system collects data to aid in production ... online Sales and Inventory Management System (SIMS) for a departmental store. This system can be used to store the details of the inventory, update the inventory based on ...
VI. Chapter 2 REVIEW OF RELATED LITERATURE AND STUDIES Foreign Literature(both should be from 2009-2014) Foreign Studies Local Literature Local Studies VII. Chapter 3 RESEARCH METHODOLOGY Specification of Research Design Respondents of the Study Research Instrument Data-Gathering Procedure/Source of Data VIII. Chapter 4 SUMMARY, CONCLUSIONS AND RECOMMENDATIONS Summary of FindingsConclusionsRecommendations Further for Further Studies BIBLIOGRAPHY APPENDICES Letter of Request for Permission to Conduct Survey Questionnaire Curriculum Vitae USER’s MANUAL ( separate document)
