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 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
Pricing_Worksheet.xlsx XLSX spreadsheet
Proposal_Response.pdf PDF
Sample_Purchase_Order.pdf 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 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 .