Attachment_J-1_Pricing_Matrix.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- DTFT6017R00001
About this file
Attachment J-1 Pricing Matrix
View the file
Other files
| File | Type | Posted |
|---|---|---|
| National_Transit_Database_Validation_Services_Final.pptx | PPTX presentation | |
| Conference_Agenda.pdf | ||
| NTD_Preproposal_Conference_Transcript_-_DTFT6017R00001_Amendment_0001.pdf | ||
| NTD_RFP_DTFT6017R00001_Amendment_000001.pdf | ||
| QA_Document_Solicitation_No._DTFT6017R0001_Amendment_000001.xlsx | XLSX spreadsheet | |
| NTD_RFP_DTFT6017R00001.pdf | ||
| Attachment_J_2_-_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
Text version
Sheet1
| Attachment J-1 Pricing Matrix | |||||||||
| Firm Fixed Price CLINS | Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||
| Objective Description | CLIN Items | Reimbursement Type | Not To Exceed Amount | Not To Exceed Amount | Not To Exceed Amount | Not To Exceed Amount | Not To Exceed Amount | ||
| Help Desk & Technical Assistance | 0001, 0101, 0201, 0201,0401 | Firm Fixed Price | |||||||
| Annual Module Validation | 0002, 0102, 0202, 0302, 0402 | Firm Fixed Price | |||||||
| Monthly Module Validation and Data Products | 0003, 0103, 0203, 0303, 0403 | Firm Fixed Price | |||||||
| Safety Module Validation and Data Products | 0004, 0104, 0204, 0304, 0404 | Firm Fixed Price | |||||||
| Apportionment Files & Annual Data Products | 0005, 0105, 0205, 0305, 0405 | Firm Fixed Price | |||||||
| Annual Review | 0006, 0106, 0206, 0306, 0406 | Firm Fixed Price | |||||||
| Reporting Manuals, Training Materials and Website Content | 0003, 0103, 0203, 0303, 0403 | Firm Fixed Price | *Travel Details | ||||||
| Program Performance Metrics Reporting | 0007, 0107, 0208, 0308, 0408 | Firm Fixed Price | Annual NTD Courses (NTI Provided) | 2 analysts at 10 trainings/year ($1200/trip/analyst) | |||||
| Travel* (See details) | 0009, 0109, 0209, 0309, 0409 | Cost Reimbursable | $39,000 | $39,585 | $40,179 | $40,781 | $41,393 | Meetings with FTA or other Contractor Support Teams | 15 day trips ($200/trip) |
| Transition | 0013, 0413 | Firm Fixed Price | Ad hoc trainings and/or conference presentations | 10 trips @ $1200 each |
| Labor Hour CLINS | Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||
| Objective Description | CLIN Items | Reimbursement Type | 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) | Total Cost Not To Exceed (Contractor Recommended) |
| Special Projects | 0010, 0110, 0210, 0310, 0410 | Labor Hours (detail in table below) | |||||
| Training Provision | 0011, 0111, 0211, 0311, 0411 | Labor Hours (detail in table below) | |||||
| User Accpetance Testing and System Requirements Documentation | 0012, 0112, 0212, 0312, 0412 | Labor 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 Detail | Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 |
| Labor Category | Hourly Rate | Hourly Rate | Hourly Rate | Hourly Rate | Hourly 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 | |||||
| Year | Base Year | ||||
| Labor Categories | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 32 | ||||
| Subject Matter Expert* | 40 | ||||
| Data Analyst (Sr) | 150 | ||||
| Data Analyst (Jr) | 320 | ||||
| Quality Technician | 40 | ||||
| Total | 582 |
| 0011: Training Provision | |||||
| Year | Base Year | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 12 | ||||
| Subject Matter Expert | 40 | ||||
| Trainer | 120 | ||||
| Total | 172 |
| 0012: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Base Year | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 120 | ||||
| Senior Technician, IT | 940 | ||||
| Technician, IT | 1880 | ||||
| Total | 2940 |
| Option Year 1 Labor Hour Objectives Detail | |||||
| 0110: Special Projects | |||||
| Year | Option Year 1 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 32 | ||||
| Subject Matter Expert* | 40 | ||||
| Data Analyst (Sr) | 150 | ||||
| Data Analyst (Jr) | 320 | ||||
| Quality Technician | 40 | ||||
| Total | 582 |
| 0111: Training Provision | |||||
| Year | Option Year 1 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 12 | ||||
| Subject Matter Expert* | 40 | ||||
| Trainer | 120 | ||||
| Total | 172 |
| 0112: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Option Year 1 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 94 | ||||
| Senior Technician, IT | 564 | ||||
| Technician, IT | 940 | ||||
| Total | 1598 | ||||
| Option Year 2 Labor Hour Objectives Detail | |||||
| 0210: Special Projects | |||||
| Year | Option Year 2 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 32 | ||||
| Subject Matter Expert* | 40 | ||||
| Data Analyst (Sr) | 150 | ||||
| Data Analyst (Jr) | 320 | ||||
| Quality Technician | 40 | ||||
| Total | 582 |
| 0211: Training Provision | |||||
| Year | Option Year 2 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 12 | ||||
| Subject Matter Expert* | 40 | ||||
| Trainer | 120 | ||||
| Total | 172 |
| 0212: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Option Year 2 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 94 | ||||
| Senior Technician, IT | 564 | ||||
| Technician, IT | 940 | ||||
| Total | 1598 | ||||
| Option Year 3 Labor Hour Objectives Detail | |||||
| 0310: Special Projects | |||||
| Year | Option Year 3 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 32 | ||||
| Subject Matter Expert* | 40 | ||||
| Data Analyst (Sr) | 150 | ||||
| Data Analyst (Jr) | 320 | ||||
| Quality Technician | 40 | ||||
| Total | 582 |
| 0311: Training Provision | |||||
| Year | Option Year 3 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 12 | ||||
| Subject Matter Expert* | 40 | ||||
| Trainer | 120 | ||||
| Total Hours | 172 |
| 0312: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Option Year 3 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 94 | ||||
| Senior Technician, IT | 470 | ||||
| Technician, IT | 752 | ||||
| Total Hours | 1316 | ||||
| Option Year 4 Labor Hour Objectives Detail | |||||
| 0410: Special Projects | |||||
| Year | Option Year 4 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 32 | ||||
| Subject Matter Expert* | 40 | ||||
| Data Analyst (Sr) | 150 | ||||
| Data Analyst (Jr) | 320 | ||||
| Quality Technician | 40 | ||||
| Total Hours | 582 |
| 0411: Training Provision | |||||
| Year | Option Year 4 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager* | 12 | ||||
| Subject Matter Expert* | 40 | ||||
| Trainer | 120 | ||||
| Total | 172 |
| 0412: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Option Year 4 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 94 | ||||
| Senior Technician, IT | 470 | ||||
| Technician, IT | 752 | ||||
| Total | 1316 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .