Automation of Post-Order Costing Analysis by Using Visual Basic for Applications In Microsoft Excel: a Case Study
[EN] 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 rese...
| Autores: | , , , , , |
|---|---|
| Tipo de recurso: | artículo |
| Fecha de publicación: | 2023 |
| País: | España |
| Institución: | Universitat Politècnica de València (UPV) |
| Repositorio: | RiuNet. Repositorio Institucional de la Universitat Politécnica de Valéncia |
| Idioma: | inglés |
| OAI Identifier: | oai:riunet.upv.es:10251/195717 |
| Acceso en línea: | https://riunet.upv.es/handle/10251/195717 |
| Access Level: | acceso abierto |
| Palabra clave: | Macros VBA programming Report automation Reporting efficiency |
| Sumario: | [EN] 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 an anonymous 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 step of report preparation using the stopwatch. VBA macros were programmed for automating all manual report-related processes in Excel and the 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`s workload was reduced as well. |
|---|