Development of linear programming model for optimization of product mix and maximization of profit: case of leather industry
Keywords:Linear programing, profit, maximization, modelling, mathematics
When the decisions are analytically supported they cannot be challenged and at the same time, the quality of decision increases. This paper is about proposing such a model which provides the analytical support to the decision for the selection of footwear articles to be produced. This paper aimed to suggest the analytically supported decision-making for deciding the number of pairs of different articles to be produced in a way that the cost and profit could be minimized and maximized respectively. This research was conducted at the ABC leather footwear company of Lahore Pakistan. The data was collected from the costing executive of the planning and costing department. Costing and profit analysis of the collected data was conducted in Microsoft Excel as per the company`s traditional method of calculations. The linear programming (LP) model was then formulated and implemented in Microsoft Excel by using solver add-in. Outputs of both the traditional method and LP model were compared. The comparison revealed that with 22% less production, 39% more profit could be earned if the selection of articles and their production quantity would be calculated accordingly. This model can be modified and used in fast-moving consumer goods (FMCGs) industries for making product mix strategies. A major limitation of the present developed model is that it is based on the scenario of the footwear industry so it cannot be used as general for other applications.
Abuizam, R. (2012). Fixed-Cost Models In Manufacturing Glass: The Case Of Juleno Crystals. Journal of Business Case Studies (JBCS), 8(3), 349-360. https://doi.org/10.19030/jbcs.v8i3.6993
Addy, I. (2014). Optimization of Production Scheduling As Linear Programming Model. Kwame Nkrumah University of Science and Technology.
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 (IJMSI) Www.Ijmsi.Org, 4(8), 51-57. Retrieved from www.ijmsi.org
Alvfors, O., & Björelind, F. (2015). Optimization of Production Scheduling in the Dairy Industry (SCI School of Engineering Sciences). SCI School of Engineering Sciences. Retrieved from www.kth.se/sci
Anggoro, B. S., Rosida, R. M., Mentari, A. M., Novitasari, C. D., & Yulista, I. (2019). Profit Optimization Using Simplex Methods on Home Industry Bintang Bakery in Sukarame Bandar Lampung. Journal of Physics: Conference Series, 1155(1), 12010-12017. https://doi.org/10.1088/1742-6596/1155/1/012010
Arain, M. S., Khan, M. A., & Kalwar, M. A. (2020). Optimization of Target Calculation Method for Leather Skiving and Stamping: Case of Leather Footwear Industry. International Journal of Business Education and Management Studies, 7(1), 15-30.
Aregawi, B. Z. (2018). Formulating and Solving a Linear Programming Model for Product- Mix Linear Problems with n Products. International Journal of Engineering Development and Research, 6(2), 167-171.
Campo, E. A., Cano, J. A., Andrés, R., & Gómez-Montoya. (2018). Linear programming for aggregate production planning in a textile company. Fibres and Textiles in Eastern Europe, 26(5), 13-19. https://doi.org/10.5604/01.3001.0012.2525
Chaudhry, A. K., Kalwar, M. A., Khan, M. A., & Shaikh, S. A. (2021). Improving the Efficiency of Small Management Information System by Using VBA. International Journal of Science and Engineering Investigations, 10(111), 7-13.
Chaudhry, A. K., Khan, M. A., Kalwar, M. A., & Chaudhry, A. K. (2021). Optimization of Material Delivery Time Analysis by Using Visual Basic For Applications in Excel. Journal of Applied Research in Technology & Engineering, 2(2), 89-100. https://doi.org/10.4995/jarte.2021.14786
Gameiro, A. H., Rocco, C. D., & Caixeta Filho, J. V. (2016). Linear programming in the economic estimate of livestock-crop integration: Application to a Brazilian dairy farm. Revista Brasileira de Zootecnia, 45(4), 181-189. https://doi.org/10.1590/S1806-92902016000400006
Jain, A. K., Bhardwaj, R., Saxena, H., & Choubey, A. (2019). Application of linear programming for profit maximization of the bank and the investor. International Journal of Engineering and Advanced Technology, 8(6), 4166-4168. https://doi.org/10.35940/ijeat.F9337.088619
Jyothi, D. N., Rao, K. S. P., & Sivasundari, M. (2019). Application of Linear Programming Model for Production Planning in an Engineering Industry-A Case Study. International Journal of Engineering Research & Technology, 8(10), 613-618.
Kalwar, M. A., & Khan, M. A. (2020a). Increasing performance of footwear stitching line by installation of auto-trim stitching machines. Journal of Applied Research in Technology & Engineering, 1(1), 31-36. https://doi.org/10.4995/jarte.2020.13788
Kalwar, M. A., & Khan, M. A. (2020b). Optimization of Procurement & Purchase Order Process in Foot Wear Industry by Using VBA in Ms Excel. International Journal of Business Education and Management Studies, 5(2), 80-100. Retrieved from https://www.ijbems.com/doc/IJBEMS-124.pdf
Kalwar, M. A., Khaskheli, S. A., Khan, M. A., Siddiqui, A. A., & Gopang, M. A. (2018). Comfortable Waiting Time of Patients at the OPD with Varying Demographics. Industrial Engineering Letters, 8(2), 20-27. Retrieved from https://core.ac.uk/download/pdf/234685697.pdf
Kalwar, M. A., Mari, S. I., Memon, M. S., Tanwari, A., & Siddiqui, A. A. (2020). Simulation Based Approach for Improving Outpatient Clinic Operations. Mehran University Research Journal of Engineering and Technology, 39(1), 153-170. https://doi.org/10.22581/muet1982.2001.15
Kalwar, M. A., Marri, H. B., & Khan, M. A. (2021). Performance Improvement of Sale Order Detail Preparation by Using Visual Basic for Applications: A Case Study of Footwear Industry. International Journal of Business Education and Management Studies, 3(1), 1-22.
Kalwar, M. A., Marri, H. B., Khan, M. A., & Khaskheli, S. A. (2021). Applications of Queuing Theory and Discrete Event Simulation in Health Care Units of Pakistan. International Journal of Science and Engineering Investigations, 10(109), 6-18.
Kalwar, M. A., Memon, M. S., Khan, M. A., & Tanwari, A. (2021). Statistical Analysis of Waiting Time of Patients by Queuing Techniques: Case Study of Large Hospital in Pakistan. Journal of Applied Research in Technology & Engineering, 2(2), 101-112. https://doi.org/10.4995/jarte.2021.14741
Kalwar, M. A., Shaikh, S. A., Khan, M. A., & Malik, T. S. (2020). Optimization of Vendor Rate Analysis Report Preparation Method by Using Visual Basic for Applications in Excel (Case Study of Footwear Company of Lahore). Proceedings of the International Conference on Industrial Engineering and Operations Management. Dhaka, Bangladesh.
Khan, M. A., Kalwar, M. A., Malik, A. J., Malik, T. S., & Chaudhry, A. K. (2021). Automation of Supplier Price Evaluation Report in MS Excel by Using Visual Basic for Applications: A Case of Footwear Industry. International Journal of Science and Engineering Investigations, 10(113), 49-60. Retrieved from http://www.ijsei.com/papers/ijsei-1011321-08.pdf
Khan, M. A., Khaskheli, S. A., Kalwar, H. A., Kalwar, M. A., Marri, H. B., & Nebhwani, M. (2021a). Application of MultiServer Queuing Model to Analyzethe Queuing System of OPD During COVID-19 Pandemic: A Case Study. Journal of Contemporary Issues in Business and Government, 27(05), 1351-1367. https://doi.org/10.47750/cibg.2021.27.05.094
Khan, M. A., Khaskheli, S. A., Kalwar, H. A., Kalwar, M. A., Marri, H. B., & Nebhwani, M. (2021b). Improving the Performance of Reception and OPD by Using Multi-Server Queuing Model in Covid-19 Pandemic. International Journal of Science and Engineering Investigations, 10(113), 20-29.
Khaskheli, S. A., Marri, H. B., Nebhwani, M., Khan, M. A., & Ahmed, M. (2020). Compartive Study of Queuing Systems of Medical Out Patient Departments of Two Public Hospitals. Proceedings of the International Conference on Industrial Engineering and Operations Management, 2702-2720. Dubai, UAE. Retrieved from http://www.ieomsociety.org/ieom2020/papers/177.pdf
Kriri, Q. M. (2018). 8vh ri /lqhdu 3urjudpplqj iru 2swlpdo 3urgxfwlrq lq d 3urgxfwlrq /lqh lq 6dxgl )rrg &r. International Scholarly and Scientific Research & Innovation, 12(3), 467-471.
Maurya, V. N., Misra, R. B., Anderson, P. K., & Shukla, K. K. (2015). Profit Optimization Using Linear Programming Model: A Case Study of Ethiopian Chemical Company. American Journal of Biological and Environmental Statistics, 1(2), 51-57.
Nawrocki, D. (2013). VBA Programming Techniques in Operations Research. 26th International Conference on Technology in Collegiate Mathematics VBA, 255-263.
Solaja, O., Abiodun, J., Abioro, M., Ekpudu, J., & Olasubulumi, O. (2019). Application of linear programming in production planning. International Journal of Applied Operational Research, 9(3), 11-19.
Tesfaye, G., Berhane, T., Zenebe, B., & Asmelash, S. (2016). A Linear Programming Method to Enhance Resource Utilization Case. International Journal for Quality Research, 10(2), 421-432. https://doi.org/10.18421/IJQR10.02-12 A
Workie, G., Alemu A, & Asmelash, S. (2016). Application of Linear Programming Techniques to Determine the Type and Quantity of Textile Dyed Fabrics. TIJ's Research Journal of Science & IT Management - RJSITM, 05(10), 18-25.
Woubante, G. W. (2017). The Optimization Problem of Product Mix and Linear Programming Applications: Case Study in the Apparel Industry. Open Science Journal, 2(2), 1-11. https://doi.org/10.23954/osj.v2i2.853
Yoanita, N. S. (2016). Optimizing Product Combination to Maximize Profit by Using Linear Programming. President University.
Yu, S. (2015). Applied research of enterprise cost control based on linear programming. MATEC Web of Conferences, 25, 1-5. https://doi.org/10.1051/matecconf/20152503012
Yue, X. (2013). A Linear Programming Model and Partial Budget Analysis To Optimize Management Strategies of Western Flower Thrips in Greenhouse Impatiens Poduction. Louisiana State University.
This journal is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Licencse