6._EXHIBIT_C_-_COST_WORKBOOK.xlsx

XLSX spreadsheet 107 KB Posted

Attached to
RFP 25-4-002-1 DOC SMARA-4 Project
Solicitation number
0000037279
Issued by
California

About this file

This Cost Workbook is an exhibit to RFP 25-4-002-1 for the SMARA-4 Project, issued by the California Department of Technology (CDT), Office of Statewide Technology Procurement (OSTP), on behalf of the Department of Conservation (DOC). The workbook serves as the cost submission vehicle for bidders responding to this technology procurement. The RFP requires licensing support for up to 50 internal DOC users and up to 1,000 external users. The final proposal, including the completed Cost Workbook, must be submitted to SharePoint in a folder marked "Volume 2 Cost" by January 20, 2026 at 10:00 AM PST, with OSTP eVAQ approval required as a non-negotiable condition. The contract term consists of a three-year base period (Years 1-3) with three optional two-year extension periods available (Years 4-9), providing the potential for up to a nine-year contract duration.

The Cost Workbook requires bidders to complete eight worksheets addressing Licensing, Maintenance and Operations (M&O) Services, Required Services, Optional Services, Non-Recurring Costs, and Unanticipated Tasks across all contract years. Costs are evaluated as 50 percent of the overall bid score. Bidders must provide unit pricing and hourly rates for key staff classifications (Project Manager, Business Analyst, and Solution Architect) in unshaded cells. The quantities provided in the worksheets are for evaluation purposes only and do not obligate DOC to utilize the entire amounts. The submitted costs will establish the maximum contracted costs and rates for the awarded contract and must align with all requirements outlined in Exhibit A (Functional and Non-Functional Requirements) and the Statement of Work. The Cost Summary sheet automatically calculates totals from data entered in the individual cost worksheets, providing a comprehensive view of pricing across all nine potential contract years.

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

Cost Workbook Instructions (no input required on this sheet)

Bidders shall submit their Cost Workbook per the instructions in RFP Part 1, Cost Workbook instructions and submission requirements.
The Cost Workbook must be submitted with the Bidder's Final Proposal per section 5.2 Cost Workbook Instructions
The Exhibit B - Cost Workbook must be uploaded to SharePoint into a separate folder marked "Volume 2 Cost".
Costs will be evaluated as 50% of the bid. Bidders are encouraged to ensure pricing aligns with ability to deliver all requirements outlined in Exhibit A - Functional and Non-Functional Requirements and SOW.
Quantities provided in the worksheets are for evaluation purposes only and should not be used as indication of future orders.
Quantities used for the Evaluation indicate the possible numbers for a typical bidder.
There is no obligation on DOC's part to utilize the entire amount in the Cost Workbook or the entire quantities provided in the Worksheets.
The unit price and all boxes that are not grayed out will be the responsibility of the bidder to complete.
Bidder's shall enter the Bidder's cost for each feature in the unshaded cells, in each Cost Worksheet
The submitted costs contained within these tables will be used for evaluation purposes per RFP Part 1, Proposal Evaluation, and will establish the maximum contracted costs and rates of the awarded contract.
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).
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 8.
3. LicensingBidder enters in the annual cost for license/subscription. Also include in the description the details of what the license/subscription includes.
4. M&O ServicesBidder enters recurring Maintenance and Operations (M&O) services costs as defined in SOW Section 28 and Help Desk / Call Center in Section 29. [if applicable]
5. Required ServicesBidder enters in costs not included in 3. Licensing or 4. M&O tabs that would be required to meet all requirements in the SOW. [if applicable]
6. Optional ServicesBidder enters in costs for optional products and services. This is basically a price list to document all the costs for optional services.
7. Non-recurring costsBidder would list any non-recurring costs during year 1 such as a one-time implementation fee.
8. Unanticipated TasksBidder enters proposed rates for each key staff role. The vendor must propose a rate for all classifications listed.

State of California Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

2. Cost Summary

Cost Summary Data Entry Not Permitted - Sheet Calculates Automatically

YearTitle3. Licensing4. M&O Services5. Required Services6. Optional Services7. Non-recurring costs8. Unanticipated TasksTotals
Year 11st year implementation$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 2Year 2 of 3 year contract$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 3Year 3 of 3 year contract$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 41st optional 2 yr extension (yr 1)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 51st optional 2 yr extension (yr 2)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 62nd optional 2 yr extension (yr 1)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 72nd optional 2 yr extension (yr 2)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 83rd optional 2 yr extension (yr 1)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Year 93rd optional 2 yr extension (yr 2)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Project Costs Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Cross reference to worksheets$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Evaluated Contract Cost (for evaluation purposes only) $ - 0

