Resource Usage Template.xlsx
XLSX spreadsheet 53 KB Posted
- Attached to
- Parking Management ServicesBid Documents State and local contract opportunity
- Solicitation number
- 26-86626
- Issued by
- Marion County, Indiana
About this file
This is a Resource Usage Template for the State of Indiana to be used in response to a Request for Proposal (RFP). The template is designed to capture detailed resource planning and allocation for project implementation, requiring respondents to complete worksheets for team resourcing and role descriptions. Respondents must identify all project roles, specify years of relevant experience required for each position, and estimate the number of resources needed across both supplier/subcontractor and State of Indiana staffing categories. The template mandates completion of estimated project hours across multiple project phases including requirements and process mapping, design, application configuration and development, testing, training, data conversion, interfaces, organizational change management and communications, go-live preparation and execution, and production stabilization, with provisions for additional project services as needed.
The template includes automatic calculation functions that compute total hours by role, percentage of total project hours, total resource counts, and consolidated project hour totals across both supplier and state staffing categories. Respondents must provide a Resource Management Plan describing how supplier/subcontractor and State of Indiana resources will be coordinated throughout the project lifecycle, with context tied to estimated hours. The Role Description Worksheet requires detailed descriptions of each proposed role's responsibilities and specific training and knowledge requirements. All yellow-shaded cells must be completed by the respondent, while maintenance and operational hours are explicitly excluded from the scope of this resource planning request.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| RFP Main Document.pdf | ||
| Att I - Pre-proposal Network Form.docx | DOCX document | |
| Att A1 - IVOSB.docx | DOCX document | |
| Att C - Indiana Economic Impact Form.xls | XLS spreadsheet | |
| Exhibit B - Reporting Requirements.pdf | ||
| Att E - Business Proposal.docx | DOCX document | |
| Att A - MWBE.docx | DOCX document | |
| Att D - Cost Proposal.xlsx | XLSX spreadsheet | |
| Att K - Scope of Work.pdf | ||
| Att B2 - IOT-PaaS.docx | DOCX document | |
| Att B1 - IOT-IaaS.docx | DOCX document | |
| Att B3 - IOT-SaaS.docx | DOCX document | |
| Att F - Technical Proposal.docx | DOCX document | |
| Artificial Intelligence - Technical Proposal Questions.docx | DOCX document | |
| Att B - Sample Contract.docx | DOCX document | |
| Att H - Reference Check Form.docx | DOCX document | |
| Infrastructure Overview.docx | DOCX document | |
| Exhibit A - Budgets.pdf | ||
| Att J - Attestation Form.docx | DOCX document | |
| Att G - Q&A Template.xlsx | XLSX spreadsheet |
Show all 20
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| RFP ##-####: [RFP NAME] |
| Attachment [X]: Resource Usage |
| Team Resourcing Worksheet |
| I. Complete only the yellow shaded cells for the following categories for both "Supplier / Subcontractor" & "State of Indiana" 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 Indiana" section, enter the number of years of relevant experience that you recommend for each State of Indiana role identified. The years of relevant experience entered will not be considered a requirement for the State of Indiana, 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 Indiana" sections)
• “% of Total Project Hours” (for both "Supplier / Subcontractor" & "State of Indiana" sections)
• “Total # of Resources” (for both "Supplier / Subcontractor" & "State of Indiana" sections)
• "TOTAL Supplier / Subcontractor Hours"
• "TOTAL State of Indiana 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 Indiana 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 | |||||||||||
| PROJECT RESOURCING | PROJECT HOURS | ||||||||||
| Role | Years of Relevant Experience | # of Resources | Project Management | Requirements | |||||||
| & Process Mapping | Design | Application Configuration | Application Development | Testing | Training | Data Conversion | Interfaces | OCM & Comms | Go-Live Preparation & Execution | Production Stabilization | 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 | 0.00 | 0.00 |
| State of Indiana | |||||||||||
| PROJECT RESOURCING | PROJECT HOURS | ||||||||||
| Role | Years of Relevant Experience | # of Resources | Project Management | Requirements | |||||||
| & Process Mapping | Design | Application Configuration | Application Development | Testing | Training | Data Conversion | Interfaces | OCM & Comms | Go-Live Preparation & Execution | Production Stabilization | 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 Indiana | 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 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 | 0.00 | 0.00 |
| Below, please describe the Resource Management Plan and how Supplier / Subcontractor and State of Indiana 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 .