Loading...
HomeMy WebLinkAboutKittitas Cayenta SOW v3_Final STATEMENT OF WORK Between Kittitas County 205 W 5th Avenue, Suite 105 Ellensburg, WA 98926 USA And Cayenta, A Division of N. Harris Computer Corporation 8333 Eastlake Drive, Suite 101 Burnaby, British Columbia V5A 4W2 Canada For Cayenta V9.2 Upgrade + Oracle to SQL Server Conversion + HCM & Connect Implementation + Analytics & Operational Models Contents Executive Summary & Overview ................................................................................................................... 1 Customer Profile ........................................................................................................................................... 2 Project Start Pre-Requisites .......................................................................................................................... 4 Project Scope – Products & Services ............................................................................................................. 5 General ...................................................................................................................................................... 5 Version 9.2 Upgrade ................................................................................................................................. 6 Oracle to SQL Server Conversion .............................................................................................................. 6 Connect Web Products Implementation .................................................................................................. 6 New Product Implementation .................................................................................................................. 7 Health Check (FMS & HCM) ...................................................................................................................... 8 Deliverables Summary .................................................................................................................................. 9 Deliverables Detail ...................................................................................................................................... 11 Methodology & Schedule ........................................................................................................................... 28 Methodology ........................................................................................................................................... 28 Project Management .......................................................................................................................... 28 Environment Setup ............................................................................................................................. 29 Configuration ...................................................................................................................................... 29 New Feature Overview & Train-the-Tester Training........................................................................... 29 Testing ................................................................................................................................................. 29 Training ............................................................................................................................................... 29 Go Live ................................................................................................................................................. 30 Post Go-Live and Transition Support .................................................................................................. 30 Schedule .................................................................................................................................................. 30 Project Environments.................................................................................................................................. 30 Payment Milestones ................................................................................................................................... 31 Overall Terms & Termination...................................................................................................................... 34 Terms and Conditions ......................................................................................................................... 34 Termination ......................................................................................................................................... 35 Appendix A: Incident Priority Definitions ................................................................................................... 36 Appendix B: Change Control Process .......................................................................................................... 37 The purpose of this Statement of Work is to set forth in detail the Software and Services deliverables to be provided by HARRIS, the milestones, schedule and acceptance criteria for such deliverables, the process for changes in scope and the respective responsibilities of HARRIS and CLIENT in connection with this Statement of Work. HARRIS will be the Prime Contractor for all application software and Services being provided under the Contract with CLIENT. This Statement of Work shall be governed by the terms and conditions of the Software License, Implementation and Support Agreement, dated _______________ between N. Harris Computer Corporation and Kittitas County. IN WITNESS WHEREOF, a duly authorized representative of each party has executed this Statement of Work on the Effective Date: Kittitas County CAYENTA, a division of N. Harris Computer Corporation Name: Name: (Signature) (Signature) Name: Name: (Print) (Print) Title: Title: Date: Date: 1 Cayenta V9 Statement of Work Executive Summary & Overview Kittitas County (CLIENT) is embarking on an upgrade of Cayenta software to version 9.2 (the latest release available) as well as implementing a number of new products including several web-based Connect products, Operational Models and Analytics Frameworks. Under the direction of the CLIENT Project Owner, the CLIENT Project Manager will drive and oversee the project in coordination with the HARRIS Project Manager. CLIENT has requested to engage Cayenta (HARRIS) for value-added services related to the upgrade outlined in Deliverables. These services are not included in the Software and Maintenance Fees. During the project, if CLIENT needs to make any changes to the Upgrade Environment, the changes need to be approved by the HARRIS project team. Changes to the configuration or interfaces that are not advised by the HARRIS project team also need to be fully documented in CayStone. The ongoing operation for the Solution will be the responsibility of the CLIENT following the project Go-live date with the support of HARRIS. The CLIENT will transition to HARRIS Support after completion of the Transition period as outlined in the Deliverables below. HARRIS and CLIENT agree to schedule and begin the project within 90 days of signature. 2 Cayenta V9 Statement of Work Customer Profile 3 Cayenta V9 Statement of Work 4 Cayenta V9 Statement of Work Project Start Pre-Requisites HARRIS and CLIENT agree that the following pre-requisites are satisfied in order to begin work on this project. Any pre-requisites that are the responsibility of CLIENT will be considered out of scope of this project and any services required of HARRIS for CLIENT-owned pre-requisites will be addressed through the Change Control process outlined in this document. Pre-Requisite Responsible Party Cayenta software is at a minimum version of V7.9 CLIENT Hardware infrastructure required for the software environments specified in this document are ready for HARRIS to perform installation prior to the start date of this project. CLIENT Provide monitors with full HD (1920x1080) for CLIENT users of the Cayenta Software. CLIENT CLIENT will have resources assigned to work on the project as per the schedule defined in this document. This is inclusive of all project work including test execution, workshop & meeting participation as well as any other activities prescribed CLIENT 5 Cayenta V9 Statement of Work Project Scope – Products & Services This project will include the following components General This is a project involving multiple threads of work. However, there are tasks and activities that will be performed by both HARRIS and CLIENT that are applicable to many if not all threads of work. Those key activities are outlined below. Key responsibilities are also outlined on a deliverable-by-deliverable basis in the Deliverables section of this document. Key HARRIS Activities: • Prepare a project schedule that outlines all project activities for both HARRIS and CLIENT • Conduct a project kickoff meeting (remote) to provide a project overview to all stakeholders • Provision a CayStone project complete with core V9.2 test cases • Deliver train-the-tester training on new V9.2 features and modules in scope of this project • Provide testing support and incident remediation services as described in the Deliverables section of this document • Conduct weekly incident review meetings (during testing) • Conduct weekly project management meetings to review progress, risks, and issues • Conduct monthly Executive Steering Committee (ESC) meetings (shared responsibility with CLIENT project manager) • Prepare a go-live cutover checklist that details all the tasks needed to successfully complete a go-live cutover • Rehearse the go-live by conducting a mock go-live cutover, using the go-live cutover checklist • Schedule and execute the go-live cutover (outside of business hours) • Provide post go-live support to CLIENT as noted in the Deliverables section of this document Key CLIENT Activities: • Provision required hardware & infrastructure for HARRIS to install and configure all products in scope of this project • Participate in the development of the project schedule, identifying any key dates that need to be considered (ex. Regulatory deadline, vacation/blackout periods, year-end, etc.) • Participate in HARRIS-led overview & training sessions • Provide input and clarifications as required to support the configuration of the solution • Participate in weekly incident review meetings & project management meetings • Contribute to Executive Steering Committee presentations • Lead, manage and monitor all testing activities, ensuring that testing is successfully completed per the dates in the project schedule • Ensure that all logged incidents have sufficient detail for HARRIS to properly triage and remediate the incidents • Re-test corrected incidents in a timely manner • Develop custom test cases that are not included in the V9.2 core test cases provided by HARRIS • Contribute to the go-live cutover checklist and identifying CLIENT-specific tasks that may not be in the standard HARRIS cutover checklist 6 Cayenta V9 Statement of Work • Own and execute all go-live cutover checklist tasks (both for mock go-live and actual go-live) • Prepare for and deliver all end user training Version 9.2 Upgrade HARRIS will work with CLIENT to set up the new V9.2 solution. V9.2 offers a variety of new features and functionality. Key HARRIS Activities: • Install the V9.2 solution o New environment will utilize SQL Server as part of the Oracle to SQL Server migration • Configure the V9.2 solution for CLIENT testing • Provide overview training on new features of the V9.2 solution • Upgrade CLIENT Cognos installation (will be done as part of Cognos for SQL installation) • Provide three data refreshes (which also include Oracle to SQL conversions on each refresh) including one for testing, one for mock go live and one for go live Oracle to SQL Server Conversion HARRIS will migrate the solution from the current Oracle database platform to SQL Server as part of this project. Key HARRIS Activities: • Install the two staging environments (one for Oracle and one for SQL Server) in addition to the V92 PROD and V92 TEST environments (as outlined in the Environments section of this document) • Develop conversion scripts to migrate from Oracle to SQL Server • Execute three (3) conversions (to double as data refreshes for V9.2) 1. Testing conversion 2. Mock Go Live conversion 3. Go Live conversion • Provide testing support and incident remediation services as described in the Deliverables • HARRIS support for custom database objects (views, tables, stored procedures, functions, etc.) is not included in the scope of this project • HARRIS support for custom-developed (i.e. non-core) Cayenta objects such as reports, interfaces or portal stats is not included in the scope of this project Connect Web Products Implementation HARRIS will deliver the following web-based Connect products: • Connect Finance • Connect Employee • Connect Manager • Connect Time Entry 7 Cayenta V9 Statement of Work Key HARRIS Activities: • Install and configure each Connect web product • Provide a solution overview to CLIENT testers • Deliver training for CLIENT testers • Provide testing support and incident remediation services as described in the Deliverables New Product Implementation HARRIS will deploy several new products in the scope of this project. HARRIS will take a similar approach for each product to ensure a successful delivery. New modules to be rolled out as part of this project will include: • Human Capital Management (HCM) • Connect Suite o Connect Finance o Connect Employee o Connect Manager o Connect Time Entry • Grants Management • Miscellaneous AR & Payments Processing (for FMS) • Cayenta Analytics for FMS • Cayenta Analytics for HCM • Operational Models for FMS • Operational Models for HCM Key HARRIS Activities: • Overview session(s) to confirm configuration requirements • Install the modules • Configure the solution • Provide a solution overview • Deliver training for CLIENT testers • Provide testing support and incident remediation services as described in the Deliverables 8 Cayenta V9 Statement of Work Health Check (FMS & HCM) After the go-live, HARRIS and CLIENT will schedule a series of workshops with CLIENT core team members and subject matter experts to examine core business processes with the intention of identifying opportunities for improvement and how the Cayenta solution can contribute to these areas of improvement. Key HARRIS Activities: • Lead the Health Check workshops (onsite) • Document findings from the workshops • Prepare a document outlining targeted improvements that can be made via process and/or configuration changes Key CLIENT Activities • Ensure all required stakeholders attend the onsite sessions • Manage the logistics of the onsite meetings • Contribute to discussions during the Health Check workshops 9 Cayenta V9 Statement of Work Deliverables Summary Below is a summary list of the Services deliverables for the project. The Deliverables section itemizes each deliverable in detail regarding specific scope, responsibilities for HARRIS and CLIENT as well as acceptance criteria. Component Group Deliverable # Deliverable Name Cost Consulting Services 1.01 Project Management Services - Month 1 $17,600.00 1.02 Project Management Services - Month 2 $17,600.00 1.03 Project Management Services - Month 3 $17,600.00 1.04 Project Management Services - Month 4 $17,600.00 1.05 Project Management Services - Month 5 $17,600.00 1.06 Project Management Services - Month 6 $17,600.00 1.07 Project Management Services - Month 7 $17,600.00 1.08 Project Management Services - Month 8 $17,600.00 1.09 Testing Support - Month 1 $31,900.00 1.10 Testing Support - Month 2 $31,900.00 1.11 Testing Support - Month 3 $31,900.00 1.12 Testing Support - Month 4 $31,900.00 1.13 Testing Support - Month 5 $31,900.00 1.14 Testing Support - Month 6 $31,900.00 1.15 Mock Go Live $8,800.00 1.16 Go Live Services $8,800.00 1.17 Support Transition & Project Close $27,720.00 Consulting Services Total $377,520.00 Technical Services 2.01 CAYPROD92 Environment Build $8,800.00 2.02 CAYTEST92 Environment Build $8,800.00 2.03 Install Cognos for MS SQL $3,300.00 2.04 Connect Web Products Installation $6,600.00 2.05 New Test and Production Cayenta Software Manager installation $4,400.00 2.06 Data Conversion 1 $33,000.00 2.07 Data Conversion 2 (Mock Go Live) $33,000.00 2.08 Data Conversion 3 (Go Live) $33,000.00 Technical Services Total $130,900.00 Product Services 3.01 V9.2 Overview Training & Core Portals/Stats Training $1,760.00 3.02 CayStone Test Cases Setup $1,760.00 10 Cayenta V9 Statement of Work 3.03 FMS Scripting Assistance $1,760.00 3.04 HCM Module Delivered for Testing $35,200.00 3.05 Time-Based Employee Master Delivery for Testing $26,400.00 3.06 CONNECT Finance Delivery for Testing $22,000.00 3.07 CONNECT Time Entry Delivery for Testing $22,000.00 3.08 CONNECT Employee Delivery for Testing $22,000.00 3.09 CONNECT Manager Delivery for Testing $22,000.00 3.10 Implement New Equipment Module $5,280.00 3.11 Grants Module Delivered for Testing $33,000.00 3.12 Misc. AR Module Delivered for Testing $33,000.00 3.13 FMS Health Check $13,200.00 3.14 WMS Health Check $13,200.00 Product Services Total $252,560.00 BI Services 4.01 Custom portal stats and interfaces testing support (T&M) $2,640.00 4.02 FMS Operational Model Delivered for Testing $17,600.00 4.03 HCM Operational Model Delivered for Testing $17,600.00 4.04 FMS Analytics Module Delivered for Testing $17,600.00 4.05 HCM Analytics Module Delivered for Testing $17,600.00 BI Services Total $73,040.00 Project Total $834,020.00 11 Cayenta V9 Statement of Work Deliverables Detail Below is a detailed listing of all deliverables in scope of this project. With each deliverable are specific responsibilities to be performed by HARRIS and CLIENT respectively as part of completion of this deliverable. Acceptance criteria for each deliverable specifies the criteria by which CLIENT will accept the deliverable upon completion by HARRIS. Upon satisfying the acceptance criteria for the deliverable will make the deliverable eligible to be billed as defined in the Payment Milestones section of this document. Deliverable ID 1.01 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 1 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Develop the project schedule • Co-facilitate the project kickoff meeting with CLIENT Project Manager • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Co-facilitate project kickoff meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 1 of the project Deliverable ID 1.02 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 2 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members 12 Cayenta V9 Statement of Work CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 2 of the project Deliverable ID 1.03 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 3 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 3 of the project Deliverable ID 1.04 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 4 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings 13 Cayenta V9 Statement of Work Deliverable Acceptance Criteria End of Month 4 of the project Deliverable ID 1.05 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 5 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 5 of the project Deliverable ID 1.06 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 6 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 6 of the project Deliverable ID 1.07 Deliverable Type Fixed Price 14 Cayenta V9 Statement of Work Deliverable Name Project Management Services - Month 7 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 7 of the project Deliverable ID 1.08 Deliverable Type Fixed Price Deliverable Name Project Management Services - Month 8 Deliverable Description HARRIS will provide a Project Manager to manage the planned activities for the project in order to deliver the scope as defined in this document. Working with the CLIENT Project Manager, the HARRIS Project Manager will provide project management services as outlined in the Harris Responsibilities section of this deliverable. HARRIS Responsibilities • Prepare weekly status reports • Facilitate weekly status meetings • Co-facilitate monthly Executive Steering Committee meetings with CLIENT Project Manager • Provide management and direction to HARRIS project team members CLIENT Responsibilities • Provide input & feedback as required to weekly status reports • Provide input & feedback as required to Executive Steering Committee presentation • Co-facilitate monthly Executive Steering Committee meeting • Provide management and direction to CLIENT team members • Attend weekly status meetings Deliverable Acceptance Criteria End of Month 8 of the project Deliverable ID 1.09 Deliverable Type Fixed Price Deliverable Name Testing Support - Month 1 Deliverable Description HARRIS will provide testing support services to CLIENT during test execution by CLIENT HARRIS Responsibilities • Incident remediation, prioritizing work based on marked priority in the incident according to criteria defined in this document • Providing clarifications and guidance on new feature testing 15 Cayenta V9 Statement of Work CLIENT Responsibilities • Execute testing per test sets as defined in CayStone • Log incidents as issues arise with testing, ensuring that appropriate screenshots, verbiage and reproduction steps are documented in the CayStone incidents • Conduct validation testing on remediated incidents in a timely manner Deliverable Acceptance Criteria First month of CLIENT testing is complete Deliverable ID 1.10 Deliverable Type Fixed Price Deliverable Name Testing Support - Month 2 Deliverable Description HARRIS will provide testing support services to CLIENT during test execution by CLIENT HARRIS Responsibilities • Incident remediation, prioritizing work based on marked priority in the incident according to criteria defined in this document • Providing clarifications and guidance on new feature testing CLIENT Responsibilities • Execute testing per test sets as defined in CayStone • Log incidents as issues arise with testing, ensuring that appropriate screenshots, verbiage and reproduction steps are documented in the CayStone incidents • Conduct validation testing on remediated incidents in a timely manner Deliverable Acceptance Criteria Second month of CLIENT testing is complete Deliverable ID 1.11 Deliverable Type Fixed Price Deliverable Name Testing Support - Month 3 Deliverable Description HARRIS will provide testing support services to CLIENT during test execution by CLIENT HARRIS Responsibilities • Incident remediation, prioritizing work based on marked priority in the incident according to criteria defined in this document • Providing clarifications and guidance on new feature testing CLIENT Responsibilities • Execute testing per test sets as defined in CayStone • Log incidents as issues arise with testing, ensuring that appropriate screenshots, verbiage and reproduction steps are documented in the CayStone incidents • Conduct validation testing on remediated incidents in a timely manner Deliverable Acceptance Criteria Third month of CLIENT testing is complete Deliverable ID 1.12 Deliverable Type Fixed Price Deliverable Name Testing Support - Month 4 Deliverable Description HARRIS will provide testing support services to CLIENT during test execution by CLIENT 16 Cayenta V9 Statement of Work HARRIS Responsibilities • Incident remediation, prioritizing work based on marked priority in the incident according to criteria defined in this document • Providing clarifications and guidance on new feature testing CLIENT Responsibilities • Execute testing per test sets as defined in CayStone • Log incidents as issues arise with testing, ensuring that appropriate screenshots, verbiage and reproduction steps are documented in the CayStone incidents • Conduct validation testing on remediated incidents in a timely manner Deliverable Acceptance Criteria Fourth month of CLIENT testing is complete Deliverable ID 1.13 Deliverable Type Fixed Price Deliverable Name Testing Support - Month 5 Deliverable Description HARRIS will provide testing support services to CLIENT during test execution by CLIENT HARRIS Responsibilities • Incident remediation, prioritizing work based on marked priority in the incident according to criteria defined in this document • Providing clarifications and guidance on new feature testing CLIENT Responsibilities • Execute testing per test sets as defined in CayStone • Log incidents as issues arise with testing, ensuring that appropriate screenshots, verbiage and reproduction steps are documented in the CayStone incidents • Conduct validation testing on remediated incidents in a timely manner Deliverable Acceptance Criteria Fifth month of CLIENT testing is complete Deliverable ID 1.14 Deliverable Type Fixed Price Deliverable Name Testing Support - Month 6 Deliverable Description HARRIS will provide testing support services to CLIENT during test execution by CLIENT HARRIS Responsibilities • Incident remediation, prioritizing work based on marked priority in the incident according to criteria defined in this document • Providing clarifications and guidance on new feature testing CLIENT Responsibilities • Execute testing per test sets as defined in CayStone • Log incidents as issues arise with testing, ensuring that appropriate screenshots, verbiage and reproduction steps are documented in the CayStone incidents • Conduct validation testing on remediated incidents in a timely manner Deliverable Acceptance Criteria Sixth month of CLIENT testing is complete Deliverable ID 1.15 Deliverable Type Fixed Price 17 Cayenta V9 Statement of Work Deliverable Name Mock Go Live Deliverable Description HARRIS will conduct a mock-go live prior to the go-live, ensuring the cutover checklist is sufficient to ensure a successful cutover at go-live. HARRIS Responsibilities • Prepare mock go-live checklist • Review mock go-live checklist with CLIENT • Execute HARRIS-assigned tasks per the checklist • Make any necessary changes to checklist based on mock go-live execution CLIENT Responsibilities • Review mock go-live checklist and add any additional tasks for CLIENT • Execute CLIENT-assigned tasks per the checklist • Provide feedback on mock go-live execution for the purpose of checklist revision Deliverable Acceptance Criteria Completion of mock go-live activities per the mock go-live checklist Deliverable ID 1.16 Deliverable Type Fixed Price Deliverable Name Go Live Services Deliverable Description HARRIS and CLIENT will execute the assigned tasks, per the go-live cutover checklist, over the planned one (1) day go-live time frame. HARRIS Responsibilities • Execute HARRIS-assigned tasks per the go-live cutover checklist • HARRIS will be available on go-live weekend to perform HARRIS-assigned tasks per the go-live cutover checklist. CLIENT Responsibilities • Execute CLIENT-assigned tasks per the go-live cutover checklist • CLIENT will be available on go-live weekend to perform CLIENT-assigned tasks per the go-live cutover checklist. Deliverable Acceptance Criteria Completion of go-live activities per the go-live checklist and CLIENT can access and use the CAYPROD90 environment for production purposes Deliverable ID 1.17 Deliverable Type Fixed Price Deliverable Name Support Transition & Project Close Deliverable Description HARRIS transitions CLIENT from assigned Project Team back to Cayenta Support and formally closes the project. The period of post go-live support provided by the Project Team will be four (4) weeks from the date of go-live. Acceptance of this deliverable signifies the acceptance of the project and official project close. HARRIS Responsibilities • Facilitate handover meeting from Project Team to Cayenta Support • Deliver Support Transition document to CLIENT and Cayenta Support • Remediate P1 & P2 priority incidents CLIENT Responsibilities • Attend handover meeting • Validate & close P1 & P2 priority incidents Deliverable Acceptance Criteria HARRIS provides Support Transition document All P1 & P2 incidents logged for the project have been remediated Deliverable ID 2.01 18 Cayenta V9 Statement of Work Deliverable Type Fixed Price Deliverable Name CAYPROD92 Environment Build Deliverable Description HARRIS will set up the new CAYPROD90 environment which will be the primary environment used for testing during the project as well as the new production system after go-live. HARRIS Responsibilities • Install the Cayenta software • Conduct an environment audit, including technical and functional validation of the environment CLIENT Responsibilities • Provide required hardware & infrastructure necessary to host the CAYPROD90 environment as well as any other required infrastructure items • Provide access to the infrastructure to HARRIS Technical Resources Deliverable Acceptance Criteria CLIENT project team is granted access to and can log into the CAYPROD90 environment. Deliverable ID 2.02 Deliverable Type Fixed Price Deliverable Name CAYTEST92 Environment Build Deliverable Description HARRIS will set up the new CAYTEST90 environment which will be the new test system after go-live. HARRIS Responsibilities • Install the Cayenta software • Conduct an environment audit, including technical and functional validation of the environment CLIENT Responsibilities • Provide required hardware & infrastructure necessary to host the CAYTEST90 environment as well as any other required infrastructure items • Provide access to the infrastructure to HARRIS Technical Resources Deliverable Acceptance Criteria CLIENT project team is granted access to and can log into the CAYTEST90 environment. Deliverable ID 2.03 Deliverable Type Fixed Price Deliverable Name Install Cognos for MS SQL Deliverable Description HARRIS will install one Cognos 11 environment HARRIS Responsibilities • Perform a new installation of the Cognos 11 environment • Configure Test and Production Cayenta application to use the new Cognos 11 environment CLIENT Responsibilities • Provide the required server infrastructure for HARRIS to perform the install • Ensure HARRIS technical personnel have proper access to server infrastructure to perform the installation Deliverable Acceptance Criteria CLIENT project team are provided access to the Cognos 11 environment Deliverable ID 2.04 Deliverable Type Fixed Price 19 Cayenta V9 Statement of Work Deliverable Name Connect Web Products Installation Deliverable Description HARRIs will install the included Connect products HARRIS Responsibilities • Install Connect Finance • Install Connect Employee • Install Connect Time Entry • Install Connect Manager CLIENT Responsibilities • Provide the required server infrastructure for HARRIS to perform the install • Ensure HARRIS technical personnel have proper access to server infrastructure to perform the installation Deliverable Acceptance Criteria Connect Finance is installed Connect Employee is installed Connect Time Entry is installed Connect Manager is installed Deliverable ID 2.05 Deliverable Type Fixed Price Deliverable Name New Test and Production Cayenta Software Manager installation Deliverable Description HARRIS will deploy two new instances of the Cayenta Software Manager tool (PROD and TEST) to support the project HARRIS Responsibilities • Install the Cayenta Software Manager tool CLIENT Responsibilities • Provide required hardware & infrastructure necessary for the installation • Provide access to the infrastructure to HARRIS Technical Resources Deliverable Acceptance Criteria HARRIS installs the Cayenta Software Manager tool Deliverable ID 2.06 Deliverable Type Fixed Price Deliverable Name Data Conversion 1 Deliverable Description HARRIS will develop the conversion scripts required to migrate the CLIENT data from Oracle to the new SQL Server environment. This will include the removal of data related to the electrical services contained in the Oracle environment as well as converting data required for the HCM application as defined in this document. HARRIS will also migrate the custom database objects (views, functions, stored procedures) as indicated in this document. HARRIS will deliver the first completed conversion to set the stage for the testing phase of the project. HARRIS Responsibilities • Develop & test conversion scripts • Migrate custom objects (views, functions, stored procedures) • Convert required HCM data • Execute and deliver Conversion 1 for CLIENT testing • Produce audit reports & record counts • Remediate conversion issues as required 20 Cayenta V9 Statement of Work CLIENT Responsibilities • Provide input & clarification as required related to conversion & data mapping • Participate in workshops/meetings as required • Test & confirm data has been converted successfully/log detailed incidents for any issues • Provide a copy of the production Oracle database to be used for the conversion • Ensure critical processes are done before copy of Oracle (ex. Month end) • Remediate source data issues Deliverable Acceptance Criteria Conversion 1 is delivered with balanced audit reports and CLIENT signs off on submitted audit reports. Deliverable ID 2.07 Deliverable Type Fixed Price Deliverable Name Data Conversion 2 (Mock Go Live) Deliverable Description HARRIS to perform the second data conversion from Oracle to SQL Server. HARRIS Responsibilities • Develop & test conversion scripts • Migrate custom objects (views, functions, stored procedures) • Convert required HCM data • Execute and deliver Conversion 1 for CLIENT testing • Produce audit reports & record counts • Remediate conversion issues as required CLIENT Responsibilities • Test & confirm data has been converted successfully/log detailed incidents for any issues • Provide a copy of the production Oracle database to be used for the conversion • Ensure critical processes are done before copy of Oracle (ex. Month end) • Remediate source data issues Deliverable Acceptance Criteria Conversion 2 is delivered with balanced audit reports and CLIENT signs off on submitted audit reports. Deliverable ID 2.08 Deliverable Type Fixed Price Deliverable Name Data Conversion 3 (Go Live) Deliverable Description HARRIS to perform the third data conversion from Oracle to SQL Server. HARRIS Responsibilities • Develop ETL tool and scripts used for the conversion • Examining source database, identifying custom objects • Restore a copy of production Oracle to Oracle staging environment • Execute conversion • Copy converted database to SQL Production environment • Produce audit reports & record counts • Remediate conversion issues as required CLIENT Responsibilities • Test & confirm data has been converted successfully/log detailed incidents for any issues • Provide a copy of the production Oracle database to be used for the conversion • Ensure critical processes are done before copy of Oracle (ex. Month end) • Remediate source data issues 21 Cayenta V9 Statement of Work Deliverable Acceptance Criteria Conversion 3 is delivered with balanced audit reports and CLIENT signs off on submitted audit reports. Deliverable ID 3.01 Deliverable Type Fixed Price Deliverable Name V9.2 Overview Training & Core Portals/Stats Training Deliverable Description HARRIS will provide two overview sessions on the new V9.2 features HARRIS will provide an overview training session on how to use portals including core portals, online vs. batch processing, column modifications and export capabilities. HARRIS Responsibilities • Facilitate overview training sessions CLIENT Responsibilities • Attend overview training sessions Deliverable Acceptance Criteria HARRIS delivers the overview training sessions Deliverable ID 3.02 Deliverable Type Fixed Price Deliverable Name CayStone Test Cases Setup Deliverable Description HARRIS will set up the CayStone testing environment, granting access to all CLIENT testers and stakeholders required. HARRIS will provide the core V9.2 test cases. Any custom test cases will be the responsibility of CLIENT to develop. HARRIS Responsibilities • Create the new CayStone project with V9.2 core test cases • Provision access for all CLIENT testers CLIENT Responsibilities • Provide list of testers to HARRIS • Develop any required custom test cases Deliverable Acceptance Criteria CayStone project has been created and access provided to all testers listed by CLIENT Deliverable ID 3.03 Deliverable Type T&M Deliverable Name FMS Scripting Assistance Deliverable Description HARRIS to provide CLIENT with assistance in updating existing FMS scripts to ensure compatibility with V9 platform HARRIS Responsibilities • Perform services as requested CLIENT Responsibilities • Provide written approval to proceed with requested work Deliverable Acceptance Criteria CLIENT will be invoiced monthly for hours expended. Hours invoiced will not exceed allocated hours without written approval from CLIENT 22 Cayenta V9 Statement of Work Deliverable ID 3.04 Deliverable Type Fixed Price Deliverable Name HCM Module Delivered for Testing Deliverable Description HARRIS will conduct an overview session of the HCM module to show CLIENT how the module is used as well as elicit any additional configuration requirements. HARRIS will deliver a configured solution to CLIENT for testing of the HCM module and conduct a training/handover session for CLIENT testers. HARRIS Responsibilities • Facilitate the overview session • Configure HCM module • Facilitate the training session CLIENT Responsibilities • Attend overview session • Attend training session • Provide input/clarifications as required Deliverable Acceptance Criteria HARRIS delivers configured HCM module for testing Deliverable ID 3.05 Deliverable Type Fixed Price Deliverable Name Time-Based Employee Master Delivery for Testing Deliverable Description HARRIS will configure the Time-Based Employee Master and deliver an overview session to CLIENT HARRIS Responsibilities • Configure Time-Based Employee Master • Provide overview session CLIENT Responsibilities • Attend overview session • Provide input/clarifications as required Deliverable Acceptance Criteria HARRIS delivers configured Time-Based Employee Master module for testing Deliverable ID 3.06 Deliverable Type Fixed Price Deliverable Name CONNECT Finance Delivery for Testing Deliverable Description HARRIS will configure the Connect Finance application for CLIENT testing. HARRIS Responsibilities • Configure the Connect Finance application • Conduct unit testing • Facilitate a handover training session in preparation for CLIENT testing CLIENT Responsibilities • Provide input/clarifications as required • Attend handover/training session Deliverable Acceptance Criteria HARRIS delivers the configured Connect Finance application for CLIENT testing 23 Cayenta V9 Statement of Work Deliverable ID 3.07 Deliverable Type Fixed Price Deliverable Name CONNECT Time Entry Delivery for Testing Deliverable Description HARRIS will configure the Connect Time Entry application for CLIENT testing. HARRIS Responsibilities • Configure the Connect Time Entry application • Conduct unit testing • Facilitate a handover training session in preparation for CLIENT testing CLIENT Responsibilities • Provide input/clarifications as required • Attend handover/training session Deliverable Acceptance Criteria HARRIS delivers the configured Connect Time Entry application for CLIENT testing Deliverable ID 3.08 Deliverable Type Fixed Price Deliverable Name CONNECT Employee Delivery for Testing Deliverable Description HARRIS will configure the Connect Employee application for CLIENT testing. HARRIS Responsibilities • Configure the Connect Employee application • Conduct unit testing • Facilitate a handover training session in preparation for CLIENT testing CLIENT Responsibilities • Provide input/clarifications as required • Attend handover/training session Deliverable Acceptance Criteria HARRIS delivers the configured Connect Employee application for CLIENT testing Deliverable ID 3.09 Deliverable Type Fixed Price Deliverable Name CONNECT Manager Delivery for Testing Deliverable Description HARRIS will configure the Connect Manager application for CLIENT testing. HARRIS Responsibilities • Configure the Connect Manager application • Conduct unit testing • Facilitate a handover training session in preparation for CLIENT testing CLIENT Responsibilities • Provide input/clarifications as required • Attend handover/training session Deliverable Acceptance Criteria HARRIS delivers the configured Connect Manager application for CLIENT testing 24 Cayenta V9 Statement of Work Deliverable ID 3.10 Deliverable Type T&M Deliverable Name Implement New Equipment Module Deliverable Description HARRIS will conduct an overview session and configure/implement New Equipment Module functionality, based on the outcome of discovery. HARRIS Responsibilities • Facilitate the discovery session • Document requirements pertaining to New Equipment Module functionality. • Perform related configuration and conversion based on the discovery. • Assist with testing the newly implemented module. CLIENT Responsibilities • Attend discovery session • Provide decisions needed to confirm requirements and sign-off on the requirements • Functional and integrated testing on the new module Deliverable Acceptance Criteria CLIENT confirms the delivered requirements document covers all requirements needed to implement New Equipment Module functionality. CLIENT will be invoiced monthly for hours expended. Hours invoiced will not exceed allocated hours without written approval from CLIENT Deliverable ID 3.11 Deliverable Type Fixed Price Deliverable Name Grants Module Delivered for Testing Deliverable Description HARRIS will conduct an overview session of the Grants module to show CLIENT how the module is used as well as elicit any additional configuration requirements. HARRIS will deliver a configured solution to CLIENT for testing of the Grants module and conduct a training/handover session for CLIENT testers. HARRIS Responsibilities • Facilitate the overview session • Configure Grants module • Facilitate the training session CLIENT Responsibilities • Attend overview session • Attend training session • Provide input/clarifications as required Deliverable Acceptance Criteria HARRIS delivers configured Grants module for testing Deliverable ID 3.12 Deliverable Type Fixed Price Deliverable Name Misc. AR Module Delivered for Testing Deliverable Description HARRIS will conduct an overview session of the Miscellaneous AR module to show CLIENT how the module is used as well as elicit any additional configuration requirements. HARRIS will deliver a configured solution to CLIENT for testing of the Miscellaneous AR module and conduct a training/handover session for CLIENT testers. 25 Cayenta V9 Statement of Work HARRIS Responsibilities • Facilitate the overview session • Configure Miscellaneous AR module • Facilitate the training session CLIENT Responsibilities • Attend overview session • Attend training session • Provide input/clarifications as required Deliverable Acceptance Criteria HARRIS delivers configured Miscellaneous AR module for testing Deliverable ID 3.13 Deliverable Type Fixed Price Deliverable Name FMS Health Check Deliverable Description After the project has gone live at a time determined collaboratively between HARRIS and CLIENT, HARRIS will conduct a Health Check on CLIENT usage of the FMS solution. Sessions allocated for health check review will focus on improving the processes so as the result the customer can be more efficient in their day to day activities. The result of these sessions is a detailed report with summary of findings and the next steps and recommendations. Any resulting configuration or system changes requiring Cayenta involvement will be managed through the Change Control process. HARRIS Responsibilities • Facilitate the Health Check Sessions • Prepare & Present Health Check Report CLIENT Responsibilities • Participate in Health Check Sessions Deliverable Acceptance Criteria FMS Health Check report delivered and presented Deliverable ID 3.14 Deliverable Type Fixed Price Deliverable Name WMS Health Check Deliverable Description After the project has gone live at a time determined collaboratively between HARRIS and CLIENT, HARRIS will conduct a Health Check on CLIENT usage of the FMS solution. Sessions allocated for health check review will focus on improving the processes so as the result the customer can be more efficient in their day to day activities. The result of these sessions is a detailed report with summary of findings and the next steps and recommendations. Any resulting configuration or system changes requiring Cayenta involvement will be managed through the Change Control process. HARRIS Responsibilities • Facilitate the Health Check Sessions • Prepare & Present Health Check Report CLIENT Responsibilities • Participate in Health Check Sessions Deliverable Acceptance Criteria WMS Health Check report delivered and presented Deliverable ID 4.01 Deliverable Type T&M 26 Cayenta V9 Statement of Work Deliverable Name Custom portal stats and interfaces testing support (T&M) Deliverable Description T&M hours to be used for updating of custom portal stats and interfaces, as needed for the upgrade. HARRIS Responsibilities • Perform services as requested CLIENT Responsibilities • Provide written approval to proceed with requested work Deliverable Acceptance Criteria CLIENT will be invoiced monthly for hours expended. Hours invoiced will not exceed allocated hours without written approval from CLIENT Deliverable ID 4.02 Deliverable Type Fixed Price Deliverable Name FMS Operational Model Delivered for Testing Deliverable Description HARRIS will configure the FMS Operational Model for CLIENT testing and provide a training session to set up CLIENT for testing. HARRIS Responsibilities • Configure FMS Operational Model • Deliver overview session CLIENT Responsibilities • Attend overview session Deliverable Acceptance Criteria HARRIS delivers FMS Operational Model for testing Deliverable ID 4.03 Deliverable Type Fixed Price Deliverable Name HCM Operational Model Delivered for Testing Deliverable Description HARRIS will configure the HCM Operational Model for CLIENT testing and provide a training session to set up CLIENT for testing. HARRIS Responsibilities • Configure HCM Operational Model • Deliver overview session CLIENT Responsibilities • Attend overview session Deliverable Acceptance Criteria HARRIS delivers HCM Operational Model for testing Deliverable ID 4.04 Deliverable Type Fixed Price Deliverable Name FMS Analytics Module Delivered for Testing Deliverable Description HARRIS will configure the FMS Analytics Module for CLIENT testing and provide a training session to set up CLIENT for testing. HARRIS Responsibilities • Configure FMS Analytics Module • Deliver overview session 27 Cayenta V9 Statement of Work CLIENT Responsibilities • Attend overview session Deliverable Acceptance Criteria HARRIS delivers FMS Analytics Module for testing Deliverable ID 4.05 Deliverable Type Fixed Price Deliverable Name HCM Analytics Module Delivered for Testing Deliverable Description HARRIS will configure the HCM Analytics Module for CLIENT testing and provide a training session to set up CLIENT for testing. HARRIS Responsibilities • Configure HCM Analytics Module • Deliver overview session CLIENT Responsibilities • Attend overview session Deliverable Acceptance Criteria HARRIS delivers HCM Analytics Module for testing 28 Cayenta V9 Statement of Work Methodology & Schedule Methodology Cayenta follows a practiced and proven methodology for delivering projects to our customers. Below is an overview of our project phases. Project Management HARRIS will provide a project manager to the project to oversee the HARRIS team and to work with the CLIENT project manager. The HARRIS project manager will be responsible for the following items: • Develop and maintain the project schedule, collaborating with CLIENT project manager. • Schedule and facilitate weekly PM meetings. • Schedule and facilitate weekly team meetings. • Develop go-live cutover checklist, collaborating with HARRIS and CLIENT project teams • Ownership of the Change Control process as outlined in the Change Control section of this document Schedule development is a collaborative task – the initial timeframe reflects the pricing provided, and a final schedule is dependent on the completion of project planning, where tasks and dependencies are finalized, resource allocation is confirmed and all non-working days are identified. A finalized project schedule must be delivered and baselined before the environment setup begins, and material changes to the initial schedule may require a change order. Any deviation from this process must be agreed to by the project teams. HARRIS agrees to provide project management services on a monthly basis as outlined in the deliverables of this document. Should there be a need to extend project management services from Environment Setup PGL Support Go Live Tes ng End ser Training Train the Tester Training Project Management Mock 1 2Conversion Development Product Con gura on Tes ng Support 29 Cayenta V9 Statement of Work HARRIS beyond what is currently scoped in this document, additional months of testing support may be added to the project at a cost determined through the Change Control process. Environment Setup HARRIS will create the environments required for the project, as defined in this document in the Project Environments section. This requires CLIENT to ensure that any server infrastructure required by HARRIS is provisioned and accessible by the HARRIS team. Configuration HARRIS will perform required configuration services to deliver the products to CLIENT in a test-ready fashion. Both HARRIS and CLIENT recognize that there may be configuration rework required as testing progresses however any significant configuration rework that is not the direct result of incorrect configuration by HARRIS may require a monetary change order New Feature Overview & Train-the-Tester Training HARRIS will provide solution overview with a focus on new features offered in the new version of the software. HARRIS consultants will work with CLIENT testers to deliver the training required for CLIENT testers to execute test cases for the project. HARRIS will also ensure that CLIENT testers have access to the CayStone environment and that all core test cases are available for CLIENT testers to execute testing against. Testing Application testing will be the most critical phase of this project and allows CLIENT to ensure a level of comfort with the delivered solution prior to going live. HARRIS will provide testing support commensurate with the services outlined in the Deliverables section of this document. CLIENT will test the application and configured solution delivered by HARRIS. CLIENT agrees to use the CayStone testing platform, provided by HARRIS to plan test cases/test sets, track all testing progress via updating of executed test cases/test sets and log incidents for all defects found. Should CLIENT decide to forego the use of CayStone for these purposes (i.e., using alternate means to plan and track testing and incidents), HARRIS may initiate the change control process (per the Change Control section of this document) to determine impacts to the project, monetary and otherwise. HARRIS agrees to provide testing support services on a monthly basis as outlined in the deliverables of this document. Should there be a need to extend testing support services from HARRIS beyond what is currently scoped in this document, additional months of testing support may be added to the project at a cost determined through the Change Control process. Training HARRIS will provide training on the new features of the solution early in the project in advance of the testing phase. This training will include an overview of the new features and products in scope of the project as well as CayStone training for those testers who are not familiar with it. CLIENT will be responsible for the development of customized end user training materials as well as the delivery of the end user training. 30 Cayenta V9 Statement of Work Go Live HARRIS and CLIENT will work collaboratively to prepare a go-live cutover checklist, drawing on templates that HARRIS will provide. It will be a shared responsibility between HARRIS and CLIENT to ensure that all tasks are documented and assigned appropriately. A mock go-live will be conducted approximately 4-6 weeks before the planned go-live to ensure that the cutover checklist is fully comprehensive with respect to the go-live tasks. HARRIS and CLIENT will schedule the go-live to take place over a weekend or a mutually agreeable timeframe. Post Go-Live and Transition Support HARRIS project team will continue to support CLIENT during the defined post go-live period (as indicated in the Deliverables section of this document) as well in this time engage Cayenta Support by preparing a Support Transition document, outlining the details of the implementation relevant to the Cayenta Support team taking on stewardship of CLIENT support needs going forward. A transition meeting including the HARRIS project team, CLIENT and Cayenta Support will be facilitated by HARRIS as part of this transition. Schedule This is an 8-month project (including 1-week of Support transition), plus an additional 3-weeks of Support transition (for a total of 4-weeks of Support transition), followed by a return to Standard Support. The schedule has been estimated based on assumed resourcing capabilities of CLIENT and is subject to change upon planning and coordination between HARRIS and CLIENT. Upon starting the project, the HARRIS project manager will collaborate with CLIENT Project Manager to baseline the project schedule. Project Environments CLIENT agrees to the provision of infrastructure required to support the following net new environments required for the project. Environment Name Purpose CAYPROD92 To be used as the primary environment for the project during testing as well as the production environment upon go-live CAYTEST92 To be used as the test environment on the new platform after go-live Oracle Staging To be used as the data staging environment for Oracle data for the Oracle to SQL conversion SQL Staging To be used as the data staging environment for SQL Server data for the Oracle to SQL conversion 31 Cayenta V9 Statement of Work Payment Milestones Below is a list of the payment milestones for this project. CLIENT agrees to pay the milestones upon completion of the mapped deliverables according to the defined acceptance criteria in this document for each deliverable. MP# Payment Milestone Description Invoice Amount Deliverable ID Deliverable Name MP01 Project Management Services - Month 1 $17,600.00 1.01 Project Management Services - Month 1 MP02 Project Management Services - Month 2 $17,600.00 1.02 Project Management Services - Month 2 MP03 Project Management Services - Month 3 $17,600.00 1.03 Project Management Services - Month 3 MP04 Project Management Services - Month 4 $17,600.00 1.04 Project Management Services - Month 4 MP05 Project Management Services - Month 5 $17,600.00 1.05 Project Management Services - Month 5 MP06 Project Management Services - Month 6 $17,600.00 1.06 Project Management Services - Month 6 MP07 Project Management Services - Month 7 $17,600.00 1.07 Project Management Services - Month 7 MP08 Project Management Services - Month 8 $17,600.00 1.08 Project Management Services - Month 8 MP09 Testing Support - Month 1 $31,900.00 1.09 Testing Support - Month 1 MP10 Testing Support - Month 2 $31,900.00 1.10 Testing Support - Month 2 MP11 Testing Support - Month 3 $31,900.00 1.11 Testing Support - Month 3 MP12 Testing Support - Month 4 $31,900.00 1.12 Testing Support - Month 4 MP13 Testing Support - Month 5 $31,900.00 1.13 Testing Support - Month 5 MP14 Testing Support - Month 6 $31,900.00 1.14 Testing Support - Month 6 MP15 Mock Go Live $8,800.00 1.15 Mock Go Live MP16 Go Live Services $8,800.00 1.16 Go Live Services MP17 Support Transition & Project Close $27,720.00 1.17 Support Transition & Project Close MP18 CAYPROD92 Environment Build $8,800.00 2.01 CAYPROD92 Environment Build MP19 CAYTEST92 Environment Build $8,800.00 2.02 CAYTEST92 Environment Build MP20 Install Cognos for MS SQL $3,300.00 2.03 Install Cognos for MS SQL MP21 Connect Web Products Installation $6,600.00 2.04 Connect Web Products Installation MP22 New Test and Production Cayenta Software Manager installation $4,400.00 2.05 New Test and Production Cayenta Software Manager installation MP23 Data Conversion 1 $33,000.00 2.06 Data Conversion 1 MP24 Data Conversion 2 (Mock Go Live) $33,000.00 2.07 Data Conversion 2 (Mock Go Live) MP25 Data Conversion 3 (Go Live) $33,000.00 2.08 Data Conversion 3 (Go Live) MP26 V9.2 Overview Training & Core Portals/Stats Training $1,760.00 3.01 V9.2 Overview Training & Core Portals/Stats Training MP27 CayStone Test Cases Setup $1,760.00 3.02 CayStone Test Cases Setup MP28 HCM Module Delivered for Testing $35,200.00 3.04 HCM Module Delivered for Testing MP29 Time-Based Employee Master Delivery for Testing $26,400.00 3.05 Time-Based Employee Master Delivery for Testing 32 Cayenta V9 Statement of Work MP30 CONNECT Finance Delivery for Testing $22,000.00 3.06 CONNECT Finance Delivery for Testing MP31 CONNECT Time Entry Delivery for Testing $22,000.00 3.07 CONNECT Time Entry Delivery for Testing MP32 CONNECT Employee Delivery for Testing $22,000.00 3.08 CONNECT Employee Delivery for Testing MP33 CONNECT Manager Delivery for Testing $22,000.00 3.09 CONNECT Manager Delivery for Testing MP34 Implement New Equipment Module $5,280.00 3.10 Implement New Equipment Module MP35 Misc. AR Module Delivered for Testing $33,000.00 3.12 Misc. AR Module Delivered for Testing MP36 FMS Health Check $13,200.00 3.13 FMS Health Check MP37 WMS Health Check $13,200.00 3.14 WMS Health Check MP38 FMS Operational Model Delivered for Testing $17,600.00 4.02 FMS Operational Model Delivered for Testing MP39 HCM Operational Model Delivered for Testing $17,600.00 4.03 HCM Operational Model Delivered for Testing MP40 FMS Analytics Module Delivered for Testing $17,600.00 4.04 FMS Analytics Module Delivered for Testing MP41 HCM Analytics Module Delivered for Testing $17,600.00 4.05 HCM Analytics Module Delivered for Testing Fixed Price Implementation Sub-total $796,620.00 MP42 FMS Scripting Assistance $1,760.00 3.03 FMS Scripting Assistance MP43 Grants Module Delivered for Testing $33,000.00 3.11 Grants Module Delivered for Testing MP44 Custom portal stats and interfaces testing support (T&M) $2,640.00 4.01 Custom portal stats and interfaces testing support (T&M) T&M Implementation Sub-total $37,400.00 FEE-01 3rd Party AcuCobol one-time migration fee $2,600.00 N/A Due on contract signing LIC-01 Cayenta Analytics - FMS: License Fee $10,000.00 N/A Due on contract signing LIC-02 Cayenta Analytics - FMS & HCM: 3rd Party License Fee $15,000.00 N/A Due on contract signing LIC-03 Operational Models - FMS: License Fee $10,000.00 N/A Due on contract signing LIC-04 Miscellaneous AR and Payments Processing: License Fee $10,000.00 N/A Due on contract signing LIC-05 Grant Management: License Fee $10,000.00 N/A Due on contract signing LIC-06 Cayenta Analytics - HCM: 3rd Party License Fee $5,000.00 N/A Due on contract signing LIC-07 Operational Models - HCM: License Fee $10,000.00 N/A Due on contract signing New Fee/License Sub-total $72,600.00 Project Total $906,620.00 MN-01 Annual Fee: Cognos Administrator $2,500.00 N/A Due upon installation MN-02 Annual Fee: Cayenta Analytics - FMS $2,500.00 N/A Due upon installation MN-03 Annual Fee: Operational Models - FMS $2,500.00 N/A Due upon installation 33 Cayenta V9 Statement of Work MN-04 Annual Fee: Miscellaneous AR & Payment Processing $2,500.00 N/A Due upon installation MN-05 Annual Fee: Grant Management $2,500.00 N/A Due upon installation MN-06 Annual Fee: Cayenta Analytics - HCM $2,500.00 N/A Due upon installation MN-07 Annual Fee: Operational Models - HCM $2,500.00 N/A Due upon installation SUB-01 Annual Fee: Connect Finance Base $10,020.00 N/A Due upon installation SUB-02 Annual Fee: Connect Finance Expense Entry $2,400.00 N/A Due upon installation SUB-03 Annual Fee: Human Capital Management (HCM) $16,800.00 N/A Due upon installation SUB-04 Annual Fee: Connect Employee $13,650.00 N/A Due upon installation SUB-05 Annual Fee: Connect Manager $10,020.00 N/A Due upon installation SUB-06 Annual Fee: Connect Time Entry $12,960.00 N/A Due upon installation Annual Costs (Year 1) Total: $83,350.00 34 Cayenta V9 Statement of Work Overall Terms & Termination Terms and Conditions 1. All subscriptions, as well as license fees and related support/maintenance, shall be billed upon signing the Statement of Work, unless otherwise noted in this document. 2. Pricing is fixed for scope as defined by this document unless it is noted as Time and Material in the Table of Services and excludes any applicable taxes. 3. Additional services deemed out of scope (per this document) will be billed at $220 per hour and will require documentation from HARRIS and the CLIENT and compliance with the Change Control Process. 4. CLIENT will provide a direct connection to the Server on which the database resides. 5. CLIENT will provide any necessary infrastructure for the project. 6. Both HARRIS and CLIENT will ensure members are available on dates agreed to and scheduled. 7. Change Orders will be created for any tasks that are requested outside the scope of the project and will follow the Change Control Process. 8. HARRIS reserves the right to alter/enhance APIs (as well as decommission, and in some cases replace APIs). Work to update Custom Portals is not covered by Standard Support and if needed is billable and may require a Change Order (if the time is not already built into the project plan). Additionally, any 3rd party costs to update interfaces which call Cayenta APIs are the responsibility of CLIENT. 9. Additional full data refreshes after the start of the project will be an additional cost and will be managed through the change control process 10. All project work is planned as remote, except for Health Checks. 11. Hardware costs are priced/managed directly by CLIENT. 12. HARRIS reserves the right to pause work upon notification to CLIENT if HARRIS invoices become aged greater than 60 days. 13. In the event CLIENT terminates this Agreement, CLIENT shall be invoiced for work done to date as of notification and CLIENT will pay all outstanding Fees and other amounts owing to Harris under this Agreement. 14. Actual travel and living expenses will be billed as incurred without any mark-up. Cayenta will work to minimize travel and living expenses. Expenses include: a. Airfare b. Lodging c. Per Diem (HARRIS policy allows for $65/day for week days ($130 for weekends and holidays) d. Ground transportation (taxis, rental cars, fuel, tolls, parking, business miles) e. Office supplies/services (as required) f. Internet access (airline) HARRIS travel guidelines will be adhered to by HARRIS personnel traveling to CLIENT. 35 Cayenta V9 Statement of Work Termination Unless HARRIS and/or CLIENT exercises its right to terminate this Statement of Work due to material breach or default, HARRIS must provide, and the CLIENT must purchase, Services from HARRIS for the items defined within this Statement of Work. The CLIENT obligations include the following: 1. Complete payment for services performed and expenses incurred prior to termination including: a. Any amount previously invoiced but unpaid. b. Fees for services performed through termination date which have not been invoiced; and c. Any approved Travel and Living costs incurred. If HARRIS terminates this Statement of Work without cause, then it shall: 1. Provide notice of 10 calendar days for termination without cause. 2. Refund to the CLIENT any fees that have not been earned under this Statement of Work through the termination date. Under no circumstances shall HARRIS be liable for any special, indirect, consequential, punitive, or incidental damages of any kind, including but not limited to loss of revenue, loss of profits, loss of business opportunity, loss of data arising out of or in connection with this scope statement, even if HARRIS has been advised of the possibility of such damages. In any event. HARRIS shall not be liable to pay any amount, in the aggregate, that is greater than the fees received by HARRIS under this Statement of Work. 36 Cayenta V9 Statement of Work Appendix A: Incident Priority Definitions HARRIS and CLIENT agree to use the following priority definitions when prioritizing incidents logged during the project. Priority 1 – Critical • System Down (Software Application, Hardware, Operating System, Database) • Application errors without workarounds that prevent testers from testing. • Incorrect calculation errors impact a majority of data. • Aborted postings or error messages preventing data integration and update. • Performance issues of severe nature impacting critical processes • Performance issues impacting critical processes. • Critical incidents assigned back to CLIENT need to be validated within a business day. Note: the existence of a reasonable work-around precludes a Priority 1 or Priority 2 issue in most cases. Priority 2 - High • Application errors that have workarounds impacting business, but the workaround is either complex or time consuming and significantly affects productivity after go- live. • Calculation errors impacting a minority of records. • Report generation failures impacting critical processes. • Report calculation issues • Data Security issues • Printer related issues (related to interfaces with our software and not the printer itself) • High Priority incidents assigned back to CLIENT need to be validated within 2- 3 business days. Priority 3 – Medium • Application errors/issues that have workarounds impacting business, but the workaround is either complex or time consuming • Report formatting issues • Issues with workarounds for large majority of accounts • Some recommendations for enhancements on application changes • Performance issues not impacting critical processes. • Usability issues • Medium Priority incidents assigned back to CLIENT need to be validated within 5 business days. 37 Cayenta V9 Statement of Work Appendix B: Change Control Process The "Change Control Process" governs changes to the Project parameters (scope, schedule, budget, quality, risk) during the life of the Project. Change Orders can be requested by HARRIS or CLIENT; however, all Change Orders must be approved in writing by both HARRIS and CLIENT before any changes are formally accepted into the project. No Change Order shall become effective unless mutually agreed to in writing by both parties. No work, other than estimating, will be performed on a Change Order by HARRIS until sign off has been obtained by the parties. There will not be fees charged by HARRIS to provide estimates for Change Orders. To effectively control changes to the project, HARRIS uses an industry standard Change Control process to assess all impacts of a potential project change. The Change Control process is described below: Change Request Submission CLIENT and/or HARRIS identify a need for a change to the project and submit a request. It is expected that the party raising the request will provide as much relevant information as possible at the time of raising the request to support proper impact assessment activities. Such a request must be in writing and identify the business and other reasons for the requested change and the impact it would have if the change were agreed upon, which may include Budget, Deliverables, Milestone Payments, Schedule, Risks, and Resources. Change Request Assessment HARRIS and CLIENT Project Managers will assess the potential change and the impact on budget, schedule, quality, resources, and risks. Where applicable, options will be defined and documented. Change Order (document) The HARRIS Project Manager will prepare a formal Change Order document and submit it to the CLIENT for review. The Change Order document will contain at a minimum: • Business reason/justification for the change • Detailed description of the change • Impact assessment of the change • Any payment milestone revisions impacted by the change (projected billing dates and invoice amounts) • Project impacts of not approving the change Any Deliverables that have already been completed and accepted by the CLIENT that are subsequently altered because of a Change Order must be appropriately revised, pursuant to the Change Order, with the change number and date noted. An updated version of such a Deliverable will then be signed and stored with the project documentation. CLIENT and HARRIS will review the Change Order for approval or rejection. Change Order Review Period After any request for a Change Order is made, the parties will have five (5) business days, or any additional, mutually agreed upon period, to consider the request (the “Change Order Review Period”). 38 Cayenta V9 Statement of Work The Change Order Review Period will commence the day the Change Order request is received in writing by the party being asked for the Change Order. During the Change Order Review Period, HARRIS will provide the CLIENT with all information material to the requested Change Order, regardless of which party initiated the Change Order, including but not limited to any additional fees that would be incurred, the impacts on the relevant Deliverables, and any alteration of the MS Project Schedule that would result if the Change Order were agreed to. HARRIS will also, during the Change Order Review Period, provide a time and materials or a Fixed Price cost based on the CLIENT’s desired pricing model. During the Change Order Review Period, the CLIENT will provide HARRIS with any information reasonably requested by HARRIS to evaluate any Change Order requested by CLIENT. Change Order Approval If both the CLIENT and HARRIS agree to the change, all relevant terms shall be documented in the Change Order. Any charges not already specified in the Statement of Work, or which are different than those in this Statement of Work will be noted in the Change Order. Any additional services performed by HARRIS because of a Change Order will require the payment to HARRIS of additional fees as agreed. Upon approval, CLIENT and HARRIS will sign the Change Order document and have the executed copy stored in the project document repository. Change Order Rejection If agreement on a requested Change Order does not occur by the end of the Change Order Review Period, the change order is considered rejected. At this point, either party may initiate the conflict resolution process set forth in this Statement of Work regarding the requested Change Order, unless the change solely regards a Deliverable that was completed and accepted before the request for the Change Order was made. Change Request/Change Order Log HARRIS will maintain an ongoing log of all Change Orders during the life of the project. This will be accessible to CLIENT. Conflict Resolution Process HARRIS recommends three levels for conflict escalation: 1. Project Managers to 2. Sponsors/Director to 3. Executive (VP, EVP, GM). One representative from HARRIS and representatives from CLIENT are designated at each level. All issues must be in written form – providing details, impacts and alternative resolutions. If the parties are unable to resolve a dispute through this informal process, then they will follow the formal Dispute Resolution process that is set forth in the Software Implementation Services Agreement.