Abstract:
This research concerns about the design and implementation of a new information system which will simplify the processes of the current system and its impact on the warehouse staffs. In order to automate the processes, a programmed information system is designed using Microsoft excel VBA, a basic programming function inside Microsoft excel. First, the current system is analyzed. Next, the user requirements and proposed system requirements are analyzed to make the system design. Then, the program is developed and tested by using VBA (Visual Basic for Applications). Then, the new system is implemented and the implementation results are analyzed. The results found that the new system successfully fulfilled the objectives of this research and the user requirements, although there are still some improvements which need to be done. During two months’ period of implementation, there are some problems encountered which required the programmer to improve the system. Like every system, there are some advantages and disadvantages found in this new system.
