ESBD_378620_1728492283604_RFI 507-25-001 Attachment A - Pricing Estimate Workbook.xlsx
XLSX spreadsheet 63 KB Posted
- Solicitation number
- 507-25-001
- Issued by
- Texas
About this file
This document is an Attachment A. Pricing Workbook for a Request for Information (RFI) issued by the Texas Board of Nurses (BON) for the Texas Real Estate Commission (TREC) and the Texas Appraiser Licensing and Certification Board (TALCB) Regulatory Applications Modernization Project (RAMP). The RFI seeks pricing information for three key modernization efforts: Enforcement System Modernization (ESM), Education Program System Modernization (EPSM), and Website Modernization (WM). The pricing workbook outlines instructions for respondents to provide one-time implementation costs, ongoing software costs for a 5-year period, and labor rates for personnel supporting the project. Respondents are asked to provide detailed pricing for specific deliverables within each modernization area, as well as to document any key assumptions underlying their pricing. The completed pricing workbook is to be submitted as a separate attachment to the RFI response.
The pricing workbook requires respondents to provide total one-time and ongoing costs, broken down by implementation services and ongoing software costs. Respondents are also asked to provide labor rates for various staff positions that may be assigned to the project. The workbook includes a section for respondents to document any key assumptions used in developing their pricing. This information will assist BON in planning the scope and budget for future modernization efforts.
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
Title Page
| Texas Board of Nurses (BON) |
| Information Technology Modernization |
| Attachment A. Pricing Workbook |
ToC
| Attachment A. Pricing Workbook | |
| Table of Contents | |
| Respondent | [Insert Respondent Name] |
| Worksheet Title / Hyperlink | Description |
| Instructions | Instructions for completing Pricing Workbook. |
| 1. Total Cost Summary | Worksheet to display a summary of the total proposed costs. THIS WILL AUTOPOPULATE FROM OTHER TABS. No changes needed. |
| 2. Labor Rates | Worksheet for itemizing hourly rate structures for proposed project personnel. |
| 3. Implementation Services | Worksheet for one-time implementation project costs. |
| 4. Ongoing Software Costs | Worksheet for ongoing costs on an annual basis |
| 5. Cost Assumptions | Worksheet for Respondent to itemize all assumptions upon which its pricing is dependent. |
TREC & TALCB
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499 Attachment F. Pricing Workbook
&P
Insert Respondent Name here
PLEASE NOTE:
1. The Respondent Name in the space provided in light-green highlight will populate across all other worksheets.
2. Cells requiring Respondent / Option data entry are marked in light-green highlight to clearly indicate which cells are available for data entry as indicated above left.
3. Cells that contain titles and formulas are marked in gray highlight.
4. Cells that are not applicable are marked in black highlight.
5. It is the Respondent's responsibility to ensure the integrity of the Pricing Workbook formulas and links.
Instructions
| Attachment A. Pricing Workbook |
| Instructions |
| [Insert Respondent Name] |
| BON appreciates Respondents providing pricing related to the scope identified in the RFI. Below are some instructions to assist in completing this Pricing Estimate Workbook. | |
| 1. | Each worksheet within the workbook is designed to elicit specific pricing information related to elements of the RFI. Respondents are encouraged to use the Cost Assumptions tab to provide any information it deems relevant to BON to help with planning regarding scope and associated pricing of the future projects. Notes on completing each worksheet can be found to the right of each table in the subsequent tabs. The spreadsheet is unlocked and Respondents may make adjustments to the pricing workbook as it deems necessary to help ensure accuracy. |
| 2. | The worksheet labeled TOC (Table of Contents) - previous tab - contains brief descriptions of each spreadsheet, as well as convenient one-click navigation of the Pricing Workbook. Respondents must enter the Respondent Name on that tab; this will populate the title of the remaining worksheets. The numbered worksheets are described below: |
| 3. | The Total Cost Summary worksheet calculates total costs based on the data entered into worksheets Tab 3 and 4. Respondents do not need to enter data into this worksheet. Costs for deliverables listed in Tab 3 are shown as one-time costs totaled by deliverable grouping and are not calculated by year. If you typically produce a deliverable more than one time, simply list that deliverable again. |
| 4. | The Labor Rates worksheet lists the titles of personnel that could be assigned responsibilities in completing the implementation of requested modernization projects. This information helps BON understand information regarding the market as well as the potential role(s) Respondents typically use to staff these types of engagements. As much detial as Respondents can provide is appreciated (e.g., role name, role names with levels of seniority, associated labor rates). |
| 5. | The Implementation Services worksheet provides a table where Respondents can indicate deliverables typically provided by Respondents when delivering these services. This information will help BON in planning the scope of future RFOs. The Respondent will enter the typical cost of each deliverablefor projects similar in size and complexity as described in the RFI in that deliverable row. |
Respondents may add additional rows as deemed necessary by inserting rows into the worksheet at the bottom of the list currently in each table. In this case, the associated formulas must be copied into column D for that deliverable.
Though BON prefers individual Deliverables-based pricing, Respondents are welcome to provide one lump-sum representation of their implementation services for a particular project.
| 6. | The Ongoing Software Costs worksheet is designed to elicit the pricing of ongoing costs for any licensing, hosting, maintenance, support and operations services for the first five years of production associated with a SaaS solution (e.g., post-Go-Live costs). Respondents may indicate pricing by each line item or a lump sum for 5 years of ongoing costs (although line item pricing is preferred). Cost Assumptions should document Respondent's approach to pricing. |
| 7. | In the Cost Assumptions worksheet, the Respondent is requested to state all assumptions upon which its pricing is being determined. Insert as many lines as necessary to ensure all assumptions are accurately expressed. The Respondent should provide details pertaining to the assumptions, expectations, and/or performance parameters that have been used as the basis for the pricing. For example, "implementation services for ESM are based on an estimate of a one year implementation period." This information will be highly valuable for planning purposes. |
| 8. | Additional notes and instructions may be provided at the top right of the worksheet tab. Please review. |
This Pricing Workbook shall be completed and be provided as a separate attachment in the Respondent's RFI Response.
TREC & TALCB
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499 Attachment F. Pricing Workbook
&P
1. Total Cost Summary
| Attachment A. Pricing Workbook | THESE CELLS WILL AUTOPOPULATE - DO NOT MAKE CHANGES |
| Total Cost Summary | |
| [Insert Respondent Name] |
| Total Cost Summary: | |
| Description | Total |
One-time Costs
| Implementation Services | $0.00 |
| Ongoing Software Costs (5 Years) | $0.00 |
| Subtotal | $0.00 |
TREC & TALCB
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499
&P
2. Labor Rates
| Attachment A. Pricing Workbook | ||
| Labor Rates | Instructions | |
| [Insert Respondent Name] | 1 | Please list the staff positions that are anticipated to support this effort (e.g., project manager, technical lead, data conversion lead, business analyst, trainer). Duplicate rows when you anticipate multiple staff in the same position. |
Staff Position Hourly Rate (Optional) Respondent or Subcontractor Name
Composite Rate
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499
&P
3. Implementation Services
| Attachment A. Pricing Workbook |
| Implementation Services |
| [Insert Respondent Name] |
| Implementation | Instructions | ||||
| 1 | BON prefers deliverable-based pricing, but is amenable to lump sum representation of respondent's implementation services. (Ex. Project Management, Design, Configuration, Testing, Integration, Customization, Training, Change Management, Technical Support) | ||||
| ID | Scope (ESM, EPSM, WM) | Deliverable Description | Total |
One-time
| Costs | 2 | If the Respondent is proposing multiple iterations of the solution to be implemented, then there will be multiple versions of the relevant deliverables. | ||||
| 1 | $0 | 3 | Please indicate the deliverables by project in Column B: |
Enforcement System Modernization (ESM): Update the enforcement database to a modern cloud-based platform with case management functionality and interoperability with the Texas Nurse Portal.
Education Program System Modernization (EPSM): Digitize programs using a cloud-based platform to streamline application processes for external customers, provide status updates, and organize the process.
Website Modernization (WM): Redesign BON website to enhance the user experience and strengthen defenses against cybersecurity.
| 2 | $0 | |
| 3 | $0 | |
| 4 | $0 | |
| 5 | $0 | |
| 6 | $0 | |
| 7 | $0 | |
| 8 | $0 | |
| 9 | $0 | |
| 10 | $0 | |
| 11 | $0 | |
| 12 | $0 | |
| 13 | $0 | |
| 14 | $0 | |
| 15 | $0 | |
| 16 | $0 | |
| 17 | $0 | |
| 18 | $0 | |
| 19 | $0 | |
| 20 | $0 | |
| 21 | $0 | |
| 22 | $0 | |
| 23 | $0 | |
| 24 | $0 | |
| 25 | $0 | |
| 26 | $0 | |
| 27 | $0 | |
| 28 | $0 | |
| 29 | $0 | |
| 30 | $0 | |
| Total Deliverables Cost | $0 |
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499
&P
4. Ongoing Software Costs
| Attachment A. Pricing Workbook | Instructions | |
| [Insert Respondent Name] | 1 | Respondent should include any annual/ ongoing costs such as licensing costs, support and maintenance costs, hosting, etc in Column D "Unit Price". |
| 2 | If you typically charge % uplift YoY please indicate that in the Cost Assumption tab | |
| Annual/Ongoing Costs | 3 | Please indicate which project costs are associated with in Column B, similar to the previous tab |
| ID | Scope (ESM, EPSM, WM) | Ongoing Cost Description (e.g., hosting, maintenance) | Unit Price | Price |
| 1 | $0 | |||
| 2 | $0 | |||
| 3 | $0 | |||
| 4 | $0 | |||
| 5 | $0 | |||
| Other (specify) - insert rows as needed | $0 | |||
| System Cost Subtotal | $0 |
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499
&P
5. Cost Assumptions
| Attachment A. Pricing Workbook | ||||
| Cost Assumptions | ||||
| [Insert Respondent Name] | ||||
| Item # | RFI Section or Attachment A location, Page, Paragraph | Description | Rationale | Other Comments |
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 | ||||
| 13 | ||||
| 14 | ||||
| 15 | ||||
| 16 | ||||
| 17 | ||||
| 18 | ||||
| 19 | ||||
| 20 | ||||
| Notes | ||||
| 1 | Insert as many lines as necessary to ensure all assumptions are accurately expressed. |
Regulatory Applications Modernization Project (RAMP) RFO No. 329-22-0499
&P
File details come from the government source that posted it. Updated .