Development of a Software Management for Capital Investment Decision Using Microsoft Visual Basic Programming

This research is the development of a software management for capital investment decision in LED T8 production of industry sector of Thailand. We have applied a Microsoft visual basic programming VB to design a graphical user interface GUI along with MySQL as the database for data storage such as labor cost, machine depreciation, material cost, packaging cost, transportation cost, etc. These data are used as calculation input for the economic analysis tools such as NPV, IRR, BCR, and PB. We have also used a case study of coin operated washing machine investment to test the software as well as to compare the results with the MS Excel. The experimental results shown that both the software are displayed the same values of NPV, IRR, BCR, and PB. This signifies that the software has the same efficiency as MS Excel programming. However, when considering the user interface, the developed software has a distinctive points of an easier and more convenient applications than that of the MS Excel program.