7._EXHIBIT_C_-_COST_WORKBOOK.xlsx

XLSX spreadsheet 107 KB Posted

Attached to
Pre-Solicitation RFP 25-4-002-1 SMARA-4
Solicitation number
0000036842
Issued by
California

About this file

This is an Excel-based Cost Workbook for a State of California Department of Technology (DOC) Request for Proposal (RFP ITS23-009) solicitation. The document provides a comprehensive cost submission template for potential bidders, covering a three-year base contract with optional two-year extensions, potentially extending the total contract period to nine years. The RFP requires bidders to provide detailed pricing across multiple worksheets including licensing, maintenance and operations (M&O) services, required services, optional services, non-recurring costs, and unanticipated tasks. The solicitation seeks a solution supporting up to 50 internal DOC users and 1,000 external users, with quantities in the worksheets intended for evaluation purposes only and not guaranteeing future order volumes.

The pricing structure emphasizes cost evaluation as 50% of the bid, with bidders required to enter unit prices and costs in unshaded cells across various categories. Key pricing components include annual licensing/subscription costs, monthly maintenance services, required and optional service rates, one-time implementation fees, and hourly rates for unanticipated tasks involving roles like Project Manager, Business Analyst, and Solution Architect. The cost workbook includes provisions for different license types (Administrator, Super User, Standard User, Portal Access) with varying quantities and pricing tiers, and allows for cost entries across the base contract years and optional extension periods. The state reserves the right to not utilize the entire proposed quantities or contract amounts, providing flexibility in future procurement.

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 .