6_Exhibit E - Cost Workbook_Pre-Solicitation_1.xlsx
XLSX spreadsheet 100 KB Posted
- Solicitation number
- 0000040884
- Issued by
- California
About this file
Cost Workbook for CalWRAPP Pre-Solicitation No. 0000040884
This document is a cost workbook template for the California State Water Resources Control Board's CalWRAPP (California Wetland and Riparian Area Protection Portal) pre-solicitation No. 0000040884. The workbook is designed for bidders to enter detailed cost proposals for the design, configuration, integration, and implementation of a modern dredge and fill application intake, review, and tracking system. Bidders must complete multiple worksheets including base contract payment costs, licensing and tools costs, maintenance and operations costs, and staff rate information across a project duration spanning up to 60 months. The cost workbook requires bidders to propose costs for deliverables organized across 12 primary deliverable groups, including project management, requirements clarification, design and development, system interfaces, data management, testing, training, configuration and release management, security and data protection, software and SaaS subscriptions, transition to maintenance and operations, and project closeout. Additionally, bidders may propose optional maintenance and operations support for Years 2 and 3. The estimated user base includes 1,300 annual permit applications, 175 concurrent external users, 200 total internal staff users, 100 concurrent Water Board staff users, and 20 concurrent non-program staff users; however, a Best and Final Offer (BAFO) adjustment notes that approximately 150 users will not require licensing in the first year during beta testing and stakeholder demonstrations.
The cost proposal structure includes separate sections for SaaS subscription licensing, software tools licensing (including third-party and open-source options), and hosting costs across the base contract year and optional renewal years. Bidders must provide detailed staff rate sheets identifying key positions such as engagement directors, delivery managers, senior project managers, technical architects, and developers, along with associated hourly rates and full-time equivalent (FTE) allocations. The workbook includes a projected staff hours section spanning 60 months to capture resource planning, and a user licenses section requiring bidders to specify whether licenses are named or concurrent, provide tiered pricing based on user ranges, and clearly indicate initial annual costs versus renewal costs. The BAFO section specifies that contractors must include 262 business intelligence (BI) licenses as part of their cost proposal. All cost data entered must reflect white cells only, with static content and formulas protected from modification. The Cost Summary worksheet automatically aggregates data from detailed worksheets, applies a 10 percent state withhold, and calculates the bidder's proposed total cost.
View the file
Other files
Show all 11
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1. Instructions
| CalWRAPP Pre-Solicitation No. 0000040884 Cost Workbook | |
| 1. Instructions | |
| Item | General Cost Workbook Instructions: |
| 1 | Bidder shall enter data into white cells only and shall not alter any static content or formulas. |
| 2 | Bidder shall enter their company name on the Cost Summary (worksheet #2) and Bidder proposed cost data in worksheets #3 through #6. |
| 3 | Bid amount shall reflect all Project Cost elements specified in the applicable SOW Sections. |
| 4 | Bidder shall refer to, and comply with, the instructions provided in item 6-13 below. |
| 5 | Bidder shall use the following information for guidance while filling out the worksheets and cost estimates. |
| 6 | Water Boards estimates a total of 1,300 permit applications submitted through the system annually |
| 7 | Water Boards estimates a total of concurrent 175 Users. |
| 8 | Water Boards estimates a total of 200 internal staff that will access the system for program related job duties. |
| 9 | Water Boards estimates a total of 100 concurrent Water Boards staff users. |
| 10 | Water Boards estimates a total of 20 concurrent Non-Program staff users, e.g. IT system support staff, database administration staff. |
| 11 | Bidder shall provide options for user licensing and associated costs based on estimates provided on items 6 through 10. If applicable, the options provided shall include different tiers based on user volumes. Please note that the estimates and user roles may change during discovery activities for the design phase of the project. However, those estimates will be used for evaluation purposes. |
| 12 | Bidder shall include the frequency (e.g., monthly, annual, etc.) for billing of any software licensing costs (e.g., Software, third-party, etc.). |
| Changes - BAFO |
| * CDFA - AHFSS is planning for deployments the first year for beta testing with stakeholders, demo's and outreach. We will not be needing licensing for approximately 150 users in the first year. Use the instructions below to adjust the cost and break it down by the category in the functional requirements |
| * CDFA - AHFSS estimates a total number of active external users (that will need to be able to login and report as well as save an application into the system), XXX concurrent active external users, XXX total active staff users, and XXX concurrent staff users at the end of the first year. |
| * CDFA - AHFSS estimates a total number of ~XXXX total active external users (that will need to be able to login and report as well as save an application into the system), XXXX concurrent active external users, XXX total active staff users, and 100 concurrent staff users at the end of the second year, beginning of third year. |
2. Cost Summary
| 2. Cost Summary | ||
| Item # | ||
| Bidder Name: | ||
| Base Contract and M&O Costs | ||
| 1 | Base Contract Payment (Tab 3) | $ - 0 |
| 2 | Licensing, Tools and SAAS Cost (Tab 4) - Base Contract Year 1 (Tab 4) | $ - 0 |
| 3 | Licensing, Tools, and SAAS Cost - Optional Year 2 for M&O (Tab 4) | $ - 0 |
| 4 | Licensing, Tools, and SAAS Cost - Optional Year 3 for M&O (Tab 4) | $ - 0 |
| 5 | Maintenance and Operations Planning Costs - Year 2 (Tab 5) | $ - 0 |
| 6 | Maintenance and Operations - Optional Year 2 (Tab 5) | $ - 0 |
| 7 | Maintenance and Operations - Optional Year 3 (Tab 5) | $ - 0 |
| Total Base Contract Cost Items | $ - 0 | |
| Total Base M&O Cost Items | $ - 0 | |
| Unanticipated Tasks (10%) of the Total Base Contract | $ - 0 | |
| Bidder's Proposed Total Cost | $ - 0 |
Note: Enter Bidder Name in Cell C3. All other fields in this worksheet will auto-populate from data input in Tabs 3 through 6.
State of California State Water Resources Control Board CalWRAPP Pre-Solicitation No. 0000040884 Cost Workbook
3. Base Contract Payment
| ` | 3. Base Contract Payment | ||||||
| Bidder Name: | |||||||
| Item # | Deliverable | Delivery Group | Deliverable Category | Quantity | Unit Cost | Total Cost | State 10% Withhold |
| 1.1 | Project Management Plans | Deliverable Group #1 | |||||
| 1.1.1 | Project Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.2 | Communication Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.3 | Implementation Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.4 | Project Organization Chart | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.5 | Schedule Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.6 | Project Schedule | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.7 | Project Schedule (Weekly Updates) | Documentation | 42 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.8 | Requirements Traceability Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.9 | Requirements Traceability Matrix | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.10 | Risk Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.11 | Risk Register (Weekly Updates) | Documentation | 42 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.12 | Issue Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.13 | Issue Log (Weekly Updates) | Documentation | 42 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.14 | Change Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.15 | Change Log (Monthly Updates) | Documentation | 10 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.16 | Weekly Status Meetings | Service | 42 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.17 | Weekly Status Reports | Documentation | 42 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.18 | Monthly Status Meetings | Service | 10 | $ - 0 | $ - 0 | $ - 0 | |
| 1.1.19 | Monthly Status Reports | Documentation | 10 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2 | Agile Management | Deliverable Group #1 | |||||
| 1.2.1 | Project Roadmap | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.2 | Product Backlog | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.3 | Sprint Planning Sessions | Service | 21 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.4 | Sprint Backlog | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.5 | Daily Stand-Ups | Service | 210 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.6 | Burndown Charts | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.7 | Testing and Validation Results | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 1.2.8 | Sprint Retrospectives | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| Subtotals | $ - 0 | $ - 0 | |||||
| 2.0 | Requirements Clarification/Finalization | Deliverable Group #2 | |||||
| 2.1 | Business Process and Requirements Analysis | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 2.2 | Fit Gap Analysis | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 2.3 | Requirements Clarifications (Functional, Non-Functional, Transitional) | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 2.4 | Requirements Finalization (Functional, Non-Functional, Transitional) | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 2.5 | Requirements Traceability Matrix | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| Subtotals | $ - 0 | $ - 0 | |||||
| 3.0 | Design, Development, and Implementation | Deliverable Group #3 | |||||
| 3.1 | Business Requirements Document | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 3.2 | System Architecture Documentation | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 3.3 | Data Architecture Documentation | Documentation | 1 | ||||
| 3.4 | Functional and Technical Design Documentation | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 3.5 | Solution Implementation Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | |
| 3.6 | System Environments |
1. Development
2. System Integration Testing
3. User Acceptance Testing
4. Training
| 5. Production | Deliverable Milestone | 5 | $ - 0 | $ - 0 | $ - 0 | |||
| 3.7 | Development Data Sets | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 3.8 | Solution Implementation Completion Report | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 4.0 | System Interfaces | Deliverable Group #4 | ||||||
| 4.1 | Interface Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 4.2 | Interface Development Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 4.3 | Interface Design Document | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 4.4 | Interface Control Documents | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 4.5 | Interface Implementations | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 5.0 | Data Management | Deliverable Group #5 | ||||||
| 5.1 | Data Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 5.2 | Data Inventory and Classification Register | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 5.3 | Data Model/Database Schema | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 5.4 | Data Dictionary | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 6.0 | Testing | Deliverable Group #6 | ||||||
| 6.1 | Master Test Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.2 | Use Cases and Test Cases Documentation | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.3 | Test Scripts | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4 | Testing Execution | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4.1 | System | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4.2 | Integration | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4.3 | UAT | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4.4 | Performance, Load | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4.5 | Security, Penetration | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.4.6 | Interfaces | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.5 | Test Data Sets | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 6.6 | Testing Results Reports (System, Integration, UAT, Performance, Load, Security, Penetration, Interfaces) | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 7.0 | Training | Deliverable Group #7 | ||||||
| 7.1 | Training Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 7.2 | Training Materials | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 7.3 | Training Execution | Deliverable Milestone | 1 | $ - 0 | $ - 0 | |||
| 7.4 | Training Completion Report | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 8.0 | Configuration and Release Management | Deliverable Group #8 | ||||||
| 8.1 | Release Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 8.2 | Configuration Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 8.3 | Cut-Over Plan | Documentation | ||||||
| 8.4 | Configuration Implementation (Development, QA, Staging, Production, Training) | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 8.5 | Pilot Deployment Report and Signoff | Documentation | 1 | |||||
| 8.6 | System Stabilization Report | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 8.7 | Formal System Acceptance and Final Go-Live Report | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 9.0 | Security and Data Protection | Deliverable Group #9 | ||||||
| 9.1 | System Security Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 9.1 | Security Test Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 10.0 | Software/SaaS/Hosting Subscriptions | Deliverable Group #10 | ||||||
| 10.1 | List of Software Licensing | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 10.2 | List of SaaS Licensing | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 10.3 | List of Hosting Licensing | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 11.0 | System Transition to Maintenance and Operations (M&O) | Deliverable Group #11 | ||||||
| 11.1 | M&O Management Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 11.2 | Transition to M&O Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 11.3 | System Maintenance Manual | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 11.4 | System Administration Guide | Documentation | 1 | |||||
| 11.5 | System Performance and Capacity Management Plan | Documentation | 1 | |||||
| 11.6 | Technology Recovery Plan | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 11.7 | Help Desk Management Plan | Documentation | 1 | |||||
| 11.8 | Help Desk Support Manual | Documentation | 1 | |||||
| 11.9 | Help Desk Implementation | Service | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 11.10 | Help Desk Statistics Reporting Framework | Documentation | 1 | |||||
| 11.11 | System Transition to M&O | Deliverable Milestone | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 12.0 | Project Closeout | Deliverable Group #12 | ||||||
| 12.1 | Updated Documentation | Documentation | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 12.2 | Participation in Lessons Learned/Retrospective Sessions | Service | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| OPTIONAL | ||||||||
| 13.0 | M&O Support - Optional Year 1 | Deliverable Group #13 | ||||||
| 13.1 | M&O Support | Service | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 13.2 | Monthly M&O Report | Documentation | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| 13.3 | Help Desk Support | Service | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 13.4 | Monthly Help Desk Statistics Report | Documentation | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 | ||||||
| 14.0 | M&O Support - Optional Year 2 | Deliverable Group #14 | ||||||
| 13.1 | M&O Support | Service | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 13.2 | Monthly M&O Report | Documentation | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| 13.3 | Help Desk Support | Service | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| 13.4 | Monthly Help Desk Statistics Report | Documentation | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Subtotals | $ - 0 | $ - 0 |
State of California State Water Resources Control Board CalWRAPP Pre-Solicitation No. 0000040884
4.Licensing Tools Hosting Costs
| 4. LICENSING, TOOLS, HOSTING COSTS | |||||||||
| Bidder Name: | |||||||||
| A. SaaS SUBSCRIPTION LICENSING | |||||||||
| Item # | Product Name | Product Information | Description | SLP Contract Number (if applicable) | License SKU | Purpose | Licensing Start Date | Qty. | 1 Year Base Contract Licensing | |
| Unit Cost | Unit Maintenance Cost (Monthly) | 1 - Year Base Contract Extended Cost | M&O Optional Year 1 | ||||||
| Licensing Unit Cost | M&O Optional Year 1 | ||||||||
| Licensing Extended Cost | M&O Optional Year 2 | ||||||||
| Licensing Unit Cost | M&O Optional Year 2 |
Licensing Extended Cost
| 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 8 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 9 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Subtotals | $ - 0 | $ - 0 | $ - 0 |
| B. SOFTWARE TOOLS COSTS (Including Third Party or Other) | |||||||||
| Item # | Product Name | Product Information | Description | |||||||
| (Open Source or Proprietary) | SLP Contract Number (if applicable) | License SKU | Purpose | Licensing Start Date | Qty. | 1 Year Base Contract Licensing Unit Cost | Unit Maintenance Cost (Monthly) | 1 Year Base Contract Extended Cost | M&O Optional Year 1 |
| Licensing Unit Cost | M&O Optional Year 1 | ||||||||
| Licensing Extended Cost | M&O Optional Year 2 | ||||||||
| Licensing Unit Cost | M&O Optional Year 2 |
Licensing Extended Cost
| 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 8 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 9 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Subtotals | $ - 0 | $ - 0 | $ - 0 |
Total Licensing Costs (Base Contract & Optional Years) $ - 0 $ - 0 $ - 0
Notes: Software Licensing is mandatory optional
State of California State Water Resources Control Board CalWRAPP Pre-Solicitation No. 0000040884
5. Maintenance & Operations
| 5. Maintenance & Operations | ||||||
| Bidder Name: | ||||||
| Item # | Cost Category | Deliverable Type | Quantity | Deliverable | ||
| Unit Cost | Deliverable | |||||
| Cost Total | Bidder Comments | |||||
| 1. Maintenance and Operations Planning - Implementation Project Year 1 | ||||||
| 1 | Transition to Maintenance and Operations Plan Updates | Documentation | 1 | $ - 0 | $ - 0 | |
| 2 | Maintenance and Operations Plan Updates | Documentation | 1 | $ - 0 | $ - 0 | |
| 3 | Maintenance and Operations Reporting Plan | Documentation | 1 | $ - 0 | $ - 0 | |
| 4 | Technology Recovery Plan (TRP) | Documentation | 1 | $ - 0 | $ - 0 | |
| 5 | System Performance and Capacity Management Plan | Documentation | 1 | $ - 0 | $ - 0 | |
| Subtotal | $ - 0 | |||||
| Cost Category | Deliverable Type | Quantity | Monthly Service Cost | Annual | ||
| Service Cost | Bidder Comments | |||||
| 2. Maintenance & Operations - Optional Year 1 | ||||||
| 1 | Maintenance and Operations Activities | Monthly Service Fee | 12 | $ - 0 | $ - 0 | |
| 2 | Monthly Maintenance and Operations Report | Documentation | 12 | $ - 0 | $ - 0 | |
| 3 | Help Desk Support | Monthly Service Fee | 12 | $ - 0 | $ - 0 | |
| Subtotal | $ - 0 | |||||
| 3. Maintenance & Operations - Optional Year 2 | ||||||
| 1 | Maintenance and Operations Activities | Monthly Service Fee | 12 | $ - 0 | $ - 0 | |
| 2 | Monthly Maintenance and Operations Report | Documentation | 12 | $ - 0 | $ - 0 | |
| 3 | Help Desk Support | Monthly Service Fee | 12 | $ - 0 | $ - 0 | |
| Subtotal | $ - 0 | |||||
| TOTAL | $ - 0 | |||||
| Notes: |
State of California State Water Resources Control Board CalWRAPP Pre-Solicitation No. 0000040884
6. Staff Rate Sheet
| 6A. Staff Rate Sheet - Project (Informational Only) | ||||||
| Bidder Name: | ||||||
| Item # | Job Classification Title | Hourly Rate | Number of Resources (FTE) | Duration | ||
| (Months) | Total Staff Costs | |||||
| Key Staff | ||||||
| 1 | Engagement Director | $ - 0 | 1.0 | 36 | $ - 0 | |
| 2 | Delivery Manager | $ - 0 | 1.0 | 36 | $ - 0 | |
| 3 | Senior Project Manager | $ - 0 | 1.0 | 36 | $ - 0 | |
| 4 | Technical Architect | $ - 0 | 1.0 | 36 | $ - 0 | |
| 5 | Technical Lead | $ - 0 | 1.0 | 36 | $ - 0 | |
| 6 | Senior Developer | $ - 0 | 1.0 | $ - 0 | ||
| 7 | Data Architect | $ - 0 | 1.0 | $ - 0 | ||
| 8 | Database Analyst | $ - 0 | 1.0 | $ - 0 | ||
| 9 | GIS Architect | $ - 0 | 1.0 | $ - 0 | ||
| 10 | GIS Developer | $ - 0 | 1.0 | |||
| 11 | GIS System Administrator | $ - 0 | 1.0 | |||
| 12 | Testing Manager | $ - 0 | 1.0 | |||
| 13 | Testing Engineer | $ - 0 | 1.0 | |||
| 14 | Business Solutions Analyst | $ - 0 | 1.0 | |||
| 15 | System Adminstrator | $ - 0 | 1.0 | $ - 0 | ||
| All Other Non-Key Staff | ||||||
| 1 | $ - 0 | 0.0 | $ - 0 | |||
| 2 | $ - 0 | 0.0 | $ - 0 | |||
| 3 | $ - 0 | 0.0 | $ - 0 | |||
| 4 | $ - 0 | 0.0 | $ - 0 | |||
| 5 | $ - 0 | 0.0 | $ - 0 | |||
| 6 | $ - 0 | 0.0 | $ - 0 | |||
| 7 | $ - 0 | 0.0 | $ - 0 | |||
| 8 | $ - 0 | 0.0 | $ - 0 | |||
| 9 | $ - 0 | 0.0 | $ - 0 | |||
| 10 | $ - 0 | 0.0 | $ - 0 | |||
| Total Key Staff Resources | 15 | $ - 0 | ||||
| Total Non-Key Staff Resources | 0 | $ - 0 | ||||
| FTE = 1,920 Hours/Year |
| 6B. Staff Rate Sheet - Maintenance & Operations (Informational Only) | ||||||
| Bidder Name: | ||||||
| Item # | Job Classification Title | Hourly Rate | Number of Resources (FTE) | Duration | ||
| (Months) | Total Staff Costs | |||||
| Key Staff | ||||||
| 1 | $ - 0 | 0.0 | $ - 0 | |||
| 2 | $ - 0 | 0.0 | $ - 0 | |||
| 3 | $ - 0 | 0.0 | $ - 0 | |||
| 4 | $ - 0 | 0.0 | $ - 0 | |||
| 5 | $ - 0 | 0.0 | $ - 0 | |||
| 6 | $ - 0 | 0.0 | $ - 0 | |||
| 7 | $ - 0 | 0.0 | $ - 0 | |||
| 8 | $ - 0 | 0.0 | $ - 0 | |||
| 9 | $ - 0 | 0.0 | $ - 0 | |||
| 10 | $ - 0 | 0.0 | $ - 0 | |||
| All Other Non-Key Staff | ||||||
| 1 | $ - 0 | 0.0 | $ - 0 | |||
| 2 | $ - 0 | 0.0 | $ - 0 | |||
| 3 | $ - 0 | 0.0 | $ - 0 | |||
| 4 | $ - 0 | 0.0 | $ - 0 | |||
| 5 | $ - 0 | 0.0 | $ - 0 | |||
| 6 | $ - 0 | 0.0 | $ - 0 | |||
| 7 | $ - 0 | 0.0 | $ - 0 | |||
| 8 | $ - 0 | 0.0 | $ - 0 | |||
| 9 | $ - 0 | 0.0 | $ - 0 | |||
| 10 | $ - 0 | 0.0 | $ - 0 | |||
| Total Key Staff Resources | 0 | $ - 0 | ||||
| Total Non-Key Staff Resources | 0 | $ - 0 |
State of California State Water Resources Control Board CalWRAPP Pre-Solicitation No. 0000040884
7. Projected Staff Hours
| 7. Projected Staff Hours | Bidder Proposed FTEs per calendar month. (For information purposes only) | ||||||||||||||||||||||||||||||||||||||||||||||||
| Bidder Name: | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | ||||||||||||||||||||||||||
| Item # | Key Activities | Total Staff Hours | Subtotal Key Staff FTE Hours | Subtotal Non-Key Staff FTE Hours | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key | Non-Key | Key |
| 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 10 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 11 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 12 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 14 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 16 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 17 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 18 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 19 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | |||||||||||||||||||||||||||||||||||||||||||||||||
| TOTAL HOURS | - 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 |
8. User Licenses
| 8. User Licenses | |||||||||
| Bidder Name: | |||||||||
| Item # | Category | License Type | Named or Concurrent | Number of User Licenses (Range) | Bidder Proposed Initial Annual Cost per Year | Bidder Proposed Annual Renewal Cost per Year | Bidder Range offered as part of the Bidder's Cost Proposal | Total Cost | |
| (Core Contract 1-3) | Total Cost | ||||||||
| (Optional Years 4-5) | BIDDER COMMENTS |
(Enter comment if Named vs Concurrent column is Other.)
| 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 8 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 9 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 11 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 12 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 13 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 14 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 15 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 16 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 17 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 18 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 19 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 20 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 21 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 22 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 23 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 24 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 25 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 26 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 27 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 28 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 29 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 30 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 31 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 32 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 33 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 34 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 35 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 36 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 37 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 38 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 39 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 40 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 41 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 42 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 43 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 44 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 45 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 46 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 47 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 48 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 49 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 50 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| TOTALS | $ - 0 | $ - 0 | |||
| NOTES: |
• BI Licenses: To meet the needs of the State, Contractor shall include 262 BI licenses as part of their cost proposal. Costs for the first 262 will roll up to Tab 2 Cost Summary, cells G12 and G21. See RFP Section 6.5 (EVV Solution Reporting) for applicable requirements.
• License Type: Bidder shall enter the type of license per their licensing model, such as core EVV solution, portal, BI, etc.
• Named vs Concurrent: Bidder shall whether the licenses are named or concurrent.
• Number of Users Licenses: Bidder shall update the number of user licenses (column C) with the BI user ranges which the Bidder leverages for their user license pricing model. For example, C4 could equal "1 to 500", C5 "501 to 1,000", C6 "1,001 to 2,000", etc.
• Bidder Proposed Initial Annual Cost: Bidder shall provide their initial cost per range (column D), which captures the first time annual cost of the license range.
• Bidder Proposed Annual Renewal Cost: Bidder shall provide their renewal cost per range (column E).
• Bidder Range Offered: Bidder shall use the drop down to indicate which user ranges are included within their cost proposal (i.e. Tabs 4-6), so that the State understands how many licenses are included in the Contract.
• Total Columns: Total Cost (Core Contract) totals the total costs for the 5 year contract. Total Cost (Optional Years) totals the 4 years of potential optional extension years. Total Amount Included in BAFO totals the core contract and optional years if the range (column H) is indicated as Yes; whereas Total Amount Not Included in BAFO totals the core contract and optional years if the range (column H) indicates No.
• Bidder Comments: Enter comment if Named vs Concurrent column is Other; or if additional clarification is needed.
Sheet1
| 1. SaaS Subscription License |
| 2. Tools License |
| 3. 3rd Party Software |
Sheet2
| 1. SaaS Subscription Licensing |
| 2. Tools Software Licensing |
| 3. Third Party Software Components Licensing |
| 4. Other (Use Notes Column to Define) |
image1.png
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .