Capacity report automation for capacity planning

Abstract

Technology has been incorporated into many organisations for their day to day operations. Automation has become the main efficiency and cost saving initiative at this point of time. This study attempted to automate the Capacity Reporting process for DTE Sdn Bhd and produce a prototype of the automated report. The preliminary study found that employees were manually processing data using Excel, which took up a lot of time and was error prone. The prototype was designed to download data directly from multiple sources and then created as a report in the reporting platform. The prototype was developed by combining Waterfall and Prototyping Software Development Life Cycle methodologies. The prototype was then validated by comparing the data with the manual process. The automated process had less than 1% discrepancy and reduced the time taken to produce a report by more than half. The Capacity Reporting team reported that overall efficiency and accuracy improved after the implementation of the automated report.