RFP Appendix 5 - Personnel Projection Matrix.xlsx

This document is a Personnel Projection Matrix appendix for a Request for Proposal (RFP 3525R03) issued by the Pennsylvania Department of Transportation (PennDOT) for Mainframe Services. The matrix provides a template for offerors to project staffing levels across a ten-year service period, including a pre-commencement transition phase of up to twelve months. The staffing projections are required for the base term years one through five on a quarterly basis for years one and two, and on an annual basis for years three through five. Additionally, staffing projections must be provided for option years six through ten on an annual basis. The transition phase covers service provider full-time equivalents (FTEs) dedicated to transitioning services, while base services encompass FTEs allocated across multiple statement of work sections including common services, security services, mainframe operations, production control and scheduling, RACF services, technical support, database services, storage and backup management, middleware administration, IBM MQ physical support, and SNA and TCP/IP technical support.

The matrix establishes separate tracking for base services, optional services, and grand totals, with all FTEs including subcontractors required to be accounted for in the overall staffing plan. The template includes rows for Common Services (2 FTEs), Security Services (3 FTEs), Mainframe Operations, and nine additional mainframe-related service categories, as well as Managed Server Services, Service Management, Request for Solution support, Information Security Management, and Steady State Evolution and Optimization of Services. The document notes that the optional services section may be updated at a later stage of the procurement process. This staffing projection framework enables PennDOT to evaluate each offeror's proposed resource allocation and management strategy for delivering comprehensive mainframe hosting, management, and infrastructure support services for approximately 100 applications, including critical systems.