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

Kalwar, Muhammad Ahmed; Khan, Muhammad Ali; Shahzad, Muhammad Faisal; Wadho, Muzamil Hussain; Marri, Hussain Bux

doi:10.4995/jarte.2022.16391

Cited by 4 publications

(1 citation statement)

References 12 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…With the advent of new technology, companies are required to innovate their processes and technology [13], [14]. Essentially, the printing industry is based on a maketo-order production system that makes customized products [15].…”

Section: Literature Reviewmentioning

confidence: 99%

Cost and Benefit Analysis of Newly Installed Digital Printing Department by Using System Dynamics Modeling Technique

2024

jjmie

View full text Add to dashboard Cite

After the establishment of any facility, it is quite necessary to determine the profitability of the unit. The present research provides a detailed analysis of the case unit along with the necessary costs and returns on investment. This research paper also includes the cost and benefits analysis of a newly installed digital printing department at Sapphire Diamond Company. Since the relationship between fabric printing and most of the costs is non-linear, this is the reason the system dynamics modelling technique was used in the present research; it was used to model the requirement of material, electricity, and human resources. The model was developed by using the stocks, flows, variables, and parameters in the Anylogic PLE version and the simulated results were validated from the real-time scenario. The data regarding the labour cost, electricity cost, and material cost were collected from the case department. Furthermore, the scenario analysis was conducted and simulated results were downloaded in Microsoft Excel. Several line charts were plotted in Microsoft Excel and Origin software. It was indicated from the scenario analysis that the cost per meter decreased by increasing the production rate. It was also indicated that if the digital printing machine was operated at its maximum capacity, the ROI would be maximum. Incurred overheads were also the subject of concern in the present scenario. After the overall analysis, it was concluded that the digital printing facility was still in profit even if its production rate per day was 150+50. Since the present research encompasses the detailed cost and benefit analysis of a newly installed digital printing facility, therefore, it can be beneficial for investors as analytical support to decide on installing digital textile printing machines.

show abstract

Section: Literature Reviewmentioning

confidence: 99%

Cost and Benefit Analysis of Newly Installed Digital Printing Department by Using System Dynamics Modeling Technique

2024

jjmie

View full text Add to dashboard Cite

show abstract

Solution of Goal Programming Product Mix Problem with Cohort Intelligence Algorithm

Nargundkar,

Kulkarni,

Pande

2024

Intelligent Systems for Smart Cities

View full text Add to dashboard Cite

Automation of production plan generating workbook at leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel

Kalwar,

Wassan,

Khan

et al. 2023

J APPL RES TECH ENG

View full text Add to dashboard Cite

In Small and Medium Enterprises (SMEs), all the reporting tasks are carried out in Microsoft Excel. The employees spend all of their time working on the reports and in the case of an error in the report; a tremendous amount of their time is incurred on the detection of that error. At one of the leather footwear companies in Lahore, Pakistan, report automation was carried out using visual basic for Application (VBA) in Microsoft Excel. The purpose of automation was to increase the reporting efficiency and minimize the chance of error. The authors automated the generation of production plan papers, which used to take 3.11 minutes to be made per plan paper. 3.11 minutes were required just for a single order of only one footwear article). This research provides the framework for the automation of manual reporting in Microsoft Excel. This automation was conducted by using VBA in Microsoft Excel. In the VBA code, the loops and conditional statements were used to program the manual activities to be performed in the report. Initially, the manual method was demonstrated in detail then way of report automation was the focus of discussion. The comparison of both methods was conducted in terms of time utilization. The manual method encompassed a series of activities whereas; the automated template included the buttons with few clicks. A time study of report-making by manual and automated method was conducted which indicated that the automated method was 1.36 minutes faster than the manual method. This research contributes to the provision of a detailed framework, with the help of which any manual work in Microsoft Excel can be automated. It was also indicated by this research that SMEs who cannot afford the implementation of Enterprise Resource Planning (ERP) software, have the option of VBA in Microsoft Excel by which they can enhance their reporting efficiency and office employees` productivity.

show abstract

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

Cited by 4 publications

References 12 publications

Cost and Benefit Analysis of Newly Installed Digital Printing Department by Using System Dynamics Modeling Technique

Cost and Benefit Analysis of Newly Installed Digital Printing Department by Using System Dynamics Modeling Technique

Solution of Goal Programming Product Mix Problem with Cohort Intelligence Algorithm

Automation of production plan generating workbook at leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel

Contact Info

Product

Resources

About