EXHIBIT E - WaterTAP COST WORKBOOK 10.02.26.xlsx

58 KB Posted

Attached to
Water Technical Access Portal (WaterTAP) 2. 0
Solicitation number
0000040529
Issued by
California

About this file

Written by GovTribe AI ·

This is an Exhibit E Cost Workbook for the WaterTAP system implementation project administered by the State of California State Water Resources Control Board. The workbook serves as the mandatory cost submission template for bidders responding to the solicitation. Bidders are required to complete cost worksheets three through seven, which detail project development phase information, base contract deliverables, licensing and hosting costs, maintenance and operations services, and staff hourly rates. The project implementation must be completed within a 24-month timeframe as specified in the Statement of Work. All project activities must conclude with a three-month Product Stabilization and Final System Acceptance period before the solution moves to production. The workbook accommodates phased deliverable submissions across four potential development phases, with deliverables organized into twelve groups including project management, design and implementation, system interfaces, data management, testing, organizational change management, configuration and release management, security, product stabilization, maintenance and operations, software, and system support transition.

Bidders must provide all costs as dollar amounts with no blank entries or N/A responses; costs must be indicated as $0 if no expense applies to a line item. The cost workbook automatically calculates total project costs across years one through three, applies a 15 percent state withhold against contractor payments, and separately accounts for hosting costs as mandatory optional items that will not be evaluated. Optional maintenance and operations costs for years four and five are also tracked but not evaluated in scoring. Bidders must complete a staff rate sheet identifying hourly rates for ten job classifications including Engagement Director, Project Manager, Senior Data Architect, Senior Software Solutions Architect, Senior Business Analyst, Training Lead, Senior Test and Validation Lead, Technical Lead, Organizational Change Management Lead, and GIS Solution Expert, with rates used to calculate costs for unanticipated tasks representing ten percent of the total project cost.

View the file

Other files

File Type Posted
ATTACHMENT 12- COMMERCIALLY USEFUL FUNCTION (CUF) CERTIFICATION.pdf PDF
ATTACHMENT 8- WORKERS_ COMPENSATION CERTIFICATION.pdf PDF
0._SWRCB_WaterTAP_Project_List_of_Documents_10.02.26.pdf PDF
EXHIBIT K- DELIVERABLE ACCEPTANCE DOCUMENT.pdf PDF
ATTACHMENT 9- BIDDING PREFERENCES AND INCENTIVES.pdf PDF
ATTACHMENT 16.7- SENIOR TEST AND VALIDATION LEAD QUALIFICATIONS FORM.pdf PDF
ATTACHMENT 16.10- GIS SOLUTION EXPERT QUALIFICATIONS FORM.pdf PDF
EXHIBIT L- KEY STAFF REPLACEMENT FORM.pdf PDF
ATTACHMENT 16.4- SENIOR SOFTWARE SOLUTIONS ARCHITECT QUALIFICATIONS FORM.pdf PDF
ATTACHMENT 13- BIDDER QUALIFICATIONS FORM - INSTRUCTIONS.pdf PDF
EXHIBIT C- FUNCTIONAL AND NON-FUNCTIONAL REQUIREMENTS.pdf PDF
ATTACHMENT 1- TEMPLATE FOR QUESTION SUBMITTAL_REQUEST FOR CHANGES.pdf PDF
EXHIBIT F- SWRCB IT SECURITY POLICIES.pdf PDF
EXHIBIT G- SWRCB SPECIAL TERMS AND CONDITIONS.pdf PDF
ATTACHMENT 16.6- TRAINING LEAD QUALIFICATIONS FORM.pdf PDF
ATTACHMENT 16- KEY STAFF QUALIFICATIONS FORM - INSTRUCTIONS.pdf PDF
EXHIBIT H- DATA CONNECTIONS.pdf PDF
ATTACHMENT 10- DVBE DECLARATIONS.pdf PDF
ATTACHMENT 17- KEY STAFF REFERENCE FORM.pdf PDF
ATTACHMENT 16.8- TECHNICAL LEAD QUALIFICATIONS FORM.pdf PDF
2._EXHIBIT_A-_STATEMENT_OF_WORK__SOW__10.02.26.pdf PDF
EXHIBIT M- CONFIDENTIALITY STATEMENT FORM (POST AWARD).pdf PDF
EXHIBIT C -WaterTAP FUNCTIONAL AND NON-FUNCTIONAL REQUIRMENTS 10.02.26.xlsx XLSX spreadsheet
ATTACHMENT 2- INTENT TO BID FORM.pdf PDF
ATTACHMENT 16.2- PROJECT MANAGER QUALIFICATIONS FORM.pdf PDF
EXHIBIT B- BUDGET DETAIL AND PAYMENT PROVISIONS.pdf PDF
EXHIBIT E- COST WORKBOOK.pdf PDF
ATTACHMENT 6- RESPONSE TO ADMINISTRATIVE REQUIREMENTS FORM.pdf PDF
EXHIBIT D- DELIVERABLES AND MILESTONES TABLE.pdf PDF
EXHIBIT J- DELIVERABLE EXPECTATION DOCUMENT.pdf PDF
ATTACHMENT 14- BIDDER QUALIFICATIONS FORM.pdf PDF
1._SWRCB_WaterTAP_REQUEST_FOR_PROPOSAL__RFP__10.02.26.pdf PDF
ATTACHMENT 18- PHASE 2- NARRATIVE RESPONSE REQUIREMENTS.pdf PDF
ATTACHMENT 16.1- ENGAGEMENT DIRECTOR QUALIFICATIONS FORM.pdf PDF
ATTACHMENT 16.3- SENIOR DATA ARCHITECT QUALIFICATIONS FORM.pdf PDF
EXHIBIT I- WORK ORDER AUTHORIZATION FORM.pdf PDF
ATTACHMENT 3- FOLLOW-ON DISCLOSURE FORM.pdf PDF
ATTACHMENT 11- TACPA PREFERENCE REQUEST FORMS.pdf PDF
ATTACHMENT 4- CONFIDENTIALITY STATEMENT FORM.pdf PDF
ATTACHMENT 5- COVER LETTER FORM.pdf PDF
ATTACHMENT 15- BIDDER REFERENCE FORM.pdf PDF
ATTACHMENT 16.5- SENIOR BUSINESS ANALYST QUALIFICATIONS FORM.pdf PDF
EXHIBIT N- GLOSSARY OF TERMS.pdf PDF
ATTACHMENT 16.9- ORGANIZATIONAL CHANGE MANAGEMENT LEAD QUALIFICATIONS FORM.pdf PDF
ATTACHMENT 7- BIDDER DECLARATION GSPD 05-105.pdf PDF
Show all 45

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1. Instructions

Exhibit E - Cost Workbook
Cost Workbook Instructions (no input required on this sheet)
The cost worksheets list all costs required to design, configure, develop, implement, operate, and maintain the solution as defined in the Statement of Work (SOW).
Bidders are required to complete cost worksheets 3 through 7 of this Cost Workbook.
For any items indicated on the worksheets that have no cost, Bidder must indicate the cost as $0, not blank or N/A.
Bidder is only permitted to input data to non-shaded cells.
Description of Cost Worksheets
1. InstructionsNo bidder input required on this worksheet. Instructions provided for bidder to complete the cost workbook.
2. Cost SummaryNo bidder input required on this worksheet. Sheet calculates from data input on sheets 3 through 7.
3. Project Phase CalculatorBidder enters project development phase information including bidder name, phase titles, phase start dates, and phase end dates. The tool auto-calculates the phase durations to ensure project completion within the 24-month timeframe identified in Exhibit A: Statement of Work. Phases should align with those identified throughout the proposal. Bidder is not required to use all phases listed in the calculator.
4. Base Contract DeliverablesBidder enters costs associated with all project deliverables. The cost of each deliverable can be split between phases to represent the development phase(s) during which the deliverable will be submitted.
5. Licensing Tools & Hosting CostsBidder enters all licensing costs including all SaaS licensing and related software and tools pertaining to development, implementation, data migration, ongoing access, support and hosting (if applicable) of the solution. Indicate in the "Product Information | Description" Column whether the cost is one-time or ongoing. Bidder also enters license costs for two optional one-year Maintenance and Operations (M&O) periods, which will not be scored. Costs for optional years may be different and will not be scored. NOTE: Hosting costs are "Mandatory Optional" and must reported in section B of this tab but will not be evaluated.
6. Maintenance & OperationsBidder enters recurring Maintenance and Operations (M&O) services costs as defined in SOW Section 14.
7. Staff Rate Sheet (UT)Bidder enters hourly rate information for Key Staff. Rates will be used in the calculation of Unanticipated Task (UT) costs.
Refer to RFP Section 4.3.1 Cost Workbook Instructions for further detail.

