- -

Automation of Production Plan Generating Workbook at Leather Footwear Company of Lahore Pakistan by Using VBA in Microsoft Excel

RiuNet: Repositorio Institucional de la Universidad Politécnica de Valencia

Compartir/Enviar a

Citas

Estadísticas

  • Estadisticas de Uso

Automation of Production Plan Generating Workbook at Leather Footwear Company of Lahore Pakistan by Using VBA in Microsoft Excel

Mostrar el registro completo del ítem

Kalwar, MA.; Wassan, AN.; Khan, MA.; Wadho, MH.; Shaikh, SA.; Marri, HB. (2023). Automation of Production Plan Generating Workbook at Leather Footwear Company of Lahore Pakistan by Using VBA in Microsoft Excel. Journal of Applied Research in Technology & Engineering. 4(2):111-129. https://doi.org/10.4995/jarte.2023.18941

Por favor, use este identificador para citar o enlazar este ítem: http://hdl.handle.net/10251/195354

Ficheros en el ítem

Metadatos del ítem

Título: Automation of Production Plan Generating Workbook at Leather Footwear Company of Lahore Pakistan by Using VBA in Microsoft Excel
Autor: Kalwar, Muhammad Ahmed Wassan, Asif Nawaz Khan, Muhammad Ali Wadho, Muzammil Hussain Shaikh, Shakeel Ahmed Marri, Hussain Bux
Fecha difusión:
Resumen:
[EN] 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 ...[+]
Palabras clave: Production , Automatic production , Microsoft Excel , VBA , Enterprise Resource Planning (ERP) , Plan papers , Visual basic for applications , Macros
Derechos de uso: Reconocimiento - No comercial - Compartir igual (by-nc-sa)
Fuente:
Journal of Applied Research in Technology & Engineering. (eissn: 2695-8821 )
DOI: 10.4995/jarte.2023.18941
Editorial:
Universitat Politècnica de València
Versión del editor: https://doi.org/10.4995/jarte.2023.18941
Tipo: Artículo

References

Abidin, I. Z., Juahir, H., Azid, A., Mustafa, A. D., & Azaman, F. (2015). Application of Excel-VBA for computation of water quality index and air pollutant index. Malaysian Journal of Analytical Sciences, 19(5), 1056-1064.

Abraham, R., Burnett, M., & Erwig, M. (2008). Spreadsheet Programming. In Wiley Encyclopedia of Computer Science and Engineering. https://doi.org/10.1002/9780470050118.ecse415

Ahmadi, A., Robinson, P. H., Elizondo, F., & Chilibroste, P. (2018). Implementation of CTR dairy model using the visual basic for application language of Microsoft excel. International Journal of Agricultural and Environmental Information Systems, 9(3), 74-86. https://doi.org/10.4018/IJAEIS.2018070105 [+]
Abidin, I. Z., Juahir, H., Azid, A., Mustafa, A. D., & Azaman, F. (2015). Application of Excel-VBA for computation of water quality index and air pollutant index. Malaysian Journal of Analytical Sciences, 19(5), 1056-1064.

Abraham, R., Burnett, M., & Erwig, M. (2008). Spreadsheet Programming. In Wiley Encyclopedia of Computer Science and Engineering. https://doi.org/10.1002/9780470050118.ecse415

Ahmadi, A., Robinson, P. H., Elizondo, F., & Chilibroste, P. (2018). Implementation of CTR dairy model using the visual basic for application language of Microsoft excel. International Journal of Agricultural and Environmental Information Systems, 9(3), 74-86. https://doi.org/10.4018/IJAEIS.2018070105

Arain, Muhammad Waqas; Rahoo, N., Thebo, J. A., Khan, M. A., & Rahoo, L. A. (2021). Emotional Intelligence and Job Satisfaction among Faculty Members of Higher Education Institutions of Pakistan. Journal of Contemporary Issues in Business and Government (CIBG), 27(6), 509-515.

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 (IJBEMS), 7(1), 15-30. Retrieved from https://www.ijbems.com/doc/IJBEMS-137.pdf

