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 PDF
Proposal_Response_REV_8.19.pdf PDF
Utility_Billing_Software_Replacement_Phase_2.pdf PDF
Draft_Term_Contract.pdf PDF
Insurance_Requirements.pdf 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 PDF
Sample_Purchase_Order.pdf 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 ImplementationInitiation & PlanningDiscoveryConfigurationFunctional & Integration TestingUser Acceptance TestingEnd-User TrainingCutover Prep & Go-LivePost Go-Live Support & Stabilization
Month123456789101112131415161718192021
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 NeededFTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%
Other - As NeededFTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%
Other - As NeededFTE%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 FTE0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
TOTAL CONSULTANT FTE0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
TOTAL TRAINING FTE0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.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 ImplementationInitiation & PlanningDiscoveryConfigurationFunctional & Integration TestingUser Acceptance TestingEnd-User TrainingCutover Prep & Go-LivePost Go-Live Support & Stabilization
Month123456789101112131415161718192021
Project Leadership Team
Project ManagerFTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%
Executive SponsorFTE%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 LeadFTE%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 LeadFTE%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 LeadFTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%
Integration LeadFTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%
Others, as neededFTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%FTE%
TOTAL PROJECT LEADERSHIP FTE0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
TOTAL CORE TEAM FTE0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
TOTAL TECHNICAL TEAM FTE0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.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 .