Premium Essay

Automate Inventory System


Submitted By bboyva
Words 1331
Pages 6

This paper describes the Inventory Management System sufficiently to determine the feasibility and usability of a finished system. The core concept is to track the sale of items from the cash registers with additional features for interpreting the data. It uses a client-server model with a connected database to allow multiple stores and warehouses to be connected. This allows for later expansion while still supporting the targeted small businesses. The core features and final framework should be completed within 2 weeks, leaving 5 weeks to implement additional features and testing.

1. Operational Concepts

The Inventory Management System is a real-time inventory database capable of connecting multiple stores. This can be used to track the inventory of a single store, or to manage the distribution of stock between several branches of a larger franchise. However, the system merely records sales and restocking data and provides notification of low stock at any location through email at a specified interval. The goal is to reduce the strain of tracking rather than to handle all store maintenance. Further features may include the ability to generate reports of sales, but again the interpretation is left to the management. In addition, since theft does occasionally occur, the system provides solutions for confirming the store inventory and for correcting stock quantities.

2. System Requirements

The Inventory Management System uses a web-based interface to display inventory data to the stock manager client. The product will use of open-source software primarily due to cost of implementation. A JSP (JavaServer Pages) servlet will be hosted by an Apache Tomcat web server (on top of any choice of operating system, although a flavor of Unix is recommend). The first feature of the Stock Manager Client web interface component allows the

Similar Documents

Free Essay

Documentation retrieve and update the files of every individual. Most people use computer as storage device especially in big business that require development of system. Mercury Drug Store Bulacan Balagtas Town Center Branch is offers health related services and is located in Bulacan, Philippines. You can contact them on phone on 63 44 693 2955 or you can meet them at their address in Bulacan which is Stall 106-1 Balagtas Town Center, Balagtas, 3016, Bulacan. Mercury Drug Store Bulacan Balagtas Town Center Branch listed sevices activity is Pharmacies. The proposed system will help the company. The researcher was able to conduct a study on developing the Mercury Drug Store point of sale and inventory system. This system could help process reports and information and update the price and stocks of the products. 1.1 Background of the study It has been disclosed during the interview that Mercury Drug Store – Balagtas Town Center Branch needs a computerized inventory system. The company’s current inventory monitory system though works for them has to automate. A simplified computerized inventory system will be very helpful to the company since this will expedite its inventory workflow as well as generate very timely reports needed by the management for its evaluation and review and overall decision making. An inventory control system is a process for managing and locating objects or materials. In common usage, the term may also refer to just the software...

Words: 944 - Pages: 4

Free Essay

Re: Week 2

...Inventory Management Systems Systems Analysis and Development Professor Irene Hoskins October 19, 2014 Inventory management systems were before reserved for large enterprises and retail chains but they are becoming more and more popular among smaller businesses and vendors. Automating your inventory control system to track and reorder your merchandise is vital for the success of any business that plans to compete in the modern world. A barcode scanner would be needed to read the barcodes on the items in stock which is stored on a computer or in the software of most Point of Sale (POS) Systems today. The information is tracked by the central computer system or the POS inventory control system software which serves a range of functions to tract the merchandise. These Inventory control systems make it very easy to locate and analyze inventory information in real-time with a simple database. They can help workers locate items on an order list in a warehouse or on the sales floor, it can also inform managers of depleting high demand stocks. To modernize and automate her store on a budget, we could consider Pay Anywhere, which is a great solution system for any business on a budget. For the Pay Anywhere infrastructure all is needed is a Samsung smart phone or tablet or iPhone, iPad or iPod and download and install the application. They will send you a free card reader for each device so you can accept credit cards. You can also request their POS System, which is their own tablet...

Words: 567 - Pages: 3

Free Essay

Inventory Managemen Systems

...Management Systems 1 Inventory Management Systems An inventory control system is a set of hardware and software based tools that automate the process of tracking goods. The type of inventory tracked with an inventory control system may include almost any type of calculable good to include food, clothing, books, equipment, and any other item that consumers, retailers, or wholesalers may purchase. Modern-day inventory control systems are practically completely based on barcode technology. Regardless of technology, all inventory systems require some element of visual inventory management. The use of bar codes, point of sale or stub control all requires manual verification periodically. As an owner of a small clothing store it is important to use an inventory system for the success and growth of the business. Inventory systems serve multiple purposes and have many functions. The systems’ primary function is to assist in promoting sales by tracking available good and materials by providing sufficient availability of products for customers. In addition, establishing the value of the products on the shelf will enable the owner to monitor the number of goods at a specific period of time which will assist in maximizing profits and minimize losses. The Small Business Administration suggests all inventory systems strive to strike a balance between managing costs and the business advantages of a broad selection of good to offer to customers. Management Systems...

