Staffing_Matrix_Worksheet.xlsx

The file is a Staffing Matrix Worksheet for a Utility Billing Software Replacement project for Seminole County Utilities Division, detailing a comprehensive Customer Information System (CIS) implementation staffing plan. The document provides an example timeline spanning 21 months, covering project stages including initiation, planning, discovery, configuration, testing, training, cutover, and post-go-live support. The matrix outlines two primary staffing sections: a Vendor Staffing Plan and a Utility Staffing Needs section, each featuring detailed role allocations across project management, consultant, technical, and training teams with flexible Full-Time Equivalent (FTE) percentage assignments.

The staffing worksheet complements the related state and local contract opportunity for replacing the utility billing software, which serves approximately 42,500 residential and 2,900 commercial water customers. The project requires integration with JD Edwards ERP and multiple existing systems, including AMI Headend, Asset Management, and Geospatial Information Systems. While the staffing matrix serves as an example template, it indicates the complexity of resource allocation needed for a comprehensive CIS replacement, with roles ranging from project managers and executive sponsors to technical leads, SME leads, testers, and training personnel. The document suggests vendors should be prepared to provide a similarly detailed staffing plan that demonstrates comprehensive coverage across all project implementation phases.