Attachment_B_ROM_Workbook.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- OPTOMETRY SERVICES - PR269002
- Solicitation number
- 0000038947
- Issued by
- California
About this file
This is a Rate of Market (ROM) Workbook template for RFI 25-IC0054, designed for contractors submitting proposals to provide optometry services to Porterville Developmental Center (PDC) in California. The contract term runs from July 1, 2026 through June 30, 2029, with an optional extension year available. The workbook is structured to accommodate a two-year base contract period plus project closeout, allowing contractors flexibility in phasing, methodology, and creative approaches to service delivery. Bidders must be licensed optometrists with a minimum of five years of experience working in state hospitals, developmental centers, or prison settings, and must demonstrate cognizance of the special needs of developmentally disabled individuals. All licenses must be included with bid documents.
The ROM Workbook contains three primary cost sections: Implementation (with 25 milestone rows for phasing flexibility), Support/Licensing/Hosting (itemized by service year), and Resources (with 23 predefined staff roles including senior executives, project managers, technical architects, programmers, and quality assurance personnel). Contractors are instructed to modify roles and billable hours as needed while maintaining all other equation variables, with an assumed baseline of 1,800 billable hours annually (ranging from 1,600-1,900 hours). All costs must be itemized by month and year, with summary totals calculated for each cost category. The workbook provides a standardized format ensuring consistent bid evaluation across all proposals submitted for this optometry services contract.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Exhibit_D_IFB.pdf | ||
| Optometry_IFB.pdf | ||
| PM423.pdf | ||
| EXHIBIT_B_IFB.pdf | ||
| HIPAA_Business_Associate_Assurances_FINAL_2017_IFB.pdf | ||
| Scope_Of_Work_IFB.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
| Summary |
| No inputs for this tab. |
| Implementation |
| 25 milestone rows were added to allow space for phasing and methodology and creativitiy. Delete rows and columns as needed depending on your approach and timeline. Please do not exceed 2 base contract years (including project close out). |
| Support, Licensing, & Hosting |
| Itemize the costs for each service year including the optional service year. Insert rows as applicable. |
| Resources |
| Change or delete roles as needed. In column I, only change the billable hours in a year for your company as needed and make a note of it on that tab. Other than the billable hours, please do not change any other variables of the column I equation. |
&"Arial,Regular"&10RFI 25-IC0054 &"-,Bold"ATTACHMENT B ROM WORKBOOK
Summary
| Company: | |||
| Year 1 | Year 2 | Optional |
Year
| Implementation | $ - 0 | $ - 0 | N/A | $ - 0 |
| Support Licensing & Hosting | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Resources | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Project Cost Estimate | $ - 0 |
&"Arial,Regular"&10RFI 26-25-IC0054 &"Arial,Bold"&10ATTACHMENT B ROM WORKBOOK
Implementation
| # | Milestones by Phase & Approach | Year 1 | Year 2 | Total | ||||||||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |||
| 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 8 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 9 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 11 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 12 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 13 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 14 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 15 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 16 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 17 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 18 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 19 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 20 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 21 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 22 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 23 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 24 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 25 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Cost by Month | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - 0 | |
| Total | $ - 0 |
&"Arial,Regular"&10RFI 25-IC0054 &"Arial,Bold"&10ATTACHMENT B ROM WORKBOOK
Support, Licensing, & Hosting
| Support, Licensing, & Hosting | Base Contract Term | Optional Extension Year | |
| Service Year 1 | Service Year 2 | Service Year 3 | |
| Contractor Annual Hosting | $ - 0 | $ - 0 | $ - 0 |
| Annual Software Licensing | $ - 0 | $ - 0 | $ - 0 |
| Annual Software Support & Maintenance | $ - 0 | $ - 0 | $ - 0 |
| Support System / Help Desk | $ - 0 | $ - 0 | $ - 0 |
| Reporting | $ - 0 | $ - 0 | $ - 0 |
| Other cost if applicable - (Insert Item Description): | $ - 0 | $ - 0 | $ - 0 |
| Yearly Totals | $ - 0 | $ - 0 | $ - 0 |
| Total | $ - 0 | ||
| Note: Insert additional rows in the table above to account for any items not covered. |
&"Arial,Regular"&10RFI 25-IC0054 &"Arial,Bold"&10ATTACHMENT B ROM WORKBOOK
Resources
| Year 1 | Year 2 | Optional Year | ||||||||||
| Role | Qty | Hrly | ||||||||||
| Rate | % Allocated | Cost | % Allocated | Cost | % Allocated | Cost | ||||||
| Senior Executive | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Program Manager /Unit Lead | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Technical Architect / SME | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Project Manager | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Operations Lead Manager | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Functional Lead / Manager | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Process Change Analyst | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Training Lead/Manager | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Training Delivery Consultant | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Business Analyst | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Strategic Sourcing Analyst | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Conversion Specialist | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Technical Architect | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Programmer/Developer | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Jr Programmer/Developer | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Security Specialist | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Security Administrator | $ - 0 | $ - 0 | $ - 0 | |||||||||
| System Analyst | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Performance Expert | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Quality Assurance Manager | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Technical Writer | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Test Lead/Manager | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Tester | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Other Category (Specify) | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Year 1 | $ - 0 | Year 2 | $ - 0 | Optional | $ - 0 | |||||||
| Total | $ - 0 | |||||||||||
| Notes: The average billable amount of hours is 1,600-1,900 per year therefore 1,800 was assumed. Adjust the billable hours as needed and document your changes in this cell. The roles listed are common IT resource types, not all are required therefore delete or change as needed. |
&"Arial,Regular"&10RFI 25-IC0054 &"Arial,Bold"&10ATTACHMENT B ROM WORKBOOK
File details come from the government source that posted it. Updated .