Amendment 0001 Attachment J-1 Pricing Matrix.xlsx

XLSX spreadsheet 24 KB Posted

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

About this file

This document contains a pricing matrix and labor categories for a solicitation seeking contractor support for the National Transit Database Program. The pricing matrix outlines firm fixed price and labor hour contract line item numbers for base, option year 1, and option year 2 for services including an annual module, monthly module, safety and security module, apportionment and non-Excel data products, annual review, reporting manuals and website content, program performance metrics reporting, and travel. Labor hour contract line items detail government estimated and contractor recommended hours and hourly rates for special projects, training provision, user acceptance testing and system requirements documentation, and written documents. The related federal contract opportunity provides additional details on solicitation number 69319522R000002 seeking proposals due May 17, 2022 to support budget and policy requirements for the National Transit Database Program through the Department of Transportation's Federal Transit Administration.

View the file

Other files

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

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, 0209Cost Reimbursable$42,014$42,644$43,284
Transition0013, 0213Firm Fixed Price$20,000$20,604.50
Staffing 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 Manager204
Subject Matter Expert204
Data Analyst (Sr)204
Data Analyst (Jr)407
Database Architect I204
Total1222
0011: Training Provision
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager13
Subject Matter Expert43
Trainer130
Total186
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 Manager130
Database Architect I611
Senior Database Developer611
Data Analyst (Jr)1018
Total2370
0014: Written Documents
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager67
Subject Matter Expert67
Data Analyst (Sr)134
Data Analyst (Jr)134
Editor407
Total811
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 Manager120
Database Architect I564
Senior Database Developer564
Data Analyst (Jr)940
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 Manager188
Subject Matter Expert188
Data Analyst (Sr)188
Data Analyst (Jr)376
Database Architect I188
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 Manager120
Database Architect I564
Senior Database Developer564
Data Analyst (Jr)940
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 .