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 Staffing_Matrix_Worksheet.xlsx is a detailed staffing plan document for the Seminole County Utilities Division's Customer Information and Billing System (CIS) replacement project in Florida. The document provides a comprehensive 21-month project timeline with proposed staffing allocations for both vendor and utility team resources across multiple implementation phases, including initiation and planning, discovery, configuration, functional and integration testing, user acceptance testing, end-user training, cutover preparation, go-live, and post go-live support and stabilization.
The staffing matrix outlines two primary staffing categories: Vendor Staffing and Utility Staffing, each with distinct team compositions. The vendor team includes project management, consultant, and training teams with roles such as Project Manager, Executive Sponsor, Application Consultants, Technical Lead, Conversion Lead, and Trainers. The utility team includes project leadership, core team, and technical team members like Subject Matter Experts (SMEs) for Customer Service, Collections, Billing, Meters, Testing Leads, Testers, and Integration Leads. While specific resource names are placeholders, the document serves as a template for detailing full-time equivalent (FTE) percentages for each team member throughout the project lifecycle, demonstrating a structured approach to resource allocation and project management.
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 | |
| Pricing_Worksheet.xlsx | XLSX spreadsheet | |
| Proposal_Response.pdf | ||
| Sample_Purchase_Order.pdf |
Show all 11
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 .