State of California State Water Resources Control Board

&A Page &P of &N

2. Cost Summary

2. Cost Summary

Bidder Name:Company_ABC
Data entry not permitted below this line. Sheet calculates automatically.Item Total
PROJECT COSTS - YEARS 1-3
1Base Contract Deliverables (Tab 4)$ -
2Licensing, Tools Cost$ -
2.1Licensing, Tools Cost - Years 1-2 - BASE CONTRACT (Tab 5)$ -
2.2Licensing, Tools Cost - Year 3 M&O - BASE CONTRACT (Tab 5)$ -
3Maintenance and Operations Activities$ -
3.1Maintenance and Operations - Year 3 M&O - BASE CONTRACT (Tab 6)$ -
Total Project Cost:$ -
Unanticipated Tasks (10%of Project Cost):$ -
PROJECT COST + UNANTICIPATED TASKS:$ -
PROJECT HOSTING COSTS - YEARS 1-3 - MANDATORY OPTIONAL (NOT EVALUATED)
4Hosting Cost$ -
4.1Hosting Cost - Years 1-2 - BASE CONTRACT (Tab 5)$ -
4.2Hosting Cost - Year 3 M&O - BASE CONTRACT (Tab 5)$ -

TOTAL OPTIONAL HOSTING COST: $ -

OPTIONAL MAINTENANCE AND OPERATIONS COSTS - YEAR 4 (NOT EVALUATED)
5Licensing, Tools Cost - Year 4 M&O - OPTIONAL YEAR (Tab 5)$ -
6Hosting Cost - Year 4 M&O - OPTIONAL YEAR (Tab 5)$ -
7Maintenance and Operations - Year 4 M&O - OPTIONAL YEAR (Tab 6)$ -

TOTAL OPTIONAL YEAR 4 COST: $ -

OPTIONAL MAINTENANCE AND OPERATIONS COSTS - YEAR 5 (NOT EVALUATED)
8Licensing, Tools Cost - Year 5 M&O - OPTIONAL YEAR (Tab 5)$ -
9Hosting Cost - Year 5 M&O - OPTIONAL YEAR (Tab 5)$ -
10Maintenance and Operations - Year 5 M&O - OPTIONAL YEAR (Tab 6)$ -

TOTAL OPTIONAL YEAR 5 COST: $ -

BIDDER'S PROPOSED TOTAL COST (INCLUDING HOSTING)$ -
BIDDER'S PROPOSED TOTAL COST (EXCLUDING HOSTING)$ -

3. Project Phase Calculator

Bidder NameProject Phase Calculator
Company_ABCAny iterative development phase(s) completed by the vendor shall include Design, Development, Testing and approval from the State; however, functionality will not move to production until final acceptance of the complete solution has been achieved following the three (3) month Product Stabilization and Final System Acceptance period. See SOW Section 10.4.7 for additional information.
Proposed Project PhasesEstimated Dates used to calculate Durations
PhaseTitlePhase Start Date

First Day of Planned Month (e.g. 1/1/2024) Phase End Date Last Day of Planned Month (e.g. 1/31/2024) Phase Duration (D to E, Months)

Phase 10
Phase 20
Phase 30
Phase 40
Compliance Check
WaterTAP Implementation Equals 24 months0months

State of California State Water Resources Control Board

&A Page &P of &N

1. Bidder only permitted to enter data to unshaded cells.

2. The phase title (Column C) should align with the approach presented throughout the proposal.

3. Phase Start Date (Column D) is the date the vendor anticipates beginning work for that phase and must be the first day of the month. THIS DATE IS NOT A CONTRACTUALLY BINDING DATE. It is only used to calculate Phase Duration.

4. Phase End Date (Column E) is the date when all activities for that phase are complete. This must be the last day of the calendar month. THIS DATE IS NOT A CONTRACTUALLY BINDING DATE. It is used to calculate Phase Duration.

