Attachment J-1 Pricing Matrix (1).xlsx

26 KB Posted

Attached to
Amendment 0001 - NTD Program Support
Solicitation number
69319522R000002
Issued by

About this file

Written by GovTribe AI ·

This document contains a pricing matrix and labor categories for a solicitation from the Department of Transportation Federal Transit Administration to provide contractor support to the National Transit Database Program. The firm fixed price and labor hour contract has a base year and two option years, with various contract line item numbers for annual modules, monthly modules, safety and security modules, apportionment and non-Excel data products, annual reviews, manuals and materials, performance reporting, travel, transition, staffing, special projects, training, testing, and written documents. Pricing and labor hours are provided for the base and option years. Responses to the solicitation are due May 17, 2022.

View the file

Other files

File Type Posted
Amendment 0001 Attachment J-1 Pricing Matrix.xlsx XLSX spreadsheet
Amendment 0001 - Attachment J-2 Past Performance Questionairre.docx DOCX document
Amendment 0001 Solicitation 69319522R000002- Questions received.xlsx XLSX spreadsheet
Amendment 0001 - Request for Proposal No. 69319522R000002.pdf PDF
69319522R000002 - SF30 Amendment 0001_Signed.pdf PDF
Attachment J-2 Past Performance Questionairre.docx DOCX document
Final RFP National Transit Database (NTD) - Program Support RFP.pdf PDF
69319522R000002 - SF33.pdf PDF
Attachment J.3 - Resume Template.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Sheet1

Price Matrix
Firm Fixed Price CLINBase YearOption Year 1Option Year 2
CLIN DescriptionCLINReimbursement TypeNot To Exceed AmountNot To Exceed AmountNot To Exceed Amount
NTD Assistance0001, 0101, 0201Firm Fixed Price
Annual Module0002, 0102, 0202Firm Fixed Price
Monthly Module0003, 0103, 0203Firm Fixed Price
Safety and Security Module0004, 0104, 0204Firm Fixed Price
Apportionment and Certain Non-Excel Data Products0005, 0105, 0205Firm Fixed Price
Annual Review0006, 0106, 0206Firm Fixed Price
Reporting Manuals, Training Materials and Website Content0007, 0107, 0207Firm Fixed Price
Program Performance Metrics Reporting0008, 0108, 0208Firm Fixed Price
Travel*0009, 0109, 0209Labor Hour$42,014$42,644$43,284
Transition0013, 0213Firm Fixed Price$20,000$20,604.50
Staffing/Work Plan0015, 0115, 0215Firm Fixed Price
Labor Hour CLINBase YearOption Year 1Option Year 2
CLIN DescriptionCLINReimbursement TypeTotal Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)
Special Projects0010, 0110, 0210Labor Hours (detail in table below)
Training Provision0011, 0111, 0211Labor Hours (detail in table below)
User Accpetance Testing and System Requirements Documentation0012, 0112, 0212Labor Hours (detail in table below)
Written Documents014, 014, 024Labor Hours (detail in table below)

Total Contract Cost (All CLINs) Base Year Option Year 1 Option Year 2

Base Year Labor Hour CLIN Detail
0010: Special Projects
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager188
Subject Matter Expert188
Data Analyst (Sr)188
Data Analyst (Jr)376
Database Architect I188
Total1128
0011: Training Provision
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager12
Subject Matter Expert40
Trainer120
Total172
0012: User Accpetance Testing and System Requirements Documentation
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager120
Database Architect I564
Senior Database Developer564
Data Analyst (Jr)940
Total2188

0013: Transition (11/2022 - 01/2023)

0014: Written Documents
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager62
Subject Matter Expert62
Data Analyst (Sr)124
Data Analyst (Jr)124
Editor376
Total748
Option Year 1 Labor Hour CLIN Detail
0110: Special Projects
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager188
Subject Matter Expert188
Data Analyst (Sr)188
Data Analyst (Jr)376
Database Architect I188
Total1128
0111: Training Provision
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager12
Subject Matter Expert40
Trainer120
Total172
0112: User Accpetance Testing and System Requirements Documentation
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager94
Senior Technician, IT564
Technician, IT940
Total2188
0114: Written Documents
Year
Labor CategoryGovt Estimated Hours
Project Manager62
Subject Matter Expert62
Data Analyst (Sr)124
Data Analyst (Jr)124
Editor376
Total748
Option Year 2 Labor Hour CLIN Detail
0210: Special Projects
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager32
Subject Matter Expert40
Data Analyst (Sr)150
Data Analyst (Jr)320
Quality Technician40
Total1128
0211: Training Provision
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager12
Subject Matter Expert40
Trainer120
Total172
0212: User Accpetance Testing and System Requirements Documentation
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager94
Senior Technician, IT564
Technician, IT940
Total2188
0214: Written Documents
Year
Labor CategoryGovt Estimated Hours
Project Manager62
Subject Matter Expert62
Data Analyst (Sr)124
Data Analyst (Jr)124
Editor376
Total748

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