Unanticipated Tasks (equals 10% of Implementation Costs) $ - 0

Project Costs(1) + Unanticipated Tasks$ - 0
(1) = Licensing, M&O Services, Required Services and Non-recurring costs

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

3. Licensing <Enter Bidder Name>

Licensing/Subscription Costs

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 99 Year Total
Item #Description of License CostsSKU/Part NumberQtyYearly Cost Per User/ItemExtended CostYearly Cost Per User/ItemExtended CostYearly Cost Per User/ItemExtended CostYearly Cost Per User/ItemExtended CostYearly Cost Per User/ItemExtended CostYearly Cost Per User/Item.Extended CostYearly Cost Per User/ItemExtended CostYearly Cost Per User/ItemExtended CostYearly Cost Per User/ItemExtended CostTotal Cost Per Line Item
1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Subtotals $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

1. Enter Bidder Company Name in cell B1.

2. This worksheet is to define the annual costs to support licensing/subscription.

3. In the description section (Column B), list out all the items included in the license/subscription cost (implementation, training, maintenance, etc.)

4. SKU/Part Number (Column C). List any applicable part numbers that should be included in the purchase order.

5. Quantity (Column D). Require licensing to support up to 50 internal DOC users and up to 1000 external users.

6. Yearly cost per user/item (Column E). Enter the cost per year for each license/item.

7. If the bidder's licensing structure is tiered or represents a group of license costs, bidder should define the tier range or group that the cost is associated with. For example, of the cost per license is the same for quantities 0-100, state this range in the description.

8. Continue completing the annual costs for Year 2 thru Year 9.

4. M&O Services

Maintenance and Operations (M&O) Services

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9M&O Totals
Item #Description of M&O ServiceMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostTotal Cost
1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Subtotals $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

1. If applicable, enter any additonal M&O service costs not included in 3. Licensing tab that would be required to meet all the requirements listed in SOW; Section 28: Maintenance and Operations (M&O) and Section 29: Help Desk/Call Center.

2. In the description field, enter in the additional services these costs cover.

5. Required Services

Required Services

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Required Services Totals
Item #Description of Required ServiceMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostMonthly CostNumber of MonthsExtended CostTotal Cost
1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Subtotals $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

1. If applicable, list any required services not included in 3. Licensing tab that would be required to meet all the mandatory requirements listed in the SOW and Funtional and Non-Functional requirements.

2. In the description field, enter in the additional feature or service these costs cover.

One-Time Project Services Costs

Delivery Date (End of Month)Phase 1Phase 2Phase 3Phase 4Phase 5
SOW 2.7.1 Implementation Planning and Management
Final Implementation Plan1/1/22$ 100,000.00
Final Implementation Project Schedule
Final Risk Assessment of the implementation approach
Update input into the CSPS project plans
SOW 2.7.2 Solution Design, Configuration, and Development
Software/Configuration Development Methodology Plan
Logical data model design
Interface specifications for all required interfaces
User interface designs and specifications
Operational report specifications
Delivery of business rule engines and configuration tables
SOW 2.7.3 Data Conversion Support
SOW 2.7.5 Testing
SOW 2.7.5 Training
2.7.6 OCM Support
BECKY'S IDEA: ADDITIONAL T&M STAFF REQUIRED TO FULFILL CONTRACT.

Hosting

Bidder's Name
Base AgreementOptional Extensions
DD&I through Final System Acceptance (FSA)FSA through end of Base AgreementYear 1Year 2Year 3
Item #DescriptionNumber of MonthsMonthly Hosting CostExtended CostNumber of MonthsMonthly Hosting CostExtended CostMonthly Hosting CostExtended CostMonthly Hosting CostExtended CostMonthly Hosting CostExtended Cost
1Host T136$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2T212$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Base Period Total$ - 0
Optional Period Total$ - 0

