Staffing_Matrix_Worksheet.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Utility Billing Software Replacement Phase 2
- Solicitation number
- RFP-605021-25/LTT
- Issued by
- Seminole County, Florida
About this file
The provided file is a Staffing Matrix Worksheet associated with the Seminole County Utilities Division's Customer Information and Billing System (CIS) Replacement Phase 2 project. The document presents a detailed staffing plan template for both vendor and utility project teams across a 21-month implementation timeline, covering critical project phases including initiation, planning, discovery, configuration, testing, training, cutover, and post-go-live support. The matrix includes roles such as Project Managers, Executive Sponsors, Application Consultants, Technical Leads, SME Leads, Testers, and Training personnel, with each role allocated flexible full-time equivalent (FTE) percentages throughout the project lifecycle.
The staffing worksheet serves as an example template for vendors to demonstrate their proposed resource allocation and commitment levels across different project stages. While the specific percentages are placeholder "FTE%" markers, the document suggests a comprehensive approach to project staffing that encompasses project management, consulting, technical, and training teams. The matrix allows for flexible staffing needs across multiple domains including customer service, collections, billing, meters, testing, and technical integration, reflecting the complex nature of the utility billing software replacement project. The template indicates the county's expectation of a detailed, structured approach to human resource planning that aligns with the project's technical and operational requirements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Utility_Billing_Software_Replacement_Phase_2_(Addendum_#1_Revision).pdf | ||
| Proposal_Response_REV_8.19.pdf | ||
| Utility_Billing_Software_Replacement_Phase_2.pdf | ||
| Draft_Term_Contract.pdf | ||
| Insurance_Requirements.pdf | ||
| Interface_Experience_Worksheet.xlsx | XLSX spreadsheet | |
| Technical_Requirements_Worksheet.xlsx | XLSX spreadsheet | |
| Functional_Requirements_Worksheet.xlsx | XLSX spreadsheet | |
| Staffing_Matrix_Worksheet.xlsx | XLSX spreadsheet | |
| Pricing_Worksheet.xlsx | XLSX spreadsheet | |
| Proposal_Response.pdf | ||
| Sample_Purchase_Order.pdf |
Show all 12
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
Vendor Staffing
VENDOR STAFFING PLAN - EXAMPLE
Proposing vendor is to provide a similar staffing plan that provides the same level of detail, at a minimum:
| EXAMPLE TIMELINE - ALTER AS NEEDED | |||||||||||||||||||||
| CIS Implementation | Initiation & Planning | Discovery | Configuration | Functional & Integration Testing | User Acceptance Testing | End-User Training | Cutover Prep & Go-Live | Post Go-Live Support & Stabilization | |||||||||||||
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| Project Management Team | |||||||||||||||||||||
| Project Manager - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Executive Sponsor - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Consultant Team | |||||||||||||||||||||
| Lead Application Consultant - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Supporting Application Consultant 1 - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Supporting Application Consultant 2 - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Technical Lead - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Conversion Lead - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| DBA/Installer - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Reporting Lead - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Bill Print Lead - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Other - As Needed | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Other - As Needed | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Other - As Needed | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Training Team | |||||||||||||||||||||
| Lead Trainer - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Supporting Trainer - (Name of resource) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| TOTAL PROJECT MANAGEMENT FTE | 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.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| TOTAL CONSULTANT FTE | 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.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| TOTAL TRAINING FTE | 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.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
TOTAL VENDOR COMMITTED FTE 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
&F
&A &P &D
Utility Staffing
UTILITY STAFFING NEEDS - EXAMPLE
Please provide your company's suggested staffing level for the utility project team
| EXAMPLE TIMELINE - ALTER AS NEEDED | |||||||||||||||||||||
| CIS Implementation | Initiation & Planning | Discovery | Configuration | Functional & Integration Testing | User Acceptance Testing | End-User Training | Cutover Prep & Go-Live | Post Go-Live Support & Stabilization | |||||||||||||
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| Project Leadership Team | |||||||||||||||||||||
| Project Manager | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Executive Sponsor | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Utility Core Team | |||||||||||||||||||||
| SME Lead (Customer Service) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| SME Lead (Collections) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| SME Lead (Billing) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| SME Lead (Meters) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| SME Lead (Others, as needed) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Testing Lead | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Tester (Customer Service) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Tester (Collections) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Tester (Billing) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Tester (Meters) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Tester (Others, as needed) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Training Lead | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Others, as needed (e.g. Change Management) | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Technical Team | |||||||||||||||||||||
| Data Conversion Lead | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Integration Lead | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| Others, as needed | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% | FTE% |
| TOTAL PROJECT LEADERSHIP FTE | 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.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| TOTAL CORE TEAM FTE | 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.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| TOTAL TECHNICAL TEAM FTE | 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.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
TOTAL UTILITY PROJECT TEAM FTE 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
&F
&A &P &D
File details come from the government source that posted it. Updated .