Using technology to enhance capital planning and budgeting: Austin's eCAPRIS project reporting and information system.
Physical infrastructure and facilities are the backbone of government operations This article aims to describe the financial expenditure associated with the operations and processes of world governments of all levels. Size of economic footprint
CAPITAL PLANNING IN AUSTIN
Austin is the state capital of Texas. With more than 640,000 residents, it is the fourth-largest city in the state and the 16th-largest city in the U.S. Austin's vision is "To be the most livable city The Livable City is a normative idea that has been developed to help guide thinking about the way our cities function and develop. Some good definitions of a livable city can be found in Vukan Vuchic's work:
Livabilityin the country." In addition to providing general government services--public safety, recreation and culture, health services health services Managed care The benefits covered under a health contract , etc.--the city also owns and operates an electric utility, a water utility, a drainage utility, a convention center, solid waste service, and an international airport.
The budget office manages the city's capital improvement program, which involves all departments that undertake capital projects as part of their mission and operations. Austin spends approximately $550 million per year on capital projects. The program is funded by a combination of bonds, cash, and grants.
Each spring, in accordance with the city charter, the budget office, working with each of the departments, prepares a five-year capital improvement program plan for review by the Planning Commission Noun 1. planning commission - a commission delegated to propose plans for future activities and developments
commission, committee - a special group delegated to consider some matter; "a committee is a group that keeps minutes and loses hours" - Milton Berle . This plan details spending, appropriation, and funding needs for every planned or ongoing project, as well as project descriptions and locations. The first year of the CIP (1) (Common Isochronous Packet) The packet format used in time-based (real time) FireWire transmission. See FireWire, IEC 61883 and mLAN.
(2) (Common Industrial P becomes the draft for the proposed capital budget, which is presented to the City Council in June of each year. The City Council adopts the annual capital budget, along with the operating budget Noun 1. operating budget - a budget for current expenses as distinct from financial transactions or permanent improvements
budget items, operating cost, operating expense, overhead - the expense of maintaining property (e.g. , in September. The city prepares a quarterly status report on benchmarked capital projects that includes schedules, spending, and status.
A CITYWIDE CIP SYSTEM
In 1997, Austin began its largest-ever annexation annexation, in international law, formal act by which a state asserts its sovereignty over a territory previously outside its jurisdiction. Many kinds of territory have been subject to annexation, chief among them those inhabited by settlers of the annexing power, , encompassing an area of 15,000 acres and 30,000 people. The city's water/wastewater utility--Austin Water Utility--faced the challenge of inventorying and, where necessary, repairing and upgrading infrastructure, per each annexation area's service plan. It quickly became clear that the utility's existing processes for financial management and project management for capital improvement projects needed to be integrated to ensure that the annexation work was completed on time and on budget. To meet this challenge, Austin Water Utility created the City of Austin Project Reporting System (CAPRIS). This system was an immediate success in the utility's finance and project management divisions, and served as the basis for a Web-based lntranet system (eCAPRIS) that was adopted citywide in 2000.
Before eCAPRIS, each city department had its own internal system for project management and for financial tracking of each of the projects. The budget office used a Microsoft Access A database program for Windows, available separately or included in the Microsoft Office suite. Access is programmable using Visual Basic for Applications (VBA). Access can read Paradox, dBASE and Btrieve files, and using ODBC, Microsoft SQL Server, SYBASE SQL Server and Oracle data. database to compile each department's capital requests into the citywide CIP. The departments submitted marked-up pages from the previous year's CIP, along with new capital requests, which were then entered into the database by budget office staff to produce the new CIP.
In the mid-1990s, Austin Water Utility recognized the need for an automated solution to improve the tracking and management of its capital program, the largest in the city. The utility prepared a report that highlighted the benefits of using a management information system to track and monitor capital expenditures and cash flow projections A Cash Flow Projection is an attempt to forecast the cash flows that will be generated by an asset, often a company, over a specified time frame. Methodology
Projections can be made with varying levels of detail, but any cash flow projection for a business entails . At the time, the utility was managing its capital program on a handful of Excel spreadsheets that were distributed among department financial managers and then forwarded to others who verified the numbers and added additional project information. Not only was this a laborious la·bo·ri·ous
1. Marked by or requiring long, hard work: spent many laborious hours on the project.
2. Hard-working; industrious. process, but it often resulted in incorrect data.
Using internal resources, Austin Water Utility created PIRTS--the Project Information Reporting and Tracking System. This Microsoft Access database with a VBA (Visual Basic for Applications) A subset of Visual Basic that provides a common language for customizing Microsoft applications. VBA supports COM, which allows a VBA script to invoke internal functions within Excel, Word and other COM-based programs or to make use of user interface provided financial and cash flow information for capital projects, but offered no project management tools. After using PIRTS for about a year, the utility recognized the limitations of the system and designed a more robust system in anticipation of the 1997 annexations.
The City of Austin Project Reporting Information System, or CAPRIS, had many of the tools the utility was looking for Looking for
In the context of general equities, this describing a buy interest in which a dealer is asked to offer stock, often involving a capital commitment. Antithesis of in touch with. in an automated solution. Similar to PIRTS, the system used an Access database to store CIP project and financial information. The front-end user interface was deployed to desktop computers in the water and public works departments Many governments worldwide have had departments or ministries referred to as the Public Works Department either formally or informally.
In Australia: -
New South Wales -
By 1999 CAPRIS had been deployed to more than 100 desktop computers in the water and public works departments. As the system grew in popularity, numbers of users, and store of information, it quickly reached the limitations of the technology used to develop it. The processing of reports and viewing of screens became very slow because of the Access database, which had grown to be more than 100 MB in size. The database had to be transferred to the network in its entirety for all updates made by the users. Changes or fixes to the system became troublesome, because they required a separate re-deployment and installation to each and every desktop computer. In spite of the mounting difficulties, CAPRIS provided much of the information needed by Austin Water Utility, which came to rely on the system as the primary management tool for its capital program overall and, most importantly Adv. 1. most importantly - above and beyond all other consideration; "above all, you must be independent"
above all, most especially , for the 1997 annexation program.
In the spring of 2000, Austin Water Utility made a presentation to the city manager and the CIP Corporate Committee on CAPRIS and its capabilities. At the time, the city was struggling with how to more efficiently capture and report citywide capital projects information and produce the annual capital improvements plan.
Impressed with the capabilities of the CAPRIS system, the city manager directed the budget office's development team to proceed with the development of a Web-based system that would be easily accessible by all city departments--within 12 months.
To meet this aggressive schedule, the city enlisted the assistance of a consulting firm Noun 1. consulting firm - a firm of experts providing professional advice to an organization for a fee
business firm, firm, house - the members of a business organization that owns or operates one or more establishments; "he worked for a that had been working on Austin Water Utility's annexation program. With city staff and consultants working side by side on design and programming, eCAPRIS was rolled out for citywide use in February 2001.
A key to the success of the new system was an interdepartmental in·ter·de·part·men·tal
Involving or representing different departments, as of a business, an academic institution, or a government: "the petty interdepartmental squabbling that surrounds the making of . . . review of the city's CIP process. The budget office coordinated a multi-departmental team consisting of project managers and financial managers to assess the current CIP process and to recommend changes. The budget office then coordinated with the eCAPRIS development team to ensure that the system was built around the new CIP process. This new process called for the standardization standardization
In industry, the development and application of standards that make it possible to manufacture a large volume of interchangeable parts. Standardization may focus on engineering standards, such as properties of materials, fits and tolerances, and drafting of capital planning and management throughout the organization.
eCAPRIS facilitates the effective and efficient management of all aspects of capital projects across city departments. It is a "homegrown home·grown
1. Raised or grown at home.
2. Originating in or characteristic of a locality: "Rock is homegrown music in the United States, evolved from blues and country and Tin Pan Alley" " Intranet application designed to promote consistent standards of information compilation and storage within the CIP process. It makes project information accessible to city staff using intuitive design coupled with a flexible architecture that promotes sustainability. The system is integrated with the city's financial, human resources The fancy word for "people." The human resources department within an organization, years ago known as the "personnel department," manages the administrative aspects of the employees. , and geographic information systems geographic information system (GIS)
Computerized system that relates and displays data collected from a geographic entity in the form of a map. The ability of GIS to overlay existing data with new information and display it in colour on a computer screen is used primarily to , and is accessed by city users through a Web browser The program that serves as your front end to the Web on the Internet. In order to view a site, you type its address (URL) into the browser's Location field; for example, www.computerlanguage.com, and the home page of that site is downloaded to you. , which greatly simplifies system setup and administration. Below is a summary of the system's major features, as illustrated in Exhibit 1.
* Active/Planned Projects--The system allows for two types of projects: active and planned. Active projects are ongoing projects with approved funding, while planned projects are those that may be approved and funded for future years. Both project types have the same tracking elements.
* Cost Estimation--A project budget is established for each project using standard cost elements.
* Financial Monitoring--Project managers enter spending plans (i.e., cash flows) to request funding, which financial managers use to generate funding needs and plans.
* Project Scheduling--A high-level work breakdown structure (project) Work Breakdown Structure - (WBS) A division of a project into tasks and subtasks. The tasks are numbered to indicate their relationship to each other. WBSs are indespensible for project planning, particularly when estimating time and resource requirements. is provided for development of the schedule for each project. To maintain strict accountability for schedule changes, the schedule can only be modified under certain conditions. All projects use standardized standardized
pertaining to data that have been submitted to standardization procedures.
standardized morbidity rate
see morbidity rate.
standardized mortality rate
see mortality rate. project phases and milestones to ensure consistent reporting.
* Status Reporting--On a monthly basis, project managers provide project status reports; this information is stored historically and is available to all users.
The eCAPRIS application also includes a module for the solicitations and contracts associated with projects. Citywide processes for issuing RFQs and RFPs for professional services (job) professional services - A department of a supplier providing consultancy and programming manpower for the supplier's products. , as well as bids for construction and monitoring participation by minority, disadvantaged, and small businesses, are incorporated into the software. Likewise, once a contract has been awarded, eCAPRIS provides information to support compliance, payment, and change orders.
All information gathered by the system is readily available to users through pre-formatted reports. In addition to the more than 100 criteria-based reports, custom reports can also be generated according to according to
1. As stated or indicated by; on the authority of: according to historians.
2. In keeping with: according to instructions.
3. the needs of project managers, financial managers, department directors, and city management.
A particularly valuable tool is the GIS (1) (Geographic Information System) An information system that deals with spatial information. Often called "mapping software," it links attributes and characteristics of an area to its geographic location. interface that allows employees to define and analyze CIP project areas by location. All projects are "mapped" within the eCAPRIS application by project managers. This process integrates citywide GIS information with project information, giving the city a powerful tool for interdepartmental project planning project planning - project management and communication, not to mention a convenient and effective means for answering questions from the City Council, management, and citizens in a timely manner. Exhibit 2 shows what the GIS interface looks like within eCAPRIS.
The eCAPRIS system has generated a wide range of quantitative and qualitative benefits to the city. Consider the following:
Increased Responsiveness to Council and Citizen Requests. The Web-based interface, with its point and click simplicity, permits users throughout the city to receive a City Council or citizen request for information, access the system, and quickly retrieve status information on projects citywide. The GIS map-based interface is particularly useful in helping users focus on a particular section of the city and visualize the extent of capital projects.
Less Staff Time Required to Compile the CIP Plan. The production of the CIP plan has been entirely automated, such that once information has been entered into eCAPRIS and validated by project managers, department managers, and the budget office, the system generates a single formatted report in excess of 500 pages for the annual CIP plan.
Improved Interdepartmental Communication. The information entered into eCAPRIS is available to all users in "real time." Each department can monitor the system for new projects and status changes, and anticipate where projects may overlap. This improved coordination leads to real cost savings for the city.
Elimination of Multiple Entries into Different Systems. The administrative burden for CIP management has been significantly reduced. Duplicate systems and offline reporting tools have been eliminated. Project managers now spend more time managing their project portfolios and less time keying in data or otherwise duplicating work effort.
Reduced Gap between Projections and Actuals. With improved information access and tools that improve project management practices, the city has closed the gap between planned and actual project performance.
Uniformity of CIP Management Processes. The eCAPRIS system has reinforced a consistent methodology for project management, which streamlines communication among departments and individual project managers. This also allows new managers to be brought on board much more quickly.
Accountability at Appropriate Organization Levels. The system incorporates a limited, yet carefully designed set of checks to ensure that the right people maintain project information, keep it up to date, and provide explanations when project status changes. The system thus supports a basic level of accountability for all project managers.
Real-Time Performance Measurement. Through tight integration with the city's financial system, the eCAPRIS system provides timely information on project actual expenditures, schedule performance, and contract status. This near-real-time performance measurement and reporting gives managers extra time to formulate actions to address financial or scheduling issues.
Improved Accuracy of CIP-Related Data. With a single system, consistent practices, and automated data management features, the eCAPRIS system gives all city departments an information resource they can rely on.
The eCAPRIS system is fully integrated with the city's other core applications, as shown in Exhibit 3. Data from the financial system, human resource system, vendor registration system, and GIS system is delivered nightly to eCAPRIS, ensuring that users have current information. Also included in this nightly "data dump" is a verification and reconciliation process.
eCAPRIS was developed using Macromedia Web development products, and the application is available citywide via Microsoft Internet Explorer See Internet Explorer. . eCAPRIS data is stored in an Oracle 9i database, while reports are generated using Crystal Reports 8.5. The budget office's Web development team, which includes four programmers, is responsible for all aspects of the system.
Now entering its fifth year of citywide use, eCAPRIS has proven to be an indispensable tool for the entire organization. Most recently, the city used the system to conduct a needs assessment in preparation for a 2006 bond election, eCAPRIS' citywide acceptance owes itself to the system's flexibility and user friendliness. Designed and maintained by city staff, eCAPRIS has been able to meet the evolving needs of the City of Austin. Looking to the future, the city is positioned to use eCAPRIS as a platform for further enhancements to the CIP process.
Editor's note Editor's Note (foaled in 1993 in Kentucky) is an American thoroughbred Stallion racehorse. He was sired by 1992 U.S. Champion 2 YO Colt Forty Niner, who in turn was a son of Champion sire Mr. Prospector and out of the mare, Beware Of The Cat.
Trained by D. : Each year GFOA GFOA Government Finance Officers Association bestows its prestigious Award for Excellence in recognition of outstanding contributions to the practice of government finance and management. This article describes a 2005 winning entry in the Accounting, Auditing, and Financial Reporting category.
GREG CANALLY is budget officer for the City of Austin, Texas. Before joining the city, he worked as a project manager/economist for HDR (1) (High Data Rate) A wireless data technology from QUALCOMM that provides up to a 2.4 Mbps data rate in a standard 1.25MHz CDMA voice channel. HDR can be used to enhance data capabilities in existing cdmaOne networks or in stand-alone data networks. Engineering, working with all levels of government to implement water planning solutions. Canally holds a bachelor's degree in economics from Villanova University Villanova University (vĭl'ənō`və), at Villanova, Pa., near Philadelphia; Roman Catholic; est. 1842 as a men's school, coeducational since 1967. and a master's degree master's degree
An academic degree conferred by a college or university upon those who complete at least one year of prescribed study beyond the bachelor's degree.
Noun 1. in economics from the University of Texas at Austin “University of Texas” redirects here. For other system schools, see University of Texas System.
The University of Texas at Austin (often referred to as The University of Texas, UT Austin, UT, or Texas .
BRUCE NEITSCH is programmer analyst A person who analyzes and designs information systems and designs and writes the application programs for the system. In theory, a programmer analyst is both systems analyst and applications programmer. In practice, the title is sometimes simply a reward to a programmer for tenure. supervisor for the Budget Office of the City of Austin, Texas. While working for the Austin Water Utility, he played a key role in the development of both the Project Information Reporting and Tracking System and eCAPRIS. Neitsch holds a bachelor's degree in computer information systems from Texas State University.
To receive a demo CD of eCAPRIS, please contact Bruce Neitsch, programmer analyst supervisor, City of Austin Budget Office, (512) 974-7915.