A Computerized Stock Records Management System (Csrms) A Case Study of Buhweju Tea Factory Store, Buhweju District

Abstract This project was aimed at developing a computerized stock records management system and the case study was Buhweju Tea Factory. A number of problems such as consuming of a lot of time, absence of data backup, slow generation and retrieval of reports/information, subjectivity to human errors among others were found out to be problems associated with the current paper based stock records management system in stores' section at Buhweju Tea Factory. The objectives of the study were to analyze the current stock records management system and find out errors and limitations associated with it, to develop a computerized stock records management system that will solve problems (errors and limitations) of the current stock management system, and to test and implement the designed system. To analyze the current system, questionnaires were used to get information from the selected respondents who filled and returned the questionnaires. Collected data was analyzed using Microsoft Excel and tables were used to present data. Having analyzed the collected data, the above mentioned problems were confirmed to be the problems associated with the current system and it was agreed that a computerized system would help solve those problems. A computerized stock records management system was designed by use of data flow diagrams and class diagrams. Microsoft access 2007 was used to come up with a database and Microsoft Visual basic was used to design the user interface that helps the user to interact with the system. Unit testing was done on the designed system and was implemented and used on some computers, and it was working normally. In spite the fact that a computer based stock records management system is expensive; it has a number of advantages such as time saving because information processing and report generation is done very fast, increased accuracy because it facilitates automatic calculations, information security and data backup and others. The researcher recommends that the new system be adopted and be used in stock records management at Buhweju tea factory store.