A software development for investment analysis of LED lighting production project using fuzzy logic technique

Main Article Content

Saroj Pullteap
Piyawat Samartkit
Kanit Kheovichai
Han Cheng Seat

Abstract

In this work, an application software for investment decision-making has been developed to analyze the feasibility level of an LED lighting production project. Particularly, the initial, manufacturing, administration, and financial expenses of the project, along with sales income and corporate tax, are applied as financial data. These inputs are then calculated into the net present value (NPV), internal rate of return (IRR), benefit-cost ratio (BCR), and discounted payback period (DPB) values, and further synthesized into the investment feasibility level using fuzzy logic. Additionally, the software allows flexible discount rate variation throughout project duration. The analysis results of 5 years duration project show that the NPV, IRR, BCR, and DPB were 6,307,759.46 Thai Baht, 24.04%, 1.08, and 3.38 years, respectively. Moreover, with 20% of expected profit margin, the feasibility level of project applying the floating discount rate of 7.12%-8.00% was “medium” at 77.89%, while project with fixed 8.00% rate suggested the level of “medium” at 67.34%. The discount rate variation, further, implied that using the floating discount rate was more attractive for the investment. Sensitivity analysis also revealed that the project was attractive until its income was 3.1% lower and expense was 2.4% higher than original. Therefore, the developed software could be suitable tool for more realistic project feasibility assessment and investment decision-making.

Downloads

Download data is not yet available.

Article Details

Section
Research Articles

References

Adnan, M. M., Sarkheyli, A., Zain, A. M., and Haron, H. (2015). Fuzzy logic for modeling machining process: a review. Artificial Intelligence Review, 43, 345-379.

Ahn, B. L., Jang, C. Y., Leigh, S. B., Yoo, S., and Jeong, H. (2014). Effect of LED lighting on the cooling and heating loads in office buildings. Applied Energy, 113, 1484-1489.

Brealey, R., Myers, S., and Allen, F. (2014). Principles of corporate finance, 11th, London: McGrawHill Education.

Castro-Santos, L., Filgueira-Vizoso, A., Carral-Couce, L., and Formoso, J. A. F. (2016). Economic feasibility of floating offshore wind farms. Energy, 112(1), 868-882.

Chaudhari, S., and Patil, M. (2014). Study and review of fuzzy inference systems for decision making and control. American International Journal of Research in Science, Technology, Engineering & Mathematics, 5(1), 88-92.

Chen, J. F., Hsieh, H. N., and Do, Q. H. (2015). Evaluating teaching performance based on fuzzy AHP and comprehensive evaluation approach. Applied Soft Computing, 28, 100-108.

Elhosseini, M. A., El Sehiemy, R. A., Salah, A. H., and Abido, M. A. (2018). Modeling and control of an interconnected combined cycle gas turbine using fuzzy and ANFIS controllers. Electrical Engineering, 100, 763-785.

Goswami, R., and Joshi, D. (2018). Performance review of fuzzy logic based controllers employed in brushless DC motor. Procedia Computer Science, 132, 623-631.

Gupta, P. (2017). Applications of fuzzy logic in daily life. International Journal of Advanced Research in Computer Science, 8, 1795-1800.

Kiliç, M., and Kaya, I. (2015). Investment project evaluation by a decision making methodology based on type-2 fuzzy sets. Applied Soft Computing, 27, 399-410.

Krungthai Bank. (2018). Management discussion and analysis 2015-2018, Bangkok: Krungthai Bank Public Co. Ltd.

Krungthai Bank. (2019). Management discussion and analysis for the first quarter ended March 31, 2019, Bangkok: Krungthai Bank Public Co. Ltd.

Lapsongphon, C., and Pullteap, S. (2018). A design of LED driver circuit for reducing production cost in Thailand industry. MATEC Web of Conferences, 192, 02067.

Leite, J. C., Abril, I. P., Tostes, M. E. L., and Oliviera, R. C. L. (2017). Multi-objective optimization of passive filters in industrial power systems. Electrical Engineering, 99, 387-395.

Mardani, A., Jusoh, A., and Zavadskas, E. K. (2015). Fuzzy multiple criteria decision-making techniques and applications - Two decades review from 1994 to 2014. Expert Systems with Applications, 42(8), 4126-4148.

Nardelli, A., Deuschle, E., de Azevedo, L. D., Pessoa, J. L. N., and Ghisi, E. (2017). Assessment of light emitting diodes technology for general lighting: A critical review. Renewable and Sustainable Energy Reviews, 75, 368-379.

Oviedo-Ocaña, E. R., Dominguez, I., Ward, S., Rivera-Sanchez, M. L., and Zaraza-Peña, J. M. (2018). Financial feasibility of end-user designed rainwater harvesting and greywater reuse systems for high water use household. Environmental Science and Pollution Research, 25, 19200-19216.

Principi, P., and Fioretti, R. (2014). A comparative life cycle assessment of luminaires for general lighting for the office - compact fluorescent (CFL) vs light emitting diode (LED) - a case study. Journal of Cleaner Production, 83(15), 96-107.

Rahman, M. M., and Mahmud, M. A. (2018). Economic feasibility of mangrove restoration in the southeastern coast of Bangladesh. Ocean & Coastal Management, 161(1), 211-221.

Samartkit, P., and S. Pullteap (2019). A design of decision making-assisted software using fuzzy logic technique: a case study of solar cell investment project. Electrical Engineering, 101, 213-223.

Shen, K. Y., and Tzeng, G. H. (2015). Fuzzy inference-enhanced VC-DRSA model for technical analysis: investment decision aid. International Journal of Fuzzy Systems, 17, 375-389.

Strnad, I., and Prenc, R. (2018). Optimal sizing of renewable sources and energy storage in low-carbon microgrid nodes. Electrical Engineering, 100, 1661-1674.

Suganthi, L., Iniyan, S., and Samuel, A. A. (2015). Applications of fuzzy logic in renewable energy systems - A review. Renewable and Sustainable Energy Reviews, 48, 585-607.

Taylor-de-Lima, R. L. N., da Silva, A. J. G., Legey, L. F. L., and Szklo, A. (2018). Evaluation of economic feasibility under uncertainty of a thermochemical route for ethanol production in Brazil. Energy, 150(1), 363-376.

Thailand Revenue Department. (2016). Royal decree issued under the revenue code regarding tax rate reduction and revenue tax exemption (No. 603) B.E. 2559. Government Gazette, No. 133:33. [Online URL:https://www.rd.go.th/publish/fileadmin/user_upload/kormor/newlaw/dc603.pdf] accessed on February 17, 2019. [in Thai]

Tir, Z., Soufi, Y., Hashemnia, M. N., Malik, O. P., and Marouani, K. (2017). Fuzzy logic field oriented control of double star induction motor drive. Electrical Engineering, 99, 495-503.

Xu, Z., Gao, K., Khoshgoftaar, T. M., and Seliya, N. (2014). System regression test planning with a fuzzy expert system. Information Sciences, 259, 532-543.

Yadav, R. S., Soni, A. K., and Pal, S. (2014). A study of academic performance evaluation using fuzzy logic techniques. In Proceedings of the 8th International Conference on Computing for Sustainable Global Development (INDIACom), pp. 54-58. New Delhi, India.

Zeng, S., and Xiao, Y. (2016). TOPSIS method for intuitionistic fuzzy multiple-criteria decision making and its application to investment selection. Kybernetes. 45(2), 282-296.