Arshad, S., Rehman, H. A., Rahoo, L. A., & Nagar, M. A. K. (2018). Information Communication Technology Applications used to Enhance Knowledge Management in the University Libraries of Pakistan. Proceedings of IEEE 5th International Conference on Engineering Technologies and Applied Sciences (ICETAS), 1-6. Retrieved from https://ieeexplore.ieee.org/document/8629133/ https://doi.org/10.1109/ICETAS.2018.8629133

Baladi, N., Channar, P. B., Rahoo, L. A., Ahmed, T., & Khan, M. A. (2021). Improve Customer Retention through Service Quality Attributes in the Restaurant Industry of Pakistan. Journal of Contemporary Issues in Business and Government (CIBG), 27(6), 331-340. Retrieved from https://www.cibgp.com/article_12147_76fd80af7f9013320f57d25d1cfccea1.pdf

Balson, D. (2012). User Defined Spreadsheet Functions in Excel. Proceedings of EuSpRIG 2012 Conference "The Science of Spreadsheet Risk Management.

Bartoszewicz, G., & Wdowicz, M. (2019). Automation of the Process of Reporting the Compliance of the Production Plan with Its Execution Based on Integration of SAP ERP System In Connection With Excel Spreadsheet and VBA Application. In Digitalization of Supply Chains. https://doi.org/10.17270/B.M.978-83-66017-86-3

Belchior Junior, A., Bruel, R. N., Andrade, D. A., Sabundjian, G., Macedo, L. A., Angelo, G., … Conti, T. N. (2011). Development of a Vba Macro-Based Spreadsheet Application for Relap5 Data Post-Processing. International Nuclear Atlantic Conference, 978-985.

Blattner, D. E., & Valrico, F. (2007). Patent No. US 2007/0055688 A1. United States.

Blayney, P. J., & Sun, Z. (2019). Using Excel and Excel VBA for Preliminary Analysis in Big Data Research. In Managerial Perspectives on Intelligent Big Data Analytics. IGI Global (pp. 110-136). https://doi.org/10.4018/978-1-5225-7277-0.ch007

Botchkarev, A. (2015). Assessing Excel VBA Suitability for Monte Carlo Simulation. 1-30.

Broman, K. W., Woo, K. H., & Woo, K. H. (2017). Data organization in spreadsheets Data organization in spreadsheets and (Vol. 1305). https://doi.org/10.1080/00031305.2017.1375989

Bukhsh, M., Khan, M. A., Zaidi, I. H., Yaseen, R., Khalid, A., Razzaque, A., & Ali, M. (2021). Productivity Improvement in Textile Industry using Lean Manufacturing Practice of Single Minute Die Exchange ( SMED ). Proceedings of the 11th Annual International Conference on Industrial Engineering and Operations Management Singapore, March 7-11, 2021. Retrieved from http://www.ieomsociety.org/singapore2021/papers/1282.pdf

Chatvichiencha, S. (2015). Enhancing Computational Thinking by Excel-VBA Based Problem Solving. The 2nd International Conference on Innovation in Education, 284-290.

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. Retrieved from http://www.ijsei.com/papers/ijsei-1011121-02.pdf

Cirujano, J., & Zhu, Z. (2013). Automatic reporting for manpower resources. Proceedings, Annual Conference - Canadian Society for Civil Engineering, 1(January), 710-719.

Ding, H.-L., Qi, K.-Y., Zhaq, X.-L., & Xu, G.-F. (2017). Tibetan Typographical Specifications and Technical Realization Based on Word VBA. 4th International Conference on Advanced Education and Management, 407-412. https://doi.org/10.12783/dtssehs/icaem2017/19117

Dunn, A. (2009). Automated Spreadsheet Development. In arXiv preprint arXiv (pp. 908-928).

Evensen, H. T. (2014). A versatile platform for programming and data acquisition: Excel and Visual Basic for Applications. ASEE Annual Conference and Exposition. https://doi.org/10.18260/1-2--20017

