Download Inventory System for Laundry Shops and more Study Guides, Projects, Research System Analysis and Design in PDF only on Docsity!
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 Inventory Management System Using VB.NET Programming Language For Labada Express Biñan A System Analysis and Design Proposal Presented to Faculty of the College of Engineering University of Perpetual Help System Laguna In Partial Fulfillment Of the Requirements for the Degree Bachelor of Science in Computer Engineering by: Sigue, Bryant Exel G. Refugio, Judy Ann A. Reyes, John Russel D. Under the supervision of Engr. Kierven R. De Mesa, MSME March 201 Chapter 1
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 The Problem and Its Setting Introduction Inventories is basically the total amount of goods and materials held in stock by the establishment. Inventories are essential for keeping the production wheels moving, keep the market going and the distribution system intact. Theses inventories allow additional flexibility for suppliers in planning, producing and delivering an order for a given product’s part, Loner (2003). The concept of inventory, stock or work-in-process has been extended from manufacturing systems to service businesses and projects, by generalizing the definition to be "all work within the process of production- all work that is or has occurred prior to the completion of production." In the context of a manufacturing production system, inventory refers to all work that has occurred – raw materials, partially finished products, finished products prior to sale and departure from the manufacturing system. In the context of services, inventory refers to all work done prior to sale, including partially process information. Inventory management is a discipline primarily about specifying the shape and placement of stocked goods. It is required at different location within a facility or within many locations of a supply network to precede the regular and planned course of production and stock of materials. The scope of inventory management concerns the balance between replenishment lead time, carrying costs of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, future inventory price
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 Fig. 1. The Conceptual Model of the Study Figure 1 shows the conceptual model of the study that represents the major components of the system. The automated inventory system will be composed of a database system wherein the data of the items will be stored, and this will be used by the staffs to view the availability of each items. This will serve as the visualization that will provide an accessible and readily format that will help the staff to easily understand the automated inventory system. Operational Model
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 Fig. 2. The Operational Model of the Study. Fig.2 illustrates the operational model of the study that will represent the different variable that provides the guidelines that could affect the process of the developing system. The VB .NET will be independent variables because the user could have the capability to control the entire system. The intervening variables such as user intervention and the storage capacity could affect the output data of the developing system. Statement of the Problem Minimizing time consumption. System Accuracy and Reliability.
VB .NET
User Intervention Storage Capacity
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 Visual Basic .NET can produce different automated system depending on the user’s application. The researchers will use VB.NET because it is very easy to use and to create a program. Through this, the users will save time in checking the available stock for each item. MySQL will be used by the researchers as the database of the system wherein the data will be stored and modified. Scope and Delimination This study will be focusing in developing an automated inventory system for the staff or admins in Labada Express located at Biñan, Laguna. The data will be provided by the admins of the said shop. This study will be limited in monitoring the current stock of the items, it is also limited in updating the saved data in the database. The allotted storage cannot be expanded automatically by the administrators. The data will be inputted and adjusted manually by the staff in order to have an updated inventory system. Significance of the Study This study will mainly benefit the business industry as well as the customers since the proposed system will be automatically show the availability of each item using Visual Basic .NET and MySQL as the database. Addition to this, the proposed system can produce short waiting queuing process that will be more beneficial to the customers. Through this, the sales of the laundry business could increase because it provides a reliable and fast service. Also, the business owners will easily monitor lack of supply or availability of the products, this will prevent shortage of items in the future.
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 This study will also help researchers to apply the knowledge that they have learned in their bachelor’s degree which is the Computer Engineering program. This study can also be use by the future researchers as a reference about Automated Inventory System and obtain information which is necessary for the future enhancement of this study. Definition of Terms The following terms were defined contextually and operationally for a better understanding to this study: Inventory. is the term for the goods available for sale and raw materials used to produce goods available for sale. Inventory represents one of the most important assets of a business because the turnover of inventory represents one of the primary sources of revenue generation and subsequent earnings for the company's shareholders. Visual Basic .NET. VB.NET is a programming language designed to create applications that work with Microsoft’s new .NET Framework. MySQL. is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 Inventory System Treerrattrakoon, & Lersbuasin (2015) stated that they designed to proposal of the inventory management system to record inventory, inventory shortage warning, current inventory status and plus estimating raw material input. The inventory management system project is developed to be easy use and applicable for motorcycle part manufacturer. Altogether inventory records have been useful to estimate raw material input implement the inventory management system, regulate raw material reorganize point and production schedule, and approximation cost for individually product. Likewise, Anastasios (2018) inventory management system is well thought-out to be the set of guidelines and controls that regulate the level of inventories, when they had better be replenished and how large orders should be. A well-organized inventory management system saves properties for the business by minimizing its costs. A basic reason for which a company preserves inventories is the mismatch between stock and demand due to uncertainty. According to Juneja (2014) states that Inventory is continually dynamic, inventory management necessitates constant and careful assessment of external and internal factors and control concluded development and review. Most of the organizations have a detached department or job function called inventory planners who uninterruptedly monitor, control and review inventory and interface with production, obtaining and finance departments.
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 This study investigates the impact of a warehouse management system on supply sequence performance that offers less resources effort, additional efficient, and dependable inventory management system. The supply sequence procedures carried out in the warehouse were studied before customizing a software that can handle the needed transactions. The software was tested for augmenting the work flow and providing a timely and efficient handling (Atieh, et al. 2014). An inventory system is a set of hardware and software based tools that automate the process of tracking inventory. The kinds of inventory tracked with an inventory system can include almost any type of quantifiable good, including food, clothing, books, equipment, and any other item that consumers, retailers, or wholesalers may purchase. It also employed in a wide variety of applications, but they all revolve around tracking delivery of goods to customers. It is crucial in retail stores, especially those with a large number or variety of merchandise items for sale. Inventory System is also used in warehouses to track orders and shipments, and for automated order processing (Barcodes, 2018). According to the article of (Robert Lockard, 2018), They tackle the different cause of using inventory system. First is to stop the products from spoiling, If you have too many products in your warehouse, you increase the risk that they will become obsolete, damaged, spoiled or stolen before you can sell them all. Depending on which industry you’re in, you’re probably more worried about some of these risks than others. For example, if you’re in the technology industry, you don’t want your expensive products to become outdated, damaged or stolen, but you probably don’t care about their freshness date. Food producers, on the other hand, put product
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 having a powerful inventory management system to free up your time and do most of the data analysis for you. According to the article of (Kimberlee Leonard, 2018), Any business that sells products needs a reliable method for inventory management. With bar codes, point- of-sale software and warehouse tracking, computerized inventory management systems make it easy for businesses to stay updated consistently. As with any new system implementation, business owners should consider the advantages and disadvantages of using a computerized inventory system. According to Fernandez (2015), Inventory Management System is a web- based application system that connects the system into a web server and a database server. This system is very important for companies or stores in managing the inventory for many different kinds of business in the industries these past few years. Retrieval of Information Harvey Hyman et. al. (2015) states that researchers take a fresh look at the information retrieval (IR) problem of balancing recall with exactness in electronic document extraction. IR constructs of uncertainty, context and relevance, proposing a new process model for context learning, and introducing a new IT artifact designed to support user driven learning by investing explicit knowledge to discover implicit knowledge within a collection of documents. The IT artifact is a prototype designed to present a small set of extracted documents from a targeted collection based upon user inputted criteria. The prototype provides the user with the chance to balance exploration and exploitation, via iterative relevance feedback to address the problem of inexactness resulting
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 from uncertainty. The researcher model the problem as an exploration– exploitation dilemma and use it to a particular case of IR called eDiscovery. According to Dumais et. al. (2015) most data retrieval technologies are designed to facilitate data discovery. However, much knowledge work involves finding and re-using previously seen data. Stuff I've Seen (SIS) is describes as the design and evaluation of a system, called that facilitates data re-use. This is accomplished in two ways. First, the system provides a unified index of data that a person has seen, whether it was seen as email, web page, document, appointment, etc. Second, because the data has been seen before, contextual cues can be used in the search interface. Zhu, Yan & Song (2017) states with the ever-increasing amount of scientific literature, there is a need for a natural language interface to list information retrieval systems to retrieve relevant information effectively. The researcher propose one such interface, NLI-GIBIR, which allows users to search for a variety of list data through natural language. NLI-GIBIR makes use of a novel framework applicable to graph-based list information retrieval systems in general. This framework incorporates algorithms for interpreting and analyzing natural language list queries via a series of text- and linguistic- based techniques, including tokenization, named entity recognition, and syntactic analysis. The researcher discover that the framework, as implemented in NLI-GIBIR, can effectively represent and address complex list information needs. According to Bookwalter, et. al. (2017) stated that it is especially suited to supporting the Data & Quality Management Systems for huge projects like LCLS-
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 well as large vocabularies such as the UMLS has greatly facilitated the work of IR researchers in devising and testing scalable approaches that can positively impact the work of the laboratory researcher. Moon Soo Cha (2015) stated that the continuing growth of information overflow has made it hard to obtain valuable information on the web. In this trend, the need for effective Information Retrieval (IR) technique has been increased. Although document data contain much more abundant information, users can retrieve necessary information only from the title and description in conventional web services. In order to meet the demands for fast and accurate retrieval of valuable information, they propose a fast and effective content-based document information retrieval system that retrieves the information from the actual content of a document. The proposed method is based on a topic model of Latent Dirichlet Allocation that is used to extract major keywords for a given document. The main contributions of this system are the increased flexibility, effectiveness, and fast retrieval of information. It also can easily communicate with existing web service through the standard JSON format. According to Khari & Jain (2016) the information retrieval is an automated way of extracting the information from various sources. It has always been a key area of research due to its wide range of applications in document searching, software traceability etc. They presented an analysis of the three basic models of information retrieval i.e. Vector Space Model, Latent Dirichlet Allocation Model and Latent Semantic Indexing Model in this paper. These models are explained in detail according to their basic concepts, methodology
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 adopted and area of application. They have provided the advantages of these topic models over each other and have discussed their limitations too. The variants of some basic models are also described according to their concept and usage. This kind of analysis will be useful for the user to make a choice between these information retrieval models as to find out which one is to be used regarding a particular problem or application. Data And Information Ugorji (2006), Dimoji (2005) and Okafor (2009) are at the view that data and information are terms people use interchangeably in everyday speech, but they mean different thing. Data are facts such as a Name, a Number etc while the term information is simply a processed data, that is when data is converted into a more useful or intelligent form. A data item e.g.(the data 28/06/2011) means title, when you associate the data item such as deadline and a subject, you can create information. Example, the deadline for your next project might be 28/06/2011. you store data in a database, you retrieve information from the database. One cornerstone of data design and data normalization is that data organization for storage differs from the information most people want to see. Example: a manager of a sporting goods supply company might want to see for one scale who the customer was, the destination of the order, the billing address, the contact phone number, the placement time of the order, the order’s shipping destination when and how delivery occurred, what article the order included and which of the company’s database differs from the particular information the man
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 According to Brea Olinda (2003), Visual Basic is an elective course designed for students interested in creating new software applications. Visual Basic programming is a basic object-oriented programming environment that includes many of the elements of the C++ and Java languages and is used to create powerful, attractive graphical user interfaces (GUI’s). Synthesis of the State of the Art Treerrattrakoon, & Lersbuasin (2015) and Anastasios (2018) define inventory system is to record inventory to be the set of guidelines and controls that regulate the level of inventories, current inventory status and additional estimating raw materials input. Atieh, et al. (2014) states also the impact of a warehouse management system on supply sequence performance that offers less resources effort, additional efficient, and dependable inventory management system. In spite of the circumstance that the unfulfilled customer expectation of laundry services which resulted in customer disappointed. With the help of Dobashi (2016); Sharif and Bahammam (2013) and Deochand, et al. 2015) that using VB .NET describes the data which provide understanding which facilitates the identification of areas whether through a presentation of graphs or numbers and which the analysis of information and for the further research. The researchers’ main purpose is to benefit the sales staff, admin/owner and customers who use manual to look for a stock available in their shop. Using this proposed study, it could be a way of a fast and precise to look for an
Laguna
Sto. Niño, City of Biñan, Laguna
College of Engineering, Aviation &
Architecture
(+632) 520-8290 local 3006/ (+63) 9228900917 availability of the product and good environment for the both sales staff and customer. Also, it will help small scale laundry shops and other businesses by providing them an advanced and fast process of an inventory system. Lastly, the validity of the product and the list time consuming. Gaps Bridged by the Present Study Based on the related literatures and studies cited above, the researchers identified the gaps as there were no other studies made utilizing Labada Express Biñan explained by the detail that the absence of customer satisfaction from Labada Express out the gap appeared between awareness and customer expectation of services. This study aimed to solve the problems encountered especially by the Labada Express on an everyday routine by providing them with a convenient assistive for customers that need help. The combinational use Visual Basic .NET can potentially introduce an accurate and reliable way of identifying the availability of the product from the shop. This system will also provide a list of inventories and required the admin/owner or sales staff to regularly update the inventory system. Definitive, the researchers have created a basis for further study in the field of inventory system, retrieval of information, Data and Information.
