Attachment #3 - Resource Usage.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- DOC Offender Management System
- Solicitation number
- RFP-532-2530-2027
- Issued by
- Polk County, Des Moines City, Iowa
About this file
This is a Resource Usage attachment worksheet for the Iowa Department of Corrections' Offender Management System (OMS) Request for Proposal. The document serves as a template for vendors to detail their proposed staffing and resource allocation across the implementation lifecycle. Vendors must complete yellow-shaded cells to identify project roles, years of required relevant experience, number of resources needed, and estimated hours by project phase. The project phases include Phase 1 (Project Initiation and Project Management), Phase 2 (System Implementation), Phase 3 (Go-Live), and Security Operations and Maintenance. Vendors must provide separate resource projections for both their own personnel and recommended State of Iowa staffing. The worksheet automatically calculates total hours, percentage of total project hours, and total resource counts for both supplier/subcontractor and State resources. Additionally, vendors must complete a Role Description worksheet providing consolidated role listings and detailed responsibility descriptions for each proposed position, including specific training and knowledge requirements.
The Resource Usage worksheet requires vendors to develop a comprehensive Resource Management Plan describing how supplier/subcontractor and State resources will be coordinated throughout the project lifecycle, with context provided based on estimated hours. The document explicitly excludes Maintenance and Operational hours from the scope of this submission, as those will be addressed separately in the broader OMS procurement. The template accommodates up to 30 distinct roles and includes space for vendors to describe any additional project services beyond the four primary phases. Years of relevant experience entered for State of Iowa roles are provided as guidance only and do not constitute formal requirements, but rather establish expectations for experience and expertise needed for successful solution delivery.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment #4.2 - Iowa Integrated Justice Bus.pdf | ||
| Attachment #2 - Subcontractor Disclosure Form.docx | DOCX document | |
| Attachment #1 - Vendor Information Form.docx | DOCX document | |
| Attachment #6 - Sample Contract.docx | DOCX document | |
| RFP 532-2530-2027 DOC OMS.pdf | ||
| Appendix 1 - Iowa DOC OMS RFP V1.docx | DOCX document | |
| Attachment #4.1- Interfaces.xlsx | XLSX spreadsheet | |
| Attachment #5 - Service Level Agreement.docx | DOCX document | |
| 1410023-event.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
| RFP#####: Offender Management System |
| Attachment 3: Resource Usage |
| Team Resourcing Worksheet |
| I. Complete only the yellow shaded cells for the following categories for both "Supplier / Subcontractor" & "State of Iowa" sections within the table. |
NOTE: Maintenance and Operational hours are NOT in scope of this request.
• "Project Resourcing" Category:
o List each role expected for project related activities and stabilization support under the “Role” column o List the number of years of relevant expeience required for each role under the “Years of Relevant Experience” column
- NOTE: For the "State of Iowa" section, enter the number of years of relevant experience that you recommend for each State of Iowa role identified. The years of relevant experience entered will not be considered a requirement for the State of Iowa, but will provide a level of guidance to set expectations for the experience and expertise needed to successfully deliver the solution.
o List the estimated number of individuals required for each role under the “# of Resources” column
• "Project Hours" Category:
o List the estimated number of hours required by role for each stage of project work (columns D-P) o If there are other stages of project work not listed within the table:
- List the number of estimated hours required by role under the “Other Project Services” (Column Q)
- BRIEFLY describe the other project work under the “Comments” column to the right of the table
II. Based upon the entries described above, the following fields will AUTOMATICALLY CALCULATE within the table:
• “Total Hours” (for both "Supplier / Subcontractor" & "State of Iowa" sections)
• “% of Total Project Hours” (for both "Supplier / Subcontractor" & "State of Iowa" sections)
• “Total # of Resources” (for both "Supplier / Subcontractor" & "State of Iowa" sections)
• "TOTAL Supplier / Subcontractor Hours"
• "TOTAL State of Iowa Hours"
• "TOTAL PROJECT HOURS"
III. Complete only the yellow shaded cells for the Resource Management Plan comments section:
• Resource Management Plan:
o Describe the Resource Management Plan and how Supplier / Subcontractor and State of Iowa resources will be managed throughout the project o Provide context based on the estimated number of hours indicated in the table
| Role Description Worksheet |
| I. Complete only the yellow shaded cells for the following columns: |
• "Role" Column:
o Provide a consolidated list of each role type under the “Role” column, proposed in the "Team Resourcing" worksheet
• "Role Description" Column:
o Provide a description of the responsibilities for each proposed "Role"
Team Resourcing
Team Resourcing VENDOR: [ENTER VENDOR NAME HERE]
| Supplier / Subcontractor | |||||||||||
| PROJECT RESOURCING | PROJECT HOURS | ||||||||||
| Role | Years of Relevant Experience | # of Resources | Phase 1 - Project Initiation and Project Management | Phase 2 – System Implementation | Phase 3 – Go-Live | Security | Operations and Maintenance (O&M) | Total Hours | % of Total Project Hours | Total # of Resources | Comments |
(Describe "Other Project Services" if applicable)
| 0.00 | 0.00 | 0.00% | 0.00 | [Comments for other work.] | ||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| TOTAL Supplier / Subcontractor Hours | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| State of Iowa | |||||||||||
| PROJECT RESOURCING | PROJECT HOURS | ||||||||||
| Role | Years of Relevant Experience | # of Resources | Phase 1 - Project Initiation and Project Management | Phase 2 – System Implementation | Phase 3 – Go-Live | Security | Operations and Maintenance (O&M) | Total Hours | % of Total Project Hours | Total # of Resources | Comments |
(Describe "Other Project Services" if applicable)
| 0.00 | 0.00 | 0.00% | 0.00 | [Comments for other work.] | ||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| 0.00 | 0.00 | |||||||||
| TOTAL State of Iowa | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL PROJECT HOURS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Below, please describe the Resource Management Plan and how Supplier / Subcontractor and State of Iowa resources will be managed throughout the project. Provide context based on the estimated number of hours indicated in the table above. | ||||||
| [Comments for Resource Management Plan.] |
Role Description
| Role Description | ||
| Role | Role Description | Specific Training and Knowledge for Role |
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] | ||
| [ROLE] |
File details come from the government source that posted it. Updated .