Inventory Management System Software for Public Universities in Ghana (IMSSPUG)

Project Abstract

<p><b>ABSTRACT&nbsp;</b></p><p>Managing inventories at Public Universities is one of the major challenges for higher educational institutions in Ghana. This is especially true for large, diverse and research-oriented institutions like the University for Development Studies. To arrest this deficiency, inventory management system software is the ideal answer for the ever growing public Universities in Ghana. In this paper, we present Inventory Management System Software for public Universities in Ghana. The software is efficient in managing stock supplies; stock issues and provides timely alert messages and reports to management in order to make inform decisions. It also requires minimal internal memory ( 512 MB) to operate and respond instantly to commands. The software is made of two parts the frontend is developed using Microsoft Visual Basic 2010 and the backend from SQL Server Database 2008. The software would be implemented on personal computers (PC) over a Local Area Network (LAN). <br></p><p><br></p>

Project Overview

<p> </p><div><div> </div><div><br></div><div><br></div><div>I. INTRODUCTION </div><div> An inventory control 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 control system can include almost any type of quantifiable goods, including food, clothing, books, equipment, and any other item that consumers, retailers, or wholesalers may purchase Inventory Management is one of the basic problems for public Universities in Ghana. It causes a lot of paperwork, in the absence automated system. Implementing such systems will require a lot of preliminary works such as determination of the requirements, system structure and decision software Inventory Management System (IMS) is generally used by IT Office/Department or Accounting Office of a company or a University. Therefore, searching the basic needs for implementation is the first step of IMS design. Several meetings with IT Office and Accounting Office are arranged. Accounting Office needs detailed reporting tools, detailed</div><div>categorization and declaration of specifications on each item, purchasing and billing info. The Information Technologies Office needs another module except the requirements of</div><div>Accounting Office. The module is about the interior maintenance and exterior product service flow. For interior maintenance flow, there will be a section. This section will be available for all users. Basically, a maintenance request will be created by the users, and the IT Office will respond to these requests. Finally, it is necessary to consider the end user’s needs that are also important part of the IMS software</div><div>design [4]. Maintaining accurate inventory levels affects several areas throughout the organization. In addition to improving operations in the warehouse, stock levels affect purchasing, restocking, and sales. Additionally, in most organizations, the purchasing department will often check the inventory software to verify stock levels before ordering more products. Having accurate inventory at all times allow this department to make smarter decisions.&nbsp;&nbsp;</div><div>The implementation of an inventory control solution can help to simplify work processes within an organization, leading to improved efficiency and productivity. Without an inventory management system, staff may not be operating efficiently. The way information passes from one employee to another wastes valuable time, and leaves room for mistakes to occur in stocking. Employees may forget to record a batch number, order or issue the wrong goods to a customer, or move items around the warehouse store, making it difficult for other employees to find the goods they need. By incorporating an inventory</div><div>control solution, a standard set of practices are created to handle every inventory transaction. [2]</div><div> </div><div>The most important benefit of an inventory management system is to save time and money. Again, without an inventory management system, countless man-hours are wasted manually recording what items are used for each Inventory Management System Software for Public Universities in Ghana</div><div><div>(IMSSPUG) transaction, delivering these forms to the office, and then manually entering the data into the accounting system.</div></div></div><div><div>Implementation of a system that updates in real-time, process all transactions at the store or warehouse will</div><div>virtually eliminate the need to manually enter data. As soon as the warehouse/store employee posts the transaction, it is automatically updated into the accounting system. This saves time both in the warehouse/store and in the office.</div><div>II. FEATURES </div><div>A. Order management </div><div>Should inventory reach a certain threshold, the inventory management system can be programmed to prompt managers to reorder that product. This helps companies avoid running out of products or tying up too much capital in inventory&nbsp;</div><div>B. Asset tracking </div><div>When a product is in a warehouse or store, it can be tracked via its tracking criteria, such as serial number, lot/batch number or revision number. Nowadays, inventory management software often utilizes barcode, radio-frequency identification (RFID), and/or wireless tracking technology.</div><div> C. Service management </div><div>Organizations that are primarily service-oriented rather than product-oriented can use inventory management software to track the cost of the materials they use to provide services,</div><div>such as cleaning supplies and educational materials. This way, they can attach prices to their services that reflect the total cost of performing them. Filter products and product variants listings to show only</div><div>those products that are currently available in stock. Decrement inventory levels when orders are processed to reflect stock quantities. Receive notifications when inventory levels reach an</div><div>out-of-stock threshold . </div><div>III. INVENTORY SOFTWARE INTERFACES </div><div> To make the software secured and prevent unauthorized </div><div>access a login module is built in to control users to the system </div><div>Fig 1.0 shows the login form for the software. </div><div> </div><div> </div><div>Fig 1.0 Login form for inventory software </div><div>After gaining access to the software, the main page of the software is displayed enabling menu items that an access privileges permits.&nbsp;</div><div>&nbsp;Fig 2.0 shows the main window of the inventory management software.</div><div> </div><div>Fig 2.0 Main window of the Inventory Management system software</div><div> </div><div>Fig 3.0 Shows Received Voucher</div></div><div><div> </div><div><div> </div></div><div> </div><div>Fig 3.0 Entry form for Goods Received Voucher </div><div> </div><div> </div><div>The form below shows the Issue voucher </div><div> </div><div>Fig 4.0 Issue Voucher Form </div><div> </div><div>The form below (Fig 5.0) takes records of all suppliers of </div><div>goods and services. </div><div> </div><div>Fig 5.0 Supplier details form </div><div>Fig 6.0 shows the form for reporting on Goods/services </div><div>received on daily, weekly, monthly, quarterly or yearly. This </div><div>applies to issues, stock as well as stock levels. </div><div> </div><div>Fig 6.0 Reporting form for inventory software </div><div> </div><div>IV. CONCLUSION </div><div>The implementation of this inventory software in public Universities would go a long way to reduce the difficulties associated with Inventories. Some of the benefits associated with the automated system include;</div><div>A. Inventory management increases profitability </div><div> Forecasting, controlling &amp; managing inventory </div><div>increases productivity and sales, while reducing </div><div>costs, resulting in greater profitability </div><div> Accuracy improvements &amp; time savings, in addition to the reduction of fixing costly mistakes, can result in considerable cost savings across an organization</div><div> Quick access to current &amp; historical pricing, cross-reference product codes and a robust tool set</div><div>for managing purchasing activities, enables streamlined processes and improved spend management&nbsp;</div></div><div></div><div><div><div><br> </div></div></div><br><p></p>