Profit Optimization Using Linear Programming Model: A Case Study of Ethiopian Chemical Company

Abstract

This paper aims for profit optimization of an Ethiopian chemical company located in Adama (Ethiopia) using linear programming model. Particularly, our present study brings out clearly the necessity of using quantitative techniques for utilization in Ethiopian company; a factory situated within Adama about 90 kms. from Addis Ababa (Capital of Ethiopia). The first step comprises data generation. A questionnaire is prepared and circulated amongst company staff both executive and technical to determine the production, sales and profit during a few months of 2014. The profits varied considerably owing to subjective approach. It was established that the decisions are undertaken by experienced people without use of quantitative people and quantitative method. Whole approach applied here is seemingly subjective. A theoretical perspective undertaken for the present study is review of various different applications of linear programming. The characteristics of base assumptions of linear programming and its advantages and disadvantages towards establishing its need for optimization are briefly outlined in terms of its application to the factory. Survey data is analyzed to determine the style of decision making and the problem is defined. An objective function is created in terms of decision variables of production, sales and profit over a period of time using the quantitatively available data of these parameters. A linear programming model for company is developed for profit optimization. The model equations with adequate restraints taking into account manufacturing limitations are solved using MS-Excel solver. Finally, some conclusive observations have been drawn and recommendations have been suggested.