Loading...
R2021-030 2021-02-08RESOLUTION NO. R2021-30 A Resolution of the City Council of the City of Pearland, Texas, authorizing the purchase of Asset Management Integration Services, from New Edge, in the estimated amount of $172,920.00. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City has obtained competitive pricing for the purchase of Asset Management Integration Services through its Interlocal Agreement Purchasing Partner, the City of Rockwall. Section 2. That the purchase of Asset Management Integration Services from New Edge, is hereby authorized and approved. Section 3. That the City Manager or his designee is hereby authorized to execute and the City Secretary to attest a contract for the purchase of Asset Management Integration Services. PASSED, APPROVED and ADOPTED this the 8th day of February, A.D., 2021. VIN COLE AYOR AT C': STAL ROAN, TRMC, CMC CITY SECRETARY APPROVED AS TO FORM: DARRI " M. COKER CITY ATTORNEY City of Pearland 3519 Liberty Drive Pearland, TX 77581 General Services Contract This Contract (Contract) is made between the City of Pearland, Texas (City), and Contractor. The City and Contractor agree to the terms and conditions of this Contract, which consists of the following parts: I. Summary of Contract Terms II. Signatures III. Standard Contractual Provisions IV. Special Terms and Conditions V. Additional Contract Attachments I. Summary of Contract Terms. Contractor: Description of Services: Contract Type: Effective Date: Termination Date: Renewal: New Edge Services, LLC 9191 Kyser Way, #103 Frisco, TX 75033 Contractor will provide Asset Management integration services, for the City of Pearland, per the specifications of implementation plan and schedule dated December 23, 2020, interlocal with City of Rockwall and R2021-30. Unit Price Contract, Estimated Amount of $172,920.00. March 1, 2021 February 28, 2024 No renewal options available II. Signatures. By signing below, the parties agree to the terms of this Contract: CITY OF PEARLAND: Purchasing Officer 3 ? 2021 Date *Si ned b ate: L/ 7h tin-, 1r��--4 City nager T Assistant City Manager Director Superintendent/Manager *Contract Signature Authority: Superintendent/Manager -$5,999 or Tess Director - $6,000 to $30,000 City Manager/Assistant City Managers - $30,001 to $50,000 City Council Resolution - $50,000+ Page 1 of 4 III. Standard Contractual Provisions. A. Definitions. Contract means this Standard Services Contract. Services means the services for which the City solicited bids or received proposals as described in Exhibit A, attached hereto. B. Services and Payment. Contractor will furnish Services to the City in accordance with the terms and conditions specified in this Contract. Contractor will bill the City for the Services provided at intervals of at least 30 days, except for the final billing. The City shall pay Contractor for the Services in accordance with the terms of this Contract, but all payments to be made by the City to Contractor, including the time of payment and the payment of interest on overdue amounts, are subject to the applicable provisions of Chapter 2251 of the Government Code. C. Termination Provisions. (1) City Termination for Convenience. Under this paragraph, the City may terminate this Contract during its term at any time for the City's own convenience where the Contractor is not in default by giving written notice to Contractor. If the City terminates this Contract under this paragraph, the City will pay the Contractor for all services rendered in accordance with this Contract to the date of termination. (2) Termination for Default. Either party to this Contract may terminate this Contract as provided in this paragraph if the other party fails to comply with its terms. The party alleging the default will give the other party notice of the default in writing citing the terms of the Contract that have been breached and what action the defaulting party must take to cure the default. If the party in default fails to cure the default as specified in the notice, the party giving the notice of default may terminate this Contract by written notice to the other party, specifying the date of termination. Termination of this Contract under this paragraph does not affect the right of either party to seek remedies for breach of the Contract as allowed by law, including any damages or costs suffered by either party. (3) Multi -Year Contracts and Funding. If this Contract extends beyond the City's fiscal year in which it becomes effective or provides for the City to make any payment during any of the City's fiscal years following the City's fiscal year in which this Contract becomes effective and the City fails to appropriate funds to make any required Contract payment for that successive fiscal year and there are no funds from the City's sale of debt instruments to make the required payment, then this Contract automatically terminates at the beginning of the first day of the City's successive fiscal year of the Contract for which the City has not appropriated funds or otherwise provided for funds to make a required payment under the Contract. D. Liability and Indemnity. Any provision of any attached contract document that limits the Contractor's liability to the City or releases the Contractor from liability to the City for actual or compensatory damages, loss, or costs arising from the performance of this Contract or that provides for contractual indemnity by one party to the other party to this Contract is not applicable or effective under this Contract. Except where an Additional Contract Document provided by the City provides otherwise, each party to this Contract is responsible for defending against and liable for paying any claim, suit, or judgment for damages, loss, or costs arising from that party's negligent acts or omissions in the performance of this Contract in accordance with applicable law. This provision does not affect the right of either party to this Contract who is sued by a third party for acts or omissions arising from this Contract to bring in the other party to this Contract as a third -party defendant as allowed by law. E. Assignment. The Contractor shall not assign this Contract without the prior written consent of the City. F. Law Governing and Venue. This Contract is governed by the law of the State of Texas and a lawsuit may only be prosecuted on this Contract in a court of competent jurisdiction located in or having jurisdiction in Brazoria County, Texas. G. Entire Contract. This Contract represents the entire Contract between the City and the Contractor and supersedes all prior negotiations, representations, or contracts, either written or oral. This Contract may be amended only by written instrument signed by both parties. H. Independent Contractor. Contractor shall perform the work under this Contract as an independent contractor and not as an employee of the City. The City has no right to supervise, direct, or control the Contractor or Contractor's officers or employees in the means, methods, or details of the work to be performed by Contractor under this Contract. The City and Contractor agree that the work performed under this Contract is not inherently dangerous, that Contractor will perform the work in a workmanlike manner, and that Contractor will take proper care and precautions to insure the safety of Contractor's officers and employees. I. Dispute Resolution Procedures. The Contractor and City desire an expeditious means to resolve any disputes that may arise between them regarding this Contract. If either party disputes any matter relating to this Contract, the parties agree to try in good faith, before bringing any legal action, to settle the dispute by submitting the matter to mediation before a third party who will be selected by agreement of the parties. The parties will each pay one- half of the mediator's fees. J. Attorney's Fees. Should either party to this Contract bring suit against the other party for breach of contract or for any other cause relating to this Contract, neither party will seek or be entitled to an award of attorney's fees or other costs relating to the suit. K. Severability. If a court finds or rules that any part of this Contract is invalid or unlawful, the remainder of the Contract continues to be binding on the parties. IV. Special Terms or Conditions. None. V. Additional Contract Documents. The following specified documents attached to this Contract are part of this Contract. Any provision contained in the Contractor's Additional Contract Documents that conflicts with this Contract shall have no legal effect. A. Contractor's Additional Contract Documents: 1. The contractor's response to implementation plan and schedule dated December 23, 2020 and interlocal with City of Rockwall, shall be construed as additional contract documents. 2. Executed Contractor Insurance Requirements & Agreement (required insurance certificate[s] shall be in possession of City at actual commencement of work). B. City's Additional Contract Documents: 1. Scope of Services as listed on the attached. EXHIBIT A CONTRACTOR'S SCOPE OF SERVICES Scope of services shall consist of the contractor providing integration of Asset Management integration services for the City of Pearland, as needed, per the specifications of implementation plan and schedule, interlocal with City of Rockwall and R2021-30. Pricing is as follows per contractor's response to the same, as listed on attached pages: Exhibit A-1— Scope of Services, December 23, 2020 EXHIBIT A-1 SCOPE OF SERVICES December 23, 2020 Im • lementation Plan and Schedule The section below details the NewEdge strategy and process for implementing Cityworks Server AMS for the City. For this implementation, the City should have a dedicated resource to the implementation team who will act as our interface to GIS, IT and departmental staff. Certain tasks will require this individual to spend up to 100% of their time, but on average the staff requirement to assist the implementation team will fall between 60-80%. NewEdge understands that the City is requesting the implementation of a Work Order and Asset Management system for the following divisions/departments: • Water Production Facilities • Wastewater Treatment Facilities • Water Distribution (water infrastructure, pump stations and tanks) • Wastewater Collection (wastewater infrastructure and lift stations) • Street Maintenance • Traffic (signs, signals and markings) • Parks and Recreation • City Facilities Maintenance • Fleet Maintenance • ROW Maintenance NewEdge Implementation Strategy and Tasks The following project approach covers the methodology for all departments and divisions listed above. The implementation of Cityworks Server AMS, from the kickoff meeting to go -live takes approximately 6 months. Additional tasks in this proposal such as data imports and integrations can extend the schedule 2 to 6 months. NewEdge understands that during the COVID pandemic not all meetings can occur on -site. While the NewEdge team prefers to be on -site and working directly with our clients our first priority is to keep both our clients and staff safe and healthy. In the case that NewEdge cannot be on -site, our staff can accommodate all aspects of the project remotely via WebEx and/or Microsoft Teams. Should the City allow vendors on -site for training, on -site support, key meetings, etc, NewEdge will adhere to the City's guidelines for safety during the pandemic. Task 1 — Software Acquisition Azteca Systems, Inc. (Azteca) is the recognized leader in Enterprise GIS-centric Computerized Maintenance Management Systems. NewEdge understands the City of Pearland will purchase the Cityworks Server AMS Premium ELA licensing through a separate contract with Cityworks. Once the City receives their license file from Cityworks, NewEdge will assist on installing and configuring the Cityworks software. Task 2 — Kick -Off Meeting and Technical Review NewEdge kicks off all projects with an on -site meeting with its clients; during which time, we collect information for input into the Cityworks database such as employee lists, materials, etc. Prior to the kickoff meeting NewEdge will distribute our best practice excel sheets that document typical workflow processes for service requests, work orders and inspections New€dge The format of this meeting is broken down into the following sessions and NewEdge will perform these discussions with each department/division • Introductory Presentation — NewEdge introduces Cityworks and our implementation plan. • Technical Review— Conducted with GIS and IT staff, NewEdge will perform a technical design and system architecture review and perform a GIS Data Review. NewEdge will discuss, in-depth, UniquelDs for GIS features and their importance in Cityworks. • Datasource Review —Review existing sources forwork order activity with project manager and supervisors. • Materials, Equipment and Labor Review — Review existing sources for work activity costs — material, labor and equipment. Review formats needed in Cityworks and provide import spreadsheets for the City to populate. NewEdge will discuss labor rates for employees and how to track inCityworks. • Reporting Requirements — Collect sample reports from the City and discuss high-level reporting requirements. Deliverables: AMS meetings 4 days on -site with each division being implemented, best practice spreadsheets. Task 3 — Cityworks Database Design and Configuration The NewEdge implementation team will use information collected from the kick-off and technical review meetings to configure the Cityworks database. Configuration of the Cityworks database will include: Service Requests Problem Codes Service Request Templates Submit To / Dispatch To Names Configured Work Orders Work Activities / Templates Employee Lists Materials Storeroom Configuration Inventory Equipment Inventory Asset — GIS Data Inspections Inspection Types Inspection Schedule Reporting Custom Queries and Inboxes Crystal Reports This task is constant throughout the project duration. The Cityworks database will continuously evolve during reviews, on -site meetings, training, and on -site support. Rather than relying on long periods of user testing and acceptance, NewEdge relies on regular reviews with the client. With this philosophy, NewEdge staff and our clients are in constant communication and on the same page. Configuration of the Cityworks database will be performed in the NewEdge hosted solution. The City will have access to the test environment throughout the duration of the project. Deliverables: Test environment configured in NewEdge cloud. Pearland user access for testing, review, etc. Task 4 — Workflow Assessment NewEdge will return for an on -site workflow assessment. Conducted by NewEdge staff, the team will perform a detailed review of existing workflows and business processes. Workflows will be reviewed using the configured Cityworks database from Task 3. Modifications can be made to the database at this time. The team will review current workflow procedures and propose changes or modifications to current processes that align more closely with practices and procedures utilized by the Cityworks AMS software. The team will determine the roles and responsibilities of the users accessing the system and establish the domain, role, and template level security. Deliverables: AMS meetings 4 days on -site, business process mapping to detail current processes and suggestions for modifications to the current procedures. 111111111116. NewEdge Task 5 — On -Site Review of Cityworks Database NewEdge will perform an on -site database review of the Cityworks database configuration with City staff. The team will review all aspects of the Cityworks database to verify if the workflow of service requests and work orders and inspections is correct, then configure any necessary database changes. Deliverables: AMS meetings 4 days on -site Task 6 — Training/On Site Support NewEdge's philosophy of training is to be on -site and interact with users. During implementations, NewEdge provides two levels of training. The first level is a classroom style training where the instructor describes software functionality and conducts live demonstrations. Users should have their own machines and field devices for the classroom training so they can interact with the software and perform the classroom exercises. Our second level of training is the on -site support week. While we call this support, it is training. This is the time when NewEdge team members work one-on-one with the software users. Users can ask questions and receive clarification on software while performing their daily work activities. NewEdge finds this a critical step in the implementation process. This also allows us the opportunity to fine-tune the database and streamline workflow processes. Classroom Training The NewEdge team will conduct on -site training of the Cityworks AMS software system. For each phase NewEdge will be on site. Administrator Training (1/2 day) — Targeted for "super users" of the system. Users are responsible for the underlying Cityworks database and on -going system maintenance. This training is not required if the client utilizes the NewEdge Hosted Solution. Designer Training (1/2 day) — Targeted for users who maintain lists and codes. Attendees manage employee lists, materials, equipment and modify or add additional workflows. User Training (1-day sessions) — Designed for system users who regularly interact with Cityworks. This training should include users entering service requests, work orders, performing inspections and will use Cityworks to generate reports. The number of sessions will be determined by the number of users and disciplines being implemented. The City will be responsible for providing atraining facility, including computers configured to correct specifications for Cityworks software and connectivity to the Cityworks database. On -Site Support Once Cityworks is on-line and staff is trained, NewEdge will remain on -site to assist users as they encounter day-to-day business transactions within the software. This is a critical step of the process as it gives our implementers an opportunity to work directly with individual users. Staff can correct configuration issues, address training lapses, and finalize or modify work order procedures. The City will be responsible for setting up the schedule for on -site support. Each user should be dedicated one to two hours of individual support with NewEdge, depending on their roles and responsibilities with the software. During on -site support week, NewEdge offers specialized classes and meetings. These include: Supervisor Training (3-hour sessions) — While supervisors and directors are encouraged to attend User Training during training week, they will also perform operations such as searching and reporting that are not taught during the general training session. Supervisors will be taught how to utilize the Cityworks search engine, create lnboxes and create on -the -fly reports. Expectations for on -site support week and go -live will also be discussed. Equipment Change -Out (2-hour sessions) — For users that work with treatment plants, lift stations, pump stations, tanks, signs and signals. This training shows users how to use the Equipment Change Out module New€dge of Cityworks to update the asset inventory for related assets. Redlining and GIS Edits (2-hour sessions) — This training shows advanced users how to create redlines and if the City GIS staff allow how to edit GIS data through the Cityworks interface. Wrap Up Session (2-hour session) — Held at the end of on -site support week, the Wrap Up Session is for supervisors and directors to discuss with NewEdge staff procedures for the go -live. It is also a time to address issues and/or concerns with the implementation. Training materials are not provided in hard copy during the training sessions. A training guide is available within the Cityworks application and all training guides are available on the mycityworks.com for download and printing by the client. Training Deliverables: 1 week on -site for classroom training, 1 week on -site for on -site support. Task 7 - Storeroom Implementation The Cityworks Server AMS Premium ELA includes the Storeroom Inventory module. This module directly links inventory from the City's warehouse to the Cityworks work orders. Inventory through Storeroom can be issued to a person, account number and/or a work order. As inventory is added to work orders the inventory is adjusted in the Storeroom. When implementing Storeroom, workflow becomes very important. Warehouse/Storeroom discussions begin very early on in the implementation process and are a part of the three key review meetings mentioned above. Storeroom module training is offered during the training week and during on -site support NewEdge staff is in the warehouse working with those employees one on one. Deliverables: Deliverables track with the Cityworks Server AMS implementation deliverables, Tasks 2-6. Task 8 — Development of GIS Related Asset Inventory NewEdge staff offers GIS services for generating GIS layers for use with Cityworks. This is often data layers that are related assets in Cityworks or assets that you cannot see directly on a Cityworks map. Examples of these features include signs on traffic poles, treatment plant assets within buildings and offices or breakrooms within facilities. These assets must be in the GIS database to create work order and inspection templates for the related assets. Attaching work orders to these types of assets requires relationship classes be built in the GIS. NewEdge has several schemas for these tables and will work with City staff to review and modify these schemas as the City sees fit for its needs. This quote includes the generation of related assets for the: • Water Production Facilities • Wastewater Treatment Plants • Lift Stations • Traffic Signs, Signals and Markings • Fleet Assets • Facilities Should the City choose to generate their own GIS layers for related assets, NewEdge will share the default schema but will not assist the City with modifications or import into the City's GIS database. Optional Implementation Tasks Tasks 1 — 8 above are implementation tasks associated with the basic implementation of Cityworks Server AMS. These tasks allow the client to immediately start keeping track of service requests, work orders, 116,1 NewEdoe inspections and inventory in the Cityworks database. The following tasks are optional services that will enhance the client's use of the Cityworks application. Import of Historical HTE Data As with any significant data conversion process, it is critical to successfully complete the conversion of a pilot project area to establish and test the acceptance criteria and established quality standards, verify proposed conversion processes and methodologies, and verify the validity of the data model design. The pilot area will provide both City stakeholders and our configuration team with the opportunity to undertake a representative sample of the full -system data conversion efforts and perform a critical evaluation of results prior to moving forward with the full system conversion. Our configuration team will develop a mapping process to import the data into Cityworks after backup of the legacy data system has been received. After a full review of the pilot migration, to verify data integrity inside the Cityworks environment, our configuration team will perform a full migration from the original file formats into the Cityworks database. Our QA/QC program builds quality into the data deliverables from the beginning of the project, as opposed to "fitting it in at the end, to provide City staff with confidence that the data meets the established quality criteria and will support the forward movement of the Cityworks system. By adhering to the established QA/ QC standards and procedures we will provide the City of Pearland a proven approach with each conversion process. NewEdge understands the data from the HTE database currently used for work order management will be migrated to the Cityworks database. NewEdge Unique ID Tool Designed to work seamlessly with the GIS database, the NewEdge Unique ID Tool generates custom, unique IDs for GIS features with the following highlights: • Allows for multiple ID formats in the same attribute tables; Legacy ID's remain active • Globally unique IDs across database • Saves configuration for easy modifications • Automatically assigns IDs, eliminating user error or duplicate ID's generated through manual ID processes • Batch ID generation functionality - for use with new or imported datasets Implementation and Configuration of Cityworks Add -On Modules / Applications Tasks 1 — 7 are implementation tasks associated with the basic implementation of Cityworks Server AMS. These tasks allow the client to immediately start keeping track of requests, work orders and inspections in the Cityworks database. Task 9 is the implementation of additional applications and modules included in the Cityworks Server AMS Premium license that are quoted in this proposal. These add-ons are not required and can be implemented later. Descriptions of these add-ons can be found in the Additional Information section. Add -on modules in this proposal include: • Native Mobile App • Style Manager for Respond System Integrations / Interface Services See the Examples of Integrations section for details on system integrations. In -House Service Request Page for Facilities Maintenance The In -House Service Request Page utilizes the Cityworks Service Request API and allows internal users to request services for Facilities without having to log -in to the Cityworks application. The page allows users to enter the Request Type, Location, Requester Information and Comments. This will generate a Service Request in Cityworks that once created will fall into the normal workflow process in Cityworks for Facilities. Crystal Reports Training and Services Out of the Box Cityworks has on -the fly searching and reporting functionality. For custom report templates, Cityworks utilizes the Crystal Reports software to generate these custom templates. Crystal Reports is not NewEdc' included in the Cityworks software package. It must be purchased by the City through SAP. NewEdge offers a two-day Crystal Reports training. The training includes how to generate search queries and on -the -fly reports through the Cityworks interface but more focuses on using Crystal Reports and the Cityworks database to create custom reports. If the City prefers to opt -out of the Crystal Training, NewEdge staff does provide report generation services at an hourly rate. NewEdge offers a standard package of reports that includes print templates for work orders, service requests and inspections, email templates for all three and 10 standard reports such as a detailed work order print out. This package does not include customization of the report outside of a logo or City name. All costs for Crystal Reports options are provided in the Pricing section of this response. Cityworks Refresher Training NewEdge offers on -site refresher training. The training agenda can be modified as the client sees fit to include but not limited to: • General Cityworks usage — for new employees, etc. • Specific topics — attaching work orders to GIS features, searching, etc • Administrator refresher training • Minor system configuration changes such as template changes or custom fields* NewEdge staff will work with the City to identify areas of focus and the best use of the 3-day training. The pricing is for one NewEdge staff to be on -site for 3 days. The 24 hours can be divided as NewEdge and the City see fit. Newdye Third Part Inte • rations Below is a matrix and notes of the integrations requested by the City Integration / Description Type of Integration Integration Notes Bentley Water Gems Two -Way Requirements for this integration still need to be determined. This quote includes a two-way integration however, the price and scope is subject to chan•e based on the requirements of the inte.ration. Tokay & Linko Integration One-Wa Tokay & Linko are used for greasetrap inspections and manifests. This integration will be a one-way push from the Tokay database to Cityworks. IMS Street Data Integration One-Wa Information would be pushed from the delivered IMS spreadsheet to the GIS tables for PCI information. CitySourced (Rock Solid) for Citizen Engagement Support Only The City currently has CitySourced for citizen engagement. NewEdge will work with the City to ensure that configurations in the Cityworks application will work directly with the CitySourced software. APIs needed for this integration are included in the Cityworks Server AMS license listed in the cost .ro.osal. Integrations with Cityworks, will require the use of web services constructed with the Cityworks APIs. NewEdge will be responsible for coding the web services and API calls for receiving data from or exporting data to a third -party application, such as NewWorld or SCADA. The City will be responsible for obtaining the appropriate APIs and services from the third -party vendor to code the receives and/or exports from the third -party application. NewEdge staff will NOT be responsible for coding the APIs or developing the web services outside of the Cityworks application. The NewEdge methodology for integration is: • Discuss high-level requirements during the kick-off meetings and begin discussions with the City on third -party software and/or services required. Collect specific data requirements during the workflow assessment meetings. This will identify what data needs to be transferred from one system to another, how/when data is transferred, what are triggers for data transfer, requirements for one-way or two-way data transfer. NewEdge staff will code Cityworks APIs in the NewEdge hosted solution, initially in the City's hosted test environment. The goal is that simultaneously, the third -party vendor will also be working on their APIs and web services. They may occur in a test environment at the City, on a test environment the vendor supplies or in the City's production environment. Installation and testing of the integration services and APIs. Installation of the integration services and APIs in the production environment Prices for integrations in the proposal are estimates of work. Prior to finalizing the contract, NewEdge will require the City obtain documentation on the third -party vendor's APIs. This will allow NewEdge to determine the level of work involved in creating the integration. NewEdge may wish to speak with the third -party as well and develop high-level requirements to finalize the scope and pricing. Deliverables: Business process for integrations Newfdge Pricin • and Pa ment Schedule NewEdge Implementation Services for Cityworks Server AMS Software Total cost for all tasks listed for the Implementation Services for Cityworks Server AMS including the Optional Integrations is: $170,420.00. Task Name / Description Pricing Cityworks Server AMS Implementation Services $83,460.00 Cityworks Storeroom Implementation Services $9,360.00 Development of GIS Related Asset Inventory $12,500.00 Additional Services Historical Import of HTE Data $10,000.00 NewEdge Unique ID Tool $5,000.00 Configuration of Cityworks Add -On Modules $5,000.00 In -House Service Request Page for Facilities $3,900.00 Crystal Reports Training $2,080.00 Cityworks Refresher Training $3,120.00 Optional Integrations Bentley Water Gems $17,000.00 IMS Pavement Management $6,000.00 Tokay & Linko $10,000.00 CitySourced Integration Support $3,000.00 Implementation Milestone Completed Cost Pre -Kickoff Meeting (10% of Task Totals) • AMS Implementation Services ($8,346.00) • Storeroom Implementation ($936.00) • GIS Configuration Services ($1,250.00) • Import of HTE Data ($1,000.00) • Configuration of Add -On Modules ($500.00) • Unique ID Tool — 100% of application ($5,000.00) • In -House SR Page for Facilities — 50% of application ($1,950.00) $18,982.00 Kickoff (33% of Task Totals) • AMS Implementation Services ($19,195.80) • Storeroom Implementation ($2,152.80) • GIS Configuration Services ($2,875.00) • Import of HTE Data ($2,300.00) • Configuration of Add -On Modules ($1,150.00) $27,673.60 Workflow Assessment (66 % of Task Totals) • AMS Implementation Services ($27,541.80) • Storeroom Implementation ($3,088.80) • GIS Configuration Services ($4,125.00) • Import of HTE Data ($3,300.00) • Configuration of Add -On Modules ($1,650.00) $39,705.60 Database Review (75% of Task Totals) • AMS Implementation Services ($7,511.40) $10,828.80 NewEdge • Storeroom Implementation ($842.40) • GIS Configuration Services ($1,125.00) • Import of HTE Data ($900.00) • Configuration of Add -On Modules ($450.00) Go -Live (90% of Task Totals) • AMS Implementation Services ($12,519.00) • Storeroom Implementation ($1,404.00) • GIS Configuration Services ($1,875.00) • Import of HTE Data ($1,500.00) • Configuration of Add -On Modules ($750.00) • In -House SR Page for Facilities — 50% of application ($1,950.00) $19,998.00 Final Implementation Invoice (100% of Task Totals) • AMS Implementation Services ($8,346.00) • Storeroom Implementation ($936.00) • GIS Configuration Services ($1,250.00) • Import of HTE Data ($1,000.00) • Configuration of Add -On Modules ($500.00) $12,032.00 Crystal Reports Training — Conducted After Go -Live $2,080.00 Refresher Training — Conducted After Go -Live $3,120.00 Total Without 3rd Party Integrations $134,420.00 Continued support of the Unique ID Tool will be billed to the City yearly from the contract date. The cost of yearly maintenance is $2,500.00 NewEdge Third Party Integration Services and Continued Maintenance NewEdge will provide continued maintenance and support for integrations one year from the integration going live on the City's production environment. Following the initial year, for continued maintenance and support the City will pay a yearly maintenance fee for each integration. Total for all third party integration services: $36,000.00 Third Party Name Pricing Integration with Bentley Water Gems $17,000.00 $4,000.00 Yearly Maintenance IMS Pavement Management — push of PCI data to the GIS $6,000.00 $0.00 Yearly Maintenance Tokay & Linko Integration for Greasetrap Inspections and Manifests $10,000.00 $2,000.00 Yearly Maintenance CitySourced (Rock Solid) Integration — Support Services Only $3,000.00 $0.00 Yearly Maintenance Payment Schedule Integration Billing Schedule • 33% Billed of Integration Total, per Integration — Kick Off/Requirements • 60% Billed of Integration Total, per Integration — Testing/Acceptance of New�dyee Integration • 100% Billed of Integration Total, per Integration —Accepted installation on production New=d q __