DIR_RFP_17546_Exhibit_D_Cost_Workbook.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 17546
- Issued by
- California
About this file
This is an Exhibit D Cost Workbook for a Request for Proposal (RFP) issued by the California Department of Industrial Relations (DIR), Division of Workers' Compensation (DWC), for the Electronic Adjudication Management System (EAMS) Modernization initiative. The procurement seeks a Commercial Off-The-Shelf (COTS) Workers' Compensation Claims Management System. The cost workbook requires bidders to price deliverables across multiple worksheets covering the two-year base contract period plus one optional extension year. Key deliverables include Project Setup and Solution Planning, Design, Build and Test, Mock Production, Organizational Change Management, and Go-Live. The contract encompasses Claims Solution Licenses for 100 internal users across all three contract years, with Maintenance and Operations (M&O) costs anticipated for Years 2 and 3 only.
Bidders must complete five interconnected worksheets within the cost workbook: Worksheet A requires pricing for six Claims deliverables; Worksheet B specifies annual licensing costs per user for 100 internal users across Years 1-3; Worksheet C captures M&O costs for the Claims solution in Years 2-3; Worksheet D requires hourly rates for key staff positions (Project Manager, Claims Functional Lead) and any support staff necessary to execute the contract; and Worksheet E automatically aggregates all costs to calculate the Total Base Contract Cost and Grand Total Cost for evaluation purposes. The workbook includes a 10% adder for Unanticipated Tasks calculated on the Base Contract Subtotal. All cost cells requiring bidder input are highlighted in yellow, and bidders must enter their company name in designated cells within each worksheet.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| DIR_RFP_17546_Exhibit_J_Current_and_Future_Claims_Interface.xlsx | XLSX spreadsheet | |
| EXHIBIT_B_Functional_Non-functional_Claims_Requirements.xlsx | XLSX spreadsheet | |
| DIR_RFP_17546_EAMS_CLAIMS_F260102.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
Instructions
| EXHIBIT D: COST WORKBOOK | |
| Bidder Name: | |
| Worksheet | Instructions for Completing |
| A. Claims Deliverables | This worksheet lists the required deliverables for the Claims Benefit Administrations system that must be priced and included with the Bidder's Proposal. |
Rows 1-2 contain the headers for the worksheet. Bidder must input their company name in Cell B1.
Column A, Payment Deliverable Number: For reference only. This column lists a payment deliverable number.
Column B, Deliverables: For reference only. This column lists the deliverable name.
Column C, Deliverable Cost: Bidder shall complete this column for all cells highlighted in yellow.
B. Claims Solution Licenses This worksheet shall include all Claims licenses for 100 internal users for the two (2) base contract years with one (1) year optional extension.
Rows 1-4 contain the headers for the worksheet. Bidder must input their company name in Cell B1. Bidder shall complete all cells highlighted in yellow.
C. M&O This worksheet shall include all maintenance and operations costs.
Rows 1-3 contain the headers for this worksheet. Bidder must input their company name in Cell B1.
Column A, Solution: For reference only. This column lists each solution.
Row 5, Claims Deliverable 7 M&O Column C-D: Monthly Cost Years 2-3: For reference only. No M&O costs are anticipated during year 1 of the contract.
Column E: Total Base Contract M&O Costs: For reference only. This column calculates the total costs for the associated M&O costs.
D. Key Staff Hourly Rates This worksheet lists the required key staff roles for this resulting contract. It also includes space for support staff. The Bidder must enter all the support staff necessary to complete the work under this contract and provide an hourly rate for each key staff role and each support staff.
Rows 1-3 contain the headers for the worksheet. Bidder must input their company name in Cell B1.
Column A, Item#: For reference only.
Column B, Title: The listed job titles are the key staff which are required and not to be modified. Bidder shall list the titles of all the support staff as necessary.
Column C, Hourly Rate: This column shall specify the Hourly Rate of each of the Key and Support Staff.
E. Summary This worksheet is not to be modified.
This worksheet aggregates costs from worksheets A through D and automatically calculates the Total Base Contract Cost (including Unanticipated Tasks) as well as the Grand Total Cost (Total Base Contract Cost plus Total Optional Years Cost). Unanticipated Task is 10% of the Base Contract Subtotal. The Grand Total Cost will be used for evaluation purposes.
Colum A, Description: For reference Only. This column describes what worksheet (A through D) each line is referencing.
Column B, Cost: These cells in this column are linked to various Total Cost cells from worksheets A through D.
A. Claims Deliverables
| Bidder's Name: | ||
| Payment Deliverable # | Deliverables | Deliverable Cost |
| 1 | Project Setup and Solution Planning | |
| 2 | Design | |
| 3 | Build and Test | |
| 4 | Mock Production | |
| 5 | Organizational Change Management (OCM) | |
| 6 | Go-Live | |
| Claims Deliverables Subtotal: | $0.00 |
B. Claims Solution Licenses
| Bidder's Name: | |||||||||||
| Claims Solution Licenses | |||||||||||
| Item # | Description | Year 1 | Year 2 | Year 3 Optional | |||||||
| QTY | Annual Cost Per User/License | Total Cost | QTY | Annual Cost Per User/License | Total Cost | QTY | Annual Cost Per User/License | Total Cost | Total Years 1-3 | ||
| 100 internal users | $0.00 | 100 internal users | 100 internal users | $0.00 |
C. M&O Bidder's Name:
| SOLUTION | Year 1 | Monthly Cost | ||
| Year 2 | Monthly Cost Optional Year 3 | Total Base Contract M&O Costs | ||
| Claims M&O | No M&O costs are anticipated during development | |||
| Deliverable 7 Claims M&O | $0.00 |
D. Key Staff Hourly Rates
| Bidder's Name: | ||
| HOURLY RATES | ||
| ITEM # | TITLE | HOURLY RATE |
| 1 | Project Manager | $ - 0 |
| 2 | Claims Functional Lead | $ - 0 |
| 3 | Support Staff Team ** | $ - 0 |
| **Support Staff Team: List the Title and Hourly Rate of each Support Staff Team member. |
E. Summary
| Bidder's Name: | |
| Summary Cost Worksheet | |
| Description | Cost |
| Worksheet A: Claims Deliverables | $ - 0 |
| Worksheet B: Claims Solution Licenses (Years 1-3 for 100 internal user licenses per year) | $ - 0 |
| Worksheet C: M&O (Year 2 and 3 for Claims) | $ - 0 |
| Base Contract Subtotal | $ - 0 |
| Unanticipated Tasks (10% of Base Contract Subtotal) | $ - 0 |
| Total Base Contract Cost (Years 1-3) | $ - 0 |
Grand Total Cost for Evaluation Purposes only $ - 0
File details come from the government source that posted it. Updated .