Words: 982 - Pages: 4

Free Essay

Inventory Management System

...would like to upgrade to an automated system that is on the low end of the expensive level. Being that I have technological skills and experience within the field, I agreed to help her purchase and installed a low budget automated inventory management system. I also took the time to explain to her how the system works. Inventory management is a database of hardware and software based tools that automate the process of tracking inventory. The kinds of inventory tracked with an inventory control 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 (inventory control system). This automated system is able to track merchandise, while altering when inventory is low, seasonal demands change, and communicating with suppliers in real-time. In addition the system can reduce the cost and time-consuming processes that were once completed by her manually, while providing her business with more accurate data. In addition, the system helps save time, keep a balanced inventory, and tracks inventory stock efficiently (Loackard). In order to establish an inventory management system there are necessary equipment that must be purchased. Due to the low availability of monetary funds, I would purchase the following; one laptop, wireless router, barcode scanner, barcode printer, barcode software, a printer, Internet service, and inventory software. An extra hard drive for backup/recovery...

Words: 1058 - Pages: 5

Free Essay

Recommendations on Implementing Automated Inventory Management Systems at Al-Baldani Trading Contracting Establishment.

...Implementing Automated Inventory Management Systems at Al-Baldani Trading Contracting Establishment. (BBA-604) Synopsis submitted by: Arifa Jamil Syed BBA (General) 541110506 Table of Content Executive Summary 3 Part 1: Understanding the industry & company 4 Part 2: Introduction 6 Objective 6 Methodology 7 Conclusion 8 5. Recommendation 8 Part 3: 1. Appendix 9 (Part 1) EXECUTIVE SUMMARY The goal of this project is to apply systems based engineering...

Words: 1447 - Pages: 6

Premium Essay

Cis564.4 - Needs and Use Cases

...regards to Operations Inventory Control. According to the virtual organization portal, Riordan Manufacturing has five hundred-fifty employees and indicated there is a projection of $46 million annual earnings. “Riordan Manufacturing, Inc. is an industry leader in the field of plastic injection molding. With state-of-the art design capabilities, we create innovative plastic designs that have earned international acclaim. Attention to detail, extreme precision and enthusiastic quality control are the hallmarks of Riordan Manufacturing. With facilities in San Jose, California, Albany, Georgia, Pontiac, Michigan and Hangzhou, China, we have the capacity to fulfill your unique needs. Riordan Manufacturing is wholly owned by Riordan Industries, a Fortune 1000 enterprise. The company produces plastic beverage containers produced at its plant in Albany, Georgia, custom plastic parts produced at its plant in Pontiac, Michigan, and plastic fan parts produced at its facilities in Hangzhou, China. The company's research and development is done at the corporate headquarters in San Jose. Riordan's major customers are automotive parts manufacturers, aircraft manufacturers, the Department of Defense, beverage makers and bottlers, and appliance manufacturers.” http:/ Determining the Needs for Riordan Manufacturing System Development Life Cycle is also known as SDLC. This is the process of the developing information systems by compiling investigative...

Words: 1321 - Pages: 6

Premium Essay

Inventory Management

...KB Corporation PROPOSAL For Inventory Management System Table of Contents 1 Overview 2 Problem Situations Proposed and Purpose 3 Record methods 3.1 Recommendation for the forms design principles are: 3.2 Computer assisted-retrieval system (CAR) 3.3 Data Retrieval methods by Information Technologies 3.4 Policies for record storage 4 Organizing the record and the classification system. 5 Implementation. 6 Conclusion: Strategically Managing Inventory for Future Growth 1. Overview As the company are expecting to establish another 20 shops in the next 2 years, we have realized how important for the document system for different department. And our products are almost imported from Europe and Asia. We cannot keep to using the manual record for the document record system. This document will explain the requirement for management, inventory, provisioning, customer support, sales support, and book-to-bank systems. Where possible recommendations are given to understand and plan for interconnection, correlation, and data warehousing requirements. Emphasis is given to ensuring all databases will have a capability to provide input to decision support systems needed by both senior management, as well as operational levels of the business. 2 . Problem Situations Our company current operation has shown that the inventory document record is obvious inefficiency. In the aspect of inventory control, more and more errors were found...

