Automate Inventory System Essay

1331 words - 6 pages


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 ...view middle of the document...

The second feature of the Stock Manager Client web interface will allow the user to modify application settings, such as the threshold for email notifications, frequency of inventory scans (daily at a particular hour, weekly, monthly, etc.), and security settings. The third feature of the Stock Manager Client web interface will allow the user to update the inventory during the restocking process. See Figure 1. Since a web interface will be used, a network that supports the HTTP/HTTPS protocol must exist, whether it is a private network for an isolated customer deployment or an Internet connection for a multi-site customer deployment. The bandwidth of the network depends on the frequency of transactions. A bandwidth of at least 10 Mbps is recommended (small commercial deployment). The database to store the inventory data will use a MySQL database.
Since the software and hardware resources of cash registers are not available due to the variation in software and cost, we will be developing an emulated Cash Register client to interface with actual cash registers. The Cash Register client will emulate purchases by having a simple graphical interface with fields for a barcode number and quantity and a button to make a purchase. See Figure 2. As these resources become available, the actual implementation for specific cash register models will be considered for future releases of the Inventory Management System. JavaPOS will be used as a reference for emulating cash registers, and could potentially be used to create the actual implementation of the future release.
Alternatively, commercially licensed products are available. In particular, the Microsoft ASP.NET (Active Server Pages) framework can be used. This requires a Microsoft ASP.NET web server and a Microsoft SQL Server database, which also requires a Microsoft operating system. However, these alternative system requirements will increase the overall costs for both implementation and deployment.

Figure 1. The three features of the Stock Manager Client web interface.

Figure 2. The emulated Cash Register Client interface.

3. System and Software Architecture

The programming language for the Inventory Management System application will be in Java since the JSP/Tomcat architecture will be used. Both types of clients will communicate with the server using Java Remote Method Invocation (RMI) with Secure Socket Layer (SSL). Thus, security will be upheld by HTTPS in both a private network and a network connected to the Internet. The application will use a client-server model. See Figure 3.
Furthermore, the Java Database Connectivity (JDBC) will use the MySQL Connector/J driver for the server to communicate to the inventory database. Upon receiving requests from the clients, the server will issue transactions to the MySQL database with ACID properties. The Cash Register clients will maintain local...

Other Papers Like Automate Inventory System

Management Essay

2549 words - 11 pages ). With these constraints identified the goal for operations and materials managers is to reduce costs and find ways to automate the supply chain system. According to Sentient Health (2007) supply automation is the use of technology to streamline inventory, consumption, charging, and ordering procedures. For example if hospitals implement the use of bar coding or radio frequency identification to identify and track inventory as it moves throughout the

Zaracase Essay

3332 words - 14 pages main advantage of upgrading the system is that it would increase the networking capability which would result in better information access to make effective decisions. Also, the upgraded system can be a stepping stone for various future technical innovations. * Centralized Data Management – A centralized inventory database will enable Zara employees to exactly determine the current inventory in the stock. With the knowledge of accurate

Small Business Management

1921 words - 8 pages responsibility will include: • Sales & marketing management • Accounting and financial management • Business identity • Automate your business • Hiring employees It’s a good idea to plan ahead of time how you are going to manage each area which may include delegating various function to a business partner, undertaking additional training or contracting a specialist advisor such as a bookkeeper, graphic designer or merchandiser

Examples Of Biopoem About My Mother

5434 words - 22 pages or developing network links to these trading partners for such applications, using the Internet or other networks. Order Processing: Order processing, or sales order processing, is an important transaction processing system that captures and processes customer orders and produces data needed for sales analysis and inventory control. In many firms, it also keeps track of the status of customer orders until goods are delivered

Types Of Information System

2993 words - 12 pages sales order, for example, the transaction processing system records the sale, updates the customer’s account balance, and makes a deduction from inventory. Using this information, the related management information system can produce reports that recap daily sales activities; list customers with past due account balances; graph slow or fast selling products; and highlight inventory items that need reordering. A management information system focuses


