The Development of a KPI and Metallurgical Accounting Systems at Nabalco

During September 2000, Nabalco management identified the need for a corporate system to deliver its key performance indicators (KPIs). In June 2001, a need was also identified to replace the existing metallurgical accounting system. After a review of the technologies available, the decision was made to develop the systems in-house, in preference to purchasing commercial software packages. This would allow much greater control over the structure, and provide for an iterative, concurrent development process between software and key business developers. This has proven invaluable in the development process. The purpose of the KPI system is to provide a unified reporting tool for all performance indicators. These indicators include production, safety, health and environment, personnel, costs, continuous improvement initiatives and opportunity losses. All of these disparate measurements are brought together into the KPI system and used to determine the performance for each department or area. The general principles of the balanced scorecard business approach (Kaplan and Norton, 1996) are applied to achieve a performance measurement for each area within Nabalco. The new metallurgical accounting system (MA) is a SQLServer database with web page and Excel interfaces. The database is structured around daily inputs of all measurements and calculations. The data is stored and adjustments and reconciliations can be made to this data as required. The focus is on accounting rigour, with all adjustments recorded in the database to allow for full auditing. The structure of the data focuses on the five input/output streams (bauxite in, caustic soda in, fuel oil in, residue out, and alumina out). In-circuit inventory provides a secondary measurement on which to check and calibrate the MA system. The KPI and MA systems were developed using Web technologies and are available to any internet-enabled device with Internet Explorer installed. This removes the need for software rollouts and user training. This will promote the wide use of the systems throughout Nabalco and Alcan.