Exhibit_D_Cost_Workbook_v3.0.xlsx
XLSX spreadsheet 66 KB Posted
- Solicitation number
- 0000040415
- Issued by
- California
About this file
This is an Exhibit D Cost Workbook for a Request for Proposal (RFP) issued by the Department of Motor Vehicles (DMV) for DL/ID Mainframe Services, Data & Integration (RFP ISD26-3629). The workbook serves as the cost submission template for bidders responding to this solicitation. The project encompasses comprehensive digital transformation services including mainframe modernization, data conversion and migration, system integration, back-end reengineering, and organizational change management support. The contract is structured across a four-year period spanning fiscal years 2026-27 through 2029-30, with a total project budget not to exceed $35,500,000. Key deliverables include project management and sub-plans, solution architecture documentation, data cleansing and conversion implementation, phased solution delivery for back-end reengineering and integrations, training coordination, hypercare and warranty services, and transition management activities. The RFP operates in two phases, with Phase 1 submissions containing no dollar amounts and Phase 2 submissions requiring detailed cost data in prescribed formats.
The cost workbook establishes strict guidelines for bidder submissions across five primary worksheets: totals (auto-calculated), software and equipment costs (optional), unanticipated task service rates, proposed services costs, and deliverables costs. Bidders must provide hourly labor rates for 25 defined key staff positions (including project managers, architects, developers, and specialized technical roles) as well as non-key staff classifications, with separate rates for onshore and offshore/nearshore personnel. The maximum contract amounts are allocated by fiscal year: $9,500,000 for FY 2026-27, $14,000,000 for FY 2027-28, $9,000,000 for FY 2028-29, and $3,000,000 for FY 2029-30. Unanticipated tasks are budgeted at 10 percent of total contract costs and will be authorized through a formal Work Authorization process. All bidder-provided software must be non-proprietary and licensed to the State at no additional charge. Deliverables are categorized with maximum cost percentages: project management plans (4%), solution architecture (20%), data conversion and implementation (70%), training and OCM coordination (3%), and hypercare and warranty services (3%). The workbook requires that deliverables costs equal total service costs and that no more than 75 percent of hours can be allocated to non-key staff per deliverable.
View the file
Other files
Show all 42
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
0-Instructions
| DMV DXP WS3A - DL/ID Mainframe Services, Data & Integration RFP (ISD26-3629) - Exhibit D - COST WORKBOOK | |
| Worksheet No. | Worksheet Title |
| Worksheet No. 0 | Instructions |
| Worksheet No. 1 | DL-ID Cost C-1 Totals |
| Worksheet No. 2 | DL-ID Cost C-2 Software and Equipment Costs (Optional) |
| Worksheet No. 3 | DL-ID Cost C-3 Unanticipated Cost Service Rates |
| Worksheet No. 4 | DL-ID Cost C-4 Proposed Services Cost |
| Worksheet No. 5 | DL-ID Cost C-5 Deliverables |
| Cost Workbook Instructions |
| The Bidder must adhere to the instructions below when completing the Cost Workbook. |
Dollar amounts are not permitted in the Bidder's Phase 1 Cost Response.
Specify the Bidder's name in the appropriate field on Worksheet No. 2.
If selected for Phase 2, Bidder is required in its Phase 2 Cost Workbook to specify all cost data in the format prescribed, even if no cost will be associated with the item indicated on the worksheet(s). When no costs are associated with an item in its Phase 2 Cost Workbook, Bidder must indicate the cost as zero (0 or $0.00).
If any character other than a numeral, dollar sign, comma, or decimal is used (e.g., a dash) in the Bidder's Phase 2 Cost Response, the State will assume the cost of the item to be zero (0 or $0.00). All other fields must not be modified. If a Cost Worksheet is modified or includes blank cells when a value is expected, the State may reject the Proposal.
The State has populated many cells with formulas, however it is the responsibility of Bidder to ensure the Cost Workbook and its calculations are correct and accurate. The State will not assume responsibility for any Cost Workbook that is not properly calculated.
| The list below summarizes the worksheets within this Exhibit D: Cost Workbook. |
| DL-ID Cost C-1: Totals |
| This worksheet is automatically calculated using data from the other worksheets. Do not enter information on this auto-summarized worksheet. |
NOTE: Line D must not exceed the project budget amount of $35,500,000.
| DL-ID Cost C-2: One-Time and Ongoing Software and Equipment Costs (Optional - if Bidder-Provided) |
| This worksheet lists costs for any Bidder-provided Solution accelerator or add-on software, as well as any Bidder-provided equipment and/or software support. |
Bidder must provide a narrative description in Column 1 for each item listed, and describe how the one-time costs and subscription/ongoing costs are allocated and how these costs align with the incremental Agile set of production releases planned by the Bidder. The State expects to have a clear understanding of when license costs are required to ensure all products are available to meet production release needs. All Contractor-provided software, including but not limited to product or Solution accelerators, enhancements, add-ons, and any other Contractor-provided software elements and features shall be non-proprietary in nature. Software and intellectual property the Contractor owns and does not offer on the open market for purchase or subscription is not acceptable for use in the DxP Solution. Such software must be licensed to or otherwise retained by the State for future use in a non-proprietary manner at no additional charge.
| DL-ID Cost C-3: Unanticipated Task/Service Rates |
| This worksheet lists the rates for staff who may perform Unanticipated Tasks during the Contract period. The total Cost for Unanticipated Tasks will be entered automatically on worksheet DL Cost C-1 Totals as 10% of the sum of Rows A and C and include the average hourly rates above for 1) Key Staff, 2) Offshore Non-Key Staff, and 3) Onshore Non-Key Staff. Bidder must ensure the average rates for Non-Key Staff (offshore/nearshore and onshore average rates) include any additional Non-Key Staff rows added by the Bidder. |
| DL-ID Cost C-4: Proposed Services Cost |
| This worksheet lists the hourly rates and expected annual hours for staff proposed for the Contract period, including completion of all tasks and deliverables prior to the final Hypercare and Warranty period. There must be sufficient staffing to achieve project deliverables and milestones without exceeding the total project cost. It may be helpful to complete RFP ATTACHMENT 17.1: KEY STAFF QUALIFICATIONS MATRIX before filling in this section. The sum of the values listed on Worksheet C-4 must equal to the sum of the values listed on Worksheet C-5. |
| DL-ID Cost C-5: Deliverables Cost |
| This worksheet lists the deliverables to be provided during the Contract period, which must be priced and included in the Bidder’s Phase 2 Proposal. |
Note that project plan deliverables (DEL-1 to DEL-8) will be initiated in many cases from existing DXP project plans developed through prior DXP project phases. The Bidder will enter the hours worked by Key Staff and Non-Key Staff for each deliverable; this worksheet will total the associated cost of staff to display the deliverable total cost. The DMV has indicated the maximum amount for categories of deliverables in column 2a; the Bidder must ensure that the combined total of deliverables within the category does not exceed the maximum percentage of total cost. It may be helpful to complete RFP ATTACHMENT 17.1: KEY STAFF QUALIFICATIONS MATRIX before filling in this section. The sum of the values listed on Worksheet C-5 must equal to the sum of the values listed on Worksheet C-4.
1-DL-ID Cost C-1 Totals
| DMV DXP WS3A - DL/ID Mainframe Services, Data & Integration RFP (ISD26-3629) - Exhibit D - COST WORKBOOK | |||||||
| Bidder Name: | |||||||
| Table C-1: Totals | |||||||
| This worksheet is auto-populated using data from the other worksheets in this Cost Workbook, therefore no input from the Bidder is required. Cell addresses specified in ITEM description may change if Bidder inserts additional rows to worksheet from which the data is collected. | |||||||
| ROW | ITEM | TOTAL COST | Subtotal FY 2026-27 Cost | Subtotal FY 2027-28 Cost | Subtotal FY 2028-29 Cost | Subtotal FY 2029-30 Cost | |
| A | Costs for One-Time and Ongoing Software for DL-ID - Bidder-Provided | ||||||
| from DL-ID Cost C-2 Optional(Cells V18, W18, X18, Y18) | $0 | $0 | $0 | $0 | $0 | ||
| B | Service Cost for Unanticipated Tasks | ||||||
| Average Hourly Rate for Key Staff | $0 | ||||||
| Average Hourly Rate for Onshore Non-Key Staff | $0.00 | ||||||
| Average Hourly Rate for Offshore Non-Key Staff | $0.00 | ||||||
| from DL-ID Cost C-3 (Cells C18, C28, and D29) |
NOTE: The cost for Row B is set at 10% of the Contract Total Cost
| (C-1 Row A + Row C)/10 | $0 | |
| C | Service Cost Total for Contract Period |
from DL-ID Cost C-4 (Cells I25, J25, K25, L25)
| MUST EQUAL DELIVERABLES COST TOTAL FOR CONTRACT PERIOD | $0 | $0 | $0 | $0 | $0 |
| D | Deliverables Cost Total for Contract Period |
from DL Cost C-5 (Cell C17)
| MUST EQUAL SERVICE COST TOTAL FOR CONTRACT PERIOD | $0 | ||||||
| E | Amount to be Awarded to Winning Bidder | ||||||
| Must not exceed $35,500,000 | $0 | ||||||
| Total Cost by FY: | $0 | $0 | $0 | $0 | |||
| Notes | |||||||
| The amounts listed above are for evaluation purposes only. |
| The maximum contract amount for Fiscal Year (FY) 2026-27 is $9,500,000 |
| The maximum contract amount for Fiscal Year (FY) 2027-28 is $14,000,000 |
| The maximum contract amount for Fiscal year (FY) 2028-29 is $9,000,000 |
| The maximum contract amount for Fiscal year (FY) 2029-30 is $3,000,000 |
2-DL-ID Cost C-2 Optional
| DMV DXP WS3A - DL/ID Mainframe Services, Data & Integration RFP (ISD26-3629) - Exhibit D - COST WORKBOOK | |||||||||||||||||||||
| Table C-2: One-Time and Ongoing Software Costs (Optional/if Bidder-Provided) | |||||||||||||||||||||
| The Bidder must provide costs for any and all Bidder-provided software licenses, additional software, and technical support services listed in Column Zero (0). Each row's total is the sum of the amounts specified in Columns 2a-2d and 3a-3d. To obtain the Total Cost (Column 14), specify the number of licenses per fiscal year (FY) in Columns 4, 5, 6,and 7. Optional columns 8, 9 and any inserted columns by the Bidder are used to capture costs for additional implementation segments. Multiply the sum of Columns 4, 5, 6, 7, 8, and any inserted columns for implementation segments by the Unit Cost (Column 12). Enter the result as either a One-Time Cost incurred during a specific FY (Columns 2a, 2b, 2c, 2d) or an Ongoing Cost by FY (Columns 3a, 3b, 3c, 3d), whichever applies. For each row, please also specify the the Unit Type (Column 11), and the Number of Units (Column 13) (if applicable). | |||||||||||||||||||||
| 0 | 1 | 2a | 2b | 2c | 2d | 3a | 3b | 3c | 3d | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | |
| Bidder-Provided Software/Support | Software Item Description and Purpose | ||||||||||||||||||||
| - INCLUDE NARRATIVE - | One-Time Costs incurred in | ||||||||||||||||||||
| FY 2026-27 | One-Time Costs incurred in | ||||||||||||||||||||
| FY 2027-28 | One-Time Costs incurred in | ||||||||||||||||||||
| FY 2028-29 | One-Time Costs incurred in | ||||||||||||||||||||
| FY 2029-30 | Ongoing Costs - ongoing costs for data cleansing/ conversion/ migration, back-end services enhancement, Hypercare and Warranty in | ||||||||||||||||||||
| FY 2026-27 | Ongoing Costs - ongoing costs for data cleansing/ conversion/ migration, back-end services enhancement, Hypercare and Warranty in | ||||||||||||||||||||
| FY 2027-28 | Ongoing Costs - ongoing costs for data cleansing/ conversion/ migration, back-end services enhancement, Hypercare and Warranty in | ||||||||||||||||||||
| FY 2028-29 | Ongoing Costs - ongoing costs for data cleansing/ conversion/ migration, back-end services enhancement, Hypercare and Warranty in | ||||||||||||||||||||
| FY 2029-30 | FY 2026-27 # of licenses needed | FY 2027-28 # of licenses needed | FY 2028-29 # of licenses needed | FY 2029-30 # of licenses needed | Production Implementation #1 - # of additional licenses needed | Production Implementation #2 - # of additional licenses needed | Production Implementation #NN - # of additional licenses needed | Unit Type (e.g., external user, internal user, CPU, hours) | Unit Cost – If multiple unit types for a part, use a different line for each unit type | ||||||||||||
| # of Units | Total Software and Support Costs | ||||||||||||||||||||
| (Columns 2a through 3d) | Total FY 2026-27 | Total FY 2027-28 | Total FY 2028-29 | Total FY 2029-30 | |||||||||||||||||
| a. Bidder-provided software accelerators/add-on licenses |
List each item in its own row numbered as follows a(1), a(2), a(3)… Insert rows as needed.
| a(1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| a(2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| a(3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| b. Costs for bidder-provided component technical support (annual warranty/tech support/upgrade fees) |
List each item in its own row numbered as follows b(1), b(2), b(3)… Insert rows as needed.
| b(1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| b(2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| b(3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| c. Other required bidder-provided components - costs |
List each item in its own row numbered as follows c(1), c(2), c(3)… Insert rows as needed.
| c(1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| c(2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| c(3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| d. Contract Subtotal Cost for Software/Hardware/Technical Support | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| Notes: | ||||||||||||||||||||||
| Unit costs must remain the same throughout the contract period. Bidders may add rows for additional software products, as required, for their solution. | ||||||||||||||||||||||
| Production Implementation begins upon formal written Feature Acceptance by the State. | ||||||||||||||||||||||
| Pre-production licenses may be a different base cost than post-production licenses (developer licenses, vs. consumer licenses, etc.). | ||||||||||||||||||||||
| Columns should be added to address all environments: development, testing, production, etc. Insert additional columns as needed for additional DD&I segments. | ||||||||||||||||||||||
| As applicable, software costs shall be based on the estimated 8,000 internal user volume. DMV anticipates that the pre-production quantities of software will be substantially lower than the post-production quantities. | ||||||||||||||||||||||
| Totals from this worksheet will be listed on worksheet DL Cost C-1 Totals. |
3-DL-ID Cost C-3 Unanticipated
| DMV DXP WS3A - DL/ID Mainframe Services, Data & Integration RFP (ISD26-3629) - Exhibit D - COST WORKBOOK |
| Table C-3: Unanticipated Task/Service Rates |
| Unanticipated Tasks represent additional work that must be performed, but not identified in the DMV's SOW. The DMV expects that during the Contract Term, legislative and/or program changes necessitate application/system modifications. Support for such modifications will result in unanticipated work at costs to be structured on the Bidder's labor costs to support change requests. |
Both the DMV and the Contractor must use the Work Authorization process outlined in the SOW and agree upon the work that needs to be performed, which will result in unanticipated costs. No work can be performed in advance of DMV's approval of a Work Authorization document.
The Bidder must specify the unanticipated hourly labor rate for the required staff classifications below for their proposal to be considered responsive. During the course of the Contract, the Contractor may use other classifications to perform work; however, the unanticipated task rate charged by the Contractor will be at the lowest classification rate provided in the Contractor's Hourly Labor Rates and classifications below. Offshore work is restricted as shown in the Statement of Work.
Bidder will determine which Key Staff will be proposed for Unanticipated Tasks.
Bidder may insert additional rows if
Information from this worksheet will be included on worksheet DL Cost C-1 Totals.
| 1 | 2 | 3 | 4 | |
| Consultant Role | Consultant Name* | Hourly Rate for ONSHORE Staff | ||
| for Unanticipated Tasks | Hourly Rate for OFFSHORE / NEARSHORE Staff |
for Unanticipated Tasks
| KEY STAFF POSITIONS | |||
| 1) Billable Hourly Rate for Project Manager (Key Staff) | $0.00 | NA | |
| 2) Billable Hourly Rate for Senior Information Architect/Lead (Key Staff) | $0.00 | NA | |
| 3) Billable Hourly Rate for Data Conversion Lead (Key Staff) | $0.00 | NA | |
| 4) Billable Hourly Rate for Senior Data Architect/DBA (Key Staff) | $0.00 | NA | |
| 5) Billable Hourly Rate for ETL Developer (Key Staff) | $0.00 | NA | |
| 6) Billable Hourly Rate for Salesforce Developer (Key Staff) | $0.00 | NA | |
| 7) Billable Hourly Rate for Senior Salesforce Developer (Key Staff) | $0.00 | NA | |
| 8) Billable Hourly Rate for Mulesoft Developer (Key Staff) | $0.00 | NA | |
| 9) Billable Hourly Rate for Senior Integration Lead (Key Staff) | $0.00 | NA | |
| 10) Billable Hourly Rate for Data Analyst (Key Staff) | $0.00 | NA | |
| 11) Billable Hourly Rate for Business Analyst (Key Staff) | $0.00 | NA | |
| 12) Billable Hourly Rate for Senior Program Manager/Engagement Director (Key Staff) | $0.00 | NA | |
| 13) Billable Hourly Rate for Senior Solution Architect/Chief Architect (Key Staff) | $0.00 | NA | |
| 14) Billable Hourly Rate for Legacy/Mainframe Modernization Lead (Key Staff) | $0.00 | NA | |
| 15) Billable Hourly Rate for Security Lead/Contractor Security Manager (Key Staff) | $0.00 | NA | |
| 16) Billable Hourly Rate for Release and Cutover Manager/Transition Manager (Key Staff) | $0.00 | NA | |
| 17) Billable Hourly Rate for Quality Assurance and Test Lead (Key Staff) | $0.00 | NA | |
| 18) Billable Hourly Rate for Data Quality and Reconciliation Lead (Key Staff) | $0.00 | NA | |
| 19) Billable Hourly Rate for Training and Knowledge Transfer Lead (Key Staff) | $0.00 | NA | |
| 20) Billable Hourly Rate for OCM Lead (Key Staff) | $0.00 | NA | |
| 21) Billable Hourly Rate for Scrum Master (Key Staff) | $0.00 | NA | |
| 22) Billable Hourly Rate for Test Automation Engineer (Key Staff) | $0.00 | NA | |
| 23) Billable Hourly Rate for Test Analyst/Tester (Key Staff) | $0.00 | NA | |
| 24) Billable Hourly Rate for Technical Writer/Documentation Lead (Key Staff) | $0.00 | NA | |
| 25) Billable Hourly Rate for Rules Engine Developer (Key Staff) | $0.00 | NA | |
| 26) Billable Hourly Rate for any additional Key staff roles proposed by bidder (List Role) | $0.00 | NA | |
| NON-KEY STAFF POSITIONS | |||
| 27) Billable Hourly Rate for Non-Key Staff | $0.00 | $0.00 | |
| 28) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| 29) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| 30) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| 31) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| 32) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| 33) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| 34) Billable Hourly Rate for other Non-Key Staff (List Role) | $0.00 | $0.00 | |
| AVERAGE RATE FOR ONSHORE NON-KEY STAFF | Bidder should ensure that average calculation includes any additional rows inserted by Bidder. | $0.00 | |
| AVERAGE RATE FOR OFFSHORE/NEARSHORE NON-KEY STAFF | Bidder should ensure that average calculation includes any additional rows inserted by Bidder. | $0.00 | |
| Notes: | |||
| Any work authorized under the Contract must utilize the hourly rates listed above, which are binding through the term of the Contract. | |||
| Bidder to determine which Key Staff to propose for Unanticipated Tasks, which may be fewer than for Hypercare & Warranty period. | |||
| Bidder may insert rows to list additional staff, beyond Key Staff, required to perform contracted tasks. | |||
| Totals from this worksheet will be listed on worksheet DL Cost C-1 Totals. |
4-DL-ID Cost C-4 Services
| DMV DXP WS3A - DL/ID Mainframe Services, Data & Integration RFP (ISD26-3629) - Exhibit D - COST WORKBOOK | |||||||||
| Table C-4: Proposed Services Cost | |||||||||
| The Contractor must provide sufficient staffing to achieve project deliverables and milestones and ensure the actual cost for each deliverable does not exceed the quoted cost for each deliverable as shown in Table C-5 of this Cost Workbook. Hourly rates are listed here for the purposes of developing future Work Orders. | |||||||||
| 1 | 2a | 2b | 3 | 4 | 5 | 6 | 7 | 9 | |
| Consultant Role | Proposed | ||||||||
| Consultant Name | This staff is shown in Attachment 17.1? | ||||||||
| (Yes/No) | Hourly Rate |
for Services (from tab DL-ID Cost C-3) Expected Annual Hours for Services
| FY 2026-27 | Expected Annual Hours for Services |
| FY 2027-28 | Expected Annual Hours for Services |
| FY 2028-29 | Expected Annual Hours for Services |
| FY 2029-30 | Total Cost |
per Staff
| (3*(4+5+6+7)) | Total FY 2026-27 | Total FY 2027-28 | Total FY 2028-29 | Total FY 2029-30 | |||||||||
| 1) Billable Hourly Rate for Project Manager (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 2) Billable Hourly Rate for Senior Information Architect/Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 3) Billable Hourly Rate for Data Conversion Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 4) Billable Hourly Rate for Senior Data Architect/DBA (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 5) Billable Hourly Rate for ETL Developer (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 6) Billable Hourly Rate for Salesforce Developer (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 7) Billable Hourly Rate for Senior Salesforce Developer (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 8) Billable Hourly Rate for Mulesoft Developer (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 9) Billable Hourly Rate for Senior Integration Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 10) Billable Hourly Rate for Data Analyst (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 11) Billable Hourly Rate for Business Analyst (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 12) Billable Hourly Rate for Senior Program Manager/Engagement Director (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 13) Billable Hourly Rate for Senior Solution Architect/Chief Architect (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 14) Billable Hourly Rate for Legacy/Mainframe Modernization Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 15) Billable Hourly Rate for Security Lead/Contractor Security Manager (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 16) Billable Hourly Rate for Release and Cutover Manager/Transition Manager (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 17) Billable Hourly Rate for Quality Assurance and Test Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 18) Billable Hourly Rate for Data Quality and Reconciliation Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 19) Billable Hourly Rate for Training and Knowledge Transfer Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 20) Billable Hourly Rate for OCM Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 21) Billable Hourly Rate for Scrum Master (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 22) Billable Hourly Rate for Test Automation Engineer (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 23) Billable Hourly Rate for Test Analyst/Tester (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 24) Billable Hourly Rate for Technical Writer/Documentation Lead (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 25) Billable Hourly Rate for Rules Engine Developer (Key Staff) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 26) Billable Hourly Rate for Other Non-Key Staff (List Role) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| (Insert additional rows as needed) | $0.00 | 0.0 | 0.0 | 0.0 | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 27) Total Hours per Period | 0.0 | 0.0 | 0.0 | 0.0 | |||||||||
| 28) Total Staff Cost for all Contract Years | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| Notes: | |||||||||||||
| Authorization for tasks shall be initiated via the Work Authorization process, utilizing the Staff Rates listed above, which are binding through the term of each contract. | |||||||||||||
| Bidder to determine which Key Staff to propose for the final Hypercare and Warranty period, which may be fewer than for Years 2 and 3. | |||||||||||||
| Bidder may insert rows to list additional staff, beyond Key Staff, required to perform contracted tasks. | |||||||||||||
| Totals from this worksheet will be reported on worksheet DL Cost C-1 Totals. |
5-DL-ID Cost C-5 Deliverables
| DMV DXP WS3A - DL/ID Mainframe Services, Data & Integration RFP (ISD26-3629) - Exhibit D - COST WORKBOOK |
| Table C-5: Proposed Deliverables Cost |
| The Bidder will enter data only in the white cells, gray shaded cells are auto-calculated. The Bidder must specify the number of hours each proposed Key Staff classification and Non-Key Staff classification will work on a particular deliverable. |
Enter the Hours for Staff by classification; for Key Staff, the Workbook will refer to Tab 5-DL-ID Cost C-4 to multiply the number of hours by the specified rate to calculate the Cost.
For Non-Key Staff, enter the role/classification, hours, and cost per deliverable. The Workbook will sum all staff Cost columns to populate Column 3 Deliverable Cost; if Non-Key Staff Costs have been shown for a deliverable, ensure the calculated amount in Column 3 correctly reflects the cost of all Non-Key Staff.
Indicate the Fiscal Year the deliverable cost is incurred by entering the value of column 3 in either column 6, 7, 8, or 9.
Indicate the total hours worked for Key Staff in space 10 and total hours worked for Non-Key Staff in space 11. Calculate the % of total hours worked for Key Staff in space 12 and the % of total hours worked for Non-Key Staff in space 13.
This information will be used for negotiation.
| 1 | 2a | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||
| Deliverable Name | Maximum Amount | DMV total cost % maximum | Percentage of Overall | |||||||||
| Contract Value | Deliverable Cost | Holdback - 15% | ||||||||||
| Prior to Final Feature Acceptance | Amount Available to Invoice | |||||||||||
| Prior to Final Feature Acceptance | Cost Incurred FY 2026-27 | Cost Incurred FY 2027-28 | Cost Incurred FY 2028-29 | Cost Incurred FY 2029-30 | Key Staff Assignments to Deliverable | Non-Key Staff Assignments to Deliverable |
(no more than 75% of hours can be allocated to Non-Key Staff)
| PROJECT TOTAL | $ 35,500,000.00 | Project Manager | Sr. Info Architect / Performance Lead | Data Architect / DBA | Data Conversion Lead | ETL Developer | Sr. Salesforce Developer | Salesforce Developer | MuleSoft Developer | Sr. Integration Lead | Data Analyst | Business Analyst | SR PgM MGR/Eng Dir | SR SA/Chief Architect | Mainframe Mod Lead | Security Lead/Mgr | Release/Cutover Mgr | QA/Test Lead | DQ Reconciliation Lead | Training/KT Lead | OCM Lead | ||||||||||||||||||||||||||||
| DEL-1 to DEL-8: Project Management Plan and Sub-Plans | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | ||||||||||
| 1. Project Management Plan - DEL-01 | $ 1,420,000.00 | 4% | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||
| 2. System Security Sub-Plan - DEL-02 | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 3. DevSecOps Sub-Plan - DEL-03 | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 4. Quality, Testing and Production Release Sub-Plan - DEL-04 | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 5. End-User Training Sub-Plan - DEL-05-A | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 6. Technical Knowledge Transfer Sub-Plan - DEL-05-B | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 7. Organizational Change Management Coordination Sub-Plan - DEL-06 | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 8. Transition Exit and Interaction from Contractor to DMV Sub-Plan - DEL-07 | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 9. Transition Entry and Interaction and Hypercare Delivery Sub-Plan - DEL-08 | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-09-A: Project Schedule | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-09-B: Hypercare and Warranty Period Project Schedule | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-10: Solution Architecture Document | $ 7,100,000.00 | 20% | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||
| DEL-11: Solutions & Services Design Document | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-12: Conversion, Integration, and Implementation Approach | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-13: Data Cleansing, Conversion and Implementation | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1. Data Cleansing, Conversion, and Migration Plan - DEL-13-A | $ 24,850,000.00 | 70% | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||
| 2. Data Auditing & Cleansing Report (all phases) - DEL-13-B | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 3. Data Migration Report (all phases) - DEL-13-C | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 4. User Quality Assurance Testing Report (all phases) - DEL-13-D | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-14: Back-End Reengineering Phased Solution Delivery | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-15: Integrations Phased Solution Delivery | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-16: Training Coordination and OCM Coordination | $ 1,065,000.00 | 3% | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||
| DEL-17: Pre-Production Readiness Assessment | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| DEL-18: Transition Exit and Interaction Delivery | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||
| SUBTOTAL - Costs for all Deliverables above | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||
| DEL-19: Monthly Hypercare and Warranty Service Reports | $ 1,065,000.00 | 3% | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||
| DEL-20: Technology Recovery Simulation Plan and Execution | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| SUBTOTAL - Costs for Deliverables 19 & 20 | $0.00 | N/A | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | |||||||
| Total Deliverable Cost | 100% | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||||||
| 10 | Total Hours for Key Staff | ||||||||||||||||||||||||||||||||||||||||||||||||
| 11 | Total Hours for Non-Key Staff | ||||||||||||||||||||||||||||||||||||||||||||||||
| 12 | % of Hours for Key Staff | ||||||||||||||||||||||||||||||||||||||||||||||||
| Notes: | 13 | % of Hours for Non-Key Staff | |||||||||||||||||||||||||||||||||||||||||||||||
| Authorization for tasks shall be initiated via the Work Authorization process, utilizing the Staff Rates listed in this Cost Workbook, which are binding through the term of the Contract. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Information from this worksheet will be used during DMV's review of the Bidder's ATTACHMENT 17.1: KEY STAFF QUALIFICATIONS MATRIX | |||||||||||||||||||||||||||||||||||||||||||||||||
| No holdback applies for deliverables DEL-17 and DEL-18. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Totals from this worksheet will NOT be listed on worksheet DL Cost C-1 Totals. Deliverable costs are provided on worksheet DL Cost C-4. |
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 .