Fisher, M., Cao, M., Rothermel, G., Cook, C.R., & Burnett, M.M. (2002). Automated Test Case Generation for Spreadsheets.

th International Conference on Software Engineering, 141–153. https://doi.org/10.1145/581356.581359

Harahap, M. I. P., & Azmi, M. H. (2017). Development of Excel Vba Program for Small Drainage Network. E-Academia Journal, 6(1), 216-227.

Hila, R. (2009). Water Quality Data Management Database.

Iftikhar, Z., Khan, M. A., Kumar, R., Bux, K., & Haseeb, A. (2021). Productivity Improvement of Garments Industry by Assembly Line Technique of Lean Manufacturing. Proceedings (Abstract) of the International Conference on Industrial & Mechanical Engineering and Operations Management Dhaka, Bangladesh, December 26-27, 2021., 908. Retrieved from https://ieomsociety.org/proceedings/2021dhaka/497.pdf

Iftikhar, Z., Khan, M. A., Soomro, A. S., Kumar, R., Bux, K., Haseeb, A., & Naz, A. (2022). Productivity Improvement of Assembly Line in Textile Stitching Unit by Lean Techniques of Line Balancing and Time and Motion Study. International Journal of Science and Engineering Investigations (IJSEI), 11(127), 51-60. Retrieved from http://www.ijsei.com/papers/ijsei-1112722-07.pdf

Iftikhar, Z., Kumar, R., Bux, K., Haseeb, A., Khan, M. A., Naz, A., … Soomro, A. S. (2022). Lean Manufacturing Tools and Techniques for the Productivity Improvement in Assembly Lines Operations of Industries. International Research Journal of Modernization in Engineering Technology and Science, 4(7), 4554-4562. Retrieved from https://www.irjmets.com/uploadedfiles/paper//issue_7_july_2022/28986/final/fin_irjmets1663258443.pdf

Jaleel, N., Khan, M. A., Jamal, M., Safeeruddin, M., Shajee, M. M., & Mughal, U. (2021). Productivity Improvement by Lean Methodologies at Dyeing & Printing Plant. Proceedings (Abstract) of the International Conference on Industrial & Mechanical Engineering and Operations Management Dhaka, Bangladesh, December 26-27, 2021., 905. Retrieved from https://ieomsociety.org/proceedings/2021dhaka/495.pdf

Junejo, I., Kumar, D., Khan, M.A., Rahoo, L.A., & Ahmed, J. (2023). Use Of E-Commerce During Covid-19 And Purchase Intention: The Mediating Role Of Social Norms. Journal of Positive School Psychology, 7(2), 959-974.

Junejo, I., Qureshi, F., & Khan, M.A. (2023). Medating role of environmental education for sustainable supply chain performance: empirical evidence from chemical companies in Pakistan. Etikonomi, 22(1), 131-142. https://doi.org/10.15408/etk.v22i1.27139

Kalhoro, Maryam;, Abro, Q.-A., Kalhoro, S., Rahoo, L. A., & Khan, M. A. (2018). ICT Integration in Teaching and Learning at Secondary Schools A Case of Sindh Province Pakistan. Proceedings (Abstract) of International Conference on Innovations in Teaching and Learning (ICITL), 25-26 June, 2018, Virtual University,Pakistan. Retrieved from https://icitl.vu.edu.pk/Download/Conference Program.pdf

Kalhoro, Maryam, Abro, Q.-A., Shaikh, R. A., Nagar, M. A. K., Kalhoro, S., Rahoo, L. A., & Zaidi, S. A. R. (2018). Customer satisfaction in commercial bank of Sindh province a case study of bank Al Falah. Proceedings (Abstract) of IEEE International Conference on Innovative Research and Development (ICIRD 2018), Bangkok, Thailand.

Kalhoro, Maryam;, Khan, M. A., Kalhoro, S., & Rahoo, L. A. (2019). Customer satisfaction in commercial bank of Sindh province a case study of bank Al Falah. Journal of Library Philosophy and Practice, 2331(May), 1-13. Retrieved from https://core.ac.uk/download/pdf/215161146.pdf

Kalwar, M.A., & Khan, M.A. (2020a). Optimization of Procurement & Purchase Order Process in Foot Wear Industry by Using VBA in Ms Excel. International Journal of Business Education and Management Studies (IJBEMS), 6(1), 213-220. https://ijbems.com/doc/IJBEMS-124.pdf

Kalwar, M.A., & Khan, M.A. (2020b). Increasing performance of footwear stitching line by installation of auto-trim stitching machines. Journal of Applied Research in Technology & Engineering (JARTE), 1(1), 31. https://doi.org/10.4995/jarte.2020.13788

Kalwar, M.A., & Khan, M.A. (2020c). Optimization of Procurement & Purchase Order Process in Foot Wear Industry by Using VBA in Ms Excel. International Journal of Business Education and Management Studies (IJBEMS), 5(2), 80-100. https://ijbems.com/doc/IJBEMS-84.pdf

Kalwar, M.A., Khan, M.A., Phul, Z., Wadho, M.H., Shahzad, M.F., & Marri, H.B. (2022). The analysis of performance before and after ERP implementation: a case of a manufacturing company. Journal of Applied Research in Technology & Engineering, 3(2), 115-121. https://doi.org/10.4995/jarte.2022.17789

Kalwar, M.A., Khan, M.A., Shahzad, M.F., Wadho, M.H., & Marri, H.B. (2022). Development of linear programming model for optimization of product mix and maximization of profit: case of leather industry. Journal of Applied Research in Technology & Engineering (JARTE), 3(1), 67-78. https://doi.org/10.4995/jarte.2022.16391

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 (IJBEMS), 3(1), 1-22. https://ijbems.com/doc/IJBEMS-159.pdf

