Improvement of Program Staffing Management Activity by Application of Excel Macro Automation Tool

Abstract

The fast-growing IT/ consulting industry and evolving technology demands automating the recurring processes and thereby improvising the system efficiency. In organizations, recurring activities executed manually consume human efforts. Staffing management is one of those activities which play significant role in success of the project. Right availability of resource in right capacity for right duration is essential for staffing management. In some organizations, it is done by manually by using Microsoft Excel. To automate these processes major automation tools like Excel Macro, MS Automate are readily available. In this paper, the selection of automation tool using MCDM and application of tool to improvise and automate the process is explained in sufficient detail. The three constraints of effective program management are time, cost, and quality. The staffing management process is exhaustive, time consuming, lengthy, and increases the chance of occurrence of multiple errors. To make the process effective and efficient, it is necessary to reduce manual effort and hence automating staffing management process can be beneficial. The automation tool uses the Excel Macros (VBA) to identify the staffing of each resource. Therefore, the automation tools used in this paper helps in reducing human errors and determines the status of the staffing for each resource-overstaffed, understaffed, unaligned and optimally staffed. The outcome of the application of automation tool in program/ space management tool leads to effectiveness and improved efficiency of the space/ program.