The URL can be used to link to this page

Home My WebLink About09.c EDB ES CVS and Cognizant CO4 EXECUTIVE SUMMARY AGENDA ITEM: Proposed Change Order No. 4 to the Statement of Work for Workday Report Development with Collaborative Solutions LLC. (CSLLC),an Affiliate of Cognizant Worldwide Limited(Cognizant) Date: December 11,2025 BACKGROUND: Staff seek to develop and implement several standardized reports and dashboards in Workday.We continue to expand our use of the platform as a core Enterprise Resource Platform. While progress has been made using Workday's standard template reports and dashboards, staff require additional expertise from professionals with extensive Workday development experience to enhance and expand reporting capabilities for improved management insight and decision-making. CSLLC and Cognizant implemented CCUA's Workday system and were subsequently engaged to support the deployment of Workday's Inventory Module. As a result, they maintain important institutional knowledge of CCUA's Workday tenant configuration, making them well positioned to assist with the current needs. The proposed scope of work includes the development of cascading dashboards that provide cumulative and Monthly Budget-Expense summaries. These dashboards will begin at a high-level core competency level and allow users to seamlessly drill down through department,team,and General Ledger(GL)account details for specific fiscal years. When completed, staff will be able to simply click on the graphical summaries at each level to efficiently review operational budget and expense information in a more intuitive and user-friendly format. Additionally, the scope of work will also address an issue with the presentation of Human Resources information. CCUA monitors employee turnover using the number of budgeted employees as the denominator, whereas Workday's standard report calculates turnover based on the number of active employees.CSLLC and Cognizant will modify the report to align with CCUA's longstanding methodology. Finally, the scope of work includes refining and optimizing our processes to better meet the needs of the finance and operational teams. BUDGET: Staff budgeted $555,000 for subcontractors within the Administrative Operating Budget. Funds from this budget will be used for this scope of work with CSLLC and Cognizant. Staff determined the proposed professional services fee is fair, competitive, and reasonable. CSLLC will be paid on a time-and-materials basis,not to exceed$100,000. RECOMMENDATION: Staff respectfully recommend the Board of Supervisors' approval of Change Order No. 4 to the Statement of Work for Workday Report Development with Cognizant Worldwide Limited. //JDJ(Author) //AW,AE,DM,KO(Review) //JDJ(Final) ATTACHMENTS: Cognizant Worldwide Limited Project Change Order //JDJ(Author) //AW,AE,DM,KO(Review) //JDJ(Final) cognizant Project Change Order December 3, 2025 Project Change Order This Change Order form is used for requesting, documenting and approving changes to the Workday deployment or other applicable service offering, including, but not limited to, changes to the project's Scope, changes for a major configuration element, project timeline/schedule changes, integration specifications changes, addition of resources or any other deliverable change from the originally planned Workday deployment or applicable service offering. Summary Client: Clay County Utility Authority SOW/Project Name: Clay County Utility Authority- CVS 2025-27 Renewal /PROJ 78230 Change Order#: CO1 Project Manager (Client): Jeremy Johnston, Clay County Utility Authority Project Sponsor (Client): Jeremy Johnston, Clay County Utility Authority Engagement Manager Scott Meltzer- (CSLLC): Collaborative Solutions, LLC ("CSLLC") Acceptance Due Date: 15 December 2025 Change Type: Change in Scope (additional hours added) Impact Assessed by: Kalil Suber, Ankana Chakraborty Priority: High Billing Project: Change Order, Bill separately under a new project Contract Line Type: Time & Materials Is new PO# required? No (No Po number is required) Request Description Function Functionality Scope Count to Location Estimated Configure Scope Hours Reporting CSLLC will assist with the following: 21 new NA 404 hours Custom • Reporting Discovery Presentation in Reports beginning of Architect Phase • Begin populating and reviewing the reporting tracker for currently scoped reports and also add any comments if required This agreement is proprietary and confidential to Collaborative Solutions,LLC 1 cognizant Project Change Order December 3, 2025 • Prioritize the reports in tracker for Go Live (e.g. High/Medium/Low) and assign due date for that • Final Requirements Approval (if required) • Development Approval for Final Requirements • Final Development Approval as per the Requirements • Started Testing after E2E Migration (Development may continue) • Finalize Report Security • Report Sign-off Complete (End of E2E Testing) • Go-Live (Deploy) Business Purpose / Reason for Change Reporting efforts to address continued challenges related to processes and reporting using Workday at CCUA Impact Assessment Project Report development per the activities in the description Activities Affected: Deliverable Discovery, Development and Delivery of up to 21 reports s Affected: Project Project Timeline Schedule Architect& Post Total Impact: Planning Configure Test Deploy Production Weeks Weeks 1 6 2 1 2 12 Estimated Start Date 5-Jan-26 12-Jan-26 23-Feb-26 9-Mar-26 16-Mar-26 Estimated End Date 9-Jan-26 20-Feb-26 6-Mar-26 13-Mar-26 27-Mar-26 Pricing The following is the Pricing Matrix: Matrix Category/Role Hours Rate Total Cost Portfolio Director 9.50 S268 S2.546 Engagement Manager 70.00 S240 S16.800 Principal Consultant 404.00 S212 S85 648 Total 483 50 $104,994 Investment -S4.994 Grand Total $100,000 This agreement is proprietary and confidential to Collaborative Solutions,LLC 2 cognizant Project Change Order December 3, 2025 Payment Terms Time & Materials SOW: This Change Order will be billed monthly on a Time and Materials ("T&M") Basis based on actual usage at the rates set forth in the SOW and as identified in the Pricing Matrix above. Assumptions All Assumptions from the SOW dated 01 September 2025 apply to this Change Order Authorization Clay County Utility Authority, Florida Collaborative Solutions, LLC Authorization Signature Name Name Job Title Job Title Date Date This agreement is proprietary and confidential to Collaborative Solutions,LLC 3 SL No. Source File Name Legacy Report Name Content Complexity Report Type Workday Report Estimated Comment Build Hours 1 09.b EDB August 25 Financial Package CCUA Balance Sheet- Detail Low Low Composite 16 2 09.b EDB August 25 Financial Package CCUA Income Statement Low Low Composite 16 3 09.b EDB August 25 Financial Package CCUA Statements of Cash Flows Low Medium Composite 24 4 09.b EDB August 25 Financial Package CCUA Cash and Cash Equivalents Low Medium Composite 24 Report 5 09.b EDB August 25 Financial Package CCUA Operating Budget Report Low Low Composite 16 6 09.b EDB August 25 Financial Package CCUA Operating Expense Report Low Low Composite 16 7 09.b EDB August 25 Financial Package CCUA CIAC Report Low Low Composite 16 8 09.b EDB August 25 Financial Package CCUA Alternative Water Low Medium Composite 24 Surcharges 9 09.b EDB August 25 Financial Package CCUA Capital Projects Budget Medium Medium Composite 32 Report Purpose of 3 graphs 10 09.b EDB August 25 Financial Package CCUA Operating Revenue Budget Low Low Composite 16 after this report Report sample? 11 09.b EDB August 25 Financial Package CCUA Construction Department Low Low Composite 16 Report 12 la-Budget Detail CCUA Proposed Operating Medium Medium Composite 32 Budget Workday Reporting Requirements 13 Budget vs Expenses Low Low Composite 12 Examples 14 Workday Reporting Requirements Cumulative Budget vs Expenses Low Low Composite 16 Examples Workday Reporting Requirements Budgeted vs Actual Monthly 15 Low Low Composite 12 Examples Overtime 16 Workday Reporting Requirements Cumulative Budgeted vs Actual Low Low Composite 16 Examples Overtime Workday Reporting Requirements Employee Turnover by Fiscal 17 Low Low Matrix 8 Examples Year/Month 18 Workday Reporting Requirements Employee Turnover by Fiscal Year Low Low Composite 16 Examples Workday Reporting Requirements Fictional Project-Invoiced 19 Low Low Composite 16 Examples Amounts vs Earned Value 20 Workday Reporting Requirements Fictional Project-Cumulative Medium Low Composite 20 Examples Invoiced Amount vs Earned Value 21 Map Total Budget-Expense Summary Total Budget-Expense Summary High Medium Composite 40 Report