3898 words - 16 pages software is useful for auditing purposes. When the auditor finds an error and fixes it, all other records are automatically updated. Real Time Information * A computerized accounting system has the advantage of providing information in real time. Accounting records are always up-to-date because they are automatically updated every time a transaction takes place. This is very useful for tracking inventory costs and sales. MYOB will show how much


2010 words - 9 pages difference between service firms and manufacturers is the tangibility of their 
output. The output of a service firm, such as consultancy, training or maintenance, for example, is 
intangible. Manufacturers produce physical goods that customers can see and touch. 

2) Inventory: Service firms, unlike manufacturers, do not hold inventory; they create a service when 
a client requires it. Manufacturers produce goods for stock, with inventory levels

The 3 Es Of Om

5180 words - 21 pages actually very similar to the reorder point system. The difference is in application. The reorder point system attempts to create a permanent ordering policy, whereas the kanban system encourages the continual reduction of inventory. We can see how that occurs by examining the formula for determining the number of kanbans needed to control the production of a particular item. Why would you use it? Lean’s strength is its fast implementation. Immediate

Jet2 Task 3

5829 words - 24 pages main difference is that a loan is a one-time transaction with higher closing costs, and a line of credit can be used multiple times to fund projects. Lines of credit generally have lower monthly payments as well. 3. Sale of capital assets such as land, machinery, or buildings. 4. Companies can raise working capital by increasing their cash flow. This could include improving their accounts receivable collections system and negotiating longer terms

Principles Of Marketing

6563 words - 27 pages increases its sales and profitability. So when we say that marketing delivers value, marketing delivers value to both the customer and the company. Franklin D. Roosevelt, the U.S. president with perhaps the greatest influence on our economic system, once said, “If I were starting life over again, I am inclined to think that I would go into the advertising business in preference to almost any other. The general raising of the standards of modern

Social Media Marketing

6353 words - 26 pages . All rights reserved. Product specifications subject to change without notice. 4 Premium Inventory Premium Locations Premium Ads run on the most valuable pages on Facebook in terms of engagement, time spent and quality, such as the Home Page and Profile pages. The Home Page includes the News Feed, which shows everything a user’s friends and other connections are sharing. Profile pages are another high engagement location that rival the home

Related Essays

Blue Company Final Essay

954 words - 4 pages Date: October 10, 2011 From: Rachael Melendez To: PwC Auditor Introduction BLUE Company operates under an enterprise planning system which allows an organization to automate and integrate its essential business processes. There are many weaknesses within BLUE’s expenditure process that lead to potential risks. The internal controls in this company are poor; for example, certain departments are authorized too much power, such as the

Inventory System Essay

1888 words - 8 pages , purchasing and sales processes of the said institution. It was also proposed to automate report generation and preparation. The proposed System will provide a great help to the staff and personnel of the pharmacy. Computerization will ease their report preparation and generation and will eliminate their manual processes. (Celino, Embralino, Locano, Mendoza, Oplas, & Pescador, 2005) The Benguet State University Marketing Center Inventory and

Cango Financial Analysis

798 words - 4 pages their quick ratio or liquidity ratio is to pay down some of their obligations or find ways to increase their sales to increase their cash or accounts receivable. Areas for improvement in CanGo’s balance sheet include are their accounts payable, maybe they can find ways to automate some of their processes decreasing manpower. If CanGo can implement the new ASRS system maybe some aspects of that system can include automating a process. An

Case Study 1

1264 words - 6 pages system to monitor and report from order to delivery (Bowersox, 10). This will increase visibility within DEP, report status of orders, show shortfalls under management control, and ensure integration with suppliers and customers. DEP will also see an increase of inventory turn, which is an increase in cash-to-cash conversion (Bowersox, 24) DEP receives orders by telephone and fax. Not only does this add an accepted risk of human input error; the