5_Exhibit_C_Cost_Worksheet_09.23.24.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
RFP 0078-02 Master Observation Database System (MODS)
Solicitation number
0000032868
Issued by
California

About this file

This document is an Exhibit C - Cost Worksheet for RFP #0078-02 issued by the State of California Department of Fish and Wildlife for a Master Observation Database System (MODS) implementation project. The worksheet provides detailed instructions for bidders to enter costs for various deliverable groups including project management, design, data conversion/migration, infrastructure setup, build, testing, training, deployment, maintenance and operations preparation, and project close. Bidders must also provide staff hourly rates for key personnel and monthly maintenance and operational support costs for the optional contract years 4 and 5. The total costs calculated from the worksheet will be used for evaluation purposes.

The worksheet requires bidders to enter all cost data in the designated green-highlighted cells across the different tabs. The State has populated some cells with formulas, but the bidder is responsible for ensuring the worksheets and calculations are accurate. The total costs from this worksheet will be packaged separately from the rest of the bidder's proposal as per the instructions in the RFP.

View the file

Other files

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

RFP 0078-02: Master Observation Database System (MODS)
Bidder Name:[Enter Bidder Name Here in Tab 1. Instructions, Cell B2]
1. Instructions
Please refer to the RFP and the SOW for details describing the services and the scope of the system implementation. The services to be provided and their associated costs shall be entered in this Cost Worksheet as specified. Bidders must ensure all cost data is submitted in the format outlined in this workbook.
1.Bidder shall enter data in Workbook tabs 3-5 in the green-highlighted cells only.

All costs to the State must apply to the following:

- Tab "3. Deliverables Costs"

- Tab "4. Staff Hourly Rates"

- Tab "5. Optional Years (M&O)"

The State has populated some of the cells with formulas, however, it is the responsibility of the Bidder to ensure the worksheets and calculations are correct and accurate.

2. Tab "1. Instructions"

- Enter Bidder Name in Cell B2.

3.Tab "2. Total Cost Summary" - This tab calculates total costs based on the data entered into worksheet tabs 3-5. There is no data entry into this worksheet tab.
4.Tab "3. Deliverables Costs" - This tab lists the deliverables specified in EXHIBIT B - DELIVERABLES TABLE. The Bidder will enter fixed pricing for the level of effort required to complete each deliverable.

- Enter deliverable costs (Columns C) for each listed Deliverable Group as detailed in the SOW.

5. Tab "4. Staff Hourly Rates" is provided for Bidders to detail rates for Key Staff as identified in the SOW.

- Enter the hourly rates for each Job Classification Title in Column C.

6. Tab "5. Optional Years (M&O)" is designed to elicit the pricing of Maintenance and Operational (M&O) support for the service components throughout the optional contract term years (Years 4-5).

- Enter the monthly cost for M&O in Column C.

This Cost Worksheets shall be completed and be packaged separately from the rest of the Bidder's Proposal per instructions in SECTION 6. PROPOSAL/BID FORMAT AND SUBMISSION REQUIREMENTS.

State of California Department of Fish and Wildlife Exhibit C – Cost Worksheet Tab 1. Instructions

RFP #0078-02

2. Total Cost Summary

2. Total Cost Summary
Bidder Name:[Enter Bidder Name Here in Tab 1. Instructions, Cell B2]
TOTAL COSTS
(For evaluation purposes only)$ - 0
DeliverablesDeliverable Cost
Deliverable Group 1 - Project Management$ - 0
Deliverable Group 2 - Design$ - 0
Deliverable Group 3 - Data Conversion/Migration$ - 0
Deliverable Group 4 - Infrastructure Setup$ - 0
Deliverable Group 5 - Build$ - 0
Deliverable Group 6 - Testing$ - 0
Deliverable Group 7 - Training$ - 0
Deliverable Group 8 - Deployment$ - 0
Deliverable Group 9 - Maintenance & Operations Preparation$ - 0
Deliverable Group 10 - Project Close$ - 0
TOTAL DELIVERABLES #1-10 COST$ - 0
Unanticipated Tasks$ - 0
TOTAL BASE CONTRACT COST$ - 0

Staff Hourly Rate Total Cost $ - 0

Optional Year CostsOptional Contract Year 1Optional Contract Year 2
Maintenance & Operational Support$ - 0$ - 0$ - 0
TOTAL OPTIONAL YEAR COSTS$ - 0$ - 0$ - 0

