Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore
Small and medium-sized firms in developing countries perform the majority of all reporting tasks in Microsoft excel. The material cost comparative analysis (MCCA) report took the user 58.51 minutes to complete and there was also a higher likelihood of calculation error. The report was created in Mic...
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universitat Politècnica de València
2023-01-01
|
| Series: | Journal of Applied Research in Technology & Engineering |
| Subjects: | |
| Online Access: | http://polipapers.upv.es/index.php/JARTE/article/view/18776 |
| _version_ | 1797937280461045760 |
|---|---|
| author | Muhammad Ahmed Kalwar Asif Nawaz Wassan Zuhaib Phul Muzamil Hussain Wadho Tanveer Sarwar Malik Muhammad Ali Khan |
| author_facet | Muhammad Ahmed Kalwar Asif Nawaz Wassan Zuhaib Phul Muzamil Hussain Wadho Tanveer Sarwar Malik Muhammad Ali Khan |
| author_sort | Muhammad Ahmed Kalwar |
| collection | DOAJ |
| description | Small and medium-sized firms in developing countries perform the majority of all reporting tasks in Microsoft excel. The material cost comparative analysis (MCCA) report took the user 58.51 minutes to complete and there was also a higher likelihood of calculation error. The report was created in Microsoft excel by the Lahore-based ABC footwear business. This used to take a lot of time to produce and there was a higher chance that the report would contain errors. This is because Microsoft excel visual basic for applications was used to automate the report. This report's manual preparation method was compiled by the company’s planning and costing division. Each activity was listed, followed by the completion of a time study. VBA macros were built in Excel to automate all manual report-related tasks and reduce the possibility of human error. Conditional statements were applied to help automated decision-making. To enable command buttons to run macros, one user form was created. There were various worksheets included in the MCA template. The automated template was found to consume only 16.26 minutes and it was quicker than the current technique. |
| first_indexed | 2024-04-10T18:42:11Z |
| format | Article |
| id | doaj.art-cc7695d5b9e94988a17a9bc1932b1f4d |
| institution | Directory Open Access Journal |
| issn | 2695-8821 |
| language | English |
| last_indexed | 2024-04-10T18:42:11Z |
| publishDate | 2023-01-01 |
| publisher | Universitat Politècnica de València |
| record_format | Article |
| series | Journal of Applied Research in Technology & Engineering |
| spelling | doaj.art-cc7695d5b9e94988a17a9bc1932b1f4d2023-02-01T12:55:48ZengUniversitat Politècnica de ValènciaJournal of Applied Research in Technology & Engineering2695-88212023-01-0141132310.4995/jarte.2023.1877617966Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of LahoreMuhammad Ahmed Kalwar0Asif Nawaz Wassan1Zuhaib Phul2Muzamil Hussain Wadho3Tanveer Sarwar Malik4Muhammad Ali Khan5Shafi Private Limited, LahoreMehran UETSindh Madressa-tul-Islam UniversityBBSUTSDStarlet Innovations LimitedMehran UETSmall and medium-sized firms in developing countries perform the majority of all reporting tasks in Microsoft excel. The material cost comparative analysis (MCCA) report took the user 58.51 minutes to complete and there was also a higher likelihood of calculation error. The report was created in Microsoft excel by the Lahore-based ABC footwear business. This used to take a lot of time to produce and there was a higher chance that the report would contain errors. This is because Microsoft excel visual basic for applications was used to automate the report. This report's manual preparation method was compiled by the company’s planning and costing division. Each activity was listed, followed by the completion of a time study. VBA macros were built in Excel to automate all manual report-related tasks and reduce the possibility of human error. Conditional statements were applied to help automated decision-making. To enable command buttons to run macros, one user form was created. There were various worksheets included in the MCA template. The automated template was found to consume only 16.26 minutes and it was quicker than the current technique.http://polipapers.upv.es/index.php/JARTE/article/view/18776material costfootwearshoe costingcost comparison |
| spellingShingle | Muhammad Ahmed Kalwar Asif Nawaz Wassan Zuhaib Phul Muzamil Hussain Wadho Tanveer Sarwar Malik Muhammad Ali Khan Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore Journal of Applied Research in Technology & Engineering material cost footwear shoe costing cost comparison |
| title | Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore |
| title_full | Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore |
| title_fullStr | Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore |
| title_full_unstemmed | Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore |
| title_short | Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore |
| title_sort | automation of material cost comparative analysis report using vba excel a case of footwear company of lahore |
| topic | material cost footwear shoe costing cost comparison |
| url | http://polipapers.upv.es/index.php/JARTE/article/view/18776 |
| work_keys_str_mv | AT muhammadahmedkalwar automationofmaterialcostcomparativeanalysisreportusingvbaexcelacaseoffootwearcompanyoflahore AT asifnawazwassan automationofmaterialcostcomparativeanalysisreportusingvbaexcelacaseoffootwearcompanyoflahore AT zuhaibphul automationofmaterialcostcomparativeanalysisreportusingvbaexcelacaseoffootwearcompanyoflahore AT muzamilhussainwadho automationofmaterialcostcomparativeanalysisreportusingvbaexcelacaseoffootwearcompanyoflahore AT tanveersarwarmalik automationofmaterialcostcomparativeanalysisreportusingvbaexcelacaseoffootwearcompanyoflahore AT muhammadalikhan automationofmaterialcostcomparativeanalysisreportusingvbaexcelacaseoffootwearcompanyoflahore |