Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study
Microsoft Excel is used to carry out reporting tasks in small and medium companies across the globe. Most people make reports manually in Microsoft Excel and the manual work takes a tremendous amount of time. The manual work can be easily automated with some effort in Microsoft Excel. This research...
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universidad Politécnica de Valencia
2023-06-01
|
| Series: | WPOM : Working Papers on Operations Management |
| Subjects: | |
| Online Access: | https://polipapers.upv.es/index.php/WPOM/article/view/18697 |
| _version_ | 1797778282271211520 |
|---|---|
| author | Muhammad Ahmed Kalwar Muhammad Ali Khan Asif Nawaz Wassan Zuhaib Phul Shakeel Ahmed Shaikh Hussain Bux Marri |
| author_facet | Muhammad Ahmed Kalwar Muhammad Ali Khan Asif Nawaz Wassan Zuhaib Phul Shakeel Ahmed Shaikh Hussain Bux Marri |
| author_sort | Muhammad Ahmed Kalwar |
| collection | DOAJ |
| description | Microsoft Excel is used to carry out reporting tasks in small and medium companies across the globe. Most people make reports manually in Microsoft Excel and the manual work takes a tremendous amount of time. The manual work can be easily automated with some effort in Microsoft Excel. This research is about the automation of report that was used to be made manually in Microsoft Excel.The present research is an extension of the previously conducted research (Kalwar, Shahzad, et al., 2022). The manual process to make the post-order costing analysis report in MS excel requires a lot of user time (22.80 minutes, just if there is a single order of only one article with one color), with the greater possibility of human error. Employees in ananonymous footwear company in Lahore used to generate the post-order costing report manually in Excel.Due to the above-mentioned reasons, it was proposedto automate the report using visual basic for applications (VBA) in Microsoft Excel.The planning and costing departmentof the company provided every single step required to make the report manually. A time study was conducted for each stepof report preparation using the stopwatch. VBA macros were programmed for automating all manual report-related processes in excel andthe accuracy of the report was also verified. After the report was automated, the time study was again conducted to measure the execution time after each click. A comparison of both methods indicated that the report automation saved 83.18% of employees' time Additionally, the automated method resulted in an error-free report, and the employee`sworkload was reducedas well. |
| first_indexed | 2024-03-12T23:15:59Z |
| format | Article |
| id | doaj.art-fd56d75d375745139b0823a186ca08b3 |
| institution | Directory Open Access Journal |
| issn | 1989-9068 |
| language | English |
| last_indexed | 2024-03-12T23:15:59Z |
| publishDate | 2023-06-01 |
| publisher | Universidad Politécnica de Valencia |
| record_format | Article |
| series | WPOM : Working Papers on Operations Management |
| spelling | doaj.art-fd56d75d375745139b0823a186ca08b32023-07-17T11:04:20ZengUniversidad Politécnica de ValenciaWPOM : Working Papers on Operations Management1989-90682023-06-0114210113610.4995/wpom.1869717887Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case StudyMuhammad Ahmed Kalwar0Muhammad Ali Khan1Asif Nawaz Wassan2Zuhaib Phul3Shakeel Ahmed Shaikh4Hussain Bux Marri5Shafi Private LimitedMehran University of Engineering and Technology Mehran University of Engineering and Technology Sindh Madressatul Islam University Mehran University of Engineering and TechnologyShaheed Benazir Bhutto University Microsoft Excel is used to carry out reporting tasks in small and medium companies across the globe. Most people make reports manually in Microsoft Excel and the manual work takes a tremendous amount of time. The manual work can be easily automated with some effort in Microsoft Excel. This research is about the automation of report that was used to be made manually in Microsoft Excel.The present research is an extension of the previously conducted research (Kalwar, Shahzad, et al., 2022). The manual process to make the post-order costing analysis report in MS excel requires a lot of user time (22.80 minutes, just if there is a single order of only one article with one color), with the greater possibility of human error. Employees in ananonymous footwear company in Lahore used to generate the post-order costing report manually in Excel.Due to the above-mentioned reasons, it was proposedto automate the report using visual basic for applications (VBA) in Microsoft Excel.The planning and costing departmentof the company provided every single step required to make the report manually. A time study was conducted for each stepof report preparation using the stopwatch. VBA macros were programmed for automating all manual report-related processes in excel andthe accuracy of the report was also verified. After the report was automated, the time study was again conducted to measure the execution time after each click. A comparison of both methods indicated that the report automation saved 83.18% of employees' time Additionally, the automated method resulted in an error-free report, and the employee`sworkload was reducedas well.https://polipapers.upv.es/index.php/WPOM/article/view/18697macrosvba programmingreport automationreporting efficiency |
| spellingShingle | Muhammad Ahmed Kalwar Muhammad Ali Khan Asif Nawaz Wassan Zuhaib Phul Shakeel Ahmed Shaikh Hussain Bux Marri Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study WPOM : Working Papers on Operations Management macros vba programming report automation reporting efficiency |
| title | Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study |
| title_full | Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study |
| title_fullStr | Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study |
| title_full_unstemmed | Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study |
| title_short | Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study |
| title_sort | automation of post order costing analysis by using visual basic for applications in microsoft excel a case study |
| topic | macros vba programming report automation reporting efficiency |
| url | https://polipapers.upv.es/index.php/WPOM/article/view/18697 |
| work_keys_str_mv | AT muhammadahmedkalwar automationofpostordercostinganalysisbyusingvisualbasicforapplicationsinmicrosoftexcelacasestudy AT muhammadalikhan automationofpostordercostinganalysisbyusingvisualbasicforapplicationsinmicrosoftexcelacasestudy AT asifnawazwassan automationofpostordercostinganalysisbyusingvisualbasicforapplicationsinmicrosoftexcelacasestudy AT zuhaibphul automationofpostordercostinganalysisbyusingvisualbasicforapplicationsinmicrosoftexcelacasestudy AT shakeelahmedshaikh automationofpostordercostinganalysisbyusingvisualbasicforapplicationsinmicrosoftexcelacasestudy AT hussainbuxmarri automationofpostordercostinganalysisbyusingvisualbasicforapplicationsinmicrosoftexcelacasestudy |