Inventory Management System Proposal

1 Introduction
1.1 Overview
Inventory Management System is a vital part of any retail business, Inventory management provides critical information about the condition of products, such as whether low on stock and the inventory needs to replenish. Inventory system also provides the customers with accurate information, letting them know when items are out of stock, back –ordered, or pre-orderable. Modern inventory control systems often rely upon barcodes and radio-frequency identification (RFID) tags to provide automatic identification of inventory objects. In an academic study performed at Wal-Mart, RFID reduced Out of Stocks by 30 percent for products selling between 0.1 and 15 units a day. Inventory objects could include any kind of physical asset: merchandise, consumables, fixed assets, circulating tools, library books, or capital equipment. To record an inventory transaction, the system uses a barcode scanner or RFID reader to automatically identify the inventory object, and then collects additional information from the operators via fixed terminals (workstations), or mobile computers. In consideration to these facts this project is meant to design Inventory management system for Vonall com plc. 1.2. Existing system

Existing system of Vonall com plc is developed using Microsoft Excel it only has one function. The excel worksheet can accessed by any staff in the Vonall com company and modification can be done easily. The customer places an order and receives the product just from the stock. This system allows the staffs to manage what products are currently in stock and where they are located. Furthermore, users are able to find products by name or model number. The existing system provides text-based interface, which is not as user-friendly as Graphical user Interface. Since the system is implemented in Manual, so the response is very slow. The transactions are executed in off-line mode, hence on-line data capture and modification is not possible. 1.3. Problem statement

Existing system, system auto trigger on working standard expired date is not able to retrieve data from multiple excel worksheet. This means that all data must enter in the same excel worksheet. It is not a good solution to keep all different data in one excel worksheet as it is hard for users to make changes or to search for related data. Besides, the excel worksheet which act as database doesn’t give a good solution for users. This is due to excel does not allow a blank row occurs in between data. It means that when a blank row occurs in between of data, the Calculate button which used to calculate the remaining days (current date minus expired date) is not able to function properly. In other words, the data after the blank row will not get the correct remaining days existing system easily accessed by anyone in the company. The excel worksheet can be accessed by any staff in the company and modification can be done easily. It is located in a sharing drive, which means that everyone is allow to search, update, and delete the data. 1.2 Motivation

We are interested to do the Inventory management system software in order to simplify the existing manual system in to automated system. 2 Project description and objective
2.1 Description
The Inventory management system software will be used to implement Inventory management. It will provide critical information about the condition of products.

2.2 Scope
The projects will be developed based on specific area and the scopes of this project are as below Inventory management automatically provides information to order entry about item numbers, descriptions, and prices, quantities and locations of stock on hand and on from suppliers and alternate item numbers. When integrated with order entry, on hand quantities in Inventory management are automatically updated when entered orders and invoices. The system is able to generate report of inventory which is located in database for users. This module focus on generate data and able to be print out by users. 2.3. Objectives

General
The General objective of this project is to develop Inventory system software for Vonall com plc to enable the users to manage the data such as add data, delete data, update data and search data in a systematic way To provide accessibility for specific users such as specialist engineers to access the data

Specific
To analyze requirement system design specification, software architecture description and implementation or develop inventory management system software. To provide simple user interface for specific users such as specialist engineers to access the data

2.3 Deliverables
Documentation will accompany the aforementioned collection inventory management system software that will describe all of its functionality, menu functions, help topics, installation methods, technical specifications, etc. This document will be delivered on the due date.

Proposal document delivery due date is 28th October 2013
Requirement Specification and Analysis Document
System Design Specification Document
Software Architecture Description
Implementation

2.4 Application
Vonall com plc will benefit from investing in the infrastructure of a basic sales automation system with a few work flow aids now, and may develop a complete management system at a later date Improved communication with customers

Scores of pre designed reports for customer and time management
3 Methodology and tools
The information which is collected through interview and reports to define the requirement layout with staff of Vonall com plc will serve as a primary data gathering and this will be taken as a major input in drawing the whole aspect of the project.

Tools
The software will be programmed in Java
The software program needs to store large amounts of data Generic databases MY SQL 4 Schedule
In the chart which is stated below, we try to describe the estimated date of all the work we are going to do for our project. Figure 1. is a Gantt chart illustrating the group’s proposed schedule.

Figure1. Estimated Schedule of Inventory Management System