5. The Phase Duration (Column F) is calculated based on the number of months between the Phase Start Date and Phase End Date.

6. All project activities for the WaterTAP system implementation must be completed within two years (2 years = 24 months), as specified in the SOW.

7. Leave any unused phases blank.

4. Base Contract Deliverables

3. Base Contract Deliverables
Bidder Name:Company_ABC
M&O and end-user availability will begin after production implementation of the complete solution; however, the State will consider a phased approach towards system development and deliverable submission. Provide phased deliverable costs in columns E-H, below. While four (4) columns are available, only use columns as needed to represent the development phase(s) during which the deliverable will be submitted. Base Contract Costs do not include optional years or M&O services (report on Tab 5 - Maintenance & Operations).
Item #Deliverable CostTask GroupPayment Type & FrequencyPhase 1Phase 2Phase 3Phase 4Total Contract CostState WithholdTotal Contractor Payment
Deliverable CostDeliverable CostDeliverable CostDeliverable Cost15%
1Project ManagementDeliverable Group #1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
1.1Project Management PlanDeliverable$ - 0$ - 0$ - 0
1.2Project ScheduleDeliverable$ - 0$ - 0$ - 0
1.3Weekly / Monthly Status ReportMonthly Service Fee$ - 0$ - 0$ - 0
1.4Sprint/Release ReportDeliverable$ - 0$ - 0$ - 0
2Design, Development, and ImplementationDeliverable Group #2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2.1Solution ArchitectureDeliverable$ - 0$ - 0$ - 0
2.2Fit Gap AnalysisDeliverable$ - 0$ - 0$ - 0
2.3Functional and Technical Design DocumentDeliverable$ - 0$ - 0$ - 0
2.4Implementation PlanDeliverable$ - 0$ - 0$ - 0
2.5Solution ImplementationMilestone$ - 0$ - 0$ - 0
3System InterfacesDeliverable Group #3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3.1Interface Management PlanDeliverable$ - 0$ - 0$ - 0
3.2Interface DevelopmentMilestone$ - 0$ - 0$ - 0
4Data Management and ConversionDeliverable Group #4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4.1Final Data Management and Conversion PlanDeliverable$ - 0$ - 0$ - 0
4.2Data Conversion ActivitiesMilestone$ - 0$ - 0$ - 0
5TestingDeliverable Group #5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5.1End-to-End Testing ResultsDeliverable$ - 0$ - 0$ - 0
5.2Master Test PlanDeliverable$ - 0$ - 0$ - 0
5.3UAT Testing Results ReportDeliverable$ - 0$ - 0$ - 0
5.4Testing (UAT, Performance, Load, Security)Milestone$ - 0$ - 0$ - 0
6Organizational Change Management and TrainingDeliverable Group #6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6.1End User Training PlanDeliverable$ - 0$ - 0$ - 0
6.2Organizational Change Management Deployment PlanDeliverable$ - 0$ - 0$ - 0
6.3Organizational Change Management ScheduleDeliverable$ - 0$ - 0$ - 0
6.4Organizational Change Management Quarterly Status ReportDeliverable$ - 0$ - 0$ - 0
6.5Organizational Change Management Performance Measurement PlanDeliverable$ - 0$ - 0$ - 0
6.6TrainingMilestone$ - 0$ - 0$ - 0
6.7Training Completion ReportDeliverable$ - 0$ - 0$ - 0
7Configuration and Release ManagementDeliverable Group #7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7.1Configuration Management PlanDeliverable$ - 0$ - 0$ - 0
7.2Pilot Deployment Report and SignoffDeliverable$ - 0$ - 0$ - 0
7.3Release Management PlanDeliverable$ - 0$ - 0$ - 0
7.4Formal System Acceptance and Final Go-Live reportDeliverable$ - 0$ - 0$ - 0
7.5Configuration ImplementationMilestone$ - 0$ - 0$ - 0
8Security and Data ProtectionDeliverable Group #8$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8.1System Security PlanDeliverable$ - 0$ - 0$ - 0
9Product StabilizationDeliverable Group #9$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9.1Final System Development and Deployment ReportDeliverable$ - 0$ - 0$ - 0
9.2Final System AcceptanceMilestone$ - 0$ - 0$ - 0
10Maintenance and OperationsDeliverable Group #10$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10.1Maintenance and Operations PlanDeliverable$ - 0$ - 0$ - 0
10.2Technology Recovery Plan (TRP)Deliverable$ - 0$ - 0$ - 0
10.3System Performance and Capacity Management PlanDeliverable$ - 0$ - 0$ - 0
11SoftwareDeliverable Group #11$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11.1List of SoftwareDeliverable$ - 0$ - 0$ - 0
12System Support TransitionDeliverable Group #12$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12.1System Support Transition Plan (SSTP)Deliverable$ - 0$ - 0$ - 0
12.2Software Maintenance ManualDeliverable$ - 0$ - 0$ - 0
12.3System Administration GuideDeliverable$ - 0$ - 0$ - 0
12.4System TransitionMilestone$ - 0$ - 0$ - 0
TOTAL CONTRACT DELIVERABLES COST:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

