Development of linear programming model for optimization of product mix and maximization of profit: case of leather industry

Authors

  • Muhammad Ahmed Kalwar Shafi Private Limited
  • Muhammad Ali Khan Mehran UET http://orcid.org/0000-0003-3956-3698
  • Muhammad Faisal Shahzad UET
  • Muzamil Hussain Wadho BBSUTSD
  • Hussain Bux Marri BBSUTSD

DOI:

https://doi.org/10.4995/jarte.2022.16391

Keywords:

Linear programing, profit, maximization, modelling, mathematics

Abstract

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.

Downloads

Download data is not yet available.

Author Biographies

Muhammad Ahmed Kalwar, Shafi Private Limited

Assistant Manager, Production

Muhammad Ali Khan, Mehran UET

Assistant Professor,Industrial Engineering & Management, Faculty of Engineering

Muhammad Faisal Shahzad, UET

Assistant Professor,Industrial & Management Engineering, Faculty of Engineering

Muzamil Hussain Wadho, BBSUTSD

Assistant Professor, Electrical Engineering, Faculty of Engineering

Hussain Bux Marri, BBSUTSD

Meritorious Professor & Dean Faculty of Engineering Technology

References

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.

Downloads

Published

2022-01-31

Issue

Section

Articles