Words: 1430 - Pages: 6

Premium Essay

Ppci Inventory

...CHAPTER I INTRODUCTION Background of the study An automated system nowadays is becoming prominent for a business that needs accurate, efficient and reliable results. Today, many businesses are engaging to automated systems, its manual setup can be applied automatically through computer. By using a computer, a business can perform its transaction in a less amount of time. Having a way to organize transactions by the use of automated system is an asset. Especially when you apply the automation to the most commonly used transaction, Inventory Management System. Inventory Management System is a list of equipment and materials that is needed for the everyday production of a business which is held available in stock. Updating the records of the stocks in a business plays an important part for the organization of business functions. Manual application of transaction can bring interruption, thus, the Automated Inventory System is considered as the best solution to this problem. A business owner can franchise more than one line of franchise, Palawan Polytechnic College Inc (PPCI) has a group of franchised business which named, MATS and MMFC. The business started since September 1968 and successfully opened 2 branches in 43 years. Since then, they record their daily sales and inventory manually by the use of record book and Microsoft excel. It starts from counting and checking their previous available stocks individually, computer for the total used stocks, record it in a record book...

Words: 14062 - Pages: 57

Premium Essay


...individually. Software/internal information flow First factor which gives Zara competitive advantage according to me is their software. The fact that all the software (PDA) used currently by Zara is developed by them gives them huge competitive advantage. Having the software developed internally makes it much more efficient and user friendly because it is compatible with the companies daily operations. Everything starting from the operational procedures, performance measures, and even office and store layouts are designed to make information flow simple. Making the internal information flow faster and more efficient is one of the key success factors for Inditex. The fact that all the stores are directly connected to the main system which in collects all the data is a great way for analyzing things that are going on in different stores. But all in all we would say that this factor is...

Words: 1575 - Pages: 7

Free Essay

Inventory Systems

...Businesses and Inventory Systems Inventory Systems Inventory systems are tracking systems designed for companies to maintain an accurate accountability of products in stock or on hand. Each time items are added or removed from inventory items on hand either decrease or increase in number. This paper will review inventory systems within Starbucks, Wal- Mart, Dell, Arby’s, and Starbucks. The paper will also provide information regarding the success of the inventory systems and if the companies are happy with the current systems. Businesses and Inventory Systems Dell is a leading global software company that manufactures desktop computers, notebook computers, network servers, work stations, and storage products. Dell uses the Just-In Time inventory system. Just-In-Time means a company can receive raw materials just in time to go into production and complete and assemble manufacturing parts just in time to ship to customers (Accounting 4 Management, 2012). The advantages of the Just-In-Time system are that it permits Dell to reduce overhead and have certainty that products are available. The Just –In-Time inventory system reduces the cost of doing business. For example, Dell does not have to spend an enormous amount of funds on the cost of warehouse storage and the customer receives the benefit of lower cost for products. The company has a high satisfaction rating because of their ability to produce products at a fast rate. The challenge includes the possibility...

Words: 1202 - Pages: 5

Premium Essay

Systems Build Project

...Systems Build Project MGT222 – Management Seminar Inventory Management Buehler’s Fresh Foods grocery store in Ohio, founded in 1929 by E.L. (Ed) Buehler and his wife, Helen, has a long and successful history, mainly due in part to Ed’s vision and his experience as an A&P employee. After opening their first store in New Philadelphia, the Buehler family moved the business to Wooster in 1932 and opened a store near the northeast corner of Public Square. Today, Buehler’s Fresh Foods is still owned by the Buehler family and operated by its “third generation” from the store’s Wooster headquarters. The Buehlers’ innovative and creative spirit has made the Ohio grocery store chain a pacesetter for independent grocers nationwide. (Buehler’s Fresh Foods) Needs Analysis Unfortunately, Buehler’s Fresh Foods is lacking the technology needed to compete with the market today. Currently, the company tracks inventory with a simple pen and paper technique. This system requires hours of unneeded manpower and is very inefficient in determining the perishable dates of many grocery products. Proper inventory management will allow the company to track the products they sell. The company can see at a glance what items they sell the most, what time of the year that more are sold, and have a chance to see what patterns develop so they can plan buying accordingly. It will also help them track products that don't sell as often, or at all, so they can either not order as much as they would routinely...

Words: 2454 - Pages: 10

Premium Essay