Software & Licensing Costs (OLD

Bidder Name
Base AgreementOptional Extensions
DD&I through Final System Acceptance (FSA)FSA through end of Base AgreementYear 1Year 2Year 3
Item #Description of Third-Party Software Products and License CostsProject Phase for Purchase / Installation# of Licenses RequiredOne-Time Cost Per LicenseExtended CostAnnual Cost Per LicenseNumber of Years (DEFINE PER CONTRACT)Extended CostAnnual Cost Per LicenseExtended CostAnnual Cost Per LicenseExtended CostAnnual Cost Per LicenseExtended Cost
1Administrator License050$ 1,200.00$ 60,000.00$ - 0$ - 0$ - 0$ - 0
2Super User License0100$ 800.00$ 80,000.00$ - 0$ - 0$ - 0$ - 0
3Standard User License1250$ 1,000.00$ 250,000.00$ - 0$ - 0$ - 0$ - 0
4Standard User License2500$ 800.00$ 400,000.00$ - 0$ - 0$ - 0$ - 0
5Standard User License31500$ 600.00$ 900,000.00$ - 0$ - 0$ - 0$ - 0
6Standard User License4750$ 400.00$ 300,000.00$ - 0$ - 0$ - 0$ - 0
7Portal Access - 50,000 users11$ 10,000.00$ 10,000.00$ - 0$ - 0$ - 0$ - 0
8Portal Access - 50,000 users22$ 8,000.00$ 16,000.00$ - 0$ - 0$ - 0$ - 0
9Portal Access - 50,000 users31$ 6,000.00$ 6,000.00$ - 0$ - 0$ - 0$ - 0
10Portal Access - 50,000 users41$ 4,000.00$ 4,000.00$ - 0$ - 0$ - 0$ - 0
11Administrator LicenseFSA50$ - 0$ 200.003$ 30,000.00$ 215.00$ 10,750.00$ - 0$ - 0
12Super User LicenseFSA100$ - 0$ 150.003$ 45,000.00$ 165.00$ 16,500.00$ - 0$ - 0
13Standard User LicenseFSA3000$ - 0$ 100.003$ 900,000.00$ 110.00$ 330,000.00$ - 0$ - 0
14Portal Access - 50,000 usersFSA5$ - 0$ 5,000.003$ 75,000.00$ 5,200.00$ 26,000.00$ - 0$ - 0
15$ - 0$ - 0$ - 0$ - 0$ - 0
16$ - 0$ - 0$ - 0$ - 0$ - 0
17$ - 0$ - 0$ - 0$ - 0$ - 0
18$ - 0$ - 0$ - 0$ - 0$ - 0
19$ - 0$ - 0$ - 0$ - 0$ - 0
20$ - 0$ - 0$ - 0$ - 0$ - 0

Base Period Subtotals $ 2,026,000.00 $ 1,050,000.00

Base Period Total $ 3,076,000.00

Optional Period Subtotals $ 383,250.00 $ - 0 $ - 0

Optional Period Total $ 383,250.00

6. Optional Services

Optional Services Price List

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9
Item #Description of Optional ServiceUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unitUnit of measureQuantityCost/unit
1Data conversion and migrations services (Mandatory - Optional)111111111
2111111111
3111111111
4111111111
5111111111
6111111111
7111111111
8111111111
9111111111
10111111111
11111111111
12111111111
13111111111
14111111111
15111111111
16111111111
17111111111
18111111111
19111111111
20111111111
Subtotals (for evaluation purposes only)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

1. List any optional services not included in any of the mandatory requirements and their cost/unit. Optional services such as workshops, training, premium support, etc.

2. In the description field, enter in the description of the optional service

3. In the unit of measure field, indicate if the cost is per unit (ea), hour, day, month, etc.

4. Required- One of the Mandatory-Optional services is "Data conversion and migration services". If this service has a separate fee, include as a cost in the "Year 1" column. If this cost is covered in a previous tab, then enter zero ($0) as the cost for this service.

7. Non-recurring costs

Non-recurring costs

YearDescription
(list non-recurring cost items)Number of MonthsMonthly CostTotal Cost (Year 1)
Year 1$ - 0

Total non-recurring costs $ - 0

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

1. This section is to enter any one time non-recurring costs (NRC) for the initial implementation year.

2. Bidder only permitted to enter data within unshaded cells.

3. In the Description column (Column C), list out the details of the one-time cost.

4. In the Monthly Cost column (Column D), enter the monthly NRC cost.

5. If there are no NRC costs, enter "N/A" in the Description column.

8. Unanticipated Tasks

Unanticipated Tasks

IDStaff ClassificationHourly Rate
(Year 1)Hourly Rate
(Year 2)Hourly Rate
(Year 3)Hourly Rate
(Year 4)Hourly Rate
(Year 5)Hourly Rate
(Year 6)Hourly Rate
(Year 7)Hourly Rate
(Year 8)Hourly Rate

(Year 9)

1Project Manager
2Business Analyst
3Solution Architect
Subtotal (for evaluation purposes only)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Department of Technology RFP

ITS23-009

Part 2 - Bidder Response December 12th, 2023

&A Page &P of &N

1. Bidder provide rates for all key staff classifications to help evaluation of costs for Unanticipated Tasks. See SOW; Section 34. Unanticipated Tasks for more detail.

2. Bidder's are cautioned to provide the lowest, most competitive rates.

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