Modelling Optimal Paint Production using
Linear Programming

Stephen I. Okeke; Akpan; N.P

doi:https://doi.org/10.14445/22315373/IJMTT-V65I6P508

International Journal of Mathematics Trends and Technology

Research Article | Open Access | Download PDF

Volume 65 | Issue 6 | Year 2019 | Article Id. IJMTT-V65I6P508 | DOI : https://doi.org/10.14445/22315373/IJMTT-V65I6P508

Modelling Optimal Paint Production using Linear Programming

Stephen I. Okeke , Akpan, N.P

Citation :

Stephen I. Okeke , Akpan, N.P, "Modelling Optimal Paint Production using Linear Programming," International Journal of Mathematics Trends and Technology (IJMTT), vol. 65, no. 6, pp. 47-53, 2019. Crossref, https://doi.org/10.14445/22315373/IJMTT-V65I6P508

Abstract

The concept of Simplex algorithm is effectively and practically used in this work. A feature of Linear Programming is to allocate raw materials to striving variables (small bucket and big bucket) in a paint industry for the purpose of maximizing company’s profit. The analysis was implemented using MS Excel Solver (2007 version) and the result showed that 10 units of small bucket of paint, 0 unit of big bucket of paint should be produced independently in order to make a profit of N 7000.00. Thus, from the analysis, it was discovered that small bucket of paint only contribute objectively to the profit. So, more of small buckets of paint are needed to be produced and sold in order to maximize the company’s profit and at same time satisfying the customers’ needs.

Keywords

Linear programming model, Decision Variables, Simplex Method, MS Excel Solver (2007version),Optimal result.

References

[1] Akpan, N.P, Iwok, I.A (2016). Application of Linear Programming for Optimal Use of Raw Materials in Bakery, International Journal of Mathematics and Statistics Invention, 4(8).
[2] Balogun, O.S. Jolayemi, E.T. Akigbade, T.J Muazu, H.G (2012). Use of linear programming for optimal production in a production line in Coca-Cola bottling company, International Journal of Engineering, Research and application, 2.
[3] Brownson, R., Naadimuthu, G. (1997). Schaum’s Outline of Theory and Problems of Operations Research, 2nd edition. New York, U.S.A. McGraw-Hill Companies, 32-34.
[4] Chikwendu, C.R. (2009). Elementary Operations Research with Applications, Nnewi, Anambra State, Nigeria: God’s Time Publishing Concept, pp 1,12,13,35.
[5] Joly, M (2012). Refinery production planning and scheduling: The refining core business. Brazilian Journal of Chemical Engineering 29(2).
[6] Lenka Veselovska, Ing (2013). Process of development of model based on linear programming to solve resource allocation task with emphasis on financial aspects. European Scientific Journal, 1.
[7] Majeke Felix (2013). Incorporating crop rotational requirements in a linear programming model: A case study of rural farmers in Bindura, Zimbabwe. International Researchers volume, 2.
[8] Taha, H.A. (2007). Operations Research: An introduction: Upper Saddle River, New Jersey, U.S.A.: Pearson Education, Inc., London Macmillan Publishing company, pp 12-15.