Exhibit 2 - Bidder Service Level Staffing.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
RFP 88-26 The MBTA's Paratransit Dedicated Service Providers
Solicitation number
BD-26-1206-MBTA-MBTA-130845
Issued by
Massachusetts

About this file

This is a Bidder Service Level Staffing template document for the Massachusetts Bay Transportation Authority's (MBTA) Paratransit Dedicated Service Providers contract (RFP 88-26). The document serves as a standardized Excel form that bidders must complete separately for each of five proposed service levels (ranging from 20% to 60% capacity), with staffing level submissions required for a mobilization and transition period plus eleven contract years extending from FY 2027 through FY 2038. Bidders are instructed to provide full-time equivalent (FTE) counts for each position category across all contract years, ensuring consistency between this staffing form and their accompanying cost models. The template includes sections for key personnel positions (General Manager, Training Manager, Safety Manager, Operations Manager, Maintenance Manager, and five additional key personnel slots), up to thirteen other personnel positions, and variable personnel categories including van and sedan vehicle operators.

The document establishes target award point hours for each service level that increase annually throughout the contract term, ranging from 274,560 hours in FY 2028 for Service Level 1 (20%) to 1,094,520 hours in FY 2038 for Service Level 5 (60%). All staffing inputs must reflect annual twelve-month figures and correspond precisely to the FTE projections submitted in the bidder's cost model for the respective service level. Bidders are explicitly instructed to include only the requested information in the template, with no extraneous data permitted, and must complete separate tabs for each service level they propose to bid upon.

View the file

Other files

Show all 19

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

Instructions

INTRODUCTION
This Staffing Level Form should be filled out by Bidders for each Service Level proposed in the response.
GENERAL INFORMATION
Bidder shall complete this excel template separately for each Service Level bid upon.
Bidder shall use this form to provide its staffing levels (the number of FTEs for each position) at the Target Award Point for each year of the contract in the tabs provided below.
Bidder shall complete all tabs herein according to the instructions on this page.
All inputs should reflect ANNUAL numbers (12 months).
Bidder shall ensure the inputs provided in this form are fully consistent with the inputs provided in Bidder's Cost Model, for each Service Level Bidder is proposing.
Bidder shall NOT include ANY information other than that which is requested.
INSTRUCTIONS
In Rows 8 - 17, 21 - 33, and 37 - 38 of the "Staffing-Service Level" tabs, enter the number of FTEs proposed for each position for each year for the desired service level. The number of FTEs provided for each position in the "Staffing-Service Level" tabs should represent the staffing levels for the Bidder's entire operation at that Service Level. This number MUST EQUAL the number of FTEs proposed in the Bidder's Cost Model for the requisite Service Level. For example, if in the Bidder Cost Model, for FY28, Service Level 1, the Bidder estimates employing three (3) Supervisors, then Bidder must include a row for "Supervisors" with 3 FTEs in the "Staffing-Service Level 1" tab.

Staffing-Service Level 1 (20%)

Service Level 1 (20%)Base ContractOption Period 1Option Period 2
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
FY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Target Award Point Hours- 0274,560279,840288,120296,660305,560314,720324,160333,880343,900354,220364,840
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Key PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
General Manager
Training Manager
Safety Manager
Operations Manager
Maintenance Manager
Key Personnel 1
Key Personnel 2
Key Personnel 3
Key Personnel 4
Key Personnel 5
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Other PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Other Personnel 1
Other Personnel 2
Other Personnel 3
Other Personnel 4
Other Personnel 5
Other Personnel 6
Other Personnel 7
Other Personnel 8
Other Personnel 9
Other Personnel 10
Other Personnel 11
Other Personnel 12
Other Personnel 13
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Variable PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Van Vehicle Operator
Sedan Vehicle Operator

Staffing-Service Level 2 (30%)

Service Level 2 (30%)Base ContractOption Period 1Option Period 2
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
FY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Target Award Point Hours- 0411,840419,760432,180444,990458,340472,080486,240500,820515,850531,330547,260
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Key PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
General Manager
Training Manager
Safety Manager
Operations Manager
Maintenance Manager
Key Personnel 1
Key Personnel 2
Key Personnel 3
Key Personnel 4
Key Personnel 5
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Other PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Other Personnel 1
Other Personnel 2
Other Personnel 3
Other Personnel 4
Other Personnel 5
Other Personnel 6
Other Personnel 7
Other Personnel 8
Other Personnel 9
Other Personnel 10
Other Personnel 11
Other Personnel 12
Other Personnel 13
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Variable PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Van Vehicle Operator
Sedan Vehicle Operator

Staffing-Service Level 3 (40%)

Service Level 3 (40%)Base ContractOption Period 1Option Period 2
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
FY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Target Award Point Hours- 0549,120559,680576,240593,320611,120629,440648,320667,760687,800708,440729,680
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Key PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
General Manager
Training Manager
Safety Manager
Operations Manager
Maintenance Manager
Key Personnel 1
Key Personnel 2
Key Personnel 3
Key Personnel 4
Key Personnel 5
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Other PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Other Personnel 1
Other Personnel 2
Other Personnel 3
Other Personnel 4
Other Personnel 5
Other Personnel 6
Other Personnel 7
Other Personnel 8
Other Personnel 9
Other Personnel 10
Other Personnel 11
Other Personnel 12
Other Personnel 13
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Variable PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Van Vehicle Operator
Sedan Vehicle Operator

Staffing-Service Level 4 (50%)

Service Level 4 (50%)Base ContractOption Period 1Option Period 2
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
FY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Target Award Point Hours- 0686,400699,600720,300741,650763,900786,800810,400834,700859,750885,550912,100
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Key PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
General Manager
Training Manager
Safety Manager
Operations Manager
Maintenance Manager
Key Personnel 1
Key Personnel 2
Key Personnel 3
Key Personnel 4
Key Personnel 5
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Other PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Other Personnel 1
Other Personnel 2
Other Personnel 3
Other Personnel 4
Other Personnel 5
Other Personnel 6
Other Personnel 7
Other Personnel 8
Other Personnel 9
Other Personnel 10
Other Personnel 11
Other Personnel 12
Other Personnel 13
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Variable PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Van Vehicle Operator
Sedan Vehicle Operator

Staffing-Service Level 5 (60%)

Service Level 5 (60%)Base ContractOption Period 1Option Period 2
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
FY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Target Award Point Hours- 0823,680839,520864,360889,980916,680944,160972,4801,001,6401,031,7001,062,6601,094,520
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Key PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
General Manager
Training Manager
Safety Manager
Operations Manager
Maintenance Manager
Key Personnel 1
Key Personnel 2
Key Personnel 3
Key Personnel 4
Key Personnel 5
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Other PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Other Personnel 1
Other Personnel 2
Other Personnel 3
Other Personnel 4
Other Personnel 5
Other Personnel 6
Other Personnel 7
Other Personnel 8
Other Personnel 9
Other Personnel 10
Other Personnel 11
Other Personnel 12
Other Personnel 13
Mobilization & Transition PeriodYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
Variable PersonnelFY 2027FY 2028FY 2029FY 2030FY 2031FY 2032FY 2033FY 2034FY 2035FY 2036FY 2037FY 2038
Van Vehicle Operator
Sedan Vehicle Operator

File details come from the government source that posted it. Updated .