Inventory Systems

...Inventory Systems Summary With the increasing demand to cut cost and increase revenues, developing the right inventory systems have become essential to compete in business. According to the Counselors to America’s Small Business, “Control of inventory, which typically represents 45% to 90% of all expenses for business, is needed to ensure that business has the right goods on hand to avoid product shortage and meet the consumer’s needs” (Counselors to America’s Small Business, p. 1). To ensure proper business practice Team A will evaluate four inventory systems and provide advantages and disadvantaged to ensure businesses can be cost-efficient, profitable, and provide for consumer’s needs. At the end of this report, a system will be suggested to meet the above criteria. Adria System Retailers are consistently faced with the challenge of properly managing their inventory to maximize profit for the company. As the second largest retailer in the United States, Target Corporation has implemented successfully an inventory system that works well for their business. Target currently uses the RFID program, also known as the radio frequency identification program. With this program, small tags are attached to each carton or pallet of merchandise delivered to the stores. “Many regard RFID tags as the new barcode to help businesses track and trace goods through the supply chain” (2011). Once the merchandise arrives at the store, the entire carton or pallet is scanned and the inventory...

Words: 1529 - Pages: 7

Free Essay

Inventory Management Systems

...INVENTORY MANAGEMENT SYSTEMS Joshua Crisp Prof. Raman Marwah CIS210 10 October, 2012 Manually tracking items in a store can be a waste of time and money. Most small businesses today use some type of automated inventory system that automatically updates inventory after point of sale (POS). This is especially important on high demand items that need to be reordered in a timely matter. First we need to look at the equipment, cost, and maintenance involved in adding an automated business system to the store. The vendor I choose was Wasp Barcode Technology Systems. EQUIPMENT First, we will look at the equipment necessary to implement a new inventory management system. To keep it simple we will need: * Software * UPC barcode printer * Labels * Scanner The software will tie into the POS system and automatically track sales, returns, and inventory levels. The software I suggest will alert you when inventory levels are low and need to be reordered. Every product will have a barcode that tells the software an item has been removed from the inventory or added to the inventory. Initially we will have to load the software with data about what products are associated with each barcode and print the barcodes to attach to the products. The scanner will be used to tell the software what items are being purchased or inventoried. COST After identifying what equipment we will use we can see how much the equipment and implementation will cost. * People-...

Words: 602 - Pages: 3

Premium Essay

Harvey Industries Case Study

...provides.  These would include the pressure washers and the coin operated car wash systems, as well as any others that the company may maintain. Second, each piece of inventory should have a valid bar code so that the inventory can be deducted from the inventory system.  “Good inventory management is important for the successful operation of most businesses and their supply chain. Poor inventory management hampers operations, diminishes customer satisfaction, and increases operating costs” (Stevenson, 2009). Bar codes will allow for automatic identification as soon as it is scanned.    Obviously, prior to obtaining these inventory bar codes, you will need to have an inventory software system to track these bar codes. These bar codes will then go into the computer system. Thereafter, it should allow you to automatically order inventory when it is necessary, as opposed to being automatically ordered.  Further, you will be able to write off inventory that might be defective or used to repair the car washes or the pressure washers.  Although you will expend the cost of the software, bar codes, and the requirement of the company to place these bar codes on each product, it will save money in the end as far as missing parts or parts that cannot be accounted for because no paperwork was kept regarding the same.  This type of inventory control will ensure that the company has control of the inventory and will prevent the company from running out of stock that is required to conduct...

Words: 813 - Pages: 4

Free Essay

The Sports Guy

...Rocky's store became built up into a quite prosperous neighborhood. Strip malls developed, and The Sports Guy is now located in a busy commercial area. Problem Statement and Objectives Problem Statement The sales growth of the store is relatively slow and at the same time the level of debt is rising so are the inventory, Rocky is not sure what to do and is looking for suggestions as to how he can improve the financial performance of the business. Objectives The main objective is to improve the financial performance of the business by increasing the amount of successful sales, which will lead to solid profits. The store also needs to implement more sophisticated purchasing techniques and a computerized inventory control system to increase the inventory turnover rate, thus reducing short-term debts and interest expenses. Rocky also wants to expand and grow his business with the town but to do so he will require external finance and investment, but to do so he needs to improve the stores profitability as mentioned earlier. Situation Analysis Current Business Situation At the moment we believe The Sports Guy is not performing well with its declining inventory...

Words: 1150 - Pages: 5