5.Licensing Tools Hosting Costs

5. LICENSING, TOOLS, HOSTING COSTS
Bidder Name:Company_ABC
A. SOFTWARE TOOLS COSTS (including Third Party or Other)Base Contract (Years 1 - 3)Optional Years (NOT EVALUATED)
Item #Product NameProduct Information | DescriptionSKUSLP#PurposeQty.Unit CostSoftware Tools Cost (Monthly)Extended Cost
Years 1-2 ProjectSoftware Tools Cost Year 3 M&OSoftware Tools Cost Year 4 M&O (OPTIONAL YEAR)Software Tools Cost Year 5 M&O (OPTIONAL YEAR)
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
TOTAL:$ - 0$ - 0$ - 0$ - 0
B. HOSTING INCLUDING CLOUD, DATA, INFRASTRUCTURE, SERVICES COSTS (Mandatory Optional - NOT EVALUATED)Base Contract (Years 1 - 3)Optional Years (NOT EVALUATED)
Product NameProduct Information | Description
(Number, Version, Open Source or Proprietary)SKUSLP#PurposeQty.Unit CostHosting Cost (Monthly)Extended Cost
Years 1-2 ProjectHosting Cost Year 3 M&OHosting Cost Year 4 M&O (OPTIONAL YEAR)Hosting Cost Year 5 M&O (OPTIONAL YEAR)
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
TOTAL:$ - 0$ - 0$ - 0$ - 0
TOTAL Licensing, Tools, & Hosting Cost
(Base Contract & Optional Years):$ - 0$ - 0$ - 0$ - 0

The Contractor shall provide costs for all software licenses required and assist the State in securing such licenses from software contractors and/or resellers, and any third-party tools necessary to meet the functional and non-functional requirement to support the WaterTAP system.

6. Maintenance & Operations

6. Maintenance & Operations
Bidder Name:Company_ABC
Item #Cost CategoryPayment TypeUnit of MeasureEst. Unit Total
(Hypothetical - For Evaluation Purposes)Bidder Proposed Monthly Service Fee Per UnitMonthly Service Cost TotalAnnual Service Cost TotalBIDDER COMMENTS

(Enter comment if proposed cost in column H equals $0.)

Year 3 Maintenance & Operations - BASE CONTRACT
1Maintenance ActivitiesMonthly Service FeeService1$ - 0$ - 0$ - 0
Year 4 Maintenance & Operations - OPTIONAL YEAR
1Maintenance ActivitiesMonthly Service FeeService1$ - 0$ - 0$ - 0
Year 5 Maintenance & Operations - OPTIONAL YEAR
1Maintenance ActivitiesMonthly Service FeeService1$ - 0$ - 0$ - 0
TOTAL$ - 0
NOTES:

7. Staff Rate Sheet (UT)

9. Staff Rate Sheet (Informational Only) *Hourly rate information will be used in the calculation of Unanticipated Task (UT) costs

Bidder Name:Company_ABC
Item #Job Classication TitleHourly Rate
1Engagement Director
2Project Manager
3Sr. Data Architect
4Sr. Software Solutions Architect
5Sr. Business Analyst
6Training Lead
7Sr. Test and Validation Lead
8Technical Lead
9Organizational Change Management Lead
10GIS Solution Expert

1920 Full-time staff calculation for the year

File details come from the government source that posted it. Updated .