Exhibit C – Cost Worksheet Tab 2. Total Cost Summary

RFP #0078-02

3. Deliverables Costs

3. Deliverables Costs
Bidder Name:[Enter Bidder Name Here in Tab 1. Instructions, Cell B2]
#Deliverable NameDeliverable Costs
1Project Management
1.1Project Management Plan (PMP)
1.2Discovery Activities
1.3Monthly Status ReportsIncluded
Deliverable #1 Cost Total$ - 0
2Design
2.1Functional Specification Document
2.2Technical Specification Document
2.3Solution Architecture Documents
2.4Infrastructure Planning & Design
2.5Database Design Document
2.6User Interface Design
2.7Integration Management Design
Deliverable #2 Cost Total$ - 0
3Data Conversion and Migration
3.1Data Conversion and Migration PlanIncluded
3.2Data Conversion and Migration Process
3.2.1Data Quality Assessment Report
3.2.2Data Cleansing Report
3.3Data Migration Test Plan
Deliverable #3 Cost Total$ - 0
4Infrastructure Setup
4.1Infrastructure Setup for Build
Deliverable #4 Cost Total$ - 0
5Build
5.1Solution Development Process
5.2Development and Preliminary Testing
Deliverable #5 Cost Total$ - 0
6Testing
6.1Test Plan
6.2Functional Testing
6.3Non-Functional Testing
6.4Integration Testing
6.5Database Validation Testing
6.6Smoke Testing
6.7User Acceptance Testing (UAT)
6.8End-to-End Testing Results ReportIncluded
6.9Pilot Testing
Deliverable #6 Cost Total$ - 0
7Training
7.1Training Plan
7.2Training Delivery
7.3Curriculum and Training Materials
7.4Training Execution & Completion ReportIncluded
Deliverable #7 Cost Total$ - 0
8Deployment
8.1Deployment Plan
8.2Analyze and Implement Pilot Testing Results
8.3Technical Go-Live, Formal System Acceptance, and Final Go-Live Report
8.4Cutover Plan
Deliverable #8 Cost Total$ - 0
9Maintenance and Operations Preparation
9.1Maintenance and Operations Plan
9.2Maintenance and Operations Support Training
9.3Maintenance and Operations Report (Optional M&O Years)Included
9.4Technology Recovery Plan
9.5System Performance and Capacity Management Plan
Deliverable #9 Cost Total$ - 0
10Project Close
10.1Software Maintenance Manual
10.2Project Closeout ReportIncluded
Deliverable #10 Cost Total$ - 0
IMPLEMENTATION COST TOTAL$ - 0

&9Exhibit C – Cost Worksheet Tab 3. Deliverables Costs&"Arial,Bold"

RFP #0078-02

4. Staff Hourly Rates

4. Staff Hourly Rates
Bidder Name:[Enter Bidder Name Here in Tab 1. Instructions, Cell B2]
Item #Job Classification TitleHourly Rate
1Project Manager
2Senior Data Architect
3Senior Software Solutions Architect
4Senior Business Analyst
5GIS Analyst
Total Staff Hourly Rates
(For Evaluation Purpose Only)$ - 0

State of California Department of Fish and Wildlife

&9Exhibit C – Cost Worksheet
Tab 4. Staff Hourly RatesRFP #0078-02

5. Optional Years (M&O)

5. Optional Years - Maintenance and Operational Support
Bidder Name:[Enter Bidder Name Here in Tab 1. Instructions, Cell B2]
Month of ContractOptional Contract YearM&O Support
Monthly Cost
11 (Year 4)
21 (Year 4)
31 (Year 4)
41 (Year 4)
51 (Year 4)
61 (Year 4)
71 (Year 4)
81 (Year 4)
91 (Year 4)
101 (Year 4)
111 (Year 4)
121 (Year 4)
Optional Year 1 Cost Total$ - 0
132 (Year 5)
142 (Year 5)
152 (Year 5)
162 (Year 5)
172 (Year 5)
182 (Year 5)
192 (Year 5)
202 (Year 5)
212 (Year 5)
222 (Year 5)
232 (Year 5)
242 (Year 5)
Optional Year 2 Cost Total$ - 0
Total Maintenance and Operational Support Cost Total$ - 0

Exhibit C – Cost Worksheet Tab 5. Optional Years (M&O)

RFP #0078-02

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