Mapping and Data Base Modeling for Public Sector Strategic Enterprise Resource Planning

Abstract

This Enterprise Resource Planning database model provides a systematic, logical and regular basis for the collection, collation, dissemination and mapping of strategic Enterprise Resource Planning data. Selective access to this accurate and timely data will improve public sector strategic Enterprise Resource Planning performance, accountability and administration. It will assist the public sector to be more effective and efficient in resource allocation and investment outcomes measurement, is transparent, and will encourage the development of trust, networks and social capital amongst public sector employees and their suppliers. The model has been successfully demonstrated through the establishment and analysis of an Enterprise Resource Planning data base with the Australian Department of Defence (ADoD). The Australian ADoD is a Federal Government Department with a FY 2008/9 spend of AU$9.3bn on products (goods and services), their support and maintenance, from almost every industry sector, on a global basis. While the implementation of Enterprise Resource Planning is usually viewed as a means of reducing transaction costs, in practice such implementation often increases transaction costs. Public sector bureaucratic hierarchies and their governance systems contribute to transaction costs. This research provides an Enterprise Resource Planning database model so that the public sector can achieve improved field mapping and strategic Enterprise Resource Planning using existing data and resources at lowest transaction cost.