RFP_37224_Attachment_2_Cost_Worksheet.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- RFP 37224 - CASE MANAGEMENT SYSTEM (CMS) REPLACEMENT, IMPLEMENTATION AND ONGOING SUPPORT
- Solicitation number
- 0000037224
- Issued by
- California
About this file
This is a Cost Worksheet template for RFP 37224, a Case Management System (CMS) Replacement, Implementation and Ongoing Support procurement issued by the Department of General Services (DGS) Procurement Division. The project encompasses nine core engagement phases spanning from initiation through project closure, including requirements analysis, solution design, system development, data migration, testing, implementation, and stabilization support. Bidders must complete designated yellow input cells only to submit their pricing for these phases and related services supporting approximately 200 users. The cost worksheet is structured to automatically calculate totals and extension costs based on bidder inputs, with specific instructions that any modification to the attachment will result in bidder disqualification.
The pricing structure separates costs into Core Engagement and Post-Implementation phases. Core Engagement costs are allocated across nine deliverable phases with specific payment percentages: Phase 1 (Requirements Analysis) at 10%, Phase 2 (Solution Design) at 15%, Phases 3-5 (Solution Development, Configuration, and Data Migration) at 25%, Phase 6 (Testing) at 10%, Phase 7 (Implementation) at 20%, Phase 8 (Stabilization Support) at 10%, and Phase 9 (Project Closure) at 10%. Post-Implementation costs include software licensing for Years 1-5, which must encompass platform, infrastructure, user seats, and all product licensing-related costs, as well as ongoing maintenance costs for Years 4-5. All calculated totals, extension costs, and grey-shaded fields are automatically computed; bidders must not enter data into these protected fields.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP_37224_Case_Management_System.pdf | ||
| RFP_37224_Addendum_No._1.pdf |
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
Cost Worksheet Key
| PRICING WORKSHEET KEY |
| COST WORKSHEET TEMPLATE |
(Rev 11/2025)
| Column Name | Line Item Number (LIN) | ||||
| Quantity / Unit of Measure | Description | Deliverables / Years of Service | Cost | % Payment Schedule for the Core Engagement1 | Total |
| Description |
(Bidder completes yellow cells only.) DGS Unique line item number. DGS's listed quantity / DGS Unit of Measure - Descriptor of the unit (i.e. each, per hours, etc). Informational text about the Service. Descriptor of the Deliverable phase / the year in which the service is to be provided Total Cost entered for "Core Engagement" auto populates the $ for each deliverable based on the associated %.
| Costs entered for the remainder are self evident. | The Deliverable Based Payment Schedule for the Core Engagement | Calculated Extension costs for Additional Licenses |
| END OF SHEET. | ||
| END OF SHEET. |
Cost Worksheet
| Department of General Services - Procurement Division | |||||
| Event ID: RFP 37224 - CASE MANAGEMENT SYSTEM (CMS) REPLACEMENT, IMPLEMENTATION AND ONGOING SUPPORT | |||||
| Attachment 2 - Cost Worksheet | |||||
| Bidder: | |||||
| Instructions: Bidder must complete the Yellow Input Cells only. | |||||
| CORE ENGAGEMENT | |||||
| Line Item # | Qty. /Each | Phase Description | Deliverables | Cost | % Payment Schedule for the Core Engagement1 |
| 1 | n/a | Initiation | n/a | n/a | |
| 2 | n/a | Concept Development | n/a | n/a | |
| 3 | 1 | Requirements Analysis | Phase 1 | $ - 0 | 10% |
| 4 | 1 | Solution Design | Phase 2 | $ - 0 | 15% |
| 5 | 1 | Solution Development, System Configuration and Integrations, and Data Migration | Phase 3, 4, and 5 | $ - 0 | 25% |
| 6 | 1 | Testing | Phase 6 | $ - 0 | 10% |
| 7 | 1 | Implementation | Phase 7 | $ - 0 | 20% |
| 8 | 1 | Stabilization Support | Phase 8 | $ - 0 | 10% |
| 9 | 1 | Project Closure | Phase 9 | $ - 0 | 10% |
| 10 | n/a | System Decommission | n/a | n/a | |
| 11 | Calculated Total Core Engagement: | $ - 0 | 100% |
| POST IMPLEMENTATION | ||||
| Line Item # | Qty./Year for 200 users | Description | Year of Service | Cost |
| 12 | 1 | Software Licensing2 | ||
| Year 1 | $ - 0 | |||
| 13 | 1 | Year 2 | $ - 0 | |
| 14 | 1 | Year 3 | $ - 0 | |
| 15 | 1 | Year 4 | $ - 0 | |
| 16 | 1 | Year 5 | $ - 0 | |
| 17 | Calculated Total Software Licencing Year 1 through 5: | $ - 0 | ||
| 18 | 1 | Ongoing Maintenance | ||
| Year 4 | $ - 0 | |||
| 19 | 1 | Year 5 | $ - 0 | |
| 20 | Calculated Total Ongoing Maintenance Year 4 through 5: | $ - 0 | ||
| 21 | Calculated Total Post Implementation Total: | $ - 0 |
22 Calculated Grand Total (lines 11 + 21) $ - 0
| 1 | Deliverable Based payment schedule based on indiated percentage. Indicated percentage will be released upon deliverable completion and OAH acceptance. |
| The percentages assigned to each Deliverable Phase may not reflect Bidders' planned allocation of effort | |
| 2 | Software licensing costs shall include platform, infrastructure, user seats, and other costs associated with product licensing |
| Note: Calculated totals and/or Extension costs are automatically calculated (Contract Unit Price x Quantity) |
| Bidders must not enter data into any grey shaded fields. These fields are calculated automatically. |
| ANY MODIFICATION OF ATTACHMENT 2 - COST WORKSHEET WILL DISQUALIFY BIDDER |
| END OF SHEET |
File details come from the government source that posted it. Updated .