Loading...
RPVCCA_CC_SR_2015_03_03_H_Computerized_Maint_Mgmt_SystemCITY OF tiRANCHO PALOS VERDES MEMORANDUM TO: HONORABLE MAYOR & CITY CO NCIL MEMBERS FROM: DAN LANDON, IT MANAGER MICHAEL THRONE, DIRECTOR OF PUBLIC WORKS DATE: MARCH 3, 2015 SUBJECT: COMPUTERIZED MAINTENANCE MANAGEMENT SYSTEM OVERVIEW REVIEWED: CAROLYNN PETRU, DEPUTY CIN MANAGE RECOMMENDATION Authorize the City to begin negotiations for an agreement with Azteca Systems "CityWorks" Computerized Maintenance Management System (CMMS) and Miller Spatial Services for the CityWorks system implementation. EXECUTIVE SUMMARY The Public Works department currently processes and tracks Service Requests and Work Orders in a hybrid process that is mostly manual. This system is inefficient and provides for minimal tracking and reporting capabilities. Past third party assessments pointed out that the City should upgrade these older systems and manual processes to updated computerized processing systems, and after an evaluation period that initially began in 2008, the City has selected CityWorks as the preferred CMMS system because of several factors, including: • Tight integration with ESRI GIS, the City's GIS system; • Configurability and the number of available modules; • Strong feature set including online and mobile applications; and • Reasonable price point. The CityWorks system connects to GIS and is able to use layers of GIS data as asset points and Service Requests and Work Orders can be assigned to non -addressed assets. This feature allows for greatly improved tracking and reporting of maintenance activities. CityWorks also has an impressive and comprehensive set of features, and in 2012 was selected as the top CMMS by a respected and independent review of industry systems by H-1 COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW MARCH 3, 2015 PAGE 2 the Water Finance Research Foundation. The CityWorks system must be configured to achieve the most productivity and feature enhancements. The City contracts with Miller Spatial Services for advance GIS functionality including assistance with the most recent GIS system upgrade. Miller Spatial Services, located in Riverside, California is a local, well qualified CityWorks partner and is recommended for the implementation process. Not only are they able to fulfill the City's requirements during implementation, they have a deep understanding of the City's GIS system, and fulfil the important requirement of a local implementer. CityWorks has three (3) licensing levels, Essentials, Standard and Premium. Based on the feature set, the City recommends the purchase of 20 individual named users of the Standard licensing model at an annual cost of $27,000. Implementation is estimated to be $50,000 subject to final negotiations and changes to the scope of work. Staff is seeking authorization to negotiate an agreement with the preferred system provider and a consultant to assist the City with implementation. Final proposals and agreements will be presented to the City Council for approval at a future meeting. BACKGROUND The Public Works department currently processes and tracks Service Requests and Work Orders using a combination of manual forms, email and spreadsheet type applications. As noted in assessments including Management Partners in 2008, Nexlevel in 2011 and Matrix in 2012, the City would benefit by an upgrade in systems, allowing for productivity and efficiencies as well as enhancing information available for management decisions and reporting. Staff has now completed a long process of analysis of the various Computerized Maintenance Management Systems available in the market and have selected the Azteca Systems "CityWorks" application as the most effective solution for our City environment. During a 2008 system review process, Public Works and IT Staff considered proposals and demonstrations of the various system options available with a goal of finding an electronic method of creating and tracking service requests and work orders in order to replace the paper triplicate "carbon -copy" forms currently in use. It was realized during this research process that a true full asset management system was needed, as opposed to simply an electronic method of processing service requests and work orders. Asset Management and Work Order systems pool information to create the most effective way to manage both the City's maintenance resources and assets in one system. Several demos were provided to the Public Works Staff by vendors offering the systems considered, including Tyler's asset management module, but Staff felt that the `GIS -centric' Azteca Systems Cityworks application best met the needs and goals of the Department because of the ability to spatially map City owned assets. In contrast to some other limited -functionality work -order systems, Cityworks was developed for the sole purpose of infrastructure asset management with a strong emphasis on tying into the spatial data that already exists inside the City's SSRI -based GIS system. This component is considered critical by Staff for a variety of reasons, but especially because of the ability to tie service requests to assets such as street segments, locations in H-2 COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW MARCH 3, 2015 PAGE 3 the preserve or signs that do not have a street address. Many Public Works requests for service involve these non -addressed assets, and a system linked to GIS data provides the capacity to clearly identify these locations for service as well as for tracking and reporting purposes. Besides the City's own comprehensive process, a 2012 non -biased "Water Finance Research Foundation" comparison found CityWorks the top CMMS choice among fourteen (14) leading CMMS's (see Exhibit A - Asset Manager Software Comparison — WERF 2012). Due to a variety of factors, the system was not implemented during the initial review in 2008. The City has since made numerous enhancements to City technologies, including the recent GIS system upgrades needed to support the CityWorks capabilities, and the City is now prepared to begin the system implementation process. DISCUSSION Because of the wide array of Land Management issues affecting local government operations, municipalities have specific needs related to the systems they procure. At a high level, there are several possible general designs for Land, Infrastructure and Asset Management systems in municipal government: Isolated systems that each specialize in specific departmental functions; Systems with separate data sources that replicate data with each other; and Integrated systems that draw data from a single source and can also share data with other systems. The integrated system type above has many advantages related to the use of data from a central data store based on geospatial data, aerial imagery, and GPS located assets. Layers of information such as parcel boundaries, structure size, street segments, signs and thousands of other attributes can be used by a number of systems, and that data is only maintained in one location as a "master" data store. Leveraging this information in departmental business or enterprise systems provides a powerful rationale for selecting a system that is "GIS Centric". CitvWorks Selection / Features CityWorks is among a small number of Asset and Infrastructure Management Systems that are fully GIS Centric. Many competitors merely replicate GIS data into their database. CityWorks supported functions include asset and work order management, recording of inspections and condition data, and reporting on a wide variety of data including by individual work request or rolling up costs for categories of work. CityWorks supports procurement and inventory management operations, and it also supports logging and tracking of service requests. CityWorks supports Application Programming Interfaces (API's) to a wide variety of other municipal government systems including Customer Relations Management (CRM) systems that can be used for accepting and tracking of resident City service requests. CityWorks includes several built-in data models based on the schemas defined by our GIS H-3 COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW MARCH 3, 2015 PAGE 4 system manufacturer, ESRI. The models support a wide range of municipal assets already programmed as layers into GIS such as water, wastewater, storm water, and road networks. The City can then modify the schemas to suit our requirements during the implementation phase. The figure below illustrates how the ESRI schema is used to associate a map of water mains with their associated work orders in CityWorks. File Edit View Insert Selection Tools Window Help ❑ �1;®431 10 1re+11:6,65; - I::E:��Q Scenario 360 ' I j ; .°. C4works Network: 1^laterNetwork Flow Analysis Trace Task; Fir r n ❑O ALL - WO {'' f OTHER r rt 1 u� ASSETGROUP lLlt IRSptctM@ti6l '*> WATER +; ❑� Water Network ' hl> Mlti% +; 2Airports 4. ❑ OrthoPhoto +I ❑r NewSubdivision +; R BuildingFootprints t: LandParcels +; RoadNetrwork +; L] ONhighway +I 0 RailLines : Q Canals Waterways +i Q Lakes - detailed +; [ lakes }; Vegetation R? id Common Ancestors fss���nn�■ao�r-sem I Dryrtal { ri y pq �I Display Source Selection I` I 360 Analysis 360 Setup 1 a Drawing R ❑ w A w i .Anal —� �1D B I u i A Go back to previous extent 655461.95 4770157.47 Meters In creating work orders or capturing other associated data, CityWorks can spatially link work orders and service requests to specific assets or to street addresses in GIS. This links directly to spatial GIS data that changes during the creation of layers or recording of events such as sales at the assessor facilitates serving notice to customers who may be affected by an asset failure or a planned maintenance operation, or in long term planning and budgeting for the replacement of Infrastructure Assets. Work orders and service requests are assigned to responsible personnel, and enables them to locally or remotely access these work orders and status or update them as work is completed. Another feature of CityWorks is its ability to support field operations by enabling browser based wireless access using tablets or laptops directly to the asset geodatabase. Staff or contracted personnel can access and update work orders and service requests, and view asset maps directly from the field. CityWorks can also operate in "disconnected" mode, an important feature with the spotty wireless reception that is a result of our terrain, by checking data in and out of the database, and keeping the data synchronized between sessions. System Implementation H-4 COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW MARCH 3, 2015 PAGE 5 CityWorks is very flexible but requires configuration to suit the specific requirements of each individual customer. Because of the very tight integration with GIS, it is important to find an implementer that also has experience with GIS. Staff's initial inquiry several years ago did not solicit any implementers in the Los Angeles area. Local support is important because the implementer will likely be assisting the City with future support and functionality requests and a quick response time without additional travel expenses or time is important to the City. Miller Spatial Services is our current GIS services consultant and has an intimate knowledge of City GIS as the firm assisted in the implementation of the GIS upgrades approved by City Council in 2014. In addition to GIS expertise, they are also a CityWorks implementation partner with offices in Riverside, California. Therefore, Miller Spatial Services meets the criteria of a local, skilled CityWorks provider with expertise in our City GIS systems. The proposed implementation consists of a planning phase, implementation, and a training and go -live phase. During the planning phase, Staff will work with the consultant to develop a comprehensive workflow based on our current processes that best fits into the CityWorks system capabilities. During implementation, the consultant will program CityWorks workflows, functionality and features required to accomplish the functionality identified in the planning phase. Finally, the training and go -live phase will commence with a comprehensive staff training program, on-site support during go -live and additional hours of support after go -live to address any deviances from the functionality identified in the planning phase. A Scope of Work was developed by Staff and submitted to Miller Spatial Services. After discussion and clarification, an implementation plan and schedule was developed, (see Exhibit B - Miller Spatial — Cityworks Implementation Proposal). Miller Spatial Services submitted an initial estimate of $41,070 including the cost of system planning, implementation, training and go -live support. Staff estimates that the final total cost will be approximately $50,000 based on several additional expected configurations such as reports and workflow changes, subject to final contract negotiation. Staff will present the final negotiated agreement to City Council for consideration. Cityworks Licensing and Support An onsite CityWorks system is recommended because of the tight integration into the City GIS system. CityWorks has three licensing levels depending on the functionality desired. (see Exhibit C - CityWorks Pricing Model) "Essentials" — most basic system license includes Asset Management and connectivity to ESRI GIS; "Standard" — include the features of Essentials, plus inventory, contracts, reporting and analytics and the use of API's for Citizen Service Requests; and "Premium" — include all the features of Standard as well as several premium mobile management features and additional API's. H-5 COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW MARCH 3, 2015 PAGE 6 After the selection of the licensing level, customers choose either "named user" licenses or "site" user licenses. The cost of licensing is based by Azteca Systems on City population. The most appropriate type of user licensing can be easily calculated based on how many users will access the system. If the individual license cost is less than a site license, then individual named license purchase are more cost effective. The Cityworks licensing level selected based on City needs is the "Standard" level. Staff expect that twenty (20) named user licenses will be used, so the number of users that will be accessing CityWorks does not support a site license model, therefore individual named licenses are recommended. Azteca "CityWorks" does not sell licensing through distributors. As such, the only source to purchase licensing is direct from Azteca Systems. The City expects that 15 licenses will be used in Public Works, 2 in Community Development, 2 in Recreation and Parks and 1 in Finance or Administration. The cost for named users of CityWorks Standard is: First 5 users - $9,000 Each additional user - $1,200 The total annual licensing and support cost for 20 user licenses is $27,000. There is no upfront fee for the software purchase. The annual cost for a site license is $45,000. The City proposes the less expensive purchase of 20 user licenses for $27,000. CityWorks does not have distributers, it is only sold direct from Azteca Systems. As a result, pricing comparisons are not possible. Staff will present the final purchase proposal to City Council for consideration along with the final agreement. CONCLUSION With the pending completion of an updated GIS system, and the planned FY 2015-16 upgrade to the Community Development Department's Land Management System, both Public Works and Community Development will be able to utilize the centralized GIS system as the single repository of all land, parcel, and infrastructure data. It is the appropriate time to implement a Computerized Maintenance Management System in order to migrate the City's current manual Service Request and Work Order systems into an integrated, GIS Centric system. Such a system will greatly improve tracking and reporting capabilities, thus increasing efficiency, timelines and improve customer service. In addition to the other efficiency, productivity and reporting capabilities, a CMMS is expected to provide useful information to the Infrastructure Management Advisory Committee and is another favorable consideration in progressing with the system implementation. FISCAL IMPACT Funds were previously appropriated by City Council and carried over to FY2014-15. It is expected that the Public Works CMMS, will be fully implemented in FY2015-16 in line with we COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW MARCH 3, 2015 PAGE 7 the 5 Year IT Plan presented to City Council in August 2014. The implementation and licensing cost for a Public Works CMMS was previously approved by the City Council and encumbered, so no additional budget adjustments are expected. Attachments: Exhibit A - Asset Manager Software Comparison — WERF 2012 Exhibit B - Miller Spatial — Cityworks Implementation Proposal Exhibit C - CityWorks Pricing Model H-7 The 2012 Comparative Review of Municipal Maintenance and Infrastructure Asset Management Systems SUMMARY: The United States and Canada face tremendous capital outlays to repair and replace aging municipal and utility infrastructure. Technology is required to better manage the complex decision making process for maintenance, operational and capital investments and resource allocation. This study conducted in 2012 comprises a comparative review of the major computerized maintenance management and infrastructure asset management systems used by municipal governments and water and wastewater utilities in the United States and Canada. The objective of this study is to provide municipal elected officials, public works directors, infrastructure asset managers, maintenance managers, information technology managers, finance directors and procurement staff an overview of municipal maintenance management and infrastructure asset management software in a comparative format in preparation for a request for qualifications or proposals. The comparative criteria includes software costs, vendor services, support, specialization, work orders, inventory control, licensing and permitting, condition assessment, risk management, asset inventory, GIS mapping, Esri GIS integration, 311 systems, mobile devices, Esri GIS ROI and future industry trends. The comparative analysis of core maintenance management and infrastructure asset management functions was completed for the following 14 software systems in alphabetic order: Accela, Agile Assets, Azteca System's Cityworks, Cartegraph, Cityview, Energov, IBM's Maximo, Infor/Hansen, Lucity/GBA, Maintenance Connection, Novotx's Elements, Oracle, Pubworks and Vueworks. Also included in this study, but not in a comparative format is a discussion on Esri GIS as the recommended platform for municipal mapping applications; and Innovyze software offerings for an advanced wet infrastructure/underground network hydraulic modeling decision analytics approach. Water Finance Research Foundation WFRF www.waterfinanceRF.org 1. SUMMARY RESULTS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-8 1. SUMMARY RESULTS The summary results of the 2012 comprehensive comparative review and study ranks Azteca System's Cityworks maintenance management and infrastructure asset management system as the top selection for municipal and utility use. Cityworks has demonstrated strength and longevity in the municipal and utility market place for the last 15 years with a highly developed work order management system, and can fully leverage an organization's (ROI) investment in the Esri GIS and the ArcGIS geodatabase as the asset repository reducing implementation and long-term maintenance cost of ownership issues. Cityworks maintains some of the most advanced LGT (Local Government Templates) with over 630 work order templates, 150 service requests with detailed condition assessment inspections. The licensing and permitting functionality is further enhanced by the Esri GIS Centric approach in developing connectivity of all public assets, infrastructure and activities. Cityworks 99 91 Oracle 94 79 Maxima 93 78 Accela 92 82 Infor/Hansen 89 79 Energov 88 82 Cartegraph 87 81 Lucity (GBA) 82 78 Pubworks 65 68 Maintenance 61 61 Vueworks 61 61 Agile Assets 52 58 Elements 50 56 Cityview 33 42 *Adjusted Price Score weighted 20% 1. SUMMARY RESULTS ( Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-9 2. INTRODUCTI®N In recent years municipalities and water and wastewater systems have struggled significantly in managing the complex and diverse assets that are within their jurisdictions for which they are accountable. Great strides have been made to develop programs and systems to improve cost efficiencies but core work order management software system functionality by itself did not address the growing needs of infrastructure asset management practices. During the most recent five years since the worldwide economic decline, which in part continues today, municipalities and utilities at all levels have faced severe revenue short falls. The actions taken to maintain baseline services involved delaying hundreds of millions of dollars a year in needed maintenance activities and deferring critical capital projects. Efforts made at the state, regional, county, and local levels to better manage assets and allocate limited resources to high profile failing assets were met with a high degree of frustration due to inconsistent and outdated practices, neglected data tracking and storing, and a lack of data integration abilities with silo/stranded data throughout many departments. Asset Management Infrastructure asset management programs, offered by different consulting firms, should still be focused on managing assets in a way in which the investment for each asset can be optimized producing a reduction in capital budgets and operating expenditures, an efficient and cost effective maintenance program based on risk and an overall reduction in the cost of capital. One common problem has been when engineering drives the capital agenda and the needs of operations and maintenance are overlooked. Likewise, when the financial tracking and planning functions are also neglected, true enterprise asset management decision snaking cannot occur. A multidisciplinary approach at a corporate level is highly recommended to create a consistent management -wide effort to guide investments and resource allocation. Comprehensive asset management professionals understand these concepts and have a global perspective and the ability to customize solutions to each municipality. These professionals possess the expertise in and understanding of the International Infrastructure Management Manual (IIMM), which is essentially the bible of asset management. This training is critical in establishing the foundational knowledge of the comprehensive process of modern asset 2. INTRODUCTION I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-10 management. The basic foundation as well as the expectations should be that asset management as a philosophy is a process of continuous improvement and change. In the United States and Canada, the definition of asset management will continue to be defined by the software tools each organization selects as a means to improve asset performance and manage costs. A reduction of cost can be defined as either a short-term gain or a long-term gain or both. The logic entails that if an asset is not maintained correctly it can fail prematurely. Likewise, an asset replaced prematurely wastes a useful asset and as a result improved performance and investment decision making does not occur. Informed decision making can reduce the overall cost of the asset and function to the benefit of the taxpayers. This process is data intensive and requires the necessary policies, leadership, and structure to meet sustainable infrastructure objectives. The goal to achieve a sense of sustainable infrastructure requires an overall plan including asset management planning, which in turn also requires a financial plan, a technology plan, a service delivery plan, and integration with community plaiming efforts. Public Asset Management The concept of public asset management strives to combine all infrastructure assets and land- based assets and functions to effectively manage the social and environmental goals of the community while offering an improved management decision making process with public review, approval and justification. The current trend is that municipal utilities as capital -intensive enterprise funds will initiate asset management programs during the economic decline and will lead their general city management counterparts of public works, streets, facilities, fleet, parks, signage, bridges, cemeteries, ports and marinas, into an era of sustainability and infrastructure asset management. The expansive nature of the process places a high level of importance on the technology which needs to be applied in a way to gain the greatest benefit overall. Computerized Maintenance Management Systems (CMMS) and Infrastructure Asset Management Software implementation trends for municipalities demonstrate initial progress in business enterprise funds like water, wastewater, and storm drains migrating efficiencies and practices to other municipal departments. This system functionality migration trend will continue and can be more readily managed with a GIS centered strategy. 2. INTRODUCTION I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-11 I METHODOLOGY The comparative analysis of core maintenance management and infrastructure asset management functions was completed for the following 14 software systems in alphabetic order: Accela, Agile Assets, Azteca System's Cityworks, Cartegraph, Cityview, Energov, IBM's Maximo, Infor/Hansen, Lucity/GBA, Maintenance Connection, Novotx's Elements, Oracle, Pubworks and Vueworks. The comparative criteria includes software costs, vendor services, support, specialization, work orders, inventory, licensing and pennitting, condition assessment, risk management, asset inventory, GIS mapping, Esri GIS integration, 311 systems, mobile devices and Esri GIS ROI taking into consideration future industry trends. The four major functional categories include 1) Company/Service, 2) Work Management, 3) Asset Management, and 4) GIS. Each major component is ranked 1-5 with a 5 as the highest score. A zero represents a function not contained in the software. The Overall Functional Score assumes an even weighting of the four major functional areas. SERVICES/IMPLEMENTATION SUPPORT/TRAINING SPECIALIZATION WORK ORDERS AND WORK FLOW INVENTORY LICENSING AND PERMITS GIS MAPPING Esri GIS INTEGRATION 311 SYSTEMS_ MOBILE DEVICES Esri GIS ROI 3. METHODOLOGY I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-12 4. REVIEW OF SERVICES The functionality of the core components of a software application is very important, however, the actual success and level of benefit gained is a direct result of the work and support around the planning, implementation, testing and training. The ability for the software vendor to provide enhanced support and training to ensure the successful implementation is critical. In the area of asset management, data conversion and a specialization in specific infrastructure types can ensure a higher degree of utilization of software capabilities. Pubworks Cityview Agile Assets Vueworks Elements Maintenance Energov Accela Lucity (GBA) Infor Oracle Maximo Cartegraph Cityworks 0 2 4 6 8 10 12 14 16 4. REVIEW OF SERVICES I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-13 Company/Services The Company/Service functional category includes Vendor Services and Implementation, Support and Training Services and Company Strength and Specialization. A ranking score ranging from 1-5 was assigned to software for each of the 3 areas. A "5" score represents the highest functionality, while a low score represents a marginal level of functionality. If software did not have functionality in a given area then a zero was assigned and calculated into the overall scoring. Cityworks 5 Cityworks 5 Cityworks 5 Cartegraph 5 Cartegraph 5 Cartegraph 5 Maximo 5 Maximo 5 Maximo 5 Oracle 5 Infor/Hansen 5 Oracle 5 Accela 4 Lucity (GBA) 5 Accela 4 Energov 4 Oracle 5 Energov 4 Infor/Hansen 4 Accela 4 Infor/Hansen 4 Lucity (GBA) 4 Energov 4 Lucity (GBA) 4 Elements 3 Maintenance 4 Maintenance 4 Maintenance 3 Agile Assets 3 Agile Assets 3 Vueworks 3 Cityview 3 Cityview 3' Agile Assets 2 Elements 3 Elements 3 Cityview 2 Pubworks 3 Pubworks 3 Pubworks 2 Vueworks 3 Vueworks 3 4. REVIEW OF SERVICES I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-14 5. REVIEW OF WORK MANAGEMENT A robust Computerized Maintenance Management System (CMMS) with work orders providing the ability to separate planned or unplanned maintenance costs, builds life cycle cost history, records actual direct costs of the activity, documents the procedures followed, notes the failure mode and primary cause of failure with comments on indirect costs and impacts to customers and possible unproductive time. A basic CMMS alone is not an asset management system. All of this data enables additional possibilities of failure, causal, consequence and efficiency analysis. Work Management Overall Score 5. REVIEW OF WORK MANAGEMENT I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-15 Work Management The Work Management functional category consisted of Work Orders and Work Flow, Inventory Control, and Licensing and Permitting. A ranking score ranging from 1-5 was assigned to software for each of the 3 areas. A "5" score represents the highest functionality, while a low score represents a marginal level of functionality. If software did not have functionality in a given area then a zero was assigned and calculated into the overall scoring. Cityworks 5 Cityworks 5 Cityworks 5 Accela 5 Accela 5 Accela 5 Energov _4 Maximo 5 Cityview 5 Infor/Hansen 4 Lucity (GBA) 5 Energov 5 Maintenance 4 Pubworks 5 Cartegraph Maximo 4 Infor/Hansen 5 Lucity (GBA) Lucity (GBA) 4 Oracle 5 Maximo Cartegraph 4 Cartegraph 5 Infor/Hansen Elements 4 Elements 5 Oracle Oracle 4 Energov 4 Elements Pubworks 4 Maintenance 4 Pubworks Vueworks 4 Vueworks 4 Maintenance Agile Assets 3 Agile Assets 3 Vueworks Cityview 0 Cityview 0 Agile Assets 5. REVIEW OF WORK MANAGEMENT I Municipal Maintenance and Infrastructure Asset Management Systems 0 0 3 0 Exhibit A H-16 6. REVIEW OF ASSET MANAGEMENT Condition assessment can be defined as a method that establishes the current condition of assets as a means of prioritizing and forecasting maintenance and rehabilitation efforts. Condition assessment can help managers understand the level of asset deterioration and the risk management impact on the probability and consequence of failure. The Asset Inventory or Registry is central to any asset management program or strategy. An asset register is a systematic recording of all assets an organization owns or for which it has responsibility. 6. REVIEW OF ASSET MANAGEMENT I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-17 Asset Management Asset Management functional category includes Condition Assessment capabilities, Risk Management, and Asset Inventory and Hierarchy. A ranking score ranging from 1-5 was assigned to software for each of the 3 areas. A "5" score represents the highest functionality, while a low score represents a marginal level of functionality. If software did not have functionality in a given area then a zero was assigned and calculated into the overall scoring. Cityworks 5 Cityworks 5 Cityworks 5` Cityview 0 Cityview 0 Cityview 0 Elements 0 Elements 0 Accela 5 Accela 5 Accela 5 Cartegraph 4 Cartegraph 4 Cartegraph 4 Energov 5 Energov 5 Energov 5 Maximo 5 Maximo 5 Maximo 5 Oracle 5 Infor 5 Infor 5 Infor 4 Oracle 5 Oracle 5 Lucity (GBA) 4 Lucity (GBA) 4 Lucity (GBA) 4 Pubworks 4 Maintenance 4 Maintenance 4 Agile Assets 3' Pubworks 4 Pubworks 4 Elements 3 Agile Assets 3 Vueworks 4 Maintenance 3 Vueworks 3 Agile Assets 3 Vueworks 3 6. REVIEW OF ASSET MANAGEMENT I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-18 7. REVIEW OF GIS Investing in a complete GIS system with full functionality produces an overall reduction in operating and maintenance costs and can become the foundation of a lower cost asset management system. Technology has increased the operating efficiencies of municipalities and utilities by converting manual office process from paper to an intelligent automation system. GIS is a unique system of hardware, software and data used to create, store, edit, organize, manipulate and analyze information within a geographic area. GIS offers the ability to visualize models of the physical infrastructure and related activities in a map view. Elements Maintenance Cityview Agile Assets Vueworks Pubworks Lucity (GBA) Cartegraph Maximo Energov Oracle Infor Accela Cityworks GIS Overall Score 0 5 10 15 20 25 7. REVIEW OF GIS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-19 GIS The GIS (Geographical Information System) functional category consists of GIS Mapping features, Esri GIS integration, 311 System Abilities, Mobile Devices Enhancements, and Esri GIS ROI (Return on Investment) considerations. A "5" score represents the highest functionality, while a low score represents a marginal level of functionality. If software did not have functionality in a given area then a zero was assigned and calculated into the overall scoring. Cityworks 5 Cityworks 5 Accela 5 Accela 5 Accela 5 Accela 4 Cartegraph 5 Maximo 5 Cartegraph 5 Cartegraph 4 Energov 5 Infor/Hansen 5 Elements 5 Energov 4 Infor/Hansen 5 Oracle 5 Energov 5 Maximo 4 Oracle 5 Cityworks 4 Maximo 5 Infor/Hansen 4 Pubworks 5 Agile Assets 4 Infor/Hansen 5 Lucity (GBA) 4 Cityworks 4 Energov 4 Lucity (GBA) 5 Oracle 4 Maximo 4 Cartegraph 3 Oracle 5 Agile Assets 3 Lucity (GBA) 4 Cityview 3 Vueworks 5 Elements 3 Vueworks 4 Lucity (GBA) 3 Agile Assets 4 Maintenance 3 Cityview 3 Maintenance 3 Cityview 4 Pubworks 3 Agile Assets 2 Pubworks 3 Pubworks 4 Vueworks 3 Elements ' 0 Vueworks 2 Maintenance 3 Cityview 0 Maintenance 0 Elements 0 GIS has been able to meet the increased demand for mobility and information sharing. Many applications for asset maintenance and management purposes have been developed by software companies in order to improve the transactional cost of public accountability. Some of these features can also be accessed through P party vendors. Municipalities and utilities have benefited from 311 citizen information, request and tracking systems as well as mobile remote business functionality via handheld mobile devices. 311 capabilities and mobile device initiatives are continually improving for top vendors. 7. REVIEW OF GIS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-20 Esri GIS It®I GIS offers a return on investment (ROI) and these operational savings will continue almost indefinitely. Municipalities and utilities in the United States and Canada rely on the industry leader Esri (Economic and Social Research Institute) GIS for their GIS software. Local governments and utilities benefit overall with standardization and common open standards for consistency which helps achieves lower -costs with the economies of scale. Under this GIS Centric approach, the Esri GIS ArcGIS geodatabase is the feature database for storing the all asset attributes. Additionally, there is no redundancy for data storage (no reliance on views, data mapping, database triggers, or "transparent" links). All feature (asset) data is fully user -definable and customizable without vendor support. This would include common standardization absent expensive non-proprietary feature data model format, including data names, fields, tables, relationships, and other data design elements. Cityworks 5 Platinum Accela 3 Gold Cartegraph 3 Silver Energov 3 Gold Maximo 3 - Infor/Hansen 3 - Lucity (GBA) 3 Gard Oracle 3 - Elements 2 - Maintenance 2 - Pubworks Z Vueworks 2 - Agile Assets 1 Cityview 1 - 7. REVIEW OF GIS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-21 8. REVIEW OF COST FACTORS Overall Scores and Rankings nonnally are based on the functional categories scores and averages. Under this review, the four major functional categories were weighted evenly. The element of cost adds additional complexity to the analysis. Most municipalities and utilities will normally focus on the core functionality of the software in order to meet all current and future business needs before reviewing bids or prices. The price component can be challenging considering there are the basic user licenses, software and maintenance costs and agreements combined with phased implementations, modular selections, data clean up, data conversion, systems integrations, testing and training. This study focuses on the common costs; however, it is very important to note that if various modules are selected and integrated, the costs of implementation are normally significant higher. Aglle ASSeis L LOW Cityview 2 Low Elements 2 Low Pubworks 2 Low Cityworks 3 Average Cartegraph 3 Average Energov 3 Average Lucity (GBA) 3 Average Maintenance 3 Average Vueworks 3 Average Accela 4 High Infor/Hansen 4 High Maximo 5 High Oracle 5 High 8. REVIEW OF COST FACTORS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-22 Cost Factors Likewise, when system integration and conversion is required for many different systems and several modules, the initial implementation and long-term system synchronization and maintenance of redundant databases can raise the total cost of ownership significantly. This is very true in the area of licensing and permitting. Every municipality and utility has a degree of data clean up due to neglect or inconsistent policies and practices concerning work order histories and inspection recording and asset data collection. One specific area of concern has been the development of the asset inventory and the connectivity and integration with GIS software. I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-23 9. Esri GIS ArcGIS: Geodlatabase management ArcGIS for Desktop includes comprehensive professional GIS applications that support a number of GIS tasks, including mapping, data compilation, analysis, geodata and image management, and geographic information sharing. ArcGIS for Desktop is the platform that GIS professionals use to manage their GIS workflows and projects and to build data, maps, models, and applications. It is also the starting point and the foundation for deploying GIS across organizations and onto the web. It is used to publish and share geographic information with others. ArcGIS for Server includes capabilities for managing multiuser geodatabases in a number of DBMSs. When you need a large multiuser geodatabase that can be edited and used simultaneously by many users or that can be synchronized across many copies (replicas) of the database, the geodatabase provides a good solution. ArcGIS for Server adds the ability to manage shared, multiuser geodatabases as well as support for a number of critical multiuser database workflows. The ability to leverage your organization's enterprise relational database is a key advantage. Multiuser, transactional geodatabases work with a variety of DBMS storage models (for example, IBM DB2, Informix, Oracle, PostgreSQL, and SQL Server). Geodatabases take full advantage of underlying DBMS architectures to support the following: • Extremely large, continuous GIS databases • Many simultaneous users • Long transactions and versioned workflows • Relational database support for GIS data management (providing the benefits of a relational database for scalability, reliability, security, backup, integrity, and so forth) • SQL types for spatial in all supported DBMSs (Oracle, SQL Server, PostgreSQL, Informix, and DB2) • High performance that can scale to a very large number of users DBMSs are efficient at retrieving and working with records containing the type of large geometry elements required for GIS data. In addition, GIS database sizes can be much larger, and the number of supported users greater, than with file -based GIS datasets. 9. Esri GIS ArcGIS: Geodatabase management ( Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-24 10. PROFILE: Azteca Systems CITYWORKS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-25 • 10. PROFILE: ACCELA I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-26 Agile Assets $ _ __. 2 12 0 ea` �� ��� \ti\�\�� y��� otJ �F � °� o�y\ e`�a y\�o \��� yeyy� � Ja�� aQ�\ o (P�°` ® 10. PROFILE: AGILE ASSETS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-27 Cartegraph 4 .. 3 2 _ ° �� _ _3 °� \ Q�v L° Ac�Q agcy\ C.°°cam \` 0-6\ 10. PROFILE: CARTEGRAPH I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-28 Elements _ T _. �. 2 _w 0= w.mom_ o oy� .���ti oto- ' �A� sae ��e\ opP � � o L vo tih �0 10. PROFILE: ELEMENTS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-29 Energov _ _. 3 4 - 2 �C 1 _ et,\ A�'� 10. PROFILE: ENERGOV I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-30 10. PROFILE: INFOR/HANSEN I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-31 "Tin 91411111 C' Lucity (GBA) 4_, 2 A �y5� �J�Q taoc�\`�'\-` 10. PROFILE: LUCITY (GBR) I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-32 1 1 Jam] Maintenance 5 _ W_ 3 2 °h��° 5 Q;``'�> " op \<�e� ec'� ohh� ��t�� ,o��° aQQ��� t��No� `\c o�Qac o� O� \>`e� 10. PROFILE: MAINTENANCE CONNECTION I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-33 10. PROFILE: IBM MAXIMO I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-34 10. PROFILE: ORACLE I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-35 WIN Pubworks v — 4 3 2 u._ Q fat 0 voma o°' �A oy��a :,Zp \a\\tia o`�,e"moo \"\5 ",� o ��� �� \�� o, L `e5 aQP t�N\ Qa�A pta 0 N� ° 10. PROFILE: PUSWORKS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-36 Vueworks S 4 3 2 & 6 �, � yaw \�o� Ora \`e�y \`oma LQ�ZCP t 10. PROFILE: VUEWORKS I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-37 1 ''1 Cityview 5 -- 4 _ w- w — _ 2 p '90 CF, A t�I` e�y\ ��Q Py5 aha �`�C"� < � ?t111 10. PROFILE: CITYVIEW I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-38 11® WATER U'TILI'TIES: INN®VYZE Innovyze is a leading global provider of wet infrastructure business analytics software solutions designed to meet the technological needs of water and wastewater utilities, government industries, and engineering organizations worldwide. Underground infrastructure is rapidly deteriorating and many utilities struggle with developing a rehabilitation and replacement program that addresses the most critical pipes in the system. Many capital improvement programs spend millions of dollars annually, but often do little to lower total system risk. CapPlan Water offers utilities the tools in one off-the-shelf software package to build or refine the capital improvement plans to provide maximum benefit for the lowest cost. Determining the likelihood of failure for a pressurized underground water pipe is a critical task. CapPlan Water combines infrastructure, hydraulic, spatial, and historical data from numerous sources to estimate for likelihood of failure. Understanding the consequences of a pipe failing is critical to determining its replacement priority. CapPlan Water has powerful tools to assess the hydraulic, geographic, spatial, and public relations criticality of each pipe in the system—including automatically taking each pipe out of service and determining the hydraulic and water quality consequences. A Risk Factor is determined for each pipe based on the Likelihood and Consequence of Failure. CapPlan Water has a wide range of budgeting options available to evaluate the highest priority pipes within existing budgets and to determine necessary budgets over the long-term to mitigate high risk levels. n ..., ,: ,. q n r1 .t cA al •, r ,,� w .. , ..,... i •;4. O.te�. Ur: 'x 'x :. . `N :Sr ,M 100641P TfE T. %7 +:; �U ,i, r1��-NY a�c� .1 ¢•r W 11. WATER UTILITIES: INNOVYZE I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-39 12. REFERENCES The Water Research Foundation would like to acknowledge and thank the researchers and contributors to this study. • American Public Works Association (APWA) members www.apwa.net • California Society of Municipal Finance Officers (CSMFO) members www.csmfo.org • Government Finance Officers Associations (GFOA) members www.gfoa.org • Interviews of software marketing and technical staff at industry conferences. • http://resources.arcgis.com • http://www.fhwa.dot.gov • http://www.nrc-cnrc.gc.ca/eng/index.html • www.accela.com • www.agileassets.com • www.cartegraph.com • www.cityworks.com • www.elementsxs.com • www.energov.com • www.esri.com • www.infor.com • www.infotivity.com • www.innovyze.com • www.lucity.com • www.maintenanceconnection.com • www.msgovem.com • www.oracle.com • www.oracle.com • www.plantservices.com • www.pubworks.com • www.reliabilityweb.com • www.vueworks.com • www-Ol.ibm.com 12. REFERENCES I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-40 WFRF The Water Finance Research Foundation (www.Water FinanceRF.org) is a non-profit organization dedicated to finding solutions which help local governments and utilities address the challenges of aging infrastructure, funding and a declining workforce. The WFRF supports and provides research, surveys, analysis, publications and training concerning best practices for municipal and utility management. The WFRF promotes municipal infrastructure asset management practices for state, county and local governments which increase efficiencies while reducing long-term operations, maintenance, and capital costs. A special focus is on wet infrastructure which includes water, wastewater, storm drain and reuse. A core program also includes creating opportunities for the next generation to gain knowledge and experience through research and publication opportunities. The WFRF also strives to help municipalities and utilities explore financing and funding solutions which includes rate and fee increases, debt refinancing, private -public partnerships, grants and other innovative programs. The Water Finance Research Foundation is proud to sponsor and promote in 2013, The American Public Infrastructure Asset Management Association (API -AMA). API -AMA focuses on traditional municipal infrastructure asset management combined with public asset management (the connectivity of assets with business activities and citizens). The evolution and power of GIS and other technologies has increased our ability to translate data into intelligence for improved resource investment decision making. The American Public Infrastructure Asset Management Association API-AMAA represents: ■ Public Works Managers ■ Municipal and Utility Asset Managers • GIS Professionals • CMMS (Computerized Maintenance Management Systems) Personnel ■ Asset Management and Work Order Maintenance Management Software Managers ■ Risk Management Managers ■ Infrastructure and Design Engineers ■ Capital Funding and Budget Approval Professionals ■ Economic Development and Growth Planning Managers M WFRF I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-41 LEGAL NOTICE Please be advised, this study and survey was completed based on numerous sources including third parties and has not been independently verified. Software is continually updated and revised and the information and functionality assessment is evaluated at a point in time and does not represent future enhancements. WFRF assumes no legal liability or responsibility for the accuracy, completeness, or usefulness of any information, nor does the WFRF represent that its use would not infringe on any privately owned rights. This study may include facts, views, opinions and recommendations of individuals and organizations deemed of interest and assume the reader is sophisticated in this industry and will make their own independent decisions. Users waive any rights it might have in respect of this study under any doctrine of third -party beneficiary, including the contracts (Rights of Third Parties) Act 1999. The use of this study is at the users' sole risk and no reliance should be placed upon any other oral or written agreement, representation or warranty relating to the information herein. THIS STUDY IS PROVIDED ON AN "AS -IS" BASIS, WFRF DISCLAIMS ALL WARRANTIES OF ANY KIND, EXPRESSED OR IMPLIED, INCLUDING, WITHOUT LIMITATION, ANY WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON - INFRINGEMENT. WFRF, NOT ITS MEMBERS, AFFILIATES, SERVICE PROVIDERS, OFFICERS, DIRECTORS, OR EMPLOYEES SHALL BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF OR RELATING TO THIS REPORT OR RESULTING FROM THE USE OF THIS REPORT, INCLUDING BUT NOT LIMITED TO DAMAGES FOR LOSS OF PROFITS, FUTURE PROFITS, USE, DATA OR OTHER TANGIBLE DAMAGES, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. THE CONTENT OF THIS STUDY SHOULD NOT BE USED FOR ANY UNLAWFUL OR UNINTENDED PURPOSE. WFRF I Municipal Maintenance and Infrastructure Asset Management Systems Exhibit A H-42 "M I LLER 01 s es1'r• partner Network ` L)A I LAL_ S1_hV1f'I_S, 11C CITY OF RANCH® PAI,®S VERDES CITYWORKS IMPLEMENTATION PROPOSAL Nil3VY13 M, W WA I '' 9 00AKomi Miller Spatial Services, LLC offers a full -spectrum implementation and integration of Azteca's Cityworks asset management software for public works and utility districts. We have a team of GIS and database management experts who specialize in the implementation of Cityworks applications. The following schedule outlines a typical scope of work provided in our complete configuration package: TASKS & DESCRIPTION TIMELINE COST TASK 1- Business Process Analysis Meetings 6 Days $9,600 We will meet with key department personnel to document the specific business processes currently in place. Information collected will include the daily work orders and maintenance management cycles needed to be configured into Cityworks. This is an integral part of the process for us to capture the complete functionality of the current system and integrate those components into the Cityworks platform. We will also analyze the need for any additional hardware and 3rd party software add-ons. This task will take place onsite in workshop -style meetings with necessary IT and department managers, and may occur over 6 days. RPV will start internal meetings first to look at their coordinated processes. SUB -TASK 1.1- Project Management 20 Hours $2,100 Oversight of entire project will be managed by MSS to include: timeline, deliverables, contract management, and costs. TASK 2 - Database Configuration 7 Days $7,600 Using the current structure of the client's database, we will configure the data and GIS layers into Cityworks. ArcGIS Server is an optional add-on installation for data storage. The timeline for the database configuration will vary depending on the status of current stored data. This task will take place offsite. TASK 3 - Onsite Cityworks Installation 7 Days $9,800 The configured database and Cityworks software package (Cityworks Server AMS Standard ELA) will be installed onsite in the client's environment. Changes to the configuration can be made during this time. Storeroom Configuration will be part of this task. A meeting will need to be held with inventory controllers to discuss requirements prior to setup. TASK 4 - Administrator User Training 1 Da $1,170 Exhibit B H-43 MILLER s�ar1A1. sEV,vIc:i S, LLC psY' I-,rta Network We will provide onsite training for the primary, or "Administrator" users of Cityworks. The client will provide the training facility and computers necessary for staff use. TASK 5 - Additional Staff Training 3 Days $4,800 Following the training of Administrator users, we will conduct a "Train -the -Trainer" style session with key department staff. The purpose of this training is to provide the knowledge and steps necessary to train all other field personnel who will use the system. Training will be broken into small groups of users depending on work responsibility. TASK 7 - Post -Installation Support 40 Hours $6,000 After the configuration, installation and training phases have concluded, we will provide troubleshooting and support services of up to 40 hours (may be negotiable). This support will primarily be remote and take place offsite. TOTALS (Dependent on Add -Ons $41,070 Exhibit B H-44 Exhibit C w c 0 Z -. .. N 0 W v c 0 L m T E O T m O C m O O v c v c 0 L m CCT C O _T m O c m O O c Ln 0 v c 0 L m T E O 4- T m O C m O O 0 R � � � bA ° c T bA C � L o L 0 t p 4- L 'a 4 m T T v w > vOi = O ) C Q c }+ c u c L p c - m L >v° m o Ow 0 CL W L i _ -OO 0 0 m O p 41 O .A_ w (3) O -O v O O 'O N L O w otw 'O +' 0 L '++ L O '+ zo ? U ';" CTC C 7 U CTC C 'O O 7 U m 0 to CM � :3 N V m Y- M d T _ = T — E m C= io i m C 7 c C= O C N m m O Gl ++ O C O O C~^7 3 a N °X' c 3> �} V)- s W 0 s w w ++ v d cu w c = L w v N E E O tJ N v Q m u J v a O O w i i m Q u -� OL 4- '- w W m m � Q - Q o 0 0 + u m` 01 L > ' N 'i cN G N� c G m N m Q Q Z+ Q W Q c a. d)N N V1 W O CL N m u O Ln d U, 0 o Q O LU v p LU v v In m O p m O m D m L = a = a + z w G/ UE Z U Z E p c u LU 31 in E v N Q O N To i m a c 0 a -mm d m Ow O Q? O L Z w m i +. W N C N O. N a. O Y O O O in O bA O bA L O v 3: L O v 3 Q vOi U 'U L7 Exhibit C w c 0 Z -. .. N 0 v c 0 L m T E O T m O C m O O v c 0 L m CCT C O _T m O c m O O v c 0 L m T E O 4- T m O C m O O bA ° bA C N L t p L 'a CC C 06 > vOi co ) C Q }+ O L p L >v° L M Ow -O W L i _ -OO "- - m O p 41 O w O -O O O 'O N L O O 'O +' Q '++ '+ zo ? U ';" 7 U In 'O 7 7 U m W to CM 7 :3 N V m w Y = Q =3 WG1 C= , i w C= LO Gl C~^7 3 a c °X' c 3> s W s w w ++ v d cu w = V) �n w v N N W Q T c Q tJ N v Q m u J 0 '- v- -,.,4u O O L w M V) w i i m Q u -� OL 4- '- w W O m Q V) '^ U ++ N 'i U w m U a O- Q W CU I— a. N V1 ,+T. M CL N cr OCL Q w= o LU 31 in E CLm Q O .� i m p 0 i d m p O Q? L Q vOi U 'U L7 Q vOi U .� U C Q cOi� U .r O. E w 'a � m yW,1.;... E •_ a a a L L L > > > Gl 07 d C O. N N N d L O L O L O g 'g ag J U W U W U W 45 ` ` F \\\ / � d \\ @ 0 E e k \ ° 0 E E ? ° 0 E B S / c@ 0 E 2 \ / � 0 E B \ / / \\ ^ 0 \ u % \ \ \ ) �: o / Q) cu �� E \\k d$@$ c 2 E om u E = m ,_ c mQ)°— o\ = y u c / f 3 2 G /2 \ § { \ } \ / \ \ r 7 s E E \ { CL® z z @ < g - 2 ƒ c & 7 [ e = _ _ $ = 3 \« k 3 &\ % E; m t m 2 J .\ 2 g 2 f\ f/ Ci f f 0 U m ii 0/ Tj 0/ 0/\ 0/ .: _ 3 = o = U _ ° d E$$ E% 2 E J E 2 E k 0 7 k v 0 2] f* / J / 0 2 // \ j \ < \ �§ < 3 / s \ 3 \ 5 2 u0 7 0 7 © 0 3 - § \ \\ u 2E } u a 2 / u u > ® u c c 6 m 2@ 2@ a m t@ �«\ 0 W 0 u 0 o G a 0$ k \ k § § / / / § Exhibit C H-46