Attachment #7 - Resource Usage Template.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- IDR Mail Modernization
- Solicitation number
- RFP-185-2525-2026
- Issued by
- Polk County, Des Moines City, Iowa
About this file
This is a Resource Usage Template worksheet for RFP-185-2525-2026 issued by the State of Iowa Department of Management on behalf of the Iowa Department of Revenue for an incoming mailroom modernization system. The template requires respondents to complete two primary sections: a Team Resourcing Worksheet and a Role Description Worksheet. The Team Resourcing Worksheet mandates that bidders identify all project roles, specify years of relevant experience required, and estimate the number of resources needed for each role across defined project stages including Project Initiation and Management, Requirements Analysis and System Design, System Development and Configuration, Data Conversion and Migration, Testing, User Acceptance Testing, Operational Readiness Testing, User Training, Go-Live Planning and Execution, and DDI Closeout. Respondents must separately estimate hours for both Supplier/Subcontractor and State of Iowa resources, with the template automatically calculating total hours, percentage of total project hours, and total resource counts. The Role Description Worksheet requires bidders to provide consolidated lists of all proposed roles with detailed descriptions of responsibilities and specific training and knowledge requirements for each role.
The template provides no explicit pricing information, set-asides, incumbent vendor details, or funding amounts. All cells in the provided template contain zero values and placeholder text, indicating this is the blank form distributed to potential bidders for completion. A threaded comment references vendor and subcontractor hourly allocation guidance contained in the RFP document itself. Maintenance and operational hours are explicitly noted as out of scope for this submission. The template is designed to ensure consistent, comparable resource planning proposals across all responding vendors for evaluation purposes.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1367890-event.pdf | ||
| RFP-185-2525-2026_Attachment #6 Requirements Traceability Matrix.xlsx | XLSX spreadsheet | |
| Attachment #8 - Exceptions Template.docx | DOCX document | |
| RFP-185-2525-2026_Attachment #4 - Cost Proposal Workbook.xlsx | XLSX spreadsheet | |
| Attachment #1 - Respondent Information Form (2).docx | DOCX document | |
| Attachment #5 - Sample Contract.docx | DOCX document | |
| Attachment #2 - Subcontractor Disclosure Form.docx | DOCX document | |
| RFP-185-2525-2026 IDR Incoming Mail Modernization.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-185-2525-2026: IDR Mail Modernization |
| Attachment 7: 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 RESPONDENT: [ENTER RESPONDENT NAME HERE]
Supplier / Subcontractor tc={BD44787F-5715-44AC-9FD0-89CE670FBF0B}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
See my comment in the RFP document re: vendor/subcontractor hourly allocation.
| PROJECT RESOURCING | PROJECT HOURS | ||||||||||||||
| Role | Years of Relevant Experience | # of Resources | Project Initiation, Management, OCM | Requirements Analysis & system Design | System Development & Configuration | Data Conversion & Migration | Testing | User Acceptance Testing (UAT) | Operational Readiness Testing (ORT) | User Training | Go-Live Planning & Execution | DDI Closeout | Other Project Services | ||
| (use "Comments") | 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 | 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 | Project Initiation, Management, OCM | Requirements Analysis & system Design | System Development & Configuration | Data Conversion & Migration | Testing | User Acceptance Testing (UAT) | Operational Readiness Testing (ORT) | User Training | Go-Live Planning & Execution | DDI Closeout | Other Project Services | ||
| (use "Comments") | 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 | 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 | 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.] |
See my comment in the RFP document re: vendor/subcontractor hourly allocation.
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 .