Inventory Management and Sales Management System for Kolden Tea International

Abstract

Information technology has converted the whole world into such state that most of the processes in every industry highly depend on IT systems and has become automated to get the best out of them. The developed Inventory Management and Sales Management System (IMSM) will be very useful to Kolden Tea international company in enhancing their day-to-day operations. Kolden Tea is a small-scale business who distributes tea products to corporate sector and they do not use any automated system for managing inventory, sales, clients and HR functions. Currently all the processes are done using excel sheets. Payment calculations, invoicing and maintaining stock re-order level are done manually. Sometimes the current practice shows wrong figures on the available stocks due to not updated sales. When delivering tea orders there is no proper way to cross check required tea packs with availability. Employee personal files for are being maintained and a manual document is used to record the attendance. Useful reports are being prepared by management but this requires a lot of time to refer the documents and excel sheets. As a solution to overcome these issues IMSM system was proposed. IMSM system handles all sales and inventory/stocks related processes and reduces the impact on the service quality resulting from inconsistent data. This system minimize the manual work done by the employees and all the files and documents are replaced with a well structured data base. IMSM system supports the management of the company for their decisions, based on the unambiguous information in the database. The efficiency of the new system is greater and same will be the base for a better service of the system users. All functional, non-functional and system requirements of the system were properly analyzed and an object oriented 'Design' solution for the problem was identified. Microsoft Visual Studio 2010 with .NET Framework and Microsoft SQL Server 2008 were selected for implementing the system. C# was used as the programming language and SQL has been used as the database language. All the critical functionalities have been thoroughly tested using black box and white box testing. Test plan was developed after considering all the modules and functions. Test cases for each module were planned and results were validated with requirements. User evaluation has been done by the several actual users at various access levels. IMSM system provides a centralized system and can be accessible by any authorized user and fulfills the purpose of the project. After a critical analysis, the developed IMSM system can be considered as a satisfactory level project which meets all the expected requirements of our client as well as the standards of the MIT degree program.