Attachment_J-1_Pricing_Matrix.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
National Transit Database (NTD) - Validation Services
Solicitation number
DTFT6017R00001
Issued by

About this file

Attachment J-1 Pricing Matrix

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

Attachment J-1 Pricing Matrix
Firm Fixed Price CLINSBase YearOption Year 1Option Year 2Option Year 3Option Year 4
Objective DescriptionCLIN ItemsReimbursement TypeNot To Exceed AmountNot To Exceed AmountNot To Exceed AmountNot To Exceed AmountNot To Exceed Amount
Help Desk & Technical Assistance0001, 0101, 0201, 0201,0401Firm Fixed Price
Annual Module Validation0002, 0102, 0202, 0302, 0402Firm Fixed Price
Monthly Module Validation and Data Products0003, 0103, 0203, 0303, 0403Firm Fixed Price
Safety Module Validation and Data Products0004, 0104, 0204, 0304, 0404Firm Fixed Price
Apportionment Files & Annual Data Products0005, 0105, 0205, 0305, 0405Firm Fixed Price
Annual Review0006, 0106, 0206, 0306, 0406Firm Fixed Price
Reporting Manuals, Training Materials and Website Content0003, 0103, 0203, 0303, 0403Firm Fixed Price*Travel Details
Program Performance Metrics Reporting0007, 0107, 0208, 0308, 0408Firm Fixed PriceAnnual NTD Courses (NTI Provided)2 analysts at 10 trainings/year ($1200/trip/analyst)
Travel* (See details)0009, 0109, 0209, 0309, 0409Cost Reimbursable$39,000$39,585$40,179$40,781$41,393Meetings with FTA or other Contractor Support Teams15 day trips ($200/trip)
Transition0013, 0413Firm Fixed PriceAd hoc trainings and/or conference presentations10 trips @ $1200 each
Labor Hour CLINSBase YearOption Year 1Option Year 2Option Year 3Option Year 4
Objective DescriptionCLIN ItemsReimbursement TypeTotal Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)
Special Projects0010, 0110, 0210, 0310, 0410Labor Hours (detail in table below)
Training Provision0011, 0111, 0211, 0311, 0411Labor Hours (detail in table below)
User Accpetance Testing and System Requirements Documentation0012, 0112, 0212, 0312, 0412Labor Hours (detail in table below)

Total Contract Cost Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 Total Cost for all years

Labor Category Hourly Rates Detail
Labor Category DetailBase YearOption Year 1Option Year 2Option Year 3Option Year 4
Labor CategoryHourly RateHourly RateHourly RateHourly RateHourly Rate
Advisor
Chief QA Analyst
Data Analyst (Sr)
Data Analyst (Jr)
Editor
Project Manager
Quality Technician
Subject Matter Expert
Trainer
Senior Technician, IT
Technician, IT
Base Year Labor Hour Objectives Detail
0010: Special Projects
YearBase Year
Labor CategoriesGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*32
Subject Matter Expert*40
Data Analyst (Sr)150
Data Analyst (Jr)320
Quality Technician40
Total582
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
Senior Technician, IT940
Technician, IT1880
Total2940
Option Year 1 Labor Hour Objectives Detail
0110: Special Projects
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*32
Subject Matter Expert*40
Data Analyst (Sr)150
Data Analyst (Jr)320
Quality Technician40
Total582
0111: Training Provision
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*12
Subject Matter Expert*40
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 Manager*94
Senior Technician, IT564
Technician, IT940
Total1598
Option Year 2 Labor Hour Objectives Detail
0210: Special Projects
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*32
Subject Matter Expert*40
Data Analyst (Sr)150
Data Analyst (Jr)320
Quality Technician40
Total582
0211: Training Provision
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*12
Subject Matter Expert*40
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 Manager*94
Senior Technician, IT564
Technician, IT940
Total1598
Option Year 3 Labor Hour Objectives Detail
0310: Special Projects
YearOption Year 3
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*32
Subject Matter Expert*40
Data Analyst (Sr)150
Data Analyst (Jr)320
Quality Technician40
Total582
0311: Training Provision
YearOption Year 3
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*12
Subject Matter Expert*40
Trainer120
Total Hours172
0312: User Accpetance Testing and System Requirements Documentation
YearOption Year 3
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*94
Senior Technician, IT470
Technician, IT752
Total Hours1316
Option Year 4 Labor Hour Objectives Detail
0410: Special Projects
YearOption Year 4
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*32
Subject Matter Expert*40
Data Analyst (Sr)150
Data Analyst (Jr)320
Quality Technician40
Total Hours582
0411: Training Provision
YearOption Year 4
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager*12
Subject Matter Expert*40
Trainer120
Total172
0412: User Accpetance Testing and System Requirements Documentation
YearOption Year 4
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager94
Senior Technician, IT470
Technician, IT752
Total1316

Sheet2

Sheet3

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