Kalwar, M.A., Shahzad, M.F., Wadho, M.H., Khan, M.A., & Shaikh, S.A. (2022). Automation of order costing analysis by using Visual Basic for applications in Microsoft Excel. Journal of Applied Research in Technology & Engineering (JARTE), 3(1), 29-59. https://doi.org/10.4995/jarte.2022.16390

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 (IEOM, Dhaka, Bangladesh, December 26-27. https://ieomsociety.org/proceedings/2021dhaka/228.pdf

Kalwar, M.A., Wassan, A.N., Phul, Z., & Wadho, Muzamil Hussain; Malik, Tanveer Sarwar; Khan, M.A. (2023). Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore. Journal of Applied Research in Technology & Engineering (JARTE), 4(1), 13-23. https://doi.org/10.4995/jarte.2023.18776

Karim, A. J. (2011). The Significance of Management Information Systems For Enhancing Strategic And Tactical Planning. Journal of Information Systems and Technology Management, 8(2), 459-470. https://doi.org/10.4301/S1807-17752011000200011

Khan, M.A. (2003). Critical Study of Human Resources Management of Pakistan International Airlines Corporation (PIAC). Bachelor of Engineering (Thesis), Department of Industrial Engineering & Management, Mehran University of Engineering & Technology, Jamshoro, Sindh, Pakistan.

Khan, M.A. (2018). Preliminary Study on Lean Manufacturing Practices at Yarn Manufacturing Industry - A Case Study [Masters of Engineering (Thesis), Department of Industrial Engineering & Management, Mehran University of Engineering & Technology, Jamshoro, Sindh, Pakistan.]. https://doi.org/10.13140/RG.2.2.31557.37609

Khan, K., Khan, M.A., Thebo, J.A., Ahmed, T., & Rahoo, L.A. (2021). Examining The Human Resource Architecture Relationship With Employee Productivity Of Chemical Industries. Journal of Contemporary Issues in Business and Government (CIBG), 27(2), 5847-5856. https://www.cibgp.com/article_11267_91767391154f6eee74a8fa4a1c11a1c6.pdf

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 (JARTE), 2(2), 89. https://doi.org/10.4995/jarte.2021.14786

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 (IJSEI), 10(113), 49-60. http://www.ijsei.com/papers/ijsei-1011321-08.pdf

Khan, M.A., Khatri, A., & Marri, H.B. (2020). Descriptive analysis of lean manufacturing practices in textile industry. Proceedings of the 5th NA International Conference on Industrial Engineering and Operations Management Detroit, Michigan, USA, August 10 - 14, 2020, 3870-3871. http://www.ieomsociety.org/detroit2020/papers/753.pdf

Khan, M.A., Marri, H.B., & Khatri, A. (2020). Exploring The Applications Of Lean Manufacturing Practices In Textile Industry. Proceedings of the International Conference on Industrial Engineering and Operations Management, Dubai, UAE, March 10-12, 2020, 2360-2361. http://www.ieomsociety.org/ieom2020/papers/545.pdf

Khan, M.A., Memon, M.S., & Soomro, A.S. (2020). Exploring the applications of lean manufacturing practices in automobile industry. Proceedings of the 5th NA International Conference on Industrial Engineering and Operations Management Detroit, Michigan, USA, August 10 - 14, 2020, August. http://www.ieomsociety.org/detroit2020/papers/727.pdf

Khan, M.A., Soomro, A.S., Shaikh, S.A., Memon, M.S., & Marri, S. (2020). Lean manufacturing in pakistan: A comprehensive review. Proceedings of the 5th NA International Conference on Industrial Engineering and Operations Management Detroit, Michigan, USA, August 10 - 14, 2020, August. http://www.ieomsociety.org/detroit2020/papers/728.pdf

Kuka, S., & Karamani, B. (2011). Using Excel and VBA for Excel to Learn Numerical Methods. 1st International Sympsosium on Computing in Informatics and Mathematics, 365-376.

Kumar, R., Iftikhar, Z., Bux, K., Haseeb, A., Khan, M.A., Naz, A., Hassam;, & Shaikh, S.A. (2022). Optimization of Fitted Sheet Set Assembly Line at Garments Industry by Lean Manufacturing Techniques and SAM Analysis. International Research Journal of Modernization in Engineering Technology and Science (IRJMETS), 4(10), 1634-1647. https://www.irjmets.com/uploadedfiles/paper//issue_10_october_2022/30821/final/fin_irjmets1667794675.pdf

Kumar, S., Khan, M.A., Ahmed, S., Rehman, A., & Luhar, E. (2020). A Case Study for Performance Evaluation of Motorcycle Assembly Line through the Lean Manufacturing Practice of Overall Equipment Effectiveness ( OEE ). Proceedings of the International Conference on Industrial Engineering and Operations Management Dubai, UAE, March 10-12, 2020, 1622-1623. http://www.ieomsociety.org/ieom2020/papers/192.pdf

Lessa, J. D. R., Lessa, P. F. R., Almeida, P. A., Junior, M., & Guimarães, H. de V. (2016). Mathematical Model and Programming in VBA Excel for Package Calculation. International Journal of Engineering Research and Applications, 6(5), 55-61.

Memon, D. A., Tanwari, A., Siddiqui, A. A., Kalwar, M. A., & Siddiqui, S. (2018). Impact of Age and Experience on the Salary Expectation and Recognition of Employees. Professional Trends in Industrial and Systems Engineering (PTISE), 119-127. UET, Peshawar.

Memon, M., Khan, M. A., & Rahoo, L. A. (2020). Usage and Availability of Information and Communication Technology Applications Facilities at Central Library. International Research Journal in Computer Science and Technology (IRJCST), 1(1), 86-92. Retrieved from http://irjcst.com/index.php/irjcst/article/view/7/6

Minto, C. F. (2009). PKPD Tools for Excel.

Nagar, M. A. K., Rahoo, L. A., Rehman, H. A., & Arshad, S. (2018). Education management information systems in the primary schools of sindh a case study of hyderabad division. 2018 IEEE 5th International Conference on Engineering Technologies and Applied Sciences (ICETAS), 1-5. IEEE. Retrieved from https://ieeexplore.ieee.org/document/8629249 https://doi.org/10.1109/ICETAS.2018.8629249

Norton, T., & Tiwari, B. (2013). Aiding the understanding of novel freezing technology through numerical modelling with visual basic for applications (VBA). Computer Applications in Engineering Education, 21(3), 530-538. https://doi.org/10.1002/cae.20498

Perry, K. M. (2012). The Call Center Scheduling Problem using Spreadsheet Optimization and VBA. Virginia Commonwealth University.

Porter, D., & Stretcher, R. (2012). Automating Markowitz Optimizations Using VBA. Journal of Instructional Techniques in Finance, 4(1), 9-16.

Rahoo, L.A., Channar, P.B., & Khan, M.A. (2020). Analysis of Stress on the Employees of Software Development Industries of Pakistan. International Research Journal in Computer Science and Technology (IRJCST), 1(1), 6-12. http://irjcst.com/index.php/irjcst/article/view/2/1

Rahoo, L.A., Hasnain, P., Abbasi, A.M., Ahmed, T., & Khan, M.A. (2021). The relationship between information technology and organizational culture in the university libraries of Sindh, Pakistan. Journal of Contemporary Issues in Business and Government Vol, 27(2). https://www.cibgp.com/article_10816_ff2852c7bcdca4f3c72857a4da607bbe.pdf

Rahoo, L.A., Khan, S.A., Khan, M.A., Khan, K., & Memon, M. (2020). Analysis of green HR practices in information technology industries of Pakistan. International Journal of Disaster Recovery and Business Continuity, 11(1), 2105-2113. http://sersc.org/journals/index.php/IJDRBC/article/view/26727

Rahoo, L.A., Ramejo, B., & Naqvi, Syed Sohail Abbas Khan, Muhammad Ali Ramejo, M.A. (2021). Analysis of Public Awareness on Adaptation to Covid-19 Vaccination during Pandemic Situation in Pakistan. Turkish Journal of Physiotherapy and Rehabilitation (TJPR), 32(3), 21156-21163

Rajput, S., Khan, M. A., Samejo, S., Murtaza, G., & Ali, R. A. (2020). Productivity Improvement by the Implementation of lean manufacturing practice ( takt time ) in an automobile assembling plant. Proceedings of the International Conference on Industrial Engineering and Operations Management Dubai, UAE, March 10-12, 2020, 1618-1619. Retrieved from http://www.ieomsociety.org/ieom2020/papers/190.pdf

Raza, M., & Gulwani, S. (2017). Automated data extraction using predictive program synthesis. 31st AAAI Conference on Artificial Intelligence, AAAI 2017, 882-890. https://doi.org/10.1609/aaai.v31i1.10668

Sato, K., & Yokoyama, R. (2001). Teaching Aid for Remote Sensing and Map Imagery Analysis Using Excel Spreadsheet and VBA. 22nd Asian Conference on Remote Sensing.

Sheikh, W.A., Kalwar, M.A., Wassan, A.N., Khan, M.A., Wadho, M.H., Mari, H.B., & Shaikh, S.A. (2022). Opportunities in Circular Economy for End-of-Life ( EOL ) of Electric Vehicle Batteries: A Review. International Journal of Science and Engineering Investigations, 11(127), 38-53. http://www.ijsei.com/papers/ijsei-1112722-06.pdf

Wettlaufer, G. J. (2010). Merlin.Net Automation of External Reports Verification Process (California Polytechnic State University). California Polytechnic State University. https://doi.org/10.1558/jsrnc.v4il.24

Yan, Q., & Wan, Y. (2017). Using the special font and VBA program to make bill of materials in the transmission line engineering. Revista de La Facultad de Ingenieria, 32(2), 335-341.

[-]

recommendations

 

Este ítem aparece en la(s) siguiente(s) colección(ones)

Mostrar el registro completo del ítem