Loading...
HomeMy WebLinkAboutWORK ORDER - PURCHASE ORDER - 9182028WORK ORDER PURSUANT TO A MASTER AGREEMENT BETWEEN THE CITY OF FORT COLLINS AND DATASPLICE LLC WORK ORDER NUMBER: 2 PROJECT TITLE: DataSplice Business Process, Prototype, and Configuration work for Water Engineering & Field Services (WEFS) Storm Water division ORIGINAL BID/RFP NUMBER & NAME: 8354 Maximo Mobile Product and Services MASTER AGREEMENT EFFECTIVE DATE: January 2, 2017 OWNER’S REPRESENTATIVE: Rick Morford WORK ORDER COMMENCEMENT DATE: March 12, 2018 WORK ORDER COMPLETION DATE: July 31, 2018 MAXIMUM FEE: (time and reimbursable direct costs): $ 78,242.50 PROJECT DESCRIPTION/SCOPE OF SERVICES: Work Order 2 is for Datasplice to develop WEFS Storm Water business processes, application configuration, prototype sessions, provide end-user training, and prepare Storm Water staff for production rollout and provide post production support. Service Provider agrees to perform the services identified above and on the attached forms in accordance with the terms and conditions contained herein and in the Master Agreement between the parties. In the event of a conflict between or ambiguity in the terms of the Master Agreement and this Work Order (including the attached forms) the Master Agreement shall control. The attached forms consisting of 6 pages are hereby accepted and incorporated herein, by this reference, and Notice to Proceed is hereby given after all parties have signed this document. SERVICE PROVIDER: Datasplice LLC. By: Date: Name: Scott Kunze Title: President ACCEPTANCE: Date: Nate Poppema, Datasplice Project Manager DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 3/15/2018 3/19/2018 OWNER’S ACCEPTANCE & EXECUTION: This Work Order and the attached Contract Documents are hereby accepted and incorporated herein by this reference. ACCEPTANCE: Date: Rick Morford, Project Manager ACCEPTANCE: Date: Coy Althoff, Utilities Asset Manager REVIEWED: Date: Pat Johnson, Senior Buyer ACCEPTANCE: Date: Gerry Paul, Purchasing Director (if greater than $60,000) DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 3/19/2018 3/19/2018 3/19/2018 3/21/2018 ATTACHMENT A Work Order 2: 2018 DataSplice WEFS Storm Water Scope of Work Project Objective: DataSplice will configure a Stormwater Application for the City of Fort Collins. DataSplice will leverage any configuration, mapping capabilities and other Work Management/Service Request functionality that was configured as part of the DataSplice Wastewater application. DataSplice will perform the initial ride alongs and workshops with the selected Stormwater Managers, Supervisors, Super Users and End Users. DataSplice and Fort Collins will develop a requirements document based on findings and discoveries during this process. DataSplice will finalize the configuration with an Agile Software approach based on feedback and requests received during scheduled Software Sprints. DataSplice has defined the phases and deliverables for the Stormwater project. Initial Requirements Gathering and Ride Alongs 1. DataSplice will coordinate with the FCU Stormwater project team (Subject Matter Expert (SME), Project Manager and DataSplice/Maximo Administrators) to employ standard requirements gathering methods. DataSplice is planning on going on ride-alongs with Stormwater FCU employees. DataSplice will gather information about the unique work processes and job functionality. DataSplice will implement the most efficient solution for the Stormwater including the mobile user interface design and other system requirements. DataSplice will interview at a minimum: project sponsor, core team, key stakeholders/Super Users, and FCU Stormwater IT. DataSplice will create a Requirements document for FCU Stormwater’s approval. Deliverables: 1.1.1.1. Requirements Document–This list of requirements will be used to trace requirements to on-site testing to ensure all requirements are traceable and all requirements are met from inception to implementation. Vendor Responsibilities: Coordinate with Fort Collins to perform workshops. Provide required documentation for FCU’s approval. The City Responsibilities: Participate in meetings and provide feedback/updates as needed. Provide access to the necessary systems required for DataSplice. Software Configuration 1. DataSplice will configure the system, in the Development environment, to meet the approved requirements, as determined by the findings in the requirements phase. The configuration of the DataSplice application is expected to include the Work Orders, Inspections, and GIS integrations. 2. DataSplice will modify the default COTS software screens and configuration to interoperate with FCU Stormwater’s instance of Maximo and its business processes. In addition to the COTS standard currently available features. 3. DataSplice will provide any required and related Maximo configuration to ensure that DataSplice is properly integrating with Maximo. If additional resources are required to perform any Maximo configuration, DataSplice will notify FCU Stormwater. Deliverables: 3.1.1.1. Configured DataSplice Stormwater Application in Maximo DEV and TRN DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 Environments. Vendor Responsibilities: Lead final Software Sprint meeting, provide updated documentation. The City Responsibilities: Participate in meetings and provide updates as requested. Final Sprint and Finalize Configuration 1. DataSplice will finalize the configured system in the Development and QA/Training environments, based on the finalized/approved requirements. DataSplice will assist with any required and related Maximo configuration to ensure that DataSplice is successfully integrating with Maximo. 2. DataSplice will modify the current software configuration to interoperate with the City’s instance of Maximo and its business processes. Deliverables: 1. Finalized Configuration. 2. Final Stormwater Software Sprint. 3. Finalized and locked down DataSplice configuration prior to UAT. Vendor Responsibilities: Lead final Software Sprint meeting, provide updated documentation. The City Responsibilities: Participate in meetings and provide updates as requested. User Acceptance Testing Support 1. DataSplice will provide support and guidance as required during UAT. DataSplice will be on-site at the designated City of Fort Collins location. Problems identified during UAT will be recorded as “Issues” with the City of Fort Collins project team. All issues will be resolved, canceled, or deferred (by the City of Fort Collins) prior to go-live. 2. DataSplice will have one technical resources available for support. City of Fort Collins will need to have multiple two (2) functional testers and two (2) technical support personnel during this phase. Deliverables: 1. Prepare updated User Acceptance Testing scripts based on any new changes that have been agreed to be included in the finalized configuration. 2. Support User Acceptance Testing on-site and collect reported defects, change requests and enhancements. Review list with the City of Fort Collins to determine included configuration items Vendor Responsibilities: Provide finalized UAT scripts, support UAT remotely and on- site based on finalized UAT agenda, The City Responsibilities: Coordinate UAT resources, provide necessary UAT hardware, determine final UAT planned activities, and execute DataSplice’s test scripts, review and prioritize UAT items. DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 Training 1. DataSplice to provide three (3) 2-hour Train-the-Trainer Trainings. DataSplice will record the meetings so Fort Collins can use this information as they provide their own End User Training. Deliverables: 1. Provide Training Documentation (User Guide and Cheat Sheet). 2. Perform Train-the-Trainer Training for the City of Fort Collins with the designated personnel to be agreed upon between DataSplice and the City. Vendor Responsibilities: Coordinate Training room and Trainers, provide access to DataSplice from a device (handheld, laptop, etc.). The City Responsibilities: Provide training to selected City of Fort Collins trainers. Provide updated training documentation, record training sessions and distribute to City of Fort Collins. Project Management 1. DataSplice provides project planning and oversight, time reporting, and DataSplice resource coordination. The DataSplice Project Manager works closely with the City Project Manager to ensure a successful outcome. 2. The City provides the lead project management resource effort. The DataSplice project team members participate in weekly project status meetings as scheduled by the City and agreed to by DataSplice. Verbal status reports are delivered during the status meetings. Additionally, written status reports are provided weekly via the City’s preferred format. Deliverables: 1. Weekly written status reports Issue log. 2. Weekly Status meetings Project schedules. Vendor Responsibilities: Provide weekly written status reports and participate in weekly meetings. The City Responsibilities: Participate in meetings and provide updates as requested. Assumptions: 2.1.1.1. DataSplice will finalize the configuration based on all feedback received through this stage of the project. DataSplice will produce a list that will include the configuration items that will be included in the Go-Live. 2.1.1.2. The Development and QA environments will be refreshed prior to UAT. DataSplice will be performing the majority of the configuration work in the QA environment until the Development is refreshed. 2.1.1.3. DataSplice will not be creating Work Orders on Service Lines. Exclusions: 1. End User training. 2. Additional configuration changes that were identified after final Prototype meeting. 3. Additional Software Development effort in excess of 4 days DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 4. Implementation of Post UAT Items that will require significant effort 5. End User or Administration Training 6. Production Go-Live Support 7. Post Production Configuration Support DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 ATTACHMENT B Work Order 2, 2018 DataSplice WEFS Storm Water schedule and task list 1.1. Schedule and Tasks 1.1.1. The period of performance for Work Order #2 will be from March 12, 2018 through July 31, 2018 as shown in the schedule below. DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77 ATTACHMENT C Work Order 2, 2018 Datasplice WEFS Storm Water cost details 1.2. Compensation 1.2.1. Dataplice proposed to perform Work Order 2 tasks on a time and materials of $191.25 per hour for Technical resources and $148.75 per hour for Project Management, including expenses. 1.2.2. The table below summarizes the price of work for Work Order 2. The MAXIMUM estimated compensation for Work Order 2 direct costs shall be $78,242.50. HOURS BREAKDOWN Change Order Tasks Project Manager - Nate Poppema Software Engineer - Mike Johnson Software Developer - Daniel Walker Hours Breakdown Hourly Rate $148.75 $191.25 $191.25 Initial Workshops and Requirements 4 32 4 40 Software Configuration 102 4 106 Software Sprints 1 and 2 4 8 4 16 Final Sprint and Finalize Configuration 4 44 48 Stormwater Development Configuration Effort 32 32 User Acceptance Testing and Support 12 52 64 Training and Training Documentation 4 36 40 Project Management 48 32 80 Total Planned Labor 76 306 44 426 Total Cost Breakdown $11,305.00 $58,522.50 $8,415.00 $ 78,242.50 1.3. Reimbursable Direct Costs 1.3.1. Reimbursable direct costs take the form of travel related costs. Total travel costs for the period of performance as defined by Work Order 2 are estimated at $0.00. 1.4. Maximum Compensation 1.4.1. The maximum compensation for both Labor time and Reimbursable direct costs as a not exceed is summarized in the table below. This agreement may not be modified, altered or amended except by written instrument duly executed by both parties, prior to work proceeding, for the proposed changes. Labor Direct Costs Total Not to Exceed (NTE) $ 78,242.50 $ 0.00 $ 78,242.50 DocuSign Envelope ID: F7DC6900-2764-45C0-AFA6-A6C991AA9E77